Lessons

MS Excel Interface
Lists and Worksheet
Bullet Printing
Lesson 5: Data Entry Data Entry
Lesson 6: Introduction to Cells Formatting Introduction to Cells Formatting
Formatting Cells Contents Formatting Cells Contents
Lesson 8: Style and Conditional Formatting Style and Conditional Formatting
Lesson 9: Graphics and Drawing Graphics And Drawing
Lesson 10: Operators and Operands Operators and Operands
Lesson 11: Introduction to Functions Introduction to Functions
Lesson 12: Collections-Based and Business Functions Series and Business Functions
Lesson 13: Financial Functions Financial Functions
Lesson 13: Financial Functions Date and Time Functions
Logical Functions Logical Functions
Lesson 15: Charts Charts
 
 

Microsoft Excel is a spreadsheet application used to perform financial calculations, statistical analysis, and other related operations.
This site offers tutorials and examples on how to use the applications and experiment with it.

Google
 

Microsoft Office Excel 2007

 
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 VBScript MS PowerPoint C++ Microsoft Access Visual Basic Language C# C++/CLI Delphi
VBA For MS Excel SQL Server Win32 Visual C++ VBA For MS Access Visual Basic Visual C# Visual C++/CLI C++ Builder
Yevol C# Key
 

Mirror Site Copyright © 2002-2009 FunctionX, Inc.