2025 Streamlining Data Entry in Excel

Spreadsheet work can present what seems like unavoidable data entry tasks, but thankfully there are often ways to avoid or at least minimize drudgery. In this presentation author and Excel expert David H. Ringstrom, CPA, empowers you to work smarter rather than...

2025 Mastering Excel Cell References

In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide attendees through essential techniques to streamline and enhance their Excel experience. David begins by showing how to use the F4 key to toggle between absolute and relative references,...

2025 Basic Excel Skills for Accountants

Many accounting professionals are unaware of Excel features and functions that improve spreadsheet accuracy and efficiency. In this presentation, author and Excel expert David Ringstrom, CPA, contrasts the SUM, SUBTOTAL, SUMIF, and SUMIFS functions, along with the...

2025 Breaking Down Excel Formulas

In this session, author and Excel expert David Ringstrom, CPA, shares techniques you can use to verify the integrity of even the most complicated Excel workbooks. Features covered include Show Formulas, Evaluate Formulas, Trace Precedents, and the FORMULATEXT...

2025 Analyzing Payroll Data in Excel

In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various payroll-related Excel techniques. Topics covered include contrasting using Flash Fill versus the TEXT function to reformat Social Security Numbers....