BEGIN:VCALENDAR
VERSION:2.0
METHOD:PUBLISH
CALSCALE:GREGORIAN
PRODID:-//WordPress - MECv6.5.5//EN
X-ORIGINAL-URL:https://www.wisbank.com/
X-WR-CALNAME:Wisconsin Bankers Association
X-WR-CALDESC:Educating, advocating for and supporting Wisconsin&#039;s Banking Industry.
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-PUBLISHED-TTL:PT1H
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
CLASS:PUBLIC
DTSTART;TZID=America/Chicago:20250812T100000
DTEND;TZID=America/Chicago:20250819T120000
DTSTAMP:20250728T193600
UID:MEC-d348734a9ee240ebc4c0937a6e755621@wisbank.com
CREATED:20250728
LAST-MODIFIED:20250728
PRIORITY:5
TRANSP:OPAQUE
SUMMARY:Excel Explained: Introduction to Spreadsheets Workshop – 2 Part Series
DESCRIPTION: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.\nBreakout rooms will not be recorded. Space is limited to 35 participants for a high-value learning experience, so register today!\nDavid 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.\n\n\n\n\nIncluded Webinars\n\nExcel Explained: Introduction to Spreadsheets Workshop – Part 1\nExcel Explained: Introduction to Spreadsheets Workshop – Part 2\n\n\n\n\n\n\nSeries Details\n\n\n\n\n\nExcel Explained: Introduction to Spreadsheets Workshop – Part 1\nAugust 12, 2025 | 10:00 am – 12:00 pm CDT\nJoin 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.\n\nWhat You’ll Learn\n\n\n\nGetting oriented with Excel’s grid of rows and columns\nLearning about the different types of files you can create in Excel\nUnderstanding the difference between working within a cell versus working on a worksheet\nEntering, editing, and clearing worksheet text—plus how cell entries behave when content overlaps\nManaging column widths within your spreadsheets\nFormatting percentages with precision using Percent Style, decimal tools, and the Format Cells dialog box\nFormatting numbers using Accounting, Currency, and Comma styles—plus adjusting decimal display\nContrasting using menu commands and keyboard shortcuts for applying formatting\nUsing the Fill Handle to extend formulas with relative references and auto-incrementing values in a column\nAvoiding century confusion when filling dates in Excel\nUtilizing the PMT worksheet function to calculate loan payment amounts\nFreezing a row or column position within by creating a mixed cell reference\nUsing a keyboard shortcut so you’ll never have to manually type $ signs in a formula again\nCopying formulas efficiently down one or more columns at the same time\n\n\nExcel Explained: Introduction to Spreadsheets Workshop – Part 2\nAugust 19, 2025 | 10:00 am – 12:00 pm CDT\nJoin 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.\nIn 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.\n\nWhat You’ll Learn\n\n\n\nSaving time by using the AutoSum formula to sum multiple columns at once with a mouse click or a keyboard shortcut\nMastering Excel’s order of operations for mathematical formulas\nFreezing rows to keep headings visible while scrolling\nSetting the Rows to Repeat at Top option to include rows on each page of a printout\nSaving paper and eliminating frustration by monitoring the Print Scale setting\nPreventing errors from the start by choosing from thousands of free Excel spreadsheet templates\nCutting and pasting data from one part of a worksheet to another\nUnderstanding how deleting worksheets affects your ability to undo any previous actions in Excel\nDuplicating Excel worksheets in two different ways\nNavigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts\nBringing Excel’s green error-checking prompts under control by managing the underlying rules\nControlling large datasets efficiently by filtering instead of sorting\nEliminating duplicates from a list with just a few mouse clicks\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
URL:https://partners.bankwebinars.com/excel-explained-introduction-to-spreadsheets-workshop-2-part-series-70bwus255370e?partner=wisconsin-bankers-association
CATEGORIES:Business Bankers,Senior Management,Training and Development,Webinar
END:VEVENT
END:VCALENDAR
