Excel 2013 Data

View:  
Sorted by:  

How to Edit Cell Content in Excel 2013

You can edit the content of a cell in an Excel 2013 worksheet either in the cell itself or in the Formula bar. If you need to edit the content in a cell, you can [more…]

How to Copy and Move Data In Excel 2013

When you’re creating a spreadsheet in Excel 2013, it’s common not to get everything in the right cells on your first try. Fortunately, moving content between cells is easy. [more…]

How to Use AutoFill in Excel 2013

When you have a lot of data to enter into your Excel 2013 spreadsheet, and that data consists of some type of repeatable pattern or sequence, you can save time by using AutoFill. [more…]

Improve Your Excel Reports with Sparklines

Much of the reporting done in Excel is table-based, in which precise numbers are more important than pretty charts. However, in table-based reporting, you often lose the ability to show important aspects [more…]

3 Types of Sparklines for Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. Although sparklines look like miniature charts (and can sometimes take the place of a chart), this feature is completely [more…]

How to Create Sparklines in Your Excel Dashboards

Sparklines in Excel enable you to see trends and patterns within your data at a glance using minimal real estate on your dashboard. Sparklines are essentially mini word-sized charts placed in and among [more…]

Use Sparkline Groups in Your Excel Dashboards and Reports

Sparklines in Excel enable you to see trends and patterns within your data at a glance using minimal real estate on your dashboard. Most of the time, you’ll probably create a group of sparklines — one [more…]

Excel Dashboards and Reports: Size and Merge Sparkline Cells

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you activate a cell that contains a sparkline, Excel displays an outline around all the sparklines in its [more…]

Customize Sparklines in Your Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you activate a cell that contains a sparkline, Excel displays an outline around all the sparklines in its [more…]

Adjust Sparkline Axis Scaling in Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you create one or more sparklines, they all use (by default) automatic axis scaling. In other words, Excel [more…]

Excel Dashboards and Reports: Fake a Sparkline Reference Line

Sparklines give you the ability to show data trends in your Excel dashboards and reports. One useful feature that’s missing in the Excel 2013 implementation of sparklines is a reference line. For example [more…]

Excel Dashboards and Reports: The Pivot Table

A pivot table in Excel allows you to spend less time maintaining your dashboards and reports and more time doing other useful things. No utility in the whole of Excel allows you to achieve this efficient [more…]

Understand Pivot Tables for Excel Dashboards and Reports

Pivot tables in Excel are extremely useful for dashboarding and reporting. A pivot table is composed of four areas. The data you place in these areas defines both the utility and appearance of the pivot [more…]

Excel Dashboards and Reports: Create Your First Pivot Table

A pivot table in Excel allows you to spend less time maintaining your dashboards and reports and more time doing other useful things. No utility in the whole of Excel allows you to achieve this efficient [more…]

Excel Dashboards and Reports: Rearrange Your Pivot Table

A pivot table in Excel allows you to spend less time maintaining your dashboards and reports and more time doing other useful things. Now here’s the wonderful thing about pivot tables: You can add as many [more…]

Excel Dashboards and Reports: Keep Your Pivot Table Fresh

As boring as your pivot tables may seem, they’ll eventually become the stars of your Excel reports and dashboards. So it’s important to keep your pivot tables fresh and relevant. [more…]

Excel Dashboards and Reports: Customize Pivot Table Field Names

The pivot tables you create in Excel for your dashboards and reports often need to be tweaked to get the look and feel you’re going for. Notice that every field in your pivot table has a name. The fields [more…]

Excel Dashboards and Reports: Change Summary Calculations

When creating your pivot table report, Excel will, by default, summarize your data by either counting or summing the items. Instead of Sum or Count, you might want to choose functions, such as [more…]

Suppress Subtotals in Your Excel Pivot Table Reports

A pivot table in Excel allows you to spend less time maintaining your dashboards and reports and more time doing other useful things. Notice that each time you add a field to your pivot table, Excel adds [more…]

Show and Hide Pivot Table Data Items On Your Reports

An Excel pivot table summarizes and displays on a report all the records in your source data table. There may be situations however, when you want to inhibit certain data items from being included in your [more…]

Hide or Show Pivot Table Items without Data On Your Reports

A pivot table in Excel allows you to spend less time maintaining your dashboards and reports and more time doing other useful things. By default, your pivot table shows only data items that have data. [more…]

Pivot-Driven Top and Bottom Views in Excel Reports

Dashboarding and reporting in Excel is often about showing actionable data. You’ll often find that managers are interested in the top and bottom of things: the top 50 customers, the bottom 5 sales reps [more…]

Create Pivot Table Views by Month, Quarter, Year for Excel Reports

The pivot tables you create in Excel for your dashboards and reports often need to be tweaked to get the look and feel you’re going for. Raw transactional data is rarely aggregated by month, quarter, or [more…]

Create a Pivot Table Percent Distribution View for Your Excel Reports

One of the more useful report views in an Excel pivot table is the percent distribution view. A percent distribution (or percent contribution) view allows you to see how much of the total is made up of [more…]

Create a Pivot Table YTD Totals View for Your Excel Report

A useful report view in an Excel pivot table is the YTD totals view. Sometimes it’s useful to capture a running-totals view to analyze the movement of numbers on a year-to-date [more…]

Listings:1-2526-5051-7576-100more...
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com