August 2014

Spreadsheets are ideal for performing ad-hoc analyses and calculations with limited sets of data, but should never be used as a database.

In her article, “Excel is Not a Database”, author and administrative support expert, Jodith Allen, explains that many companies store critical data in Microsoft® Excel® spreadsheets, but simple human errors can skew formulas, equations, and figures resulting in inaccurate budgets, forecasts and other business processes.

Continue reading 6 Reasons It’s Time To Stop Using Excel As A Database

Read more

The popularity of Microsoft® Excel® within Human Resource (HR) departments is undisputed: 90% of HR professionals use Excel to accomplish their daily tasks, according to a 2012 WorldatWork/Deloitte consulting survey.

The application’s flexibility, user-friendliness and powerful modeling and analysis capabilities make it ideal for most HR processes.

For example, models, formulas and spreadsheets can be adjusted on the fly in Excel to fit the specific and evolving needs of any company.

Additionally, Excel’s powerful modeling and analysis capabilities are so easy to use that professionals with widely ranging languages, skill sets and accessibility needs have become deeply familiar with the application.

As a result, external consultants are not required to maintain the hundreds, if not thousands, of spreadsheets and workbooks many companies have on hand.

Continue reading Is Excel Right for Managing HR Department Data?

Read more