arrow_back
SECTION 1: Introduction
1 : Course Introduction
2 : Getting Started
3 : Mastering Excel Shortcuts, Tricks and Tips for Productivity
4 : Mastering Shortcuts Tricks and Tips
SECTION 2: Sheet & Workbook Shortcuts & Tricks
4 : Navigating between Worksheets & Workbooks
5 : Grouping
6 : Renaming, Moving & Deleting Worksheets
SECTION 3: Formatting Shortcuts
7 : Rapid Formatting for Cells & Text
8 : Cell Styles & Themes
9 : Conditional Formatting
10 : Custom Number Formatting
SECTION 4: Ribbon & Quick Access Toolbar
11 : Customising the Ribbon
12 : Quick Access Toolbar
13 : Adding & Managing Commands
SECTION 5: Navigation Shortcuts
14 : Moving around Large Worksheets
15 : Jump to Specific Ranges
16 : Using Name Box for Quick Navigation
SECTION 6: Date & Time Shortcuts
17 : Entering Dates and Times Effortlessly
18 : Calculating Date & Time Differences
19 : Using Date & Time Functions
SECTION 7: Table Shortcuts
20 : Table Shortcuts
21 : Filtering & Sorting
22 : Table Formatting Tricks
SECTION 8: Pivot Table Shortcuts
23 : Building Pivot Tables Quickly
24 : Customising Pivot Tables for Analysis
25 : Expanding & Collapsing Pivot tables
SECTION 9: Chart Shortcuts
26 : Creating Stunning Pivot Charts
27 : Modify Chart Types & Styles
28 : Dynamic Charting Techniques
SECTION 10: Number Shortcuts
29 : Formatting Numbers for Clarity
30 : Applying Currency, % & Accounting Formats
31 : Rounding & Truncating Numbers
SECTION 11: Editing & Other Shortcuts
32 : Copying & Pasting Tricks
33 : Undo & Redo Smartly
34 : Find & Replace Techniques
SECTION 12: Row & Column Shortcuts
35 : Inserting & Deleting Rows & Columns
L36 : Hiding_Unhiding - Grouping_Ungrouping Rows & Columns
37 : Adjusting Row Height & Column Width
SECTION 13: Formula Shortcuts, Tricks & Tips
38 : Building Formulas Faster
39 : Using Named Ranges & Cells
40 : Debugging & Auditing Formulas
SECTION 14: Bonus Tricks & Hacks
41 : Bonus Tricks & Tips
CONCLUSION
Course Conclusion