In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it sounds. In fact, once you get started, it's not too steep a ...

Look for it on the Data tab. Instead of pressing Enter, click Flash Fill in the Data Tools group. SEE: Explore 6 ways to save time using Flash Fill in Microsoft Excel.

3. Click on the "Data" tab in the top menu so the Data menu ribbon appears. Once you've highlighted your cells, select the "Data" tab from the top menu. Laura McCamy/Business Insider 4.

Highlight the cells under Breakfast. Click the Data tab and select the Food data type from the Data Types gallery. Click the Insert Data button on the right side of the cell.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.