by Hellen Oti-Yeboah | Nov 12, 2013 | BI Strategy, Spreadsheets
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...
by Hellen Oti-Yeboah | Nov 6, 2013 | Spreadsheets
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...
by Hellen Oti-Yeboah | Nov 6, 2013 | Business Reporting, Spreadsheets
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...
by Hellen Oti-Yeboah | Nov 5, 2013 | Spreadsheets
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,...
by Hellen Oti-Yeboah | Nov 4, 2013 | Spreadsheets
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...
by Hellen Oti-Yeboah | Nov 2, 2013 | Spreadsheets
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way. by Charley Kyd, MBA Microsoft Excel MVP Several years ago, I created my Complete Excel Shortcuts Workbook. It contains more that 250 keyboard shortcuts...
