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.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

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.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.