Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.
[Quick Guide] Master The COUNTIF Function In Excel!
You often need to work out your data statistically by checking on particular portions of your data set that meet specific criteria. The COUNTIF function is designed to help you with that. Want to learn how to use the COUNTIF…
How To Make A Stacked Bar Or Column Chart (5 Minutes Or Less!)
Charts and graphs are efficient ways of data presentation that help users visualize data. They help a user to decode and readily understand data, big or small. Visualizing data in the form of a picture is always easier than skimming…
Introduction to VBA: Step-By-Step Guide
VBA stands for Visual Basic for Applications. It is an object-orientated, event driven programming language. The VBA language can sound intimidating, but this step-by-step guide will walk you through each step smoothly. This article is an Excel VBA Tutorial appropriate…
Analysing Data In Excel (3 Quick Methods)
Data Analysis is the process of cleaning, collating, examining, and modelling data to deliver information and key insights. These insights can be used to assist with decision-making. Data Analysts look at providing answers, to specific business-related questions, by using data.…
How to Use the Transpose Function in Excel
There may be times when you’ll need to switch the layout of your data set around. In situations like these you can use the Excel transpose function! You can learn more about basic and advanced functions in our Microsoft Excel…
Transpose Data In Excel With Paste Special (1 Minute!)
Excel provides a few ways to change the layout of your data set. For example, you can transpose data with Paste Special in Excel. If you would like to learn more about how to use Paste Special, visit our…
Excel Guide: Remove Blank Rows Or Cells
Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve removing blank rows or blank cells. In this post, we are going to show you how to remove blank rows…
Applying Conditional Formatting In Excel
Conditional Formatting allows you to format a cell or group of cells based on a certain condition or conditions being met. Excel provides a wide range of conditional formatting options, and they are simple to implement in your worksheets. If…
Using Concatenate in Excel: A Complete Guide
Even expert excel users can sometime face issues with structuring data using the copy and paste function in excel. This is especially useful when you have tons of disaggregated data. To help with that, we’ve got the Excel concatenate function…
Creating A Simple Macro In Excel (Step-By-Step)
Creating a simple macro in Excel is not a daunting task. Now it may seem contradictory, but you do not need to learn Visual Basic for Applications (VBA) to record simple macros in Excel. VBA does however, come in handy…
Microsoft Excel: How To Email An Excel File Without Leaving Excel
If you frequently email your colleagues Excel files (and how doesn’t) this is a quick tip to speed things up by doing that directly from Excel. You don’t need to hop across to Outlook. If you would like to learn…
(Ultimate Guide) Create Random Numbers In Excel!
Seeking to extract a sample out of a diversified population? Or working on some stuff and looking for ways to generate precisely random numbers? In either case, if you want an unbiased set of random numbers, the Excel random number…