Spreadsheet Exercises 2025
by Greg Bowden
 |
Spreadsheet Exercises provides teachers with a series of graduated Spreadsheet activities. These can be given to students directly or used by teachers in the development of their own course materials.
The exercises do not provide detailed instructions on how to create the spreadsheets, but they do provide brief instructions on the Spreadsheet features that could be used. If more detailed instructions are required, then the Learning Microsoft Excel 365 Modules would be more appropriate. |
The Exercises cover entering formulas, formatting cells and worksheets, rearranging cell data, creating different types of charts such as Pie, Column and Sparkline charts, using the Drawing Tools, applying IF and IFS functions, using the XLookup function, creating Sales Invoices, creating Payroll/Payslip systems, sharing data between files, using Macros and Buttons, entering financial and date calculations, and creating Pivot Tables.
Support files are provided in the SPREADSHEETS SUPPORT FILES when exercises need images or prepared spreadsheets. |
|
Prices (Including GST)
Prices are in Australian dollars and include GST. For purchases outside Australia, the 10% GST (tax) is removed from the price. |
|
If you are ordering using a school Purchase Order Number, please complete the Order Form. |
|
If you are purchasing using a Credit Card or PayPal, select the ADD TO CART button below. |
|
Spreasheet Exercises, $33.00 |
 |
List of Exercises
Spreadsheets Exercise 1: Simple Formulas |
|
Spreadsheets Exercise 2: Formatting Cells |
|
Spreadsheets Exercise 3: More Detailed Formatting |
|
Spreadsheets Exercise 4: Copying Cell Data |
|
Spreadsheets Exercise 5: Rearranging Data |
|
Spreadsheets Exercise 6: Using Worksheets |
|
Spreadsheets Exercise 7: Displaying Data in a Pie Chart |
|
Spreadsheets Exercise 8: More Detailed Charts |
|
Spreadsheets Exercise 9: Sparkline Charts |
|
Spreadsheets Exercise 10: Using the Drawing Tools |
|
Spreadsheets Exercise 11: Making Predictions |
|
Spreadsheets Exercise 12: Making Decisions on Data |
|
Spreadsheets Exercise 13: Lookup Commands |
|
Spreadsheets Exercise 14: Creating Sales Invoices |
|
Spreadsheets Exercise 15: Sharing Data Between Files |
|
Spreadsheets Exercise 16: Macros and Buttons |
|
Spreadsheets Exercise 17: Payrolls and Payslips |
|
Spreadsheets Exercise 18: Financial Applications |
|
Spreadsheets Exercise 19: Date Calculations |
|
Spreadsheets Exercise 20: IFS Functions |
|
Spreadsheets Exercise 21: Pivot Tables |
|
Spreadsheets Exercise 22: Project |
| Home | Products | iPad | Downloads | Testimonials | Ordering | Contact Us |