Learning Excel 2019 – Productive (TOSA)
You are not yet enrolled in this course.
-
Use productivity tools like Flash Fill, Search and Replace, and Proofing and Researching tools
Apply advanced Conditional Formatting and Comparative Analysis Formatting to make it easy to read and analyze your data - Use multiple View features to compare multiple workbooks and compare worksheets
- Sort and filter column data
- Create, modify, and format charts and tables and create a Pivot Table to group and summarize data.
- Use multiple worksheets and workbooks to track, retrieve, and report on data using features Group Mode and 3D Reference formulas.
- Collaborate with others using Comments and Track Changes
- Prepare a workbook for sharing by checking for accessibility and sensitive information
- Use forecasting and data analysis tools like Goal Seek and Sparklines
- Visualize geographic data with Map Charts and 3D Map Tours
- Work with external data, including importing and exporting data and using a Web Query to access data on a website
There are two kinds of people: Those who are masters in 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 skill sets 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 3 Productive TOSA Certification.
Topics covered include:
- Using productivity tools
- Applying advanced Conditional Formatting
- Comparing multiple workbooks or worksheets
- Creating and formatting charts, tables, and PivotTables
- Using Comments and Track Changes
- Preparing a workbook for sharing
- Using data analysis tools like Goal Seek and Sparklines
- Visualizing geographic data
- Working with external data
Over three hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!
Â