Home > 

Site Map

• Contact
• Excel for Business Newsletter
• Excel Dashboards
• Excel Solutions
• Exploring Excel
• Enterprise Excel
• Business Tools
• Excel Catalog
• Excel Help Portal

Contact

• Write About Business and Excel
• Charley Kyd
• Marty Ryerson
• Michael Gonnerman
• Patrick R. O'Beirne
• Sam Savage

Excel for Business Newsletter

• Mar 18, 2008 -- Excel Cycle Plots + Excel Webinars
• Feb 5, 2008 -- Plug-N-Play Dashboards, Excel 2007 Dashboard Book
• Jul 19, 2007 -- Benford's Law + NPVs + Arrays + SUMPRODUCT
• Apr 3, 2007 -- Summarize Excel Data + Excel 2007 + Excel Cartoons
• Dec 20, 2006 -- Excel Makes a GREAT BI!
• Oct 18, 2006 -- Excel's Many Competitors + Excel Downloads
• Sep 20, 2006 -- Sparkcharts + Should You Upgrade to Excel 2007?
• Jul 12, 2006 -- Bullet Graphs + Normal Distributions + Try Excel 2007 in Your Browser
• Jun 13, 2006 -- Excel-Friendly Data + Excel MVPs + Your Excel Questions
• May 23, 2006 -- Get Office 12 Beta + Fight Excel Errors
• Apr 12, 2006 -- Introducing Office 2007 + PDF Handbook for Office
• Mar 22, 2006 -- Improved Reporting + Dot Plot Charts
• Feb 21, 2006 -- Nightmare Reports + Free Dashboards
• Jan 19, 2006 -- Excel MVP + Excel Dashboards + Management Reports
• Dec 12, 2005 -- Strategy + Business + Excel
• Nov 2, 2005 -- Using Excel as a Funnel
• Oct 4, 2005 -- Excel 12: A Radical Departure
• Aug 30, 2005 -- A First Look at Office 12. Dashboards. BI.
• Jun 29, 2005 -- Office 12 and XML
• May 25, 2005 -- First Hints About Excel 12
• May 5, 2005 -- VBA, Array Formulas, Documenting Excel

Excel Dashboards

• Create Cycle Plots in Excel to Chart Seasonal Sales Data
• Learn to Show Business Data That Readers Can Understand
• Compare Metrics by Category Using Excel Dot Plot Charts
• Explore Business Performance Using Small Charts in Excel
• Six Ways Excel Dashboards Can Improve Cash Flows
• Down With Gauges!
• Sample Excel Dashboards
  --Standard Excel Dashboard
  --Standard Excel Dashboard With ExcelUser Colors
  --Standard Excel Dashboard, Business Week Style
  --Standard Excel Dashboard, Wall Street Journal Style
  --Wire Frame Excel Dashboard
  --Excel Dashboard to Compare Several Organizations
  --Excel Dashboard, Forbes Magazine Style
  --Excel Dashboard Postage Stamp Report
  --Standard Excel Dashboard In Black and White
  --Mini Briefing Book Using Excel Dashboards
  --Old Business Week Excel Dashboard Report
  --Excel Dashboard, Competitor Performance
  --Old Business Week Excel Dashboard Report, Modified
  --Excel Dashboard, Competitor Performance, Modified
  --Excel Dashboard: Sales Analytics Report
  --Excel Dashboard: Sales Funnel Report
  
• Introducing Excel Dashboards For Management Reporting
• Free Dashboard Report
• How to Get Started With Excel Dashboard Reporting
• Displays of Business Data Using Excel Dashboards

Excel Solutions

• Use Excel to Fix Your Broken Accounts Receivable Measure
• Should You Raise Prices? Or Should You Lower Them?
• Using Excel to Calculate Frequency Distributions
• Returning Items from a List Using Excel's Data Validation
• Reporting Periodic Data From Excel Databases
• Find Future & Present Values From Scheduled Cash Flows In Excel 2003 and Excel 2007
• Fooling Around With Excel-Generated Cartoons
• Show Key Stats Automatically In Periodic Excel Reports
• Finding errors after a system conversion
• Strategies for an Excel system for invoicing or estimating
• Seven Ways to Avoid Errors In Excel Reports & Analyses
• How to Fight Spreadsheet Hell With Three Excel Functions
• Use MS Query with Text Files For Dynamic Excel Reporting
• Dynamic Range Names
• Map Costs and Sales in Excel With This Breakeven Chart--Excel 97-2003
• Map Costs and Sales in Excel With This Breakeven Chart--Excel 2007
• Excel Can Help You Find the Variances That Matter
• Traffic Lighting With Excel
• How to Fix the IRR
• Manage Periodic Payments With an Excel Cash Calendar
• Map Your Financial Health With an Excel DuPont Chart
• Show Useful Variance Charts In Your Excel Dashboards
• Common-Age Excel Charts Compare Sales Performance
• Sources and Uses of Funds
• Document Excel Worksheets With Pictures That Include Row & Column Headings

Exploring Excel

