Clemenson Imaging analyzes expense reports from field representatives as well as patient and image data. To complete the worksheets, you format data as a table and build an advanced filter. You import a comma-separated text file (.csv) and use the Subtotal command. Finally, you display data in a PivotTable.
[Student Learning Outcomes 4.1, 4.2, 4.3, 4.4, 4.5, 4.6, 4.7, 4.8]
File Needed: Clemenson-04.xlsx (Available from the Start File link.), ClemensonText-04.csv and ClemensonWord-04.docx (Available from the Resources link.)
Completed Project File Names: [your name]-Clemenson-04.xlsx and [your initials] Excel 4-3Word.docx
This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.
IMPORTANT: If you are a Canadian user, be sure to verify that your browser and Microsoft Office use the same country settings. See here for a Help topic on how to change your settings.