https://www.wiley.com/Excel+Data+Analysis+For+Dummies%2C+5th+Edition-p-9781119844426
|
Published:
February 15, 2022

Excel Data Analysis For Dummies

Overview

Turn jumbles of numbers into graphics, insights, and answers with Excel

With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions—it's all in here, with examples and ideas for Excel users of all skill levels.

This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice—and Dummies is the best choice for learning how to make those numbers sing.

  • Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data
  • Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers
  • Clean up large datasets and identify statistical operations that will answer your questions
  • Perform financial calculations, database operations, and more—without leaving Excel

Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

Read More

About The Author

Paul McFedries is the owner of Logophilia Limited, a successful technical writing firm. He has 25 years’ experience writing instructional computer books and is the author of over 100 books that have sold a combined 4 million copies worldwide.

Sample Chapters

excel data analysis for dummies

CHEAT SHEET

Data analysis, by definition, requires some data to analyze. However, after you’ve imported or entered that data and cleaned it up as best you can. what’s your next move? Ah, that’s where the “analysis” part raises its hand in the air and says, “Pick me, pick me!”Excel is bursting at its digital seams with tools for analyzing data, but there are some that you’ll turn to most often.

HAVE THIS BOOK?

Articles from
the book

All kinds of people use Excel, including scientists, engineers, mathematicians, statisticians, and pollsters. But if you could somehow survey all the world’s Excel users, the typical user would probably have something to do with the financial industry. Whether they’re accountants or adjusters, bankers or borrowers, or money managers or money lenders, financial types rely on Excel every day to analyze budgets, loans, investments, and other monetary minutiae.
Excel comes with so many powerful data-analysis tools and features that you might be wondering why you need to learn yet another: the PivotTable. The short answer is that the PivotTable is a useful weapon to add to your data-analysis arsenal. The long answer is that PivotTables are worth learning because they come with not just one or two but a long list of benefits.
Data analysis, by definition, requires some data to analyze. However, after you’ve imported or entered that data and cleaned it up as best you can. what’s your next move? Ah, that’s where the “analysis” part raises its hand in the air and says, “Pick me, pick me!”Excel is bursting at its digital seams with tools for analyzing data, but there are some that you’ll turn to most often.
You set up your Excel Solver model by using the Solver Parameters dialog box. You use the Set Objective box to specify the objective cell, and you use the To group to tell Excel Solver what you want from the objective cell: the maximum possible value; the minimum possible value; or a specific value. Finally, you use the By Changing Variable Cells box to specify the cells that Solver can use to plug in values to optimize the result.
Excel spreadsheet tools such as Goal Seek that change a single variable are useful, but unfortunately most problems in business are not so easy. You’ll usually face formulas with at least two and sometimes dozens of variables. Often, a problem will have more than one solution, and your challenge will be using Excel to find the optimal solution (that is, the one that maximizes profit, or minimizes costs, or matches other criteria).
To help you analyze data that’s stored in a table or range, you can turn to Excel’s powerful database functions, which enable you to apply calculations such as sum, average, and standard deviation.The database functions all use the same three arguments: database: The range of cells that make up the table you want to work with.
When it’s time to get down to analyzing your data, a good place to start is with some basic statistics, such as counting items, calculating sums and averages, finding the largest and smallest values, working out the standard deviation, and so on. These measures fall under the general rubric of descriptive statistics, and Excel offers a fistful of functions that help you get the job done.
To make an Excel PivotTable with a large number of row or column items easier to work with, you can group the items. For example, you can group months into quarters, thus reducing the number of items from twelve to four. Similarly, a report that lists dozens of countries can group those countries by continent, thus reducing the number of items to four or five, depending on where the countries are located.
A comparison expression — also known as a logical expression or a Boolean expression — is an expression in which you compare the items in a range or table column with a value you specify. In Excel, you use comparison expressions to create advanced filters for a table, as well as in functions that require criteria, such as COUNTIF, SUMIF, and AVERAGEIF.
The Data Analysis command provides a tool for calculating moving and exponentially smoothed averages in Excel. Suppose, for sake of illustration, that you’ve collected daily temperature information. You want to calculate the three-day moving average — the average of the last three days — as part of some simple weather forecasting.
Perhaps the most common data analysis tool that you'll use in Excel is the one for calculating descriptive statistics. To see how this works, take a look at this worksheet. It summarizes sales data for a book publisher.In column A, the worksheet shows the suggested retail price (SRP). In column B, the worksheet shows the units sold of each book through one popular bookselling outlet.
Excel provides a robust toolset for illustrating trends. You can do this by plotting trendlines in your Excel charts to offer a visual of your data. Here, you discover how to plot logarithmic trendlines, power trend lines, and polynomial trend lines in Excel. Plotting a logarithmic trend line in Excel A logarithmic trend is one in which the data rises or falls very quickly at the beginning but then slows down and levels off over time.
In a general sense, Excel PivotTables take a large amount of information and condense that data into a report that tells you something useful or interesting. For example, take a look at the following table. Some great data, but how do you make sense of it? This table contains well over 100 records, each of which is an order from a sales promotion.
When you add a second field to the row or column area, Excel displays subtotals for the items in the outer field. Having these outer field subtotals available is a useful component of Excel data analysis because it shows you not only how the data breaks down according to the items in the second (inner) field, but also the total of those items for each item in the first (outer) field.
https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

Frequently Asked Questions

No items found.