CHAPTER 4Case 4: Using Data Analytics: Analyzing and Summarizing Data with Excel Pivot

4-1 ANDERSON INTERNAL MEDICINE (DATA ANALYTICS): USING DATA ANALYTICS—ANALYZING AND SUMMARIZING DATA WITH EXCEL PIVOT

Learning Objective

After completing this case, you should be able to:

  1. Use Excel Pivot to analyze a spreadsheet created by, or small database imported into, Excel.
  2. Use Excel Pivot to summarize by preparing easy to understand summary schedules for inclusion in examination reports and/or for courtroom presentation.

 

Get Fraud Examination Casebook with Documents now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.