Welcome! Lets start your excel journey..

## Welcome! Register Now to Unlock Exclusive Excel Tutorials

• Exclusive Playlists
• Exclusive Templates

# Category "Excel-Formulas" hd
• 7 hours ago
• 2 views
• 1
Count the Number of Errors using Excel's ISERROR, IF and COUNT Function hd
• 7 hours ago
• 3 views
• 1
How To Count Specific Word That Occurs In a Cell?
In this video, I will show you how to count specific words that occur in a cell. This is different from counting cells because we can not just use the COUNT function and specify "count" or "cells." We need to look at each word individually and then add it up. To do this we will use the LEN and SUBSTITUTE functions. These two functions allow us to find out how many characters are in a text string; and if we want, we can replace them with something else too! Table Of Content: 00:00 Introduction 01:08 Adding Helper Value 02:22 Adding Length of the cell using LEN Function 03:10 Substituting Value with Blank Value using LEN & SUBSTITUTE Function 04:16 Calculating the number of John in Specific Cell 04:57 Complete formula to Count Specific Word Occurs in a Cell 07:32 Conclusion Count function has its own limitation as you cannot count specific words that occur in a cell. So here we are using Excel LEN and SUBSTITUTE functions to resolve the same. Let's take an example where we want to count a number of "John" in a specific cell. We will first add a helper value so that we can easily identify the location of John in the text string. This is done by simply adding an apostrophe (') at the beginning and end of the text string as shown below: ='John' Now, we can use the LEN function to find out how many characters are in this text string. The LEN function will return 11 as there are 11 characters including both apostrophes. Next, we will use the SUBSTITUTE function to replace all instances of John. So we are using two functions here, lets see the argument of both. =LEN(text) =SUBSTITUTE(text, search_term, replace_with) Now follow the video above to understand how to do the same. hd
• 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. hd
• 2 weeks ago
• 36 views
• 1
How to Sum Multiple Worksheet in Excel
Do you have two or more worksheet to work on? want to sum across multiple worksheet in your current one, then this video is for you. In this video, we will learn how to sum multiple worksheet using 2 ways to resolve the same. checkout the table of content below and watch the video above for the same. Table Of Content: 00:00 Introduction 01:14 Copy Formula in Excel 03:19 Fill Formula In Rows or Columns 04:18 Absolute Reference 06:16 Move a Formula 08:20 Bonus Tip 09:38 Conclusion

Sample SEO text for showing on Excel-Formulas category page. Here you can use HTML tags. Here you can show random best words.