CounselTrain
Call usEnquire now
Home/Courses/Intermediate Microsoft Excel 2019

Intermediate Microsoft Excel 2019

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

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.

Who Should Attend

  • 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

16 December 2026
Intermediate Microsoft Excel 2019
16 March 2027
Intermediate Microsoft Excel 2019
16 June 2027
Intermediate Microsoft Excel 2019
16 September 2027
Intermediate Microsoft Excel 2019

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

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.

How We Deliver

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.

Online Instructor-Led Training

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

Live SessionsRecorded AccessGlobal