Microsoft Excel® 2019

Microsoft Excel® 2019 Module 1
Working with Ranges

In Excel, a range is a group of two or more cells that work together rather than separately.  The range is the basic function that makes Excel a powerful tool, and it is discussed in this module. We start by learning how to fill a range with values, move or copy them, and insert or delete them.  After that we discuss range names and how to use them.  We conclude by discussing how to format fonts, colors, alignments, numbers, column widths, row heights, and other range options.

• Excel’s Ribbon User Interface
• Data Entry
• Cell Formatting
• Working with Columns
• Editing Workbooks

Microsoft Excel® 2019 Module 2
Getting Organized 

Once a range is populated and formatted, it’s time to do something with that data. In this module we discuss how to change page orientation, view your pages in Page Layout view, and how to print all or just some of your worksheets. We move on to discuss how to maintain and manipulate the worksheet, which is where you spend most time in Excel, then you will learn how worksheets and workbooks go together. We describe how to name your cells, find and replace information, and how to categorize and maintain multiple worksheets.

• Previewing Pages
• Printing
• Maintaining the Worksheet
• Multiple Worksheets
• What-If Analyses

Microsoft Excel® 2019 Module 3
Tables, Charts, and Graphics 

Once you have your workbooks and worksheets created, it’s time to do something useful with your new tools. In this module we first discuss the purpose and multiple uses of Pivot tables. Then we dive into the basics of creating professional looking charts and graphics. Finally, we discuss how to set up and work with data lists in Excel, as well as how to link, automate, and share spreadsheets.

• Pivot Tables
• Working with Charts and Graphics
• Creating Data Lists
• Linking, Automating, and Sharing Spreadsheets

Microsoft Excel® 2019 Module 4
Using and Analyzing Data 

In the last module of this course, we explore the do’s and don’ts of working with Excel and we discover important skills required to use Excel successfully. We also discuss how to manage and maintain loads of data and we identify trends in your data.

• Beginner Basics
• Commandments of Excel
• Managing Data
• Analyzing Data