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 […]
Having Duplicates in your Data can be a real problem, so addressing them is important. Finding them, especially in a big data set, can often be an arduous task though. A simple combination of Conditional Formatting with Filters is a great way to highlight and track down those Duplicates. The basic steps are as follows: […]
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 […]
Microsoft Excel is used by many professionals in day-to-day business for data management and reporting. Today we have a mass of data that is often difficult to analyze or understand which is why we use Excel’s reporting tools to create simple visual representations of large data sets. Enter Pivot Tables, one of Microsoft Excel’s most […]
Many of the shortcuts that we teach in Excel can be applied across other applications. 3 of them are almost universal and can be used for just about anything. Ctrl + N – to create a New Workbook, Document, Email, Presentation etc Ctrl + O – to Open an existing Workbook, Document, Email, Presentation etc […]
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 […]
When manually entering data into Excel we often have the need to copy the value directly from the cell above. Thankfully, there is a shortcut to do just that. Two in fact! ctrl + “ just the value ctrl + D copies the value and the formatting Both have their advantages, depending on your requirements. […]
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 […]
Normal copy and paste includes hidden rows and columns, so how do you Copy and Paste just the cells that are visible? Select Visible Cells only before copying. The quick guide… Select the range you want to copy (ctrl + A) Call up Go To (Ctrl + G) Click on the Special… button bottom left […]
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 […]
Where would we be without Copy and Paste? Probably way behind schedule, or should I say, further behind schedule than we are currently! ? In Excel, Copy and Paste copies everything by default… except column widths! This can be a little frustrating especially if that is one of the key things you require to copy. […]
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 […]
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
