Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2007 Power Shortcuts, Adobe product manager and designer Michael Ninness, shows many of the tips and tricks he's picked up throughout his career to make Excel work for him. Michael starts with his top ten shortcuts, then continues with tips for navigation, cell selection, formatting, and data entry. He shows how to make a sheet easier to read by shading every other row, and demonstrates how to remove hyperlinks from selected cells. He explains how to get basic statistics from the Status bar, and introduces the ever-useful AutoSum keyboard shortcut. This course is filled with useful tips for anyone who uses Excel to track projects, create spreadsheets, or build forms. Exercise files accompany the course.
(Music playing.) Hello! I am Michael Ninness. If you are like most Excel users, you probably know the basics of how to create and format spreadsheets, just enough to get by. This course aims to morph you into an Excel Power User and it's designed to reveal the essential tricks and hidden shortcuts, so you can do those everyday tasks in Excel faster and more efficiently. At the start of this course, we will cover the top ten power shortcuts that all Excel users must memorize. From there, I will show you how to make Excel fly by keeping your hands on the keyboard as much as possible.
I will teach you dozens of productivity tips, like how to customize the new Ribbon interface by adding your most used commands to the quick access toolbar, cool keyboard shortcuts to instantly change the formatting of your text and numerical data, tricks for selecting rows and columns and ranges of cells quickly, and how to get Excel to enter data for you automatically. I have developed this course so that it can be watched from start to finish and also used as an on going quick reference tool. With that in mind, I recommend you breeze through the entire course but come back often for specific reminders, until you have memorized all the power shortcuts that are relevant to you and your Excel work.
Now, let's get started with Excel 2007 Power Shortcuts.
There are currently no FAQs about Excel 2007 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.