• LOGIN
  • No products in the basket.

Login

Microsoft Excel is used in businesses throughout, starting from engineering to diverse fields such as medicine. It is one of the top three best known Microsoft Office tools and probably the best spreadsheet program out there. However there is a steep learning curve to its advanced features, which you can now master from this Microsoft Excel 2016 Advanced Training course.

This course will help you learn some of the advanced features of the 2016 version of Excel. As such it starts out with a bang as you learn to automate worksheet functionality, along with how to update worksheet properties, create and edit macros, apply conditional formatting, and add data validation criteria. Next you discover ways to trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online. Furthermore you will learn to analyze and present data through statistical analysis, creating Sparklines and scenarios, and more. You will also learn how to work with multiple workbooks, export excel data, and import and export XML data.

Using this course correctly will lead you to master some of the most advanced features of Excel 2016 and essentially develop key skills that will help you stand out from the crowd.

Why Should You Choose Microsoft Excel 2016 Advanced Training

  • Internationally recognised accredited qualification
  • 1 year accessibility to the course
  • Free e-Certificate
  • Instant certificate validation facility
  • Properly curated course with comprehensive syllabus
  • Full-time tutor support on working days (Monday – Friday)
  • Efficient exam system, assessment and instant results
  • Access to the course content on mobile, tablet or desktop from anywhere anytime
  • Eligible for **Student ID** card which gives you 1000’s of discounts from biggest companies.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful in no time. You will be able to stand out in the crowd after completing this course. You will also be able to add our qualifications to your Resume and make yourself worthy in the competitive job industry.

FAQs

Who is this course for?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

Is this course accredited?

Yes, this course is accredited by CiQ and CPD Qualification Standards.

If I take the course, how will I be assessed?

Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. Pass mark is 60%.

Does this course include exams?

Yes, this course includes exams.

How can I achieve my certificate?

Once you successfully pass your exam you can obtain your certificate of achievement either in PDF or hard copy format, or both, for an additional fee.  Certificates are also available as e-certificates.

Is there any charge for certification?

Yes, there is an additional charge for the certification service.  Certificates are £4 each for PDFs and £8 each for hard copies. If both PDF and hard copy certificates are ordered at the same time, the cost is £10. E-certificates are available from your learning portal completely free of charge.

Can anyone validate my certificate through your website?

Yes, there is a unique code issued for every certificate and anyone can validate your certificate by using this code through our website.

Are there any prerequisites for the course?

There are no prerequisites for this course and it is open to everyone.

How long until I receive the course confirmation details?

Once you purchase a course your account will be set up within 48 hours and you will receive an email with your account details.

For how long do I have access to the course?

You will have access to the course for one year following purchase.

What support do you offer?

We provide 24 hours live chat support and our customer service team is available during working hours to answer your phone calls.

