Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
How to create your own formula in Excel
The range of formula within Excel is great. Most of the day to day functionality that you need is there but if you find that you need to do a different calculation that is not built in then you can create what is called a User Defined Function (UDF). If you are going...
Excel Foundations
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Formulas and Functions
The IF statement in Excel
This quick video explains using the IF Statement in Excel The IF statement in Excel is widely used in Excel and can be confusing if you haven't come across it before. This short video will show you how to use the IF statement - which is used when testing for a...
Using the VLOOKUP Formula
This quick video explains how to use the VLOOKUP Formula in Excel Using The VLOOKUP Formula is one of the most widely used functions in Excel and is regularly used incorrectly. Learn why it is so useful and what errors to avoid. V is short for Vertical and lets us...
Calculating a person’s age in Excel
Calculating a Persons Age in Excel. So you want to know a person’s age or need to calculate how many years have lapsed since a renewal date. Perhaps you want to know the ages of your staff without having to calculate it each year or you want to check if one of your...
Excel Analyzing Data
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Charts
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Reporting and Dashboards
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Security and Design
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Recording Macros and VBA
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.