Join 3,522 readers in helping fund MetaFilter (Hide)

10 posts tagged with excel and business. (View popular tags)
Displaying 1 through 10 of 10. Subscribe:

Control sheet excel inputs from sql

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
posted by trashcan on Aug 3, 2013 - 6 answers

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]
posted by reenum on Sep 14, 2012 - 6 answers

Bringing business cards into 2012

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]
posted by jonathanbell on Jul 23, 2012 - 5 answers

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]
posted by gibbsjd77 on Sep 2, 2011 - 8 answers

Excel for Business?

Quickbooks vs. Excel? My business partner needs some convincing. [more inside]
posted by pakoothefakoo on Apr 6, 2010 - 17 answers

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]
posted by shalam on May 17, 2009 - 6 answers

Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]
posted by SirStan on Mar 25, 2009 - 3 answers

Escaping the grind

My friend works in database applications each day to create in house reports. He's bored and wants to go it alone. [more inside]
posted by simplesharps on Sep 3, 2008 - 0 answers

Timescale display in Excel

Excel/Graphing - Time vs. usage (y/n) graph [more inside]
posted by SirStan on Aug 25, 2008 - 6 answers

Filter by month, not year in Excel?

How do I sort a column of birthdates in Excel to by month and NOT year? [more inside]
posted by ggypsy on Feb 4, 2006 - 9 answers

Page: 1