1 / 16

Microsoft Excel

Microsoft Excel. By Tom Osti. What is Excel?. Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet-application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

minor
Télécharger la présentation

Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Excel By Tom Osti

  2. What is Excel? • Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet-application written and distributed by Microsoft for Microsoft Windows and Mac OS X. • It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). • It has been the most widely used spreadsheet application available for these platforms since version 5 in 1993Excel is part of Microsoft Office.

  3. Creation of Excel • Microsoft originally made a spreadsheet program called Multiplan in 1982. • This was very popular on CP/M systems • On MS-DOS though lotus 123 was favoured • The first version of Microsoft Excel came out on the MAC OS X in 1985 • The first version to be released onto Windows was in November 1987 and soon after Windows had made 1988 Excel • Afterwards this success Microsoft has released a new version of Excel every year • The current Windows version Excel 12 (also known as Microsoft Office Excel 2007 is doing undoubtedly well

  4. Excel Versions • Excel Versions for Mac • 1985 Excel 1.0 • 1988 Excel 1.5 • 1989 Excel 2.2 • 1990 Excel 3.0 • 1992 Excel 4.0 • 1993 Excel 5.0 (Office 4.X -- Motorola 68000 version and first PowerPC version) • 1998 Excel 8.0 (Office '98) • 2000 Excel 9.0 (Office 2001) • 2001 Excel 10.0 (Office v. X) • 2004 Excel 11.0 (part of Office 2004 for Mac) • 2008 Excel 12.0 (part of Office 2008 for Mac)

  5. Excel Versions • Versions for Microsoft Windows include: • 1987 Excel 2.0 for Windows • 1990 Excel 3.0 • 1992 Excel 4.0 • 1993 Excel 5.0 (Office 4.2 & 4.3, also a 32-bit version for Windows NT only on the PowerPC, DEC Alpha, and MIPS) • 1995 Excel for Windows 95 (version 7.0) - included in Office 95 • 1997 Excel 97 - included in Office 97 • 1999 Excel 2000 (version 9.0) included in Office 2000 • 2001 Excel 2002 (version 10) included in Office XP • 2003 Excel 2003 (version 11) included in Office 2003 • 2007 Excel 2007 (version 12) included in Office 2007

  6. What can it be used for? • There are many uses to excel • This varies from being more advance to more basic tasks • Graphs • Tables • Formulas • Matrix(won’t be looking much into)

  7. Matrix • In mathematics, a matrix (plural matrices, or less commonly matrixes) is a rectangular array of numbers. • Matrices consisting of only one column or row are called vectors, while higher-dimensional, e.g. three-dimensional, arrays of numbers are called tensors. • Matrices can be added and subtracted entrywiseand multiplied according to a rule corresponding to composition of linear transformations. • These operations satisfy the usual identities, except that matrix multiplication is not commutative - the identity AB=BA can fail. • Matrix is a regular arrangement of numbers for example.

  8. Functions • Excel was the first spreadsheet that allowed the user to define the appearance of spreadsheets (fonts, character attributes and cell appearance). • It also introduced intelligent cell recomputation, where only cells dependent on the cell being modified are updated (previous spreadsheet programs recomputed everything all the time or waited for a specific user command). • Excel has extensive graphing capabilities.

  9. Tables • Number Sequences • Random Number Generating • Naming Cells • =RAND()*10 • Product (Cleaner look • No need for extra brackets) • =SUM(G2,I2 ) • =SUM($G$2,I2) • =Average(B2,B11)

  10. Tables

  11. Graphs • Graph 1 • 17.3156602 • 23.3156602 • 19.3156602 • 17.3156602 • 19.3156602 • 11.3156602 • 22.3156602 • 12.3156602 • 15.3156602 • 11.3156602 • Graph 2 • 17.3156602 • 22.63505923 • 20.23480688 • 14.12964534 • 20.55755594 • 13.18979432 • 28.09487977 • 10.21968914 • 13.08003719 • 10.99980921

  12. Solvers – Simple Interest • Example 1 – Simple Interest • Simple Interest Rate • Total • Interest Rate Amount • =C5+$C$3

  13. Compound Interest • Example 2 • Compound Interest • Interest Percent • Total • Original Interest • =C4+E4 • =$C$2*C5

  14. Advanced Table • Guesses • Sum • Average • Log • ^2

  15. Special Pasting • Pasting Equations Excel Paste into Word • Being able to change numbers

  16. Conclusion • What is Excel • Uses • Tables • Formulas • Graphs • Solvers • Special Pasting

More Related