Details
1: Who is the Course for?
This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.
2: The CourseCourses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.
3: CertificatesEach delegate will receive a manual and a certificate of attendance.
Outline
Course Content
- Naming Cells & Ranges
- V & H Lookup
- Index & Match
- Logic – AND OR NOT
- Excel Forms
- Scenario Manager
- Goal Seek
- Installing Solver
- Solver
- Data Validation
- Subtotals
- Grouping & Outlining
- Index & Match
- Toolbars
- Pivot Tables
- Pivot Charts
- Excel Macros
- Macro Security
- Saving a Macro Workbook
- Recording & Running a Macro
- Relative Cell References (Macros)
- Viewing & Editing a Macro
- Assigning Macros
- Global Macros
- Object to run Macros
Speaker/s
David Ludlow
Many years of experience in the computer and training business.
Many years of experience in the computer and training business.
Reviews
Be the first to write a review about this course.
Write a Review
InIT Learning deliver one day computer courses at your premises. All equipment is provided, all you need to do is provide a suitable room, e.g. board room or training room.
All levels are offered: Introduction, Intermediate and Advanced levels.
InIT Learning is based in Milton Keynes, Buckinghamshire, England and will travel to most locations in the UK.
All levels are offered: Introduction, Intermediate and Advanced levels.
- Excel - Spreadsheets
- Word - Word Processing
- PowerPoint - Presentations
- Access - Database
- Outlook - Email and Calendar
InIT Learning is based in Milton Keynes, Buckinghamshire, England and will travel to most locations in the UK.