Excel's Advanced Analysis Tools

Course: Advanced Tools for Analysis
Author: Joseph Helstrom and Patricia McCarthy
Course ID:EXATA709
Publisher: Mill Creek Publishers
CPE Hours: 5
Pages:127

Course Description:

If you are looking for tools to help you analyze data and improve your efficiency with creating budgets and forecasts then this course is for you.

$41.25

TABLE OF CONTENTS
Basic Tools
Range Names................P. 7
Watch Window..............P. 20

Remove Duplicates.......P.27
Pivot Tables...................P.34
What-IF Analysis
Goal Seek........................P. 82

   Data Tables.....................P. 86
   Scenarios.........................P. 98
   Spinner............................P. 109
   Solver.(Overview)..........P. 114

Appendix
Frequency Distribution.. P. 126

Click here to see a sample page.

Learning Objectives

Gain an understanding of how Excel's what-if tools and pivot tables work
Understand how to utilize What-ifs, pivot tables and range names in your workpapers

Level
Intermediate user

Prerequisite
An understanding of Excel -
This Ebook is not recommended if you have already taken Pivot Tables as the Pivot Table section is identical to that of the Pivot Table Course(EPT20507/EPT30907).

Version
Excel 2007 (Excel 2003 users will be able to use most -but not all -of the features however it is recommended that you have Excel 2007)

Format
Ebook in PDF format and Excel exercise files

Reviwed/Revised: November 2011

Price:

$41.25