Use flash fill in Excel 2013 or later to automatically extract or to automatically combine data. Flash Fill in Excel only works when it recognizes a pattern.

This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.

Use the ‘Paste Special Transpose’ option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet.

It is a useful built in feature in excel that can save a lot of time. This feature is mostly used while we are importing data in excel workbook.

Normally, we hide or unhide rows and columns by using the Hide or Unhide features from the right-clicking menu. Besides this method, we can hide or unhide rows or columns easily with plus or minus sign in Excel.

When you’re collaborating with others on your spreadsheet, inserting comments can save you a lot of time.

If you create a custom list in Excel, you can easily fill a range with your own list of departments, clients, cities, credit card numbers, etc.

It’s easy to create all sorts of sequences in Excel.

Use AutoFill in Excel to automatically fill a series of cells. This page contains many easy to follow AutoFill examples.