by Oz du Soleil | Apr 17, 2012 | Excel Geekdom, Tips
{=sum(- -(b8:b550 < f8:f550))} One more thing I’ll whoop on ya today: Excel’s spooky little double-negative. S’pose you want to know the number of times something was true, and then do math with it COUNTIF won’t help because...
by Oz du Soleil | Apr 14, 2012 | Excel Geekdom, Tips
Data can be wily and you never know what’s inside a data set until you begin to work with it to scrub it or extract information from it. You might need to do the same procedure from different angles to locate particular oddities. So, forgive yourself for not...
by Oz du Soleil | Apr 14, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Development, Tips
Do you work with password protection in Excel spreadsheets? If so, I have good news and bad news. BAD NEWS: the passwords are easy to break GOOD NEWS: the passwords are easy to break If you’re sanitizing data, repairing and modifying spreadsheets, it means...
by Oz du Soleil | Apr 13, 2012 | Data Management, Excel Geekdom
I’ve watched this Simon Sinek video several times and it always has me reflect on my passion for Data Hygiene, Data Management and spreadsheets. Throughout the video Simon insists “people don’t buy what you do, they buy why you do it.” So, why...
by Oz du Soleil | Feb 22, 2012 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips
A handy feature in Excel: hide formulas that result in 0. You’ve set up a spreadsheet in anticipation of the future. All of the formulas are in place and the vast majority = 0. Of course they do. It’s only February. None of your product lines have sales...
