Excel: Tips and Tricks

Focused View

Dennis Taylor

2:33:35

212 View

01 - Introduction

01 - Become a proficient Excel user.mp4

00:27

02 - 1. Seven Super Shortcuts

01 - Enter data or formulas in non-adjacent cells simultaneously.mp4

02:50

02 - Copy data or formulas down a column.mp4

03:19

03 - Instantly enter todays date or time.mp4

03:33

04 - Convert formulas to values with a simple drag.mp4

03:50

05 - Display all worksheet formulas instantly.mp4

03:05

06 - Create charts instantly with these keyboard shortcuts.mp4

03:38

07 - Zoom in and out quickly.mp4

03:57

03 - 2. Ribbon and Quick Access Toolbar Tips

01 - Access ribbon commands with Alt key sequences.mp4

04:12

02 - Expand or collapse the ribbon and full screen views.mp4

02:23

04 - 3. Display Shortcuts

01 - Create split screens and frozen titles in a flash.mp4

04:27

02 - Restore missing labels and hide repeating labels.mp4

03:58

05 - 4. Navigation and Selection Shortcuts

01 - Navigate between workbooks and worksheets efficiently.mp4

04:36

02 - Navigate within worksheets efficiently.mp4

03:46

03 - Open, close, save, and create new workbooks with shortcuts.mp4

03:00

04 - Select an entire row, column, region, or worksheet.mp4

02:13

05 - Select non-contiguous ranges and visible cells only.mp4

03:20

06 - 5. Data Entry and Editing Shortcuts

01 - Accelerate data entry.mp4

04:00

02 - Enter dates and date series efficiently.mp4

03:23

03 - Enter times and time series efficiently.mp4

04:33

04 - Use Custom Lists for rapid data entry and list-based sorting.mp4

04:15

07 - 6. Drag-and-Drop Techniques

01 - Accelerate copy and move tasks in cells and worksheets.mp4

02:36

02 - Drag and insert cells with the Shift key.mp4

02:33

03 - Display Paste Special options instantly.mp4

02:29

04 - Accelerate formatting with the right mouse button.mp4

02:31

08 - 7. Formula Shortcuts

01 - Create formulas rapidly.mp4

04:18

02 - Select all dependent or precedent cells.mp4

04:17

03 - Use AutoSum shortcuts.mp4

02:21

04 - Use Conditional Formatting to highlight formula cells only.mp4

02:42

05 - Perform calculations without formulas.mp4

02:50

09 - 8. Operational Shortcuts

01 - Re-align imported text.mp4

02:53

02 - Collapseexpand detail quickly with groupungroup buttons.mp4

04:06

03 - Create double-spaced printouts quickly.mp4

02:55

10 - 9. Formatting Shortcuts

01 - Use keyboard shortcuts for frequently used numeric formats.mp4

04:17

02 - Accentuate data with alignment tools.mp4

02:26

03 - Addremove borders and strikethrough with keyboard shortcuts.mp4

03:21

04 - Display values in thousands or millions without formulas.mp4

03:26

05 - Quickly format phone and SS numbers.mp4

03:33

11 - 10. Data Management Techniques

01 - Clean up spaces quickly with the TRIM function.mp4

03:17

02 - Split column data using Text to Columns and Flash Fill.mp4

03:43

03 - Ensure unique entries with data validation rules.mp4

03:58

12 - 11. Charting and Visual Object Tips

01 - Control chart placement and sizing with dragging techniques.mp4

04:09

02 - Create and manipulate shapes with the Shift, Ctrl, and Alt keys.mp4

03:30

03 - Create linked dynamic and linked static images.mp4

04:00

13 - 12. Ten Tiny Tips

01 - Become a more proficient Excel user with these short tips.mp4

04:19

14 - Conclusion

01 - Continue learning Excel.mp4

00:20

Description

Want to take your Excel game to the next level? In this course, veteran Excel trainer and instructor Dennis Taylor shares powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus, discover drag and drop techniques, formatting shortcuts, charting, and much more.

Note: This course was recorded on Excel for Microsoft 365; however, most of the contents will benefit anyone using Office 2019 or 2016.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Dennis Taylor

Instructor's Courses

Leading Excel trainer with more than 200 hours (60+ courses) of online Excel training available on LinkedIn Learning. Presenter of in-person Excel classes and seminars in over 40 states and Canada. To learn more, visit www.excel-train.com.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.