Excel Macro Loop – Limit Redundancy to Save Time and Energy
Does your code need to execute the same action more than once? Instead of programming it multiple times, try writing it once and repeating it with a loop.
PRYOR+ 7-DAYS OF FREE TRAINING
Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
Beware of Common Grammatical Errors
When writing you must watch for errors in grammar punctuation mechanics and word choice. That’s a lot too think about but their all important topics you can’t let any of them slip through the cracks. Its not enough to rely on your word processor’s spell-checker either. Everyone have to proof his or her work to…
Read More
Those Tiny Mistakes Can Hurt
I was riding an adrenaline high, having just put my first self-published book on sale at a major online retailer. The cover was beautiful, polished, and professional, and I knew that my message would resonate with people and maybe even help someone who had faced the same struggles as me. I had done what I…
Read More
How NOT to Write an Email
How often have you re-read a lengthy email and STILL had no clue what you were supposed to do? Or received a response to your message that clearly indicated the recipient either failed to read or understand what you wanted? A single message mistake can mean the difference between a constructive, helpful response and a…
Read More
Where is the Chart Wizard in Excel?
Microsoft eliminated the Excel Chart Wizard in Excel 2007, and it has not returned in the successive versions. In fact, the company rebuilt the entire chart system, and the team decided it would not be worthwhile to update the wizard and all of its options.
Using VLOOKUP in an Excel Formula
Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer?
Excel Date Formula
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them.
Excel Gantt Chart Template
Manage Your Projects with Our Excel Gantt Chart Template Are you required to manage project timelines when dates for dependencies are shifting? Do you need to know how the latest resource adjustment will affect the project deliverable dates? Then you need a Gantt chart. Some managers can’t function without expensive project management software such as…
Read More
Organize Projects and Count the Time between Dates with the Help of Excel Date Formulas
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them. Fortunately, Excel has all the functions to do the date arithmetic for you.
Don’t Lose Another Caller – Critical Communication Skills for the Phone
Have you ever called a business and your first impression was your last impression of that business? Just the other day I called a computer repair company to schedule an appointment (and hopefully fix) a computer that went crazy. The person answered my call with, “Yeah.” Hmm, I thought to myself, did I misdial?
