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 | Oct 30, 2013 | Data Analysis
Metaphorically, belief and disbelief in business analytics as a competitive edge – and not just a passing fad – meet at a door. On one side is passion, and on the other, fear. Passion always lives with fear. Those with passion for a methodology, like...
by Hellen Oti-Yeboah | Oct 29, 2013 | BI Strategy, BI System
A few years ago I had the great opportunity to work with a Canadian owned, privately held corporation which had hit a home run with the design and manufacture of an unique product which had taken its industry by storm. The company had grown quickly and substantially...