Microsoft Excel: Learning Tutorial

Author Topic: Microsoft Excel: Learning Tutorial  (Read 25769 times)

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Microsoft Excel: Learning Tutorial
« on: November 01, 2010, 06:25:25 PM »
Part-1

Introduction:
Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Excel forms part of Microsoft Office. The current versions are 2010 for Windows and 2011 for Mac.

The number of row of Microsoft Excel is 65,536 and the number of column is 256.

MS Excel : Microsoft Excel Is a Great Software for our Life. Personal Accounting, Financial Accounting, Official works, Variety of Calculation can be easily done by MS Excel.
Click for download
Source:http://forum.daffodilvarsity.edu.bd/index.php/topic,2691.0.html

I have copied the source file from Mr. Rubel sir. Mr. Rubel sir has described about Ms Excel very nicely and his attached file is really very informative. So, you can know from the attached file the basic operation of Excel.

However, I will share with you the different functions of excel.


« Last Edit: November 03, 2010, 11:27:49 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-2
« Reply #1 on: November 01, 2010, 06:56:44 PM »


All of these are the input value.




(the above function as you can see some "." (dot), when you type the formula,  Please ignore the dot. Otherwise it will not work.

A6, B6, C6, D6, E6, F6, G6, H6 are the output value.  

I try to find out the sum in the A, B, C, D and E no column.

Ex: First of all, type the input value like image shown after that put the mouse cursor on the A6 no cell and type the formula like =SUM(A3:A5). You will get the desire value.

N.B: The formula of Sum1 and Sum2 are the same. Both are working. However, always try to use first one. Because it saves your time and more flexible.

As you can see, I try to find our Column no F is average like (4+3+2)/3=3. type the following formula on the cell no F6.
=AVERAGE(F3:F5)

MIN means minimum. Using this formula will find out the minimum value.Such as 3, 6, 4, Here the minimum input value is 3.

MAX means Maximum value. Using this formula will find out the Maximum value. Such as 9, 5, 6, Here the maximum input value is 9
« Last Edit: July 13, 2011, 07:50:07 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-3
« Reply #2 on: November 02, 2010, 05:18:15 PM »



If you want, you can download soft copy.

Click Here
« Last Edit: July 13, 2011, 07:51:40 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-4
« Reply #3 on: November 03, 2010, 11:27:01 AM »


N.B: Avoid dot(.) and use the formula. In any cell you can use these formula.

Total-1   =sum(c4:e4)   
      
Total-2   =sum(c4:c15)   
      
Total           =sum(f4:f15)   
      
Average   =sum(c4:c15)/12   
      
.% of Total    =c16/f16*100   

At first input data like the image file. After that write these formula any of the cell in the spreadsheet.


For your convenience, you can download the soft copy of this post.

Click for download soft copy


Thank you
« Last Edit: July 13, 2011, 07:53:31 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-5
« Reply #4 on: November 04, 2010, 06:23:11 PM »



Solution:



Find out the 10% of Sales of each employees after that add to Basic salary with it.
Formula is = b7+c7*10%




You can download the soft copy from the following link
Click here for dowonload
« Last Edit: July 13, 2011, 07:55:51 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-6
« Reply #5 on: November 14, 2010, 12:58:03 AM »
How to calculate discount and interest rate?





Soft copy Click here

« Last Edit: July 13, 2011, 07:56:55 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-7
« Reply #6 on: November 14, 2010, 11:43:09 AM »


For soft copy Click here:    


Do you face any problem, just inform me.

« Last Edit: July 13, 2011, 07:58:08 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline arif_theviper

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #7 on: November 14, 2010, 02:08:22 PM »
I am regular viewer of this post. Thank you Mr. Ashiq. Keep it up.
Arif Hossain
ID-103-11-1635
Daffodil International University

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #8 on: November 14, 2010, 02:40:04 PM »
Nice to know about it. Anyway, My next comment on Grade sheet, Result sheet, Best quiz count. I am working for preparing it.

thank you.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #9 on: November 14, 2010, 02:43:34 PM »
Dear viewer of my this post. In each part, first of all I mention the cell no with the headline after I mention formula. Every formula starts from "=" sign.

Thank you
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-8
« Reply #10 on: November 15, 2010, 12:39:27 AM »
« Last Edit: July 13, 2011, 08:04:04 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-9
« Reply #11 on: November 15, 2010, 01:00:01 AM »
« Last Edit: July 13, 2011, 08:02:55 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline faham

  • Full Member
  • ***
  • Posts: 111
  • I'm different.... ;)
    • View Profile
    • FahamBD
Re: Microsoft Excel: Learning Tutorial
« Reply #12 on: November 15, 2010, 09:54:26 AM »
Good job Mr.Ashiq, keep it up.
Faham Kabir
MBA (112), HRM & MIS
BBA (073), HRM
Daffodil International University,
.....................
Asst. Manager (HRD & MIS)
New Horizons CLC of Dhaka
http://fb.com/fahamkabir

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-10
« Reply #13 on: November 20, 2010, 12:15:51 AM »
« Last Edit: July 13, 2011, 08:01:55 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #14 on: November 20, 2010, 12:18:01 AM »
Thank you Faham bhai.

Dear Viewers,
If you have any query, you can ask me.

Thank you.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806