Fully master the most popular spreadsheet tool on the market, Microsoft Excel. Your instructor is an Excel wiz who will guide you through everything step-by-step, from beginner to advanced levels and beyond!
Throughout the three day course (1 session per week), you will learn the Excel skills that will make your daily tasks a breeze and more importantly(!) impress your co-workers. We’ll start with the basics, building a solid foundation before progressing onto the more complicated stuff.
Here is a glance at some of the great things you’ll pick up from attending this course:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day to day Excel tasks by mastering the power of Macros and VBA