Advanced Excel Course (Formula, VLOOKUP & Power Query)

Advanced Excel Course (Formula, VLOOKUP & Power Query)

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Description

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.

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: 

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. 

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.

Certification

After completing this course's assessment, you will be eligible for:

OE Certificate@2x-100 (1) (1) (1)
Transcript

The CPD QS accredited certificate 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.

You can Order Your CPD QS Accredited Certificate from here.

After successfully completing the course, you will be able to order an endorsed certificate as proof of your 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.

You can Order Your QLS Endorsed Certificate from here.

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:

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

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

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.

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: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) 1 week, 4 days
Order Your Certificate
Order Your Certificate QLS 00:00:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon