Skip to main content

Posts

Showing posts from April, 2011

New Article

How to SUM by matching partial text in Excel

Details of File menu in Excel 2003

I hope you know about the basic of MS-Excel from my previous topic. Now I am going to work with the File menus of Excel 2003 .   Image 1: File menu File Menu: The first menu is New . You can take a new MS-Excel file or a MS-Excel template , or MS-Excel website template from this menu.   Open menu is only for opening any previously saved MS-Excel file from your PC or Web.  By using Close menu you can close a MS-Excel file which is currently opened.   Save is for saving a MS-Excel file into your any disk drive. With the help of Save As menu you can make a copy of MS-Excel file which is previously got title or saved.   Save as web page is the menu by which you can save your MS-Excel sheet as HTML (Hyper Text Mark-up Language) or web page (.htm or .html) format.   Save as Workspace is as like as Save As menu. But the difference is, Save or Save As option works for current workbook only. On the other hand, Save as Workspace makes a ...

Format cells dialog box introducing

Changing cell entry actually means the cell value setting. Such as Text , Currency , Date , Time , Percentage etc. The default setting of each cell is General . It means if you type in a cell 002053 then it will display 2053. But sometime you need to use 00 before 2053. So, how it is possible? Yes, you need to change the cell setting from Format Cells dialog box. Before I describe the cell setting option, I would like to display a picture of a database.   Image 1: Data table In this image, Cell A2:A5 (A2 to A5) are set to Text . Cell B2:B5 are set to Number . So that you can calculate them. Cell C2:C5 set to Currency in $ USD format. Cell D2:D5 set to Date format.   To change the setting of a cell, just select your necessary cells and then you need to open a dialog box named Format Cells . In Excel 2013 it is same with some additional options.  Shortcut key of Format Cells dialog box is   Number Settings: Well the first tab in this dia...

How to enter data in Excel Worksheet?

First of all you need to know what is a Record . Record is the single information of a complete data. You may call it as Cell Value in Excel. On the other hand Data is a complete information. And few data together makes a Data Table . Image 1: Record, Data and Data Table From this picture you will know about database, data and datum. A single information or value of a data is called datum. The complete information of a person or item is called data. And some data together makes a database. How to enter Data? To do this you need to create some records. To create a record just Click or Select a Cell and start typing from your key board as like as MS-Word. Not like MS-Access where you need to create field first, then specify the cell format. In MS-Excel you can work like MS-Word. Just click and type. Then if necessary you can format a cell as your choice. On the other hand, you can copy a data table from another source and direct paste in Excel to create your data table in...

Cell Selection and Cursor movement

Excel is a spreadsheet program. You can analysis your many types of data through Excel by using it's beautiful and user friendly tools. That is why it is the most popular spreadsheet analysis software in the world. But before working on it, you have to clear the concept of Cell .   What is cell? In my opinion, a cell is a unique box in a sheet, where specific column and a specific row crossed. To describe this I need to show a picture to you. Image 1: Cell In this image each box is called a cell and each cell has a unique name in a sheet. If you see closely, then you can find that, Columns are named as Alphabetically and Rows are named as Numerically. The present cell where the cursor placed is column C and row 7 . In short C7 . The C7 cell is a crossing point, where column C and row 7 crossed. So, If I ask you, what is the value of C7 cell? Then your answer will be Balak . Cell name is shown in Name Box . And the value of the cell has shown in Function bar . Se...

Shortcut Keys of Excel 2003

There are many shortcut keys are used in MS-Excel 2003. The main reason of using shortcut keys is to save time and find out the result quickly. For example: You have to go to the end of the database. To do this generally you need to click on vertical scroll bar or horizontal scroll bar for a long time. But If you press “CTRL+End” keys then your cursor will move to end of the database less than 1 second. Now you are clear about the using of shortcut keys in MS-Excel. I am showing some important shortcut keys of MS-Excel 2003 which will helpful for you: Shortcut keys of MS-Excel 2003 Purpose Press Complete entry in a cell Enter Save the current workbook Ctrl + S Close the current workbook Ctrl + W Open a workbook Ctrl + O Exit from MS-Excel Alt + F4 Save As F12 Cursore Movement Arrow Keys Cancel an entry in the cell or formula bar Esc Edit th...

Introduction to Excel 2003

Microsoft Excel is a popular spreadsheet application of Microsoft Office package. It is very user friendly to use for managing database in office. There are some versions of MS-Excel. I will use MS-Excel 2003 here.The latest update is Microsoft Excel 2016.   Image 1: Microsoft Excel 2003 Microsoft Office is not freeware. You have to pay for use this software. But it has a very user friendly interface. Microsoft Excel 2003: This is the main screen of MS-Excel 2003 as you see in below. In this image you can see Title bar , Menu bar , Tool bar , Row Number, Column Number etc. The Workbook is also known as Sheet. You see the cursor here? Yes the shape is like a box. This box is called Cell and each cell has a unique name in a sheet. For example: currently the cursor selected the cell A1 . In here, column number A and row number 1 . Look the cell name is displayed on Name Box as A1 .   Image : Microsoft Excel 2003 working area You can see that, there are 9...