Aging Schedules

The Aging Schedules exercise is designed to reinforce accounting concepts taught in class, as well as provide exposure to dozens of Excel techniques that appear on the Microsoft Excel Certification exam. Students pay $9.95 for the exercise and are guided through a video with numbered steps.

The students are taught 38 different Excel concepts.
  • Enabling Get Data from Text
  • Opening and Saving .xlsx files
  • Using the Text Import Wizard
  • Assigning Worksheet Names
  • Importing Tab-delimited text files
  • Importing Fixed-width text files
  • Removing extraneous column breaks
  • Importing Comma-delimited text files
  • Opening CSV files
  • Moving Worksheets
  • Autofit column widths
  • Inserting worksheets
  • Assigning the percent style to the numbers
  • Using the VLOOKUP function
  • Using the Find and Replace feature
  • Correcting #VALUE errors
  • Correcting #N/A errors
  • Using the DATE function
  • Using the IF function
  • Using the SUMIFS function
  • Using the SUMIF function
  • Using the COUNT function
  • Using the COUNTIF function
  • Using the COUNTIFS function
  • Copying formulas down a column
  • Averaging using funcitons
  • Using the LARGE function
  • Using INDEX with MATCH
  • Using the SMALL function
  • Creating a Text Box
  • Sorting with multiple columns
  • Creating a PivotTable
  • Creating a Page Footer
  • Drilling-down a PivotTable
  • Creating a PivotChart
  • Filtering data
  • Removing blank rows
  • Using the Subtotal feature
  • Formatting Subtotals
Students enter perform the following accounting tasks on their own:
  • Calculating the allowance for bad debt based on different percentages for each aging bucket.
  • Recording the increase or decrease in bad debt for five months via general journal entries..

Each student is assigned a unique 4-digit number known as their Spreadsheet ID for use during the exercise. This ID number is incorporated into the exercise and helps ensure that each student turns in their own work.

The students submit their work to us and we handle all of the grading. We give you three scores:

  • Completion: This score indicates if the student attempted a given step.
  • Accuracy: This score indicates carried out the step accurately.
  • Combined: The average of the two Completion and Accuracy scores.

Within one week of an assignment’s due date we provide instructors with a spreadsheet showing all student results. Partial credit in our scoring is given if a student at least attempts a step. Instructors determine final credit for each student, and whether late submissions are allowed. Students receive written feedback confirming which steps were completed successfully, as well as providing guidance on steps that they did not attempt or did not complete correctly.

Some instructors give more weight to the Completion score than the Accuracy score, while other instructors use the combined average when determining credit. We’re happy to provide any additional information that can help you as an instructor.

  • Exercise Video
  • Purchase instructions – to share with your students
  • Exercise handouts – both Windows and Mac versions – We prefer students watch the video rather than use the PDF instructions.  The video includes detailed demonstrations, check figures, steps and discussion.
  • Downloadable files – the students will use to complete the exercise

Please direct questions to David Ringstrom (david@studentsexcel.com) or 404.784.0275. Learn more about us at www.studentsexcel.com.