Excel data analysis

Excel data analysis

by McFedries, Paul

Type Book
Rate 0.0 /5

Take Excel to the next level Excel is the worlds leading spreadsheet application. Its a key module in Microsoft Officethe number-one productivity suiteand it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data s…

Read More ↓
Details
Files
Reviews
Download

Title Statements

  • Full title :Excel data analysis.

Summary

Take Excel to the next level Excel is the worlds leading spreadsheet application. Its a key module in Microsoft Officethe number-one productivity suiteand it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, youll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If youre familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

Read More ↓

Edition Statements

  • Publication Date:2019
  • Edition:4th edition

Publication Statements

Notes

Previous edition: 2016.

Includes index.

The Physical Object

  • Description:xi, 338 pages : : illustrations ; : 24 cm

Edition Identifiers

  • ISBN:9781119518167, 1119518164
  • oclc:on1078682101
  • LC Classification:HF5548.4.M523
  • Dewey Decimal:005.54

Table of Contents

Introduction -- Part 1: Getting started with data analysis -- Learning basic data-analysis techniques -- Working with data-analysis tools -- Introducing Excel tables -- Grabbing data from external sources -- Scrub-a-dub-dub: Cleaning data -- Analyzing table data with functions -- Part 2: Analyzing data with PivotTables and PivotCharts -- Creating and using PivotTables -- Performing PivotTable calculations -- Building PivotCharts -- Part 3: Discovering advanced data analysis tools -- Tracking trends an making forecasts -- Analyzing data with statistics -- Analyzing data with descriptive statistics -- Analyzing data with inferential statistics -- Part 4: The part of tens -- Ten things you ought to know about statistics -- Ten ways to analyze financial data -- Ten ways to raise your PivotTable game.

Read More ↓

Subjects

Electronic spreadsheets -- Computer pro… Microsoft Excel (Computer file) Tableurs -- Logiciels

Writers

McFedries, Paul

More from this Series

  • Switching to a Mac for dummies

    2011.
    more →
    Switching to a Mac for dummies

  • Switching to a Mac for dummies, Mac OS X Lion edition

    ©2011.
    more →
    Switching to a Mac for dummies, Mac OS X Lion edition

  • Switching to a Mac for dummies

    2011
    more →
    Switching to a Mac for dummies

  • Switching to a MAC for dummies

    2011.
    more →
    Switching to a MAC for dummies

  • Switching to a Mac for dummies

    2011
    more →
    Switching to a Mac for dummies

Rate & Review

0.0/5
(0 people Voted)

No reviews yet. Be the first to rate this work.

Files & Downloads

No downloadable files are registered for this work yet.