Excel is a very popular program and has many features. Here are tutorials for everyone from the beginner to the advanced user. These tutorials are for both Windows and Mac versions and I add to this page regularly.
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 you an option for what to do if there is no match found and unlock the other lookup functions mentioned it can look to the left of the array or above it which was not possible before.
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 collaborating on an Excel workbook.
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 in an Excel list is straightforward. In more recent versions this is very easy, in older versions it is still easy but done differently.
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 columns rather than rows. The HLOOKUP function takes a value and looks for it in the first row of an array and then returns the corresponding value from another specified row.
Excel has some useful database functions that allow you to set criteria so that you can filter information in a list or database so that you can sum, average, and get highest and lowest values. These are done using the functions DSUM, DAVERAGE, DMAX and DMIN.