Course Syllabus


 
 

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

Learning Outcomes

By successfully completing this course, students will be able to:
  • Demonstrate the ability to create, save, and navigate an Excel spreadsheet, while utilizing basic features such as the Quick Access Toolbar and menu ribbon.
  • Recognize and describe the basic components of Microsoft Excel's interface, including rows, columns, cells, and ribbon tabs.
  • Define the difference between a worksheet and a workbook in Excel by providing examples of each.
  • Demonstrate how to perform basic mathematical operations using Excel formulas, including referencing cells for dynamic calculations.
  • Define the process of formatting numeric data in Excel by using specific number templates to control the display of decimals and currency symbols.
  • Demonstrate how to apply various cell styles in Excel, including font changes, text alignment, and cell colorization, to enhance the spreadsheet's visual appeal.
  • Recognize and apply Excel's protection features to restrict access, edit ranges, and safeguard workbook integrity, ensuring data security in collaborative environments.
  • Define and demonstrate the process of referencing both internal worksheets and external workbooks in Excel by correctly applying the appropriate syntax.
  • Demonstrate the ability to create and utilize Excel formulas using both relative and absolute cell references and properly manage order of operations using parentheses.
  • Recognize and utilize the SUM, AVERAGE, and COUNT functions in Excel to perform data calculations within various ranges of cells.
  • Analyze various financial outcomes using Excel's Scenario Manager by creating at least two different scenarios with provided data sets.
  • Utilize Excel's Goal Seek function to determine necessary variable adjustments to achieve a specific financial target, such as desired monthly payments.
  • Identify the steps required to insert an image from local storage or online into an Excel spreadsheet using the 'Insert' tab's 'Illustrations' menu.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
Motives for Taking this Course 2 points
Lesson 1 Quiz 9 points
Lesson 2 Quiz 9 points
Lesson 3 Quiz 10 points
Lesson 4 Quiz 10 points
Lesson 5 Quiz 10 points
Lesson 6 Quiz 10 points
Lesson 7 Quiz 10 points
Lesson 8 Quiz 10 points
Lesson 9 Quiz 10 points
Lesson 10 Quiz 10 points
Lesson 11 Quiz 10 points
Lesson 12 Quiz 9 points
Lesson 13 Quiz 10 points
Lesson 14 Quiz 10 points
Lesson 15 Quiz 9 points
The Final Exam 70 points
Business Writing Courses
Business Writing Courses
Microsoft Word Courses
Microsoft Word Courses
How to Bank Online with QuickBooks Online Version
How to Bank Online with QuickBooks Online Version
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Adaptations Required with the Development of Social Networks
Adaptations Required with the Development of Social Networks
Communications Courses
Communications Courses
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
How to Manage Loans in QuickBooks Online Version
How to Manage Loans in QuickBooks Online Version
Using the DELETE Statement in SQL
Using the DELETE Statement in SQL
How to Maintain Your QuickBooks Files
How to Maintain Your QuickBooks Files
The Use of Twitter for Marketing Strategies
The Use of Twitter for Marketing Strategies
Computer Literacy Level 3 - Living and Working Online
Computer Literacy Level 3 - Living and Working Online
Operations Management Courses
Operations Management Courses
Learn HTML - Create Webpages Using HTML5
Learn HTML - Create Webpages Using HTML5
QuickBooks Courses
QuickBooks Courses
Microsoft Excel Courses
Microsoft Excel Courses
Computer Literacy Level 2 - Internet Basics
Computer Literacy Level 2 - Internet Basics
Introduction to SQL
Introduction to SQL