Name: MS Excel 2016 Advanced
Price: 25 GBP
Rating: 4.7 (8 reviews)

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