Module 1: Solve a problem using a Spreadsheet

After completing this module, the learner will be able to prepare and produce a spreadsheet to provide a solution to a given problem.

• Ensure that the spreadsheet produced addresses the given problem
• Work with MS Excel
• Adjust settings to customise the view and preferences of the spreadsheet

Module 2: Creating Advanced Calculations

In this lesson the learner will learn how to create advanced calculations, working with Range Names, formulas and functions.

• Apply range names
• Use MS Excel to apply formulae to provide alternative solutions to the given problem
• Insert Functions in a Worksheet

Module 3: Organizing Worksheet Data with Tables

Tables allow you to use Excel’s powerful organizational capabilities without modifying the data itself.

• Create and modify tables
• Use subtotal features and database functions

Module 4: Visualizing Data with Charts

While pure data can be analyzed by those familiar with this data and the tools that Excel provides, sometimes you need graphical assistance to help interpret it.

• Create charts
• Modify and format existing charts
• Create a trendline
• Create advanced charts

Module 5: Inserting Graphics

While the default appearance of your worksheets can be quite plain, Excel offers you access to a variety of graphical objects that you can use to enhance their visual appeal.

• Insert and modify graphical objects
• Layer and group graphic objects
• Incorporate SmartArt into your workbooks

Module 6: Apply formatting and special effects

You can help improve the readability of a worksheet by applying different types of formatting.

• Use MS Excel to apply formatting and special effects applicable to the given problem
• Manage themes
• Utilize International Symbols

Module 7: Auditing Worksheets

In this lesson you will learn how to evaluate formulas, troubleshoot invalid data and work with the trace cells feature.

• Use MS Excel to evaluate a spreadsheet to comply with the given problem
• Trace cells
• Troubleshoot invalid data and formula errors
• Watch and evaluate formulas
• Create Scenarios
• Perform a What-If Analysi

Module 8: Working with Multiple Worksheets

After completing this module, the learner will be able to work with multiple worksheets to suit the solution to the given problem.

• Format worksheet tabs
• Manage worksheets
• Manage the view of worksheets and workbooks
• Work with Page Breaks
• Printing Large Worksheets