Skip to main content

Microsoft Excel 2003 Tutorial

What is Microsoft Excel ?

Microsoft Excel is an application software developed by Microsoft. Excel is a spreadsheet package which is used for data automation. Excel is also used for creating graphs, which gives us a pictorial view of a company or an organisation. Excel features calculation, graphing tools, pivot tables etc. 


What is Workbook and Worksheet ?

A workbook is a multiple pages Excel document. Each page of a workbook is called a worksheet, and the active worksheet is displayed in the document window.

What is Column, Row and Cell ?

Each spreadsheet is divided into columns, rows and cells separated by gridlines.
  • Columns :: These are vertical cells which can contains information. The first column is A and letter A is appears in the column heading. Each worksheet has 256 columns.
  • Rows :: There are the horizontal cells which can contains information. Each worksheet has 65,536 rows.
  • Cells :: A cell is the intersection of a row and a column. Each cell has a unique address composed of the cell’s column and row.
How do you Open MS Excel ?

To open MS Excel follow the steps below :

Go to Start > All Programms / Programms > Microsoft Office > Microsoft Office 2003/2007/2010.

How do you create a new file ?

Open Microsoft Excel first > go to File > click on New  or  Press Ctrl + N on the keyboard

How do you setup your page ?

Go to File > click on Page setup > select the Orientation, paper size, click on margin to change the margin of the pages > click O.K


How do you Save your file ?

Go to File > click on Save As > or Press Ctrl + S on the keyboard > Type the file name > click on Save

How do you Open an existing Microsoft file ?

Go to File > click on Open  or Ctrl + O > go to the location of your existing file > select your file > click on Open

How do you make contents Bold / Italic / Underline ?


It is similar to Microsoft Word. Select contents  > Press B / I / U on the Formating Toolbar   or  Ctrl + B  / Ctrl + I / Ctrl + U


How do you change alignment ?

select the contents > click on the alignment buttons on the Formating Toolbar

How do Copy and Cut and Paste ?

Select cells / rows / columns / worksheet > Place the cursor where you want to paste
                      OR
  • Ctrl + C = Copy (for copy)
  • Ctrl + X = Cut (for cut)
  • Ctrl + V = Paste (for paste)
How do you insert Column / Row / Worksheet / Symbol ?

Place the cursor where you want to insert > go to Insert > select Rows / Column  / Worksheet / Symbol whatever you want to insert > then follow the steps as your requirements

How do you delete Rows / Columns / Worksheet ?

Select the rows / columns / worksheet > Press the delete button on key board
                 OR
Right click on selected rows / columns / worksheet > Select delete

Editing & Formatting Cells

Select the cell and double click on the cell to edit it. 
                                 Or
Select the cell > click on Format on the Menu bar > Do the needful > O.K


How do insert Border ?

Select the cell / rows / columns > Format  > cells / rows / columns > Click on Border > select Outline and Inside > O.K


How do you merge cells ?

To merge cells follow the steps below :

Select the cells > Format > Cells > Click on Alignment > Select check box of Merge Cells > O.K


How do you make Summations of cells ?

Click on a blank cell > type the formula   =sum( column and row number of first cell : column and row number of final cell) > press Enter

How do you make Subtraction ?

Click on a blank cell > type the formula   =column and row number of first cell -column and row number of final cell > press Enter


How do you make Multiplication ?

Click on a blank cell > type   =product(column and row number of first cell : column and row number of final cell) > press Enter


How do you make divide ?

Click on a blank cell > type    =column and row number of first cell / column  and row number of final cell > press Enter


Summation of multiple sheets

cleck on a blank cell on the final worksheet and type the formula given below :

=sum(sheet1:sheet5!column and row number of first cell of 1st worksheet : column  and row number of final cell of final worksheet) > Press Enter on keyboard

What is Goal Seek ?

Goal Seek is a procedure to find a specific result for a cell containing formula by adjusting the value of one other cell.

 Procedures

Tools > Goal Seek  > Set cell name (cell containing the total estimated cost)  >   write the “To Value” (i.e., target value)  >  mention the cell for which you want to change the expenditure  > OK  >  OK



