Excel 2013 Power Shortcuts
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.
- 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
(music playing) Hi! I am Curt Frye. Welcome to Excel 2013 Power Shortcuts. In this course I will show you how to use Excel 2013 efficiently. You'll learn how to use an Excel table column in a formula, create hyperlinks to other resources, and analyze data using the new Quick Analysis Lens. Next, I'll show you how to control the Excel program and its user interface, such as by customizing the Quick Access Toolbar and finding commands that aren't on the Ribbon.
I'll then move on to managing workbooks and worksheets. I cover skills such as finding a target value, picking data from a list, and using the new Flash Fill feature to manage your data. You'll learn how to generate a list of unique random numbers, analyze formulas for errors, and create a chart by pressing one key. I am sure you'll find that your time with Excel 2013 Power Shortcuts will be time well spent. Dive right in.
There are currently no FAQs about Excel 2013 Power Shortcuts.
Excel 2013 Essential Training5,659,883 Views
Excel 2013: Advanced Formulas and Functions946,009 Views
Excel 2013: Pivot Tables in Depth1,203,892 Views
Excel 2013 Tips and Tricks702,997 Views
Access 2013 Essential Training2,494,302 Views
Excel 2010 Essential Training5,756,965 Views
Foundations of Programming: Fundamentals6,728,971 Views
Windows 10 Essential Training725,484 Views
Word 2013 Essential Training1,535,042 Views
PHP with MySQL Essential Training3,907,848 Views