Overview of this project

This project uses fixed asset information from anonymized and modified data for a tax client from a public accounting firm. The data set includes 1,500 fixed asset records. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, create calculated fields, use the slicer and timeline tool. In addition, students will be asked to analyze the data for errors. The students will prepare several different fixed asset schedules and also a pivot chart (column type) that depicts book value by asset category and region.

Project resources

• Hula Hut Burger Fixed Asset Instructions (Word doc)
• Hula Hut Burger Fixed Asset_DATA (Excel file)
• Tutorial video: Overview and Requirements 1 through 3 (YouTube Link)
• Tutorial video: Requirements 4 through 6 (YouTube Link)
• Hula Hut Burger Fixed Asset_DEMODATA (Excel file)
• Training Slides for Hula Hut Burger (PPT file)

Learning Objectives

1. Create a pivot table in Excel
2. Format a pivot table
3. Apply filters to a pivot table
4. Create sum columns in a pivot table
5. Create a calculated field
6. Use the slicer tool in a pivot table
7. Analyze data for errors
8. Use the timeline tool in a pivot table
9. Create a pivot chart in Excel

Office 365 or Excel 2016 (newest version)

Anyone doing this project will need to have either Office 365 or Excel 2016. It is important that students update their version of Office 365 and/or Excel 2016.

Solution

If you would like to have a copy of the Excel solution file, please fill out the request form. (There is a separate request form for each project.) Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions files with your students. The Excel solutions file is for you own use only.