To meet multiple conditions in data or record, Excel offers the nested if function. We know, the IF function has three arguments – in case of nesting, you can replace one of the arguments with another function – it can be another IF function or SUM function or AVERAGE function and so on. It depends ...

The following table lists weight of several persons in kilogram. I would like to convert them into pounds. Select cell C2 > click on fx (you find it ( fx ) left to the formula bar or under the Formulas tab – it's called 'Insert Function') The 'Insert Function' window opens > from under Select a func...

First open the MS-DOS prompt Click Start > type cmd and press Enter . The dos command prompt opens. In my case, it always opens with the default directory path C:\Users\mybook99> So type cd.. and press Enter, it will move you one level up. C:\Users\mybook99>cd.. [enter] C:\Users\>cd.. [enter] C:\> N...

If you want to make a quick sum of a range of data, the best and easiest way is to use the shortcut for Autosum. First, you need to install it in your quick access toolbar. So follow the steps: Right mouse click on the Autosum button ( Σ button under Home tab) > select Add to Quick Access Toolb...

There are several ways to calculate age in Excel. Let's say, in the following table I will calculate the age of Jens Hendrik. So in cell C2 enter =(YEAR(NOW())-YEAR(B2)) http://shamskm.com/forum/exceltutor/agecalc/age_calculation_with_year_function.jpg Here instead of any current date, I have used t...

You can do it with 'Steps Recorder' , also called 'Problems Steps Recorder' to take a screenshot with mouse cursor. Click on Start button > go to Windows Accessories > click on Steps Recorder . This small tool opens. http://shamskm.com/forum/images/pcstuffs/screenshot_with_mouse_cursor.jpg Now click...

Let's say, I would like to add 5 rows between cells A6 and A7. http://shamskm.com/forum/exceltutor/excel2/insert_rows_in_excel.jpg So select cell A7 > right mouse click > Insert... > select Entire row . It will add a single row between the cells while moving the original cell A7 content down. Now pr...

By default, in Excel all cells are locked. So if you want to lock a single cell or specific cells: - you have to unlock all cells first, - select and lock the specific cell or cells, and - then protect the worksheet (with password). In the following example, I want to protect only the cells A5, B5 a...

An average is the sum of your data points divided by the number of data points. Here each data point contributes equally to the final average, while in weighted average , some data points contribute more than others. Let's say, you buy and sell second-hand cars. So your recent purchase is as follows...

Microsoft Excel's Text to Columns is a powerful feature that can split texts into multiple columns. You find it under Data > Data Tools > Text to Columns . With the keyboard shortcut ALT + A + E you can also access this feature. http://shamskm.com/forum/exceltutor/texttocolumns/excel_s_text_to_colum...

Microsoft Excel's Text to Columns is a powerful feature that can split texts into multiple columns. You find it under Data > Data Tools > Text to Columns . With the keyboard shortcut ALT + A + E you can also access this feature. http://shamskm.com/forum/exceltutor/texttocolumns/excel_s_text_to_colum...

If you want a quick summary of key statistical parameters (like mean, standard deviation, sum etc.) for your data set, the best and easiest way is to use Excel's data analysis tool called Descriptive Statistics . Where do you find this tool? Go to Data tab > here you should find the Data Analysis bu...

Let's say, I would like to copy and paste the following Excel table as it is to another sheet. Here you see, one student is in red as he is below the pass mark 45. Two are above 75 – very good, and marked with blue and bold. http://shamskm.com/forum/exceltutor/excel2/how_to_use_paste_special_in_exce...

In the following table, I have sales report from 2010 till 2017. I want to calculate the percentage of change in sales in 2011 from the previous year 2010, then percent change in 2012 from the previous year 2011 and so on. I want to make my calculation in Column C. Here I need to change the cell for...

Suppose you want to make a list of members with names and unique id numbers for your newly born 'Samba' club. So you would like to prevent double entries for member names. Let's start : Select the range (A2:A15) Go to Data > Data Validation Data Validation window opens: Under Settings > choose Custo...