Introduction to Microsoft Excel

Introduction About Excel

Microsoft Excel 2000 gives opportunity to learn and strengthen skills as you gather data, create worksheets, analyze and chart the results, and integrate your findings info reports and assignments. Excel 2000's features help you to work better and teach better. The following topics offer self-guided lessons to make it easy for you to use Excel 2000 as a classroom tool and management tool. Illustrations and steps written in plain language help you to:
  1. Gather and enter data.
  2. Format data.
  3. Work with numbers, formulas, and functions.
  4. Use proofing tools.
  5. Emphasize your point with charts.

#Introduction to Database-management system (DBMS).
#What Are Coding Conventions?

Introduction of Spreadsheets

Modern day business is heavily dependent on financial analysis. Fast and accurate analysis of data is required for making informed business decisions and planning strategies. Information systems need to integrate and analyze large volumes of data from several sources in order to present an accurate picture of the business Situation.

Analysis of data involves:

  1. Performing statistical and mathematical calculations on the data, like totalling, averaging etc.
  2. Presenting the data in the form of graphs to facilitate comparison between two sets of data.
  3. Relating tables of data from more than one source to generate a consolidated data set.

Spreadsheets allow you to perform detailed analysis on numerical data. Spreadsheets, also known as worksheets, display data in the form of rows and columns. Data is entered in a cell, which represents the intersection of a row and column. Data is entered in a cell, Formulas for performing calculations are also entered in the cells that will contain the result of the calculation. The analysis is done by defining formulas to perform calculations on a set of data, link different spreadsheets and present data in the form of graphs. A powerful feature of a spreadsheet is that it recalculates the result of a mathematical formula automatically if the source data changes. Thus, spreadsheets are fast and accourate tools for performing complex data analysis.


Excel is a powerful spreadsheets program. Spreadsheets are tools that can be used to do things such as calculate your checkbook, grade book, or your business,s projected profits. Not only do they look professional, but they are easire than doing the calculations with something else because of automatic recalculation.

For example, imagine you are doing your checkbook and it does not balance out (let's hope this never happens!). You notice that the reason is because you deducted the wrong amount two weeks ago. If you were doing this manually, you would correct the error and then have to redo your entire math for the last two weeks. Using Excel, because of automatic recalculation, all you have to do is correct your mistake and Excel will calculate the correct balance instantly.

Some of the most important features of Excel are:

  • Windows Based Application: Ms-Excel has an interface similar to Windows NT, like all windows applications, Excel has toolbars shortcut menus, Auto Correct, Online help and wizards. This makes Excel easier to learn for users of Windows.
  • Workbooks: Workbooks are containers that hold one or more worksheets. Keeping all sheets that are related to a project in one file reduces the need to maintain different filles.
  • Auditing: Worksheets auditing is a feature that checks a worksheet for errors. Auditing can be used to relate formulas in different cells and locate the source of a calculation error.
  • OLE Support: Excel worksheets can contain any object, like a document, a picture or a video clip. This feature is known as Object Linking and Embedding (OLE). This capability can be used to integrate Excel with all other applications.
  • Large Data Management Capacity: Excel can maintain large volumes of data at a time. A worksheet can contain 65,534 rows and 256 columns. A single cell can contain a maximum of 255 characters. One workbooks can contain a maximum of 255 worksheets. Such data management capacities make Excel a powerful spreadsheets application.
  • Data Analysis Features: Excel contains powerful tools that help in data analysis. Pivot tables, Microsoft Query and Data Map tools allow users to present data in different ways to facilitate analysis.

Post a Comment