BHT’s half-day Advanced Excel course is for people who are very familiar with using Excel and creating formulas, or using Excel to manage a budget.
Learn how to set up complex spreadsheets and edit existing ones, create questionnaires and limit question choices, and evaluate or analyse data.
- Formulas and Functions to analyse information
- Data validation (selecting options from a list)
- VLookup and HLookup to compare tables
- Pivot tables and Pivot Charts to analyse information
- Creating Automatic SubTotals
You will receive an Advanced Excel workbook.
Course level: Advanced
Without wanting to sound like a geek, I absolutely loved this course. I know I am going to use what I have learned on a regular basis and it will help me to analyse data for my colleagues.