Microsoft Office Excel 2007

FunctionX Press FunctionX VBA Excel VB Language Visual Basic C# Visual C# ASP.NET Visual C++/CLI C++ Builder SQL Server
Microsoft Office Excel 2007

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.

 
Table of Contents
1.   Microsoft Excel Fundaments Introduction to Accounting
2.   The Columns of a Spreadsheet Economic Entities
3.   The Rows of a Spreadsheet Elements of Accounting
4.   The Cells of a Spreadsheet Transaction Analysis
5.   Worksheets
6.   Workbooks
7.   Printing
8.   Introduction to Data Entry
9.   Data Entry With Numbers
10. Introduction to Cell Formatting
11. Aesthetic Cell Formatting
12.  Data Analysis With Charts
13. Introduction to Expressions
14. Introduction to Functions Accompanying Exercises
15. Business and Financial Functions Microsoft Excel 2003
 
 
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  
Exercises Radio Buttons
Samples
 
Other Tutorials
 
External Links
Microsoft Office User Specialist
 
 

FunctionX Press SQL MS PowerPoint C++ Managed C++ Visual Basic C# Object Pascal ADO
VBA For MS Excel SQL Server StarImpress Visual C++ C++/CLI VBScript Visual C# Delphi ADO.NET
MS Access StarCalc Win32 Visual C++ .NET VBasic J# XML.NET
VBA For MS Access C++ Builder JavaScript Visual Basic .NET Visual J#
 

Mirror Site Copyright 2002-2008