Blended Course

Advanced Excel (Feb 2020) (AE0220)


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:
* 13th February
* 18th February
* 27th February
* 5th March
All 11am - 12pm UK Time
Content
  • Section 1 34d
  • Welcome
  • Week 1 - Analysing Spreadsheets 68d
  • Workbook 1
  • Before the virtual workshop
  • Virtual Workshop - Analysing Spreadsheets
  • Replay - week 1 Virtual Workshop
  • Activity 1 - Sort, Filter, Conditional Formatting
  • Activity 2 - Goal Seek, Scenarios, Pivot Tables
  • Activity 3 - Practice Analysing Spreadsheets
  • Week 2 - Working with formulas 102d
  • 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 136d
  • 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 170d
  • Workbook 4
  • Virtual Workshop - Automating Tasks
  • Activity 1 - Creating and Editing a Macro
  • Activity 2 - Troubleshooting and Proofing
  • Activity 3 - Practice Automating Tasks
  • Feedback 204d
  • Feedback
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever