Overview
Are you someone who’s always overwhelmed while working on a spreadsheet? Do you struggle when you open a Power Query? Are you facing trouble to keep track of all the running tasks and calculations?
If the answer to all the questions above is “Yes” then this Advanced Excel Course (Formula, VLOOKUP & Power Query) is something that you seriously need to look at.
Description
Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is designed for learners opting to easily learn Formula, VLOOKUP, Power Query and M Language.
The course will introduce you to a wide range of Excel features that can assist you in your day to day activities:
- Discover text formulas, mathematical formulas, date and time formulas even financial and informational formulas
- Discover how to compare lists in VLOOKUP and only look for values vertically
- Know the trick to look for data from left to right and 2-way lookups
- Learn the basic features of Power query and how to trim and transform data in Excel Power Query
- Learn how to extract data from folders and do auto clean up on Excel Power Query
- Learn how to merge and shape data according to analysis requirements and prepare models by tools such as power pivot
- Know how to extract data from a table based on a particular value
- Know how to calculate, analyse, and visualize data and information
The course is designed for beginner users opting to learn MS Office. No matter how knowledgeable you already are about Excel, you are sure to benefit from this quick course.
Course design
The Advanced Excel Course (Formula, VLOOKUP & Power Query) is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of:
- Video lessons
- Online study materials
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £89. There is an additional £10 postage charge for international students.
CPD Certification from Thames College
After successfully completing the MCQ assessment of this course, you will qualify for the CPD Certificate from Thames College, as proof of your continued professional development. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.
Endorsement
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme websit
Method of Assessment
To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD accredited certificates.
After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance.
After passing the assignment exam, you will be able to apply for a certificate.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills attesting to your knowledge.
The Advanced Excel Course (Formula, VLOOKUP & Power Query) is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Requirements
Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
Excel is a very essential tool in our day to day lives. If you’ve managerial and administrative duties, is it safe to assume, Excel is by now an indispensable tool for you. Whether you’re taking your early steps or hold more of a senior role in your career, our Advanced Excel Course (Formula, VLOOKUP & Power Query) is something you can be benefitted from.
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
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
