This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
Airway Management Airway Management Training Course Three Hours Cost: £50 + vat per person This 3-hour course will equip learners with the necessary skills, knowledge and expertise on how to manage a casualty’s airway in the event of an emergency. The course is suitable for First Aiders, pre-hospital care providers and those working in high-risk environments. SYLLABUS A range of subjects is covered, including: The respiratory system Principles of airway management Airway examination and assessment The airway management ladder Practical training CERTIFICATION Although there is no formal assessment, the trainer will assess each individual throughout the course and issue a non-regulated certificate of achievement where the required level of attainment has been met. NUMBERS A maximum of 16 students can be accommodated on this course. Age limit Learners must be a minimum of 16 years of age to attend the course. First Aid • Life-Saving Skills First Aid Training is not just a Course; it’s a life-saving skill everyone should possess. It’s about being prepared for the unexpected knowing how to respond when seconds count. As Health & Safety Law mandates, employers must create a secure and healthy environment for their employees. This responsibility extends to providing immediate and effective First-Aid Care when necessary. We understand that learning is best achieved through practical application. That’s why we offer In-Person Workshops on First Aid. These workshops provide hands-on experience under the guidance of our highly qualified trainers. You’ll have the opportunity to practice what you’ve learned in a controlled environment before you need to apply it in real life. Upon completion of a First-Aid Qualification, employers can be assured that they have highly-trained personnel capable of responding swiftly and effectively to any First-Aid needs. This fulfils legal obligations and contributes to a safer, more caring work environment for all. In essence, the First Aid Certification is more than just a qualification; it’s an investment in the health and safety of your workforce.
Paediatric First Aid Emergency Paediatric First Aid One Day Course Cost: £75 + vat per person This one-day Emergency Paediatric First Aid course has been designed for those interested in Child and Infant Basic Life Support, including parents, guardians and family members. The purpose of the qualification is for the learner to attain the knowledge and practical competence required to deal with a range of Paediatric First Aid. The FAA Emergency Paediatric First Aid qualification is Unit 1 of the two-day FAA Paediatric First Aid qualification. From gaining this Emergency Paediatric First Aid qualification, learners could progress to completing Unit 2 and being awarded the 2-day FAA Award in Paediatric First Aid. The qualification is designed for learners with a responsibility for the Care of Children and Babies. It provides knowledge and skills to deal with a range of Paediatric First Aid conditions and incidents. SYLLABUS Role of the Paediatric First Aider Primary survey Resuscitation (CPR including the safe use of an AED) Wounds, bleeding and shock Seizure Choking Minor injuries Recovery position Maximum of 12 People Students must be a minimum of 16 years of age to qualify. Numbers A maximum of 12 students can be accommodated on this course. CERTIFICATION The qualification is valid for three years from the date of achievement. It is recommended that the learner attends annual refresher training. The learner will need to complete the full course again to re-qualify for a further three years. First Aid • Life-Saving Skills First Aid Training is not just a Course; it’s a life-saving skill everyone should possess. It’s about being prepared for the unexpected knowing how to respond when seconds count. As Health & Safety Law mandates, employers must create a secure and healthy environment for their employees. This responsibility extends to providing immediate and effective First-Aid Care when necessary. We understand that learning is best achieved through practical application. That’s why we offer In-Person Workshops on First Aid. These workshops provide hands-on experience under the guidance of our highly qualified trainers. You’ll have the opportunity to practice what you’ve learned in a controlled environment before you need to apply it in real life. Upon completion of a First-Aid Qualification, employers can be assured that they have highly-trained personnel capable of responding swiftly and effectively to any First-Aid needs. This fulfils legal obligations and contributes to a safer, more caring work environment for all. In essence, the First Aid Certification is more than just a qualification; it’s an investment in the health and safety of your workforce.
Paediatric First Aid Paediatric First Aid at Work Two Day Course Cost: £125 + vat per person This course has been developed for those who are working with children and infants. It will be of particular interest to teachers, child minders, crèche assistants, playgroup personnel and anyone else who has a responsibility for their welfare whilst in your care. The purpose of the qualification is for the learner to attain the knowledge and practical competence required to deal with a range of paediatric first-aid situations. This two-day qualification fulfils the requirements for first aid training detailed in the Department for Education’s statutory framework for the Early Years Foundation Stage. SYLLABUS A range of subjects is covered, including: Role of the Paediatric First Aider Primary survey Resuscitation (CPR including the safe use of an AED) Wounds, bleeding and shock Allergic reactions including anaphylaxis Head, neck and back injuries Seizure Choking Minor injuries Recovery position Fractures Foreign bodies Diabetic emergencies Asthma Meningitis Febrile convulsions Extreme cold and heat Electrical incidents Maximum of 12 People Students must be a minimum of 16 years of age to qualify. Numbers A maximum of 12 students can be accommodated on this course. CERTIFICATION The qualification is valid for three years from the date of achievement. It is recommended that the learner attends annual refresher training. The learner will need to complete the full course again to re-qualify for a further three years. First Aid • Life-Saving Skills First Aid Training is not just a Course; it’s a life-saving skill everyone should possess. It’s about being prepared for the unexpected knowing how to respond when seconds count. As Health & Safety Law mandates, employers must create a secure and healthy environment for their employees. This responsibility extends to providing immediate and effective First-Aid Care when necessary. We understand that learning is best achieved through practical application. That’s why we offer In-Person Workshops on First Aid. These workshops provide hands-on experience under the guidance of our highly qualified trainers. You’ll have the opportunity to practice what you’ve learned in a controlled environment before you need to apply it in real life. Upon completion of a First-Aid Qualification, employers can be assured that they have highly-trained personnel capable of responding swiftly and effectively to any First-Aid needs. This fulfils legal obligations and contributes to a safer, more caring work environment for all. In essence, the First Aid Certification is more than just a qualification; it’s an investment in the health and safety of your workforce.
This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: Appreciate why errors occur Understand how stress and other factors can affect focus and accuracy Know how to improve accuracy and reduce errors when handling text and data Be able to proof-read text and number-based documents more accurately 1 The importance of accuracy The impact of mistakes Why accuracy is so important Main reasons why errors occur 2 Attentiveness theory The 'capacity' and 'bottleneck filter' models Selective attention Chunking - big picture / little picture 3 Preparing for accuracy Working styles - how they affect detail-orientation Identifying and minimising the impact of stress on concentration 4 Practical strategies How to improve accuracy and reduce errors when inputting text Managing interruptions and distractions Proofing text and numbers
Severe allergic reactions (anaphylaxis) can kill without immediate first aid. The UK is one of the top countries in the world for incidence of allergies. This course covers the management of anaphylaxis and the use of auto-injectors for the initial treatment of anaphylaxis.
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report
This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document
This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security
This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint