Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
Excel includes powerful sort functionality in the Sort & Filter group on the Data tab. But what if your data changes frequently, or if you’re simply tired of clicking through the Ribbon each time you generate a similar table? The answer might be to create a formula that does your sorting work for you. As…
Read More
In a previous post (Sales Management Software Considerations), I discussed the basics of sales management software. As noted, there are many “must-have” benefits to such a system, not the least of which is something called pipeline management, or sales forecasting.
When I moved into sales management 20 years ago, the #1 rule preached in management class was: “Inspect what you expect.” Which, back then, was easier said than done. It required detailed review of every salesperson’s paper call reports, quotes and sales reports. From there I would “back into” the numbers to review activity and…
Read More
In my two other posts (Sales Management Software and Sales Pipeline management), I referenced processes — reinforcing the fact that sales is a process and not a magic art only imparted to the gifted few. This post details that process further.
About Excel’s INDEX Function Sometimes useful functions like VLOOKUP just don’t apply when the information you need is more about where in your table the information is than what the information is. The INDEX function returns the value of an element that is specified by position (row and column) in an array or table. You…
Read More
If you work in sales, marketing or any department that uses/receives reports from Business Intelligence software, you’re probably familiar with the Sales Funnel Chart. If you are looking to create a funnel chart of your own, you might find that it’s a bit of a trick. Excel gives you the tools to create the iconic…
Read More
Once you have gone to the effort of collecting, organizing and processing your data, you probably want to show it off! Tables do a nice job of presenting raw information, but a chart can bring your data to life. Charts create visual impact that conveys not only the data itself, but its relationships and meaning.
Excel’s PivotTable feature allows you to organize information in such a way that you can answer many questions about your data that would otherwise require lots of formulas, functions and “IF” statements. To get even more answers out of your data, PivotTables offer Calculated Fields and Calculated Items.
If you want to know how to improve your skill at shooting hoops or playing the guitar, you practice. If you want to learn more about how to use Microsoft® Excel®, you take a class and complete examples that help you with your tasks.
Have you run across someone recently who is not familiar with the term “Emotional Intelligence,” sometimes referred to as EQ? It’s a term heard more frequently in business environments. Yet, do you know your EQ score?
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 8,500+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
