Online Class: Excel 2019

In Excel 2019, users learn to craft sophisticated spreadsheets by mastering techniques such as data input, formula application, and chart creation. This course highlights essential features, advanced tools like pivot tables, and VBA, supported by interactive lessons, making learners adept in transforming data into actionable insights.
$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 15
    Lessons
  • 17
    Exams &
    Assignments
  • 26
    Students
    have taken this course
  • 12
    Hours
    average time
  • 1.2
    CEUs
 
 
 

Course Description

Excel 2019 is the latest iteration of the popular spreadsheet software developed by Microsoft. Excel allows users to create rich, stylized spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually appealing content that represents your data. Before you start using Excel though, you should first learn what all the features Excel offers are and how to use them, so that your spreadsheets are built correctly the first time.

In this course, you're going to learn how to...
  • Create spreadsheets
  • Format cells, rows, columns, and entire worksheets so they fit and match your data
  • Enter data into a spreadsheet
  • Use formulas and functions for math, accounting, and totaling
  • Create formulas and functions
  • Calculate data
  • Create charts and diagrams for your data
  • Create data lists and forms
  • Create and use pivot tables and pivot charts
  • Work with Excel templates
  • Share and protect your worksheets and workbooks
  • Use What-If Analysis to determine possible outcomes
  • And much more!
 
The first few lessons explain how to use Excel core features such as formatting rules and techniques. We then move on to formulas. Formulas are the foundation for most basic and complex spreadsheets that store data. Formulas allow you to automatically calculate results based on any number of variables including information stored in your rows, columns and cells. Once we learn how to use formulas, we'll move on to scenarios, pivot tables and what-if charts. These advanced tools allow you to track your reports and create projections for your business.

Nowadays, your Excel spreadsheet should include at least one chart, so we have step-by-step tutorials on charting, graphics, and using images. All these added components help make spreadsheets more visually appealing. We also review ways to use common functions as well as sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.

The final lesson introduces you to Visual Basic for Applications (VBA).  VBA is a powerful language used to make macros. We will show you how to create simple recorded macros as well as how to edit macros for more complex applications. 
 
With clear and concise step-by-step directions, beautifully illustrated lessons with screenshots, and HD Video tutorials, this Excel 2019 online course will teach you everything you need to know to become an Excel power user.
 
Note: You do not need access to Excel software in order to successfully complete this course, although it is strongly recommended in order to follow along with the course examples. 
Courses Frequently Bought Together:
  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 
 

Course Lessons

Average Lesson Rating:
4.31 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(8,174 votes)

Lesson 1. Navigating the World of Microsoft Excel: From Basics to Mastery

Microsoft Excel empowers users to efficiently manage, calculate, and visualize data, offering seamless integration with other Microsoft Office tools like Word and Outlook. Understanding basic navigation and the ribbon interface enhances productivity, making Excel a versatile tool for both personal and professional use. 11 Total Points
  • Lesson 1 Video
  • Review Practice Worksheet: 9770516rz57137.png
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Motives for Taking this Course
  • Assessment: Lesson 1 Quiz

Lesson 2. Entering Data with Precision in Excel

Excel distinguishes between a worksheet and a workbook, allowing users to organize multiple sheets within a single file, enabling seamless data connections and enhanced calculations. Entering and formatting data properly, including overriding default settings, ensures accurate representations of text, values, and formulas which are crucial for effective Excel usage. 9 Total Points
  • Lesson 2 Video A
  • Lesson 2 Video B : Entering Data
  • Assessment: Lesson 2 Quiz

Lesson 3. Excel Beyond Basics: Mastering Cell Formatting and Styling

Excel simplifies data presentation by automatically formatting strings and numbers and providing template options for consistent numeric display. Users can leverage cell, font, and alignment styles to enhance visual appeal and structure, including custom formats for specific needs. 10 Total Points
  • Lesson 3 Video
  • Assessment: Lesson 3 Quiz

Lesson 4. Excel Editing Essentials

Editing Excel cells involves replacing values and adjusting formats, which may be necessary to keep data accurate and relevant; Excel's formulas automatically update to reflect changes and can reference external sheets and workbooks for comprehensive data management. Teams can enhance collaboration by leaving comments, protecting cells, and managing specific edit permissions, ensuring data integrity and controlled access. 10 Total Points
  • Lesson 4 Video
  • Assessment: Lesson 4 Quiz

Lesson 5. Excel Formula Fundamentals

Using Excel's function lookup assists in identifying and leveraging various built-in functions, such as COUNT and ROUND, with proper parameter syntax, helping users to avoid errors in spreadsheets. This becomes crucial when embedding multiple functions within a single cell to perform complex calculations. 10 Total Points
  • Lesson 5 Video A
  • Lesson 5 Video B : Formulas and Calculations
  • Assessment: Lesson 5 Quiz

Lesson 6. Excel's What-If Tools: A Quick Overview

What-If Analysis in Excel simplifies the exploration of potential results by allowing dynamic adjustments without programming skills. Utilizing Scenarios, Goal Seek, and Data Tables can vastly improve your ability to foresee financial impacts and make informed decisions. 10 Total Points
  • Lesson 6 Video
  • Assessment: Lesson 6 Quiz

Lesson 7. Mastering Excel's Graphic Features

Lesson Summary 2 10 Total Points
  • Lesson 7 Video A
  • Lesson 7 Video B : Working with Graphics
  • Assessment: Lesson 7 Quiz

Lesson 8. Crafting Compelling Charts in Excel

With Excel's charting tools, users can transform static data into dynamic visualizations, choosing from diverse types like pie, bar, or line charts. These tools simplify data analysis by providing recommendations and easy data integration, while allowing extensive customization. 10 Total Points
  • Lesson 8 Video A
  • Lesson 8 Video B : Working with Charts and Diagrams
  • Assessment: Lesson 8 Quiz

