Excel - Easy Simple Smart

What is an Excel Workbook

Posted on June 19, 2025 by DevPaulC

If you're new to Microsoft Excel, you might hear the term "workbook" often. So, what exactly is an Excel workbook? Let’s break it down! Excel Workbook vs. Excel Worksheet At its core, an Excel workbook is like a binder, and each worksheet inside is like a page in that binder. You can think of a workbook as a collection of worksheets, all housed within one single file. Key Features: Workbook: The entire Excel file (.xlsx) that contains one or more worksheets. Worksheet: Also known as a “sheet,” this is a grid of cells where you can enter data, perform...read more

COUNT functions in Excel

Posted on June 19, 2025 by DevPaulC

There are a number of COUNT functions in Excel that you can use to count your records. Here are the most used ones: COUNT - count the number of cells in a range that contain numbers COUNTA - counts the number of cells in a range that are not empty COUNTBLANK - counts the number of cells in a range that are empty COUNTIF - counts the number of cells in a range that meet a condition COUNTIFS - counts the number of cells in a range that meet a set of conditions Let's get into the details COUNT...read more

What is a worksheet

Posted on June 19, 2025 by DevPaulC

A worksheet is a tab inside a workbook in Excel. Think of it like a page in a notebook. Just as a notebook has many pages, an Excel workbook can have many worksheets, each used to store data and perform calculations. By default, a new workbook starts with one blank worksheet named "Sheet1" Adding More Worksheets To add more worksheets: Click the + icon next to the existing sheet tab (usually labeled "Sheet1"). Every time you click it, a new worksheet is created. Tip: You can have as many worksheets as you need within the same workbook. Each one...read more

How to use multiple conditions in the Excel IF function

Posted on June 19, 2025 by DevPaulC

If you want to use multiple conditions in an IF function in Excel, you have to use the AND or the OR function to evaluate all the conditions (two or more conditions). All conditions evaluated have to be TRUE to make the output of the AND function TRUE. Only one condition have to be TRUE to make the output of the OR function TRUE Example: =IF(AND(condition1,condition2,condition3), ValueIfTrue,ValueIfFalse) =IF(OR(condition1,condition2,condition3), ValueIfTrue,ValueIfFalse) AND and OR functions AND and OR are the logical function used in all programming languages. Here is how these functions work. The AND function AND (TRUE, TRUE) = TRUE...read more

Simple Worksheets Commands

Posted on June 19, 2025 by DevPaulC

As seen in the previous section "What is a worksheet" once we have a brand new worksheet, we can do some commands in regards to that worksheet. To access a list of the quick commands, right click on the name of the worksheet. List of worksheet commands How to insert a new Worksheet and more The Insert action is used to insert a new worksheet. Similar with the + sign, if you press Insert, you get the option to insert a black worksheet. While the + sign immediately inserts a new worksheet (the most common thing to do), with...read more

How to Calculate BMI in Excel

Posted on June 19, 2025 by DevPaulC

The BMI calculation formula is =weight(kg)/height(m)^2. In this example, we'll apply this formula in Excel. The formula works for the metric measurements. If you have your measurements for height and weight in imperial units, you'll first have to convert them to metric. Step 1: Calculate BMI in Excel in the metric system. The weight is listed in cell A2, the height is listed in cell B2 and the BMI is calculated in cell C2. The calculation here is =A2/(B2*B2). Make sure you isolate the (B2*B2) to ensure the order of operations. Another way to write the formula would be...read more

Cells and Ranges

Posted on June 19, 2025 by DevPaulC

Cell In Excel, one grid box is called a cell. A cell is named as the intersection of the column and row. In the example below, the Cell is named C4 because it is at the intersection of row 4 and column C. You can see the name of the cell that you currently have selected in the name field (highlighted in yellow) Range A Range is a collection of two or more cells. If you select a cell and then with the left mouse button pressed, drag the mouse down and right, you would select a range of...read more

How to open Excel Files downloaded from the Internet

Posted on June 19, 2025 by DevPaulC

You may have reached here because you purchased and Excel template from one of our Online Stores on Etsy, TeachersPayTeachers or Gumroad. Or maybe you downloaded a file from somewhere else and you want to open it. First of all, make sure you trust the source. We scan all our files with the latest anti-virus programs. It is also good, as an additional precaution to have your own antivirus and to scan any file that you may have received. The warnings below are usually showing when opening Excel files with macros. Here are some of the warnings you may...read more

The excel ribbon

Posted on June 19, 2025 by DevPaulC

When first introduced, the ribbon was not liked by many experienced Excel users. Personally I hated the ribbon. Now, I can't even imagine how Excel looked before the ribbon. If you don't know, or don't remember, this used to be instead of the ribbon. How does it look to you now? Compared with the current ribbon Much better, right? The ribbon is not just one ribbon. It is actually 10 ribbons that change depending on the tab selected. Each tab has it's own set of commands. The Home tab has worksheet related commands, the Insert tab has commands related...read more

What is an Excel Pivot Table

Posted on June 19, 2025 by DevPaulC

Pivot tables are Excel's most powerful feature. A pivot table lets you summarize detailed data automatically. In this tutorial you will learn what is an Excel Pivot table and how to create an Excel pivot table to summarize a simple dataset. Case Study A grocery store wants to keep track of daily sales of the main fruits thei are selling: Apples and Oranges. They start with a blank Excel sheet and each day add two lines. One for the sales of Apples and one for the sales of Oranges. Towards the end of the month, the store manager wants...read more