Get the Newest CompTIA A+ 2025 Course for Only $12.99

Get Offer

For a limited time, check out some of our most popular courses for free on Udemy.  View Free Courses.

Microsoft Excel 2019 Training

Course Level: Beginner
Duration: 5 Hrs 37 Min
Total Videos: 58 On-demand Videos

Master the intricacies of Microsoft Excel 2019 with our comprehensive training course. Ideal for beginners to advanced users seeking to enhance their skills for professional or academic purposes, this course covers everything from basic data entry to complex data analysis tools, empowering you with the knowledge to excel in various career opportunities.

Buy An all access pass to over 3,000 hours of training

Learning Objectives

01

Understand the basics of Excel, including navigating the Ribbon, saving files, and entering and formatting data.

02

Gain proficiency in using Excel formulas, correcting errors, and understanding the functionalities of different functions.

03

Learn to insert functions, create charts, and customize these charts to suit your needs.

04

Develop skills in navigating and editing multiple worksheets, creating links between worksheets, and adding hyperlinks to documents.

05

Master the use of view options, filters, and grouping data for efficient data management in Excel.

06

Learn to create and customize visually appealing pages, convert tabular data to Excel tables, and apply data validation to cells.

07

Understand advanced Excel functions such as conditional functions, VLOOKUP, HLOOKUP, and create custom drop-down lists.

08

Learn to create and manipulate data in Pivot Tables and Charts, run preinstalled Macros, and create a simple Macro with Visual Basics for Applications (VBA).

Course Description

This Microsoft Excel 2019 Training is designed for professionals who want to master capabilities from basic data entry to advanced analysis, turning you into a confident user who can drive better decisions with spreadsheets.

You’ll walk away with practical, real‑world skills that matter in today’s roles—from organizing and validating data to building visually compelling reports. Whether you’re new to Excel or looking to sharpen your proficiency, this course guides you through an end‑to‑end learning path that supports immediate on‑the‑job impact.

During the program, you’ll explore the essential interface, create and manage worksheets, and apply powerful formulas and functions. As you progress, you’ll master data validation, conditional formatting, and data analysis tools, equipping you to handle large datasets, automate routine tasks, and produce clean, actionable insights.

Key topics include pivot tables, data cleanup, visual reports, spreadsheet automation, and financial modeling fundamentals, all framed to help you improve productivity and deliver results faster in tasks like reporting, budgeting, and performance tracking.

  • Build and analyze data models with confidence using formulas and functions
  • Create dynamic reports with pivot tables and data visualization
  • Automate routine tasks and standardize processes with efficient workflows
  • Validate data, format consistently, and manage large datasets effectively
  • Develop practical skills applicable to roles in data analysis, finance, project management, and business analysis

Enroll today to elevate your Excel mastery, accelerate your career, and unlock new opportunities across industries that rely on accurate data, clear reporting, and informed decision‑making.

Who Benefits From This Course

  • Individuals seeking to enhance their office productivity skills
  • Business professionals who handle data analysis and reporting
  • Administrative professionals responsible for data management
  • Job seekers aiming to improve their resume with technical skills
  • Entrepreneurs and small business owners who manage their own financial data
  • Students aspiring for a career in data analysis or management
  • Educators needing to track and analyze student data
  • Researchers who work with large datasets
  • Financial analysts who deal with complex financial data
  • Project managers requiring to track and present project data

Frequently Asked Questions

What are the potential career opportunities after mastering Microsoft Excel 2019?
Proficiency in Microsoft Excel 2019 can open up a wide range of career opportunities across various industries. Potential job titles include:
  • Data Analyst
  • Financial Analyst
  • Business Analyst
  • Project Manager
  • Administrative Assistant
  • Accountant
  • Marketing Analyst
These roles leverage Excel skills for data management, financial modeling, reporting, and more, making you a valuable asset to any organization.
What are the key functionalities covered in the Microsoft Excel 2019 training?
This course covers a vast range of Excel's most valuable functionalities, which include but are not limited to:
  • Data entry and formatting
  • Complex formulas
  • Data analysis tools
  • Data validation
  • Conditional formatting
  • Pivot tables
  • Macros
