Aging Schedules

A step-by-step Excel assignment in which students prepare and analyze aging schedules using real-world accounting data.

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.

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
- 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 Presentations
- Setting page footers
- Adding text boxes
- Creating page waterwarks

General Journal Entries
- Creating T account listings
- Recording journal entries for allowance amounts

This assignment covers approximately 25% of the material tested on the Microsoft Office Specialist Excel Certification exam.

Step 1: Record your 4-digit Spreadsheet ID

The Spreadsheet ID is used throughout the assignment to help ensure each student submits unique work.

Students: Your Spreadsheet ID appears on your dashboard.
Faculty/Teaching Assistants: You may use any 4-digit number as your Spreadsheet ID.

Step 2: Download the assignment files

If you already downloaded the exercise files from your dashboard, you may skip this step.

↓ Download the aging.zip file

You will start the assignment with a blank Excel workbook.
These files will be used later in the video as you build the assignment step by step.

Important:
After downloading, you must extract (unzip) the files before using them.

Windows: Right-click the ZIP file and choose Extract All
macOS: Double-click the ZIP file to extract the contents

Keep the extracted files available while you work through the video.

Step 3: Complete the assignment alongside the instructional video

Choose the tutorial that matches your Excel environment:

Watch the 2 hour, 5 minute step-by-step tutorial
If the video doesn’t play, you can watch the MP4 backup version

Watch the 1 hours, 41 minute step-by-step tutorial
If the video doesn’t play, you can watch the MP4 backup version

View background on why this assignment requires Excel for Windows or Mac.

Step 4: Submit your completed spreadsheet via your dashboard

return to your dashboard

Keep these tips in mind to ensure clean submission of your work:

Double-check that your workbook is not an .XLTX workbook.
Close Excel completely before attempting to upload your work.
Make use of the alternate submission methods if needed.

How This Assignment Is Graded

An automated tool is used to grade your work based on completion and accuracy, including partial points for incorrect steps. Your instructor determines how scores are applied toward course credit.

Need help?

FAQs

Click here to access of list of frequently asked questions about this assignment.

Learn More

Support

Support is email-based. In rare instances Zoom meetings are available when issues cannot be resolved otherwise.

Get Support

Aging Schedules Assignment