Learn Microsoft Excel 2007 By Video Tutorials For Free
This Microsoft Excel tutorials is an useful training aid and reference for using Excel 2007, suitable for beginners and intermediate users this tutorials offers an comprehensive insight into using Excel in a commercial environment. Using practical hands-on examples the tutorial teaches by using a series of preset problems and providing the solutions using working examples and detailed explanations, working files are included in this tutorial so users can work along with the author in real time.
In computing, Microsoft Excel (full name Microsoft Office Excel) consists of a proprietary spreadsheet-application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for Excel 2008 for Mac OS X, a macro programming language called VBA (Visual Basic for Applications).
Microsoft Office is considered to be one of the leading application software in the world of computers. This is a widespread application among businesses. Microsoft Office consists of applications like Word, Excel, PowerPoint, Outlook, etc. Major applications that are used are Word and Excel. Let us see the various features available in Excel and how to learn them. Read along!
If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.
Read further to understand the various options available to you to master Microsoft Excel. You can learn the tricks of Microsoft Excel through CD, CBT or videos. Let us learn about each option one after the other.
Mastering Microsoft Excel 2007 through our video tutorials for free:
With the help of CDs, you can learn Excel at your own pace and need not spend time in attending classes. Microsoft Excel CD would contain screenshots of various commands, how to create professional looking spreadsheets, how to insert charts, diagrams, formulas, create tables, etc. You would also get hands-on training as it would be more interactive. One of the main advantages of learning Microsoft Excel using CD is that you can read at your own convenience.
Learn Excel 2007 - Level 1
Learn Excel 2007 - Level 2
Learn Excel 2007 - Level 3
Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which became very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. Redmond released the first version of Excel for the Mac in 1985, and the first Windows version (numbered 2.05 to line up with the Mac and bundled with a run-time Windows environment) in November 1987. Lotus was slow to bring 1-2-3 to Windows and by 1988 Excel had started to outsell 1-2-3 and helped Microsoft achieve the position of leading PC software developer. This accomplishment, dethroning the king of the software world, solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft pushed its advantage with regular new releases, every two years or so. The current version for the Windows platform is Excel 12, also called Microsoft Office Excel 2007. The current version for the Mac OS X platform is Microsoft Excel 2008.
Internet Explorer version: Just download and setup
FireFox version: Just download the file and open it in FireFox
Chrome version: Just download the file and open it in Chrome
Early in 1993, Excel became the target of a trademark lawsuit by another company already selling a software package named "Excel" in the finance industry. As the result of the dispute Microsoft was required to refer to the program as "Microsoft Excel" in all of its formal press releases and legal documents. However, over time this practice has been ignored, and Microsoft cleared up the issue permanently when they purchased the trademark of the other program. Microsoft also encouraged the use of the letters XL as shorthand for the program; while this is no longer common, the program's icon on Windows still consists of a stylized combination of the two letters, and the file extension of the default Excel format is .xls.
Excel offers many user interface tweaks over the earliest electronic spreadsheets; however, the essence remains the same as in the original spreadsheet, VisiCalc: the program displays cells are organized in rows and columns, and each cell contains data or a formula, with relative or absolute references to other cells.
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, and enables users to perform mail merge.
When Microsoft first bundled Microsoft Word and Microsoft PowerPoint into Microsoft Office in 1993, those applications had their GUIs redesigned for consistency with Excel, the killer app on the PC at the time.
Since 1993, Excel has included Visual Basic for Applications (VBA), a programming language based on Visual Basic which adds the ability to automate tasks in Excel and to provide user defined functions (UDF) for use in worksheets. VBA is a powerful addition to the application which, in later versions, includes a fully featured integrated development environment (IDE). Macro recording can produce VBA code replicating user actions, thus allowing simple automation of regular tasks. VBA allows the creation of forms and in-worksheet controls to communicate with the user. The language supports use (but not creation) of ActiveX (COM) DLL's; later versions add support for class modules allowing the use of basic object-oriented programming techniques.
The automation functionality provided by VBA has caused Excel to become a target for macro viruses. This was a serious problem in the corporate world until antivirus products began to detect these viruses. Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate.
Versions 5.0 to 9.0 of Excel contain various Easter eggs, although since version 10 Microsoft has taken measures to eliminate such undocumented features from their products.
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 (x86 and also a DEC Alpha version)
- 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
- Notice: There is no Excel 1.0, in order to avoid confusion with Apple versions.
- Notice: There is no Excel 6.0, because the Windows 95 version was launched with Word 7. All the Office 95 & Office 4.X products have OLE 2 capacity - moving data automatically from various programs - and Excel 7 should show that it was contemporary with Word 7.
Versions for the Apple Macintosh include:
- 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)
Versions for OS/2 include:
1989 Excel 2.2
1990 Excel 2.3
1991 Excel 3
Versions of Excel up to 7.0 had a limitation in the size of their data sets of 16K (2^14) rows. Versions 8.0 through 11.0 could handle 64K (2^16) rows and 256 columns (2^8 as label 'IV'). Version 12.0 can handle 1M (2^20=1048576) rows, and 16384 (2^14 as label 'XFD') columns.
Unlocking the potential of Microsoft Excel through CBT:
Computer Based Training (CBT) is yet another way where you take your own time to master the application. With the help of Excel CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.
Using tutorials to learn Microsoft Excel application:
Microsoft Excel tutorials are another best way to master the application. You get to learn the application in detail as there are various simulations available that are realistic and interactive. Like Excel tutorial CDs, videos and CBT, you can learn the application at your convenience.
Why are you waiting? Grab either a CD, video, CBT or a tutorial and start mastering Microsoft Excel and unlock the power this application has got.
All the best!
About the Author
Caitlina Fuller is a freelance writer.