Loading...

Course Description

Become an expert in data manipulation using Excel spreadsheets. Organizations rely on information to make sound business decisions. The amount of available data growing on a daily basis, there is an urgent need to make sense of all of that data. Learn how to organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction.This course provides a foundation for Excel knowledge and skills. PREREQUISITE: Introduction to Microsoft Windows or equivalent experience.

 

Course Outline

  • Lesson 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
  • Lesson 2: Performing Calculations
    • Create Worksheet Formulas
    • Insert Functions
    • Reuse Formulas and Functions
  • Lesson 3: Modifying a Worksheet
    • Insert, Delete, and Adjust Cells, Columns, and Rows
    • Search for and Replace Data
    • Use Proofing and Research Tools
  • Lesson 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
  • Lesson 5: Printing Workbooks
    • Preview and Print a Workbook
    • Set Up the Page Layout
    • Configure Headers and Footers
  • Lesson 6: Managing Workbooks
    • Manage Worksheets
    • Manage Workbook and Worksheet Views
    • Manage Workbook Properties

Learner Outcomes

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

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to Excel 2019
Type
In-Person
Days
M, W
Time
5:30PM to 8:30PM
Dates
Apr 01, 2024 to Apr 03, 2024
Schedule and Location
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $259.00 Click here to get more information
Instructors
Section Title
Introduction to Excel 2019
Type
In-Person
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Apr 09, 2024 to Apr 11, 2024
Schedule and Location
Contact Hours
6.0
Course Fee(s)
Tuition and Fees non-credit $259.00 Click here to get more information
Instructors
Section Title
Introduction to Excel 2019
Type
In-Person
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Jun 25, 2024 to Jun 27, 2024
Schedule and Location
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $259.00 Click here to get more information
Instructors
Section Title
Introduction to Excel 2019
Type
In-Person
Days
M, W
Time
5:30PM to 8:30PM
Dates
Jul 01, 2024 to Jul 03, 2024
Schedule and Location
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $259.00 Click here to get more information
Instructors
Required fields are indicated by .