Advanced MS Excel 2016

BI & Visualization

Course Description

Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Logical functions, Formula Auditing, Data validation, What-if Analysis, Pivot tables, Pivot charts, Advanced Filters, Sparklines, Macros, and Data Security.

Excel has become one of the prerequisites for almost all jobs in the analytics and consulting sector. Through this course, you’ll learn the advanced functions that are used by analysts on a day to day basis. You’ll also get accustomed to even more advanced stages of excel use like Macros which further come handy.

4 Days

  • Learn new features in MS Excel 2016 and implement advanced excel concepts
  • Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
  • Apply advanced functions and formulas to enhance Excel’s productivity
  • Perform What-if analysis command to experiment with data
  • Apply data validation to restrict data input
  • Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
  • Use Macros to automate routine tasks in Excel
  • Integrate passwords to protect Excel files
  • Use Excel shortcuts wherever applicable
  • Data Analyst
  • Financial Analyst
  • Advanced Excel User
  • Fresher seeking jobs in Analytics/Consulting job streams

There are no prerequisites for this course. However, a basic understanding of Microsoft Excel will be supportive.

  • Overview of Advanced MS Excel 2016
  • Custom and Conditional Formatting
  • Advance Functions and Formulas
  • Advanced Data Tools
  • Data Analysis
  • Introduction to Macros
  • Data Security
  • Working with Advanced Excel 2016
Close Menu