Microsoft Excel Intermediate

Welcome to Charter Training 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 competency in the more complex features of Microsoft Excel for business or individual use.
Increased effectiveness with the ability to explore the benefits of Microsoft 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, who wish to develop spreadsheet competency on this market leading software. Also for students familiar with a non-Windows spreadsheet package, who want to cross-train.

Course Duration: 12 - 14 hours

Course Content

Practice with Formulae, AutoCalculate, Introduction to Functions, Date Functions, Financial Functions, Conditional Functions, Introduction to Charts, Using the Chart Wizard, Creating Charts of Different Types, Resizing & Moving Charts & Components, Chart Options, Chart Colours & Other Formatting, Cell Alignment, Cell Borders, Sorting Data, Using Find & Replace, Multiple Workbooks, Moving & Copying Worksheets, E-mailing Worksheets & Workbooks, Web Pages & Web Page Preview, Filling Cells, AutoFill, Creating Number Series, Date Series, Custom Lists, AutoComplete & Pick From List, Cell Names.