SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Microsoft Excel

minor avatar
minor
16 diapositives · 651 Views · Sep 17, 2014

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.

#microsoft excel #microsoft excel ppt #powerpoint #presentation
Microsoft Excel - slide 1
01 / 16Microsoft Excel
1 / 17

Télécharger la présentation

Microsoft Excel
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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