Description

MS Excel 2016 has various functions. It engages people to maintain documents, business resource, calculations, making so many effective works at an instance. If you want to more about its functions, you may have a look at the MS Excel 2016 Advanced course.

The MS Excel 2016 Advanced course is designed in such a way that will enable students to learn about the advance issues of MS Excel including AVERAGEIF, COUNTIF, and SUMIF functions. It also incorporates advanced lookup features such as VLOOOKP and HLOOKUP, INDEX, and MATCH, and difficult logical and textual functions. The purpose of the course is to make the students expert on auditing formulas including learning the methods of worksheet and workbook safety, IF Analysis types of equipment, functions of Pivot Tables and PowerPivot add-in, use of Macros, and the assurance of data reliability in the worksheet and workbooks.

Assessment:

This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates 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?

MS Excel 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our MS Excel 2016 Advanced 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 confidence to enrich yourself and brighten up your career in the relevant job market.

Course Curriculum

Introduction
Introduction FREE 00:01:00
Using Advanced IF Statements
Summarize Data with SUMIF 00:04:00
Summarize Data with AVERAGIF 00:03:00
Summarize Data with COUNTIF 00:02:00
Using Advanced Lookup Functions
Using VLOOKUP with TRUE to find an Approximate Match 00:04:00
Using HLOOKUP TRUE to find an Approximate Match 00:01:00
Using the Index Function 00:03:00
Using the Match Function 00:02:00
Creating a Combined Index and Match Formula 00:04:00
Comparing Two Lists with VLOOKUP 00:02:00
Comparing Two Lists with VLOOKUP and ISNA 00:04:00
Using Complex Logical and Text Functions
Creating a Nested IF Function 00:03:00
Using the IFERROR Function 00:02:00
Using the LEN Function 00:02:00
Using the TRIM Function 00:01:00
Using the Substitute Function 00:02:00
Formula Auditing
Showing Formulas 00:01:00
Tracing Cell Precedents and Dependents 00:03:00
Adding a watch Window 00:02:00
Error Checking 00:02:00
What-If Analysis Tools
Using the Scenario Manager 00:03:00
Using Goal Seek 00:02:00
Analyzing with Data Tables 00:02:00
Worksheet and Workbook Protection
Protection Overview 00:02:00
Excel File Password Encryption 00:03:00
Allowing Specific Worksheet Changes 00:01:00
Adding Protection to only Certain Cells in a Worksheet 00:03:00
Additional Protection Features 00:02:00
Advanced Use of PivotTables and PowerPivot
Using the Pivot Tables Charts Wizard 00:02:00
Adding a Calculated Field 00:02:00
Adding a Caculated Item 00:02:00
Apply Conditional Formatting to a Pivot Table 00:03:00
Using Filters in the Pivot Table Fields Pane 00:02:00
Creating Filter Pages for a Pivot Table 00:01:00
Enabling a Power Pivot Add In 00:04:00
Automating with Macros
What are Macros 00:03:00
Displaying the Developer Tab and Enabling Macros in Excel 00:03:00
Creating a Basic Formatting Macro 00:03:00
Running a Macro 00:02:00
Assigning a Macro to a Button 00:02:00
Creating a More Complex Macro 00:02:00
Viewing and Editing the VBA Code for an Existing Macro 00:03:00
Adding a Macro to the Quick Access Toolbar 00:02:00
Working with Form Controls
What are Form Controls 00:02:00
Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00
Adding a Combo Box to a Spreadsheet 00:02:00
Ensuring Data Integrity
What is Data Validation 00:01:00
Restricting Data Entries to Whole Numbers 00:02:00
Data Validation Restricting Data Entry to a List 00:01:00
Data Validation Restricting Data Entry to a Date 00:01:00
Data Validation Restricting Data Entry to Different Text Lengths 00:01:00
Composing Input Messages 00:02:00
Composing Error Alters 00:02:00
Finding Invalid Data 00:02:00
Editing and Deleting Data Validation Rules 00:01:00
Collaborating in Excel
Working with Comments 00:03:00
Printing Comments and Errors 00:02:00
Sharing a Workbook 00:04:00
Tracking Changes in a Workbook 00:03:00
Working with Versions 00:02:00
Sharing Files via Email 00:02:00
Importing and Exporting Data to a Text File
Importing a Text File 00:03:00
Exporting a Text File 00:01:00
Conclusion
Course Recap 00:01:00
Assessment

Course Reviews

4.7

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

No Reviews found for this course.

587 STUDENTS ENROLLED

ACCREDITED BY

OUR COURSE AWARDING BODIES

OUR COURSE PARTNERS

Have you any inquiry?

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

Certificate Code

top

© John Academy.