English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 20m | 845 MB
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 PivotTable tips, and much more.
Note: This course was recorded on Excel for Office 365; however, most of the contents will benefit anyone using Office 2019 or 2016.
Topics include:
- Creating charts with keystroke shortcuts
- Expanding and collapsing ribbon and full-screen views
- Display shortcuts
- Efficiently navigating between workbooks and worksheets
- Selecting entire rows, columns, regions, and worksheets
- Data entry and editing shortcuts
- Rapidly creating formulas
- Operational and formatting shortcuts
- Data management techniques
Table of Contents
Introduction
1 Save time in Excel
Seven Significant Shortcuts
2 Enter data or formulas in nonadjacent cells simultaneously
3 Copy data or formulas down a column
4 Instantly enter today s date or time
5 Convert formulas to values with a simple drag
6 Display all worksheet formulas
7 Create charts with these keystroke shortcuts
8 Zoom in and out quickly
Ribbon and Quick Access Toolbar Tips
9 Access ribbon commands with Alt key sequences
10 Expand and collapse the ribbon and full-screen views
Display Shortcuts
11 Create split screens and frozen titles in a flash
12 Restore missing labels and hide repeating labels
13 Customize the display of status bar totals
Navigation and Selection Shortcuts
14 Navigate between workbooks and worksheets efficiently
15 Navigate within worksheets efficiently
16 Open close save and create new workbooks with keystrokes
17 Select an entire row column region or worksheet
18 Select noncontiguous ranges and visible cells only
Data Entry and Editing Shortcuts
19 Accelerate data entry
20 Enter dates and date series efficiently
21 Enter times and time series efficiently
22 Use custom lists for data entry and list-based sorting
23 Enhance editing tools
Drag and Drop Techniques
24 Accelerate copy and move tasks within cells and worksheets
25 Drag and insert cells with the Shift key
26 Display the Paste Special options
27 Accelerate copy move and paste actions with the right mouse button
Formula Shortcuts
28 Create formulas rapidly
29 Select all dependent or precedent cells
30 Use AutoSum shortcuts
31 Count the number of unique entries
32 Use conditional formatting to highlight formula cells
33 Perform calculations without formulas
Operational Shortcuts
34 Insert delete hide and unhide columns and rows
35 Realign imported text
36 Select and manipulate blank cells
37 Collapse and expand detail with group and ungroup buttons
38 Create double-spaced or triple-spaced printouts
Formatting Shortcuts
39 Use keystroke shortcuts for frequently needed numeric formats
40 Accentuate data with alignment tools
41 Add a color background to every fifth row in a range
42 Use conditional formatting based on comparison criteria
43 Use special formats for times over 24 hours
44 Add and remove strikethrough and borders with keystroke shortcuts
45 Display values in thousands or millions without formulas
46 Format phone and social security numbers
Data Management Techniques
47 Clean up spaces with the TRIM function
48 Split column data using Text to Columns and Flash Fill
49 Join data with the TEXTJOIN function and Flash Fill
50 Insure unique entries with data validation rules
51 Display unique items from large lists
Charting and Visual Object Tips
52 Manipulate chart placement and sizing with dragging techniques
53 Create chart titles from cell content
54 Create and manipulate shapes with the Shift Ctrl and Alt keys
55 Create linked dynamic and linked static images
PivotTable Tips
56 Adjust report layouts to allow totals on top or bottom
57 Revisit relevant source data with the drill down feature
Tiny Tips
58 Become a more proficient Excel user with these short tips
Conclusion
59 Next steps
Resolve the captcha to access the links!