Online Excel Training | Adavnced Excel - Mildain
Call Us Today! - +911204326873 | +91.8447121833|info@mildain.com
Sale!
  • online excel training
  • advanced-excel-online-training

Online Excel Training

100.00 90.00

4.5 out of 5 based on 4 customer ratings
(4 customer reviews)

Online Course on Advanced Excel Training

Course Contents: Ms-Excel & Advanced Excel

Course Benefit: You will learn how to Use Advance Features of Excel with LIVE PROJECTS

Duration: 16 Sessions [Every Session is of 1 hour]

Category:

Product Description

Online Excel Training

Have some experience with Excel and want to improve your skills? This Advanced Excel online course will help you learn intermediate and advanced Excel techniques.

In 16 or more engaging sessions you will learn how to find a value with VLOOKUP, create and format Pivot Tables, record basic Macros and more.

Whether you use Excel for work or study, these tutorials will help you on your journey to becoming an Excel Expert!

The course  from Mildain is Microsoft Excel 2010, 2013 and 2016 compliant. Videos are recorded in Microsoft Excel 2016 and 2013 for PC, and where the user interface is significantly different.

  • What are the requirements?

  • Microsoft Excel 2013, Windows 8, 7, Vista or XP

  • What am I going to get from this course?

  • Over 128 lectures and 10 hours of content!
  • To take your basic Excel skills to the next level
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment

  • What is the target audience?

  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title

Online Excel Training

  • Topics Covered

  • Advance Features of Ms-Excel. Advanced Excel course also enables the student to utilize, the advance
  • features taught in this course in an office environment with maximum efficiency.

  • BASIC Microsoft Excel:

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets

  • ADVANCED Excel Contents:

  • Formulas & Macros Formulas:
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas

  • DATA Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK
  • PIVOT Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

  • MACRO’S

  • Macros:
  • Definition and use , Record a macro
  • Assign a macro , Run a macro
  • Store a macro, Introduction to VBA Prog.

  • Develop the Worksheet:

  • Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance

  • Special Operations:

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Advance Excel Training With Live Projects

  • Graphic Operations:

  • Create charts , Enhance charts, Drawing toolbar features

Online Excel Training

  • Approx : 2 weeks

  • Duration: 16 Sessions(each sessions of 2hours)
 

Mildain Solutions

Plot No 17, C Block Market, Sec 36,
Noida (U.P.)-201301(India)
(+91) 1204326873
(+91) 7834800821
Contact Us

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Query

4 reviews for Online Excel Training

  1. 5 out of 5

    :

    Excellent learning happy with the course subject.

  2. 5 out of 5

    :

    very happy with the way trainer teach Pivot tables, charts and macros.

  3. 4 out of 5

    :

    Good training , Good trainer, good learning.

  4. 4 out of 5

    :

    It is a very good training, but indeed advance excel itself is very vast so i believe only 16 session are not sufficient, but happy with trainer.

Add a review

Your email address will not be published. Required fields are marked *

Grab Corporate/Online Training at best Cost.