This course is designed to get all users up to speed on the many aspects of Excel and familiarise them with its more sophisticated functions. We'll go through how to construct and apply complex formulae, how to analyze data, how to organize worksheet data with tables, how to visualize data with charts, how to insert graphics, and how to improve spreadsheets. 

Course Content 

•  Creating Advanced Formulas 

•  Analysing Data with Logical and Lookup Functions 

•  Organising and Analysing Datasets and Tables 

•  Visualizing Data with Charts 

•  Analysing Data with PivotTables, Slicers, and Pivot-Charts 

•  Inserting Graphics 

•  Enhancing Workbooks