• No products in the basket.

Introduction Discover how to utilize Microsoft Excel for advanced functions including linking multiple workbooks, mapping, and forecasting data with this …

Category

Students

17

Review

4.7

Course Description

Introduction

Discover how to utilize Microsoft Excel for advanced functions including linking multiple workbooks, mapping, and forecasting data with this accessible online course. The Advanced level MS Office Excel qualification offers a comprehensive training program through video tutorials, PDF handouts, automated assessments, and other online study materials. You are introduced to advanced Excel skills, building on your foundational and intermediate knowledge of the spreadsheet software, through easy-to-understand step-by-step instructions.

Course description

The Advanced MS Office Excel Course is designed and delivered by industry experts to take you from simple data entry to complicated financial models and analysis, watching and evaluating formulas, and troubleshooting faulty macros. You will also learn how to fully automate your workbooks, safely importing and exporting data, performing validation checks and using your data to determine potential outcomes in financial forecasting.

Course design

The course 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
  • Mock exams
  • Multiple-choice assessment

Certification

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

  • A CPD QS accredited Certificate from Course Links.

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.​

Order Your Certificate here

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

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 and an accredited qualification attesting to your knowledge.

The [course_title] 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.

Course Content

    • Use Links and External References 00:12:00
    • Use 3-D References 00:06:00
    • Consolidate Data 00:05:00
    • Use Lookup Functions 00:12:00
    • Trace Cells 00:09:00
    • Watch and Evaluate Formulas 00:08:00
    • Collaborate on a Workbook 00:19:00
    • Protect Worksheets and Workbooks 00:08:00
    • Apply Data Validation 00:13:00
    • Search for Invalid Data and Formulas with Errors 00:04:00
    • Work with Macros 00:18:00
    • Create Sparklines 00:07:00
    • MapData 00:07:00
    • Determine Potential Outcomes Using Data Tables 00:08:00
    • Determine Potential Outcomes Using Scenarios 00:09:00
    • Use the Goal Seek Feature 00:04:00
    • Forecasting Data Trends 00:05:00
    • Mock Exam – Advanced MS Office Excel Course 00:20:00
    • Final Exam – Advanced MS Office Excel Course 00:20:00

4.7

4.7
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Original price was: £424.99.Current price is: £29.00. ex Vat
30-Day Money-Back Guarantee
Includes

subcribe New letters

Enter your email and we’ll send you more information.

top