Creating Chart / Graph

Select the data   >   Insert   >  Chart    >  Select Chart type   >  Next   >   Next   > Enter the Chart Title, Category (X) Axis and Value (Y) Axis   >   As object in or As new sheet   >   Finish






Autofilter/Sorting/Subtotal

Select the data   >   Data   >  Filter  >  Autofilter  >  Custom on any field   > OK
Select the data   >   Data   >  Sort  >  Select the field name at sort by box  > OK
Select the data   >  Sort the data on the field for which Sub-Total is needed>   Data   >  Subtotal  >  Select the field at each change in box  >  OK


What is Scenario ?

A scenarios is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. You can edit your scenario also.

Procedure

Select the data  >  go to Tools in the menu bar > click on Scenario  >  Add  >  Type Scenario name  >  OK  >  Cell range for changing data  >  OK  >  Enter the new value  >  OK  >  Scenario Manager dialog box opens click on Summary  >  Result Cells  >  OK

Edit Scenario

Tools  >  Scenarios  >  Click the name of the scenarios you want to edit, and then click Edit  >  Make the changes you want  >  In the Scenarios Values dialog box, type the values you want for the changing cells  >  To save the changes click OK.


To return to the Scenarios Manager dialog box without changing the current scenarios, click Cancel.

What is Macro ?

A Macro can be defined as a program that instructs Excel to perform action. In other words they are programs run by the application for which they are created. MS-Excel poses a feature which can record and play back command Macro. When you record a series of steps, Excel notches the steps and converts them into instructions.

Procedure

Tools > Macro > Record New Macro (Record Macro dialog box appears) > Type the Macro name, also the shortcut key  > OK  (then a step recording dialog box appears) > Write down the structure that you want to be recorded.  > After completing it click stop recoding button. > Open another blank sheet where you want the same sheet to be written. Press the Ctrl + and the shortcut key together to run the Macro.



Run or Deleting a Macro

Tools  >  Macro  >  Macros  >  Select Macro  >  Run or Delete



Practice 1. Domestic budget calculation


Practice 2. Profit and Loss Calculation





Comments

Popular posts from this blog

How To Change Default File Download Path in UC Browser

All of us known that UC browser is the most popular, fast and less data consuming mobile browser for android devices. Many of us use UC browser on daily basis on our smart phones. By default UC browser has download path to internal memory device which is /storage/sdcard0/download. sdcard0 is the built in memory or internal memory of your device. Read also : How to fix HTTP and HTTPS Mixed Content Errors.

Do you know that this default download path can be changed? Since, internal memory is fixed, and once you exceed this value you can't download more. You need to move some data from mobile memory to the external memory which is sdcard1. If you change this default path to external memory card (sdcard1), you can download more data directly to your desired directory. Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Here, I will show you, how to change this default download path from internal memory card sdcard0 to external memory card sdcard1. To do so you need to…

Calculation of Total Marks, Percentage, Division, Remarks, Maximum & Minimum Number of Students in MS Excel

In this post, I will help you to learn how to calculate total marks, percentage, division, maximum number, minimum number and remarks of students of a class very fast. At first you need to look over the above image very carefully. The above image shows the marks obtained by six students of a class.

Formula to calculate Total Marks of all students within seconds 

First you need to find out the Total Mark of a single student who is on the top of the list i.e, Mani. To calculate Total Mark of Mani, click on the Total Mark cell address of Mani i.e, H6 and then type the formula =sum(1st subject's cell address i.e, b6:last subject's cell address i.e, g6) and then press Enter on the keyboard or click anywhere on the worksheet. Here b6 and g6 are cell address of 1st subject (English) and last subject (Biology) of that student. Read also : How to Enable HTTPS for Blogger Blog.

After getting results, click on the resultant cell address of Total Mark of the 1st student i.e., Mani an…

How To Rename A WhatsApp Group

We all know that WhatsApp is the most popular messaging service for Android, BlackBerry, iPhone and for other platforms. In this post, I will show you how to rename an existing WhatsApp group. To rename an existing WhatsApp group your smartphone must have internet connection. After that you need to follow the below steps. Read also : How to track lost/stolen mobile phone and erase data remotely.


