by Oz du Soleil | Jun 21, 2013 | Data Management, Excel Geekdom, Tips
Let’s add this to an earlier post about the 6 Quiet Habits for Working with Excel & Data. In that post I listed several best practices that won’t ever end up in a “Make Excel Your Friend” manual. Yet, they are just as helpful as a nested IF...
by Oz du Soleil | Jun 7, 2013 | Data Integrity, Data Management, Excel Geekdom
I’m getting ready to teach a 2-session workshop on parsing data in Excel. As with other courses, before I teach them for the first time, I have to clarify the mindset to decide who would get the most from the course. Scrubbing data, reorganizing columns, peeling...
by Oz du Soleil | May 30, 2013 | Excel Geekdom
Thanks to Susan Murphy of SuzeMuse for the encouragement to share this blogpost with you. Her blogpost What’s Holding You Back From Telling Your Story has reminded me to just be a human being and write. Sometimes, I read so much about “how to blog”...
by Oz du Soleil | May 13, 2013 | Excel Geekdom
This is so exciting, I almost put a cuss word in the subject line! This deserves a cigar so, please join me. For the past few months I’ve explored possibilities with Excel and the internet. I even took a PHP/MySQL course and what I discovered is that being in...
by Oz du Soleil | May 1, 2013 | Data Management, Excel Geekdom
2 years ago I was converting my life over to Apple. Their users boast of the Mac processing speed and resistance to malware. I’d spent enough time and money cleaning up my PCs in spite of the firewalls, ad-blockers, malware detectors, and other counter-measures....
by Oz du Soleil | Feb 6, 2013 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness
Quick & dirty update! AWW WOW! Excel 2013 allows the addition of a timeline into Pivot Charts! (not included with Excel for Mac) Let’s say you have a lot of dates and want to see graphic summaries grouped by month or year. Before 2013, that called for a...
