4
- × 30 Days to Soar Course 1 × £319
- × PDF Certificate (Special Gift - 67% OFF) 2 × £5.99
- × Scaffolding Safety in Construction Environments 1 × £25
Subtotal: £355.98

View basket Checkout
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

Excel 2016 Advanced

What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Process monthly …

★ ★ ★ ★ ★

4.6(38 reviews)

1414 enrolled on this course

What Will I Learn?

Use Advanced IF Statements

Use Advanced Lookup Functions

Use Complex Logical and Text Functions

Process monthly pay

Auditing Formulas

Working with What-If Analysis Tools

Protecting Worksheet and Workbook

Use Advanced PivotTables and PowerPivot Tools

Automate with Macros

Work with Form Controls

Ensure Data Integrity

Import and Export Data to a Text File

Welcome To Excel 2016 Advanced

Course Overview

In this day and age can you imagine an office without Excel! No matter what profession you have, good Microsoft Excel skills will always come in handy. The Excel 2016 Advanced course is designed to show the learners A-Z of Excel 2016 to turn them into expert users.

This course is packed in 65 easy to follow modules to help you understand all the tools and functions of Excel 2016. This course will guide you through using advanced if statements, automating with macros and formula auditing. You will also learn about complex text functions. During this course, you will have the opportunity to take an assessment to consolidate your learning.

If you desire to comprehend all the advanced Excel 2016 skills, then this is the course. Upon completing this course, you will be able to raise your proficiency level and bring out your all potentials. So don’t delay, enrol today!

Excel 2016 Advanced is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.

This course is accredited by CPD so you will get a career boost upon completing this course. Our Excel 2016 Advanced is packed with 65 modules and 3 hours, 1 minute of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.

It doesn’t matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.

Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Preview

Certification

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Introduction
	Introduction	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:03: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
Course Certification
	Order your Certificate	00:00:00
Mock Exam
	Mock Exam – Excel 2016 Advanced	00:20:00
Final Exam
	Final Exam – Excel 2016 Advanced	00:20:00