Overview This lab has three parts: one using the Data Analytics Using Excel Microsoft 365 textbook, one using the Accounting Information Systems textbook, and one in which you'll create learn something

new in Excel and teach it to your classmates. Our objectives this week are to: Practice IF and IFS-type formulas and Pivot Tables without relying on keystrokes from the text. Learn about the Expenditure Cycle in accounting and explore the internal controls that help ensure that actions are performed as designed and expenditure data are captured accurately and completely. Practice learning new Excel analytics tools on your own using a learning-by-teaching approach. Deliverables Submit your work to the Assignments area in Canvas and the class folder in Drive as follows: As soon as you have your Excel topic for Part 3, enter it next to your name in the Excel Topic sign- up sheet in the ACTG 335 Fall 2023 Drive folder HW 5 Worksheet, renamed HW5_firstname_lastname HW5_Firstname_Lastname.xlsx YourExcelTopic_Firstname_Lastname.xlsx (in Canvas) YourExcelTopic_Firstname_Lastname.xlsx 335 Fall 23 Drive uploaded to the Student Excel Labs folder in the ACTG/nInstructions The tables in this document are the same as those in the HW5 Worksheet. If you find it easier, you can fill in the tables here and then paste them into the worksheet when you're done with the assignment. You are allowed to discuss this assignment with classmates or even to work through the assignment together. However, you are not allowed to work on a single worksheet or Excel file each student must complete their own version. Submitting two copies of a single file is not allowed.