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

Is Excel For The Common Man? YES!

by Oz du Soleil | Jan 4, 2015 | Spreadsheet Development, Spreadsheet Tidiness

My friend Mike asked, “is Excel for the common man?” The answer is yes, but I had to find a good example for someone who’s recently retired and has no workplace need for Excel. But, wherever there’s data, there’s opportunity to use Excel....

Excel, Christmas, Krampus & Kids

by Oz du Soleil | Sep 24, 2014 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness

Mynda Treacy’s recent blogpost at MyOnlineTrainingHub is a hot one! Excel Custom Validation to Limit Entries poses a fun and excellent solution that Santa probably deals with every year: How does Santa set up Excel to allow a kid to request no more than 3...

App Development, ExcelWebApp, Break-Even Calculator

by Oz du Soleil | Dec 2, 2013 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness

October 2012, I posted a mild complaint about the ability to build a calculator in Excel and then publish online via ExcelWebApp. The Excel piece was easy. The WebApp piece was disappointing but was infinitely better than Google’s version. Yesterday a friend...

Excel 2013: Insert Timeline for Grouping Dates

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...

Excel Dashboard: Good, Bad & Ugly

by Oz du Soleil | Jan 28, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips

The image below is an Excel Dashboard section generated from 847 rows and 11 columns of data related to classroom and book sales. In the range D1:N5 we summarize Monthly Sales Totals by Sales Rep. So much easier to look at this instead of scrolling around in the...

Excel Dashboards for Simpler Data Entry & Analysis

by Oz du Soleil | Jan 25, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness

In preparation for teaching a workshop on Excel Dashboards & Reports, I’m thinking about what needs to be covered. Several months ago, Mynda Treacy of My Online Training Hub provided an excellent guest post on Excel reporting. (Going forward, I use...
« Older 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