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
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.
Assessment Guide
| Assessment | Points |
|---|---|
| My Excel Experience | 1 points |
| Lesson 1 Quiz | 9 points |
| Lesson 2 Quiz | 9 points |
| Lesson 3 Activity Assignment | 1 points |
| Lesson 3 Quiz | 10 points |
| Lesson 4 Activity Assignment | 1 points |
| Lesson 4 Quiz | 10 points |
| Lesson 5 Activity Assignment | 1 points |
| Lesson 5 Quiz | 10 points |
| Lesson 6 Activity Assignment | 1 points |
| Lesson 6 Quiz | 10 points |
| Lesson 7 Activity Assignment | 1 points |
| Lesson 7 Quiz | 10 points |
| Lesson 8 Activity Assignment | 1 points |
| Lesson 8 Quiz | 10 points |
| Lesson 9 Activity Assignment | 1 points |
| Lesson 9 Quiz | 10 points |
| Lesson 10 Activity Assignment | 1 points |
| Lesson 10 Quiz | 10 points |
| Lesson 11 Activity Assignment | 1 points |
| Lesson 11 Quiz | 10 points |
| Lesson 12 Quiz | 9 points |
| Lesson 13 Activity Assignment | 1 points |
| Lesson 13 Quiz | 10 points |
| Lesson 14 Quiz | 10 points |
| Lesson 15 Quiz | 9 points |
| The Final Exam | 70 points |
Microsoft Word Level 1
How to Upload and Share Files in Slack
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Excel Courses
Microsoft Project Level 1
Understanding HTML5 and Web Design
Business Writing Courses
Benefits and Setting Up MySQL Replication
Using the SUM, AVG, COUNT, MIN, MAX Operators in SQL
QuickBooks Courses
Introduction to SQL
Communications Courses
Computer Literacy Level 2 - Internet Basics
Database Design in MySQL
Operations Management Courses
Microsoft Word Courses
Ultimate Excel Training Bundle
Learn How to Create a Slack Server
Loading...
