One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...

When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order. This behavior potentially creates irregular spacing with unpredictable formatting. If the ...

Create professional Excel visuals with custom charts, icon bars, radar charts, and interactive navigation bars with gradients ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

How to use the Geography data type to quickly add a map chart in Excel Your email has been sent Most will agree that a picture is worth a thousand words, and where geographical data is concerned, it’s ...

Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that now supports lambdas and variables, Excel has become a tool that people build businesses ...

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. Have you noticed that people groan when you pop open a spreadsheet to ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

The general ledger is a vast historical data archive of your company’s financial activities, including revenue, expenses, adjustments, account balances, and often much more. The detailed transactions ...