BMI Calculator in Excel You can enter your height and weight in a BMI calculator (Body Mass Index) to find your BMI index. This number is commonly used to judge whether your weight is healthy. To learn how to create a BMI calculator in Excel, follow the steps below. 1. Type in the following information […]
How to Make a BMI Calculator in Excel Read More »
Create a Meal Chart in Excel In this lesson, we will create a weekly meal chart or planner in Excel from the scratch. To accomplish this goal, follow the steps below. 1. In Sheet2, we Named Range B3:B15 as Breakfast, C3:C15 as Lunch, and D3:D15 as Dinner. 2. In Sheet1, select cell C5. 3. From
How to Create a Meal Chart in Excel Read More »
Create a Cash Budget in Excel A cash budget is an important step in personal financial management. In this tutorial, you will learn how to create a cash budget in Excel. For this exercise, we assume that you have a basic understanding of using Excel. If not, we highly suggest you consider taking our 100%
How to Create a Cash Budget in Excel Read More »
Excel Templates Create a New Template Excel offers many built-in templates for users to choose from. Instead of creating a workbook on your own, you can take advantage of Excel templates. In this lesson, you learn where those free templates are and how to use them. Built-in Templates To use free templates or workbook design,
What are Excel Templates? Read More »
Copy Visible Cells only in Excel You can use built-in options in Excel to copy visible cells only. To learn how it works, follow the steps below. 1. We have an excel spreadsheet wherein row 2 is hidden. 2. Now, copy the range A1:A4 and paste it below (cell A6). The result above includes the
How to Copy Visible Cells only in Excel Read More »
Row Differences in Excel In row differences in Excel, you can identify cells that have different contents than the comparison cells do. Let’s learn it by following the steps below. 1. Select the range A1:C14 by clicking cell A1 first and then dragging it to cell C14. Here, cell A1 is the active cell and
How to identify Row Differences in Excel Read More »
Delete Blank Rows in Excel To delete blank rows or rows containing blank cells in your worksheet, follow the steps below: 1. Select a range. If you want to find blank cells in the entire worksheet then no need to select any range of cells. 2. Click Home tab ->Find & Select -> Go To
How to Delete Blank Rows in Excel Read More »
Find Features in Excel This tutorial is about more advanced level Find features that Excel offers. Follow the steps below: 1. Click Home tab ->Find & Select -> Find 2. In the “Find and Replace” dialog box, click Options. 3. In the “Find what” box, type the text you want to find (e.g., Marketing) and
Find Features in Excel Read More »
Create Dependent Drop-down Lists The dependent drop-down lists in Excel is designed to create conditional drop-down lists. Specifically, selecting an item from a drop-down list will change the available items in another drop-down list. Let’s create one by following the steps below. 1. In Sheet1 create four named ranges. (a) state [B4:B6], (b) texas [C4:C7],
How to Create Dependent Drop-down Lists Read More »
Create Drop-down lists in Excel Allow non-listed entries | Add/remove items | Dynamic Drop-down | Remove Drop-down Drop-down lists in Excel enable a user to select an item from a list without actually typing it. In other words, this could be used to restrict a user from entering information that is not wanted. Creating a
How to Create Drop-down lists in Excel Read More »
