MS Office 2016 Excel Intermediate Level

Introduction

Enhance your existing Microsoft Excel skills and develop core competencies for the workplace with our Microsoft Office 2016 Excel Intermediate course. Through video tutorials that go step-by-step through each skill, it covers working with functions to make your worksheets more efficient, sorting and filtering data through lists, creating PivotTables and PivotCharts, and filtering data by using timelines and splicers. Your learning is augmented through PDF handouts, multiple choice assessments and other online study materials.

Course description

Microsoft Excel training is essential for a range of careers and personal projects. Excel can be used for organising, storing and analysing data in financial, administration, accounting, and other contexts. This complete video course will teach you all the skills you need to develop your knowledge of using Excel, building on your foundational understanding of creating worksheets and formulas to offer intermediate functions in creating databases and queries.

The MS Office 2016 Excel Intermediate Level 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 Functions
• Working with Lists
• Analyzing Data
• Visualizing Data with Charts
• Using PivotTables and PivotCharts

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,