Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

Category "Excel Functions"

FIND Function in Excel
hd
Admin
  • 3 days ago
  • 11 views
  • 1
FIND Function in Excel
In order to locate text in an Excel worksheet, you can use the FIND function. You can either supply the text directly into the formula or supply a cell reference for the text to be found. In either case, the FIND function will return the position of the character or string within a specified range. The FIND function will return 1 if it finds a string that contains the text you are looking for. The FIND function is case-sensitive, so you should specify a starting point and endpoint in the cell you want to search. Let's see the syntax and argument of the FIND Function in excel; =FIND(find_text,within_text,start_num) Find_text - text you want to find. Within_text - text containing the text you want to find. Start_num - specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1. Table of Content; 00:00 Introduction 00:19 Find Function in Excel 05:56 Conclusion The FIND Function in Excel is a helpful tool for many different applications. Unlike the SEARCH function, it does not mind the cast of characters. In the example above, the FIND function will return "Good Morning," but not the word "good." In this case, the function will return a number, rather than a string. You can also specify the starting position of the string, which is called a range. The FIND function is case-sensitive and works best with two arguments. The first argument is the text string you're looking for. The second argument is the location of the text. The third argument is the start-number. This identifies the position of the left and right parenthesis. The final argument, within_text, is optional. In this case, the FIND function will start searching at position six. The FIND function is a useful tool for finding characters in an Excel spreadsheet. It works by comparing two strings and locating the first character in each one. It also allows you to specify a wildcard character. To use this function in an Excel worksheet, you need to specify the start-num argument. By default, this argument is set to one. The Start-number argument specifies the position from which the search should begin. The FIND Function returns the numerical position of a text string. You can search the entire sheet or a specific cell in the spreadsheet. Using the FIND function in Excel is a great way to find the correct character in a text string. There are also other ways to search a string. You can combine a string with a single word to make it appear in a new row. You can also use a combination of these functions to perform complex tasks. The FIND function can be used to extract the first word from a specific text. The search begins at the first character of the string. If you are searching for a name in a column, you can use the FIND function to find the first word in that column. The space is treated as a character in the spreadsheet. In the case of an email id, it will be the value of the 'T'. The FIND function in excel is case-sensitive. The first character of a text string will be found using the SEARCH function. In other words, it is case-sensitive. If the text contains a space, the FIND function will return the position of the next character after the first. It is possible to locate a dash in a text string by referencing a cell with a formula. For instance, if the string begins with a letter, the formula =FIND("a"). The FIND function in Excel is case-sensitive. It can be used to find a specific character in a string. It can be nested in multiple functions, but it can also be used on its own. The first two arguments are required while the third is optional. The third argument is optional. If the FIND function returns a result that does not match the specified value, the error will be returned with an error code. The FIND function in excel is case-sensitive. It accepts a text as a parameter. The result will be a numeric value if the text contains the word. The FIND function in excel is case-insensitive and does not consider the case. If you have a string in column C, you can use the RIGHT function to extract the last name. Otherwise, you can enter the text in column C.
Read More
Not Equal to in Excel: A basic guide
hd
Admin
  • 1 week ago
  • 17 views
  • 1
Not Equal to in Excel: A basic guide
This video will show you how to use the NOT EQUAL TO operator in Microsoft excel with helper functions like IF function, AVERAGE IF Function, and COUNTIF Function. NOT EQUAL TO is an operator denoted as "<>" which is being used to compare or check if one value is not equal to another value in your worksheet. It's very common for numerical or logical calculation in Microsoft Excel. As the name suggests "NOT EQUAL TO", If you have data and want to sort duplication of text strings or numbers then this comes very handy. Let's say if you want to compare A1 cell should not be equal to B1, then you can simply put the formula i.e. A1<>B1 in cell C1, and it will return boolean values i.e. True or False. Do follow the video using the following timeline for the video; Table Of Content: 00:00 Introduction 00:56 Not Equal to In Excel Basics 02:00 Not Equal to In Excel Using IF Function 06:24 Not Equal to In Excel Using COUNTIF Function 11:10 Not Equal to In Excel Using AVERAGEIF Function 06:50 Conclusion In this video, we have explained the basics of NOT EQUAL TO with basic examples along with logical functions like IF, AVERAGEIF, COUNTIF using 3 different and practical examples to practice for you. If you want to download the same excel sheet used in the video you can download using the link below.
Read More
How to use SWITCH Function in Excel
hd
Admin
  • 2 weeks ago
  • 28 views
  • 1
How to use SWITCH Function in Excel
Switch functions basically replace on given expression against your value which is being prescribed in the function. Like in the above example we have country abbreviations like US, UK, CA, etc and we want to replace such expressions with a full country name like United states for the US, the United Kingdom for Uk, and Canada for CA respectively. We will use the SWITCH and Helper function i.e. RIGHT function to do that. Switch Function Expression; SWITCH (expression, value1, result1, [default or value2, result2],…[default or value3, result3]) Follow the video with below table content to browse through the timeline. 00:00 Introduction 01:50 Switch Function in Excel 08:30 Switch Function Limitation 09:38 Conclusion
Read More
IFS Function in Excel
hd
Admin
  • 2 weeks ago
  • 31 views
  • 1
IFS Function in Excel
IFS Function is one of the most popular or most used function in excel which returns values on the basis of multiple conditions. This function is very identical to IF function as we know IF is limited by one condition whereas IFS can perform multiple conditions as we have described in the above video. In above videom we have described each and everything with examples which you can browse by following the table of content. Syntax for the IFS function is: =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3) Table of Content; 00:00 Introduction 01:10 IFS vs IF Function 04:01 IFS Function In Excel Ex.1 06:10 IFS Function In Excel Ex.2 07:38 Conclusion
Read More

Microsoft Excel has a variety of Excel functions that allow you to manipulate data in different ways. In this section, we will learn all excel functions there is with examples.