MS Office 2016 Excel Advanced

Introduction

Discover how to utilise Microsoft Excel for advanced functions including linking multiple workbooks, mapping and forecasting data with this accessible online course. The Microsoft Office 2016 Excel Advanced 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 Microsoft Office 2016 Excel Advanced - Complete Video 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.

The MS Office 2016 Excel Advanced 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.

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.

CPD

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

COURSE CURRICULUM

• Working with Multiple Worksheets and Workbooks
• Using Lookup Functions and Formula Auditing
• Sharing and Protecting Workbooks
• Automating Workbook Functionality
• Creating Sparklines and Mapping Data
• Forecasting Data

Whether you’re a beginner aiming to get your foot in the door or an established professional keeping ahead of the latest developments, our online classes are suitable for all skill levels.

One Education knows that everyone is different. That’s why we offer a range of learning styles, across a number of different subjects.

All our courses offer a variety of learning materials including video and audio lectures, online exams, test areas, as well as traditional handouts.

We cover IT skills including network maintenance, programming, coding, cyber security and more

Our design courses will help you learn the skills necessary to work in interior design, web or digital design, graphic design, and even landscape gardening,

All courses come with professional accreditation meaning you can pursue your career goals with confidence in your specialist skills and knowledge,