Weekend Excel Training
Why Should I Attend Weekend Excel Training?
If you want to improve your Excel skills but have limited availability, then Weekend Excel training is just for you!
With our weekend 1 day Excel courses, you can still attend hands-on Excel training without having to sacrifice time off work. You will receive the same high standard of training as our conventional courses however this option means that you don’t have to use any of your precious annual leave.
Contact us Today
Weekend Excel Open Courses
Microsoft Excel L1 Course Outline
- Shortcuts and important fundamentals
- Fast & efficient ways of navigating, selecting and entering data
- Creating basic formulas for calculations – percentages, averages, SUM, etc…
- Relative & Absolute cell addressing (use of $ within formula’s)
- Arranging data & creating tables from scratch – best practices
- Sorting and Filtering Data
- Applying automatic formatting down columns with Conditional Formatting
- Page Layout Settings for PDF conversion and Printing
- Creating Charts and graphs
Prerequisites: Computer and mouse literate
Microsoft Excel L2 Course Outline
- Working with Dates and Time – e.g. ageing and forecast
- Making decisions with the IF Function
- Adding, Counting and Averaging subsets of data with SUMIFS, AVERAGEIFS and COUNTIFS
- Finding & copying data with XLOOKUP (VLOOKUP for Excel 2016 and earlier versions)
- Creating custom drop-down lists with Data Validation
- Applying Automatic formatting with formulas – Conditional Formatting
- Understanding Dynamic Arrays and the #SPILL error
- Analysing data with Pivot Tables
Prerequisites: Confident/experienced writing own basic formulas e.g. SUM, AVERAGE, COUNT, percentages, etc. Ideally experienced/confident in using ‘$’ to lock cells within formulas.
Timings: 09:30 – 16:30
Microsoft Excel L3 Course Outline
- Making decisions through Nested Logical Functions – IF, AND, OR
- Finding and copying data with Nested XLOOKUP functions – sophisticated Lookup techniques (VLOOKUP for Excel 2016 and earlier versions)
- XLOOKUP extended capabilities – e.g. wild card LOOKUP & returning multiple columns (or INDEX and MATCH for Excel 2016 and earlier versions)
- Finding and copying multiple records using FILTER function (** NEW **)
- Introduction Automating repetitive spreadsheet tasks through Macros (VBA)
Prerequisites: experienced/confident writing own Logical functions (IF, SUMIFs, COUNTIFs, AVERAGEIFs) and XLOOKUP formulas from scratch
Timings: 09:30 – 16:30
Please select one of the below options if your desired course is available
BOOK IN PERSON COURSE NOW BOOK VIRTUAL COURSE NOW
Alternatively, if you can’t see a suitable date for a weekend training course please e-mail enquiries@weareexcel.co.uk or call 020 7183 7740 for further availability.
Your trainer
Our Lead trainer “Chris” delivers our weekend Excel training. Chris is accredited by The Learning & Performance Institute. The institute’s TPMA certificate is one of only nine certificates accepted globally by Microsoft. Microsoft trainers, anywhere in the world, who hold the TPMA certificate can demonstrate that they have reached a level of instructional delivery that meets or exceeds the high standard demanded by the Microsoft Certified Trainer (MCT) programme.
Click here to read more on TPMA accredited Trainers
Looking for private One to One Training? Click here.
