fbpx

Category

Formulas

Conditional Formatting with Formulas

Let’s begin by defining the term Conditional Formatting? Conditional formatting is also expressed as conditional automatic formatting. It is triggered under certain defined conditions by the user. Say we use conditional formatting to make characters bold and italic at the start of each line. And it worked. Then, conditional formatting is an effective way to...
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protech formula in Excel? Confused? Here is the blog to know how to lock excel formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or...
Read More

How to Create Formulas in Excel?

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. This tutorial explains how to write formulas in Excel, beginning with very simple ones. We will learn how to create a formula in Excel using three ways, Constants, Cell references and...
Read More

How to copy formulas in Excel?

  Before you start reading this blog, Checkout our top Selling Comics: Think: Sometimes we need to do same formulas in another cell or column, but can’t copy easily based on our requirements. There are many ways to copy formulas and its value from one cell to another or one sheet to another. Let’s see some...
Read More

How to Display Formulas in Excel

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells instead of the result. So, Let’s Show Formulas in Excel Instead of the Values with those...
Read More

How to use Roundup Function in Excel

Roundup Function in Excel can use as a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. Here, we will learn how to Round up numbers in Excel. Before we start, we must know about...
Read More

Countif function in Excel

COUNTIF function in excel counts cell meeting a single criterion. It will Count the Empty or the Blank Cells present in the Range. You can use COUNTIF Function to count or Calculate the number of Cells, the cells with dates, numbers, and text matching a specific criterion. The COUNTIF function Supports the logical operators (>,...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....
Read More

Microsoft Excel Go To Data Cleaning Trick

Data Cleaning Trick It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important if you are working in...
Read More

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you why. Excel Sumif...
Read More

Excel VLOOKUP Function

Before we learn how to use Excel VLOOKUP function, we must learn when do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no.,...
Read More

How to Use Excel VLOOKUP Formula

What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right. you will...
Read More

INDEX Formula in Excel

Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned about my favorite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer...
Read More

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
Read More

Learn how to use SUMIF Excel Function

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to add...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features one of it is excel formula auditing. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the...
Read More

How to Calculate Ratio in Excel | Excel Formula

This article is been written to find calculate ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such advanced excel tutorial in our advanced excel dashboard course. If...
Read More

Working with Excel Date Functions

In this article, let us learn more about Excel date functions and Excel date format. It will help you in areas of calculations such as due dates, project deadline & warranty expiry date. Here is a summary of what we will explain: How is a date stored in Excel (Hint: Every valid date is a...
Read More
1 2