Introduction to Spreadsheets - Part 2

Building upon the groundwork laid in the previous session, Introduction to Spreadsheets - Part 2 elevates your Microsoft Excel proficiency by exploring intermediate tools designed to maximize data efficiency and analysis. Led by David Ringshaw, CPA, this course transitions from basic data entry to powerful techniques for managing, visualizing, and summarizing large datasets. By moving beyond simple cells and formulas, learners will discover how to make their spreadsheets smarter and self-updating, significantly reducing the time spent on repetitive maintenance.

This course covers a broad spectrum of functionalities available in Microsoft 365, focusing on transforming static data into dynamic, useful information. You will delve into essential cleanup tools, sophisticated sorting methods, and the robust capabilities of Excel Tables and PivotTables. Additionally, the course introduces modern AI-based features and critical safety measures to protect and audit your work.

Key topics covered in this course include:

• Data Cleanup and Transformation: Mastering tools like Text to Columns and Flash Fill to separate or combine text, and understanding the nuances of Find and Replace to avoid unintended data loss.
• Visual Data Exploration: Using the Recommended Charts feature, implementing Conditional Formatting to highlight duplicate values, and utilizing advanced sorting options based on multiple levels or cell color.
• Excel Tables vs. Standard Ranges: Converting static lists into dynamic Excel Tables to automate formula updates and data expansion, and knowing when and how to revert these changes.
• PivotTables: Creating and customizing PivotTables to instantly summarize data, with a specific focus on the benefits of basing them on dynamic Excel Tables rather than static ranges.
• Text Formulas: Combining text strings effectively using the Ampersand method, as well as the CONCAT and TEXTJOIN functions to handle complex data arrangements.
• Safety Nets and Auditing: Utilizing the Trace Dependents feature to audit formulas before making changes, and learning how to recover unsaved workbooks and manage AutoRecover settings.

By the end of this course, you will possess the skills to clean messy data, create dynamic reports that update automatically, and utilize Excel's built-in auditing tools to ensure accuracy. Whether you are working on Windows or adapting to the Mac interface, this course provides the essential techniques to navigate spreadsheets with confidence and precision.