Now they are available for any data that is formatted as a table. Once you are satisfied with the chart, click the OK button (Fig 15, 3).įilter Table Data by Using Slicers Slicers were introduced to Pivot Tables in Excel 2010. Select a chart from the Recommended list (Fig 15, 1) or alternately, click the All Charts tab to select any chart of your choosing (Fig 15, 2). The Insert Chart window will appear (Fig 15). From the Insert tab, select Recommended Charts in the Charts group (Fig 14, 1).ģ. Select the data that you want to chart (Fig 13, 1).Ģ. Press the Enter key on your keyboard to accept the Flash Fill.Ĭhart Recommendations When inserting a new chart into an Excel worksheet, Excel will analyze the data and present recommended options depending on the type of data. After completing at least two entries, Excel will recognize the trend and fill in the remaining blank cell with relevant data (Fig 12, 1). Type a section of the text that you want Excel to autocomplete for you (Fig 11, 1). Click in the column adjacent to the data (Fig 10, 1).Ģ. For instance, if you wish to extract a piece of text from a larger string – you can fill an entire column in a couple of seconds. Figure 9įlash Fill If you have a large amount of data which needs to be entered, the new flash fill feature in Excel 2013 will help. For Sparklines, the data will appear in the column to the right (Fig 9). For Charts, Totals, and Tables, the data will appear on top of the existing data (Fig 8).ĥ. For formatting options, the data will be formatted accordingly (Fig 7). The data will appear depending on the selection. Select a tab from the list and choose an analysis option by clicking the selection (Fig 6, 2). The pop-up window is comprised of five tabs (Fig 6, 1). Analysis options will appear in a pop-up window (Fig 6). Click the Quick Analysis icon (Fig 5, 1). Highlight a section of text you want to analyze (Fig 5).Ģ.
These tools include charts, totals, tables, sparklines and formatting. Quick Analysis Tool The Quick Analysis Tool provides single-click access to data analysis tools. Alternately, you can click the Browse button to launch the Open dialog window (Fig 4, 3). Select a location from the left pane (Fig 4, 1) and a folder from the right pane (Fig 4, 2). To Open other documents, click the Open Other Documents button (Fig 3, 3). Templates appear on the Right Panel (Fig 3, 2). Recent Documents appear on the Left Panel (Fig 3, 1). The Launch Screen When an Office Application opens, the Launch Screen will appear (Fig 3). Click the File tab on the Ribbon (Fig 1, 2). The program view defaults to the Home tab (Fig 1, 1). Quick Analysis Tool Flash Fill Chart Recommendations Filter Table Data by Using Slicersġ. Backstage View is where you manage the file actions of a Microsoft document, slideshow or worksheet such as creating, saving, setting file properties, printing or modifying program options. Modified Backstage View The Backstage view was introduced in the 2010 version of Microsoft Office. Introduction Modified Backstage View Launch Screen In this self-help document, you will learn about the general new features that are available in the 2013 version of Microsoft Excel. 60-day money back guarantee.Microsoft Excel 2013 has undergone some slight user interface (UI) enhancements while still keeping a similar look and feel to Microsoft Excel 2010. Easy deploying in your enterprise or organization. Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic.Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.
Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.
The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%