Learning Excel 2019 – Basics (TOSA)

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
What you'll learn
Perform calculations and work with basic functions including logical functions and conditional functions
Insert and delete cells, rows, and columns
Apply formatting to text, numbers, and cells including cell alignment and themes
Use Page Layout options to insert page breaks and adjust 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
Find and address errors in your formulas by using auditing tools
Requirements
Basic knowledge of Excel
Description
Objectives. You will be able to:
· 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 will get you one step closer to becoming an expert at using Excel 2019. The material is aligned with the Level 2 Basics TOSA Certification.
Topics covered include:
· Performing calculations
· Formatting data
· Managing multiple worksheets
· Working with named ranges
· Inserting functions
· Sorting data
· Inserting charts
· Auditing formulas
Over two hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Who this course is for:
People who are preparing for TOSA certification and have a basic knowledge of Microsoft® Windows® and want to learn basic Excel 2019 or Excel 365 skills to create and modify spreadsheets.

More Info