#### PRYOR+ 7-DAYS OF FREE TRAINING

Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

### Basic Formula Series: The Excel® Sum Formula

Excel® formulas have their own logic and syntax, much like math problems. Once you understand the syntax, you can save a great deal of time by building basic and complex formulas to do the majority of your work for you. Where in math problems you combine numbers with variables, in Excel formulas and functions you…

### Using the Excel PMT Function to Determine Loan Interest

We start out with a basic premise that we borrow \$10,000.00 (D1). Our interest is 3.0% (D2) and the monthly payments are forty-eight months (D3).

### Use VLOOKUP to Find Values from an Excel® Table

VLOOKUP. You’ve heard about it – but what does it do? Vlookup searches a list for a value in the left most column and retrieves the corresponding value from other columns in that row. As an Excel user, what does that mean for you?

### You Owe It to Yourself to Take that “Leap of Faith”

Remember when your career depended on a leader to recognize your potential? They spent time with you to encourage your skills and talent. You are now in a better place because of the potential they saw in you. It’s time to pay it forward!

### Why Aren’t You Delegating?

Effective delegation is one of your most effective efficiency tools—don’t let hesitation stand in your way of using it! “Don’t tell people how to do things, tell them what to do and let them surprise you with their results.”—General George Patton One of the most important skills a smart leader can foster is the ability…

### Eliminate Your Frustration with Excel Time Formulas!

Working with time in Excel can be a problem.  Have you ever calculated how long a person was at work, and then wanted to multiply that time by an hourly wage?  It isn’t difficult to fail miserably! But, if you know the trick, Excel time formulas are easy.

### Tips for Taking on VBA & Excel Macros, Part 2

Last week, the feature was for the advanced Excel users who are not programmers and new to VBA.  This post continues that theme.  The Immediate Window Is Your Friend The Immediate Window is where you can test code against current data and see the results. Use this to make sure your macro really does what…

### Tips for Taking on VBA & Excel Macros

For the advanced Excel users who are not programmers and new to VBA It’s inevitable. If you are an Excel power user, you will reach a point where formulas and the built-in Macro Recorder just aren’t enough. When that happens, VBA (Visual Basic for Applications) macros may be just the thing you need.

### Determining Customer Needs

A salesperson cannot provide a valued solution without first determining the customer’s needs. You can generate happiness and loyalty by matching customers with the solution that works best for them. Solutions should be selected to ease pain, meet short- and long-term goals and address gaps.