Microsoft Excel - Advanced

Course details

The Aim of our Microsoft Excel Advanced course is to build on the knowledge gained at the lower levels giving the learners a complete knowledge of the more complex aspects of Excel.

Who Should Attend?

• This course would be for those people who having completed the Intermediate Course (or already have that level of competence) and wish to maximise their spreadsheet skills.

Course Objectives:

• Using spread sheets, be able to work with complex functions, formulas, templates, charts, pivot tables, database functions, Macros Scenarios etc.

Course Programme:

• Working with Formulas (SumIF, CountIF, CountA)
• Working with Date & Time Functions
• Creating sub-totals
• IF & nested IF Functions
• V Lookups & H Lookups
• More formatting Charts
• Pivot Tables
• Creating Tables in excel
• Advance formulas & functions
• Database functions
• Text functions
• Lookup, Index & Match
• Advanced list management
• Drawing & Picture objects in Excel
• Importing & Exporting Data
• What If Analysis
• Scenarios
• Data Tables
• Goal Seek
• Spreadsheet Security
• Working with Macros - creating , inserting & assigning a macro to a button
• Forms & form control in excel

Training Methods:

• Classroom based, using Microsoft programmes & interactive discussion.

Additional Information:

• Maximum of 9 participants.
• National Training Solutions Certificate will be given to all participants who complete the course.
• ECDL Certification available.
• Price on application. We can also offer group discounts.