Type and hit enter to Search
×

Introduction to Microsoft Excel 2019

  • 4.7(45,580 Rating)

Course Overview

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

Multiple Routes of Delivery to
Fit Your Timetable

We understand that flexibility is key to effective learning and development, especially in today’s dynamic work environment. That’s why we offer multiple delivery formats for our IT trainings in UAE. Whether you prefer the interaction of in-person classes, the convenience of live virtual training, or the independence of self-paced online learning, we have a solution tailored to your schedule. Our goal is to make professional growth accessible to everyone, allowing you to upskill without compromising your other commitments.

Target Audiance

  • 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.

Schedule Dates

17 December 2024
Introduction to Microsoft Excel 2019
17 March 2025
Introduction to Microsoft Excel 2019
17 June 2025
Introduction to Microsoft Excel 2019
17 September 2025
Introduction to Microsoft Excel 2019

Course Content

  • 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

  • Tabs
  • Groups
  • Commands

  • 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

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement
  • Customize the Quick Access Toolbar

  • 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

  • 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

  • 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

FAQs

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.

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.

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.

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.

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.

Open chat
Hello
How Can We Help You?