• ExcelUser Poll: How Do Business Users Like Excel 2007's New Ribbon?
• ExcelUser Poll: The Excel 2007 Market Share?
• Use Excel's SUMPRODUCT to Summarize Worksheet Data--Excel 97-2003
• Use Excel's SUMPRODUCT to Summarize Worksheet Data--Excel 2007
• Summarize Data With Excel Arrays--Excel 97-2003
• Summarize Data With Excel Arrays--Excel 2007
• The New Excel User Interface
• Excel Shortcut Keys Offer Quick Access to Dialogs
• Weekly dashboard reporting with Excel
• Read a text file with VBA, and write the text to Excel
• How to Round Excel Time To Half-Hour Increments
• Use AutoFilter to Delete Rows In Worksheets, Not Macros
• Key Excel MVP Web Sites
• How to Tab From Cell to Cell In an Excel Worksheet Form
• How to Round Up with Excel's INT and ROUNDUP Functions
• Using Absolute and Relative References in Excel Formulas
• Use VBA Functions to Return Excel Document Properties
• Debugging the INDEX function
• Using local range names in Excel reports
• Use a Combo Box with many criteria in an Excel database
• How to Create Normal Curves In Excel, With Shaded Areas
• How to Work With Dates Before 1900 in Excel
• Add Class to Your Reports With Excel Drawing Objects
• Experiment With Excel 2007 Using Only a Web Browser
• How to Create Bullet Graphs to Replace Gauges in Excel
• An Introduction to Excel's Normal Distribution Functions
• Key Microsoft Web Sources Explain Office 2007 Features
• Excel Range-Name Roundup
• Corporate VBA Standards for Excel Users Who Program
• Use Excel's Web Queries to Import Web Data Easily
• Use MS Query to Treat Excel As a Relational Data Source
• Three Ways to Reduce Errors In Your Excel SUM Formulas
• Excel's Dynamic Range Names
• Document Excel Worksheets With Pictures That Include Row & Column Headings
• Summarize Spreadsheet Data With Excel's Array Formulas
• Display Any Colors in Excel

Business Intelligence for Excel

• Excel Makes a Great BI!
• Try Out BI for Excel for Free
• Is Excel Budgeting a Mistake?
• Create an Accordion Report In Excel, Using OLAP Data
• Excel Spreadsheet Functions That Read Values From Cubes
• Consolidating Excel Data From Many Workbooks
• What Do Users Need From Excel-Friendly Data Sources?
• Set Up Common-Age Charts With Excel and OLAP Data
• Map Your Financial Health With an Excel-Friendly OLAP
• What the Heck Is OLAP? When Is It Excel-Friendly?
• The Partnership of OLAP and Excel Brings A Cure for Spreadsheet Hell
• Five Reasons OLAP Belongs On Excel Users' Desktops
• OLAP Products for Excel

Business Tools

• Cash Trap
• Weighing Your Debt Load
• How Fast Is Too Fast?
• Use Benford's Law with Excel to Improve Business Planning--Excel 97-2003
• Use Benford's Law with Excel to Improve Business Planning--Excel 2007
• How to Use Excel Formulas To Calculate Term Loan Info
• How to Use Excel Formulas To Calculate Term Loan Info
• Predict Business Bankruptcy Using Z Scores with Excel
• 13 Ways to Improve Your Monthly Board Reports
• The Flaw of Averages
• Metric Madness?
• Agile Spreadsheet Development
• Weighing Your Debt Load
• How Fast Is Too Fast?
• Bain's Management Tools
• Use Business Tools With Excel To Save Time and Money

Excel Catalog

• Plug-N-Play Excel Dashboard Report Kit
• Dashboard Reporting With Excel
• Map Costs and Sales in Excel With This Breakeven Chart
• Report Many Key Measures Using Bullet Graphs in Excel
• 21 Files From the Dashboard Book

Excel Help Portal

• Excel Add-Ins: p1, p2
• Excel Charts: p1, p2, p3, p4, p5, p6
• Customizing Excel: p1
• Excel Databases: p1, p2, p3, p4
• Dates and Times in Excel: p1, p2, p3
• Excel Downloads: p1, p2
• Using External Data with Excel: p1, p2, p3
• Financial Analysis With Excel: p1, p2, p3, p4, p5, p6, p7, p8, p9
• Formatting Excel: p1, p2, p3, p4, p5, p6, p7
• Using Excel Formulas: p1, p2, p3, p4, p5, p6, p7
• Doing Lookups in Excel: p1
• Excel for Mathematicians: p1
• Miscellaneous Excel: p1
• Excel PivotTables: p1, p2
• Printing With Excel: p1
• Setting Up Excel: p1, p2, p3
• Excel for Statisticians: p1
• Excel System: p1, p2, p3, p4, p5, p6, p7
• Using Text with Excel: p1, p2
• Programming Excel: p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11,
     p12, p13, p14, p15, p16, p17, p18, p19, p20, p21,
• Excel and the Web: p1, p2, p3, p4
• Excel Worksheets: p1, p2, p3, p4

Sample Dashboards

• Dow Jones & Company, Inc.
• McGraw-Hill Companies, Inc.
• Microsoft Corporation
• Starbucks Corporation