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





Recommended Post
Big on Hosting. Unlimited Space & Unlimited Bandwidth

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…

Best Video Calling App For 2G, 3G, 4G and Wi-Fi Network

More or less every mobile subscriber wishes to chat with their contacts by seeing his/her infront of them. Now a days video calling becomes more popular in urban areas rather than rural areas. After the invention of 3G network it becomes a trend to chat with loved one through video calling. Read also : How to protect your computer from WannaCry ransomware virus.

But what happened if you have 2G network instead of 3G or 4G. Could you be able to chat with your loved one by seeing him on 2G network? There is a good news for those who wishes to see their friends or family members on mobile screen when they talk to them. There are many application software available on internet which provides video calling facility even on 2G network. Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Although there are many video calling applications are available, among them my recommendation is IMO. Because IMO provides fast, free and high quality video calling facility to its members…

How To Delete / Deactivate / Reactivate a Pinterest Account

Pinterest is one of the best social network since it allows users to create boards and also to update boards with images. But what if you want to delete your pinterest account? Pinterest allows users to delete their accounts permanently or deactivate their accounts so that whenever a user like to come back easily can reactivate his/her account. So be sure what do you want? Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Do you want to delete your account permanently or deactivate your account? Keep in mind that by deactivating your Pinterest account, your profile and boards will not be visible on Pinterest also your twitter and facebook profiles will be unliked, if you had connected them earlier.

Steps to Delete/Deactivate Pinterest Account

Step 1: At first log in to your Pinterest account with your user name and password. Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Step 2: Click on your username locating right side at the top of the ho…

Enable Auto Save Forms & Passwords in UC Browser

Many of you use UC browser on daily basis on your smart phone but very less enable this feature. Enabling auto save forms and passwords allows the browser to remember the username and passwords. It gives you relief from entering username & password every time whenever you login to your email. Did you enable auto saving form & password? If not, then do it now. Read also : How to track lost/stolen mobile phone and erase data remotely.

In this post, I will show you how to enable auto save forms & password in UC browser in your Android phones. To do so you need to follow the below steps.

Steps to enable auto save forms and passwords

Step 1. At first open UC browser

Step 2. In the second step, tap on the horizontal bar.


On the next image, you will able to see Bookmarks, History, Refresh etc. icons. Now swipe this menu screen to the left and tap Settings. Read also : How to create custom AdSense Search Engine and make money from it.


Step 3.  Now on the Browser Settings, you w…