Introduction
  • Welcome
Excel Productivity Tips - Part 1
  • Tip #1: Camera Tool
  • Tip #2: Add Line Break in Formula Bar
  • Tip #3: Advanced Copy-Paste using Office Clipboard
  • Tip #4: Navigation between Worksheets using Shortcut Keys
  • Tip #5: Flash Fill
  • Tip #6: Add Multiple Rows and Columns Quickly
  • Tip #7: Delete Blank Rows
  • Tip #8: Multi Level Row and Column Sorting
  • Tip #9: Add Sparklines
  • Tip #10: Paste Special - Transpose
Excel Productivity Tips - Part 2
  • Tip #11: Snap to Grid
  • Tip #12: Create Custom Autofill List
  • Tip #13: Absolute Cell Reference
  • Tip #14: Import Data from Web page
  • Tip #15: Move Cell Direction
  • Tip #16: Delete Data using Mouse
  • Tip #17: Status Bar Quick Calculations
  • Tip #18: Link Text Boxes to Cell
  • Tip #19: Phone Number and ZIP Code Format
  • Tip #20: Speaking Cell
Excel Productivity Tips - Part 3
  • Tip #21: Invisible Text
  • Tip #22: Worksheet Grouping
  • Tip #23: Advanced Transpose
  • Tip #24: XLStart Folder
  • Tip #25: Use Slicers
  • Tip #26: Convert Text to Numbers
  • Tip #27: Hiding Workbook Elements
  • Tip #28: Useful Shortcut Keys
  • Tip #29: Sort data from Left to Right
  • Tip #30: Advanced Filter (Complex)
Wrap Up
  • Thank You