Intermediate Microsoft Excel 2016

Overview Schedule Dates Course Content Faqs

Course Overview

In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel’s data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

Course Outcome

Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
Learn to create useful and eye-catching charts
Discover how to manipulate data with the push of a button
Add the time-saving functions of advanced Excel users to your repertoire

Prerequisites

There are no prerequisites to take this course.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

Office Managers: Office managers seeking to enhance their data management and analysis skills for better efficiency.
Data Analysts: Data analysts aiming to deepen their Excel proficiency for more advanced data manipulation and visualization.
Financial Analysts: Financial analysts looking to streamline financial modeling and reporting tasks.
Human Resource Professionals: HR professionals wanting to improve their ability to organize and analyze employee data.

Schedule Dates

Intermediate Microsoft Excel 2016

10 September 2024

Intermediate Microsoft Excel 2016

10 December 2024

Intermediate Microsoft Excel 2016

10 March 2025

Intermediate Microsoft Excel 2016

10 June 2025

Course Content

Using Named Ranges in Formulas
Naming a Single Cell
Naming a Range of Cells
Naming Multiple Single Cells Quickly
Using Formulas That Span Multiple Worksheets
Using the IF Function
Using AND/OR Functions
Using the SUMIF, AVERAGEIF, and COUNTIF Functions
Using the PMT Function
Using the LOOKUP Function
Using the VLOOKUP Function
Using the HLOOKUP Function
Using the CONCATENATE Function
Using the TRANSPOSE Function
Using the PROPER, UPPER, and LOWER Functions
The UPPER Function
The LOWER function
The TRIM Function
Using the LEFT, RIGHT, and MID Functions
The MID Function
Using Date Functions
Using the NOW and TODAY Functions
Creating Scenarios
Utilize the Watch Window
Consolidate Data
Enable Iterative Calculations
What-If Analyses
Use the Scenario Manager
Use Financial Functions

Converting a List to a Table
Removing Duplicates from a List
Sorting Data in a List
Filtering Data in a List
Adding Subtotals to a List
Grouping and Ungrouping Data in a List

Working with Clip Art
Using Shapes
Working with SmartArt

Creating a Custom Chart Template
Inserting Charts
Add and Format Objects
Insert a Text Box
Create a Custom Chart Template

Format Data as a Table
Move between Tables and Ranges
Modify Tables
Define Titles

Applying Conditional Formatting
Working with Styles
Creating and Modifying Templates

New Functions in Excel 2013
Using New Chart Tools
Using the Quick Analysis Tool
Using the Chart Recommendation Feature

New Charts
Treemap
Sunburst
Histogram
Waterfall
Box and Whisker
Pareto

FAQs

Participants should have a basic understanding of Microsoft Excel, including knowledge of fundamental operations like creating and editing worksheets, basic formulas, and formatting cells.

The course covers advanced functions and formulas, data analysis tools, PivotTables and PivotCharts, conditional formatting, data validation, and advanced charting techniques.

The course is delivered through a combination of lectures, hands-on exercises, and practical projects. This blended approach ensures that participants can apply what they’ve learned in real-world scenarios.

Yes, the Intermediate Microsoft Excel 2016 course covers many of the skills and knowledge areas tested in the MOS certification for Excel 2016.

It depends on the training provider. Some providers supply computers equipped with the necessary software, while others may require you to bring your own laptop with Excel 2016 installed.