The description of Excel 2016 Assistant
Looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.
Course 1: Mastering the fundamentals of Excel
How Excel works, how to navigate and design a spreadsheet.
The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.
How to create beautiful looking graphs and charts.
Introduction to PivotTables, Pivot Charts and Basic Macros.
Formatting, including; conditional, cell and number formatting.
Printing, publishing and sharing your work.
Course 2: Taking your learning to the next level with Advanced Excel Training:
Demystify the most complex business relevant areas of Excel.
To use advanced graphs and presentation techniques
How macros and VBA automate your spreadsheets and increase interactivity
How superpower functions can solve complex problems
To use PivotTables and PowerPivots to turn raw data into key decisions
Course 3: Mastering data analysis and data presentation through PivotTables.
An introduction to the world of PivotTables.
How to identify the best and worst data sets
How to filter, sort and group PivotTable data to maximise effectiveness
How to present your data clearly using PivotCharts and Conditional Formatting
How to create great looking management reports using a PivotTable
Courses 4: Maximise the effectiveness of your Business Analysis
How to turn buckets of data into sound business decisions
Financial modelling theory
Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
How to effectively and clearly present your findings to relevant stakeholders
Different forecasting techniques, including Moving Averages and Regression
This course will take you through a proven, process derived from years of experience financial and business modelling to the world’s top financial institutions.
The course is Excel 2010, 2013 and 2016 compliant. Videos are recorded in Excel 2016 and 2013 for PC, and where the user interface is significantly different, Excel 2010 videos are provided too.
Once Installed, our friendly support team and tutors are here to help with any course related inquiries.