Good News: Training Announced
Exciting news! Just launched the announcement of 2 Excel Training sessions. They aren't available to the public but this could be the opening of such a possibility.
Taming Dataville: Data Generators & Bogus Data
Taking on a new project is like showing up in something reminiscent of Cormac McCarthy’s “Blood Meridian.” In Data Management one useful tool is a Data Generator to help bring safety and order to Dataville. Read the story and learn how it’s done.
The Seven Deadly Sins of Data Entry (or how NOT to use Excel)
If you share spreadsheets in a team, the data will only be as strong as the weakest link in the team.
So this is a list of the seven things that everyone who touches that spreadsheet should know:
Excel Form, Data Collection & Birthday Alerts
Recently, I posted details about the challenges the client was facing, and how we arrived at a solution. Below is a screencast demo of the final product showing the Excel form, the data collection and Birthday tickler. See the blog: Excel User Form & Birthday...
Screencast #2: Excel User Form & Birthday Notification
This project required use of an Excel User Form in order for all of the requirements to be met. We used tabels, sheet protection, dropdown boxes, and other controls. The User Form allowed us to save data while keeping the data clean and safe.
Learning to Learn (Excel or anything else)
xlcalibre.com is a wonderful site that's focused on Excel and how it's used (and can be used) in Human Resources. I especially like the post Learning to Learn Excel. Often, the question comes up in conversation, in online forums, on Facebook, etc. How to you learn...
Screencast Debut: Relative & Absolute Cell References
This short screencast shows use of Excel relative cell references and absolute cell references.
Laissez Les Bon Temps Rouler!
If we were to take a poll of people who are both good at Data Management, and are musicians I bet we'd find an unusually high number of bassists and drummers. Why? Any good band must have a solid rhythm section Any good business must have solid Data Management ...
6 Reasons Not To Use Excel VBA (Macros)
Excel is already exciting, and then you add macros or VBA (Visual Basic for Applications) into the mix and WOAH! When I started using Excel VBA with regularity, it seemed like the right VBA code would allow me to see into the future. I've used VBA for Web-scraping...
Using a Text Editor to Troubleshoot Formulae
Have you worked with a complex, long, and/or detailed formula, Excel keeps returning #N/A or #NAME and it's making you crazy? Excel does have a Formula Troubleshooter but it's not so user-friendly. So, how do you troubleshoot formulae without going cross-eyed? I...
Insurance Benefit Calculator
Client Challenge: A client was struggling with a recurring nine-variable calculation that helped them determine the services they could provide and for how long. Calculation Variables Fixed allotment amount Deductible Hourly rate of Therapy 1 Hourly rate of Therapy 2...
RFP Assessment Tool
This client was charged with evaluating Requests-for-Proposals (RFPs) as his company prepared to make a $3.5M/year decision. Over his 14 years in his industry, he knew which questions to ask and how to analyze the responses. The challenge: Presenting text answers and...