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...
Enroll Now - Select a section to enroll in
Section Title
Excel 2019 Level 1
Type
Online
Days
T
Time
6:30PM to 9:30PM
Dates
Mar 07, 2023 to Mar 21, 2023
Schedule and Location
Contact Hours
9.0
Course Fee(s)
Course Fee non-credit $191.00
Drop Request Deadline
Feb 28, 2023
Transfer Request Deadline
Feb 28, 2023
Section Title
Excel 2019 Level 1
Type
Lecture
Days
T, Th
Time
11:00AM to 2:00PM
Dates
Apr 04, 2023 to Apr 11, 2023
Schedule and Location
Contact Hours
9.0
Course Fee(s)
Course Fee non-credit $191.00
Drop Request Deadline
Mar 28, 2023
Transfer Request Deadline
Mar 28, 2023
Section Title
Excel 2019 Level 1
Type
Lecture
Days
Sa
Time
9:00AM to 12:00PM
Dates
Apr 15, 2023 to Apr 29, 2023
Schedule and Location
Contact Hours
9.0
Course Fee(s)
Course Fee non-credit $191.00
Drop Request Deadline
Apr 08, 2023
Transfer Request Deadline
Apr 08, 2023
Instructors
Required fields are indicated by .