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 […]
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 […]
Data dumps from 3rd party systems often give us data with a plethora (lots of) blank rows. Finding and Deleting these Rows can take an age. Not any more though! This cool tip will show you how to use the Go To Special… Blanks feature to detect and delete all these unwanted rows in a […]
Many of the cool features in Excel auto-detect data ranges to function, such as Filters, Flash-Fill and Pivots, to name but a few. Considering this, it’s really important that we store our data in such a way that an Excel Range can be detected without any issues. Simply put, our Data should be stored in […]
The Summit Solutions 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 training […]
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 […]
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 […]
Most times using a keyboard shortcut is quicker than using a mouse. Sometimes though, it’s a nifty combination of the two that does the trick! Let’s look at the quickest way to a move a column in Excel. The standard way of moving a column within a range of data is to right-click on the […]
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 […]
Businesses are obsessed with data – and for good reason. We turn data into meaningful insights to understand how we can successfully implement new strategies for growth, reduce risk, increase productivity, and manage costs. Essentially, we try to use data to predict and plan for the future, and with data being collected around the clock, […]
Microsoft Excel has become a household term – everyone knows about it or has used it before. Most of us use Excel in our day to day lives as professionals, students or even to keep track of our admin like budgets and spending. But how did it all start? How did Excel become one of […]
If you’ve seen The Social Dilemma, you’ll realise how easy it is for computer programmers and data scientists to manipulate programmes to suits their needs and protect their time and mental wellbeing. Whether coding in Python or reporting in Excel, saving time with automation tools is vital to methods of working in today’s fast paced, […]
MS Excel Beginner Course
R750.00 incl. VAT
MS Excel Intermediate Course
R1,350.00 incl. VAT
MS Excel Advanced Course
R1,750.00 incl. VAT
MS Excel Automation Course
R2,150.00 incl. VAT
Excel All-in-One Bundle
Original price was: R6,000.00.R3,250.00Current price is: R3,250.00. incl. VAT
Excel Int-Adv Bundle
Original price was: R3,100.00.R2,150.00Current price is: R2,150.00. incl. VAT
Excel Adv-Auto Bundle
Original price was: R3,900.00.R2,450.00Current price is: R2,450.00. incl. VAT
Excel Beg-Int Bundle
Original price was: R2,100.00.R1,550.00Current price is: R1,550.00. incl. VATReceive our monthly Excel tips and news to your inbox!
© Summit Solutions Training (Pty) LTD | Terms | Privacy Policy | Cookie Policy
Receive our Excel tips and news to your inbox!
"*" indicates required fields
Course Length: 79 Lessons | 7.5 Hours of Videos
Course Length: 55 Lessons | 5.5 Hours of Videos
