Search found 314 matches
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...