Assuming a basic knowledge of Microsoft Excel, this hands-on step-by-step spreadsheet course guides participants through commonly used business applications such as forecasting techniques, advanced database functions and logical tests and Pivot tables. In the final week we look at the recording, running and basic editing of VBA macros.
Software version: Office 2007
Course Information
| Start Date | Start Time | Duration | Cost | Course Code | Apply |
|---|
| Monday 3 October 2011 |
18:30 - 20:30 |
10 weekly classes |
£360.00 |
CE1596 |
Apply Now
|
| Friday 14 October 2011 |
18:30 - 20:30 |
10 weekly classes |
£320.00 |
CE1596 |
Apply Now
|
| Friday 27 January 2012 |
18:30 - 20:30 |
10 weekly classes |
£320.00 |
CE1596 |
Course Full |
| Tuesday 24 April 2012 |
18:30 - 20:30 |
10 weekly classes |
£360.00 |
CE1596 |
Apply Now
|
| Friday 27 April 2012 |
18:30 - 20:30 |
10 weekly classes |
£320.00 |
CE1596 |
Apply Now
|
Tutor Info
Robert Stephenson is a visiting lecturer at London Metropolitan University. He has a Mathematics and Computing BSc (UNL) and Data Communications, Networks and Distributed Systems MSc (UCL).
Eligibility
Successful completion of the Microsoft Office course or a basic knowledge of MS Excel, such as formulas and simple functions.
What will I learn?
- Profit and loss statement in a Forecasting environment
- Forecasting Market Trends using Scenarios and Goal Seeker
- Markup Calculation in a Retail Environment
- An Insurance Inventory calculating Depreciation
- Alternative methods of calculating Depreciation - SLD, SYD
- Wage Bonus calculation using nested logical tests
- Sales Invoicing linked to a Product and a Customer Array
- Automation of the above module with Error Messages and macros
- Reconfigure Databases and Arrays using Pivot Table Wizard
- An introduction to inserted Visual Basic Macro modules and an overview of some customised models.
By the end of the course, you will be able to:
- use all of the Intermediate level and some Advanced level facilities of the Microsoft Excel spreadsheet package such as Grouping, Linking, scenarios & Goal Seeker
- use DSUM, DAVERAGE, DMAX, DMIN & DCOUNT functions, multiple extraction criteria in creating databases
- use complex nested formulae and logical tests to create spreadsheets
- design (for a given problem) and create a spreadsheet solution using functionality such as linked files, and/or grouped sheets, nested logical tests, arrays databases, Pivot Tables and macros
- demonstrate an understanding of the variety of solutions that exist within Excel to vary many common business scenarios; be capable of selecting an appropriate one.
