Excel 101: Introduction to Spreadsheets Part 2 (Completed)

This presentation by author and Excel expert David Ringstrom, CPA, builds on the discussion in part 1 of his two-part series on spreadsheet basics. You'll learn how to duplicate Excel worksheets to save time, as well as create a fallback position. David will explore the nuances of copying and pasting in Excel, which is different than in other programs. You'll also learn techniques such as merging cells, finding data, tracing formulas, sorting lists, and recovering unsaved workbooks.

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.

In his webinars, David encourages questions throughout the presentation and demonstrates every technique twice: first on a PowerPoint slide with numbered steps and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the session and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.

Who Should Attend
Professionals seeking to learn or refresh the basics of working with Excel spreadsheets.

Topics Covered

• Exploring the PivotTable ribbon tabs and PivotTable Field List.
• Creating PivotTables and PivotCharts based upon your data by asking natural language questions
• Removing the Table feature or just clearing its alternate row shading
• Identifying and highlighting duplicate entries in a list using Conditional Formatting
• Preventing errors from the start by choosing from thousands of free Excel spreadsheet templates
• Using the Total Row in Excel Tables
• Swapping out data within worksheet cells by way of the Replace feature
• Bringing Excel’s green error-checking prompts under control by managing the underlying rules
• Spell-checking spreadsheets by way of a keyboard shortcut or menu command
• Identifying other cells, a formula relies on by way of the Trace Precedents feature
• Understanding how deleting worksheets affects your ability to undo any previous actions in Excel
• Using Text to Columns to quickly separate cities, states, and ZIP codes into separate columns

Learning Objectives

• State the location of the Error Checking Rules within Excel's Options dialog box
• State which menu the Trace Dependents command appears on in Excel
• State the functionality that the Flash Fill feature offers

Level
Basic

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
Excel 101: Introduction to Spreadsheets Part 1 is recommended but not required

Advance Preparation
None