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
http://www.rarefile.net/s2z30j4suoty/Lynda.Excel.2013.Power.Shortcuts.rar
.
0 Response to this entry.