The Data menu contains many important features in Excel to manipulate data in your spreadsheet; it includes features to import and add connections to the database, sort and filter data, data ...

Learn how to efficiently clean data using Power Query in Microsoft Excel 365 to help improve your data analysis, calculations and spreadsheet ...

With Excel, you can quickly and easily move, organize, and manipulate data in individual cells and columns. If you wish to reorder the representation of data by moving a column, there are two main ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

We’ve put together top resources from some Excel experts to help you deliver your 2014 analysis and results.

Learn how to create impressive McKinsey style charts in Microsoft Excel spreadsheets to visualize your data in more dynamic and visually ...