Introduction
  • Welcome
Excel Productivity Tips - Part 1
  • Camera Tool
  • Add Line Break in Formula Bar
  • Advanced Copy-Paste using Office Clipboard
  • Navigate between Worksheets using Shortcut Keys
  • Flash Fill
  • Delete Blank Rows Quickly
  • Multi Level Row and Column sorting in Excel
  • Add Spark-lines
Excel Productivity Tips - Part 2
  • Paste Special - Transpose
  • Snap to Grid
  • Import data from a webpage
  • Status Bar Quick Calculations
  • Link Text Boxes to Cell
  • Number format for phone number and pin code/zip code
Excel Productivity Tips - Part 3
  • Invisible Text
  • Worksheet Grouping / Data Replicator
  • Advanced Transpose
  • XLStart Folder
  • How to use Slicers in Excel
  • Convert text to Numbers
  • Hiding Workbook Elements
  • Useful shortcut keys
  • Sort Data from left to right
Excel Productivity Tips - Part 4
  • Email as PDF
  • Quick Analysis of data within Excel
  • How to add blank rows after each data row
  • Custom views in Excel
  • EMBED Feature in Excel
  • Plot an average line to a chart
Wrap Up
  • Thank You