Aging Schedules
A step-by-step Excel assignment in which students prepare and analyze aging schedules using real-world accounting data.
ASSIGNMENT OVERVIEW:
This Aging Schedules assignment is a step-by-step Excel exercise designed for Intermediate Financial Accounting courses. It functions as a guided, hands-on activity in which students work through 40 PowerPoint slides with individual numbered steps, each corresponding to a specific task used to import, organize, analyze, and present accounting data to prepare aging schedules and related allowance entries. The assignment emphasizes Excel tools commonly used in professional accounting practice, including data import, worksheet management, formulas, PivotTables, and journal-entry support, making it well suited for classroom instruction or independent study.
Assignment Materials and Support
Troubleshooting Video issues
The videos are hosted on scalable Amazon Web Services (AWS) servers. If you experience difficulty playing a video, try opening it in an incognito or private browser window. If the issue persists, you may download and watch the MP4 version instead: Windows video or Mac video.
For Instructors: Preview the Assignment
Instructors and teaching assistants may preview this assignment by downloading the materials and completing the exercise using a self-selected spreadsheet ID.
This is step 3 of 4 in the Pathway to Excel Certification.
This assignment covers approximately 25% of the material tested on the Microsoft Office Specialist Excel Certification exam.
Key Topics and Learning Components
- Accessing Text Files and Workbooks
- Importing tab-delimited, fixed-width, and comma-delimited files using the Legacy Wizards and “From Text” options.
- Opening and combining XLSX workbooks
- Worksheet Management
- Renaming worksheets
- Moving and copying worksheets
- Adjusting column widths
- Ensuring correct worksheet naming conventions.
- Formatting
- Entering and formatting numbers (Percent Style, Comma Style)
- AutoFitting column widths.
- Formulas and Functions
- VLOOKUP
- SUMIF and SUMIFS
- COUNT, COUNTIF, and COUNTIFS
- INDEX and MATCH
- LARGE and SMALL functions
- IF and DATE functions for calculating days old
- Basic arithmetic and cell referencing (including absolute and mixed references)
- Data Analysis Tools:
- Creating and using PivotTables
- PivotTable drill-down
- Creating PivotCharts.
- Sorting, Filtering, and Subtotaling
- Sorting multiple columns
- Filtering data
- Removing blank rows
- Using and formatting subtotals in data sets
- Page Layout and Presentation:
- Setting page footers
- Adding text boxes.
- General Journal Entries:
- Creating T account listings
- Recording journal entries for allowance amounts