The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.

The Food Data Type converts cells with food to nutrition details. Learn how to use Food Data Type in Excel to get calorie & nutrition facts.

Fetching live data Since we're dealing with live data to create the dashboard, the first step is to link Excel with the data source so that all the required data can be fetched in real-time.

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.

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.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Learn how to perform regression analysis of your data in Microsoft Excel, a statistical process that helps you understand the relationship ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.