Reader Adam screencasts one of our best Microsoft Excel tips ever - how to make an instant, in-cell bar graph. Hit the play button above to see it i ...

Text to columns is another handy function when you have data all crammed into one cell, and you need to split it into ...

Excel can do more than just render typed numbers in tables of cells. It can take two columns of numbers and show a pictorial representation of how they relate to each other through a graph.

You can do this by creating a summary chart, which uses subtotals from columns of data rather than data in individual cells.

First time to stick my toe into this part of the fora! Two Excel questions that I cannot find an answer to here or anywhere else on the internets. I have access to Excel 2007 PC and Excel 2004 Mac ...

You may have used Excel for years without delving into Styles (or stylesheets). We’re going to cover Cell Styles, and Smart Art, Drawing, Graphics, Picture, and Chart Tools.

A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

Tired of erasing holes in your graph paper or having to start over from scratch? Here's an easy way to create your own custom graph paper in Excel.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

You can lock the position of a chart in Excel spreadsheet so that it doesn't move or resize when you include more columns and change cell width. Learn how!

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.