I have created an excel based Multiplication Time Table practice 20 x 20 program.  This Multiplication Table practice is mainly designed for kids in their primary school. Download from here.   Following is the instruction: Enter the answer in the white area If the answer is correct, it will automatically change the background colour to green. … Read more

## How to replace words in excel? Substitute or replace in excel?

How to replace words in excel? You can use two different functions – substitute and replace. Difference between substitute and replace are shown from the following table. SUBSTITUTE function in excel The substitute function in excel is to replace a text within a cell by a new text Syntax SUBSTITUTE(text,old_text_new_text,[Instance_num]) Argument Argument Description text The … Read more

## Getpivotdata – an easier and better way to reference a pivot table in Excel

From my other blog I have illustrated how to create a pivot table. How to read information from a pivot table Now I am going to mention how to refer information from a pivot table. There are two ways to do the job refer to the corresponding cells  (e.g. = a10) using the “GetPivotData” function … Read more

## How to Create Pivot Table in Excel

This video illustrated hot to create pivot table in excel. What is a Pivot Table? A pivot table is an excel report that quickly summarise a large amount of data. It automatically performs sort, count, total or average of data stored in the spreadsheet and displays result as a report. Usually, the reports will be … Read more

## Difference between all 5 count functions (COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK) in Excel.

What is the difference between COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK in Ms-Excel? Suppose we have a table like this.   Different type of count functions The following table illustrated the differences between each function: Usage Count Count number of cells that have numbers or values CountA count any cell value containing numbers, text, logical values, … Read more

## How to use if function with multiple conditions and outcomes in Excel

This paragraph is original in English. From my last blog, we have introduced the if function in Excel where following is the syntax: Syntax: if function with multiple conditions and outcomes What if we have multiple conditions? Can we use the if function with multiple conditions? The answer is “Yes”. There are two ways to … Read more

## How to change report formats in Excel

From my last blog, I have mentioned how to create pivot table in excel. Now, let’s go through different kinds report formats in Excel pivot table. There are three types of report formats in Excel Pivot Table: Compact Form Outline Form Tabular Form Suppose we have a pivot table with the following report fields. Following is … Read more

## How to merge cells in Excel without losing data in 2 steps

Merge cells in Excel can be as easy as one click. However, how to merge cells in Excel without losing data? Before discussing how to merge cells in Excel without losing data. Let’s call over how to merge cells in Excel. How to Merge Cells in Excel As mentioned, merge cells in Excel cab be … Read more

## How to write an if statement in excel?

The IF function in Excel is one of the most popular conditional formula functions, and it allows you to make logical comparisons between a value and what you expect.

Syntax:

[vtftable cols=”{0}0:fff2cc;{/}”]
=if(Condition , Result when matched, result when not matched);nn;
[/vtftable]

For Example: Meaning:

If A2 is less than 10, (exclude 10), then the value for B2 is “<10”, else the value for B2 is “>=10”.

As now A2 is nothing, in Excel, it will be considered as 0. Therefore, the result for B2 is “<10”.