Excel Module II - What If Models and Data Analysis

By Ron McMillan et al.
eBook (PDF), 298 Pages
(2 Ratings)
Price: $27.80
Now updated for Excel 2010 & 2013, Module II assumes a basic familiarity with Excel (see Module I by Santarossa/Clark). Module II starts by building What-If? models (e.g., a simple one sheet Break even model, various Financial models such as Capital Budgeting through to 3D and Multiworksheet models for Cash Flow, Timesheet Billings). The second part of the module introduces various tools for manipulating Data Lists (Tables) – tools include Sorting, Filtering, Descriptive Statistics, various SUBTOTAL and IF related functions and PivotTable/PivotChart manipulation. Module II concludes with Advanced Topics like OLAP, Array Functions and Solver. Again, the focus is on students taking various business programs at the college/university level.
Available in PDF Format

Ratings & Reviews

Log in to review this item
Lulu Sales Rank: 9599
There are no reviews for the current version of this product
There are no reviews for previous versions of this product

Product Details

January 10, 2014
File Format
File Size
11.02 MB
Product ID

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch... (See More)
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes
Report This Content to Lulu >

Moderation of Questionable Content

Thank you for your interest in helping us moderate questionable content on Lulu. If you need assistance with an order or the publishing process, please contact our support team directly.

How does this content violate the Lulu Membership Agreement?


Listed In