The MAX and MIN Functions in Excel: Finding the Largest and Smallest Values

The MAX and MIN functions in Excel are used to find the largest and smallest values in a range of cells, respectively.

The COUNTIF Function in Excel

The COUNTIF function in Excel is used to count the number of cells in a range that meet a certain criteria.

The INT function in Excel and Google Sheets, is used to round a number down to the nearest integer, or give you a whole number.

Here are five common Excel mistakes that people often make, that you should be aware of and how to avoid them.

Learn how to use CONCATENATE in Excel, and other methods of joining together text from two cells.

Many office workers only know how to use a small fraction of Excel’s capabilities. Here are the five things you need to learn.

The COUNTIF function in Excel is a powerful tool that will help you quickly analyse data, making your job go much smoother.

Using conditional formatting in Excel to display icons is a great way to make your spreadsheets stand out from the crowd.

Why was the Excel spreadsheet feeling confused?

Because it had too many dates and didn’t know which format to choose!

VLOOKUP is a very powerful tool in Excel, when interviewing candidates for jobs, I would ask them about their English, Maths and VLOOKUP skill