Excel 2010 Power Shortcuts

with Dennis Taylor
please wait ...
Excel 2010 Power Shortcuts
Video duration: 0s 3h 43m Intermediate


In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.

Topics include:
  • Creating charts with keyboard shortcuts
  • Converting formulas to values by dragging
  • Repeating Undo and Redo actions
  • Displaying formulas instantly
  • Navigating quickly through worksheets and across workbooks
  • Formatting numeric, and date/time data in a flash with keystroke shortcuts
  • Inserting dates or times instantly
  • Grouping rows or columns to create collapsible regions
  • Building data-entry shortcuts with Auto-fill
  • Displaying unique items from large lists


Hi, I am Dennis Taylor and welcome to Excel 2010 Power Tips and Shortcuts. Would you like to be more productive as you use Excel? Would you like to use Excel with speed and confidence? Of course, you would. I have been working with Excel since the early 1990s, and I have always been intrigued by the variety of tips, tricks and shortcuts that are not very well-known by most Excel users. This course brings together over a hundred tips that will make your use of Excel more efficient, more exciting and more fun.

I'll show you the top ten shortcuts that every Excel user should know and also how to use the Ribbon menu system much more effectively, how to eliminate time-consuming dragging methods to copy, move, and paste data, how to simplify frequently-used data entry and formatting tasks, how to rapidly build formulas to calculate results in a flash, and how to manipulate and massage data and display charts in no time at all. Throughout the course you'll learn dozens of keystroke shortcuts that will save you a ton of valuable time and have you wondering how you could ever have done without them.

So, we've got a lot to show you. Let's get started.

Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts .

Expand all | Collapse all
please wait ...
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
please wait ...