Part time Excel Advanced
Vocational qualification
In Doncaster
Description
-
Type
Vocational qualification
-
Location
Doncaster
-
Duration
1 Day
m 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.Course AimsThis 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:Course OutlineProtection- Cell Protection- Hiding Data- Workbook ProtectionSolver-
Facilities
Location
Start date
Start date
About this course
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.
Reviews
Course programme
Microsoft Excel 2003 - Advanced Type of learning:
Instructor lead at DBIC
Duration:
1 day intensive
Times/dates:
Cost:
£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information
Target Audience
Anyone wishing to investigate the more powerful and advanced features of Excel 2003.
Pre-Course Requirements
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.
Benefits to the Employer
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.
Course Aims
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:
Course Outline
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.
Part time Excel Advanced