Excel 2013 Power Shortcuts with Curt Frye

Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.

Topics include:

• Entering a data series using the fill handle


• Creating hyperlinks


• Setting a print area


• Applying a table style


• Creating substitute data sets using scenarios


• Wrapping and shrinking text


• Creating a data entry form


• Removing duplicate values


• Inserting the current date or time


• Generating a list of unique random numbers


• Calculating running totals


• Analyzing a formula for errors


• Summarizing data with charts and PivotTables