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)