[Adverisment]

Introduction to Microsoft Excel

Microsoft, Microsoft Excel, Ms Excel, Windows, Introduction to 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 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.

Composition of Parliament of India.
# What is the Distinction between State Government and Society?
# What is Formation of Public Opinion?


Spreadsheets

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.

COMMENTS

Advertisement

Name

CBSE,1,Essay Writing,7,G.K & Current Affairs,9,Information & Technology,24,Letter Writing,8,News Letter,10,Passage Writing,3,Report Writing,2,SEBA,1,
ltr
item
Teacher Notes: Introduction to Microsoft Excel
Introduction to Microsoft Excel
Microsoft, Microsoft Excel, Ms Excel, Windows, Introduction to Excel,
https://images.hasgeek.com/embed/file/f9b11c6fdbaa4fb089c610998d309907
Teacher Notes
https://www.freeteachernotes.com/2019/12/introduction-to-microsoft-excel.html
https://www.freeteachernotes.com/
https://www.freeteachernotes.com/
https://www.freeteachernotes.com/2019/12/introduction-to-microsoft-excel.html
true
2332357964370966229
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy