Excel 2016 Assistant

MS Excel的 - 在1天学习全课程：

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.