Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
Learn how to make a genuine difference in your life by taking our popular Advanced Excel Course (Formula, VLOOKUP & Power Query) Course. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Advanced Excel Course (Formula, VLOOKUP & Power Query) to a whole new level and quickly reap the rewards of your study in the field you have chosen.
We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.
Please note that Advanced Excel Course (Formula, VLOOKUP & Power Query) provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.
By completing the training in Advanced Excel Course (Formula, VLOOKUP & Power Query), you will be able to significantly demonstrate your acquired abilities and knowledge of Advanced Excel Course (Formula, VLOOKUP & Power Query). This can give you an advantage in career progression, job applications, and personal mastery in this area.
This course is designed to provide an introduction to Advanced Excel Course (Formula, VLOOKUP & Power Query) and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.
Once you have completed all the modules in the Advanced Excel Course (Formula, VLOOKUP & Power Query) course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.
Show off Your New Skills with a Certification of Completion
The learners have to successfully complete the assessment of this Advanced Excel Course (Formula, VLOOKUP & Power Query) course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! | |||
How to Get the most of the course | 00:01:00 | ||
Text formulas in Excel | 00:08:00 | ||
Text Formulas Exercise | 00:01:00 | ||
Text Formulas Exercise (answers) | 00:01:00 | ||
Mathematical Formulas In Excel | 00:04:00 | ||
Mathematical Formulas Exercise (answers) | 00:01:00 | ||
Mathematical Formulas Exercise (answers) | 00:01:00 | ||
Date and Time Formulas In Excel | 00:06:00 | ||
Date and Time Exercise Formulas (answers) | 00:01:00 | ||
Date and Time Exercise Formulas (answers) | 00:01:00 | ||
Logic Formulas In Excel | 00:12:00 | ||
Logic Formula Exercise | 00:01:00 | ||
Logic Formula Exercise (answers) | 00:01:00 | ||
Financial Formula In Excel | 00:06:00 | ||
Financial Formula Exercise | 00:01:00 | ||
Financial Formula Exercise (answers) | 00:02:00 | ||
Informational Formula In Excel | 00:04:00 | ||
Informational Formula Exercise | 00:01:00 | ||
Informational Formula Exercise (answers) | 00:01:00 | ||
VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! | |||
Menu Example with Excel Vlookup | 00:08:00 | ||
Wildcard Search with Excel Vlookup | 00:09:00 | ||
Looking to the Left with Excel Vlookup | 00:17:00 | ||
2-Way Lookup | 00:14:00 | ||
Comparing Lists with Excel Vlookup | 00:03:00 | ||
Microsoft Excel Vlookup Tips and Tricks | 00:14:00 | ||
Microsoft Excel: Master Power Query in 120 Minutes! | |||
Power Query Intro and Excel version | 00:03:00 | ||
Excel Power Query – Introduction | 00:03:00 | ||
Enabling M in Power Query | 00:02:00 | ||
Transform Data – Trim in Excel Power Query | 00:05:00 | ||
Transform Data – Format Dates and Values in Excel Power Query | 00:02:00 | ||
Simple Expressions – Nested Expressions | 00:03:00 | ||
Transform Data – Parsing URLs in Excel Power Query | 00:05:00 | ||
Variables | 00:07:00 | ||
Microsoft Excel Keyboard Shortcuts | |||
Formatting Excel Keyboard Shortcuts | 00:02:00 | ||
Table Excel Keyboard Shortcuts | 00:02:00 | ||
Editing Excel Keyboard Shortcuts | 00:05:00 | ||
Formula Excel Keyboard Shortcuts | 00:03:00 | ||
Workbook Excel Keyboard Shortcuts | 00:02:00 | ||
Handy Excel Shortcuts Keyboard Shortcuts | 00:05:00 | ||
Assignment | |||
Assignment – Advanced Excel Course (Formula, VLOOKUP & Power Query) | 00:00:00 | ||
Order Your Certificate | |||
Order your Certificate. | 00:00:00 |