Maths and trigonometry functions (reference)

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This blog post presents you with a list of all Maths and trigonometry functions. To obtain in-depth details about a function, select its nameContinue reading “Maths and trigonometry functions (reference)”

How to count unique values within duplicates?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011. This blog post will teach you how to count unique values among duplicates. It will explore various functions you can use to count unique values, such asContinue reading “How to count unique values within duplicates?”

How to cover error values and error indicators in cells?

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. This blog post aims to teach you how to conceal error values and error indicators in cells. It will also explain why error values and indicators arise in your spreadsheet in the first place so you can guard against them in future. Imagine thatContinue reading “How to cover error values and error indicators in cells?”

##### error – a guide to resolving this

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011. In this guide, you will learn why the ##### error happens and what actions you can take to rectify these to present your dataset in all its entirety. Microsoft ExcelContinue reading “##### error – a guide to resolving this”

#NAME? error – a guide to fixing this

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Web App, Excel Starter 2010. This guide will outline why the #NAME? error appears in your formulas and how to rectify this. The single greatest reason why theContinue reading “#NAME? error – a guide to fixing this”

#REF! error – a guide to how to correct this

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile, Excel Starter 2010. This guide will teach you how to rectify the #REF!Continue reading “#REF! error – a guide to how to correct this”

How to fix a #NUM! error?

Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile Excel Starter 2010. This post will examine when a #NUM! error typically occursContinue reading “How to fix a #NUM! error?”

A guide to correcting a #VALUE! error

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Web App, Excel Starter 2010.  This post will teach you what #VALUE! error means and offer you solutions for correcting a #VALUE! error whenever it comes up. AnytimeContinue reading “A guide to correcting a #VALUE! error”

Using the ODD Function

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will tell you how to use the ODD function in Microsoft Excel. It will include a summary of this function, its formula syntaxContinue reading “Using the ODD Function”

The EVEN Function Explained

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.  This post outlines how the EVEN function works, including a summary of this function, important conditions to keep in mind when using it asContinue reading “The EVEN Function Explained”