Excel 2013

Learn how to manage worksheets in a workbook: insert, rename, color tab, delete, move, and group multiple sheets, and understand compatibility mode and hiding/unhiding sheets.

Learn to create and manage custom views in Excel 2013, capturing original views, quarterly totals, and bill views, and use zoom, hide rows, and auto fit to tailor worksheet presentations.

Explore Flash Fill in Excel 2013 to automatically complete names and create full names from first and last names, using a tour template and practice files.

Sort Excel 2013 data by single and multiple fields, restore original order, and control dates and days of week using the Data tab and the big sort button.

Turn on auto filter arrows from the data tab to filter data, use checkboxes to select multiple criteria, and sort within the filtered results.

Use the remove duplicates tool to delete later duplicates by selecting key columns including the header row, keeping the first record and removing later ones.

Navigate through large wine sales data by creating a pivot table in Excel 2013, renaming worksheets, and analyzing the best selling wines and the best selling salesperson.

Right-click a value in the pivot table, open value field settings, and set number format to currency with dollar signs, two decimals, and thousands separators for all cells.

Master data validation in Excel 2013 by configuring pull-down lists from lookup sources. Add input messages and stop or warning error alerts to enforce data-entry rules.

Link data between worksheets in the same workbook using equals formulas or paste special, build a totals sheet for quarterly state totals, and understand absolute references in Excel 2013.

Master Excel 2013's averageif by calculating conditional averages from software expense data, using range, criteria, and an average range, alongside familiar sumif comparisons.

Explore how vlookup uses true to return the closest match from the bonus look up range, using the largest value less than the target and a column 2 bonus.

Learn date functions in Excel 2013 to calculate days overdue and days since birth using today and date subtraction, and add days to dates to schedule future dates.

Explore using Excel 2013 data tables to analyze multiple inputs and outputs in a loan amortization problem. Build a PMT calculation and master absolute references with dollar signs for results.

Record macros in Excel 2013, choose absolute or relative references, name and store them, assign a shortcut, and view or edit the generated VBA code.

Record a formatting macro in Excel 2013 by selecting cells and changing font styles. Learn how relative versus absolute references affect macro playback and when to start or stop recording.