Feel free to get in touch,we value your feedback
MS Advanced Excel Training
The Microsoft Advanced Excel Training course, follow up from the beginners Excel 2010 course to extent possibilities into features and functions to this powerful spreadsheet software.
In this course, you will learn all possibilities in excel even faster than ever. You will learn to use maximum formula to make your spreadsheet faster and accurate like AVERAGE, SUMIF and many more. You will learn about performing LOOKUPS with HLOOKUPS and VLOOKUPS. This training also covers spark lines, and goes in depth with PIVOT Tables and charts. Please find the below detailed points will be covered under this training program.

  • Beginners Introductions: It Will Cover the Basic Detail about the MS Excel
  • Basic Formatting.
  • Absolute & Cell Referencing.
  • Conditional Formatting.
  • Naming Ranges & Cells.
  • Auto Filter & Advances Data Filtering.
  • Introduction to Pivot Table.
  • Advanced Pivot Table: Round 1
  • Advanced Pivot Table: Round 2
  • Creating & Designing Charts
  • Data Validation.
  • Formula Editing.
  • Five Powerful Excel Tips.
  • Error Checking & Data Monitoring.