Report Writing 1 Day Training in Sheffield
Emotional Intelligence 1 Day Training in Sheffield
This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access
This QA Level 2 Award in citizenAID (RQF) course is a half-day course to teach the skills and knowledge needed in case one finds themselves in the middle of a terrorist attack. The skills are also usable in any event where there might be either multiple or severely injured people. Past attendees said: Attended the citizen aid course this week, absolutely brilliant. Whilst we all hope that we are never involved in a major incident, the big question though would be are we prepared, what would we do? This course discusses various incidents and some are uncomfortable to think about, but if something happened most people panic, after this course you are likely to stay calm, take control and above all save lives. This course is for everyone due to the current threats in the world, However large companies especially should consider training their staff, it may save your life or someone close to you. Highly recommended, well presented and really interesting. Benefits of this course: Following several terrorist attacks that have claimed the lives of countless victims and left many in hospital with critical injuries, both in the UK and abroad, it has been clear that normal, everyday people can save each other's lives with the right levels of training This course, together with the citizenAID Phone App and a pocket guide, has been designed by both highly experienced military and civilian clinicians This course will teach you what to do during a terrorist-related, or 'simply' a serious accident, where casualties can suffer from severe trauma. It is specifically designed to help people react safely, prioritise the injured and give life-saving first aid to the casualties RUN - HIDE - TELL - TREAT Watch this short, 4 ½ minute video by the Counter Terrorism Police UK on how to stay as safe as possible during firearms and weapons attacks Whether work is causing or aggravating mental health problems, employers have a legal responsibility toward their employees Fortunately, these events are rare, but when they do happen, being prepared can save your life, and that of others Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable This half-day course gives people a good awareness of mental health in the workplace Better still, of course, is to do this citizenAID course with us, which will help a lot more! Course Contents Active shooter or knife attacker scenario Shooting incident Suspect bombs Exploded bomb Casualty first look Severe bleeding Tourniquets Haemostatic Dressings Unresponsive casualty Broken Bones Burns Casualty handover Accredited, Ofqual regulated qualification Our citizenAID course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards and taught by an experienced trainer. This means that you can rest assured that your citizenAID training is of high quality. The Ofqual Register number for this course is 603/1934/3.
This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson
This qualification aims to provide expert guidance to learners wishing to gain knowledge and understanding on Electric Vehicle charging equipment installation. This 2 day course provides expert guidance on EV charging equipment installation, an important emerging area which is not covered in detail by the current edition of the Wiring Regulations (BS 7671) or the IET’s Guidance Notes. Aimed at experienced electricians interested in understanding a wide range of equipment and systems available, this course applies to the specialised installation requirements of electric vehicle charging equipment in domestic dwellings, on-street locations, commercial and industrial premises. The course provides detailed guidance and recommendations on all aspects of the installation of Electric Vehicle Charging Equipment from the origin of the electrical supply, through distribution and final circuits, installation of the charging equipment itself to the cable between the charging equipment and vehicle’s electrical inlet. Also included are related issues of site layout and planning and subsequent inspection, testing, certification and maintenance of installations. Why take this course? Currently there is an increasing demand for new electric vehicle charging points but too few installers to roll them out. This is already a booming market which is due to get much bigger in the near future. The number of public charging connectors and locations has increased by 38% in the past 12 months and is expected to continue at that rate for years to come. Entry Requirements There are no formal entry requirements for this qualification, however we do expect you to meet the following requirements: Minimum age 18 years old (mandatory) Must be able to demonstrate the following competencies Be able to correctly install and terminate: pvc/pvc cable (twin and earth) Steel Wire armoured cable (swa) Be able to carry out an initial verification (inspection & testing) on an electrical installation and complete the necessary paperwork. Please Note: These competencies are required for the assessment and are not taught as part of the course. It is also recommended that you are up to date with your wiring regulations.
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
What past delegates said: "I started looking for a course in education and training when I was offered a chance to help deliver some health & safety training in my local area - I was incredibly lucky to have found Ottilia Pochat Training. Ottilia has a wealth of experience in teaching, and she managed to share those skills and techniques with us in a way that was both incredibly informative and fun! I can’t recommend Ottilia Pochat Training highly enough - why wouldn’t you want to learn how to teach from the best?" This course is fully tutor-led and teaches you how to become a good, quality trainer Virtual Classroom, this course is run over 8 weeks: 16 sessions of 2½ hour duration, from 10:00 -12:30 and 13:30 - 16:00 The virtually run course starting on Friday 7 July will be held over 8 consecutive Fridays Face to Face: Five-day course Run by a Dutch teacher who spent 4 years learning to teach and has international teaching experience in working with all age groups Course Contents Roles and responsibilities in education and training Ways to maintain a safe and supportive learning environment Relationships between teachers and other professionals Boundaries between the teaching role and other professionals Points of referral to meet the individual needs of learners Inclusive teaching, including:Ways to create an inclusive teaching and learning environmentCreating an inclusive teaching and learning planJustifying own selection of teaching and learning approaches, resources and assessment methods in relation to individual learner needsUsing teaching and learning approaches to meet learner needsEvaluating the delivery of inclusive teaching and learning including areas for improvementDelivering inclusive teaching and learning to meet individual needs Communicating with learners in a way that meets their needs Understanding assessment in education and training, including:Different methods of assessment and how they can be adapted to meet individual learner needsHow to involve learners and others in the assessment processThe role and use of constructive feedbackRecord keeping of assessments Benefits of this course: This Ofqual regulated course will allow you to work in adult education Or even, run online training sessions With this course, you'll also be able to run professional workshops Accredited, Ofqual regulated qualification Our QA Level 3 Award in Education and Training (RQF) Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can rest assured that your level 3 Award in Education and Training fulfils the legal requirements to kick-start your own career in Education and Training. The Ofqual Register number for this course is 603/2770/4
QA Level 2 Award In Food Safety In Catering (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations. Accredited, Ofqual regulated qualification Our Food Safety in Catering training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Food safety in Catering certificate fulfils the legal requirements and is a very good way to make sure your employees are trained in Food Safety. The Ofqual Register number for this course is 603/2594/X
QA Level 2 Award In Food Safety For Retail (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations.