Excel 2013

Sorted by:  

How to Use Ready-Made Number Filters in Excel 2013

Excel 2013 contains a number filter option called Top 10. You can use this option on a number field to show only a certain number of records (like the ones with the ten highest or lowest values in that [more…]

How to Format Values in the Pivot Table in Excel 2013

Excel 2013 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data or list of data. All you need to do is click a cell of the pivot table [more…]

How to Move Pivot Charts to Separate Sheets in Excel 2013

You may find it easier to customize and work with your pivot table in Excel 2013 if you move the chart to its own chart sheet in the workbook, even though Excel automatically creates all new pivot charts [more…]

How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool

Excel 2013 makes creating a new pivot table a snap with its new Quick Analysis tool. To preview various types of pivot tables that Excel can create for you on the spot using the entries in a data table [more…]

Top Ten Excel VBA Control Structures

Following is a list of the ten most commonly used Excel VBA programming control structures. Included is a simple example of each control structure and a brief description of when you would use that structure [more…]

Deciphering Error Values in Excel 2013 Formulas

You can tell right away that an Excel 2013 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness is, in the parlance of Excel [more…]

Moving the Cell Cursor in Excel 2013 Spreadsheets

Excel 2013 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if [more…]

Excel 2013 Data-Entry Etiquette

To begin to work on a new Excel 2013 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines [more…]

Excel 2013 For Dummies Cheat Sheet

At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2013 user interface. However, this Cheat Sheet will help you navigate your way by showing you [more…]

How to Customize the Excel 2013 Quick Access Toolbar

To ease your transition to Excel 2013 from Excel 2003, you can customize the Quick Access Toolbar so that it contains every button from the Standard and Formatting toolbar in Excel 2003 with the exception [more…]

How to Find the Excel 2013 Formatting Toolbar Buttons Equivalents

Finding the Excel 2013 equivalents for the buttons on the Formatting toolbar in earlier versions of Excel couldn't be easier: Every one of the buttons on the Formatting toolbar is displayed prominently [more…]

Create Charts in Excel 2013 via the Quick Analysis Tool

For those times when you need to select a subset of a data table in Excel 2013 as the range to be charted (as opposed to selecting a single cell within a data table), you can use the new Quick Analysis [more…]

Top 10 New Features in Excel 2013

If you’re looking for a quick rundown on what’s new and cool in Excel 2013, look no further! Just a cursory glance down the first few items in this list tells you that the thrust of the features is being [more…]

How to Copy Custom Styles in Excel 2013

Excel 2013 makes it easy to copy custom cell styles that you’ve saved as part of one workbook into the workbook you’re currently working on. To copy custom styles from one workbook to another, follow these [more…]

How to Add Comments to Excel 2013 Worksheet Cells

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify [more…]

How to Move Pivot Charts in Excel 2013

Although Excel 2013 automatically creates all new pivot charts on the same worksheet as the pivot table, you may find it easier to customize and work with it if you move the chart to its own chart sheet [more…]

How to Set Regional Dates in Excel 2013

Excel 2013 isn’t set up to automatically recognize European date formats in which the number of the day precedes the number of the month and year. For example, you may want 6/11/2014 to represent November [more…]

How to Share Excel 2013 Files

You can share files in Excel 2013 in a variety of ways. Keep in mind when making any last-minute changes in a shared workbook, that some of Excel’s editing features become unavailable to you and any others [more…]

How to Add WordArt in Excel 2013

The WordArt gallery in Excel 2013, opened by clicking the WordArt command button in the Text group of the Insert tab of the Ribbon, makes it a snap to add really artsy text to the worksheet. [more…]

How to Sort on Multiple Fields in Excel 2013

When you need to sort a data list on more than one field in Excel 2013, you use the Sort dialog box. And you need to sort on more than one field when the first field contains duplicate values and you want [more…]

How to Use the Excel 2013 Quick Analysis Tool

Excel 2013 makes it simple to create a new pivot table using a data list selected in your worksheet with its new Quick Analysis tool. To preview various types of pivot tables that Excel can create for [more…]

How to Describe a Custom Excel 2013 Function

To help your user understand the purpose of your custom functions in Excel 2013, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function [more…]

How to Select Cells in Excel 2013

Excel 2013 makes it easy for you to select cell ranges with a physical or Touch keyboard by using a technique known as extending a selection. To use this technique, you move the cell cursor to the active [more…]

How to Split an Excel 2013 Worksheet into Panes

Excel 2013 enables you to split the active worksheet window into two or four panes. After splitting up the window into panes, you can use the Excel workbook’s horizontal and vertical scroll bars to bring [more…]

How to Download a Spreadsheet Template in Excel 2013

Anytime you launch Excel (without also opening an existing workbook file), the Excel screen in the Backstage view presents you with a choice between opening a new workbook or opening a new workbook based [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com