Course Curriculum

  • Unit 01: Excel from A-Z Course Introduction - Update Version
  • Excel from A-Z Course Intro
  • 00:03:00
  • Excel Job Opportunities
  • 00:03:00
  • Excel Job Types
  • 00:04:00
  • Microsoft Excel Marketplace
  • 00:04:00
  • What is Microsoft Excel?
  • 00:04:00
  • Who is This Course For?
  • 00:04:00
  • Unit 02: Getting Started With Excel - Update Version
  • Finding & Opening Excel
  • 00:01:00
  • Excel’s Start Screen
  • 00:03:00
  • Explaining the Excel Interface
  • 00:03:00
  • Excel Interface Continued
  • 00:01:00
  • Excel Workbook vs. Excel Worksheet
  • 00:02:00
  • Saving an Excel Document
  • 00:04:00
  • Customizing the Quick Access Toolbar
  • 00:02:00
  • Customizing the Excel Ribbon
  • 00:03:00
  • Excel Shortcut Keys
  • 00:02:00
  • Unit 03: Values, Referencing and Formulas - Update Version
  • Creating Excel Labels
  • 00:03:00
  • Entering Numeric Values in Excel
  • 00:03:00
  • Formatting Date Values in Excel
  • 00:05:00
  • Building Basic Formulas in Excel
  • 00:05:00
  • Order of Operations
  • 00:06:00
  • Relative vs. Absolute Cell References
  • 00:07:00
  • Unit 04: Intro to Excel Functions - Update Version
  • Excel Functions Explained
  • 00:03:00
  • The SUM() Function
  • 00:08:00
  • The MIN() & MAX() Function
  • 00:04:00
  • The AVERAGE() Function
  • 00:02:00
  • COUNT() Functions
  • 00:05:00
  • Unit 05: Adjusting Excel Worksheets - Update Version
  • Moving & Copying Data
  • 00:07:00
  • Insert & Delete Rows and Columns
  • 00:05:00
  • Adjusting the Width and Height of Cells
  • 00:05:00
  • Hiding and Unhiding Excel Rows and Columns
  • 00:04:00
  • Renaming, Moving & Deleting Excel Worksheets
  • 00:05:00
  • Adding Protection to Specific Cells
  • 00:04:00
  • Protecting the Structure of a Workbook
  • 00:02:00
  • Adding a Workbook Password to Open File
  • 00:02:00
  • Unit 06: Visually Pleasing Cell Formatting - Update Version
  • Formatting Fonts and Cell Background Color
  • 00:05:00
  • Adding Cell Borders
  • 00:05:00
  • Formatting Data Appropriately
  • 00:05:00
  • The Magic behind Excel’s Format Painter
  • 00:04:00
  • Creating Styles for Formatting Efficiency
  • 00:06:00
  • Merging Cells for a Cleaner Look
  • 00:03:00
  • The Power of Conditional Formatting
  • 00:06:00
  • Unit 07: How to Insert Images and Shapes! - Update Version
  • Grab User’s Attention using Illustrations
  • 00:09:00
  • Customizing Icons
  • 00:05:00
  • Create Compelling Graphics with SmartArt
  • 00:06:00
  • Unit 08: Visualize Data with Charts - Update Version
  • The Commonly Used Column Chart
  • 00:03:00
  • Changing the Chart Design.mp4
  • 00:02:00
  • Formatting Elements of a Chart
  • 00:06:00
  • Modifying the Data, Type & Location of a Chart
  • 00:06:00
  • Unit 09: Excel’s Printing Options - Update Version
  • Print Preview Options
  • 00:04:00
  • Excel’s Page Layout View
  • 00:07:00
  • Printing a Specific Range of Cells
  • 00:03:00
  • Converting Spreadsheets to PDF Files
  • 00:02:00
  • Unit 10: Benefits of Using Excel Templates - Update Version
  • Why Create an Excel Template
  • 00:01:00
  • How to Create an Excel Template
  • 00:05:00
  • Unit 11: Working with Excel Datasets - Update Version
  • How to Prepare Data for Analysis
  • 00:04:00
  • How to Sort Data in Excel
  • 00:03:00
  • Multi-Level Sorting
  • 00:03:00
  • Custom Sorting Datasets in Excel
  • 00:02:00
  • Applying Filters to Datasets
  • 00:05:00
  • Creating Subtotals within a Dataset
  • 00:06:00
  • Converting Datasets into Tables
  • 00:06:00
  • Little Slice of Pie Charts
  • 00:05:00
  • Finding & Removing Duplicate Values
  • 00:07:00
  • Unit 12: Excel Database Functions - Update Version
  • The SUMIF() Function
  • 00:09:00
  • The DSUM() Function
  • 00:08:00
  • The DSUM() Function Cont.
  • 00:07:00
  • The SUBTOTAL() Function
  • 00:06:00
  • Unit 13: Excel Data Validation - Update Version
  • What is Excel Data Validation?
  • 00:02:00
  • Creating a Drop Down List with Data Validation
  • 00:07:00
  • Different Types of Excel Data Validation
  • 00:06:00
  • Adding Custom Alerts to Data Validation
  • 00:07:00
  • Creating a Dynamic Drop Down List
  • 00:03:00
  • Complex Validation: Dependent Drop Down List!
  • 00:09:00
  • Unit 14: Excel PivotTables - Update Version
  • Creating an Excel Pivot Table
  • 00:06:00
  • Modifying Excel PivotTables
  • 00:06:00
  • Grouping & Filtering PivotTable Data
  • 00:07:00
  • Drilling Down into PivotTable Data
  • 00:02:00
  • Creating Pivot Charts & Utilizing Slicers
  • 00:08:00
  • Unit 15: Excel’s PowerPivot Add-In - Update Version
  • What is PowerPivot?
  • 00:04:00
  • Activating the Excel PowerPivot Add-In
  • 00:02:00
  • Creating Relationships between Data Tables.mp4
  • 00:06:00
  • Using Data Models to Create PivotTables
  • 00:05:00
  • How to Create PowerPivot KPI’s
  • 00:08:00
  • Unit 16: Excel’s Conditional Functions - Update Version
  • Excels IF Function
  • 00:05:00
  • IF() Function with AND() Criteria
  • 00:05:00
  • IF() Function with OR() Criteria
  • 00:05:00
  • Nesting Multiple IF() Functions
  • 00:07:00
  • The COUNTIF() Function
  • 00:04:00
  • Key Benefits of Named Ranges
  • 00:04:00
  • Unit 17: Excel’s Lookup Function - Update Version
  • VLOOKUP() Function
  • 00:09:00
  • The Beauty of Excel’s IFERROR() Function
  • 00:04:00
  • HLOOKUP() Function
  • 00:06:00
  • The INDEX Function
  • 00:05:00
  • MATCH() Function
  • 00:05:00
  • INDEX() and MATCH() Combined
  • 00:05:00
  • Two-Way Lookup with INDEX() and MATCH()
  • 00:04:00
  • Unit 18: Text Based Functions in Excel - Update Version
  • LEFT(), RIGHT() and MID() Function
  • 00:07:00
  • Extracting Specific Text using LEN() & SEARCH()
  • 00:13:00
  • Combining Text with CONCATENATE()
  • 00:06:00
  • Quick Tips & Other Text Based Functions
  • 00:06:00
  • Unit 19: Auditing Formulas and Views in Excel - Update Version
  • Final Exam- Microsoft Excel 2016 Advanced Training
  • 00:20:00
  • Tracing Precedents & Dependents in Formulas
  • 00:04:00
  • Showing Formulas
  • 00:02:00
  • Grouping Data
  • 00:03:00
  • 3D Referencing in Formulas
  • 00:05:00
  • Utilizing the Watch Window in Excel
  • 00:03:00
  • How to Freeze Panes in Excel
  • 00:03:00
  • Unit 20: Excel’s “what If?” Tools - Update Version
  • Excel’s Scenario Manager Tool
  • 00:06:00
  • Goal Seek in Excel
  • 00:06:00
  • Compare Results with Excel Data Tables
  • 00:04:00
  • Solver Tool
  • 00:11:00
  • Unit 21: Welcome to Excel VBA - Update Version
  • The Power Behind Excel VBA
  • 00:03:00
  • A Look Inside the Visual Basic Editor (VBE)
  • 00:04:00
  • Recording a Macro
  • 00:09:00
  • Saving & Opening a Macro-Enabled Workbook
  • 00:02:00
  • Unit 22: The VBA Language - Update Version
  • Modules and Procedures
  • 00:07:00
  • Objects, Methods and Properties
  • 00:06:00
  • Excel VBA Variables
  • 00:05:00
  • Unit 23: Writing VBA Code - Update Version
  • Referencing a Range
  • 00:14:00
  • InputBox & MsgBox
  • 00:06:00
  • Using Variables in VBA Code
  • 00:05:00
  • If Then Else Statement
  • 00:10:00
  • Worksheet Functions inside VBA
  • 00:08:00
  • Creating User Defined Functions
  • 00:09:00
  • User Defined Functions within VBA Scripts
  • 00:06:00
  • Unit 24: Important VBA Tools and Logic - Update Version
  • Find Last Row of Data
  • 00:06:00
  • Find Last Column of Data
  • 00:03:00
  • With Statement
  • 00:05:00
  • Debugging & Error Handling
  • 00:07:00
  • Debugging & Error Handling Cont.
  • 00:07:00
  • Unit 25: Excel VBA Loop - Update Version
  • For Next Loop
  • 00:09:00
  • Do Until Loop
  • 00:06:00
  • For Each Loop
  • 00:04:00
  • Unit 26: Triggering Macros - Update Version
  • Assigning Macros to Shapes
  • 00:04:00
  • Form Controls vs ActiveX Controls
  • 00:08:00
  • Worksheet Events
  • 00:04:00
  • Workbook Events
  • 00:03:00
  • Fun with VBA Events!
  • 00:07:00
  • Unit 27: Excel User Forms - Update Version
  • Creating an Excel UserForm
  • 00:03:00
  • Adding Controls to UserForms
  • 00:10:00
  • How to Show an UserForm
  • 00:03:00
  • Passing TextBox Values to Desired Cells
  • 00:07:00
  • Passing Option Buttons to Desired Cells
  • 00:07:00
  • UserForm ComboBoxes
  • 00:08:00
  • Clearing Values from UserForm Controls
  • 00:03:00
  • How to Close an UserForm
  • 00:02:00
  • UserForms and Protected Sheets
  • 00:05:00
  • Unit 28: Starting a Career in Excel - Update Version
  • Creating an Excel Resume
  • 00:05:00
  • Getting Started with Freelancing
  • 00:06:00
  • How to Become an Excel Freelancer
  • 00:05:00
  • Top Freelance Websites
  • 00:05:00
  • How to Get Your First Client
  • 00:08:00
  • Personal Branding
  • 00:07:00
  • Networking Do’s and Don’ts
  • 00:04:00
  • Importance of Having a Website
  • 00:04:00
  • Automating Worksheet Functionality - Old Version
  • Update Workbook Properties
  • 00:15:00
  • Activity-Update Workbook Properties
  • 00:05:00
  • Create and Edit a Macro
  • 00:15:00
  • Activity-Create and Edit a Macro
  • 00:05:00
  • Apply Conditional Formatting
  • 00:15:00
  • Activity-Apply Conditional Formatting
  • 00:05:00
  • Add Data Validation Criteria
  • 00:15:00
  • Activity-Add Data Validation Criteriaty
  • 00:05:00
  • Auditing Worksheets - Old Version
  • Trace Cells
  • 00:15:00
  • Activity-Trace Cells
  • 00:05:00
  • Troubleshoot Invalid Data and Formula Errors
  • 00:15:00
  • Activity-Troubleshoot Invalid Data and Formula Errors
  • 00:05:00
  • Watch and Evaluate Formulas
  • 00:15:00
  • Activity-Watch and Evaluate Formulas
  • 00:05:00
  • Create a Data List Outline
  • 00:15:00
  • Activity-Create a Data List Outline
  • 00:05:00
  • Analyzing and Presenting Data - Old Version
  • Create Sparklines
  • 00:15:00
  • Activity_Create Sparklines
  • 00:05:00
  • Create Scenarios
  • 00:15:00
  • Activity-Create Scenarios
  • 00:05:00
  • Perform a What-If Analysis
  • 00:15:00
  • Activity-Perform a What-If Analysis
  • 00:05:00
  • Perform a Statistical Analysis with the Analysis ToolPak
  • 00:15:00
  • Activity-Perform a Statistical Analysis with the Analysis ToolPak
  • 00:05:00
  • Create Interactive Data with Power View
  • 00:15:00
  • Activity-Create Interactive Data with Power View
  • 00:05:00
  • Working with Multiple Workbooks - Old Version
  • Consolidate Data
  • 00:15:00
  • Activity-Consolidate Data
  • 00:05:00
  • Link Cells in Different Workbooks
  • 00:15:00
  • Activity-Link Cells in Different Workbooks
  • 00:05:00
  • Merge Workbooks
  • 00:15:00
  • Activity-Merge Workbooks
  • 00:05:00
  • Exporting Excel Data - Old Version
  • Export Excel Data
  • 00:15:00
  • Activity-Export Excel Data
  • 00:05:00
  • Import a Delimited Text File
  • 00:14:00
  • Activity- Import a Delimited Text File
  • 00:05:00
  • Integrate Excel Data with the Web
  • 00:15:00
  • Activity-Integrate Excel Data with the Web
  • 00:05:00
  • Create a Web Query
  • 00:15:00
  • Activity-Create a Web Query
  • 00:05:00
  • Importing and Exporting XML Data - Old Version
  • Import and Export XML Data
  • 00:15:00
  • Activity-Import and Export XML Data
  • 00:05:00
  • Activities - Old Version
  • Activities – Microsoft Excel 2016 Advanced Training
  • 00:00:00
  • Mock Exam - Old Version
  • Mock Exam- Microsoft Excel 2016 Advanced Training
  • 00:20:00
  • Final Exam - Old Version
  • Assignment
  • Assignment – Microsoft Excel 2016 Advanced Training
  • 6 days, 16 hours

Course Reviews

4.7

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

No Reviews found for this course.

TAKE THIS COURSE
736 STUDENTS ENROLLED

Accredited By

 

30 Days – Money Back Guarantee

Our Students Say..

Our Course Awarding Bodies

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816

Our Courses Partners

Adams Academy

About

Make learning more accessible to learning enthusiasts, regardless of where they are residing in the world.

0800 368 7767
help@adamsacademy.com
Beaufort House, 15 St Botolph Street, London EC3A 7BB

Certificate Code

Coming Soon

   

top

© Adams Academy Inc. Ltd.

[Prince2 courses are not included in this offer.]
[Prince2 courses are not included in this offer.]
[Prince2 courses are not included in this offer.]
[Prince2 courses are not included in this offer.]
[not applicable for Prince2]
[not applicable for Prince2]