19DEC12: Excel formula workshop in Chicago

After teaching an Excel workshop, students requests a workshop on Excel formulas. We’re doing it! I’ll be teaching … EXCEL FORMULA WORKSHOP Wednesday, 19 December 2012 $20 6:30pm to 8:30pm The Holiday Club 4000 N Sheridan Outstanding place to have a...

Top 5 Excel Functions

Here’s the answer to a question about THE Excel Functions To Know. The request was for the top 10 but 10 is too many. After 3 or 4 functions, they get difficult to rank because they fall into areas of infrequent use or exclusive use. Things like INDIRECT, INDEX,...

What is =+ in an Excel formula?

QUESTION Erika saw an Excel formula that started with: =+ What’s the deal?   ANSWER Nothing. People who grew up with Lotus notes got into the habit of starting a formula with ‘+’ and they carried it over to Excel. What excel does with that is simply...