Microsoft Excel Advanced

Welcome to Charter Recruitment Services Ltd

We offer a wide range of courses in Computer, Office & Business Skills leading to recognised qualifications ranging from National Vocational Qualifications in a number of topics including Information Technology, Accounting, Business Administration and Management, through to the European Computer Driving Licence

Aims and Objectives

Gain a clear understanding of the basic principles and key features of this software package, and the ability to use it effectively.
Increased effectiveness with the ability to explore the benefits of Excel and make tasks easier.
A choice of training locations and times, and the flexibility and value of self-study training methods that allow for different learning speeds and styles.

Target Audience

Business individuals, including secretaries, with a good knowledge of Microsoft Excel who want to increase their skills to include the more advanced features of this market leading software package.

Course Duration: 12 - 14 hours

Course Content

Subtotals, What-if Analysis - Data Tables, What-if Analysis - Goal Seek, Protection & Security, Querying & Filtering, Linking Data, More on Charts, Functions Overview, Functions - IF/AND/OR/ISERROR, Functions - TODAY/DAY/MONTH/YEAR, Functions - COUNT & Related Functions, Functions - LOOKUP & Related Functions, Functions - Converting Text, Pivot Tables & Pivot Charts, What-if Analysis - Scenarios, Formula Auditing, Adding Comments, Macros, Macro Security, Templates