http://blog.contextures.com/ar chives/2009/07/01/excel-ate-my -numbers/ A nasty Excel bug is eating the credit card numbers. How will they order the crucial replacement parts? Excel stores 15 significant digits, and cell format will control what's displayed.

mwCEI8nSgls

http://www.contextures.com/xlC ondFormat01.html -- Use conditional formatting to highlight rows where the date is Saturday or Sunday.

wbRLhPoZhPo

The cell reference changed, even though it was an absolute reference. For information on the INDIRECT function, please visit http://www.contextures.com/xlF unctions05.html
This animated video was made at Xtranormal.com -- a fun experiment.

W_0B5eBkc-0

Convert percentages to letter grades with a VLookup formula in Excel. For written instructions see http://www.contextures.com/xlF unctions02.html#Range

YmseU3Wiod0

Make it quick and easy to move through cells in a specific order, by using a named range. For more Excel tips visit http://www.contextures.com/tip tech.html

unUqxBM68zg

When you paste or fill in Excel, option dropdowns might appear. You can turn these off. Excel tips at http://www.contextures.com

vVyR65ikmxo

Dr5fg1Mr6Nw

Quickly hide the commands on the Excel 2007 Ribbon, to make more room for your data. http://www.contextures.com/tip tech.html

WURfA4gOplQ

Quickly summarize a large table of data in an Excel 2007 pivot table. Details at http://www.contextures.com

HvZVSn7JkfI

In Excel, use a mouse shortcut to quickly copy formulas and paste the results as values. Detailed instructions at http://blog.contextures.com/ar chives/2009/02/04/paste-values -shortcut-for-excel/

zhmR80YXRzY

http://www.contextures.com/xla dvfilter01.html
If data is on one sheet, use a filter to extract some data to a different sheet.
Excel Contextures Filter Advanced Filter

bGUKjXmEi2E

http://www.contextures.com/xlP ivot14.html
With running totals you can show accumulated sales for the year, over several months. Use the Custom Calculation feature in Excel's pivot tables
Detailed instructions at:
http://www.contextures.com/xlP ivot14.html

2MjeqlTWUdk