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

Introduction to Microsoft Excel 2019

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

Introduction to Microsoft Excel 2019

The Microsoft Excel training provides participants with foundational knowledge and skills in Excel. The course is intricately designed to train individuals to become expert in data manipulation. Throughout the program, participants will be taken through the detailed working of Excel, which will enable them to create and develop Excel worksheets and workbooks. Besides covering a wide range of topics, this course includes hands-on exercises to provide deep practical insights into the subject. The growing significance of data and data management puts Microsoft Excel skills at the top of the list as it is used for organizing, analyzing and presenting large amounts of data. By the end of this training, participants will have a solid understanding of Excel and developed skills essential for using Excel for advanced data applications.

Course Outcome

Successful completion of the Microsoft Excel course will help you to:

  • Comprehend the fundamentals of Microsoft Excel
  • Learn how to create, format, and save a workbook
  • Understand formulae and functions and how to use them in workbooks
  • Learn how to enter and edit data, format cells, and save a workbook
  • Learn how to format data in Excel, including how to apply cell styles, change font sizes and colors, and add borders and shading
  • Learn how to print and share worksheets in Excel

Target Audience

  • The meticulous accountant who now sees Excel as their ultimate tool for financial wizardry.
  • The overwhelmed administrative assistant now confidently organizes data with Excel's functions and shortcuts.
  • The ambitious entrepreneur now leverages Excel to forecast profits and streamline business operations.
  • The analytical engineer now harnesses Excel's power for data analysis and visualization like a pro.

Course Content

7 modules · 53 topics
01Creating a Microsoft Excel Workbook9 topics
  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook
02The Ribbon3 topics
  • Tabs
  • Groups
  • Commands
03The Backstage View (The File Menu)9 topics
  • Introduction to the Backstage View
  • Opening a Workbook
  • Open a Workbook
  • New Workbooks and Excel Templates
  • Select, Open and Save a Template Agenda
  • Printing Worksheets
  • Print a Worksheet
  • Adding Your Name to Microsoft Excel
  • Adding a Theme to Microsoft Excel
04The Quick Access Toolbar5 topics
  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement
  • Customize the Quick Access Toolbar
05Entering Data in Microsoft Excel Worksheets9 topics
  • Entering Text
  • Adding and Deleting Cells
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle
  • Entering Numbers and Dates
06Formatting Microsoft Excel Worksheets12 topics
  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Customize a Workbook Using Tab Colors and Themes
  • Adding a Watermark
  • The Font Group
  • Working with Font Group Commands
  • The Alignment Group
  • Working with Alignment Group Commands
  • The Number Group
  • Working with Number Group Commands
07Using Formulas in Microsoft Excel6 topics
  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References
  • Working with Formulas

Schedule Dates

4 upcoming batches
Session Type
Physical sessions run at our training facility.
Introduction to Microsoft Excel 2019
Batch DatesDurationBatch OptionsLanguageAction
17 December 2026Next1 Day4 hours & 8 hoursEnglish/ Arabic
17 March 20271 Day4 hours & 8 hoursEnglish/ Arabic
17 June 20271 Day4 hours & 8 hoursEnglish/ Arabic
17 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 is Microsoft Excel?

Microsoft Excel is a powerful spreadsheet program developed by Microsoft. It allows users to organize, analyze, and visualize data using a grid of cells arranged in rows and columns.

What are the benefits of learning Microsoft Excel in Dubai?

Learning Microsoft Excel in Dubai opens up numerous opportunities for career advancement, as proficiency in Excel is highly valued in various industries such as finance, accounting, marketing, and data analysis.

Is Excel 2019 different from previous versions?

Yes, Excel 2019 introduced several new features and enhancements compared to previous versions. Some notable additions include new functions, improved data analysis tools, and enhanced collaboration features.

Do I need prior experience with Excel to take this course?

No prior experience is required for this Introduction to Microsoft Excel 2019 course. The course is designed for beginners and covers the fundamental concepts and skills needed to start using Excel effectively.

Will the course be hands-on?

Yes, the course will be hands-on, allowing participants to practice their skills in real-time. Exercises and practical examples will be provided to reinforce learning.

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