The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates.
This course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.
Please Note: This course contains a taster session on PivotTables. Detailed training on this subject is covered in our Microsoft Excel 2013 Advanced course.
This course is aimed at end users who have taken the following QA course or have equivalent knowledge: Microsoft Excel 2013 Introduction.
Unsure which Excel course level will be better for you? Click here to take our free online assessment and find out!
Our new Microsoft Excel 2013 curriculum consists of QA Authored courses which allow adequate time to cover the technical subject matter in sufficient depth to ensure a full understanding. The courseware for the new Microsoft Excel 2013 courses has been written by QA’s Microsoft Excel experts. It covers the key topics required by users of this software, including the brand new features of this version, with lots of in-depth explanations, step by step instructions, key questions and group and individual activities
At the end of this course you will be able to:
Lesson 1: Calculating With Advanced Formulas
Lesson 2: Auditing a Worksheet
Lesson 3: Mastering Excel Tables
Lesson 4: Organising Worksheet Data
Lesson 5: Charts
Lesson 6: Working with Templates
Lesson 7: Analysing Selected Data
Lesson 8: Apply Conditional Formatting
Lesson 9: An Introduction to Pivot Tables
Lesson 10: Appendix – Inserting Illustrations
Lesson 11: Appendix – Excel Options