Step 1. Open WhatsApp application on your smartphone.

Step 2. After that you need to click CHATS tab and click on your group name.



Step 3. Once you click on your group name, you will able to see chat details. Now you need to click vertical dots located extremely top right corner and then click Group info. Read also : How to setup AdSense page level ads.


Step 4. Now you can easily rename your group. To rename the group just click Edit icon and then type the desired group name and click OK. Read also : How to protect your computer from WannaCry ransomware virus.


In this way you can rename a What…

Change UC Browser Default Homepage in Android Phones

We all know that Android OS operated Smartphones and Tablets are great for web browsing. Like other browsers, uc browser has a default search engine Yahoo is set for web search. UC browser provides different kind of search facilities under 5 different categories namely Web, Video, Shop, Image and APP. Read also : How to protect your computer from WannaCry ransomware virus.

In this post, I will show you how to change the default search engines of uc browser in Android devices for their 5 different categories. To do so you just need to follow the below steps. Read also : How to Enable HTTPS for Blogger Blog.

Change Default Homepage for UC Web search

Step 1. At first you need to open UC browser
Step 2. After that click Search. Follow the below image.


Step 3. Once you click Search, you will able to see the default search engine's icon for Web search like y for Yahoo, g for Google. Now you need to click that search icon. Follow the below image. Read also : How to change UC browser defaul…

How To Remove Copied Contents on Smart Phone / Android Device

We all know that UC browser is the fast and most used mobile browser in the world. Almost every mobile user used UC browser to surf internet or doing social networking. Do you know why most people use UC browser rather than other browser. I think, the perfect answer may be its compatibility feature in all kind of mobile phones. Read also : How to transfer large files without mobile data.

UC browser has lots of feature comparing to other mobile browsers. Among them, Set as Default Browser, Auto Save Form, Change Download Path, Auto Reconnect, Clipboard and many more. Lots of browser does not have many of this feature.

Let's come to the main point. We all know that what ever we copy in the computer, all the copied items are stored in the clipboard. Similarly, what ever you copy in android device or other device, all the copied items are stored in the Clipboard.  But I have noticed that Clipboard option is not available in Chrome, Opera Mini or any other application. Read also : H…

Bad Effects of Dendrite

As we all know that dendrite is a good popular adhesive and P. C. Chandra's Chemical Enterprises Pvt. Ltd. is the manufacturer of dendrite. It is broadly used in various sectors like Engineering, Automobile, Footwear, Lather Craft, Home Decor, Carpenters and also for repairing punctured tyres. It contains a substance called toluene. Toluene is a sweet smelling and intoxicating hydrocarbon which is called neurotoxin. When these intoxicants are smeared on a piece of cloth and inhaled, the user feel euphoric (high and experience a sense of invincibility). But they dissolve the membrane of the brain cell and causes hallucinations.



When I was returning from my hometown by train I had noticed at the New Jalpaiguri (NJP) train station that some children mostly rag-pickers were keeping their handkerchief / polythene on their mouth and breathing through it and some smelling their handkerchief. Some of them are were half-naked, bare feet and had a broom in their hands also. All were between…

Change SMS Storage Location in Android Device

By default all the SMS that you have got from friends and mobile operators are stored in either SIM card or phone memory. There is a limited space in the SIM card to store your SMS. If the limitation exceeds all SMS you have got is start storing in phone memory. In this post I will discuss how to change default SMS storage location from Phone memory to SIM card in Android devices. To change the SMS storage location, you just need to perform the below steps.

Step 1. At first you need to open the Messaging application from the app screen. After that, you need to touch the Menu icon i.e., the three vertical dots of top right corner and then need to touch Settings.


Step 2. SMS Settings screen opens. Here, you need to touch Text Message(SMS).


Step 3. Now you need to touch SMS Storage Location. If you use dual SIM card on your Android device then you just need to select the desired mobile operator for which you want to change the SMS storage location either from Phone memory to SIM or SIM …