17049 Other courses in Manchester delivered Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' 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 in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 classroom, one to one, tailored and bespoke courses. Tailored In company training: 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel 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

Autism is a lifelong developmental disability that affects how a person communicates with and relates to other people around them. According to the National Autistic Society, autism affects about 700,000 people in the United Kingdom, which equates to 1 in 100 of the population and the number of children being diagnosed with the condition is continuing to increase. This course will provide you with an understanding of what autism is and how it affects a child's daily life. It will touch on what factors contribute towards a child developing autism as well as some of the typical behaviours associated with it and how you can provide effective support for those with the condition. It also discusses what happens during the diagnosis process, some of the intervention methods that can help manage the condition and suggests some simple adaptations you can make to improve a child with autism's day to day life.

Working safely is in the interest and concern of all staff, both employers and employees. Health and safety is one of the few areas where the law places specific duties specifically on employees so a knowledge of where this applies and how to ensure that it is adhered to is vital to protect individuals and businesses. Most workers feel that accidents are something that only happens to other people. The reality is that too many workers are coming to harm by not observing Health and Safety laws and not working to safe systems of work - the physical, mental and financial burden of these accidents can have a huge impact on themselves, their families and their colleagues. The course covers a wide range of topics including fire safety, asbestos awareness, working at height, COSHH, PPE and electricity. It also covers methods for improving safety performance and methods of protecting the environment.

The all new NASM Women’s Fitness Specialization (NASM-WFS) will deliver your next step in fitness programming knowledge to meet the needs of your female clients. Whether it’s your own interest in the topic or wanting to better address the fitness needs of women, the NASM-WFS gives you the insights to confidently design safe and effective programming to support women on their fitness and health pursuits across various ages and life stages. Unlike other women’s fitness courses you may have encountered, the NASM-WFS is a comprehensive program that dives into the many health and fitness topics that women want to know more about – and do something positive about!

Looking to advance your career in electrical inspection and testing? Our comprehensive 2391-52 Inspection & Testing Online Course is designed for electricians, electrical engineers, and professionals in the field. Gain your City & Guilds qualification with our streamlined approach. Enrol now for just £210.00 and get access to expert guidance and study materials. Prepare at your own pace and excel in your final examinations!

Introduction to Cardiovascular Disease (2-Day Course)Course Description:BBO Training has responded to numerous requests for a course focused on cardiovascular disease, following the success of our previous courses, such as Introductions to COPD/Asthma/Diabetes and Minor Illness. In response, we have developed a comprehensive two-day agenda on this critical subject.These days are designed to provide a holistic approach to cardiovascular diseases, encompassing Coronary Heart Disease (CHD), Stroke, Heart Failure, and Hypertension. Participants will gain the knowledge and skills necessary to perform annual reviews for patients with these conditions.This course is particularly well-suited for Nurse Associates, Practice Nurses, Nurse Practitioners (NPs), Emergency Nurse Practitioners (ENPs), Paramedics, and Pharmacists. Dr. Tamara Cunningham, an experienced GP Trainer, will lead these interactive online sessions.Day One09.15 - Coffee and Registration09.30 - Introduction and Course Objectives09.45 - Setting the Scene: - Screening, Diagnosis, Pathophysiology, and Symptoms10.30 - Q-Risk Assessment10.45 - Coffee Break11.00 - Diet & Cardiovascular Disease: - Healthy Eating - Range of Dietary Approaches - Weight Management Services (PH25)11.45 - Benefits of Activity for Cardiovascular Disease12.30 - Lunch01.30 - Hypertension - A Review of NICE Guidelines (NG136): - Targets - Risk Assessment - Medications - Assessing Target Organ Damage02.45 - Lipid Modification - A Review of Nice Guidelines (NG181): - How Lipids Affect Cardiovascular Risk03.15 - Case Studies03.30 - Action Plan, Evaluation, and Resources03.45 - CloseDay Two09.15 - Coffee and Registration09.30 - Heart Failure - How to Perform a Safe Annual Review (NG106)10.45 - Coffee Break11.00 - CHD - Performing an Annual Review and Including Assessment of Angina12.30 - Lunch01.30 - Stroke - Secondary Prevention and Management of Long-Term Complications02.30 - Case Studies - Group Work to Consolidate Learning03.30 - Competencies, Training, and Resources03.45 - CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the basic physiology of cardiovascular disease.2. Perform risk assessments with patients and discuss modifiable factors such as diet and exercise.3. Describe the targets for blood pressure and cholesterol and how these affect primary and secondary prevention of CVD.4. Describe the basic anti-hypertensive and cholesterol-lowering medications involved in CVD.5. Name the major complications that may arise in people with a long duration of CVD and measures that may limit or prevent them.6. Describe the key advice to patients regarding Heart Failure and recognition of when to escalate/refer.7. Perform a safe review for stroke, CHD, and HF, recognizing how to work within your professional limits and when to signpost.8. Provide examples of referral pathways to other services, e.g., weight management, secondary care, activity, and psychological services.9. Explain the key components and process of an annual review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective cardiovascular disease care within primary care settings.

