1577 A2 courses delivered Online

This course covers what you need to know about the Control of Substances Hazardous to Health. It’s aimed at anyone who is exposed to Substances Hazardous to Health at work, as well as line managers with responsibility for such people.

This course outlines exactly what constitutes manual handling and covers the regulations and legislation that apply to manual handling tasks. It then goes on to cover safe handling techniques and how to develop good habits in relation to manual handling. It finishes off by introducing some practical solutions and the use of mechanical aids. Important note: Please note that this is an awareness course only, if your duties include manual handling you will also need further practical training, you can get in touch with us to arrange this.

How Daring to Dialogue Improves Performance and Creates a Culture of Agility The single greatest predictor of success is the way we are having or not having conversations, and if we can learn to be more intentional in how we invite, cultivate, participate, and facilitate conversations there will not be any challenge that an organization cannot skillfully navigate in order to produce effective outcomes. But what if our conversations are stuck or ineffective? What if conversations break down instead of generating new collective thinking? We'll look at conversations and how to use the structure of the conversations to harvest the intelligence that already exists, and the daring role leaders play in creating a space for dialogue in order to greatly change the nature of the discourse. Key Takeaways include: Four actions that everyone can take to foster better conversations Understand the impact of monologue vs dialogue on culture Three ways for leaders to engage in better dialogue starting today

Leading in a Disruptive Age: Don´t Just Manage Projects ... Lead Them How can a leader in today's organization get the right mix across teams, leadership, and the culture that binds them together? This session will cover the latest trends in what drives teams, the disconnects between leaders and their teams, and considerations for building a winning project culture that drives value to both the customer and organization across factors of people, process, and technology. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Comprehensive Teaching Assistant Diploma covering TA roles, SEN, Autism, ADHD, Dyslexia, and Paediatric Care. Ideal for aspiring and current teaching assistants and support staff.

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

This course will start by making it very clear exactly what we mean by customer service, and why it’s so vital and then go into detail about some of the ways you can improve the customer service provided by your organisation.

This course covers the commitments that should be laid out in your company’s anti-harassment and bullying policy so as to comply with UK law. It explains the differences between harassment and bullying, the steps that can be taken if either of these occur in or out of work, and some case studies to illustrate the points covered throughout the course.

This course covers the commitments that should be laid out in your company’s anti-harassment and bullying policy so as to comply with UK law. It explains the differences between harassment and bullying, the steps that can be taken if either of these occur in or out of work, and some case studies to illustrate the points covered throughout the course.

ADHD is a chronic condition that creates a range of persistent symptoms such as difficulty sustaining attention, hyperactivity and impulsive behaviour. The course covers the definitions of ADHD, the different types of ADHD and how to recognise some key signs and symptoms. Beyond this the course will look at some of the possible causes of ADHD, how it is diagnosed and how it can be treated, including environmental changes, types of therapy and medication that can be prescribed.