Microsoft Excel Level 3 Gurus
March 9 - March 11£TBA
Imagine Training joins ECMS for a two part course in Microsoft Excel Level 3 Gurus, split between 2 half days. The first part of the course will be delivered on Tuesday 9th March 2021 13:15 – 16:30 and the second part on Thursday 11th March 2021 at 13:15 – 16:30.
With 10 years experience of successfully delivering online training, Imagine Training could help you learn essential skills for business. Trainers use the internet to deliver our training courses, direct to your desktop. Electronic training manuals help you retain what you learn and you can interact with us in the session and ask questions, watching the screen on your desk instead of the projector screen in your training room.
Learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. Covering Maths, Statistical, Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use Goal Seek and Solver and create your own macros!
What happens on this course
- Logical and statistical functions
- Financial and date functions
- Lookups and data tables
- Advanced data management
- Exporting and importing
- Analytical tools
- Macros and custom functions
You know you’re on your way to being an Excel Guru when you can create macros in Excel. We’ll even show you some of the behind the scenes VBA code and how to use functions within your macros.