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 ...
Microsoft Office's Excel application allows users to store, model and manipulate data sets. Excel spreadsheets organize this data into worksheets, each with a number of rows and columns. Each row or ...
Squash an odd Excel charting bug that could drive you crazy Your email has been sent If Excel fails to recognize a series, check the heading rows in the data range before reaching for a hammer. The ...
Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...
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 ...
One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...