News

Microsoft Excel Intermediate Training Course Case Study: Working out Commission Payable to Sales Reps

Sales is an interesting career path which includes everything from real estate agents, account managers to direct sales people who walk from door-to-door or make calls on the phone.

Being a Sales Representative is something that every bookkeeper does if they have their own bookkeeping business. You speak with prospects, find out what they want, see if you can do the work for them and then sign them up and start working. You’re helping to match a business with a customer.

I’m often fascinated at how many Bookkeepers HATE hearing the word “sales” associated with any part of their work and as a result they act like a ROBOT when they speak to potential clients, but I’m digressing and that’s a topic for another blog post!

The benefit of being in sales is that you can earn a commission which is often much larger than your base salary – but keeping track of commissions payable each month can be complicated and we teach you how to use Excel to make it EZY.

In our Microsoft Excel Intermediate Training Course (Module 306) you use a spreadsheet to calculate the commission payable to a team of sales people based on the turnover they generated last month.

It might seem like an easy task but can escalate in complexity very quickly based on changes in commission rate, tiered commissions and base salary payments. When you start adding extra sales people but still want the spreadsheet to be easy to understand you’ll learn how to reduce the number of columns and rows by using Intermediate level Excel formulas.

Sales Managers like to vary the incentives to increase the urgency that their sales people put onto prospects to BUY NOW and using formulas that span multiple worksheets sales managers put all the variables in one sheet and the answers in another.

That’s the real power of formulas in Excel and makes you look like a real Microsoft Excel Pro.

Use Microsoft Excel to Identify the Sales Leaders and Calculate Their Commission

In one of the Intermediate Excel case studies and sample exercise file you’ll learn how to create a tiered commission structure that automatically calculates the commission payable to sales reps as well as identify which level of achievement they were able to attain.

The visual part of this case study uses conditional formatting to show the highest awards in one colour and less results in different colours or gradients.

Conditional Formatting can also be used to identify who succeeded in reaching their budget and who didn’t quite make it and need to try harder.

Microsoft Excel Complete includes all 9 of our Microsoft Excel Short courses and comes at a discounted price. If you are a medium sized company or want to have several of your staff trained in using Excel you’ll find our course prices are even cheaper with a Microsoft Excel Corporate Training Licenses.

Corporate Training pricing is designed to eliminate the Needs Analysis that can take a long time and cost a lot of money and enable all of your staff to be at the same level – which you can choose.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Is Xero really promoting websites for $2,700

Xero has always used its partner network to reach it's users. I remember one claim…

20 hours ago

Just follow the messy trail and you’ll learn Xero and MYOB

The purpose of a well designed course is to provide a series of steps for…

2 days ago

Has it all become too complicated?

I've tried and tested hundreds of software programs over the last 25 years and I've…

7 days ago

Remote Working Internship

Working with our graduates we've discovered that organisations are still looking for staff who can…

2 weeks ago

Should you learn MYOB, Xero or QuickBooks First?

We receive lots of bookkeeping course enquiries from students who are changing careers and want…

2 weeks ago

What’s happening PEPPOL?

Am I speaking gibberish or just crazy? No, I'm speaking the language of eInvoicing! PEPPOL…

4 weeks ago