Search found 314 matches

by Admin
Sun Jan 22, 2017 4:03 pm
Forum: Technology & How-To Forum
Topic: How AutoSum Shortcut works in Excel?
Replies: 0
Views: 11562

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 Toolbar ht...
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: 11129

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: 12857

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: 10925

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: 11244

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: 1
Views: 11132

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: 11176

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: 10477

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: 12324

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: 10948

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: 11143

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: 2
Views: 11200

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...
by Admin
Tue Jan 10, 2017 2:01 pm
Forum: Technology & How-To Forum
Topic: Very easy: Compare Two Lists in Excel
Replies: 0
Views: 11198

Very easy: Compare Two Lists in Excel

This tutorial will show you how to compare two lists using Excel's conditional formatting. Suppose you have two lists of top European football clubs - one you prepared, the other one your friend. You will check if both the lists contain all the top clubs. (Remember, it's just an example – your favor...
by Admin
Sun Jan 08, 2017 5:11 pm
Forum: Technology & How-To Forum
Topic: How to hide Gridlines in Excel
Replies: 0
Views: 11169

How to hide Gridlines in Excel

Sometimes may be for presentation purposes you may need to hide the gridlines on your excel sheet. Usually you do it from the View tab > in the Show/Hide group > uncheck the Gridlines option. In the older versions like Excel 2003 or earlier: Go to Tools > Options > here under View tab > uncheck the ...
by Admin
Sat Jan 07, 2017 4:20 pm
Forum: Technology & How-To Forum
Topic: How to calculate days between two dates in Excel
Replies: 0
Views: 11900

How to calculate days between two dates in Excel

So let's start: To calculate number of days between two given dates, you simply subtract the End Date from the Start Date. However, cell formatting is important here. In the table below, I have changed the cells format for Cloumn A, B and E. These three columns have date as cell format. How do you m...