-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Advanced MS Office Excel Course
Advanced MS Office Excel Course
£29 ex Vat
Take This Course OR
1 Year Access 
Advanced
18 Students -
3 hours, 14 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
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 One Education.
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 Advanced MS Office Excel Course 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 Curriculum
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| 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 | |||
| Mock Exam – Advanced MS Office Excel Course | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Advanced MS Office Excel Course | 00:20:00 | ||
Related Courses
Intermediate
Intermediate
Intermediate
COPYRIGHT © 2022 One Education
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add