Excel 2013 For Dummies Extras

Sorted by:  

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…]

Excel 2013 All-in-One For Dummies Cheat Sheet

Microsoft Excel 2013 gives you access to hot key sequences that keyboard enthusiasts can use to greatly speed up the process of selecting program commands. The first thing to know is that you activate [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com