1190 Management courses in Stevenage

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

City & Guilds Level 3 Award in Direct Emergency Rescue and Recovery of Casualties from Confined Spaces - 6160-07 - This course is designed to introduce delegates to the basics of rescue and recovery of casualties from confined spaces. Understanding emergency arrangements as set by legislation and employers, some of the equipment required to rescue a casualty and safety of the rescue team. Note: A pre-requisite qualification is required to complete this course. Delegates must hold a valid 6160-08 qualification. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-07-level-3-award-in-direct-emergency-rescue-and-recovery-of-casualties-from-cs/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 3 Award in Supervising Teams Undertaking Work in Confined Spaces - 6160-05 - This course is designed to provide delegates with enough understanding of Safe Systems of Work to be able to authorise works and issue permits. It identifies the employer’s responsibilities within their own policies to allocate duties to competent employees. To achieve this qualification the delegate must hold the level 2 qualification relevant to their own work environment including the use confined space equipment. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-05-city-guilds-level-3-award-in-supervising-teams-undertaking-work-in-confined-spaces/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 4 Award in Plan, Manage and Review Legislative and Safety Compliance for Work in Confined Spaces - 6160-06 - This course focuses on planning, organizing and managing work safely in confined spaces including legislative roles and responsibilities, health and safety considerations and equipment requirements. Designed for managers that are responsible for organizing and planning work activities within a confined space. The manager may or may not supervise the actual job. The manager cannot enter the confined space. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-06-level-4-award-in-plan,-manage-and-review-legislative-and-safety-compliance-in-cs/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 3 Award in Control Entry and Arrangements for Confined Spaces (High Risk) - 6160-04 - This course is designed to provide delegates that need to enter medium and high risk confined spaces with an in-depth understanding of legislation, regulations and safe systems of work. This course includes recognising all risk levels of confined spaces. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-04-level-3-award-in-control-entry-and-arrangements-for-confined-spaces-(high-risk)/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to use power tools. By the end of the course delegates will have an understanding of the correct operational procedures of power tools. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

The aim of the CCNSG Safety Passport is to ensure a basic knowledge of health and safety for all site personnel to enable them, after appropriate site induction, to work on site more safely with lower risk to themselves and others. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346 or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 2 Award in Working in High Risk Confined Spaces - 6160-03 - This course is designed to provide delegates that need to enter medium and high risk confined spaces with an in-depth understanding of legislation, regulations and safe systems of work. This course includes recognising all risk levels of confined spaces. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-03-city-and-guilds-level-2-award-in-working-in-high-risk-confined-spaces/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City and Guilds level 2 Award in Entrant and Entry Controller for Confined Spaces (Medium Risk) - 6160-09 - This course is designed to provide delegates that need to enter confined spaces and hazardous areas with an in-depth understanding of the Legal requirements and the associated legislation, hazard identification and suitable control measures. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-09-city-and-guilds-level-2-award-in-entrant-and-entry-controller-for-confined-spaces-(medium-ri/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346