Self Study

Stay up to date on the latest changes...

Shop course
/ Shop course
Maximize Excel: Basic Skills for Accountants

Maximize Excel: Basic Skills for Accountants

$49.95$49.95
  • SKU : ODNV2308
  • OUR PRICE :$49.95
  • CREDIT HOURS : 2

Maximize Excel: Basic Skills for Accountants
Presented by David H. Ringstrom, CPA
 

In this presentation, CPA and author of "Microsoft 365 Excel for Dummies" David Ringstrom focuses on the essential Excel skills accountants rely on to summarize, analyze, and safeguard financial data. You’ll learn how to create accurate totals with SUM, SUBTOTAL, SUMIF, and SUMIFS, convert static lists into Excel tables, filter and analyze data efficiently, avoid common reporting pitfalls that compromise data integrity, and apply formatting and worksheet protection techniques that make financial reports clearer and more reliable.
 
David demonstrates every technique at least twice: first on a PowerPoint slide with numbered steps, and then live in Excel for Windows using the subscription-based Microsoft 365 version. Differences between Microsoft 365 and earlier perpetual versions of Excel (2021, 2019, and earlier) are clearly identified during the session and reinforced in the accompanying handouts. Participants also receive an Excel workbook containing many of the examples used in the presentation.
 
Who should attend:
Accountants, financial professionals, and Excel users who create or review financial reports and want to improve accuracy and efficiency.
 
Topics typically covered:
 
• Creating reusable cell styles for consistent formatting.
 
• Recovering workbooks that won't open due to damage.
 
• Unearthing Full Screen View to easily hide or show Excel’s ribbon and formula bar.
 
• Filtering tables quickly using the Slicer feature.
 
• Using SUMIFS to total values based on multiple conditions.
 
• Summing sections quickly with the SUBTOTAL function.
 
• Creating a filter shortcut on the Quick Access Toolbar.
 
• Improving PivotTable integrity with the Table feature.
 
Learning objectives:
 
• State what SUMIF returns if a match cannot be found.
 
• Recognize the feature you should use to eliminate manually resizing PivotTable source data ranges.
 
• Identify the mouse action that enables you to remove icons from Excel's Quick Access Toolbar.

 
 

 

The Wait is Over

SIGNUP TODAY AND RECEIVE 8 HOURS OF FREE CPE CREDIT

How may we Help you?

[email protected] 1-800-545-7601

Connect with us

Copyright © 2026 CPE Credit. All Rights Reserved.

cross