Overview:
In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets using Excel 2019 or Excel 365.
Audience:
Students who have little or no familiarity with Microsoft Excel 2019 or more experienced Excel users who want to learn the topics covered in this course in the 2019 interface.
Pre-Requisite:
Experience in the following is required for this Microsoft Excel class:
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Windows environment.
- Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Course Curriculum
Creating a Microsoft Excel Workbook | |||
Starting Microsoft Excel Details | 00:00:00 | ||
Creating a Workbook Details | 00:00:00 | ||
Saving a Workbook Details | 00:00:00 | ||
The Status Bar Details | 00:00:00 | ||
Adding and Deleting Worksheets Details | 00:00:00 | ||
Copying and Moving Worksheets Details | 00:00:00 | ||
Changing the Order of Worksheets Details | 00:00:00 | ||
Splitting the Worksheet Window Details | 00:00:00 | ||
Closing a Workbook Details | 00:00:00 | ||
Creating a Microsoft Excel Workbook Details | 00:00:00 | ||
The Ribbon | |||
Tabs Details | 00:00:00 | ||
Groups Details | 00:00:00 | ||
Commands Details | 00:00:00 | ||
Exploring the Ribbon Details | 00:00:00 | ||
The Backstage View (The File Menu) | |||
Introduction to the Backstage View Details | 00:00:00 | ||
Opening a Workbook Details | 00:00:00 | ||
Open a Workbook Details | 00:00:00 | ||
New Workbooks and Excel Templates Details | 00:00:00 | ||
Select, Open and Save a Template Agenda Details | 00:00:00 | ||
Printing Worksheets Details | 00:00:00 | ||
Print a Worksheet Details | 00:00:00 | ||
Adding Your Name to Microsoft Excel Details | 00:00:00 | ||
Adding a Theme to Microsoft Excel Details | 00:00:00 | ||
The Quick Access Toolbar | |||
Adding Common Commands Details | 00:00:00 | ||
Adding Additional Commands with the Customize Dialog Box Details | 00:00:00 | ||
Adding Ribbon Commands or Groups Details | 00:00:00 | ||
Placement Details | 00:00:00 | ||
Customize the Quick Access Toolbar Details | 00:00:00 | ||
Entering Data in Microsoft Excel Worksheets | |||
Entering Text Details | 00:00:00 | ||
Adding and Deleting Cells Details | 00:00:00 | ||
Adding a Hyperlink Details | 00:00:00 | ||
Add WordArt to a Worksheet Details | 00:00:00 | ||
Using AutoComplete Details | 00:00:00 | ||
Entering Text and Using AutoComplete Details | 00:00:00 | ||
Entering Numbers and Dates Details | 00:00:00 | ||
Using the Fill Handle Details | 00:00:00 | ||
Entering Numbers and Dates Details | 00:00:00 | ||
Formatting Microsoft Excel Worksheets | |||
Selecting Ranges of Cells Details | 00:00:00 | ||
Hiding Worksheets Details | 00:00:00 | ||
Adding Color to Worksheet Tabs Details | 00:00:00 | ||
Adding Themes to Workbooks Details | 00:00:00 | ||
Customize a Workbook Using Tab Colors and Themes Details | 00:00:00 | ||
Adding a Watermark Details | 00:00:00 | ||
The Font Group Details | 00:00:00 | ||
Working with Font Group Commands Details | 00:00:00 | ||
The Alignment Group Details | 00:00:00 | ||
Working with Alignment Group Commands Details | 00:00:00 | ||
The Number Group Details | 00:00:00 | ||
Working with Number Group Commands Details | 00:00:00 | ||
Using Formulas in Microsoft Excel | |||
Math Operators and the Order of Operations Details | 00:00:00 | ||
Entering Formulas Details | 00:00:00 | ||
AutoSum (and Other Common Auto-Formulas) Details | 00:00:00 | ||
Copying Formulas and Functions Details | 00:00:00 | ||
Relative, Absolute, and Mixed Cell References Details | 00:00:00 | ||
Working with Formulas Details | 00:00:00 | ||
Working with Rows and Columns | |||
Inserting Rows and Columns Details | 00:00:00 | ||
Deleting Rows and Columns Details | 00:00:00 | ||
Transposing Rows and Columns Details | 00:00:00 | ||
Setting Row Height and Column Width Details | 00:00:00 | ||
Hiding and Unhiding Rows and Columns Details | 00:00:00 | ||
Freezing Panes Details | 00:00:00 | ||
Working with Rows and Columns Details | 00:00:00 | ||
Editing Worksheets | |||
Find Details | 00:00:00 | ||
Find and Replace Details | 00:00:00 | ||
Using Find and Replace Details | 00:00:00 | ||
Using the Clipboard Details | 00:00:00 | ||
Using the Clipboard Details | 00:00:00 | ||
Using Format Painter Details | 00:00:00 | ||
Managing Comments Details | 00:00:00 | ||
Finalizing Microsoft Excel Worksheets | |||
Setting Margins Details | 00:00:00 | ||
Setting Page Orientation Details | 00:00:00 | ||
Setting the Print Area Details | 00:00:00 | ||
Print Scaling (Fit Sheet on One Page) Details | 00:00:00 | ||
Printing Headings on Each Page/Repeating Headers and Footers Details | 00:00:00 | ||
Headers and Footers Details | 00:00:00 | ||
Preparing to Print Details | 00:00:00 |
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED