LCT0014 - Introduction to Excel 2019
Course Description
This course has been revised. Starting August 2024 the title is Excel Part 1 (Microsoft 365).
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.
Note: Summer 2024 is the last time Community Education will be offering Excel 2019. Starting in August, we will be moving to Microsoft 365.
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.