55167 Courses delivered Online

AS YOU DELIVER THIS INFORMATION, YOU ARE COACHED TO IMPROVE YOUR PUBLIC-SPEAKING STYLE IN THESE (AND A FEW OTHER) AREAS: BODY LANGUAGE, POSTURE, WORD CHOICE, CONFIDENCE, EYE CONTACT, VERBAL TICS/FILLER WORDS, AND VOLUME. You will be coached to overhaul your content and visual aids (frequently PowerPoint) used during the presentation by: stating your purpose clearly, reducing the amount of text on slides, making messages more user-friendly, and choosing best graphics to support message. Attendees Will Be Able To: * Increase ability to motivate the audience by delivering organized and engaging presentations; * Gain more efficiency by crafting carefully-worded, streamlined messages, free of verbal tics and filler words; * Increase enthusiasm through focus on body language and stage presence; and * Convince listeners with strong evidence presented in speech and visual aids. Online Format—Advanced Presentation Skills is a 4-hour interactive virtual class for up to six people. REGISTER FOR THIS CLASS AND YOU WILL BE SENT ONLINE LOGIN INSTRUCTIONS PRIOR TO THE CLASS DATE. -------------------------------------------------------------------------------- The Diversity Sensitivity & Awareness workshop was excellent. It provided a unique approach to addressing the topic. The session was interactive, interesting and very informative, leaving participants with a greater understanding of the merits of diversity and an inspiration to continue to broaden that knowledge base. Sandra Hess Moll, Director of Employment Services / Affirmative Action CoordinatorMcHenry County College

In this series of 2-hour workshops, you'll learn practical strategies to improve relationships with your team and stakeholders, ensuring smoother and more successful project delivery. Each session includes knowledge-sharing and hands-on activities. Attendance is limited to foster connections with like-minded project managers.

We're passionate about equipping churches to respond to domestic abuse. Our Domestic Abuse Awareness course will help you explore key questions around the issue of domestic abuse, like how to recognise the signs of domestic abuse, why domestic abuse happens, and how to start supporting survivors.

Monthly free to attend support group for people with hoarding behaviour. Facilitated by Founder/Chair Megan Karnes. Provides both psychological and practical support.

OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: * Writing DAX formulas. * Defining calculated tables and columns. * Defining measures. * Using DAX iterator functions. * Modifying filter context. * Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: * Understand Analytic queries in Power BI * Create calculated tables, calculated columns and measures * Use DAX functions and operators to build DAX formulas * Use DAX iterator functions * Create formulas that manipulate the filter context * Use DAX time intelligence functions WHO IS THE COURSE FOR? * Analysts with experience of Power BI wishing to develop more advanced formulas in DAX * Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup * Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI * Create a measure * Use variables in the measure definition Lab 3 Add Calculated Table And Columns * Duplicate a table * Create a hierarchy * Create a date table * Add calculated columns Lab 4 Add Measures To Power BI Desktop Models * Add an implicit measure to a report * Add an explicit measure * Add a compound measure * Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model * Complex summarization * Higher grain summarization * Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models * Apply Boolean expression filter * Remove filters: use ALL * Remove filters: use AllSelected * Preserve filters: use KeepFilters * HASONEVALUE * ISINSCOPE * Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models * TOTALYTD * SAMEPERIODLASTYEAR * Calculate new occurrences * Snapshot calculations

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. Why choosing Mindmaps Wellbeing is a good choice for your mental health training. The MHFA England RRP is £325pp, our rate is £300pp and our fee includes: ✅ Instructor led training sessions over two days ✅ Course Manual ✅ Workbook ✅ Handy Cue Card ✅ MHFAider Certificate upon completion Plus, exclusively when you choose Mindmaps Wellbeing, it also includes: ✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life). ✅ Access to our online MHFAider peer support groups moderated by the instructor team. ✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider. ✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available. For a little extra: ✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. ✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - USING VBA TO SOLVE BUSINESS PROBLEMS * Topic A: Use Macros to Automate Tasks in Excel * Topic B: Identify Components of Macro-Enabled Workbooks * Topic C: Configure the Excel VBA Environment 2 - AUTOMATING REPETITIVE TASKS * Topic A: Use the Macro Recorder to Create a VBA Macro * Topic B: Record a Macro with Relative Addressing * Topic C: Delete Macros and Modules * Topic D: Identify Strategies for Using the Macro Recorder 3 - GETTING HELP ON VBA * Topic A: Use VBA Help * Topic B: Use the Object Browser to Discover Objects You Can Use in VBA * Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - CREATING CUSTOM WORKSHEET FUNCTIONS * Topic A: Create a Custom Function * Topic B: Make Decisions in Code * Topic C: Work with Variables * Topic D: Perform Repetitive Tasks 5 - IMPROVING YOUR VBA CODE * Topic A: Debug VBA Errors * Topic B: Deal with Errors * Topic C: Improve Macro Performance 6 - CONTROLLING HOW AND WHEN MACROS RUN * Topic A: Prompt the User for Information * Topic B: Configure Macros to Run Automatically 7 - DEVELOPING CUSTOM FORMS * Topic A: Display a Custom Dialog Box * Topic B: Program Form Events 8 - USING VBA TO WORK WITH FILES * Topic A: Use VBA to Get File and Directory Structure * Topic B: Use VBA to Read Text Files * Topic C: Use VBA to Write Text Files 9 - USING VBA TO CLEAN AND TRANSFORM DATA * Topic A: Automate Power Query * Topic B: Transform Data Using VBA and Workbook Functions * Topic C: Use Regular Expressions * Topic D: Manage Errors in Data 10 - EXTENDING THE PROGRAMMING ENVIRONMENT BEYOND THE WORKBOOK * Topic A: Run Other Programs and Commands * Topic B: Share Your VBA Projects

Duration 3 Days 18 CPD hours This course is intended for This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITIL© 4 Foundation certification and who want to prepare for ITIL© 4 Foundation exam. Overview By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITIL© Practices, and the new Service Value Chain that incorporate the core of ITIL© version 4. ITIL© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITIL© 4. This course will earn you 21 PDUs. This class includes an exam voucher. 1 - ITIL 4 OVERVIEW * Introduction to ITIL * Key Concepts of ITIL 2 - THE ITIL FRAMEWORK * The Four Dimensions of Service Management * The ITIL Service Value System 3 - THE ITIL GUIDING PRINCIPLES * Focus on Value * Start Where You Are * Progress Iteratively with Feedback * Collaborate and Promote Visibility * Think and Work Holistically * Keep It Simple and Practical * Optimize and Automate 4 - THE ITIL SERVICE VALUE SYSTEM (SVS) * Governance * The Service Value Chain * Continual Improvement 5 - KEY ITIL PRACTICES * Continual Improvement * Service Level Management * Change Control * Incident Management * Service Request Management * Service Desk * Problem Management 6 - OTHER ITIL PRACTICES * General Management Practices * Service Management Practices * Technical Management Practices

LOOKING FOR: ADULT FICTION, NON-FICTION Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency.  With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character’s life and be swept into the narrative as if she’s been there all along. She’s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She’s open to these ideas being explored in a variety of ways, but at the moment, she’d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too. In non-fiction, she’s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you’d never thought you would be. She’d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking. She’s not currently taking on YA, children’s, fantasy or science fiction projects. Sian would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words) of your manuscript in a single word document.  (In addition to the paid sessions, Sian is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk [agent121@iaminprint.co.uk] to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline 20and note that I Am In Print take no responsibility for the advice received during your agent meeting. Please prepare to submit your manuscript immediately you book as the submission deadline is now: Monday 8 July 2024

During this 12 week course you will have the opportunity to work on your own project ideas to explore your different media choices.