Author
Released
8/12/2010- 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
Skill Level Intermediate
Duration
Views
- Hi, I'm 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've been working with Excel since the early 90s, and 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. And 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.
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Excel 2010: Advanced Formatting Techniques
with Dennis Taylor3h 2m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate -
Excel 2010: Macros
with Dennis Taylor2h 44m Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Top Ten Shortcuts
-
Print Preview1m 7s
-
Instant date or time entry1m 16s
-
Undo/Redo/Repeat3m 19s
-
Zooming in and out quickly2m 10s
-
2. Ribbon and Quick Access Toolbar Tips
-
Keyboard command access2m 22s
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigation shortcuts2m 30s
-
Navigating within worksheets5m 13s
-
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerating data entry6m 27s
-
Custom lists for rapid entry5m 54s
-
Cell editing tips2m 19s
-
-
7. Drag-and-Drop Techniques
-
Copy/Move acceleration tips3m 27s
-
-
8. Formula Shortcuts
-
Rapid formula creation3m 48s
-
AutoSum shortcuts2m 57s
-
Rounding shortcuts5m 14s
-
Generating random numbers3m 16s
-
Counting unique entries3m 11s
-
-
9. Operational Shortcuts
-
Controlling rows and columns5m 50s
-
Realigning imported text2m 27s
-
Handling blank cells4m 20s
-
-
10. Formatting Shortcuts
-
Formatting numbers6m 49s
-
Aligning data3m 49s
-
Creating custom formats6m 23s
-
-
11. Database Techniques
-
Sorting shortcuts2m 40s
-
Cleaning up spaces4m 47s
-
Identifying duplicates6m 10s
-
Splitting columns3m 57s
-
Ensuring unique entries2m 46s
-
-
12. Charting and Visual Object Tips
-
Placing and adjusting charts2m 37s
-
-
Conclusion
-
Goodbye9s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome