In some cases, you may need to calculate the total number of characters in a cell/range or the number of times a specific character occurs in a cell. While there is the LEN function that can count the number of characters in a cell, you can do the rest as well with a combination of formulas (as we will see later in the examples). In this tutorial, I will cover different examples where you can count total or specific characters in a cell/range in Excel....

A Scroll Bar in Excel is what you need when you have a huge dataset and you don’t want it to hijack your entire screen’s real estate. It’s a great tool to use in an Excel Dashboard where you have to show a lot of data in a limited space. In this step-by-step tutorial, I will show you how to create a scroll bar in excel. You will also learn how to link a dataset to this dynamic scroll bar, such that when a user changes the scroll bar, the data accordingly changes....

It’s a numeric value that tells us how two variables are correlated. It tells us how much the dependent variable will change in case there is a change in the independent variable. There are three ways to find the slope of the regression line for a given set of variables in Excel: Using the SLOPE FunctionUsing an Excel Scatter chart In this tutorial, I show you how to calculate slope using each of the above three methods....

For example, you may have a list of dates where you want to highlight all the weekend dates. This can easily be done using Conditional Formatting with a little bit of formula know-how. In this tutorial, I will show you how to highlight the weekend dates in a date data set. The method covered here can also be used to highlight any kind of dates (say Mondays or Tuesdays or alternate days) So let’s get to it!...

By default, Excel does this by inserting page breaks at regular intervals in the worksheet while printing. This is done based on the paper size, margins, and scale options. But in case you need more control and want to decide how much content should be printed on Page 1 and where it should break and go to the next page, then you can manually insert a page break in between the pages....

Excel formulas are easy to create and edit in Excel. You can easily edit a formula through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. Consider this. You are going through a worksheet full of formulas, and you accidentally hit the delete key, or backspace key, or some other number/alphabet key. Now you’ll be lucky if you’re able to spot the error and correct it....

Among all these Excel chart types, there has been one that has been a subject of a lot of debate over time. …the PIE chart (no points for guessing). Pie charts may not have got as much love as it’s peers, but it definitely has a place. And if I go by what I see in management meetings or in newspapers/magazines, it’s probably way ahead of its peers. In this tutorial, I will show you how to create a Pie chart in Excel....

For example, if you have the name and designation data of people, you may want to remove the designation after the comma and only keep the name (or vice-versa where you keep the designation and remove the name). Sometimes, it can be done with a simple formula or a quick Find and Replace, and sometimes, it needs more complex formulas or workarounds. In this tutorial, I will show you how to remove the text before or after a specific character in Excel (using different examples)....

However, there is no inbuilt functionality in Excel to sort the cells based on the length of the text in the cells. In one of my Excel training sessions, I was asked whether it is possible to ‘sort by the length of text in the cells in Excel or not. I could come up with two simple methods to do this (there could be more I am sure). In this tutorial, I’m going to share these two simple methods you can use to quickly sort by the length in Excel....

This happens because, somehow, the Scroll Lock has been enabled, and you need to turn off the scroll lock for things to work as expected in Excel. In this short tutorial, I will show you a couple of methods to quickly turn off the Scroll Lock in Excel. How to Know that Scroll Lock is Enabled? Before I tell you how to turn off the scroll lock in Excel, I must tell you how to identify whether it is enabled or disabled....

When to use Excel TEXT Function Excel TEXT function can be used when you want to convert a number to text format and display it in a specified format. What it Returns It returns text in the specified format. Syntax =TEXT(value, format_text) Input Arguments value – the number that you want to convert into text. format_text – the format in which you want to display the number. Additional Notes This is a useful function when there is a need to show numbers in a format, or a need to combine numbers with text/symbols....

For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to that URL. There are many things you can do with hyperlinks in Excel (such as a link to an external website, link to another sheet/workbook, link to a folder, link to an email, etc....

In this blog post, I will show you various ways to use the HYPERLINK function to send emails from Excel. There is also a bonus Email Generator Excel Template available for download at the end of this post. Let me first explain the Hyperlink function: Hyperlink Function Syntax: =HYPERLINK(link_location, [friendly_name] link_location: This is a mandatory argument where you give the link of a cell, worksheet, workbook, or an external URL....

In this blog post, I have listed 10 useful Excel Data Entry tips that will make you more efficient and save a lot of time. #1 Use Excel Data Entry Form Excel Data Entry form enables you to add records to an existing data set. It gives a pop-up form that can be filled by the user. It is especially convenient when the data set has many columns and would require you to scroll right and left again and again as you key in data points....

And what is more awesome is that one Excel function – a formula that consists of two, three, or more functions. With a combination of functions, you can create some advanced Excel formulas that can do some incredibly advanced things with a press of a key. So if you’re an Excel aficionado like me, I am sure you’re going to love this article. In this article, I will cover the 20 advanced Excel functions you should know....

A common thing many Excel users need to check when working with dates is whether a date is between two given dates. A simple use case of this could be when you need to check whether the date of submission of a report was within the given dates or not. Based on this, you can highlight what reports were submitted after the deadline. In this tutorial, I will show you how to check if the date is between two given dates or not....

In this tutorial, you’ll learn how to create a searchable drop-down list in Excel – i.e., a drop-down list that will show the matching items as you type. Below is a video of this tutorial (in case you prefer watching a video over reading the text). Searchable Drop Down list in Excel For the purpose of this tutorial, I am using the data of Top 20 countries by GDP. The intent is to create an excel drop down list with a search suggestion mechanism, such that it shows a drop down with the matching options as I type in the search bar....

Now there are various ways you can use to do this: Go to each blank row and delete it manually (too tedious and time-consuming). Sort the entire data set so that all the blank rows are at the bottom (works but alters the data set). Use Go To special technique (or a macro) to select all the blank cells at once and delete the rows (way to go). Delete Blank Rows (Empty Rows) in Excel In this tutorial, you’ll learn two ways to quickly select the blank cells in a data set:...

The INDIRECT function in Excel can be used when you have the reference of a cell or a range as a text string and you want to get the values from those references. In short – you can use the indirect formula to return the reference specified by the text string. In this Excel tutorial, I will show you how to use the indirect function in Excel using some practical examples....

Till now, she used a simple Gantt chart in Excel but wanted something better with more functionalities. So, I created this Excel Leave Tracker Template to make leaves management easy and track monthly and annual leaves by her team members. You can also use this as a vacation tracker template or student attendance tracker if you want. Excel Leave Tracker Template This Excel Leave Tracker template can be used to record and monitor employee leaves for a year (of a financial year where you can choose the starting month of the year)....