So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

Simplify data analysis with Excel PivotTables. Learn how to replace formulas, uncover trends, and create dynamic reports in minutes.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more. Everyone knows Microsoft Excel as a ...

You’re probably familiar with selection shortcuts in Microsoft Excel. There are several that select text, sentences, whole paragraphs, and so on, so it should come as no big surprise that shortcuts ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...