Lesson 9. Mastering Excel's Data Validation: Create Efficient Dropdowns

By configuring dropdown lists in Excel, users can choose from predefined data, reducing errors and improving efficiency in data entry tasks, with options to utilize either internal or external data sources. The data validation tool provides flexibility, enabling custom instructions and error messages to guide users in maintaining accurate and compliant data input. 10 Total Points
  • Lesson 9 Video A
  • Lesson 9 Video B : Managing Data
  • Assessment: Lesson 9 Quiz

Lesson 10. Dynamic Data Analysis with Pivot Tables

A pivot table turns static data into an adaptable analysis tool, providing diverse insights and answers by restructuring the dataset. Excel's SUM function complements this by enabling straightforward calculation of totals, enhancing the depth of data examination. 10 Total Points
  • Lesson 10 Video
  • Assessment: Lesson 10 Quiz

Lesson 11. Harness the Power of Templates and Macros in Excel

Microsoft Excel 2019 comes equipped with diverse templates for swift handling of common tasks and calculations, thus speeding up the workflow significantly. Paired with cleverly created macros, it turns the often redundant manual operations into efficient automated actions, albeit with cautious usage due to potential security concerns. 10 Total Points
  • Lesson 11 Video
  • Assessment: Lesson 11 Quiz

Lesson 12. Direct Database Connections: Excel Meets Access

With Excel, users can convert data from CSV files or databases for integration into spreadsheets, supporting diverse analytical needs. This tutorial guides through data transfer techniques from Microsoft Access to Excel, emphasizing on CSV exports and dynamic database queries. 9 Total Points
  • Lesson 12 Video
  • Assessment: Lesson 12 Quiz

Lesson 13. Excel Essentials: Sort and Filter Data

Excel's sorting feature simplifies data organization by allowing users to order data in ascending or descending sequence, while conditional formatting emphasizes specific cell values to improve data visibility, saving time during data evaluation tasks. 10 Total Points
  • Lesson 13 Video
  • Assessment: Lesson 13 Quiz

Lesson 14. Date, Time, and Text Functions

Master Excel with versatile functions like IF for conditional logic, NOW for current timestamps, and CONCAT for text processing, enhancing productivity and precision. These functions simplify complex tasks, allowing users to focus on data-driven decision-making. 10 Total Points
  • Lesson 14 Video
  • Assessment: Lesson 14 Quiz

Lesson 15. Mastering VBA: Unlocking Excel's Potential

VBA integrates seamlessly into Microsoft Office, allowing users to enhance Excel spreadsheets with custom functionalities and automation. To start using VBA, enable the 'Developer' tab, which provides access to coding tools and controls like buttons that can execute programmed macros. 79 Total Points
  • Lesson 15 Video
  • Lesson discussions: End of Course Poll; Course Comments; Reasons for Taking this Course
  • Assessment: Lesson 15 Quiz
  • Assessment: The Final Exam
218
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what a spreadsheet is and what Excel's capabilities are.
  • Demonstrate working with worksheets, workbooks and entering data in Excel.
  • Demonstrate formatting cells and data.
  • Demonstrate using formulas and calculations in Excel.
  • Demonstrate creating and using What-If Analysis tool.
  • Demonstrate adding images and graphics.
  • Demonstrate creating charts and diagrams.
  • Demonstrate creating data lists and managing data.
  • Demonstrate creating and using Pivot Tables and Charts.
  • Describe techniques for sorting and filtering data.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Excel 2019
Course Number: 9770516
Lessons Rating: 4.31 / 5 Stars (8,174 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: Accessible from any state in the U.S., this course covers key areas such as California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. The course is also offered in English-speaking nations like Australia, Canada, the UK, and South Africa.
Last Updated: April 2024
Course Type: Self-Paced, Online Class
CEU Value: 1.2 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Proctor: UniversalClass Instructional Team
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
for 6 months
 
Add to Cart
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$120
for 6 months
 
Add to Cart
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+
 

Student Testimonials

  • "This course was very informative and I learned so much and I am lot more comfortable using Microsoft Excel." -- Rachel S.
  • "I thought I knew a lot about Excel until taking this course. I learned so many fun and new things. I can't wait to get creating!" -- Erica J.
  • "I felt this course was very helpful for me. Not knowing anything about excel before starting the course, I feel I have a much better understanding of its functions and capabilities now. I also feel a much greater confidence in applying knowledge of this program within my skills and experience." -- Tess H.
  • "I thought this course was beneficial. I never used Excel for much more than adding and subtracting. However, I have a great new understanding of the possibilities of this program now. I have done a cool project using Excel since starting this class and am interested in going further. Thank you." -- Daryl S.
  • "Taking the Microsoft Excel course was something that was long overdue, and this course in particular met my needs and expectations. It was helpful in learning basic actions more thoroughly, as well as more newfound advanced features I was eager to comprehend. The theme of each lessons were explained well and I am looking forward to putting my knowledge of Excel to good use." -- Jadah N.
  • "This course was very helpful and easy to follow. I hope that I can use these skills to help me get some freelance work in Data Entry." -- Carrima H.
  • "Thoroughly enjoyed the course, feel like I gained a lot of knowledge and that I am better prepared to use Excel in my work." -- Claire S.
  • "This was more than I needed for what I do but I loved learning all the added features. Nice to put on your resume that you are familiar with the concepts." -- Crystle S.
  • "This course was very helpful and informative; so much so that I will be taking the Advanced Excel court in the near future." -- Antoinette M.
  • "It was very helpful. Some lessons were just a refresher and some were on topics I knew nothing about." -- Lindsey S.
View More Testimonials...
 

Related Courses