Microsoft Office Excel 2007

FunctionX Press FunctionX VBA Excel Visual Basic Language Visual Basic C# Visual C# Oracle ASP.NET C# Visual C++/CLI C++ Builder SQL Server

Microsoft Excel is a spreadsheet application used to perform financial calculations, statistical analysis, and other related operations. Microsoft Office Excel 2007 brought many enhancements to previous versions of the software, including the Ribbon, aesthetic aspects, and overall performance.

This site offers various lessons on how to use Microsoft Office Excel 2007 to create spreadsheets, perform calculations, and do data analysis.

Fundamental Topics
 
   

Microsoft Excel Topics

 

Data Entry

Intermediate Topics

Functions

 

Spreadsheet Topics

Accounting

 
 
Spreadsheet Topics
 
Accompanying Exercises
Previous Version of this site (Microsoft Excel 2003 Lessons)
 
 
 
 
Examples
Georgetown Cleaning Services

This is a better version of the application of the same name referred to in the lessons. This time, we use the DateTimePicker control to help the user specify when the cleaning items are dropped and when they are expected.

College Park Auto Shop

This is an example of a spreadsheet that helps to process car repair orders.

Bethesda Car Rental

In this workbook, we simulate a car rental business, using a list of cars in a separate worksheet.

Net Price Calculation

This small example shows how to perform a simple operation of calculating the amount of tax retrieved from a sale item and the net price sold.

CD Publisher

This example simulates a small business that prints or publishes CDs for other small companies or individuals. It calculates the unit price of a CD based on the quantity ordered

Compound Interest

This is an example of calculating the interest accrued on a loan. The calculations are performed depending on an interest rate and the type of frequency (monthly, annually, etc).

 
Resources Controls  
Examples Radio Buttons Links
 
Other Tutorials
 
External Links
Microsoft Office User Specialist
 
 

Microsoft Access SQL MS PowerPoint C++ C++/CLI VBScript Win32 Object Pascal ADO XML
VBA For MS Access SQL Server XML.NET Visual C++ Visual C++/CLI JavaScript C++ Builder Delphi ADO.NET  

Mirror Site Copyright © 2002-2011 FunctionX, Inc.