Spreadsheets
Articles on Spreadsheet Management, Excel Tips, Tutorials and News
How to Set Up a Pivot Table as a Spreadsheet Database
Pivot Tables aren't merely a way to interact with your data. You also can use them as a rich source of data for regular reports and analyses...without using the weak function, GETPIVOTDATA. by Charley Kyd, MBA Microsoft Excel MVP You can use a Pivot Table as a...
Will Business Intelligence ever be Intelligent?
From Forbes.com, this article sparked a lot of interaction on our social media outlets, and we think it is an important one: Business Intelligence (BI) Isn't Very Intelligent, Yet. Yes, big companies talk about BI like they know what is going on. Fact is, very few...
Get With The Program! Accept Excel As the Cracklin’ BI Solution.
Excel is pervasive in businesses, with a probably very low estimate of a couple of hundred million users around the world. Countless companies run some part of their reporting, analytics or planning systems using spreadsheets. For this good reason Excel is regarded...
How to Transform Data into Intelligence that Promotes Growth
Most businesses have the ability to capture data from customer transactions and day-to-day operations, and through research. However, the significant problem after accumulating data is how to turn the data into intelligence that can improve the bottom line. A major...
Map Your Financial Health With an Excel DuPont Dashboard
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display. by Charley Kyd, MBA Microsoft Excel MVP Management reporting is all about communication. Reporting Return On Equity...
Create Variable-Length, Dynamic Reports Linked to Excel Tables
When you change a criteria value in a cell, Excel can use formulas and conditional formatting to expand or contract your report automatically, without macros. Here's how. by Charley Kyd, MBA Microsoft Excel MVP Excel Tables are a powerful feature introduced in Excel...
What’s a ‘Deprecated’ Function in Excel?
Microsoft tells us that many worksheet functions are 'deprecated.' So what does that mean, exactly? Wikipedia tells us that deprecation is a status applied to a computer software feature, characteristic, or practice indicating it should be avoided, typically...
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers at least three ways to set up data so your reports and analyses can use it easily as a reliable data source. by Charley Kyd, MBA Microsoft Excel MVP Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with...
