Data Analysis in Excel
Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.
In this short, eleven module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, 'Excel Data Analysis' will set you up with a great foundation upon which to build further skills.
In this course you will learn:
- Clean up data ready for analysis
- Create PivotTables and PivotCharts
- Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
- Make decisions using IF Statements
- Highlight information using Conditional Formatting and Rules
- Build a basic Interactive Dashboard
+ SECTION 1 | INTRODUCTION - 1 MODULE
Unit 1 | Getting Started
+ SECTION 2 | BUILDING A GOOD FOUNDATION - 1 MODULE
Unit 2 | Preparing Data for Analysis
+ SECTION 3 | ANALYSING LARGE DATASETS - 4 MODULES
Unit 3 | PivotTables
1. Building a PivotTable
2. Managing PivotTables
3. Summarising Data and Using Calculated Fields
4. Creating PivotCharts
+ SECTION 4 | LOOKING UP INFORMATION - 2 MODULE
Unit 4 | Lookup Functions
1. Looking up Information with VLOOKUP and HLOOKUP
2. Working with INDEX and MATCH
+ SECTION 5 | DECISION MAKING - 1 MODULE
Unit 5 | Logical Functions
+ SECTION 6 | PRESENTING DATA - 1 MODULE
Unit 6 | Conditional Formatting
+ SECTION 7 | CREATING AN IMPACT - 1 MODULE
Unit 7 | Building an Interactive Dashboard
About the author
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.