• LOGIN
  • No products in the cart.

Microsoft Office 2016 Excel Advanced - Complete Video Course

4.7( 7 REVIEWS )
651 STUDENTS

Benefits you will get

Description

Nowadays, Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut – from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced – Complete Video Course is designed to help you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn to visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us.

Screenshot:

Requirements:

Assesment:

We assess our learners through quizzes or multiple choice test. This test will be assessed automatically and immediately to give you an instant result.

Accrediation:

cpdqs logo
ciq

Certification:

The PDF copy of Certificate of Completion can be claimed at the free of cost. If you need a hardcopy of this certificate, you have to pay an additional payment. The time for PDF certificate turnaround is 24 hours, and for the hardcopy, it is 3-7 working days

Course Curriculum

Working with Multiple Worksheets and Workbooks
Use Links and External References FREE 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- Microsoft Office 2016 Excel Advanced – Complete Video Course 00:20:00
Final Exam
Final Exam- Microsoft Office 2016 Excel Advanced – Complete Video Course 00:20:00

Course Reviews

4.7

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

No Reviews found for this course.

TAKE THIS COURSE

Instructors

651 STUDENTS ENROLLED

30 DAYS MONEY BACK Guarantee

Buy For Your team

Get your team access to john’s top 1540+ courses anytime anywhere

try john academy for business

Our Course Awarding Bodies

ACCREDITED BY

 

OUR COURSE PARTNERS

Have you any inquiry?

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

© 2021 John Academy All Rights Reserved.