Excel Training - Intermediate v2003

By: Taylor Mason Training  16/09/2011
Keywords: it training, Microsoft training, Microsoft Office Courses

Microsoft excel course content: Viewing excel worksheets Customise view options Display and customise toolbars Hide workbooks and worksheets Freeze panes Group excel worksheets More Formatting Techniques Using styles Conditional formatting The format painter Hiding and displaying cells More execl formulas and functions Using the series command Using the function wizard Financial functions Correcting formulas Using the error checker Using the auditing toolbar Using the watch window Absolute Cell References Entering an absolute column and row reference into a formula Entering mixed cell references into a formula Using Logical Functions Using the IF function Nesting IF functions Database and List Management Using Excel as a database Sorting a database Using Autofilters and advanced filters Using data forms Excel charts Creating excel charts using the wizard Formatting charts Linking Worksheets within a Workbook Renaming worksheets Inserting and deleting worksheets Creating formulas to link worksheets Drawing and Picture Objects Creating drawing objects Using drawing toolbar to control objects Excel 2003 and Other Applications Copying data from another application Using hyperlinks

Keywords: it training, Microsoft Office Courses, Microsoft training

Other products and services from Taylor Mason Training

16/09/2011

Stress management

Delegates will learn how to manage stress, understand what it is and what are the causes of it; they will be shown how to spot stress and what happens if it is not managed.


16/09/2011

Recruitment and Selection

This course is recommencded if you need help with recruitment and selection as you will be learning things such as, Describe the features of a ‘best practice’ recruitment process Describe the advantages and disadvantages of different selection methods and interview formats Use effective questioning skills to select the best candidate for a role. And much more!


16/09/2011

Crystal Reports - Introduction

By the end of this 2 day Crystal Reports training course delegates will be able to: Display, find, sort and filter data Work with groups Build, write and edit formulas Work with filters Understand formatting Enhance reports Create charts Distribute reports


16/09/2011

Interview Skills and CV Writing

This interview and CV writing course is designed to provide you with the most up to date techniques and skills in CV preparation, interviewing techniques and self marketing strategies.


16/09/2011

Crystal Reports Training (Bespoke)

Usually this is delivered over the one day and can cater for proficient users of the software that are looking for specific training solution


16/09/2011

Headhunting Training

After attending this coure you will learn new tips and ideas such as, being able to describe what headhunting is and the process it follows you will understand how to explain why headhunting is used, and the needs of all parties affected by the headhunting process and also identify potential sources of candidates using research techniques and networking, plus much more.


16/09/2011

Headhunting Training

After attending this coure you will learn new tips and ideas such as, being able to describe what headhunting is and the process it follows you will understand how to explain why headhunting is used, and the needs of all parties affected by the headhunting process and also identify potential sources of candidates using research techniques and networking, plus much more.


16/09/2011

Sage Accounts 50

You will learn how to deal with sales, purchase and nominal ledgers, VAT returns and management reports through to prepayments and accruals.


16/09/2011

Sage Payroll - Introduction

The course uses your data as opposed to sample data thus ensuring that you receive both the training a practical set up of your payroll.


16/09/2011

Employment Law

After taking this course you will feel comfortable enough to be confident with no hesitation when asked about employment law. You will learn lots of new facts about it.


16/09/2011

Accredited Management Training - Level 3, 4 days

This management training course will enhance your skills and understanding of your role, your responsibility and the required behaviours to be successful at managingand leading people and teams.


16/09/2011

Discipline & Grievance Training

By taking this course you will learn new information and tips, and come away with a lot of new knowledge to help your company/business.


16/09/2011

Accredited Supervisor Training - Level 3, 1 day

This course provides new or excisting supervisor with the skills and knowledge to become exceptional team managers whilst obtaining an accreditation at the end of the training.


16/09/2011

Conflict Resolution

You will learn effective techniques in dealing with difficult situations professionally; you will be able to identify the underlying causes of difficult behaviour. You will also understand the model for managing conflict, keeping calm to resolve problems and understand the techniques used to overcome negative and aggressive behaviour.


16/09/2011

Appraisal Training

To provide you with an understanding of appraisals and how to use an appraisal system effectively.