Excel Webinar Schedule

Upskill yourself from home in 4 Weeks

Each Excel Live Webinar runs at 11.30am

All that’s needed to join is an internet connection.

Monday  – Accelerated start – touring Excel, shortcuts and using Quick Access Toolbar, Working with Sheets

Tuesday – Professional Formatting tools using Excel

Wednesday – Spreadsheet fundamentals and Functions in Excel 

Thursday – Get your dates right. Working with & Formatting Dates and Date Functions

Friday – Pretty printing master printing Options & Layout

Monday – Great ways to Sort, Filter and Subtotal Lists

Tuesday – Saving time copying functions – Named Ranges/Name Manager

Wednesday – Magic with Conditional Formatting

Thursday – Getting tough with Data Validation and Protecting Worksheets and Workbooks

Friday – Working with Words. Text to Column, Text Functions and Flash Fill

 

Monday – Working with Tables and Formulas

Tuesday – To be or not to be? IF and Nested IF

Wednesday – Power Countif(s), Sumif(s), Averageif(s), Maxifs and Minifs

Thursday – Going vertical with Lookups

Friday – Finding what you want with Index and Match

Monday – Twisting data with Pivot Tables, Pivot Charts and Slicers

Tuesday – Getting graphical with Charts and Sparklines

Wednesday – Robotic power with basic Macros

Thursday – Swapping tables with Named ranges and Offset Function

Friday – Super powerful New excel functions (2019/365)