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 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...
by Hellen Oti-Yeboah | Oct 28, 2013 | Big Data, Data Analysis
The current premise is that the more data an organization can access and analyze, the greater the insights that can be acted upon – so focus on data, data and more data. This approach loses sight of “NO” Data, though, which if detected can often represent even more...
by Hellen Oti-Yeboah | Oct 28, 2013 | Technology and Trends
1. Mobile Device Diversity and Management “Enterprise policies on employee-owned hardware usage need to be thoroughly reviewed and, where necessary, updated and extended….Set policies to define clear expectations around what they can and can’t do. Balance...