Excelling at MS Excel – CBM Training
Business Courses

Business Skills Courses

CBM Training provides a range of courses designed to help delegates hone their business skills to improve productivity in the workplace. Our Business Skills Courses are delivered by a faculty of highly qualified consultants who are not merely lecturers but rather specialists consulting in their particular field. They have greater insight into the market and a fuller understanding of delegate needs and deliver Business Courses which are practical in nature and extremely relevant to the current market.
Excelling in MS Excel

Excelling at MS Excel

Become more productive and self-reliant by mastering the world’s most popular productivity tool! A recent study identified that almost 750 million people worldwide use MS Excel but most are just scratching at the surface of what Excel can do for them in business.

Many people think of MS Excel as a sophisticated “number crunching” program to be used mainly by financial departments to show figures and by others to simply keep records. In truth, MS Excel is a powerful business tool that should be used by every person in an organisation to store, analyse and present data in order to make better business and managerial decisions.

This 3-day “Excelling in MS Excel” course will grow your knowledge of the programme exponentially, introducing you to new ways of using the programme and teaching you the skills needed to organise, calculate, evaluate and find data quickly and efficiently. You will cover correct ways to set up and link spreadsheets and discover how to use “built” in specialist capabilities such as Functions, Macros, PivotTables and Data Validation tools that we all know exist, but don’t really know how to effectively use.

We guarantee that if you attend this programme, you will go back and redesign your spreadsheets, making them more efficient and effective as a business tool to support your role in the organisation, allowing you to do more in less time, with Excel, than you ever have in the past.

Our 3 day “Excelling in MS Excel” training course will help you to unlock the full potential of one of the most powerful business tools at your disposal – helping you to stand out from your colleagues, improving the quality of your analysis and decisions and assisting in your own professional development.

Your comprehensive programme includes:

– Recapping some of the important MS Excel Skills needed to capture and prepare your data correctly for more advanced analysis
– Learning to design high-quality spreadsheets with data laid out and listed intelligently and usefully
– Using Excel to automate What-If Analysis and Forecast Sheets to “predict the future” to assist in making informed business decisions
– Discovering some key MS Excel functions you did not know about that will enhance your ability to perform data manipulation and automate your day-to-day tasks
– Working with advanced Excel MATCH and INDEX functions to better analyse your data and extract the information you are looking for
– Understanding the fuss about PivotTables – Using these to rapidly summarise large amounts of data into easy-to-read and export reports you can use to inform your managers and colleagues
– Incorporating “SparkLines” into your PivotTables to showcase data trends such as Sales fluctuations, increased Marketing ROI or decreasing suppliers costs
– Uncovering some amazingly powerful shortcuts that can help you navigate around complex spreadsheets, many of which can be used across the entire MS Office suite of programmes

Do you have 8 or more delegates and want to run this course Onsite?

Click here to request a quote and get more information about our onsite training.


REGISTER

Dates

13-14 August 2019 (CPT), 18-19 September 2019 (JHB)

Duration

2 Days

City

Cape Town, Johannesburg

Venue

Corporate Conference Centre (Dowerglen), Belmont Square Conference Centre (Cape Town)

Price R4,250.00 excl. 15% VAT

R4,250.00 excl. 15% VAT

PLEASE SELECT OPTIONS TO CONTINUE

Clear

Onsite Enquiry Form:

Complete the form below and our onsite team will be in touch with you shortly.

Please prove you are human by selecting the Star.

PDI Scholarship Application Form:

 


Personal Details:

Previously Disadvantaged Individual (PDI) Group: Black: AfricanBlack: ColouredBlack: IndianOther


Company Details:

Please prove you are human by selecting the Truck.