Requirements

  • Basic/ Minimun knowledge of Advance Excel
  • Basic understanding of process flow
  • Pen and paper for taking notes
  • No previous experience required
  • Maintain 90% attendance in class for infection of the curriculum

Description

Get the most out of Microsoft Excel faster and easier than ever and be the Excel Guru of your work place. In this Course, maximize your productivity with Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including PivotTables, PowerPivot, Sparkline, Goal Seek, Conditional Formatting, Report Automation, Subtotals, Tips and Tricks and many more! Get more things done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more!

The course is separated into three Difficulties level- Beginner, Intermediate and Advance. As the course progresses you will be introduced with Powerful Techniques that will take you from Novice to Professional.

How participants will benefit after the course:

It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excel's built-in utilities. In this course we will explore those uncovered areas in such fine manner that attendees can readily imply them in their regular work just after attending the program.

The main formulas & functions covered in this training course include:
● INDEX and MATCH
● IF with AND / OR
● OFFSET combined with other functions
● CHOOSE for creating scenarios
● INDIRECT combined with other functions
● XNPV and XIRR
● CELL, COUNTA and MID functions combined together
● PMT, IPMT and principal payment calculations

The main types of data analysis in this advanced tutorial include:
● Data tables
● Pivot tables
● Column and line charts
● Stacked column charts
● Waterfall charts
● Gauge charts

WHO CAN JOIN:

  • If you are looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
  • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
  • Beginner, Intermediate and Advanced users who want to be proficient in Excel.
  • Anyone new to Microsoft Excel or upgrading from a previous versions of Excel.