Excel Formulas From a Microsoft MVP!
Chandoo, who writes a blog called Pointy Haired Dilbert for charting and Excel tips, created a tutorial that makes learning Excel (2003 and 2007) formulas fast, easy and fun. This workbook contains 75 of the most frequently used formulas that are explained in plain wording. If you are new to Excel, want to brush up on some rusty formulas or want to learn some new ways to look at data, buy this ebook today. For just $10, you can be using formulas that will save you hours worth of manual work in Excel.
Click here to view more details
I personally use 63 or 84% of these formulas on a regular basis (yes, I counted). It’s amazing to see the results when I show someone how to use the NETWORKDAYS, VLOOKUP. CONCATENATE or TRIM formula.
This post contains an affiliate link.
June 9th, 2009 at 3:27 pm
Hi Tony… Thanks for such a good review
@readers of Support Analytics: If you have some questions or doubts about this product, drop a comment here and I will answer them
June 10th, 2009 at 9:31 am
What’s the use of CONCATENATE?
June 10th, 2009 at 3:52 pm
@Derek: concatenate() or & operator are used to add up 2 or more texts
June 10th, 2009 at 9:36 pm
@Derek – a good example would be:
If you had “John” in column A and “Smith” in column B, you could use the concatenate function or & operator to combine them into one cell in a new column.
=CONCATENATE(A1,B1)
Or you can get fancy and add text to the middle and use the & operator. For example:
=A1&B1 results in – John Smith
=A1&”, “&B1 results in John, Smith
June 11th, 2009 at 3:57 pm
See, I don’t regard the & operator as fancy. I regard it as the complete replacement for CONCATENATE(), which I can only suppose is kept around for back-compatibility.
June 11th, 2009 at 4:09 pm
When I said fancy, I was talking about adding the comma to separate the first and last name. The & operator is simply quick and easy. I never write out “concatenate” anymore, which I think was your point.