Microsoft® Office Excel® 2019: Part 1 Training

The course is intended to offer learners with foundational knowledge for Excel that can be utilized to become an expert in data recording. The course covers the Office Specialist Program to help students effectively prepare for the certification exam.

• Getting started with Office Excel 2019.
• Performing calculations.
• Modifying a worksheet.
• Formatting a worksheet.
• Printing workbooks.
• Managing workbooks.

The course is for students wishing to gain foundational knowledge of Microsoft Office Excel necessary for creating and working with electronic spreadsheets.

• 1. Getting Started with Excel 2019
• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
View Less    View More   
2. Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
3. Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
4. Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
5. Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
6. Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties