Microsoft Excel is an incredibly powerful tool, that can be used in all sorts of different ways. However, this also makes it a little intimidating to use. So in this section of the website, we focus on some of Excels key features and try to help you better understand how you might use it in your work.
The SUM function is probably one of the first functions you learn to use in Microsoft Excel. As it basically allows you to quickly add numbers together. So while you probably already know how to use the SUM function. For completeness let’s take…
As Microsoft Office has evolved, new features have been introduced that you may not find to be all that useful. For us one such feature is the mini toolbar. Which is a secondary menu that will appear if you perform a right click with your mouse…
While the CONCATENATE and CONCAT functions are both widely used in order to join data into series. For example joining a first and last name, in order to get someone’s full name. You might be better served using TEXTJOIN as this function is…
As you become more proficient with Microsoft Excel, it’s conceivable that you might find yourself in a situation where you need to concatenate. Which is where we link or chain together data into a series. For example you might need to chain…
The default layout for Microsoft Excel, can be both distracting and a little intimidating. Particularly if you are new to Excel. So it’s lucky that there are a number of settings that we can use, to customise and de-clutter this application…
By default when you start Microsoft Excel, you are presented with a startup screen. While the aim of the startup screen is to help you get started with creating or editing a spreadsheet. It can be distracting and unnecessary. So in this video we…
