by Oz du Soleil | Dec 7, 2012 | News
7DEC12 A recent spreadsheet was giving me hell. It was littered with hidden apostrophes, carriage returns and was a general pain. Manually correcting 1500 rows and 28 columns was going to be ridiculous. The cause was the importing of files that weren’t Excel or...
by Oz du Soleil | Dec 6, 2012 | How Tos and Q&As
# 3 In our Top 5 Excel Functions, the Operators AND & OR Excel AND and OR functions are fairly straightforward. In this post, we see cover details and warnings. And we wrap up with a Thought Exercise rather than examples. So, let’s hit it! If VLOOKUP were a...
by Oz du Soleil | Nov 27, 2012 | How Tos and Q&As
#2 of my Top 5 Excel Functions: VLOOKUP If VLOOKUP was a song, this would be it, I Like it Like That! VLOOKUP can turn a 2-day ordeal into a 5-minute task. Reasons to use VLOOKUP List of 400 addresses each needing to be assigned one of 9 Regions Master list of the 9...
by Oz du Soleil | Nov 24, 2012 | News
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...
by Oz du Soleil | Nov 24, 2012 | How Tos and Q&As
The Excel IF function is like a nice pair of black shoes: they’re fundamental and fly under the radar. When asked about a list of Top Excel Formulas, I immediately thought of the almighty VLOOKUP. But Wait! My #1 is IF and #2 is VLOOKUP. IF is fundamental like...
