Higher Education

Microsoft Excel 2013 for the Business Analyst, 1st Edition

  • Larry Rockoff
  • ISBN-10: 128577888X  |  ISBN-13: 9781285778884
  • 368 Pages
  • © 2014 | Published
  • College Bookstore Wholesale Price = $22.49
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



As one of the most popular software tools in the world, Microsoft Excel is used by business analysts across the globe to keep track of details, look deeply into the data that drives business, and provide managers with the information and insights they need to keep their companies moving forward. MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is an introduction to Excel, written by a business analyst for business analysts. While providing a general overview of the features and functions of Excel, the book places special emphasis on helping users in the task of data analysis. The book begins with a conceptual overview and a discussion of Excel's main components--cells, worksheets, tables, pivot tables, and pivot charts. That material provides an understanding of how Excel summarizes data and paves the way for a detailed exploration of the software's formulas and functions. Written in an easy-to-grasp style, with plenty of helpful screenshots, MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is perfect for analysts who are new to Excel or experienced users who wish to learn more about Excel's business-analysis capabilities.

Features and Benefits

  • Begins with a complete overview of Excel's main components.
  • Provides special emphasis on data analysis, with coverage of pivot tables and pivot charts.
  • Covers Excel's formulas and functions.

Table of Contents

1. An Overview of Excel.
2. The Excel User Interface.
3. Getting External Data.
4. Tables.
5. Pivot Table Basics.
6. Pivot Table Calculations.
7. Charts and Pivot Charts.
8. Data Commands.
9. Formulas.
10. Text Functions.
11. Numeric Functions.
12. Aggregate Functions.
13. Logical and Lookup Functions.
14. Analysis Tools.

Meet the Author

Author Bio

Larry Rockoff

Larry Rockoff has been involved with Excel and business intelligence development for many years. He currently works as a senior reporting analyst for a major retail pharmacy. His main area of expertise is with data warehouse systems and reporting tools. He holds an MBA from the University of Chicago, with a specialization in management science.