- Self-Paced Online learning
- 24/7 Online Support
- 14 Days Money Back Guarantee
- Fully Accredited Courses
Advanced Excel Course (Formula, VLOOKUP & Power Query)
Overview
Messy spreadsheets slow reports, hide errors and make everyday business decisions harder. With UK workplace digital skills remaining a major concern, stronger Excel ability can be a valuable career asset for learners who handle data, reports, records or business information.
This Advanced Excel Course builds confidence in Microsoft Excel formulas, VLOOKUP, Power Query, M Language, keyboard shortcuts, data cleaning, list comparison and spreadsheet analysis. Learners explore text, maths, date, logic, financial and information formulas, plus left lookups, two-way lookups, folder data extraction, trimming, transforming and merging data. Ideal for admin, finance, HR, operations, reporting and data learners, it supports UK career goals in data analysis, office administration, finance support, business analysis and reporting. Enrol today and improve Excel efficiency online with confidence
Key Benefits Included
► Accredited by CPD
► Endorsed by QLS (Quality Licence Scheme)
► Instant Access
► 24/7 Learning Assistance
► Self-paced learning and laptop, tablet, smartphone-friendly
► Fully online, interactive course with audio voiceover
► Developed by qualified professionals in the field
Learning Outcomes
This Advanced Excel Course helps learners improve spreadsheet, formula, VLOOKUP, Power Query, data cleaning, and reporting skills for admin, finance, HR, business, and operations roles.
► Use text formulas to clean and organise spreadsheet data
► Apply mathematical formulas for workplace calculations
► Work with date and time formulas in reports
► Use logic formulas to test conditions and return results
► Apply financial formulas for business and finance tasks
► Use information formulas to check and review data
Who is This Course For?
This Advanced Excel Course online is ideal for learners who want to improve Excel skills for reports, calculations, records, dashboards, and workplace data preparation.
► Admin professionals working with spreadsheets and reports
► Finance learners using formulas, VLOOKUP and data checks
► HR staff managing staff records and spreadsheet tasks
► Operations learners tracking performance and workflow data
► Business learners preparing reports and analysis files
► Use information formulas to check and review data
Certification
CPD Certification
After successfully completing the assessment of this course, you can apply for the CPD accredited certificates.
PDF certificate: £9.99
Hardcopy certificate: £15.99
Endorsed Certificate of Achievement from the Quality Licence Scheme
Upon successful completion of the 2D Animation: Ultimate Guide to Adobe Animate course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of —
► 135 GBP within UK
► 145 GBP for International Delivery — Postal Fees Included
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses
Career Opportunities
► Data Analyst: £28,000–£65,000 per year
► Reporting Analyst: £28,000–£45,000 per year
► Business Analyst: £23,000–£55,000 per year
► Finance Officer: £19,500–£34,000 per year
► Finance Assistant: £21,000–£32,000 per yea
Course Curriculum
The course covers a wide range of essential topics, including:
► How to Get the most of the course
► Text formulas in Excel
► Text Formulas Exercise
► Text Formulas Exercise (answers)
► Mathematical Formulas In Excel
► Menu Example with Excel Vlookup
► Wildcard Search with Excel Vlookup
► Looking to the Left with Excel Vlookup
► 2-Way Lookup
► Comparing Lists with Excel Vlookup
► Power Query Intro and Excel version
► Excel Power Query – Introduction
► Enabling M in Power Query
► Transform Data – Trim in Excel Power Query
► Transform Data – Format Dates and Values in Excel Power Query
► Formatting Excel Keyboard Shortcuts
► Table Excel Keyboard Shortcuts
► Editing Excel Keyboard Shortcuts
► Formula Excel Keyboard Shortcuts
► Workbook Excel Keyboard Shortcuts
Excellent
4.7 Average - 9 Reviews
Course Curriculum
| 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 | 00:01:00 | ||
| Mathematical Formulas Exercise (answers) | 00:01:00 | ||
| Date and Time Formulas In Excel | 00:06:00 | ||
| Date and Time Formulas Exercise | 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 | 00:08:00 | ||
| Simple Expressions – Nested Expressions | 00:03:00 | ||
| Transform Data – Parsing URLs in Excel Power Query | 00:05:00 | ||
| Variables | 00:08: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) | 1 week, 4 days | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
The Advanced Excel Course is an online training programme covering Excel formulas, VLOOKUP, Power Query, M Language, shortcuts, data cleaning, reporting, and spreadsheet analysis for learners who want stronger workplace Excel confidence.
Yes, this course is suitable for learners who know basic Excel and want to progress into more confident spreadsheet use. It explains formulas, lookup functions, Power Query, shortcuts, and data-handling techniques in a structured way.
You will learn key Excel formulas, VLOOKUP techniques, Power Query basics, M Language concepts, keyboard shortcuts, data cleaning, list comparison, reporting support, and ways to manage spreadsheet information more efficiently.
Yes, the course includes VLOOKUP topics such as wildcard searches, left lookups, two-way lookups, list comparison, and useful lookup tips to help learners find, match, and compare data across spreadsheets.
Yes, learners explore Power Query for data preparation, including trimming data, formatting dates and values, parsing URLs, using expressions, understanding variables, and transforming spreadsheet data for cleaner reporting workflows.
Access
Level
Number of Units
Duration
Course Type