Debby Bloom, CMA, CFM, CSCA, FMAA

 

 

 

Family and friends are a luxury, a smart accountant is a necessity

_______________________________________________________________

 

TACTYC 2026 Annual Conference resources

 

Click here for the presentation PowerPoint

Click here for the presentation Excel workbook

 

New Excel Functions PIVOTBY, GROUPBY, FILTER

Sales data for Principles of Accounting, Intermediate Accounting

Click here to download the Excel file

Click here to view the YouTube video

 

Data Validation and SUMIF for a Cool Application

Purchase order data for Principles of Accounting, Intermediate Accounting

Click here to download the Excel file

Click here to view the YouTube video

 

Introduction to PivotTables

Sales data for Principles of Accounting, Intermediate Accounting

Click here to download the Excel file

Click here to view the YouTube video

 

PivotTables, Slicers, Calculated Fields and Pivot Charts

Budgetary data for Managerial Accounting, Cost Accounting

Click here to download the Excel file

Click here to view the YouTube video

 

Use VLOOKUP, XLOOKUP, and Conditional Formatting to Find Missing PO Numbers in a Sequence

PO Data for Auditing, Accounting Information Systems

Click here to download the Excel file

Click here to view the YouTube video