
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
Call us: +27 (0)86 167 3923
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
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.
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
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
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
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
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
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
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!
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
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,
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
Receive our monthly Excel tips and news to your inbox!
© Custom IT Solutions cc | Terms | Privacy Policy | Cookie Policy
Course Length: 79 Lessons | 7.5 Hours of Videos
Course Length: 55 Lessons | 5.5 Hours of Videos
Course Length: 56 Lessons | 4 Hours of Videos