Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Page 1

8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

LOGIN

HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / MICROSOFT OFFICE 2016 EXCEL INTERMEDIATE - COMPLETE VIDEO COURSE

Microsoft O ce 2016 Excel Intermediate Complete Video Course ( 10 REVIEWS ) 

450 STUDENTS

Description: This will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. …

TAKE THIS COURSE

 https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

1/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

£350.00 £19.00

   

1 YEAR INTERMEDIATE COURSE BADGE COURSE CERTIFICATE

19

NUMBER OF UNITS NUMBER OF QUIZZES

2

4 HOURS, 16 MINUTES

HOME

CURRICULUM

REVIEWS

Description: This Microsoft O ce 2016 Excel Intermediate – Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now.

Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

2/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Before sitting for your nal exam you will have the opportunity to test your pro ciency with a mock exam.

Certi cation: After completing and passing the course successfully, you will be able to obtain an Accredited Certi cate of Achievement. Certi cates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for? Microsoft O ce 2016 Excel Intermediate – Complete Video Course is certi ed by CPD Quali cations Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and quali cation required for this course, it is available for all students from any academic background.

Requirements Our Microsoft O ce 2016 Excel Intermediate – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path After completing this course you will be able to build up accurate knowledge and skills with proper con dence to enrich yourself and brighten up your career in the relevant job market. COURSE CURRICULUM

Working with Functions

Work with Ranges

00:18:00

Use Specialized Functions

00:11:00

Work with Logical Functions

00:23:00

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

3/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Work with Date & Time Functions

00:08:00

Work with Text Functions

00:11:00

Working with Lists

Sort Data

00:10:00

Filter Data

00:10:00

Query Data with Database Functions

00:09:00

Outline and Subtotal Data

00:09:00

Analyzing Data

Create and Modify Tables

00:15:00

Apply Intermediate Conditional Formatting

00:07:00

Apply Advanced Conditional Formatting

00:05:00

Visualizing Data with Charts

Create Charts

00:13:00

Modify and Format Charts

00:12:00

Use Advanced Chart Features

00:12:00

Using PivotTables and PivotCharts

Create a PivotTable

00:13:00

Analyze PivotTable Data

00:12:00

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

4/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Present Data with PivotCharts

00:07:00

Filter Data by Using Timelines and Slicers

00:11:00

00:20:00

00:20:00

Mock Exam

-

Mock Exam- Microsoft O Course

ce 2016 Excel Intermediate – Complete Video

Final Exam

-

Final Exam- Microsoft O Course

ce 2016 Excel Intermediate – Complete Video

COURSE REVIEWS

4.9   10 ratings

5 STARS

0

4 STARS

0

3 STARS

0

2 STARS

0

1 STARS

0

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

5/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

NO REVIEWS FOUND FOR THIS COURSE.

RELATED COURSES

Microsoft Excel Basics

£199.00 £10.00  

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

492

6/12


8/13/2018

Microsoft O

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

ce Essential Skills

£269.00 £14.00  

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

488

7/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Workplace Essential Training: Team Player

£199.00 £10.00  

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

588

8/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Workplace Essential Training: Collaboration

£199.00 £10.00  

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

564

9/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Progressive Employer Training

£199.00 £10.00  

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

583

10/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Microsoft Power BI

£199.00 £10.00 527

 

450 STUDENTS ENROLLED

HAVE YOU ANY INQUIRY?

https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

11/12


8/13/2018

Microsoft Office 2016 Excel Intermediate - Complete Video Course - John Academy

Full Name *

Your Email *

Telephone

Message *

By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

Submit

ABOUT We are a company who is best known for o ering awarding body accredited courses for anyone who wishes to take their professional life to the next level.  11 Floor, 15 St Botolph Street, London EC3A 7BB  020 3744 3990  info@johnacademy.co.uk CERTIFICATE CODE Enter Certi cate Code https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-intermediate-complete-video-course/

12/12


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.