Viewers: in countries Watching now:
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.
(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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.