Intermediate Microsoft Excel 2016

Course Overview

The Intermediate Microsoft Excel 2016 course is designed for users with a basic understanding of Excel who want to expand their skills to work more efficiently with data and spreadsheets. This practical, hands-on course introduces intermediate-level features that help users organize information, perform calculations, analyze data, and create professional reports.

Participants will learn how to work with advanced worksheet formatting, formulas and functions, data management tools, charts, tables, and workbook collaboration features. The course also covers sorting and filtering data, using logical and lookup functions, creating templates, and managing large worksheets effectively.

By the end of the course, participants will have the confidence to use Excel more productively, improve data accuracy, and create well-structured spreadsheets that support everyday business and reporting requirements.

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.

Flexible Training Options to
Meet Your Needs

We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.

Select the method that best suits your needs.

Online Instructor-Led Training

Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.

Classroom Training

Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai

Onsite Training

Learn a customized curriculum in your workplace to ensure the most impact and team participation.

Overseas Training

Participate in our international training sessions and improve your abilities with world-class instructors.

Target Audience

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

04 August 2026

Intermediate Microsoft Excel 2016

04 November 2026

Intermediate Microsoft Excel 2016

04 February 2027

Intermediate Microsoft Excel 2016

04 May 2027

Intermediate Microsoft Excel 2016

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.

Yes. Participants will learn how to sort, filter, and organize data efficiently to improve data analysis and reporting.

Yes. Conditional formatting is covered in the course and allows you to automatically highlight important data based on specific criteria.

The Intermediate course bridges the gap between basic spreadsheet skills and advanced data analysis techniques. It focuses on improving efficiency, working with larger datasets, and using more powerful functions, preparing participants for advanced Excel features such as PivotTables, advanced lookups, and automation.

Intermediate Microsoft Excel 2016

Course Overview

Course Outcome

Prerequisites