Excel - Tips and Tricks (2025)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 01 - Introduction
• 01 - Become a proficient Excel user.mp4 (1.6 MB)
• 01 - Become a proficient Excel user.srt (0.8 KB)
02 - 1. Seven Super Shortcuts
• 01 - Enter data or formulas in nonadjacent cells simultaneously.mp4 (8.6 MB)
• 01 - Enter data or formulas in nonadjacent cells simultaneously.srt (6.3 KB)
• 02 - Copy data or formulas down a column.mp4 (11.5 MB)
• 02 - Copy data or formulas down a column.srt (6.8 KB)
• 03 - Instantly enter today's date or time.mp4 (10.3 MB)
• 03 - Instantly enter today's date or time.srt (8.8 KB)
• 04 - Convert formulas to values with a simple drag.mp4 (12.1 MB)
• 04 - Convert formulas to values with a simple drag.srt (6.9 KB)
• 05 - Display all worksheet formulas instantly.mp4 (12.8 MB)
• 05 - Display all worksheet formulas instantly.srt (7.9 KB)
• 06 - Create charts instantly with these keystroke shortcuts.mp4 (7.2 MB)
• 06 - Create charts instantly with these keystroke shortcuts.srt (4.7 KB)
• 07 - Zoom in and out quickly.mp4 (19.2 MB)
• 07 - Zoom in and out quickly.srt (7.6 KB)
03 - 2. Ribbon and Quick Access Toolbar Tips
• 01 - Access ribbon commands with Alt key sequences.mp4 (14.6 MB)
• 01 - Access ribbon commands with Alt key sequences.srt (6.9 KB)
• 02 - Expand or collapse ribbon and full‑screen views.mp4 (8.2 MB)
• 02 - Expand or collapse ribbon and full‑screen views.srt (4.2 KB)
04 - 3. Display Shortcuts
• 01 - Create split screens and frozen titles in a flash.mp4 (37.7 MB)
• 01 - Create split screens and frozen titles in a flash.srt (14.1 KB)
• 02 - Restore missing labels or hide repeating labels.mp4 (22.1 MB)
• 02 - Restore missing labels or hide repeating labels.srt (11.6 KB)
05 - 4. Navigation and Selection Shortcuts
• 01 - Navigate between workbooks and worksheets efficiently.mp4 (15.7 MB)
• 01 - Navigate between workbooks and worksheets efficiently.srt (9.0 KB)
• 02 - Navigate within worksheets efficiently.mp4 (24.6 MB)
• 02 - Navigate within worksheets efficiently.srt (10.2 KB)
• 03 - Use keystrokes to open, close, save, and create new workbooks.mp4 (6.7 MB)
• 03 - Use keystrokes to open, close, save, and create new workbooks.srt (4.3 KB)
• 04 - Select an entire row, column, range, or worksheet.mp4 (11.8 MB)
• 04 - Select an entire row, column, range, or worksheet.srt (5.1 KB)
• 05 - Select noncontiguous ranges and visible cells only.mp4 (22.2 MB)
• 05 - Select noncontiguous ranges and visible cells only.srt (9.0 KB)
06 - 5. Data Entry and Editing Shortcuts
• 01 - Accelerate data entry.mp4 (11.7 MB)
• 01 - Accelerate data entry.srt (10.8 KB)
• 02 - Enter dates and date series efficiently.mp4 (10.6 MB)
• 02 - Enter dates and date series efficiently.srt (7.2 KB)
• 03 - Enter times and time series efficiently.mp4 (11.6 MB)
• 03 - Enter times and time series efficiently.srt (9.1 KB)
• 04 - Use custom lists for rapid data entry and list-based sorting.mp4 (31.1 MB)
• 04 - Use custom lists for rapid data entry and list-based sorting.srt (14.1 KB)
07 - 6. Drag-and-Drop Techniques
• 01 - Accelerate copy and move tasks.mp4 (7.7 MB)
• 01 - Accelerate copy and move tasks.srt (6.0 KB)
• 02 - Drag and insert cells with the Shift key.mp4 (9.9 MB)
• 02 - Drag and insert cells with the Shift key.srt (5.1 KB)
• 03 - Display Paste Special options instantly.mp4 (11.7 MB)
• 03 - Display Paste Special options instantly.srt (6.0 KB)
• 04 - Accelerate formatting with the right mouse button.mp4 (8.2 MB)
• 04 - Accelerate formatting with the right mouse button.srt (4.1 KB)
08 - 7. Formula Shortcuts
• 01 - Create formulas rapidly.mp4 (17.0 MB)
• 01 - Create formulas rapidly.srt (9.8 KB)
• 02 - Select all dependent or precedent cells.mp4 (10.6 MB)
• 02 - Select all dependent or precedent cells.srt (6.2 KB)
• 03 - Use AutoSum shortcuts.mp4 (9.0 MB)
• 03 - Use AutoSum shortcuts.srt (6.9 KB)
• 04 - Highlight formula cells only with conditional formatting.mp4 (7.7 MB)
• 04 - Highlight formula cells only with conditional formatting.srt (5.2 KB)
• 05 - Perform calculations without formulas.mp4 (10.1 MB)
• 05 - Perform calculations without formulas.srt (6.2 KB)
09 - 8. Operational Shortcuts
• 01 - Realign imported text.mp4 (9.5 MB)
• 01 - Realign imported text.srt (7.3 KB)
• 02 - Collapse and expand detail using group and ungroup buttons.mp4 (17.3 MB)
• 02 - Collapse and expand detail using group and ungroup buttons.srt (8.2 KB)
• 03 - Create double-spaced or triple-spaced printouts quickly.mp4 (9.3 MB)
• 03 - Create double-spaced or triple-spaced printouts quickly.srt (5.3 KB)
10 - 9. Formatting Shortcuts
• 01 - Use keyboard shortcuts for frequently used numeric formats.mp4 (16.9 MB)
• 01 - Use keyboard shortcuts for frequently used numeric formats.srt (11.5 KB)
• 02 - Accentuate data with alignment tools.mp4 (8.6 MB)
• 02 - Accentuate data with alignment tools.srt (6.0 KB)
• 03 - Add or remove borders and strikethrough with shortcuts.mp4 (13.1 MB)
• 03 - Add or remove borders and strikethrough with shortcuts.srt (8.0 KB)
• 04 - Display values in thousands or millions without formulas.mp4 (13.3 MB)
• 04 - Display values in thousands or millions without formulas.srt (8.2 KB)
• 05 - Quickly format phone and Social Security numbers.mp4 (14.7 MB)
• 05 - Quickly format phone and Social Security numbers.srt (7.2 KB)
11 - 10. Data Management Techniques
• 01 - Clean up spaces quickly with the TRIM function.mp4 (15.4 MB)
• 01 - Clean up spaces quickly with the TRIM function.srt (7.6 KB)
• 02 - Split column data using Text to Columns or Flash Fill.mp4 (10.8 MB)
• 02 - Split column data using Text to Columns or Flash Fill.srt (7.3 KB)
• 03 - Ensure unique entries with data validation rules.mp4 (9.7 MB)
• 03 - Ensure unique entries with data validation rules.srt (7.3 KB)
• 04 - Fast sorting and filtering with the right mouse button.mp4 (14.6 MB)
• 04 - Fast sorting and filtering with the right mouse button.srt (7.1 KB)
12 - 11. Charting and Visual Object Tips
• 01 - Drag to control chart placement and sizing.mp4 (15.5 MB)
• 01 - Drag to control chart placement and sizing.srt (11.5 KB)
• 02 - Create and manipulate shapes with Shift, Ctrl, and Alt.mp4 (13.0 MB)
• 02 - Create and manipulate shapes with Shift, Ctrl, and Alt.srt (9.7 KB)
• 03 - Create dynamic and static linked images.mp4 (14.8 MB)
• 03 - Create dynamic and static linked images.srt (7.3 KB)
• 04 - Quickly create full or partial screen capture images.mp4 (8.7 MB)
• 04 - Quickly create full or partial screen capture images.srt (6.2 KB)
13 - 12. Ten Tiny Tips
• 01 - Continue learning Excel.mp4 (21.6 MB)
• 01 - Continue learning Excel.srt (10.1 KB)
• Bonus Resources.txt (0.1 KB)