All articles with 'help' Tag

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

Published on Jul 30, 2009 in VBA Macros
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

I am stuck with an excel problem and I need your help. While trying to insert an image in to my excel 2007 workbook using VBA I hit on this weird error and not able to use the ActiveSheet.Pictures.Insert method. Do you know why?

Continue »

New Improved Version of Excel Formula Help

Published on Mar 16, 2009 in Learn Excel

Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Find out more…

Continue »

PHD Excel Formula Helper – Now an E-Book

Published on Feb 2, 2009 in blogging, Learn Excel
PHD Excel Formula Helper – Now an E-Book

Remember the PHD Excel Formula Helper Tool? Good, now it is available as an e-book, so that you can take a print out of all the formulas or save it on your disk and learn formulas at leisure.

For 5 $ you can buy this e-book and read it at your leisure.

Continue »

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

Published on Jan 5, 2009 in Charts and Graphs, Learn Excel
Excel Basics – What are Combination Charts and How to Make One?

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.

Continue »

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

Published on Dec 19, 2008 in Learn Excel
Use Alt+Enter to get multiple lines in a cell [spreadcheats]

A very quick spreadcheat for Friday. If you need to type content in a cell and you want to see it multiple lines then use alt + enter to break the content in several lines. See to the right for an example.

Bonus tip: If you are using formulas to create content in a cell by combining various text values and you want to introduce line breaks at certain points … For eg. you are creating an address field by combining house number, street name, city and zip code and you want to introduce line breaks after house number and street name then you can use CHAR(10).

Continue »

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

Published on Dec 17, 2008 in Learn Excel
Custom Views in Excel – Save filter and header settings for quick reference

PHD reader and commenter Vishy contributed this post through e-mail. Thank you so much Vishy for this very useful tip. The Problem: You have created a specific view of your data in Excel (say by filtering, zooming out, changing column width, hiding specific rows, customizing window settings, print settings etc.). This is your reference point […]

Continue »

Formula Debugging in Excel – Tip [spreadcheats]

Published on Dec 15, 2008 in Learn Excel
Formula Debugging in Excel – Tip [spreadcheats]

Can you imagine building a complex worksheet without formulas? I can’t. While no one can dispute the usability of formulas, we all know how painful it is when an excel formula returns a mysterious error and we don’t know what is causing the error.

Continue »

Introducing Excel Formula Helper

Published on Nov 24, 2008 in blogging, Learn Excel
Introducing Excel Formula Helper

One of the most common comments we get here is “how does xxx formula works?” Even though there is vast documentation on excel formulas including the built-in help in MS Office, often it is difficult for us to learn a formula quickly and use it in a snap. So to help new users of excel […]

Continue »

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

Published on Nov 19, 2008 in Featured, Learn Excel
vlookup(), match() and offset() – explained in plain english [spreadcheats]

VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, OFFSET and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]

Continue »

Make your VBA macros work anywhere: Enable Relative References

Published on Nov 18, 2008 in Learn Excel
Make your VBA macros work anywhere: Enable Relative References

Do you know that while recording macros in excel you can use the relative reference based recording so that you can use your macro anywhere and the references would be adjusted automatically? Yes! I have learned this yesterday and I thought it is pretty cool. Here is how you can make your macro VBA code […]

Continue »

Excel Formula for Finding Repeated Words in a Cell

Published on Nov 11, 2008 in Learn Excel
Excel Formula for Finding Repeated Words in a Cell

If you ever need to know whether a particular word is repeated in a cell (for eg: a file extension or telephone number or name of the customer) here is how you can find it. =if(lower(cell-with-text)<>SUBSTITUTE(lower(cell-with-text),lower(word-to-check),””,2),”Yes”,”No”) We are using substitute() to replace the second occurance of a particular word and then compare this with original […]

Continue »

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

Published on Nov 6, 2008 in Analytics, Learn Excel
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least. So […]

Continue »