Learning Excel 2019 – Productive (TOSA)
Course Description:
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 3 Productive TOSA Certification.
Why “Learning Excel 2019 – Productive (TOSA)” Matters:
• 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
