All articles with 'help' Tag

Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

Published on Jul 30, 2009 { 25 Comments }
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu
Continue »

New Improved Version of Excel Formula Help

Published on Mar 16, 2009 { 1 Comment }
New Improved Version of Excel Formula Help
Continue »

PHD Excel Formula Helper – Now an E-Book

Published on Feb 2, 2009 { 3 Comments }
PHD Excel Formula Helper – Now an E-Book
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 »

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 »

Custom Views in Excel – Save filter and header settings for quick reference

Published on Dec 17, 2008 { 4 Comments }
Custom Views in Excel – Save filter and header settings for quick reference
Continue »

Formula Debugging in Excel – Tip [spreadcheats]

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

Introducing Excel Formula Helper

Published on Nov 24, 2008 { 7 Comments }
Introducing Excel Formula Helper
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 »

Make your VBA macros work anywhere: Enable Relative References

Published on Nov 18, 2008 { 1 Comment }
Make your VBA macros work anywhere: Enable Relative References
Continue »

Excel Formula for Finding Repeated Words in a Cell

Published on Nov 11, 2008 { 8 Comments }
Excel Formula for Finding Repeated Words in a Cell
Continue »

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Published on Nov 6, 2008 { 2 Comments }
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Continue »