I am excited by the developments of BI capabilities in excel this year and I want to use the power explorer, view, mapping tools with my sql database. I have two questions really... 1. Can I extract individual calculations and data from the sql/data model rather than always through a pivot 2. If yes, or no, what would be the best way to build a control excel spreadsheet which monitors performance across key criteria (leads per day, orders per day, cancellations, etc) across regions so that I can see where the business is not operating as expected and act accordingly. Thanks Tc
What are the dates for the 9th and 20th business day for the rest of this year and all of next year?
I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]
Quickbooks vs. Excel? My business partner needs some convincing. [more inside]
Looking ideas on what systems can be used for efficient internal business reporting in a small / medium business
What efficient systems can one use to report different internal working data generated in a small / medium sized business - excel is too clumsy and a customized database based application feels like an overkill? [more inside]
Excel - Pivoting With Dates [more inside]
My friend works in database applications each day to create in house reports. He's bored and wants to go it alone. [more inside]
Excel/Graphing - Time vs. usage (y/n) graph [more inside]
How do I sort a column of birthdates in Excel to by month and NOT year? [more inside]