Desktop Applications

Excel 2019 Beginner

Beginner
6h

By: Ryan Stebbins

Overview

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Modules

1. Introduction

1.1 Excel 2019 Beginner Introduction1 min

2. Getting Started with Excel

2.1 What is Excel4 min
2.2 Opening Excel7 min
2.3 Navigating the Excel User Interface10 min
2.4 Using the Excel Ribbon7 min
2.5 Understanding Excel Worksheet Components7 min
2.6 Using the Backstage View9 min

3. Creating Workbooks and Using Templates

3.1 Creating a New Workbook6 min
3.2 Creating Workbooks Using Templates3 min
3.3 Saving an Excel Workbook5 min
3.4 Using the Accessibility Checker4 min

4. Entering Data

4.1 Navigating a Worksheet by Mouse or Keyboard5 min
4.2 Understanding Excel Data Types6 min
4.3 Using the Inking Tools6 min
4.4 Working with Cell and Range Addressing3 min
4.5 Using Various Data Selection Techniques3 min
4.6 Working with Common Excel Commands5 min
4.7 Using the Autofill Handle4 min
4.8 Using Flash Fill2 min

5. Excel Formula Basics

5.1 What are Formulas and Functions4 min
5.2 Understanding the Components of a Formula6 min
5.3 Understanding Calculation Hierarchy and the Order of Operations3 min
5.4 Creating Basic Formulas3 min
5.5 Working with Basic Functions and AutoSum6 min
5.6 Using Cell References5 min
5.7 Using the Quick Analysis Tools3 min

6. Adjusting a Worksheet

6.1 Modifying Columns and Rows6 min
6.2 Hiding and Unhiding Columns and Rows4 min

7. Formatting and Aligning a Worksheet

7.1 Formatting and Aligning Data11 min
7.2 Merging Data8 min
7.3 Wrapping Text and Adjusting Orientation7 min
7.4 Formatting Numbers8 min
7.5 Using Borders and Shading7 min
7.6 Using the Format Painter4 min
7.7 Removing Formatting Quickly5 min

8. Using Cell Styles and Themes

8.1 Using Cell Styles6 min
8.2 Applying Themes4 min

9. Inserting Objects and Graphics

9.1 Inserting and Formatting Images6 min
9.2 Inserting and Formatting Shapes6 min
9.3 Inserting and Formatting SmartArt9 min
9.4 Working with Icons6 min
9.5 Working with 3-D Models5 min
9.6 Inserting Screenshots5 min
9.7 Inserting Hyperlinks5 min
9.8 Inserting Symbols and Equations5 min
9.9 Inserting WordArt and Text Boxes8 min
9.10 Inserting Other Excel Objects6 min
9.11 Arranging Objects5 min

10. Proofing a Workbook

10.1 Using Find and Replace3 min
10.2 Using Go To and Go To Special3 min
10.3 Using the Spell Checker5 min
10.4 Using the Thesaurus and Translation Features5 min

11. Printing an Excel File

11.1 Printing and Previewing Excel Files5 min
11.2 Creating Custom Margins and Scaling5 min
11.3 Adding Headers and Footers5 min
11.4 Exporting to PDF and XPS4 min

12. Managing Worksheets

12.1 Renaming and Coloring Worksheet Tabs4 min
12.2 Adding, Deleting, and Navigating Worksheets5 min

13. Navigating and Viewing Excel Files

13.1 Viewing Workbooks5 min
13.2 Using Zoom Tools2 min
13.3 Configuring Sheet Options4 min
13.4 Using the Freeze Panes and Split Commands6 min
13.5 Working with Window Commands3 min
13.6 Adjusting Workbook Properties6 min

14. Conclusion

14.1 Excel 2019 Beginner Recap1 min

Ready to Elevate Your Team's Learning?

Talk with our sales team to see how StormWind can transform the way your organization trains and grows.

CONTACT SALES