Learning Excel 2019 – Advanced (TOSA)
You are not yet enrolled in this course.
- Create and use named ranges
- Insert functions into spreadsheets, including Date and Time, Conditional, Database, Lookup, and Subtotals.
- Perform custom and advanced filtering
- Apply advanced charting tools and create a chart template
- Create a Pivot Table and apply advanced Pivot Table features, as well as filter data using Slicers and Timelines
- Use multiple worksheets and workbooks to track, retrieve, consolidate, and report on data using features like cell links and Consolidate
- Collaborate with others using Co-Authoring and Compare and Merge
- Prepare a document for sharing by adding a digital signature, as well as use multiple ways to protect your worksheets and workbooks from changes
- Keep your data consistent and accurate with Data Validation and automate tasks with Macros
- Provide quick and easy access to navigate, modify, and enter data using Forms and Form Controls
There are two kinds of people in the world: A handful of people who are masters of Excel and millions of others who wish they were.
When you master Excel, you have one of the most practical and valuable skill sets in modern business. A spreadsheet expert can work wonders—from organizing lists to creating multi-layered interactive reports, answering critical business questions, managing budget allocations, and tracking expenses.
Take this course, and you’ll be one step closer to becoming an expert at using Excel 2019. You’ll work with more complex features and functions of Excel and acquire a skillset to handle large tables and databases. Learn to use customized sorting and filters to extract data, so you can quickly review and manage your data. The Level 4 Advanced User TOSA Certification aligns with the material in these modules.