Blended Course

Advanced Excel (Nov 2019) (AE1119)


Description

Do you know how to create basic spreadsheets, but wish they'd do more of the work for you? Do you wish there was a better way to analyse your spreadsheets or turn them into useful reports quicker? This course is for you!

After this course, you'll be able to get Excel to analyse data for you, set up reports in only a few clicks and create buttons that do exactly what you want them to!

Over four weeks, learn how to use the advanced features of Excel without leaving your desk. You'll become confident when working with Excel to create spreadsheets that do the work for you and learn tips and tricks to save time. This four week course allows you to learn entirely online through virtual workshops and activities so you can implement what you learn in your own workplace each week.

Virtual Workshop Dates (Mondays):
* 25th November
* 2nd December
* 9th December
* 16th December
All 1pm - 2pm UK Time

***Special Early Bird Rate of £199 if booked before 15th Nov*** (rather than £250)

Content
  • Welcome
  • Week 1 - Analysing Spreadsheets
  • Workbook 1
  • Before the virtual workshop
  • Virtual Workshop - Analysing Spreadsheets
  • Activity 1 - Sort, Filter, Conditional Formatting
  • Activity 2 - Goal Seek, Scenarios, Pivot Tables
  • Activity 3 - Practice Analysing Spreadsheets
  • Week 2 - Working with formulas
  • Workbook 2
  • Working with formulas
  • Virtual Workshop - Formulas
  • Activity 1 - vLookup, If, Nesting
  • Activity 2 - hLookup, SumIf
  • Activity 3 - Practice Working with Formulas
  • week 3 - creating new spreadsheets
  • Workbook 3
  • Virtual Workshop - Creating New Spreadsheets
  • Activity 1 - Templates and Protecting Data
  • Activity 2 - Consolidation and Importing / Exporting
  • Activity 3 - Practice Creating New Spreadsheets
  • week 4 - automating tasks
  • Workbook 4
  • Virtual Workshop - Automating Tasks
  • Activity 1 - Creating and Editing a Macro
  • Activity 2 - Troubleshooting and Proofing
  • Activity 3 - Practice Automating Tasks
  • Feedback
  • Feedback
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever