Oz du Soleil
  • About
  • Tutorials
  • Blog
  • Contact
Select Page

What is Crossfooting?

by Oz du Soleil | Sep 7, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Development, Tips

Crossfooting is the Word of the Day. I woke up today and read a forum post about spreadsheet errors. Smart spreadsheet  users include crossfooting to check the integrity of their spreadsheets and results. So: what is crossfooting?   Crossfooting: calculating a...

Pivot Tables Part 2

by Oz du Soleil | Sep 6, 2012 | Data Management, Spreadsheet Development, Tips

What Are Pivot Tables Used For? What Are Pivot Tables Good For?   My last post described spreadsheet Pivot Tables and tonight I was talking with my good friend Patrick Richards. He commented that he wasn’t left with a clear sense of what a Pivot Table is....

Powerful Feature in Excel 15: Flash Fill

by Oz du Soleil | Aug 20, 2012 | Data Management, Excel Geekdom, Tips

The Data Marshall returns to tell you about a feature in the forthcoming Excel 15. It’s going to be invaluable in Taming Dataville. There isn’t an official release date for Office 15 but there are previews and lots to be excited about. Check out this video...

Spreadsheet Development: It Was All Fun & Games Until …

by Oz du Soleil | Aug 7, 2012 | Data Management, Excel Geekdom, Spreadsheet Development, Tips

There are plenty of tutorials about working inside spreadsheet cells: creating formulae, finding ways to extract elusive data, etc. However, some of the best Data Management attention is spent outside of the spreadsheet cells: development of the overall file. So...
Read more

Data Generator 2: with VLOOKUP & Pivot Table

by Oz du Soleil | Jul 24, 2012 | Case Studies, Excel Geekdom, Screencast, Tips

 This video demonstrates one use of data generator results as follow-up to an earlier blog entry, Taming Dataville. In the video below, you will see: Use of dummy data While waiting for someone to create a Master List, I moved ahead by using random fish species where...
« Older Entries
Next Entries »
Best Microsoft Excel Bloggers

Recent Posts

  • Learning Excel By Building
  • Beyond BI Tools: The Real Life Impact
  • More Excel Videos in 2016

Blog Categories

  • Being a Good Analyst
  • Case Studies
  • Data Integrity
  • Data Management
  • Data Management for Nonprofits
  • Excel Geekdom
  • Excel Management
  • Guest Blogger
  • How Tos and Q&As
  • News
  • Screencast
  • Spreadsheet Development
  • Spreadsheet Tidiness
  • Tips

DataScopic.net

DataScopic is committed to Excel as a tool in service of Data Literacy: competence in collecting, manipulating, interpreting and auditing data. Oz du Soleil provides clients with more than 15 years of expertise to solve their data challenges.

Search

  • About
  • Tutorials
  • Blog
  • Contact
  • Facebook
  • X
  • RSS
Privacy Policy