BlogIyo.com

Using Data Validation to input data into Excel cells can improve your productivity substantially. Surprisingly few people use the data validation feature in Excel!

Data validation is the simple process of inputting data into Excel cells using defined criteria. For example, let’s say, you need to enter the names of the employees in an Excel worksheet regularly. Why think about the spellings or try to remember all the names? You create a list and then arrange the cells in such a way that you can select the names from a drop down list. Similarly, let’s assume you need to enter the prices of items that you sell or the salary of the employees. Create a list!

Share This

You know that task sitting over there, on the corner of your desk? Yeah, the one you’ve been avoiding… Or should I say, the one that’s been pre-occupying your mind, distracting you from getting anything else done effectively… The one you’re not getting solved but you’re sure having a lot of mental chatter about.

Back in the days when I was in the Big 8 consulting world (or was it Big 6, 5, 4…) I had to write reports for clients. For hours at a time I was combing through the results of our team’s analytical work and turning it into narrative explanations to support the recommendations we were making.

Share This

Do you get depressed when you meet an obstacle, and toss in the towel? Are your goals unrealistic, making them impossible to reach? Or do you start projects, but don’t finish them? These weaknesses oftentimes derail your goals.

Dr. Cloud, a noted Christian psychologist, explains on his CD, “Quarantine Your Weaknesses”: “We are meant to be successful in life. In order to do that, our personal weaknesses need to be isolated from our strengths as we head towards our goals.”

Share This

The 80/20 Principle and Time Revolution

Most of what we do is of low value.

Some small fragments of our time are much more valuable than all the rest.

If we can do anything about this, we should do something radical.

If we make good use of only 20 percent of our time, there is no shortage of it!

The point is not to manage your time better!

You need to transform how you spend your time and you probably need to change the way you think about time itself. Time management is about the selling of “time managers.” Time management aims to fit a quart into a pint jar, it is about speeding up.

Share This

What is the difference between traditional training and competency based training? Competency based training and the traditional approach to training differ in four distinct areas:

1. What the participant learns

2. How participants learn

3. When participants proceed from task to task

4. whether or not the participants learn each task

Perhaps the most fundamental difference; however, is that competency based training is a very systematic approach to training while the more traditional approach is not. What the participants need to know is based upon precisely stated work outcomes that have been verified as being essential for adequate performance of the job for which the participant is being trained.

Share This