Course description
Microsoft Excel Level 3
Level Up Your Excel Skills: Microsoft Excel Level 3: Gurus
Master advanced techniques in this TWO HALF DAY Microsoft Excel Level 3 course. Become a Microsoft Excel power user and transform your spreadsheets.
- Conquer "What If" Scenarios: Master logical functions (IF, AND, OR, NOT) to automate complex decisions within your Level 3 Excel skills.
- Unlock the Geek Within (Made Easy!): Demystify the 5 most popular Math & Statistical Functions in Microsoft Excel Level 3.
- Advanced Formula Powerhouse: Craft powerful formulas in Excel Level 3 to automate tasks, crunch data, and boost efficiency.
Excel Like a Pro:
- Build robust, automated spreadsheets in Microsoft Excel Level 3.
- Extract data insights with powerful analysis techniques.
- Stand Out From the Crowd: Impress with your advanced Microsoft Excel Level 3 expertise.
Don't be average! This Microsoft Excel Level 3 course unlocks your Microsoft Excel potential.
Upcoming start dates
Suitability - Who should attend?
Who is this for?
This TWO HALF DAY course is specifically designed for office workers, managers, accountants and data analysts. Delegates on this course should have existing Intermediate knowledge of Excel, and we will turn you into an Excel expert.
Training Course Content
- Become an Excel Expert using Logical Functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions but in a way that makes it easy to understand and conquer!
- Want to speed up data entry on your spreadsheets? Then validating cell entries is one lesson you won’t want to miss. Build Drop Down lists, data entry conditions like ‘not before date’ and fix how many characters can be input. A sure-fire way to cut down data entry errors!
- If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course!
- Now we’re uncovering some of Excel’s best kept secrets such as how you can use Goal Seek and Solver to find the answer to your business questions! Take a peek at the Analysis ToolPak and see how you can easily create ‘Scenarios’ to show different ‘What if’ situations and choose the best options.
- Need to know the fundamentals of VLOOKUPs? Take a first peek at the new replacement for VLOOKUPS XLOOKUP! We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover creating Data Tables.
- 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.
- Need to be a whizz at Exporting and Importing files? If you work with external databases and want to manipulate that data in Excel this lesson is for you!
- Hands-on exercises and demonstrations help you gain in-class practice creating engagement programs. Take-home your very own Microsoft Certified Manual to help extend your learning beyond the class as you apply what you have learned back in your job.
Reviews
Average rating 4.9
Macros, Spill formulas and Data Validation
Request info
Imagine Training
Welcome to Imagine Training, empowering businesses through comprehensive Microsoft 365 training with a particular emphasis on Excel Training. As we navigate through the rapidly evolving digital age, our mission is to ensure your organisation not only keeps pace but excels....
XLookups and data validation