Loading...

Course Description

Discover how to create and develop worksheets and workbooks in order to work with and analyze data. Topics include calculations, modifying and formatting a worksheet and managing workbooks. Workbook included.

Course Outline

Lesson 1: Getting Started with Excel 2019

 Topic A: Navigate the Excel User Interface

 Topic B: Use Excel Commands

 Topic C: Create and Save a Basic Workbook

 Topic D: Enter Cell Data

 Topic E: Use Excel Help

Lesson 2: Performing Calculations

 Topic A: Create Worksheet Formulas

 Topic B: Insert Functions

 Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

 Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

 Topic B: Search for and Replace Data

 Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

 Topic A: Apply Text Formats

 Topic B: Apply Number Formats

 Topic C: Align Cell Contents

 Topic D: Apply Styles and Themes

 Topic E: Apply Basic Conditional Formatting

 Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

 Topic A: Preview and Print a Workbook

 Topic B: Set Up the Page Layout

 Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

 Topic A: Manage Worksheets

 Topic B: Manage Workbook and Worksheet Views

 Topic C: Manage Workbook Properties

Learner Outcomes

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will:

  • Get started with Microsoft Office Excel 2019.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Prerequisites

Knowledge of Windows and Word.

Applies Towards the Following Certificates

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .