Super Easy Short Computer Notes To Improve Computer Literacy and Your IT Skills

Sponsored Links

Sunday, December 14, 2014

How To Unsubscribe Utunes Service of Ufone

Leave a Comment
Today, We will discuss the simple and easy way to unsubscribe the Utunes Service of Ufone. Remember, Utunes service will cost you at the rate of  Rs. 1.55 daily.
Simple Steps to Deactivate and UnSubscribe Utunes Service

I was using the mobile phone of my son when I saw an SMS message from Ufone Hisaab SMS. The message was in Urdu language and it was informing the cost of Utunes Service Rs. 1.55 per day. The message of Hisaab SMS is shown in the following figure:
Step by Step Procedure for Deactivation of Utunes

 What is Utunes Sevice

 With Ufone UTunes service your friends and family can listen to your favorite tunes every time they call you. You can select a UTune from the content library.
Hisaab Do Ufone Service To Reaveal Utunes Money Deduction
I think Utunes is one of the most useless services of Ufone that is costly too. So I tried to find the solution for deactivation of Utunes service instantly.

How To Unsubscribe / Deactivate Utunes Service

Send UNSUB Message To 666 To Deactivate Utunes
  • Type a new message "UNSUB" and send it to the number 666.
  •  You will recieve a message from Ufone 666 as shown in the following figure, if you are lucky enough.
  •  Otherwise you can call the Ufone help line 333 and ask the person to unsubscribe the Utune service from your number. Normally the person on 333 Ufone Help Desk will ask you that he/she is sending the procedure to unsubscribe / deactivate the Utunes Service. But you must insist so that deactivates the Utune service himself
Utune Service Unsubscribed Deactivated Successful Way





Read More...

Sunday, November 30, 2014

How Functions are Used in Excel Fast and Easy Way 3

Leave a Comment

What is a Function in Microsoft Excel?

Microsoft Excel provides a large number of Functions for processing data in Excel Worksheets easily. Functions are predefined formulas in Excel. These functions are used in different types of calculations on numerical or other data  quickly.

How a Function is Used in Microsoft Excel?

There are three popular ways to use built-in functions in Microsoft Excel.

1. Type Functions Manually
2. Use Function Library Commands
3. Use Insert Function Dialogue Box

1. Type Functions Manually

You can type a function manually in the required cell. First of all press Equal key from keyboard. Then start typing function name, for example, type SUM. A formula autocomplete list box will be displayed. Press TAB key when SUM is selected in the autocomplete formula list box. Type cell reference of first cell, suppose A1, type a colon ( : ). Type the cell reference of the last cell, suppose A4 as shown in the figure. Press Enter. You will see the result 100 in this cell.
How Functions are used in Microsoft Excel Quick and Easy Way 3


A function is used by its name and providing some arguments to the function. The arguments are the necessary data values for calculation. Moreover, there is an EQUAL sign before every function name.
How to type a function manually

General Syntax of a Function in Microsoft Excel


=FunctionName(Argument1, Argument2,...)
Arguments can be numbers in mathematical functions or cell references etc. If the cell references are used the syntax becomes
=FunctionName(CellRef1:CellRef2)
where CellRef1 represents the cell reference of the first cell in the range and CellRef2 represents the cell reference of the last cell in the range. For example in the given figure,
=SUM(A1:A4)

2. Use Function Library Commands


Another way to insert a function in a cell is to use the icons in the Formulas each of which is a drop-down control.

How to use a function through FUNCTION LIBRARY COMMANDS in Excel
When you select a function from one of these lists, Excel displays its Function Arguments dialog box to help you enter arguments. The rest of the procedure is the same as in first method.



3. Use Insert Function Dialogue Box


HOw to Use Insert Function Dialog Box in Microsoft Excel
Using the Insert Function dialog box ensures that you spell the function correctly and that it contains the proper number of arguments in the correct order. Select a suitable category of the function, for example, if you want to use SUM function then it will be found in Math & Trig category of functions. Search and select the function SUM and click on OK button. Now Function arguments dialog box will open, type suitable arguments.

To insert a function, select the function from the Insert Function dialog box, as shown in Figure

You access this dialog box by

  • Choosing Formulas, Function Library,Insert Function
  • Choosing Formulas,Function Library, AutoSum, and then clicking More Functions in the

drop-down list

       In Function Arguments dialog box, you can enter the cell reference of first cell and a colon ( : ) and the cell reference of the last cell to add all the numbers in the cells between these two cells including, as shown in the figure. After giving argument values click on Ok button and the result 100 will be shown in the required cell.
Read More...

Thursday, November 27, 2014

Using Simple Formulas in Excel With Arithmetic Operators-2

1 comment

What are Arithmetic Operators in Excel?


Arithmetic Operators are used to perform arithmetic operations like addition, subtraction, multiplication and division etc. There are following arithmetic operators in Microsoft Excel:

1.  + Operator


The + arithmetic operator is used to perform addition of numbers. It is used with in formulas along with Cell References normally. For example, to add the number 10 in A1 cell and the number 20 in B1 cell, we can write a formula =A1+B1 in cell C1. After pressing Enter key we will see the answer 30 in the cell C1.

Important Points To Write a Simple Formula in Excel


  1. Every formula in Microsoft Excel is started with an Equal sign ( = ).
  2. Arithmetic operators (+ for addition, - for subtraction, * for multiplication, / for division) are used.
  3. Percentage is calculated by % operator. ( =B2*10%       means 10% of the number in cell B2)
  4. Power function is performed by ^ operator. (3^2 will give 9) 

Use of addition arithmetic operator in Excel


2.  - Operator


The - arithmetic operator is used to perform subtraction of numbers. It is used with in formulas along with Cell References normally. For example, to subtract the number 100 in B1 cell from the number 50 in A1 cell, we can write a formula =B1-A1 in cell C1. After pressing Enter key we will see the answer 50 in the cell C1.
Use of subtraction arithmetic operator in Excel


3.  * Operator


The * arithmetic operator is used to perform multiplication of numbers. It is used with in formulas along with Cell References normally.

Use of multiplication arithmetic operator in Excel
For example, to multiply the number 10 in A1 cell with the number 20 in B1 cell, we can write a formula =A1*B1 in cell C1. After pressing Enter key we will see the answer 200 in the cell C1.


4.  / Operator


The / arithmetic operator is used to perform division of numbers and gives quotient of the division. It is used with in formulas along with Cell References normally.

Use of division arithmetic operator in Excel
 For example, to divide the number 10 in A1 cell by the number 5 in B1 cell, we can write a formula =A1/B1 in cell C1. After pressing Enter key we will see the answer 2 in the cell C1.


5. % Operator


The % arithmetic operator is used to calculate percentage. It is used with in formulas along with Cell References normally.

Use of Percentage arithmetic operator in Excel

For example, to calculate the 10 % of the number 1000 in A1 cell, we can write a formula =A1*10% in cell B1. We will read the formula =A1*10% as "10% of A1" means 10% of the number in cell A1. After pressing Enter key we will see the answer 100 in the cell B1.




6.  ^ Operator  (Exponent operator or Power operator)


The ^ arithmetic operator is used to calculate a number n raised to the power p. For example 2^3 is equal to 8 ( 2 raised to the power 3).
 Use of exponent - Power arithmetic operator in Excel
It is used with in formulas along with Cell References normally. For example, to calculate 2 raised to the power 3, type 2 in Cell A1 and 3 in cell B1. Now we can write a formula =A1^B1 in cell C1. After pressing Enter key we will see the answer 8 in the cell C1.


Order of Precedence of Arithmetic Operators in Excel


Order of precedence means the order in which operations will be performed when evaluating an expression in Microsoft Excel.

1. First of all the operation in parentheses ( ) is performed if any. If nested parentheses exist in expression, then the inner most parentheses will be evaluated first.
2. Secondly, Exponents will be evaluated if any.
3. In third step, multiplications and divisions will be calculated from left to right order.
4. In fourth step, additions and subtractions will be performed in Left to Right order.

Example: Evaluate the following expression according to the order of precedence in Excel
               =A1*B1-C1*(20+3)
Order of precedence of Arithmetic Operators in Microsoft Excel

Solution:  Let A1=10,   B1=5,    C1=2
             
               Step 1. First of all parentheses (20+3) is evaluated to 23
                             Now expression becomes  =A1*B1-C1*23
              Step 2. Now there is no exponents, so we check multiplication and division. There are
                          two multiplication operators. Since A1*B1 is on left so we evaluate it by putting values
                          10*5 the answer is 50. Therefore expression is reduced to =50-C1*23
              Step 3. Now we will evaluate multiplication C1*23. Putting values 2*23 and the answer is
                          46. So the expression becomes  50-46.
              Step 4. Now we will evaluate the last operation of subtraction 50-46 which gives the answer 4.
   
                                 

Read More...

Monday, November 24, 2014

Microsoft Excel Formulas and Functions Fast and Easy Way -1

2 comments

Introduction


Using Formulas and Functions in Microsoft Excel is really a tough job for new students. This is a series of tutorials to make the use of Formulas and Functions in worksheets, easy with various real life example worksheets.
مائیکروسافٹ ایکسل میں فارمولوں اور فنکشنزکا استعمال نئے طلبا کے لیے ہمیشہ سے ایک مسئلہ رہا ہے۔ میری کوشش ہے کہ فارمولا اور فنکشن کا ٹاپک پریکٹیکلی اور پکچرز کے ساتھ تفصیل سے بیان کروں۔

Let,s start.

By: Mahmood Alam,
      Instructor IT,
      Government Post Graduate College of Commerce,
      Rahim Yar Khan.


What is Microsoft Excel?


Microsoft Excel is a popular application software used to manage data in the form of rows and columns and using Excel formulas and built-in Excel functions to perform various calculations on these data. Microsoft Excel is a part of Microsoft Office. We can make different types of worksheets in Excel, for example:
  1. Employee Pay Sheet
  2. Student Test Score Result Sheet with Grades Calculation
  3. Simple Electricity Bill Calculation Formula

What is an Excel Formula?


Excel Formula is a proper combination of operators (like +, -, /, *) and operands. A formula is used to perform different types of calculations and gives result. For example a formula to add numbers in cells A1 and A2 will be typed as =A1+A2.
Note: +, -, / and * are called arithmetic operators in Excel to calculate addition, subtraction, division and multiplication respectively.
Note: A1 and A2 are the Cell References of two cells situated in worksheet. A1 represents the cell in Row number 1 of Column A Whereas A2 represents the cell in Row number 2 of Column A.
Understanding Cell References in Excel

 What is a Cell Reference?


A Cell Reference is a special Reference Number made by combining Column name and Row Number. Actually a Cell Reference is used to access contents of a cell within a formula. For example, "A1" is an example of Cell Reference. "A" is taken from column name and "1" is taken from Row number. Therefore the intersection cell of column A and Row number 1 is called "A1". Look at the above picture to understand the concept of Cell Reference and how it is made.

How To Use a Cell Reference in a Formula?

Start Microsoft Excel with a new blank workbook. Type 100 in cell A1 and 200 in Cell B1. Now you want to add the two numbers typed in the cell A1 and B1 respectively.

How to enter Excel Formula for Adding two numbers by cell references
You must enter a formula using Cell References of both these cells. Every formula in Excel can be started with an equal sign  =. Now type "=" then type cell reference A1. Type + operator ( by pressing Shift and equal to key together ). Now type cell reference B1. Press Enter key. The result of addition will be displayed in cell C1 which is 300.
Result of addition formula using cell references


Read More...

Friday, November 21, 2014

Advantages and Disadvantages of LAN Local Area Network

Leave a Comment

LAN - Local Area Network


LAN stands for Local Area Network. It normally connects the computers and other devices within one office, building or a group of nearby buildings.
Advantages Disadvantages of LAN - Local Area Network

Advantages of LAN or Local Area Network

1. Resource Sharing

Computer resources like printers, modems, DVD-Rom drives and hard disks can be shared with the help of local area networks. This will reduce cost of hardware purchases.

2. Software Applications Sharing

It is cheaper to use same software over network instead of purchasing separate licensed software for each client in a network.

3. Easy and Cheap Communication

Data and messages can easily be transferred over networked computers.

4. Centralized Data

The data of all network users can be saved on hard disk of the server computer. This will help users to use any workstation in a network to access their data. Because data is not stored on workstations locally.

5. Data Security

Since, data is stored on server computer centrally, it will be easy to manage data at only one place and the data will be more secure too.

6. Internet Sharing

Local Area Network provides the facility to share a single internet connection among all the LAN users. In Net Cafes, single internet connection sharing system keeps the internet expenses cheaper.

Disadvantages of LAN or Local Area Network

1. High Setup Cost

Although the LAN will save cost over time due to shared computer resources but the initial setup costs of installing Local Area Networks is high.

2. Privacy Violations

 The LAN administrator has the rights to check personal data files of each and every LAN user. Moreover he can check the internet history and computer use history of the LAN users.

3. Data Security Threat

Unauthorized users can access important data of an organization if centralized data repository is not secured properly by the LAN administrator.

4. LAN Maintenance Job

Local Area Network requires a LAN Administrator. Because, there are problems of software installations or hardware failures or cable disturbances in Local Area Network. A LAN Administrator is needed at this full time job.

5. Covers Limited Area


Local Area Network covers a small area like one office, one building or a group of nearby buildings.




Read More...

Sunday, July 6, 2014

Create Bar Chart in Excel Easily by Example

Leave a Comment
Today, we will discuss How to Create Bar Chart in Excel Easily by Example. A chart is the graphical representation of data. Microsoft Excel provide an easy to use Chart Wizard for this purpose. The Microsoft Excel Chart Wizard guides you on each step to perform the specific tasks and get a brilliant Chart finally.

NOTE: You can chose a chart Type as BAR chart which is on number two in chart type list. For this example, here pictures are provided for the default chart type, the first one, named COLUMN CHART.


Create Bar Chart in Excel Easily by Example

Steps to Create Bar Chart in Excel Easily by Example

NOTE: You can chose a chart Type as BAR chart which is on number two in chart type list. For this example, here pictures are provided for the default chart type, the first one, named COLUMN CHART.  as shown in the following picture.

Create Bar Chart in Excel Easily by Example Step 1

 

  1. Create Worksheet and enter data to Create Bar Chart in Excel Easily by Example.
  2. Select the columns data. If the two columns are adjacent, Select the both columns along with column headings with the help of mouse. If the two columns are not adjacent, select first column by mouse dragging. Now press and hold CTRL button from keyboard and select the other column by mouse.
  3. Start the Chart Wizard by clicking on Chart Wizard Tool.
  4. Select the type of chart as BAR chart and select the subtype also. Click Next button.
  5. There is nothing to do in this step as you have already selected data for chart in step 2. You can change data here if necessary. Click NEXT
  6. In this step enter the name of the chart and titles for the X- and Y-axes. you can also set some other options for the axes, grid lines, legend, and data labels etc. Click NEXT.
  7. In this final step select the location to insert chart. Click As new sheet if you wish to insert chart in a new blank sheet. Select As object in if the chart should be included in the existing sheet.

Create Bar Chart in Excel Easily by Example Step 2

Create Bar Chart in Excel Easily by Example Step 2

Create Bar Chart in Excel Easily by Example Step 3 

Create Bar Chart in Excel Easily by Example Step 3

 Create Bar Chart in Excel Easily by Example Step 4 

 
Create Bar Chart in Excel Easily by Example Step 4

 Final Image for Create Bar Chart in Excel Easily by Example 

Create Bar Chart in Excel Easily by Example Step by Step

 A BAR CHART will look like this

Picture of a Bar Chart in Excel
A Bar Chart in Excel

 This Excel Tutorial is based on Microsoft Office 2000 - 2003.

 Create Bar Chart in Excel Easily By Example Office 2007

 In Microsoft Excel 2007,
  1.  Type and select the data.
  2. Click on INSERT tab.
  3. In chart group, click on the required chart type. suppose you click on Bar type then a list of subtype options is displayed, select one of it.
  4. The selected chart will be inserted. 
  5. You can edit this chart for any modifications.

Download original Worksheet to create Bar Chart in Excel Easily By Example Office 2007


Create Bar Chart in Excel Easily By Example Office 2007
Read More...

Students Test Score Grades Result Sheet in Excel

Leave a Comment
Today, we will discuss How to create an Students Test Score Grades Result Sheet in Excel using Formulas / Functions ( IF Function ). The following formulas will be used in Students Test Score Grades Result Sheet: Q: Prepare the following Students Test Score Grades worksheet in MS Excel. Apply suitable formula and functions: Test Score >=90 A grade, 80-89 B grade, 70-79 C grade, 60-69 D grade, below 60 F grade, as shown in the following table:
Roll No. Test Scores Grade
1 90 A
2 80 B
3 75 C
4 60 D
5 50 F
  1. Create a worksheet in MS Excel according to the requirements as shown above
  2. Enter sample data of Roll No. and Test Score Columns as shown in above table.
  3. Apply formula to calculate Grade on the basis of test scores obtained by the student.

Grade Formula in Students Test Score Grades Result Sheet

Grade Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))

Image for Students Test Score Grades Result Sheet in Excel

Students Test Score Grades Result Sheet in Excel


Solution:
  1. Create a new workbook in MS Excel and save as with the name Students Test Score Grades Result Sheet in Excel
  2. Enter sample data for one to five Roll Numbers of students as shown in above table.
  3. Enter formula for Grade in the cell C3 Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))and press Enter.
So, the worksheet with Electricity Bill Calculator Formulas Worksheet in Excel has been prepared successfully.

Download the Original Workbook File Prepared For Students Test Score Grades Result Sheet in Excel

Click to Download Excel Workbook For Students Test Score Grades Result Sheet Students Test Score Grades Result Sheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training Course. There are very simple formulas used to calculate Grade using the IF logical function. Although, an established institute may use a customized software for preparing Result Sheets, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Students Test Score Grades Result Sheet Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.  
Read More...

Saturday, July 5, 2014

Microsoft Office Word Processing Practicals

Leave a Comment
Today we will discuss some important basic Microsoft Office Word Processing Practicals. These practicals are essential part of Learning Microsoft Word for basic documentation preparation process. I have given the solutions according to some old versions of Microsoft Office 2000, 2003 etc. Soon, I will provide the practical procedures to perform these tasks in newer versions of Microsoft Office starting from MS Office 2005, 2007 and above.

MS OFFICE 2000, 2003 Old is Gold 


Microsoft Office Word Processing Practicals

Open Microsoft Word

Start -> Programs -> Microsoft Word
To Create a New File
File -> New or Press CTRL+N

To Save a File:

File -> Save or Save As -> Type file name -> Select file location -> click on Save

To Save a File with Password

File -> Save As  -> Click on Tools -> General Options -> Type password in Password to open box.
-> Ok -> Retype password / confirm password -> ok -> save

To Save Document in a Folder on Desktop


File -> Save As -> Select Desktop -> Click on New Folder button on dialogue box ->
Type folder name -> Type filename -> Save

Some More Useful Features for Microsoft Office Word Processing Practicals

How to set Paragraph Line Spacing


Type Paragraph. -> Select paragraph
-> Press
CTRL+1   For single line spacing
CTRL+2     For double line spacing
CTRL+5   For 1.5 line spacing

Text Effects


Select text -> Format menu -> Text Effects Tab -> select a text effect -> ok

Change Case


Select text -> Format -> change case -> select option -> ok (short cut CTRL+F3)

Borders and Shading


Select paragraph -> Format menu -> Borders and shading -> borders tab
-> Select a border setting, style, color and width -> ok

Shading


Select paragraph -> Format menu -> Borders and shading -> shading tab
-> Select a color from fill section -> ok

Microsoft Office Word Processing Practicals: Applying Graphical Page Borders

Page Borders


Format menu -> Borders and shading -> Page Border tab
-> Select a border from Art list box -> set other options -> ok

DROP CAPS

Image for Drop Caps Microsoft Office Word Processing Practicals
Set Drop Cap Options in Microsoft Office Word Processing Practicals
Place the cursor in paragraph -> Format menu -> Drop Caps -> select different options -> ok

Header and Footer

Picture for Header and Footer 
Header Footer Options in Microsoft Office Word Processing Practicals

View Menu -> Header and Footer -> Type text in header or use Insert Auto text option to
enter different options like Page X of Y    ---  Page 1 of 10 --- etc
-> click on Switch between header and footer button -> type text in footer or insert page number
etc. -> Close

Insert Page Number


Insert Menu -> Page Number -> set different options -> ok

Microsoft Office Word Processing Practicals: Inserting Word Art and Clip Arts

Word Art


Insert menu -> Picture -> Word Art -> set different options -> ok

Clip Arts

Microsoft Office Word Processing Practicals: Inserting Clip Arts

Insert Menu -> Picture -> Clip Arts -> select category and picture

TABLES

Inserting Tables in a Document: Microsoft Office Word Processing Practicals

Table menu -> Insert -> table -> select number of rows and columns
-> ok

TYPE Text E = mc2(Superscript and Subscript by Shortcut Key)


type the text E = mc2   -> select 2 -> press[ CTRL + Shift + = ]for super script text
similarly Press CTRL + = for subsript text

Bullets and Numbering


Select text -> Format menu -> bullets and numbering -> select bulleted or numbering tab ->
select bullets and number style

COLUMNS

Using Columns in Document: Microsoft Office Word Processing Practicals

Format menu -> columns -> select number of columns -> or select preset options
 -> ok

Soon, I will provide the same procedures to perform Microsoft Office Word Processing Practicals
in latest versions of MS Office.

Download Worksheet and Procedure to Create an Employee Pay sheet Worksheet in Microsoft Excel

 
Read More...

Thursday, July 3, 2014

Electricity Bill Calculator Formulas in Excel

2 comments
Today, we will discuss How to create an Electricity Bill Calculator Worksheet by using Electricity Bill Calculator Formulas in Excel. The following formulas will be used in Electricity Bill Calculator Worksheet: Q: Prepare a worksheet according to the following instructions:
  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of Electricity units consumed by customers in a city
  3. Apply formula to calculate Units Consumed
  4. Apply formula to calculate Electricity Charges
  5. Apply formula to calculate Surcharge
  6. Apply formula to calculate Bill Payable
Units Consumed Formula=D5-C5
Electricity Charges Formula=IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10))
SURCHARGE FORMULA = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0))
BILL PAYABLE FORMULA = SUM(F5:G5)

Image for Electricity Bill Calculator Formulas in Excel Software



Solution:
  1. Create a new workbook in MS Excel and save as with the name Electricity Bill Calculator Formulas in Excel
  2. Enter sample data for at least three customers
  3. Enter formula for Units Consumed= D5 - C5 in cell with cell reference E5.
  4. Enter formula for Electricity Charges =IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10)) in cell with cell reference F5.
  5. Enter formula for Surcharge = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) in cell with cell reference G5.
  6. Enter formula for Bill Payable =SUM(F5:G5) in cell with cell reference H5.
So, the worksheet with Electricity Bill Calculator Formulas in Excel Worksheet has been prepared successfully.

Download the Original Workbook File Prepared For Electricity Bill Calculator Formulas in Excel

Click to Download Excel Workbook For Electricity Bill Calculator Formulas in Excel Worksheet
Electricity Bill Calculator Worksheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training. There are very simple formulas used to calculate monthly electricity bill of the customers living in a town. Although, the electric supply company may use a customized software for preparing electricity bills, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Electricity Bill Calculator Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.  
Read More...

Wednesday, July 2, 2014

Employee Pay sheet Formulas in Microsoft Excel

1 comment
Today, we will discuss How to create an Employee Worksheet by using Employee Pay sheet formulas in Microsoft Excel. The following formulas will be used in Employee Pay sheet: Q: Prepare a worksheet according to the following instructions:
  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of employees in a college
  3. Apply formula to calculate Medical Allowance @ 40 % of Basic Pay
  4. Apply formula to calculate Conveyance Allowance @ 30 % of Basic Pay
  5. Apply formula to calculate House Rent @ 50 % of Basic Pay
  6. Add a column of Income Tax @ 7 % of Basic Pay
  7. Apply formula to calculate Net Pay = Medical Allowance + Conveyance Allowance + House Rent - Income Tax

Image for Employee Pay sheet Formulas in Microsoft Excel Software

Employee pay sheet Formulas in MS Excel

 Solution:How to Create Employee Pay Sheet in Excel With Formulas

  1. Create a new workbook in MS Excel and save as with the name Employee Pay sheet Formulas.
  2. Enter sample data for at least three employees.
  3. Enter formula for Medical Allowance = D5 * 40% in cell with cell reference E5.
  4. Enter formula for Conveyance Allowance = D5 * 30% in cell with cell reference F5.
  5. Enter formula for House Rent = D5 * 50% in cell with cell reference G5.
  6. Enter formula for Income Tax = D5 * 5% in cell with cell reference H5.
  7. Enter formula for Net Pay = D5 + E5 + F5 + G5 - H5 in cell with cell reference I5.
So, the worksheet with Employee Pay sheet Formulas has been prepared successfully.

Download the Original Worksheet Prepared For Employee Pay Sheet Formulas

Click to Download Excel Workbook For Employee Pay sheet Formulas Employee Pay sheet is normally required and maintained in every small business organization. There are very simple formulas are used to calculate monthly pay of the employees working in a small business. There is no need to develop a software for this purpose in a small book shop. Because, Microsoft Excel can be very useful to prepare such employee pay sheet with formulas.

Employee Pay sheet Formulas in Microsoft Excel

Here is the
Picture of Complete MS Excel Worksheet on

Employee Pay sheet Formulas in Microsoft Excel

Employees Pay Sheet Formulas Complete MS Excel Worksheet

 

Read More...

Tuesday, June 10, 2014

Create Save Password Protect Workbook in Excel

1 comment
Today, we will discuss a basic MS Excel Tutorial with a lot of pictures on How to Create a New Work book, Save workbook and Apply Password Protection on workbook in MS Excel.

Here is a list of topics to discuss:

  • Create a new Excel Work Book
  • Save a Work book
  • Password Protect a work book

How to Create a New Microsoft Excel Workbook?


  1. Start Microsoft Excel. It will open with a new workbook already created.
  2. OR when Excel is open, click on Office button and click on New.
  3. OR Press Ctrl + N from keyboard

How to Save a MS EXCEL Workbook?


  1. Click on Office button and click on Save As option
  2. OR press CTRL + S
  3. Save As dialogue box will open
  4. Select the drive and folder location to save file
  5. Type work book name
  6. Click on Save button to save the workbook 



How to Apply Password Protection on Excel Workbook


  1. Repeat the above mentioned steps from 1 to 5 as in SAVE WORKBOOK method.
  2. Click on Tools button which is before SAVE button on Save As dialog box
  3. Click on General Options
  4. Type a password in Password to Open text box, press Enter
  5. Confirm password and click on Ok button
  6. Click on Save button.
  7. Now workbook is password protected.
  8. Next time, when you open this work book, it will ask a password before opening.

 


 
Read More...

Sponsored Links

.