£185 (includes course materials, lunch and refreshments) Corporate rates available please contact us for further information
Anyone wishing to investigate the more powerful and advanced features of Excel 2003.
Delegates should be proficient users of Excel 2003, and should have experience of the topics covered in our Introductory and Intermediate courses, either from attending these courses or by knowledge gained from their own experience.
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.
This course allows the delegate to appreciate the full potential of Excel 2003. By the end of the course, the user will be competent with the following skills:
Protection
- Cell Protection
- Hiding Data
- Workbook Protection
Solver
- Goal Seek
- Using Solver Constraints
Scenarios
- Creating, Using, Editing and Deleting
- Producing Summary Reports
Lists
- Create a List
- Data Forms
- Adding Subtotals
- Database Functions
PivotTables
- Create and Understand PivotTables
- Display One Item
- Formatting/Grouping
Advanced Functions
- Logical OR/AND
- Date and Time
- Lookup and Reference
- SumIf and CountIf
- Text Functions
- Financial
- Nested
Advanced Charts
- 3D Chart View
- Data Labels and Markers
- Stacked Bar Charts
Data Tables
- One/Two Input Data Tables
Styles
- Create, Use and Delete Styles
Data Consolidation
- By Position or Category
Macros
- Security
- Record
- Run
- Assign to a Button or Menu
Auditing
- Trace Precedents, Dependents and Errors
- Data Validation
Forms
- Create and Format Online Forms
Web Pages
- Create Hyperlinks
- Use Send To
This course outline is a guide. All our courses can be tailored to customer requirements.
Explore the benefits of using other Office applications including Access, Word, PowerPoint, or Project.
Microsoft Office Specialist
(MOS 2007)
MOS - Excel
MOS - Word
MOS - PowerPoint
MOS Outlook
MOS Access
Intensive Training (Office 2007)
Government funding available for local businesses through Train to Gain Enhancement Fund.
Click on icon to print this page
Email: info@ictacademy.co.ukTel: 01302 554958Address: ICT Academy, DBIC, Doncaster, DN4 5QA