Analytics

Advanced Excel Course

Learn Advanced Formulas and Function Step - by - Step.

What will you get from this course

Girl Using Laptop
  • Online Live Class from Expert Faculty.

  • 10 Days of Training 1 Hour a day.

  • Course Completion Certificate.

  • 239 Shortcut Key E Book for Free of Cost.

What this Course offer

Day 1 - 2
  • Overview of Excel/Spreadsheet.

  • How to Navigate in Excel.

  • Formatting Tricks.

Day 3 - 4
  • Number Formatting.

  • Conditional Formatting.

  • Copy, Paste and Paste Special.

Day 5 - 6
  • Format as Table.

  • Cell Styles.

  • Data Sorting & Advance Filter.

Day 7 - 8
  • Basic Formulas.

  • Fill Series.

  • Go to Special.

Day 9 - 10
  • Advanced Function like Sumif, Countif, AvgIf etc.

  • Pivot Table.

  • Pivot Charts.

  • Dashboard.

Day 11 - 12
  • Vlookup.

  • Hlookup.

  • Index Match.

Day 13 - 14
  • Text Function.

  • Date & Time Function.

  • Text to column.

  • Flash fill.

Day 15 - 16
  • Data Validation.

  • Goal Seek.

  • Scenario Manager.

Day 17 - 18
  • Financial Functions.

  • Consolidation.

  • Subtotal.

Day 19 - 20
  • Printing Tricks.

  • Basic Macros.

  • Protect Sheet

  • Page View, Freeze Panes, Split, New window

  • And Remaining Points

Trainer

Arun Rajput

Certified Microsoft Excel Expert.

He has having more than 10 Years of Teaching Experience.

Sample Videos of our Online session. Simple to understand.

We teach in Marathi and Hindi Language.