All articles with 'spreadcheats' Tag

How to use Excel Chart Templates and Save Time

Published on Mar 10, 2009 { 3 Comments }
How to use Excel Chart Templates and Save Time
Continue »

5 Areas where Mouse Kicks Keyboard’s Butt

Published on Mar 2, 2009 { 21 Comments }
5 Areas where Mouse Kicks Keyboard’s Butt
Continue »

Quickly Change Formulas Using Find / Replace

Published on Feb 17, 2009 { 4 Comments }
Quickly Change Formulas Using Find / Replace
Continue »

“Too Many Worksheets” Driving You Nuts? Read This!

Published on Feb 16, 2009 { 15 Comments }
“Too Many Worksheets” Driving You Nuts? Read This!
Continue »

Make a Dynamic Chart using Data Filters

Published on Feb 12, 2009 { 14 Comments }
Make a Dynamic Chart using Data Filters
Continue »

Employee Satisfaction Surveys using MS Excel

Published on Feb 4, 2009 { 16 Comments }
Employee Satisfaction Surveys using MS Excel
Continue »

Colors in Chart Labels [Quick Tip]

Published on Jan 29, 2009 { 18 Comments }
Colors in Chart Labels [Quick Tip]
Continue »

Excel Basics – What are Combination Charts and How to Make One?

Published on Jan 5, 2009 { 12 Comments }
Excel Basics – What are Combination Charts and How to Make One?
Continue »

Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Published on Dec 30, 2008 { 0 Comments }
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]
Continue »

Use Alt+Enter to get multiple lines in a cell [spreadcheats]

Published on Dec 19, 2008 { 5 Comments }
Use Alt+Enter to get multiple lines in a cell [spreadcheats]
Continue »

Formula Debugging in Excel – Tip [spreadcheats]

Published on Dec 15, 2008 { 16 Comments }
Formula Debugging in Excel – Tip [spreadcheats]
Continue »

What is camera tool and how to use it? [spreadcheats]

Published on Dec 2, 2008 { 10 Comments }
What is camera tool and how to use it? [spreadcheats]
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [spreadcheats]
Continue »

vlookup(), match() and offset() – explained in plain english [spreadcheats]

Published on Nov 19, 2008 { 72 Comments }
vlookup(), match() and offset() – explained in plain english [spreadcheats]
Continue »

Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]

Published on Nov 12, 2008 { 22 Comments }
Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]
Continue »
Page 2 of 31[2]3