4728 Courses delivered Live Online

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Foundation Day Training in Clinical Hypnosis Refresh. Practise. Connect. Transform. Whether you're just starting your journey in clinical hypnosis or you're a graduate looking to refresh and refine your skills, our Foundation Day Training is the perfect opportunity to reconnect with the core techniques that make hypnosis such a powerful therapeutic tool. 🔁 For Graduates: Reignite your confidence, polish your technique, and deepen your understanding of trance work in a supportive and hands-on environment. 🎓 For Trainees: This immersive day is a practical companion to your eLearning journey. It brings the theory to life with live demonstrations, peer-to-peer hypnotic practice, and real-time feedback—your chance to induce trance for the very first time! 🌀 What You’ll Learn and Practise: Trance Inductions & Deepeners – Multiple approaches, techniques, and live demonstrations. Building Confidence – For both you and your clients. Consultation Skills – Learn how to structure effective client sessions from the very first meeting. Therapeutic Techniques – Grounded in modern clinical hypnosis and NLP. Peer Practice – Hypnotise each other under supervision in a safe, encouraging environment. 💡 Course Highlights: Introduction to the world of clinical hypnosis Health and safety, mental wellbeing, and contraindications of hypnosis The history of hypnosis and NLP, including key pioneers The 3 laws of suggestion and why they matter How to handle common client questions Understanding the power of the mind and the subconscious The basics of suggestion, sensory systems, and rapport building Creating a therapeutic space and planning effective therapy Exploring premature cognitive conditioning and the unique client 🧠 Included: Access to a self-paced eLearning module Weekly live Masterclasses Group practice sessions Peer supervision and support Step into the transformative world of clinical hypnosis with clarity, confidence, and competence. Whether you’re revisiting or discovering it for the first time, Foundation Day is your gateway to lasting change. 👉 Book Your Place Today and take the next confident step in your hypnotherapy journey.

Just like physical first aid, we recommend that Mental Health First Aiders and MHFA Champions attend a Refresher course every three years.

Details *30 min class* Stretch & De-stress will use techniques from Pilates and Yoga and will focus on strength and stretch in a calm environment. Using exercises for spinal mobility and core stability as well as working on those areas affected by modern life. Classes are done via Facebook Live in a closed group so you can join live or replay (as many times as you like) at a time that suits you.   Instructions Find a clear and adequate space in your home with suitable flooring. Wear comfortable clothing and have water nearby. This class is suitable for all ages and abilities but please make sure you work within your own limits and what is safe for you. By joining in these online sessions you are doing so at your own risk. If you have any health concerns or are new to exercise please speak to your doctor before joining in.

Duration 3 Days 18 CPD hours This course is intended for This advanced course is designed for those individuals who are responsible for operating and managing the operation of an IBM i system. Overview Explain the concept of how LPAR works Explain the functions served by the HMC Explain how user versus resource security are implemented Explain the difference between group profiles and authorization lists Describe how adopted authority works Describe how work is managed on the system and the concepts of the performance tuning process on the system Explain how Management Central can be used to manage a single system or a network of System i servers Perform the steps to create a basic CL program using both the traditional (PDM and SEU) and the newer GUI (RSE and LPEX) application development tools Perform the steps to create a menu using SDA Provide some tips on how you can improve your operations This course is designed to enhance the skills of an IBM i System Operator. This course explains the concept of how LPAR works and discusses the functions provided by the HMC LPAR concepts and overview . Console options and HMC overview . IASP concepts and overview . Security concepts and overview . System values . User security (user and group profiles) . Resource security . Authorization lists and adopted authority . Management Central overview . Commands and tasks using Management Central . Inventory using Management Central . System values using Management Central . Other Management Central functions . Work management: Concepts and overview . Work management: Subsystem concepts and overview . Work management: Job processing concepts and interactive jobs . Work management: Job processing concepts of other job types . Work management: Submitting and tracking of batch jobs . Programming concepts . CL programming concepts . Using PDM and SEU to create a CL program . Starting and setting up RSE . Creating a CL program using RSE and LPEX Editor . Creating a menu using SDA . Tips for improved operation .

The main subject areas of the course are: Legislation and guidance for asbestos practitioners. The properties of asbestos and health effects of exposure to asbestos fibres. The types of asbestos and its uses in buildings. The types of asbestos surveys. The asbestos register, risk assessment and management plan. Asbestos remediation. The role of asbestos analysts and laboratory procedures.

Join our OISC Level 1 course which shows you how to become an immigration adviser and helps you to pass the OISC exam by honing your exam technique.

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

The course is a four hour refresher session for those who have completed the Mental Health First Aid two or one day course. Just like physical first aid, we recommend you refresh your skills regularly and keep up-to-date. The four-hour MHFA Refresher course will support MHFAiders® by:  Renewing their skills Updating their knowledge of mental health supports Giving them the chance to practice applying the Mental Health First Aid action plan Providing them access to three years of MHFAider® support and benefits Please note the MHFA Refresher is only for people who have previously complete the MHFA course.Format This is a half day course delivered online Learning takes place through a mix of presentations, group discussions and workshop activities We limit numbers to 25 people per course so that the instructor can keep people safe and supported while they learn What are the MHFAider support & benefits? With access to MHFAider® support and benefits, training doesn't stop when the course comes to an end. We provide continuous support for MHFAiders® – well beyond initial certification – so they are confident, empowered and motivated to carry out their role.  MHFAiders® get automatic 24/7 digital support through the MHFAider Support App®. From there they will find exclusive resources, ongoing learning opportunities and the benefit of joining England’s largest community of trained MHFAiders®.  Access includes:  A resource library of toolkits, guidance, animations and core mental health concepts to support them in their role as an MHFAider® A signposting database through Hub of Hope to find local and national mental health services for additional support Secure conversation journalling to make reflective notes while protecting confidentiality Reminders for wellbeing check ins with the people MHFAiders® are supporting 24/7 text support services through Shout for advice and reassurance on a mental health conversation or to support wellbeing after a difficult conversation Exclusive quarterly webinars to embed and broaden mental health knowledge The benefit of joining England’s largest community of trained MHFAiders®