Excel Explained: Introduction to Spreadsheets Workshop – 2 Part Series
These aren’t your typical webinars. After each set of topics, you’ll head into breakout rooms to apply what you’ve learned with direct support from David as he visits each room. Afterward, David will regroup with everyone to review questions before moving on to the next segment. Whether you’re brand new to Excel or brushing up on rusty skills, this interactive session will build your confidence step by step.
Breakout rooms will not be recorded. Space is limited to 35 participants for a high-value learning experience, so register today!
David is the author of Microsoft Excel 365 for Dummies, Exploring Microsoft Excel’s Hidden Treasures, and six other books. He demonstrates every technique at least twice—first on a PowerPoint slide with numbered steps and then live in the subscription-based Excel for Microsoft 365. David highlights any differences in Excel 2021, 2019, or 2016 throughout the session and in his detailed handouts. Attendees receive an Excel workbook that includes most of the examples used during the presentation for continued practice after the workshop.
Included Webinars
Excel Explained: Introduction to Spreadsheets Workshop – Part 1
Excel Explained: Introduction to Spreadsheets Workshop – Part 2
Series Details
Excel Explained: Introduction to Spreadsheets Workshop – Part 1
Join us for an engaging, hands-on online workshop designed to help you confidently navigate Excel and build a solid foundation. Excel expert David H. Ringstrom, CPA will guide you through essential spreadsheet skills such as entering and formatting data, managing worksheet layout, and using tools like the Fill Handle and PMT function. You’ll explore the difference between working within a cell and working on a worksheet, uncover shortcuts to speed up formatting, and practice freezing rows and columns for easier scrolling.
Getting oriented with Excel’s grid of rows and columns
Learning about the different types of files you can create in Excel
Understanding the difference between working within a cell versus working on a worksheet
Entering, editing, and clearing worksheet text—plus how cell entries behave when content overlaps
Managing column widths within your spreadsheets
Formatting percentages with precision using Percent Style, decimal tools, and the Format Cells dialog box
Formatting numbers using Accounting, Currency, and Comma styles—plus adjusting decimal display
Contrasting using menu commands and keyboard shortcuts for applying formatting
Using the Fill Handle to extend formulas with relative references and auto-incrementing values in a column
Avoiding century confusion when filling dates in Excel
Utilizing the PMT worksheet function to calculate loan payment amounts
Freezing a row or column position within by creating a mixed cell reference
Using a keyboard shortcut so you’ll never have to manually type $ signs in a formula again
Copying formulas efficiently down one or more columns at the same time
Excel Explained: Introduction to Spreadsheets Workshop – Part 2
Join us for an engaging, hands-on online workshop that builds on foundational Excel skills with practical, timesaving techniques. Excel author and instructor David H. Ringstrom, CPA will guide you through a variety of essential topics, including using AutoSum to total columns with just a click, mastering Excel’s order of operations, and keeping header rows visible as you scroll. You’ll also gain control over printed output by repeating rows on every page and avoiding scaling surprises that waste paper.
In addition to working smarter with your data, you’ll learn how to start clean by choosing from Excel’s extensive library of templates, manage worksheets by cutting, duplicating, and deleting with confidence, and uncover powerful techniques for navigating large workbooks. David also shows how to rein in Excel’s green error prompts, filter data efficiently, and eliminate duplicates from your lists.
Saving time by using the AutoSum formula to sum multiple columns at once with a mouse click or a keyboard shortcut
Mastering Excel’s order of operations for mathematical formulas
Freezing rows to keep headings visible while scrolling
Setting the Rows to Repeat at Top option to include rows on each page of a printout
Saving paper and eliminating frustration by monitoring the Print Scale setting
Preventing errors from the start by choosing from thousands of free Excel spreadsheet templates
Cutting and pasting data from one part of a worksheet to another
Understanding how deleting worksheets affects your ability to undo any previous actions in Excel
Duplicating Excel worksheets in two different ways
Navigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
Bringing Excel’s green error-checking prompts under control by managing the underlying rules
Controlling large datasets efficiently by filtering instead of sorting
Eliminating duplicates from a list with just a few mouse clicks
We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.
We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
Other external services
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds:
Privacy Policy
You can read about our cookies and privacy settings in detail on our Privacy Policy Page.
