CounselTrain
Call usEnquire now

Intermediate Microsoft Excel 2019

4.7(45,580 Ratings)
Duration
1 Day
Upcoming Batch
16 December 2026
Batch Options
4 hours & 8 hours
Language
English/ Arabic

Course Overview

This is an intermediate-level class that teaches the different concepts in Microsoft Excel in a much more in-depth manner. This Intermediate Microsoft Excel 2019 training class is a one-day class that gives you the advantage of gaining the skills of this comprehensive course in only one day. This is meant for students who want to increase their knowledge and gain an in-depth understanding of MS Excel 2019, as well as advance their abilities and techniques in working with advanced formulas, lists, and illustrations. Apart from this, the students will also get to work with charts and advanced formatting inclusive of styles.

Learning Objectives:

The course has the following learning objectives:

  • Making use of formulas and functions
  • Constructing and amending the charts
  • Converting, sorting, and managing the lists
  • Inserting and amending the illustrations in the worksheet
  • Operating the tables
  • Making use of conditional formatting and styles

Audience:

This course is designed for and suitable for students who have foundational skills in operating Microsoft Excel 2019. This is for the students who now want to enhance their skills and get expertise in the intermediate-level skills of Excel, or for those students who want to gain an understanding of the concepts discussed in this course in the 2019 version.

Target Audience

  • Accountant - An accountant enhanced their data analysis skills by learning advanced Excel functions and financial modeling techniques.
  • Project Manager - A project manager improved their ability to track and manage project timelines and resources using Excel's advanced tools.
  • Data Analyst - A data analyst refined their proficiency in data manipulation, visualization, and pivot table creation.
  • HR Specialist - An HR specialist learned to streamline employee data management and reporting processes with Excel.

Course Content

6 modules · 38 topics
01Advanced Formulas9 topics
  • Using Named Ranges in Formulas
  • Using Named Ranges in Formulas
  • Using Formulas That Span Multiple Worksheets
  • Entering a Formula Using Data in Multiple Worksheets
  • Using the IF Function
  • Using the PMT Function
  • Using the LOOKUP Function
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
  • Adding Subtotals
03Working with Illustrations6 topics
  • Working with Clip Art
  • Using Shapes
  • Adding Shapes
  • Working with Icons
  • Working with SmartArt
  • Using Office Ink
04Visualizing Your Data8 topics
  • Inserting Charts
  • Using the Chart Recommendation Feature
  • Editing Charts
  • Using Chart Tools
  • Using the Quick Analysis Tool
  • Editing Charts
  • Add and Format Objects
  • Create a Custom Chart Template
05Working with Tables5 topics
  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles
  • Creating and Modifying a Table in Excel
06Advanced Formatting4 topics
  • Applying Conditional Formatting
  • Using Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Schedule Dates

4 upcoming batches
Session Type
Physical sessions run at our training facility.
Intermediate Microsoft Excel 2019
Batch DatesDurationBatch OptionsLanguageAction
16 December 2026Next1 Day4 hours & 8 hoursEnglish/ Arabic
16 March 20271 Day4 hours & 8 hoursEnglish/ Arabic
16 June 20271 Day4 hours & 8 hoursEnglish/ Arabic
16 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 topics are covered in the Intermediate Microsoft Excel 2019 course?

The Intermediate Microsoft Excel 2019 course covers advanced functions and formulas, data analysis tools, pivot tables, conditional formatting, advanced charting techniques, data validation, macros, and workbook management.

What are the prerequisites for enrolling in this course?

Participants should have a basic understanding of Excel, including familiarity with basic functions, formulas, and spreadsheet navigation. Prior completion of a Beginner Excel course or equivalent experience is recommended.

How long is the Intermediate Microsoft Excel 2019 course?

The course typically spans 2 to 3 days, with daily sessions lasting around 6 to 8 hours. The exact duration may vary depending on the training provider.

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

This depends on the training provider. Some may provide computers with Excel 2019 pre-installed, while others may require you to bring your own laptop. It’s best to check with the course provider beforehand.

Is the course conducted in English?

While many courses in Dubai are conducted in English, it’s advisable to confirm with the training provider. Some providers might offer the course in other languages based on demand.

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
16 December 2026