Top 20 + common Excel questions for your job interview

Excel

This page list all common Excel questions for your job interview and their answer. This page will be updated regularly to ensure it’s most updated accuracy. Please come back regularly or consider to have this page bookmarked. Common Excel questions for your job interview 1) What is Microsoft Excel? Microsoft Excel is software that is … 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

Excel Tutorial: How to write an if statement in excel

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:

If Function in Excel

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”.

Read more

How to manipulate worksheets in Excel

How to manipulate worksheets in Excel? As mentioned from my other blogs – How to create a new excel file? – an Excel spreadsheet can have multiple sheets in one file. You can add, rename, move, delete, hide, unhide entire spreadsheet as long as to change colour of the spreadsheet. If you are using Excel … Read more

How to do summation or counting in Excel with multiple wildcard criteria? – new excel functions

Example of sumifs function

We can use the following functions to do summation or counting in Excel with multiple wildcard criteria Summation or counting in Excel with multiple wildcard criteria However, both Sumif and Countif only allows single criteria. SUMIFS & COUNTIFS Since Excel 2007, Microsoft have introduced two new functions called SUMIFS & COUNTIFS They are close to sumif and … Read more