Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 235 matches
Forum Index
Author Message
  Topic: How to calculate weighted average in Excel?
Admin

Replies: 0
Views: 3

PostForum: Technology & How-To Forum   Posted: Tue Jan 17, 2017 3:28 pm   Subject: 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 mo ...
  Topic: Excel's Text to Columns: Name List as Example
Admin

Replies: 0
Views: 4

PostForum: Technology & How-To Forum   Posted: Mon Jan 16, 2017 11:25 pm   Subject: 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 + ...
  Topic: Text to Columns in Excel: Split Email addresses
Admin

Replies: 0
Views: 4

PostForum: Technology & How-To Forum   Posted: Mon Jan 16, 2017 4:59 pm   Subject: 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 + ...
  Topic: Simple & Easy: Descriptive Statistics in Excel
Admin

Replies: 0
Views: 3

PostForum: Technology & How-To Forum   Posted: Sun Jan 15, 2017 5:20 pm   Subject: 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 ...
  Topic: Copy Column Widths & Contents to Another Sheet in Excel
Admin

Replies: 0
Views: 8

PostForum: Technology & How-To Forum   Posted: Sat Jan 14, 2017 4:43 pm   Subject: 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, an ...
  Topic: Calculate percentage of change between two values in Excel
Admin

Replies: 0
Views: 9

PostForum: Technology & How-To Forum   Posted: Fri Jan 13, 2017 5:46 pm   Subject: 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 pre ...
  Topic: Prevent duplicate data entry into your excel table
Admin

Replies: 0
Views: 10

PostForum: Technology & How-To Forum   Posted: Fri Jan 13, 2017 12:28 am   Subject: 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 ...
  Topic: Very easy: Compare Two Lists in Excel
Admin

Replies: 0
Views: 12

PostForum: Technology & How-To Forum   Posted: Tue Jan 10, 2017 2:01 pm   Subject: 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. ...
  Topic: How to hide Gridlines in Excel
Admin

Replies: 0
Views: 14

PostForum: Technology & How-To Forum   Posted: Sun Jan 08, 2017 5:11 pm   Subject: 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 ...
  Topic: How to calculate days between two dates in Excel
Admin

Replies: 0
Views: 11

PostForum: Technology & How-To Forum   Posted: Sat Jan 07, 2017 4:20 pm   Subject: 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 h ...
  Topic: How to use 'IF function' in Excel
Admin

Replies: 0
Views: 31

PostForum: Technology & How-To Forum   Posted: Sun Dec 25, 2016 9:41 pm   Subject: How to use 'IF function' in Excel
What is IF function in Excel?

IF function

- is a logical function

- that checks the condition you put and returns you one value if the condition is TRUE, else the other value if the conditio ...
  Topic: Cumulative Sum and Cumulative Graph in Excel
Admin

Replies: 0
Views: 34

PostForum: Technology & How-To Forum   Posted: Sat Dec 24, 2016 1:12 pm   Subject: Cumulative Sum and Cumulative Graph in Excel
First let us know what is a cumulative sum?

A cumulative sum is the summation of numbers in a given sequence.

For example, the cumulative sum of the sequence {1,2,3,4,5....} is 1, 3 (1+2), 6 ( ...
  Topic: Combine texts from multiple cells into one cell in Excel
Admin

Replies: 0
Views: 44

PostForum: Technology & How-To Forum   Posted: Sun Dec 18, 2016 9:10 pm   Subject: Combine texts from multiple cells into one cell in Excel
In Excel You can easily combine texts from two or more cells into one cell using the ampersand (&) operator.

See the following example:


http://shamskm.com/forum/exceltutor/combining_texts_ ...
  Topic: Working with fractions and mixed numbers in Excel
Admin

Replies: 0
Views: 49

PostForum: Technology & How-To Forum   Posted: Fri Dec 16, 2016 7:19 pm   Subject: Working with fractions and mixed numbers in Excel
It's just little bit tricky to enter fractions and mixed numbers in Excel. Just that. Let's make it easy.


Fractions

When you enter any fraction like 5/6 or 7/8 in your cell, Excel interprets t ...
  Topic: 'Standard deviation' and 'mean absolute deviation' in Excel
Admin

Replies: 0
Views: 50

PostForum: Technology & How-To Forum   Posted: Wed Dec 14, 2016 11:58 pm   Subject: 'Standard deviation' and 'mean absolute deviation' in Excel
In Excel you can calculate 'standard deviation' and 'mean absolute deviation' of your data points or samples, so to say, with STDEVA function and AVEDEV function.

But before we proceed, let's make ...
 
Page 1 of 16 Goto page 1, 2, 3 ... 14, 15, 16  Next
All times are GMT + 2 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group