Explaining how the LARGE Function works

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 deep dive into how the LARGE function works in Microsoft Excel. It will include a summary of this function, its formula syntax,Continue reading “Explaining how the LARGE Function works”

Why do you need the RANK 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. In this post, you will learn why the RANK function will be a useful asset to you and all about using the RANK functionContinue reading “Why do you need the RANK Function?”

How to use the MEDIAN 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 teach you how to use the MEDIAN function in Microsoft Excel, including a summary of it, its formula syntax, and also anContinue reading “How to use the MEDIAN Function?”

Using text 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. Introduction to using text functions (reference) This post will teach you how to use each of the text functions (reference) and some important factors toContinue reading “Using text functions (reference)”

How to combine text and numbers?

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. This post will teach you how to combine numbers and text using various functions, including CONCATENATE, CONCAT, TEXT and TEXTJOIN functions. Imagine you must make a grammatically correct sentence from numerous columns of data to finalise a widespread mailing. Alternatively, you’re in need ofContinue reading “How to combine text and numbers?”

How to count characters in cells

Applies to: Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013. In this post you will learn how to count characters in cells, using the LEN function and SUM function. Counting characters using the LEN Function For any time you have to count the characters in cells, the LEN function comes in handy. This functionContinue reading “How to count characters in cells”

How to use the SEARCH and SEARCHB Functions?

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 show you how to use the SEARCH and SEARCHB functions in Microsoft Excel. We will will cover their descriptions, their respective formulaContinue reading “How to use the SEARCH and SEARCHB Functions?”

How to use FIND and FINDB Functions?

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 teach you how to use the FIND and FINDB functions in Microsoft Excel. You will learn how they work, the syntax ofContinue reading “How to use FIND and FINDB Functions?”

How to use the CONCAT Function?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2019 for Mac. This post will teach you how to use the CONCAT function (how it is formatted), essential conditions for it to work, some examples. There will also be some further links directing you to similar topics to exploreContinue reading “How to use the CONCAT Function?”

Using the CONCATENATE 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 teach you how to use the CONCATENATE function in Excel. We will cover what it is used for, its syntax, examples whichContinue reading “Using the CONCATENATE Function”