Excel data analysis Your visual blueprint for analyzing data, charts, and PivotTables

Paul McFedries

Book - 2013

Geared towards Excel power users, this visual guide presents numerous screenshots and easy-to-follow numbered steps to show users how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions.

Saved in:

2nd Floor Show me where

005.54/EXCEL/McFedries
0 / 1 copies available
Location Call Number   Status
2nd Floor 005.54/EXCEL/McFedries Due Jan 4, 2025
Subjects
Published
Indianapolis, IN : John Wiley & Sons [2013]
Language
English
Main Author
Paul McFedries (-)
Edition
Fourth edition
Physical Description
323 pages : illustrations ; 24 cm
Bibliography
Includes index.
ISBN
9781118517147
  • Building formulas for data analysis
  • Troubleshooting formulas
  • Enhancing formulas with functions
  • Analyzing financial data
  • Analyzing statistical data
  • Building tables for data analysis
  • Sorting and filtering data
  • Learning data analysis techniques
  • Working with data analysis tools
  • Tracking trends and making forecasts
  • Working with the analysis ToolPak
  • Analyzing data with PivotTables
  • Visualizing data with charts
  • Importing data into Excel
  • Querying data sources
  • Learning VBA for data analysis
  • Appendix: Using Excel keyboard shortcuts.