These functionalities ensure you have a well-rounded understanding of Excel's capabilities.
How can proficiency in Excel enhance my analytical skills?
Excel is a powerful tool for data analysis. It allows you to manipulate, analyze, and visualize data, which is crucial for making data-driven decisions. By mastering Excel, you can manage large datasets, leverage formulas to calculate statistics, use conditional formatting to highlight data trends and patterns, create pivot tables for data summarization, and generate charts and graphs for data visualization. These skills not only enhance your analytical capabilities but also improve your problem-solving and decision-making skills, making you a valuable asset in any data-driven role.
Who can benefit from the Microsoft Excel 2019 Training Course?
This course is designed for a wide range of learners. Whether you are a beginner looking to gain a solid foundation in Excel, a professional aiming to enhance your data management skills, a student seeking to improve your proficiency for academic projects, a business analyst, a data scientist, or anyone interested in automating tasks, this course offers valuable insights and practical knowledge for everyone.
Why is Microsoft Excel 2019 considered a valuable skill in the job market?
Microsoft Excel is one of the most widely used spreadsheet applications in the world. It is integral to many business operations, particularly those involving data management, financial modeling, and reporting. Employers across various industries highly value Excel proficiency due to its critical role in data analysis and decision-making. By mastering Excel, you can increase your productivity, enhance your analytical skills, and gain a competitive edge in the job market.

Included In This Course

Module 1: Beginner

  •    1.0 Intro
  •    1.1 The Ribbon
  •    1.2 Saving Files
  •    1.3 Entering and Formatting Data
  •    1.4 Printing from Excel & Using Page Layout View
  •    1.5 Formulas Explained
  •    1.6 Working with Formulas and Absolute References
  •    1.7 Specifying and Using Named Range
  •    1.8 Correct a Formula Error
  •    1.9 What is a Function
  •    1.10 Insert Function & Formula Builder
  •    1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
  •    1.12 Create and Customize Charts

Module 2: Intermediate

  •    2.0 Recap
  •    2.1 Navigating and editing in two or more worksheets
  •    2.2 View options - Split screen, view multiple windows
  •    2.3 Moving or copying worksheets to another workbook
  •    2.4 Create a link between two worksheets and workbooks
  •    2.5 Creating summary worksheets
  •    2.6 Freezing Cells
  •    2.7 Add a hyperlink to another document
  •    2.8 Filters
  •    2.9 Grouping and ungrouping data
  •    2.10 Creating and customizing all different kinds of charts
  •    2.11 Adding graphics and using page layout to create visually appealing pages
  •    2.12 Using Sparkline formatting
  •    2.13 Converting tabular data to an Excel table
  •    2.14 Using Structured References
  •    2.15 Applying Data Validation to cells
  •    2.16 Comments - Add, review, edit
  •    2.17 Locating errors

Module 3: Advanced

  •    3.1 Recap
  •    3.2 Conditional (IF) functions
  •    3.3 Nested condition formulas
  •    3.4 Date and Time functions
  •    3.5 Logical functions
  •    3.6 Informational functions
  •    3.7 VLOOKUP & HLOOKUP
  •    3.8 Custom drop down lists
  •    3.9 Create outline of data
  •    3.10 Convert text to columns
  •    3.11 Protecting the integrity of the data
  •    3.12 What is it, how we use it and how to create a new rule
  •    3.13 Clear conditional formatting & Themes
  •    3.14 What is a Pivot Table and why do we want one
  •    3.15 Create and modify data in a Pivot Table
  •    3.16 Formatting and deleting a Pivot Table
  •    3.17 Create and modify Pivot Charts
  •    3.18 Customize Pivot Charts
  •    3.19 Pivot Charts and Data Analysis
  •    3.20 What is it and what do we use it for
  •    3.21 Scenarios
  •    3.22 Goal Seek
  •    3.23 Running preinstalled Macros
  •    3.24 Recording and assigning a new Macro
  •    3.25 Save a Workbook to be Macro enabled
  •    3.26 Create a simple Macro with Visual Basics for Applications (VBA)
  •    3.27 Outro