Intermediate Microsoft Excel 2019

Overview Schedule Dates Course Content Faqs

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.

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

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.

Schedule Dates

Intermediate Microsoft Excel 2019

16 September 2024

Intermediate Microsoft Excel 2019

16 December 2024

Intermediate Microsoft Excel 2019

17 March 2025

Intermediate Microsoft Excel 2019

17 June 2025

Course Content

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

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

Working with Clip Art
Using Shapes
Adding Shapes
Working with Icons
Working with SmartArt
Using Office Ink

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

Format Data as a Table
Move between Tables and Ranges
Modify Tables
Define Titles
Creating and Modifying a Table in Excel

Applying Conditional Formatting
Using Conditional Formatting
Working with Styles
Creating and Modifying Templates

FAQs

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.

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.

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.

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.

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.