Search found 306 matches

by Admin
Thu Jan 26, 2017 11:51 am
Forum: Technology & How-To Forum
Topic: Conditional Formatting with Nested IF Function in Excel
Replies: 0
Views: 4603

Conditional Formatting with Nested IF Function in Excel

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 ...
by Admin
Tue Jan 24, 2017 2:28 pm
Forum: Technology & How-To Forum
Topic: Quickly convert units in Excel – like Kg to pounds
Replies: 0
Views: 4813

Quickly convert units in Excel – like Kg to pounds

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...
by Admin
Mon Jan 23, 2017 7:09 pm
Forum: Technology & How-To Forum
Topic: Save list of files as csv or txt from MS dos command line
Replies: 0
Views: 4576

Save list of files as csv or txt from MS dos command line

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...
by Admin
Sun Jan 22, 2017 4:03 pm
Forum: Technology & How-To Forum
Topic: How AutoSum Shortcut works in Excel?
Replies: 0
Views: 4808

How AutoSum Shortcut works in Excel?

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...
by Admin
Sat Jan 21, 2017 4:32 pm
Forum: Technology & How-To Forum
Topic: How to easily calculate age in excel?
Replies: 0
Views: 4693

How to easily calculate age in excel?

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...
by Admin
Thu Jan 19, 2017 2:59 pm
Forum: Technology & How-To Forum
Topic: How to take screenshots with mouse cursor?
Replies: 1
Views: 5837

How to take screenshots with mouse cursor?

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...
by Admin
Wed Jan 18, 2017 9:16 pm
Forum: Technology & How-To Forum
Topic: Insert multiple rows/columns in Excel
Replies: 0
Views: 4501

Insert multiple rows/columns in Excel

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 Admin
Wed Jan 18, 2017 11:51 am
Forum: Technology & How-To Forum
Topic: How to lock only specific cells in Excel?
Replies: 0
Views: 4563

How to lock only specific cells in Excel?

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...
by Admin
Tue Jan 17, 2017 3:28 pm
Forum: Technology & How-To Forum
Topic: How to calculate weighted average in Excel?
Replies: 0
Views: 4554

How to calculate weighted average in Excel?

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...
by Admin
Mon Jan 16, 2017 11:25 pm
Forum: Technology & How-To Forum
Topic: Excel's Text to Columns: Name List as Example
Replies: 0
Views: 4495

Excel's Text to Columns: Name List as Example

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...
by Admin
Mon Jan 16, 2017 4:59 pm
Forum: Technology & How-To Forum
Topic: Text to Columns in Excel: Split Email addresses
Replies: 1
Views: 3307

Text to Columns in Excel: Split Email addresses

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...
by Admin
Sun Jan 15, 2017 5:20 pm
Forum: Technology & How-To Forum
Topic: Simple & Easy: Descriptive Statistics in Excel
Replies: 0
Views: 5443

Simple & Easy: Descriptive Statistics in Excel

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...
by Admin
Sat Jan 14, 2017 4:43 pm
Forum: Technology & How-To Forum
Topic: Copy Column Widths & Contents to Another Sheet in Excel
Replies: 0
Views: 4360

Copy Column Widths & Contents to Another Sheet in Excel

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...
by Admin
Fri Jan 13, 2017 5:46 pm
Forum: Technology & How-To Forum
Topic: Calculate percentage of change between two values in Excel
Replies: 0
Views: 4428

Calculate percentage of change between two values in Excel

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...
by Admin
Fri Jan 13, 2017 12:28 am
Forum: Technology & How-To Forum
Topic: Prevent duplicate data entry into your excel table
Replies: 1
Views: 3192

Prevent duplicate data entry into your excel table

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