There’s nothing like a long, slow jog to burn those calories, right? Well, continuous cardio workouts might not actually be the only answer to your cardio training needs. From HIIT to Tabata, learn about other types of cardio training that can offer equal or greater benefits.

Anti Money Laundering (AML) Did you know that the term "Money Laundering" actually has its origins in the 1920s when notorious gangster Al Capone tried to hide his illegal income from the government by running it through a series of laundromats? The idea was that dirty money from illegal activities would be mixed in with the legitimate earnings of the laundromat and come out "clean" on the other end. Hence, the term "Money Laundering" was born. What other courses are included with this Anti Money Laundering Specialist Training? Course 01: Anti Money Laundering (AML) Regulation for AML Officers Diploma Course 02: English Law and Legal System Level 3 Course 03: Understanding Wills and Probate Laws - Level 2 Course 04: Level 3 Tax Accounting Course 05: Financial Investigator Course 06: Business Analysis Level 3 Course 07: GDPR Data Protection Level 5 Course 08: Compliance & Business Risk Management Course 09: Effective Communication Skills Course 10: Time Management Course 11: Decision Making Benefits you'll get choosing Apex Learning for this Anti Money Laundering: One payment but lifetime access to 11 CPD courses of this Anti Money Laundering Bundle Certificates and student ID for the Anti Money Laundering course are included in a one-time fee Full tutor support is available from Monday to Friday with this Anti Money Laundering Bundle Accessible, informative modules of Anti Money Laundering bundles are designed by expert instructors Learn Anti Money Laundering Training at your ease - anytime, from anywhere Study the Anti Money Laundering course from your computer, tablet or mobile device CPD accredited Anti Money Laundering Bundle course - improve the chance of gaining professional skills So enrol now in this Anti Money Laundering Bundle to advance your career! The curriculum of Anti Money Laundering Specialist Bundle Course 1: Anti Money Laundering (AML) Regulation for AML Officers Diploma 01: Introduction to Anti Money Laundering 02: Proceeds of Crime Act 2002 03: Development of Anti Money Laundering Regulation 04: Responsibility of the Money Laundering Reporting Office 05: Risk-based Approach 06: Customer Due Diligence 07: Record Keeping of Anti Money Laundering 08: Suspicious Conduct and Transactions 09: Awareness and Training CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anti Money Laundering Specialists Requirements Anti Money Laundering Specialists Career path Anti Money Laundering Specialists Certificates Certificate of completion Digital certificate - Included PDF Certificate: Free (Previously it was £6*11 = £66) Certificate of completion Hard copy certificate - £9.99 Hard Copy Certificate: Free (For The Title Course: Previously it was £10) To get the Hard copy certificates of other courses, then you have to Pay £9.99 for each

Ofqual Regulated Qualification | Awarded By Focus Awards Limited | 100% Online Course | FREE Certificate, Assessment & 20 Premium Courses | Expert Support

Pricing can determine whether your business succeeds or fails – yet too many entrepreneurs rely on guesswork or back-of-the-napkin calculations to set prices. This learning stream reveals a proven methodology for developing a pricing strategy, as well as ways to increase customer perceptions of value so you can justify higher prices and boost margins. As part of the process, you’ll learn how investors evaluate pricing strategies, the advantages and drawbacks of different pricing models, how to calculate margins, average margins for specific industries and retail categories, how to gauge price sensitivity, and how to build a pricing profile specific to your offering based on eight key variables. Tips and examples are included for both product- and service-based businesses, as well as businesses that contend with seasonal pricing variations. The session offers guidance on bundling, discounting, and other pricing techniques, which you can apply in a workshop session that walks through the pricing strategy framework step by step.