Microsoft Excel 2003
Course Outline
Microsoft Excel is an electronic spreadsheet and it is mainly used for manipulating numerical information. Amongst other things, spreadsheets enable you to produce budget reports, financial plans and profit and loss statements.
They re-calculate automatically, providing huge savings in time, and their formatting tools allow you to present well laid out reports.
This is can be delivered as a half-day or full day course.
ILA Approved
This course has been ILA approved. This means you could get up to £200 towards the cost of this course. Find out more about using your ILA at Net Resources.
Microsoft Excel Course Contents
The following represents a typical breakdown of our Microsoft Excel course, however we can tailor all our courses to specific requirements as required.
Introduction to Microsoft Excel
- Get started with Excel
- Enter, change and delete numbers and labels
- Create and copy formulae
- Move and copy ranges
- Format cells to display decimals, currency and dates
- Insert and delete rows and columns
- Save and open spreadsheets
Advanced Microsoft Excel
- Consolidation, Names and Protection
- Freezing Panes, Comments, Styles and Templates
- What-If Analysis
- Using Goal Seek
- Managing Data Lists
- Retrieve records using AutoFilter
- Validating Data
- Create a PivotTable report
- Functions
Skills Gained:
- Entering information into an existing spreadsheet
- Creating and formatting a simple spreadsheet
- Saving and opening a spreadsheet
- Printing spreadsheets and reports
- Ongoing spreadsheet management methods
Course Details
- Duration: 1 day
- Time: 10:00-16:00
- Cost: £289.00 + VAT
- Dates: Call for details