Blog

Cells and Ranges

Posted on 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

Simple Worksheets Commands

Posted on 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
what is a worksheet step 6

What is a worksheet

Posted on 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
what is a workbook step 6

What is an Excel Workbook

Posted on 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

How to create a dynamic Excel drop down

Posted on by DevPaulC
Learn how to create an Excel drop down list the right way. Yes, there is a wrong way and I will show you below. The right way to create a drop down list is to make it dynamic so you can always add new items to your list without changing any formulas or data validation rules in order to incorporate the new values. Static drop down lists - the wrong way Let’s assume you have a list of cars in the first column and you want to create a drop-down list to be able to pull your favorite car...read more

How to convert text to date in Excel

Posted on by DevPaulC
There are many cases when the data you have in Excel appears to contain dates but when you look closer, the dates are not in a date format. This can be problematic if you need to sort dates, group them by month, year, week or days. So we have to find a way to convert them to a Date format. The direct text to date conversion This method may seem very simple and direct. Unfortunately it doesn't work in most of the difficult cases. However, it is the first method to try so you can see what are you...read more

How to get data from web in Excel

Posted on by DevPaulC
Did you know that you can get data stored on websites directly into Excel and refresh it with a click of a button? Here's how you do it Before you get into the method, it's important to know that not all websites will be open to be imported into Excel. The data in the website has to be in the form of a table. The best way to determine if the data can be imported in Excel is by trying to import it. You can also get an indication if it would work if you visit a website and...read more

How to add numbers in a column in Excel

Posted on by DevPaulC
Adding numbers in a column or on a row is one of the most basic Excel Functions. Here are 3 easy ways to do it. Use simple addition ( the plus sign +) Use the SUM() function Use the AUTOSUM button Simple addition In the example below we have a list of cells containing the amount of money in sales for 12 months for 4 products. Assuming that we want to add all the amounts in January, let's do a simple addition of the 4 numbers highlighted. How to create a simple addition A simple addition looks like this:...read more

Excel IF statement

Posted on by DevPaulC
IF statement is one of the most common programming function. It is also one of the most used ones in Excel. The IF function can be used with one condition, as described below or with multiple conditions evaluated using the AND / OR functions How does the IF function work The IF function works like this. There are two branches. An IF branch and an ELSE branch. As an example you can use this to assign a value if something happens or not. If event happens then assign a value else assign another value. For example: IF Traffic Light...read more