LCT0014 - Introduction to Excel 2019
202651
Delivery Options
LEL-Lecture-lab.
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
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019
- Microsoft Office 2019 Administrator Digital Badge : Microsoft Office 2019 Administrator Digital Badge
Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .