How to Use the Excel OR Function
The OR Function is a logical Function, that evaluates two or more conditions and returns true if at least one of the conditions is true. If all of the conditions are found to be...
ExcelDemy.com Blog
Excel Security: Worksheet vs. Workbook Level Protection
It is often necessary to protect either the sensitive information in one’s actual worksheet or the workbook structure, from being edited. Excel provides different options for protecting and securing one’s data and we are...
How to Use the HLOOKUP Function in Excel
We have already seen how to utilize the VLOOKUP Function in a previous tutorial. We are now going to see how to use the HLOOKUP Function. HLOOKUP stands for horizontal lookup and is used...
How to Use XOR Function in Excel [With Example]
The XOR Function is a logical function that was introduced in Excel 2013 and later versions. The XOR Function if used with two conditions and one of the conditions evaluates to true, then the...
How to Use the CEILING.MATH and the FLOOR.MATH Function in Excel
The CEILING.MATH Function is a new function that was introduced in Excel 2013 and later versions. The CEILING.MATH Function rounds a specified number up to the nearest integer or nearest specified multiple of significance....
How to Use Excel ROUND, ROUNDUP, ROUNDDOWN, MROUND & CEILING Functions
Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are namely the ROUND Function, the ROUNDUP Function, the ROUNDDOWN Function, the MROUND Function and the CEILING Function. The ROUND...
3D Referencing & External Reference in Excel
Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D...
How to Compare Two Columns in Excel to Find Differences
This is an interesting situation that often comes up. Namely, sometimes one needs to match data in two different columns or different sheets. So, let’s get started with a simple example, to illustrate how...
How to use the TODAY() and NOW() Functions in Excel
The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April...
How to Print Excel Spreadsheet with Grid Lines and Change its Color
Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Well, look no further, since we will show you how to do just...
Using Table Nomenclature in Excel and Referring to Tables in VBA
We have already covered how to format Excel Tables extensively in a previous tutorial. We are now going to look at using Table Nomenclature or structured Table references in formulas. Using structured Table References...
How to Create Doughnut, Bubble and Pie of Pie Chart in Excel
Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are used to showcase...
How to Apply Accounting Number Format in Excel!
The Accounting Format is similar to the Currency format and can be applied to numbers where needed. The difference between the Accounting format and the Currency format is that the Accounting format puts the...
How to Print Excel Sheet on One Page
This is a question that is often asked (How to Print Excel Sheet on One Page), namely how to fit the contents of one’s spreadsheet on one page when printing. So we are going...
How to Use the FORMULATEXT Function in Excel
The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula and...
40+ Free Online Excel Course with Certificates
So, you’re looking for free online Excel course with certificates. You’re at the right place. On this page, I’ve listed 40+ free Excel courses (online based) and after the completion of the courses, you...
