Event Details
In this session, Microsoft Certified Trainer Alex Waterton will be providing a 4-day interactive training course aimed at providing staff with top tips and tricks to get the most out of Microsoft Excel. This course is free for up to two members of staff and will take place live alongside other attendees, allowing attendees to ask questions during the session.
Attendees will also be sent a pre-prepared workbook to follow along with during the session.
In this session, Alex will be taking a look at:
- Quick access toolbar
- Fill Series
- Useful formulas (Sum, Min, Max, Average, Count (A), HLOOKUP & VLOOKUP, IF and more!)
- Formating a table
- Sorting & Filtering
- Flash fill and lookups
- Charts & Pivot Tables
- …and much more!
Microsoft Excel Training
Date: 05th – 08th October 2021 (Tuesday – Friday)
Time: 11:00 am – 12:00 pm
Location: Online
AGENDA
- Quick Access Toolbar
- Fill Series – Standard
- Fill Series – Custom
- Styles & Formatting
- Inserting & Deleting Rows/Columns
- BODMAS
- Quick Analysis Tool – Totals
- Worksheets
- Formula – Sum
- Formula – Average
- Formula – Min
- Formula – Max
- Formula – Count(A)
- Formula – Percentages
- AutoSum
- ACS: Absolute Cell References
- Sorting Data – A – Z
- Sorting Data – Z – A
- Sorting Data – Custom List
- Format as Table
- Filtering – By Selection
- Filtering – By Checkbox
- Filtering – By Font/Icon/Cell Colour
- Table – Naming
- Table – Headings
- Table – Banding by Row/Column
- Table – Total Row
- Table – Adding Rows
- Conditional Formatting
- Flash Fill
- Data Validation
- IF Formula
- Formula – HLOOKUP & VLOOKUP
- Name Ranges – Formula
- Formula – XLOOKUP
- Charts – Basic
- Sub Totals
- Outlining
- PivotTable – Basics
- PivotChart – Basics
Additional Training Cost:
- Free for up to 2 members of staff.
- Additional staff will be charged £80 per person for the 4-day training course.
- For existing ADM clients, please contact your account manager for further information.
- If you would like to provide this training service to your customers, or are interested in personalised and additional large scale staff training, please contact: kailas.bryant@adm-computing.co.uk
Please book your place using the form provided or contact Penelope Mak via her DDI: 01227 913311 or email Penelope.Mak@adm-computing.co.uk.
Speaker
Alex Waterton – Microsoft Certified Trainer | Founder of F-Keys Microsoft Training and Examination Centre – Established in 1998.
Alex has an endless passion for teaching and helping others to gain added skills and confidence with Microsoft 365 applications. These added skills mean that users are more effective and efficient in the workplace, able to accomplish tasks faster and easier on a day-to-day basis.
Microsoft Excel Training
Date: 05th – 08th October 2021 (Tuesday – Friday)
Time: 11:00 am – 12:00 pm
Location: Online