Excel

Excel: Using the XLOOKUP Function, Latest Function in Excel

  • by

The XLOOKUP function is a relatively new addition to Excel and replaces the VLOOKUP and HLOOKUP functions, although you can still use those. There are extra features as well as being easier to use and simpler to understand. It gives …

How to Use the Excel AVERAGE function

  • by

You may be familiar with the SUM function for totalling up a set of figures but there are some other similar functions such as AVERAGE for working out, you guessed it, the average.

Other related functions:

AVERAGEIF …

Using the AVERAGEIF Function in Excel

  • by

What if you want to work out the average on some figures but you only want to calculate it based on certain criteria. For that you need the AVERAGEIF() function.

Related functions:

AVERAGE …

Excel: Colour Code the Tab on Your Worksheets

A great way to organise your worksheets in Excel is to colour code the tab of the worksheet, this can help you quickly identify particular sheets and make working that much quicker. It helps too if you are sharing and …

How to Remove Duplicates in an Excel List

If you have built up a list of data in Excel there may be a chance that there are duplicates of the same entry or perhaps someone has given you a list that you know has duplicates. Thankfully removing duplicates …

Excel: How to Use the HLOOKUP Function

  • by

You may have come across the VLOOKUP function in Excel, it is a very useful function and one of the most used in Excel. There is also HLOOKUP which is similar but is used when you have your data in …

How to Copy an Excel Worksheet

If you need to make a copy of a worksheet in Excel then here are two easy ways to do it. This works for both the Windows and Mac versions of Excel. …

Excel Hide Gridlines and Headings

If you want to display a worksheet in Excel you have the choice of making gridlines and headings visible or invisible. You can simply choose to not display the gridlines and/or the headings.…