Microsoft Excel Activities 2003/2004

Microsoft Excel Activities has been developed for use with Microsoft Excel 2003 on the Windows system and Microsoft Excel 2004 on the Macintosh system.

Prices

Download Product

Summary of the Chapters

Module 1

Chapter 1: Introduction to Microsoft Excel

This chapter introduces:

• the components of the Excel screen.
• moving around the spreadsheet.
• entering labels and values.
• entering formulas.
• saving and printing.

Back to Excel | Top | Next

Chapter 2: Formatting Cells

This chapter introduces the basics of formatting the content of cells: It includes:

• formatting single cells and groups of cells.
• formatting values to currency and per cent.
• adjusting column widths and row heights.
• using the format cells dialogue box.
• approaches for creating spreadsheets.

Back to Excel | Top | Previous | Next

Chapter 3: Further Formatting

This chapter demonstrates some more detailed cell formatting techniques, such as:

• using the Format Painter tool.
• setting borders.
• setting cell shading
• setting text colour
• centring across selection
• text wrapping within cells.

Back to Excel | Top | Previous | Next

Chapter 4: Copying Cell Data

This chapter demonstrates the many cell duplicating commands that Excel provides. It includes:

• Fill Right, Fill Down and Fill Series.
• AutoFill and AutoFill options.
• Adsolute and Relative references.
• the AutoSum command.
• application of the copy commands.

Back to Excel | Top | Previous | Next

Chapter 5: Larger Spreadsheets

This chapter demonstrates how to manage larger spreadsheets. It includes:

• splitting the screen using freezing titles.
• inserting rows and columns.
• editng cells contents.
• sorting labels and values.

Back to Excel | Top | Previous | Next

Chapter 6: Using Worksheets

This chapter demonstrates how to manage spreadsheet files using worksheets. It includes:

• copying data between worksheets.
• duplicating a worksheet.
• moving worksheets.
• deleting worksheets.
• setting tab colours.
• creating worksheets for Equation Dumps.

Back to Excel | Top | Previous | Next

Chapter 7: Displaying Data in Charts

This chapter introduces simple chart creation techniques. It involves:

• setting the chart type, data range, chart options and chart location.
• modifying charts.
• using the Chart tool bar.
• changing the chart type.
• printing charts.
• deleting charts.

Back to Excel | Top | Previous | Next

Chapter 8: More Detailed Charts

This chapter demonstrates the more detailed chart techniques, such as:

• plotting multiple column data.
• changing axis scales.
• formatting columns, axes and walls.
• comparison charts.
• custom charts.

Back to Excel | Top | Previous | Next

Chapter 9: The Drawing Tools

This chapter demonstrates some of the Drawing Tools that can be used to enhance a spreadsheet's appearance. It includes:

• shading cells.
• importing graphics and clip art.
• using AutoShapes.
• using WordArt.
• using fill effects

Back to Excel | Top | Previous | Next

Module 1 Projects

The multi-user version provides two projects for students to apply their spreadsheet skills:

1. Create a payroll for the EasyTune Car Care company.
   
2. Produce charts to show the number of patrons and revenue received from the Currumvale Motor Show.

Back to Excel | Top | Previous | Next

Module 2

Chapter 10: Making Predictions With Excel

This chapter covers how to use formulas to predict outcomes. It involves:

• predicting the income for a motel.
• using manual prediction methods.
• using the Goal Seek command.

Back to Excel | Top | Previous | Next

Chapter 11: Making Decisions With Excel

This chapter introduces the IF command which allows Excel to make decisions. It includes:

• simple IF statements.
• using greater than, less than
• using greater than or equal to.
• using AND and OR in IF statements.

Back to Excel | Top | Previous | Next

Chapter 12: Lookup Commands

This chapter uses for the Lookup command. It includes:

• the structure of the Lookup command.
• looking up a interest rate table.
• creating an income tax calculation.
• calculating real estate commissions.

Back to Excel | Top | Previous | Next

Chapter 13: Creating Sales Invoices

This chapter combines the use of IF and Lookup commands to produce sales invoices. It includes:

• formatting the invoice.
• looking up stock values from a table.
• using IF statements to ensure calculations are only carried out when values are entered.
• creating a master invoice.
• setting print areas.

Back to Excel | Top | Previous | Next

Chapter 14: Sharing Data Between Files

This chapter demonstrates how to link files so that it data is changed in one file other linked files are updated. It includes:

• naming cells.
• linking an Office file to 3 department files.
• editing cells contents.
• looking at all 4 files at once.

Back to Excel | Top | Previous | Next

Chapter 15: Using Macros and Buttons

This chapter demonstrates how to create macros and use buttons to run them. It includes:

• recording macros.
• assigning buttons to macros.
• editing and deleting macros.
• button properties.

Back to Excel | Top | Previous | Next

Chapter 16: Payroll Systems

This chapter how to create a payroll linked to payslips. It involves:

• completing a payroll worksheet.
• linking a payslip worksheet to the payroll.
• using link formulas.
• setting macros and buttons to automate the payslips.

Back to Excel | Top | Previous | Next

Chapter 17: Financial Applications

This chapter demonstrates some examples of financial applications that spreadsheets can be used for, such as:

• an electronic cheque book.
• a home loan simulator.
• compound interest calculations.

Back to Excel | Top | Previous | Next

Chapter 18: Date Calculations

This chapter demonstrates some of the some of the calculations that can done on date values. It includes:

• a library overdues system.
• a debt collection system.

Back to Excel | Top | Previous | Next

Chapter 19: Useful Tools

This chapter demonstrates some useful tools that students can use when creating spreadsheets. It includes:

• help features.
• Save options.
• Auto format.
• styles.
• spell checking.

Back to Excel | Top | Previous | Next

Module 2 Projects

The multi-user version provides a project for students to apply their spreadsheet skills.Students are required to create an invoice/stock list system for Quantum Electronics (a stereo systems manufacturer).

Back to Excel | Top | Previous | Download Product

Home | Products | Prices | Ordering | Podcasts | Downloads | Contact