Excel 2013 Data

Sorted by:  

The Excel 2013 Document Recovery Feature

Excel 2013 offers a document recovery feature that can help you in the event of a computer crash because of a power failure or some sort of operating system freeze or shutdown. The AutoRecover feature [more…]

Eliminate Errors with Text to Speech in Excel 2013

Excel’s Text to Speech feature can help you flag and then correct some errors that otherwise you would have to check and verify by comparing cell to cell. Usually, you do this by checking the columns and [more…]

How to Customize Excel 2013 AutoCorrect

Excel 2013 has an AutoCorrect feature that automatically fixes common typos that you make in the text entries as soon as you complete them. In addition to the errors already recognized by AutoCorrect, [more…]

How to Create Custom AutoFill Lists in Excel 2013

Just as you can use AutoFill in Excel 2013 to fill out a series with increments different from one unit, you can also get it to fill out custom lists of your own design. For example, suppose that you often [more…]

How to Save Custom Views of an Excel 2013 Worksheet

In the course of creating and editing a worksheet in Excel 2013, you may find that you need to modify the worksheet display many times as you work with the document. Excel’s Custom Views feature enables [more…]

Sort Excel 2013's Data Lists on Font and Fill Colors and Cell Icons

In Excel you normally sort the records of a data list or rows of a table on the values (entries) contained in one or more columns of the list or table; however, Excel 2013 also enables you to sort on the [more…]

How to Subtotal Data in Excel 2013

You can use Excel’s Subtotals feature to subtotal data in a sorted list. To subtotal a data list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

The Excel 2013 AutoFilter Feature

Excel’s AutoFilter feature makes filtering out unwanted data in a data list as easy as clicking the AutoFilter button on the column on which you want to filter the data and then choosing the appropriate [more…]

How to Sort Columns of a Data List in Excel 2013

You can use the column sorting capability in Excel 2013 to change the order of the fields in a data list without having to resort to cutting and pasting various columns. [more…]

How to Eliminate Records with Excel 2013’s Eliminate Duplicates Feature

You can use Excel’s Eliminate Duplicates feature to quickly find and remove duplicate records from a list (or rows from a table). This is a great feature especially when you’re dealing with a really large [more…]

How to Filter with the Excel 2013 Top Ten Option

The Top Ten option on the Number Filters option’s submenu in Excel 2013 enables you to filter out all records except those whose entries in that field are at the top or bottom of the list by a certain [more…]

How to Use Advanced Filtering in Excel 2013

When you use advanced filtering in Excel 2013, you don’t use the field’s AutoFilter buttons and associated drop-down menu options. Instead, you create a so-called Criteria Range somewhere on the worksheet [more…]

How to Produce a Summary Report in Excel 2013

You can use the Summary button in the Scenario Manager dialog box of Excel 2013 to create a summary report that shows the changing values used in each scenario and, if you want, key resulting values that [more…]

The Solver Add-In Utility for Excel 2013

When dealing with complex problems in Excel 2013, you might need to use the Solver add-in. For example, use the Solver to find the best solution when you need to change multiple input values in your model [more…]

Set Up and Define Problems in Excel's Solver Add-In Utility

The first step in setting up a problem in Excel 2013 for the Solver add-in utility to work on is to create the worksheet model for which you will define the objective cell, variables cells, and the constraint [more…]

Stem-and-Leaf Plots Present a Distribution of Scores in Excel

Stem-and-leaf displays organize data so that an entire distribution of scores is quickly and easily comprehensible. The display breaks each score into two components: a [more…]

Box-and-Whisker Charts for Excel

Excel doesn’t offer a box-and-whisker chart. Instead, you can cajole a type of Excel chart into boxes and whiskers. Instead of showing the mean and the standard error, the [more…]

Data Smoothing in Excel

Statisticians typically have to look at large masses of data and find hard-to-see patterns. Sometimes an overall trend suggests a particular analytic tool. And sometimes that tool, although statistically [more…]

How to Perform Analyses of Variance with Two Kinds of Variables

What happens when you are performing analyses of variance (ANOVA) and you have a Between Groups variable and a Within Groups variable . . . at the same time? How can that happen? [more…]

How to Perform Analyses of Variance in Excel

Someday, Excel’s Analysis ToolPak might have a choice labeled ANOVA: Mixed Design. That day, unfortunately, is not today. To run two ANOVAs on the same data and combine the ANOVA tables, follow these steps [more…]

How to Graph the Results of Analyses of Variance in Excel

Because analyses of variance (ANOVA) isn’t a built-in tool, Excel doesn’t produce the descriptive statistics for each combination of conditions. You have to have those statistics [more…]

Post-Analysis after an Analysis of Variance

A significant result in an analysis of variance (ANOVA) in Excel tells you that an effect is lurking somewhere in the data. Post-analysis tests tell you where. Two types of tests are possible — either [more…]

Analysis of Variance for Mac Users of Excel

You can use StatPlus LE to do analysis of variance in Excel on a Mac. The first thing you have to do, however, is rearrange the data the way StatPlus likes it — in columns. The second thing is to recode [more…]

How to Select Ranges in Excel 2013

Range names in Excel 2013 are written with the upper-left cell address, a colon, and the lower-right cell address, as in the example A1:F3. Here A1:F3 means the range that begins in the upper-left corner [more…]

How to Enter Cell Content in Excel 2013

You will need to learn some spreadsheet basics in order to work in Excel 2013. When it’s time to actually do something, try entering some text and numbers into cells. [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com