Learning Excel 365 – Advanced (TOSA)

Objectives. be able:

• Make and use ranges with names.
• Make custom and advanced filters
• Use more advanced charting tools and make a chart template.
• Make a Pivot Table and use advanced Pivot Table features, as well as Slicers and Timelines to filter data.
• Use Co-Authoring and Compare and Merge to work with others.
• Use Data Validation to make sure your data is consistent and accurate, and use Macros to do things for you quickly.
• Make it easy to navigate, change, and enter data with Forms and Form Controls.

Those who know how to use Excel 2019 or Excel 365, and those who wish they were.

When you learn how to use Excel 2019 or Excel 365, you have one of the most important and useful skills in business today. A spreadsheet expert can do a lot of things, from organizing lists to making multi-layered, interactive reports to answering important business questions about ROI, budget allocations, expense tracking, and more.

If you want to become an expert at using Excel 2019, this class will help you get there.

Covered topics are:

• With Named Ranges:
• Adding complex functions (Date, Time, Conditional, Database, Lookup)
• Using the more advanced filtering
• In order to use more advanced chart features, you need to
• Adding and changing graphics
• Making PivotTables and using PivotTable features that are more advanced.
• Creating links to both inside and outside of your own company
• When you paste something, you can use Paste Special to make it look like it was
• Putting together data
• Writing together and using Compare and Merge
• Putting Digital Signatures on them
• Make sure workbooks and worksheets aren’t lost or stolen
• If you want to make sure that your data is correct, use Data Validation
• In this case, you can use Goal Seek.
• Putting symbols and characters in
• When you work with forms

In the “Uniquely Engaging” TM Bigger Brains style, there are over five hours of high-quality HD videos.