5525 Courses in London delivered Live Online

This course is aimed at health and social care staff who are both registered and unregistered, who work with or support individuals where safeguarding concerns are a possibility.

Get strategies for developing numeracy and literacy across the curriculum.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

When used effectively, questioning is a useful teaching and learning strategy. During this workshop we will discuss how questioning can be used effectively to assess, challenge and stretch pupils progress.

THE course for practitioners of the Integrated Local Delivery framework (ILD)

Join us for this exciting online event where you can gain a Level 4 Award in Understanding the External Quality Assurance of Assessment Processes and Practice. Whether you're new to the field or looking to enhance your skills, this event is perfect for you.

Our comprehensive online course offers a deep dive into Urban and Rural Driving, Working at Height. Whether you are a seasoned driver or just starting out, this training will equip you with essential knowledge and skills to navigate various road conditions safely and efficiently. Urban and Rural Driving, Working at Height Training Content: Urban Driving Techniques: Develop strategies for navigating busy city streets, including managing traffic congestion, negotiating junctions, and adhering to specific urban regulations. Rural Road Safety: Learn how to adapt your driving style for rural roads, including handling narrow lanes,unpredictable bends, and potential hazards like livestock and wildlife. Working at Height: Learn essential training on safe practices for working at height, covering risk assessments, equipment usage, and compliance with safety regulations. Learn to identify hazards, use fall protection systems, and ensure a safe working environment. Join us to enhance your vehicle safety knowledge, compliance with legal requirements, and improve your driving skills in diverse environments. Register today to be better prepared for a wide range of driving challenges. Please review our Terms and Conditions for more information.

P402 Surveying and sampling strategies for asbestos in buildings is the industry standard qualification for asbestos surveyors. In addition to holding the qualification, asbestos surveyors are required to undertake and provide evidence of annual refresher training.

Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.