Microsoft Excel

How would your data look if it had clear written descriptions instead of general titles? It would be easier to present, and for others to work with. Named ranges are one of the most unutilised features of Excel. A named…

Learning to present the data in your spreadsheets clearly is extremely important. Unclear and poorly laid out spreadsheets are much more likely to contain errors. Excel contains lots of data validation tools but it is better to get your calculations…

For those of you who know how to create a Pivot Table, have you ever considered turning your list into a Data Table? From this you can then start creating a Pivot Table.  This would be beneficial if your data…

VLookup is used to look up information in a list and extract the data into another list. It can also be used for matching; is the value I have in one list, also in another. The benefit of using Index…

Learning about Relative, Absolute and Mixed Cell References is imperative to being a skilled Excel user. This will save you a great amount of time. If you want to like this guide and want to learn more about the fundamentals…

Formulas and Functions are some of Excels most powerful tools. They allow the user to make complex and useful spreadsheets. This article shows you how to use both Formulas and Functions in Excel, as well as take you through some…

In Excel, there are a few different methods to rename worksheets. This guide will take you through each of them, so you can find whichever approach suits you best. When working in an Excel workbook with multiple worksheets, it is…