Contextures Excel Tutorials
contextures's Channel
 
Excel Ate My Numbers contextures - 122 views - 4 days ago
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
Highlight Weekend Dates in Excel by contextures.com contextures - 66 views - 2 weeks ago
http://www.contextures.com/xlC ondFormat01.html -- Use conditional formatting to highlight rows where the date is Saturday or Sunday.
wbRLhPoZhPo
Absolute Reference Problems contextures - 337 views - 3 weeks ago
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 Excel VLookup by www.contextures.com contextures - 793 views - 1 month ago
Convert percentages to letter grades with a VLookup formula in Excel. For written instructions see http://www.contextures.com/xlF unctions02.html#Range
YmseU3Wiod0
Excel Data Entry in Specific Cells by www.contextures.com contextures - 247 views - 1 month ago
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
Turn Off Paste Options In Excel by www.contextures.com contextures - 104 views - 2 months ago
When you paste or fill in Excel, option dropdowns might appear. You can turn these off. Excel tips at http://www.contextures.com
vVyR65ikmxo
AutoFilterButtons contextures - 134 views - 3 months ago
Dr5fg1Mr6Nw
Minimize Excel 2007 Ribbon contextures - 40 views - 3 months ago
Quickly hide the commands on the Excel 2007 Ribbon, to make more room for your data. http://www.contextures.com/tip tech.html
WURfA4gOplQ
Create a Simple Pivot Table in Excel 2007 contextures - 1,501 views - 4 months ago
Quickly summarize a large table of data in an Excel 2007 pivot table. Details at http://www.contextures.com
HvZVSn7JkfI
Excel Shortcut Changes Formulas to Values contextures - 421 views - 5 months ago
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
Filter Excel Data to a Different Sheet contextures - 397 views - 8 months ago
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
Add Running Totals to an Excel Pivot Table contextures - 1,994 views - 9 months ago
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
contextures  
Profile
 
Name:
Debra
Channel Views:
2,564
Joined:
April 30, 2008
Last Sign In:
2 days ago
Videos Watched:
356
Subscribers:
93
Excel tips and tutorials, large collection of Excel sample workbooks, keyboard shortcuts, links
About Me: Microsoft Office Consultant, Excel MVP, Author
Country:
Canada
Companies:
Contextures Inc.
Recent Activity  
contextures uploaded a new video (4 days ago)
http://blog.contextures.com/archives/... A nasty Excel bug is eating the credit card numbers. How will they order the crucial replacement parts? E...   more
 
 
contextures uploaded a new video (2 weeks ago)
http://www.contextures.com/xlCondForm... -- Use conditional formatting to highlight rows where the date is Saturday or Sunday.   more
 
 
contextures uploaded a new video (3 weeks ago)
The cell reference changed, even though it was an absolute reference. For information on the INDIRECT function, please visit http://www.contextures...   more
 
 
contextures uploaded a new video (1 month ago)
Convert percentages to letter grades with a VLookup formula in Excel. For written instructions see http://www.contextures.com/xlFunction...   more
 
 
contextures uploaded a new video (1 month ago)
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/tipt...   more
 
Channel Comments
There are no comments for this user.