Microsoft Excel – Advanced: Masterclass
Microsoft Excel – Advanced: Masterclass
13th March 2020 @ 9:30 am - 5:00 pm
One event on 10th April 2020 at 9:30am
One event on 15th May 2020 at 9:30am
One event on 11th October 2019 at 9:30am
One event on 8th November 2019 at 9:30am
One event on 13th December 2019 at 9:30am
One event on 14th February 2020 at 9:30am
One event on 13th March 2020 at 9:30am
Event Navigation
Member price – £120.00 + VAT
Non-member price – £160.00 + VAT
Duration – 1 Day
The previous stages of Excel introduce several very useful functions and tools, as introduced in the intermediate course; one single function cannot always provide you with a solution. The master class focuses on how to combine the features, functions and tools of Excel together. This course is not just about integration, but several new functions will also be introduced such as Financial, Text & Date formulas. This will give the user confidence to master any formula. In addition this course also introduces Macros VBA.
- Refresher Workshop
- Date Formulas – Day / Month / Year / WeekDay / WeekNum
- Combined Advanced Formulas – IF / AND / OR / V & H Lookup Combined
- Problem Solving Exercises – The Solver / Utilising / Complex Formulas
- Introduction to Macros VBA – Recording, Editing, Running Macros / Understanding VBA / Rem
- Statements
- Advanced Customising Of Excel – Toolbars / Menus
- Advanced Formatting – Templates / Consolidating Data / Track Changes / Auditing
- Forms / Dropdown Lists / Tick Boxes / Spinners
- Date Formulas – Day / Month / Year / Weekday / WeekNum
- Combined Date Formulas: =IF(WeekDay(A1,2)<=5,”Work”,”Play”)
- Advanced Combined Text Formulas – Len / Left / Right / Mid / Find / Proper / Upper / Lower
- Problem Solving Workshops
- Question and Answers