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...
by Hellen Oti-Yeboah | Aug 12, 2013 | BI System, Big Data, Spreadsheets
In an era where having access to real-time data and analyzing data effectively can push you a step ahead of your competition, it is essential to make the big data process as simple as possible. Data gathered from transactions, to customer service functionally, price,...
