Excel 2013 Data

Sorted by:  

How to Add a Comment to a Cell in Excel 2013

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 Drag and Drop in Excel 2013

The first editing technique you need to learn in Excel 2013 is drag and drop. Drag and drop is primarily a technique for moving cell entries around a worksheet, you can adapt it to copy a cell selection [more…]

How to Freeze Panes in Excel 2013

Panes are great for viewing different parts of the same worksheet that normally can’t be seen together in Excel 2013. You can also use panes to freeze headings in the top rows and first columns so that [more…]

How to Edit Comments in a Worksheet in Excel 2013

To edit the contents of a comment in Excel 2013, select it by clicking the Next or Previous command button in the Comments group of the Review tab and then click the Edit Comment button or right-click [more…]

How to Name a Cell or Cell Range in Excel 2013

By assigning descriptive names to cells and cell ranges in Excel 2013, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate [more…]

How to Use the Goal Seek Feature in Excel 2013

When you need to do analysis, you use Excel 2013’s Goal Seek feature to find the input values needed to achieve the desired goal. Sometimes when doing what-if analysis, you have a particular outcome in [more…]

How to Use the Scenario Manager in Excel 2013

Excel 2013’s Scenario Manager option on the What-If Analysis button’s drop-down menu on the Data tab of the Ribbon enables you to create and save sets of different input values that produce different calculated [more…]

How to Find Records with the Data Form in Excel 2013

In a large data list, trying to find a particular record by moving from record to record in Excel 2013 — or even moving ten records at a time with the scroll bar — can take all day. Rather than waste time [more…]

How to Sort Data Lists on a Single Field in Excel 2013

Every data list you put together in Excel 2013 will have some kind of preferred order for maintaining the records. You can sort on a single or multiple fields. Depending on the list, you may want to see [more…]

How to Use Custom Filters in Excel 2013

In addition to filtering a data list to records that contain a particular field entry in Excel 2013, you can create custom AutoFilters that enable you to filter the list to records that meet less-exacting [more…]

How to Query Access Database Tables to Import External Data in Excel 2013

Excel 2013 makes it easy to import data into a worksheet from other database tables created with stand-alone database management systems (such as Microsoft Access), a process known as making an [more…]

How to Perform Web Queries to Import External Data in Excel 2013

To make a web page query in Excel 2013, you click the From web command button on the Data tab of the Ribbon or press Alt+AFW. Excel then opens the New web Query dialog box containing the Home page for [more…]

How to Add Records to Data Lists via the Data Form in Excel 2013

Excel 2013 allows you to add records to data lists by using the data form. The first time you click the custom Form button you added to the Quick Access toolbar, Excel analyzes the row of field names and [more…]

How to Edit Records in the Data Form in Excel 2013

After the database is under way and you’re caught up with entering records in Excel 2013, you can start using the data form to edit and perform routine maintenance on the database. For example, you can [more…]

How to Move Through Records in the Data Form in Excel 2013

Excel 2013 allows you to move through the records you have created in the data form. You can use the scroll bar to the right of the list of field names or various keystrokes to move through the records [more…]

Excel 2013: Creating a Data List

Using Excel 2013 to create a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings. To set up a new data list, follow these steps [more…]

How to Add Data to Data Lists Using the Excel 2013 Form Button

Instead of entering the records of a data list directly in the table, you can use Excel 2013’s data form to make the entries. The only problem is that the command to display the form in a worksheet with [more…]

How to Sort Data Lists on Multiple Fields in Excel 2013

You need to use multiple fields in sorting in Excel 2013 when the first field you use contains duplicate values and you want a say in how the records with duplicates are arranged. [more…]

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

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

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

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 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 Flash Fill in Excel 2013

Excel 2013’s great new Flash Fill feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes [more…]

Limit Data Entry with Data Validation in Excel 2013

The Data Validation feature in Excel 2013 can be a real timesaver when you’re doing repetitive data entry, and can also go a long way in preventing incorrect entries in your spreadsheets. When you use [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com