Guerrilla Data Analysis Using Microsoft Excel, 2nd Edition
- 2h 10m
- Bill Jelen, Oz du Soleil
- Tickling Keys
- 2015
Bill Jelen uses his combined experience and analytical ingenuity to de-mystify the arduous task of dealing with downloaded data. He uses real-life examples of real-life management requests, and then walks you through the maze of Excel tools and formulas that not only cuts valuable time out of the process, but teaches you in plain English how to overcome the most common analytical obstacles.
About the Authors
Oz du Soleil teaches Excel workshops and consults clients who have small businesses with no IT teams or sophisticated data management systems. He’s worked with data and Excel for more than 10 years, including time spent as a financial analyst, facing issues of data quality, modeling business rules in Excel formulae, and revising reports.
Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 44 books about Excel.
In this Book
-
Introduction—Welcome to the World of Guerrilla Data Analysis!
-
Reviewing the Basics
-
Developing Dynamic Spreadsheets
-
Conditional Formatting
-
Using IF Statements
-
Sorting
-
Filtering
-
Using Consolidate
-
Using Subtotals
-
Summing and Counting Using Criteria
-
Matching Lists of Data
-
Using Pivot Tables
-
Using Array Formulas
-
Stepping Up to Excel Tables
-
Using the INDIRECT and OFFSET Functions
-
Controlling Data Inputs and Maintaining Data Integrity
-
Implementing Error-Handling and Formula Triggers
-
Using Pivot Charts
-
Using Slicers
-
Excel 2013—Guerrilla Data Analysis Gets Real
-
Graphing aand Charting
-
Using Excel on the Internet
-
Down and Dirty Tips and Insights
-
Useful Excel Functions
-
Troubleshooting Excel
-
Linking
-
Spreadsheet Layout and Development
-
Using Keyboard Shortcuts
-
Wrap-Up
