Course details
Participants on this course should have a good working knowledge of the basic features of Excel, gained from day-to-day usage or from prior attendance on an "Introduction/Intermediate Excel" course.
Number of Participants
Minimum 6 - maximum 10
Programme Methodology & Process:
- Linking Worksheets / Workbooks
- If Statements
- Vlookup Tables
- Using Databases
- Subtotals
- Database Forms
- Creating Database
- Functions
- Creating Templates
- Auditing
- Data Consolidation
- Goal Seek
- Scenario Manager
- Pivot Tables & Pivot Charts
- Customising Toolbars and Menus
- Recording Macros
- Creating & Editing Charts
- Review & Close
Assumed Knowledge
A working knowledge of Microsoft Excel basics, Windows and file management is assumed.
Updated on 08 November, 2015Course Location
About Positive2Work Skillnet
- Building Resilience / Stress Management
- Conflict Management / Building Constructive Relations
- Change Management / People Management
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- EUR 105Duration: Upto 80 Hours
- Microsoft Office Essential Skills Skill-UpEUR 9
EUR 188Duration: Upto 3 Hours