learning@counseltrain.com
CounselTrain
Contact usEnquire now
Call usEnquire now

Intermediate Microsoft Excel 2016

4.8(45,582 Ratings)
Duration
1 Day
Upcoming Batch
10 December 2026
Batch Options
4 hours & 8 hours
Language
English/ Arabic

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.

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.

Course Content

8 modules · 61 topics
01Advanced Formulas29 topics
  • 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
02Working with Lists6 topics
  • 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
03Working with Illustrations3 topics
  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt
04Visualizing Your Data5 topics
  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template
05Working with Tables4 topics
  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles
06Advanced Formatting3 topics
  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates
07Microsoft Excel Features that Were New in 20134 topics
  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature
08Features New in 20167 topics
  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

Schedule Dates

4 upcoming batches
Session Type
Physical sessions run at our training facility.
Intermediate Microsoft Excel 2016
Batch DatesDurationBatch OptionsLanguageAction
10 December 2026Next1 Day4 hours & 8 hoursEnglish/ Arabic
10 March 20271 Day4 hours & 8 hoursEnglish/ Arabic
10 June 20271 Day4 hours & 8 hoursEnglish/ Arabic
10 September 20271 Day4 hours & 8 hoursEnglish/ Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

FAQs

What are the prerequisites for enrolling in the Intermediate Microsoft Excel 2016 course?

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

What topics are covered in the Intermediate Microsoft Excel 2016 course?

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

What is the course format?

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.

Is this course suitable for preparing for the Microsoft Office Specialist (MOS) certification?

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

Do I need to bring my own laptop for the course?

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.

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

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.

Learn more

Highlights

Live SessionsRecorded AccessGlobal

Related Courses

Other courses in the same category that might interest you.

View All
Upcoming Batch
10 December 2026