Video description


This video is helpful for users with limited knowledge of Excel. This video covers Excel keyboard shortcuts, how to format your data and other helpful tips to get you on your way to becoming an Excel wizard.

Chapters


  • Who is this session for? [02:38]
  • Session breakdown [04:40]
  • Example Workbook demo [06:23]
  • Keyboard Shortcuts and Tips [07:35]
  • Formatting Data [20:15]
  • Importing Data from Text files [25:52]
  • Sorting and Filtering Data [29:24]
  • Combining Data with formulas [36:18]
  • IF Statements [40:05]
  • Splitting Data with formulas [46:12]
  • VLOOKUP [56:02]
  • Final tips [01:01:15]
  • Q&A [01:02:48]

Related articles


Solving some common Excel problems

Exporting Products

Exporting Contacts

Importing Simple Products

Importing and Updating Product Data