Target Audience: People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 or Excel 365 skills to create and modify spreadsheets. By the end of this course, you will be able to use Excel 2019 or Excel 365 to create your own workbooks and analyze your data.

Instructor: Kathy Jones

Objectives:
• Insert functions into spreadsheets including Logical functions and Conditional functions
• Insert and delete rows and columns
• Apply formatting to text, numbers, and cells including Cell Alignment and Themes
• Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
• Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
• Create and use named ranges
• Create and modify charts
• Quickly find and address errors in your formulas with Tracing

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more.

This course is your first step towards becoming an expert at using Excel 2019. The material is aligned with the Level 1 Beginner TOSA Certification.

Topics covered include:
• Insert functions into spreadsheets including Logical functions and Conditional functions
• Insert and delete rows and columns
• Apply formatting to text, numbers, and cells including Cell Alignment and Themes
• Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
• Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
• Create and use named ranges
• Create and modify charts
• Quickly find and address errors in your formulas with Tracing

Course Length

Lessons : 23
Seat Time : 2 Hours 29 Minutes

Performing Calculations
Inserting Functions 8:10
Using Absolute References 9:51
Formatting Worksheets
Inserting and Deleting Cells 8:50
Applying Text Formats 8:35
Applying Number Formats 7:24
Aligning Cell Contents 7:17
Applying Themes 3:48
Using Templates 6:01
Printing Workbooks
Setting the Page Layout 6:34
Inserting Page Breaks 8:38
Configuring Headers and Footers, Part 1 5:09
Configuring Headers and Footers, Part 2 4:04
Managing Workbooks
Managing Worksheets, Part 1 5:02
Managing Worksheets, Part 2 7:39
Creating a Custom View 3:47
Working with Functions
Using Named Ranges 5:25
Working with Logical Functions 8:36
Working with Conditional Functions 7:33
Other
Sorting Data 5:18
Creating Charts 5:37
Using Chart Types 2:27
Tracing Formulas 6:22
Addressing Formula Errors 7:16