by Oz du Soleil | Jun 11, 2012 | Spreadsheet Development
xlcalibre.com is a wonderful site that’s focused on Excel and how it’s used (and can be used) in Human Resources. I especially like the post Learning to Learn Excel. Often, the question comes up in conversation, in online forums, on Facebook, etc. How to...
by Oz du Soleil | Jun 10, 2012 | Excel Geekdom, Screencast, Tips
This was inspired by a friend who asked about automatically populating a range by dragging the formula–based on numbers at the top and along the left side of the range. It’s a bit of a logic puzzle in using relative/absolute cell references, and...
by Oz du Soleil | Jun 8, 2012 | Data Management, Excel Geekdom
If we were to take a poll of people who are both good at Data Management, and are musicians I bet we’d find an unusually high number of bassists and drummers. Why? Any good band must have a solid rhythm section Any good business must have solid Data...
by Oz du Soleil | Jun 6, 2012 | Excel Geekdom, Tips
Excel is already exciting, and then you add macros or VBA (Visual Basic for Applications) into the mix and WOAH! When I started using Excel VBA with regularity, it seemed like the right VBA code would allow me to see into the future. I’ve used VBA for...
by Oz du Soleil | May 21, 2012 | Excel Geekdom, Spreadsheet Development, Tips
Have you worked with a complex, long, and/or detailed formula, Excel keeps returning #N/A or #NAME and it’s making you crazy? Excel does have a Formula Troubleshooter but it’s not so user-friendly. So, how do you troubleshoot formulae without going...
