Training courses in Sunderland

1 Excel Basics • Spreadsheet Concepts • Entering Text & Numbers • Summing Rows and Columns 2 Excel Workbooks • What is a spreadsheet? • Opening and Saving Workbooks • Switching between Workbooks • Entering Text and Numbers • Entering Pre Defined Lists • Defining a Custom List • Summing Rows and Columns • Saving and Closing a Workbook 3 Calculations & Corrections • Entering Formulae • Correcting Mistakes 4 Moving, Copying and Inserting • Moving/Copying...

1 More about Calculations • Absolute References • Using Functions • Examples of Functions 2 More Features • Using Comments • Splitting and Freezing • Using Zoom • The Paste Special Command 3 More about Printing • Adding Headers & Footers • Setting the Print Area • Using Print Titles • Controlling Page Breaks 4 More about Charts • The Chart Menu • Revising a Chart • Further Formatting • Drag and Plot 5 Working with Multiple Worksheets • Selecting Multiple Worksheets • Navigating...

1 Data Functions • Text Functions • Logical Functions • HLOOKUP/VLOOKUP • Error Functions 2 Handling Worksheets • Working with multiple sheets • Inserting / Deleting / Renaming • Moving / Copying 3 Formatting and Validation • Custom Number Formats • Conditional Formatting • Data Validation & Cell Protection • Hiding Cell Entries 4 Using Lists • Advanced Sorting & Data Filtering • Pivot Tables • Database Functions 5 More about Worksheets • Worksheet Auditing • Using Views • Scenarios & Report Manager • Designing...

This course refreshes and updates the First Aid skills of those who need to renew their First Aid at Work (statutory) certificate and whose existing certificate is still valid. Two days including assessments .

A five day corse This Level 4 advanced course with management accountability in mind. It is intended to equip persons with adequate knowledge to ensure that companies operate in a hygienic and efficient manner. The course includes lectures enhanced by audio/visual...

A three day course ( 18th, 19th, 20th May ) to provide successful candidates with the essential skills to handle any First Aid situation, from minor slips and trips to the most serious of incidents. First Aid provision in the workplace...

This is a five days course (1st, 2nd, 3rd, 6th, 7th June) This qualification has been developed for anyone entering teaching or training roles or already in-service who needs to achieve the minimum threshold status as a teacher in the lifelong...

This is a four day course (21st, 22nd, 23rd, 24th June) This course is an excellent stepping stone to further courses that are required for corporate membership of IOSH. The Managing Safely course has been produced to provide the necessary standards...

This is a two day course (13th & 14th June) that provides delegates with the skills and understanding to formally audit and/or Inspect companies ‘in house’ training systems and the effectiveness of the companies trainers. The course is intended for persons who...

A ten day course covering the 13 elements of the NEBOSH National General Certificate in Occupational Safety and Health. Subjects areas covered include the systems required for effective health and safety management, applicable legislation and practical controls for common workplace hazards. ...

32 modules, starting from the very basics, up to 70 words per minute after about 60 hours of study. Your lectures are all on CD or optionally on an mp3 player so that you can study anywhere. Personal feedback on all...