Shopping Cart
3-MS-Excel-Tips

Our Top 3 Excel Tips from 2021

Someone once said “you can’t teach an old dog new tricks”, but we tend to disagree. Whether you’re an Excel beginner or someone who has been using the program daily for the past decade, we believe there’s always something you can learn — a tip or three that you didn’t know can make all the […]

The #1 productivity killer in a business

It all comes down to the bottom line. That looming figure which can make or break your business, or your job… There are many factors that can cause a negative impact. Employee productivity is often a critical one and there are many things to consider when looking at the causes of poor productivity.  It might […]

VLookup – What It Is and How You Can Use It to Free Up More of Your Time This Week

Microsoft Excel allows you to organise large sets of data in a way that is simple and streamlined. You can organise just about anything from inventories and stock counts to customer details or an employee’s progress in learning and development. But a clean, pretty spreadsheet means nothing if you can’t go back and look up […]

4 Simple Excel Hacks That Will Free Up More of Your Time This Week

We’ve all been a beginner at something, whether it be data management, sales, gardening or learning to play the drums. Just like any skill, Excel takes practice and the more you use it the more accustomed you become with the programme, and the more stumbling blocks you will inevitably face.  If you are reading this […]

How‌ ‌training‌ ‌your‌ ‌staff‌ ‌in‌ ‌Excel‌ ‌can‌ ‌benefit‌ ‌your‌ ‌company‌ ‌

It is argued that humans require three things to be motivated: stimulus, structure and recognition, and each one of these motivational hungers drives us to perform in the workplace. No matter the motivation style of each of your employees, a dedicated skills development programme will help boost productivity and job satisfaction.  Microsoft Excel is an ideal business […]

10 popular business uses for Microsoft Excel

To the average person, Microsoft Excel is a number-crunching program, used to store and track information, like household expenses. But it is extremely popular in business, as it’s highly visual and with the right training, relatively easy to use. And, while many organisations think that Excel is only good for leaving you cross-eyed trying to […]

The Role of Microsoft Excel in Digital Transformation

Developed in 1985 with the sole purpose of helping companies compile financial data and yearly credit and debt sheets, Microsoft Excel remains one of the most widely used spreadsheet programmes around the world. People and businesses invariably turn to Excel to work with data, whether to create a simple shopping list, or to crunch a […]

Excel: The Multi-tool of the digital world?

I read an article once that stated emphatically that “The World runs on Excel”. This may seem like Microsoft propaganda but the more I discover how extensively Excel is used in business, the more I have come to realise that this statement is not too far from the truth, Microsoft Excel is the multi-tool of […]

Sustainable Excel Solutions In Business

Sustainable Excel solutions for your business

At Summit Solutions, our mission is to empower businesses to implement successful sustainable Excel solutions internally, rather than creating an on-going dependency on us. Over the past 20 years we’ve fine-tuned our corporate consulting and training offering to achieve exactly that. In some cases, when our Clients know exactly what they want, we skip the […]

Duplicate A Worksheet In Excel

Quickest way to Duplicate a Worksheet

There is a basic rule of thumb in the Windows environment. Dragging something will move it; dragging while holding down the control key will create a copy. Unbeknown to many, this simple principle works across most applications, including Excel and is easy to use when trying to duplicate a worksheet. If I use my mouse […]

Excel Courses To Save You Time

A little bit of Excel can save you a whole lot of time (and money)

One of the key components of any training program is to get people to apply what they learned in their every-day. Irrespective of how brilliant the training might be, if the transfer and application of skills are not evident once training has taken place, then there is no real value in what’s been learned. To […]

The Future of Excel in the Workplace

We’re all familiar with the term Artificial Intelligence (AI), but have you heard of Business Intelligence (BI)? Business intelligence comprises the strategies and technologies used by enterprises for the data analysis of business information, providing a historical, current and predictive view of business operations. Essentially, it is a set of tools that help people to […]

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks

This draw is closed. Keep checking back, for the next draw.