Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Enterprise Software

Best new features in Excel 2013

By Susan Harkins November 6, 2013, 10:24 AM PST

Image
1
of 8

excel_gal_promo.png
excel_gal_promo.png
Best new features in Excel 2013

Excel 2013

Excel 2013

These are some of the new features in Excel 2013 that users should get to know. You can see these and a couple more picks in the original blog post, 10 best new features in Excel 2013.

Excel_New_Ftrs.FigA.png
Excel_New_Ftrs.FigA.png
Best new features in Excel 2013

Flash Fill

Flash Fill

Perhaps the closest thing to magic Excel users will ever see in a rnworkbook is Flash Fill. This feature anticipates formatting and data rnrequirements by recognizing patterns so it can finish what you start. This screenshot shows a typical use for Flash Fill. First, I transposed a rnrecord’s name value into last name, first name order. While doing the rnsame for the second record, Flash Fill recognized a pattern and rnsuggested possible entries to complete the column. When Flash Fill rndisplays this list, you have two choices: Press Enter to complete the rnlist or press [Esc] to remove it. To learn more about this feature, readrn Excel 2013 Flash Fill anticipates needs on the fly.

Excel_New_Ftrs.FigB.jpg
Excel_New_Ftrs.FigB.jpg
Best new features in Excel 2013

Recommended Charts

Recommended Charts

Most users don’t always know the best chart type for their data. rnRecommended Charts takes the guesswork out of the process. Simply click rninside the data you want to chart, click the Insert tab, and click rnRecommended Charts to see a collection of suggested chart types, as rnshown above. Then, click a thumbnail to preview your data rnas that chart type. Double-click a thumbnail to embed the chart. Using rnthis feature lets you work with confidence knowing the chart will rnhighlight your data in a meaningful way.

Excel_New_Ftrs.FigC.jpg
Excel_New_Ftrs.FigC.jpg
Best new features in Excel 2013

Recommended PivotTables

Recommended PivotTables

This feature works similar to Recommended Charts, but generates a quick rnPivotTable. It’s a great new feature for most users, because so many of rnus struggle with PivotTables. Click inside the data range (which must rnhave header cells) and click the Insert tab. In the Tables group, click rnRecommended PivotTables to display the dialog shown above. Select a thumbnail and click OK to embed an effective PivotTable in a new sheet.

Excel_New_Ftrs.FigD.jpg
Excel_New_Ftrs.FigD.jpg
Best new features in Excel 2013

Quick Analysis

Quick Analysis

Use Quick Analysis to quickly preview your data in meaningful ways. rnFor instance, Quick Analysis offers a second new way to generate rnappropriate charting for your data. Select the data and then click the rnQuick Analysis icon at the bottom-right, as shown above. Click the Charts tab to view the suggested chart types. If you don’t see this icon, check your settings:

  1. Click the File tab and choose Options from the left pane.
  2. Choose General in the left pane (the default).
  3. Inrn the User Interface Options section, the Show Quick Analysis Options On rnSelection option should be checked. Enabled is the default, so you rnshould see this icon unless someone has changed this setting.
  4. Click OK.
Excel_New_Ftrs.FigE.jpg
Excel_New_Ftrs.FigE.jpg
Best new features in Excel 2013

Timelines

Timelines

A timeline lets you filter records in a PivotTable—it works similar to a slicer, but you’ll filter by dates. For instance, here is a PivotTable and timeline. (I used the same data range used in rn#3.) Once you have a PivotTable arranged, adding the timeline is simple:rn

  1. With the PivotTable selected, click the contextual Analyze tab.
  2. In the Filter group, click Insert Timeline.
  3. Inrn the resulting dialog, check the date field (in this case, that’s Date) rnand click OK. Excel will embed the timeline alongside the PivotTable.
Excel_New_Ftrs.FigF.jpg
Excel_New_Ftrs.FigF.jpg
Best new features in Excel 2013

Cloud support

Cloud support

Microsoft claims that its cloud support is the true shining star of rnthe Office 2013 suite. If you need it, you probably agree; many rnorganizations aren’t taking full advantage of it yet. If you’re curious,rn you can quickly hook up to SkyDrive or your organization’s SharePoint rnteam site by using the Save As (or Open) screen. Doing so has two advantages:

  • Yourn have quick and easy access to your Excel files on any device that runs rnExcel 2013 (including a Windows tablet and smartphone).
  • Using Office 365 (you’ll need a subscription), you can review and edit your workbooks online using almost any web browser.
Excel_New_Ftrs.FigG.jpg
Excel_New_Ftrs.FigG.jpg
Best new features in Excel 2013

Apps for Office

Apps for Office

This new feature provides quick access to specialized programs at Officern Store. Just a quick click and you’re shopping! To install an app, clickrn the Insert tab and then click Apps for office in the Apps group. You’llrn need an account at the store, which the feature will help you create rnthe first time you use it. This slide shows Bing Maps as an installed app.

  • Enterprise Software
  • Microsoft
  • Account Information

    Share with Your Friends

    Best new features in Excel 2013

    Your email has been sent

Share: Best new features in Excel 2013
Image of Susan Harkins
By Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
  • Account Information

    Contact Susan Harkins

    Your message has been sent

  • |
  • See all of Susan's content

TechRepublic Premium

  • TechRepublic Premium

    Media disposal policy

    PURPOSE This Media disposal policy from TechRepublic Premium provides specific instructions for ensuring organization data is properly protected when disposing of old storage media. From the policy: POLICY DETAILS When disposing of damaged, unusable, obsolete, off-lease, decommissioned, old, or end-of-service-life equipment and media, the organization requires that the guidelines outlined herein be followed: Hard drives, ...

    Published:  March 30, 2023, 12:00 PM EDT Modified:  March 31, 2023, 11:06 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    IT email templates: Upcoming software release

    PURPOSE To take some of the effort out of writing (and rewriting) emails to share with company staff and executives, TechRepublic Premium has assembled basic templates to handle the most common types of communications. Simply copy the text into your favorite word processor and customize it to fit your needs. Then, paste it into an ...

    Published:  March 30, 2023, 12:00 PM EDT Modified:  March 31, 2023, 11:29 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Mobile app development policy

    PURPOSE The purpose of this policy from TechRepublic Premium is to provide guidelines for developing mobile applications from a security, procedural and best practices standpoint. While it contains technical guidelines, it is not intended to serve as a programming guide but as a framework for operations. This policy can be customized as needed to fit ...

    Published:  March 29, 2023, 12:00 PM EDT Modified:  March 30, 2023, 4:43 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    New client audit checklist

    PURPOSE This checklist from TechRepublic Premium provides a method for auditing and documenting a client site and assembling an inventory of systems and software, as well as giving you a framework for developing recommendations, applying costs to them, and storing all that information in one file. Tracking client contact details, circuit information, network equipment, cloud ...

    Published:  March 29, 2023, 12:00 PM EDT Modified:  March 30, 2023, 4:54 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice