789 Courses

Create a Gatsby.js Progressive Web App with GraphQL, React, and WordPress and add JAMstack to your skills

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Certificate in Compliance will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Certificate in Compliance will help you keep ahead of the pack. The Certificate in Compliance incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Certificate in Compliance will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while at the same time it outlines essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Certificate in Compliance, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Certificate in Compliance course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Certificate in Compliance Bundle Consists of the following Premium courses: Course 01: Training of Compliance Officer Level 3 Course 02: Paralegal Course 03: Corporate Risk And Crisis Management Course 04: Employment Law Level 3 Course 05: Contract Law UK Level 3 Course 06: Payroll Administrator and UK Payroll System Training Course 07: GDPR Data Protection Level 5 Course 08: Internal Audit Training Diploma Course 09: Financial Investigator Course 10: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 11: Workplace Safety Course So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Certificate in Compliance: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Certificate in Compliance Bundle Course 01: Training of Compliance Officer Level 3 Introduction to Compliance Compliance Management System Basic Elements of Effective Compliance Compliance Audit Compliance and Ethics Introduction to Risk and Basic Risk Types Further Risk Types Introduction to Risk Management Risk Management Process Risk Assessment and Risk Treatment Types of Risk Management Course 02: Paralegal Understanding the Concept of Paralegal Key Legal Terminology Effective Communication Skills for Paralegals The Legal Workplace & Professionals Law & Legal Systems Contract & Business Law Property Law Wills, Probate, Estate Law Criminal Law Common Paralegal Legal Matters Human Rights Conflict and Conflict Resolution Professional Conduct and Ethics of Paralegals Mandatory Knowledge Fields and Survival Tips for Paralegals Course 03: Corporate Risk And Crisis Management Module 01: Introduction to Risks and Risk Analysis Module 02: Process of Risk Analysis and Management Module 03: Corporate of Risk Management Module 04: Managing Financial Risks Module 05: Introduction to Crisis and Crisis Management Module 06: Crisis Response and Communication Module 07: Incidents Management and Emergency Response Plan Module 08: Crisis Management Team Module 09: Post Crisis Phase Course 04: Employment Law Level 3 Basic of Employment Law Legal Recruitment Process Employment Contracts Employee Handbook Disciplinary Procedure National Minimum Wage & National Living Wage Parental Right, Sick Pay & Pension Scheme Discrimination in the Workplace Health & Safety at Work Dismissal, Grievances and Employment Tribunals Workplace Monitoring & Data Protection Course 05: Contract Law UK Level 3 Introduction to UK Laws Ministry of Justice Agreements and Contractual Intention Considerations and Capacities of Contact Laws Terms within a Contract Misinterpretations and Mistakes Consumer Protection Privity of Contract Insurance Contract Laws Contracts for Employees Considerations in International Trade Contracts Laws and Regulations for International Trade Remedies for Any Contract Breach Course 06: Payroll Administrator and UK Payroll System Training Module 01: Payroll System in the UK Module 02: Payroll Basics Module 03: Company Settings Module 04: Legislation Settings Module 05: Pension Scheme Basics Module 06: Pay Elements Module 07: The Processing Date Module 08: Adding Existing Employees Module 09: Adding New Employees Module 10: Payroll Processing Basics Module 11: Entering Payments Module 12: Pre-Update Reports Module 13: Updating Records Module 14: e-Submissions Basics Module 15: Process Payroll (November) Module 16: Employee Records and Reports Module 17: Editing Employee Records Module 18: Process Payroll (December) Module 19: Resetting Payments Module 20: Quick SSP Module 21: An Employee Leaves Module 22: Final Payroll Run Module 23: Reports and Historical Data Module 24: Year-End Procedures Course 07: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 08: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Internal Control and Control Risk Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor Course 09: Financial Investigator Introduction to Financial Investigator Introduction to Financial Investigation Characteristics of Financial Crimes Categories of Financial Crimes Financial Crime Response Plan Collecting, Preserving and Gathering Evidence Laws against Financial Fraud Course 10: Fraud Management & Anti Money Laundering Awareness Complete Diploma Introduction to Money Laundering Proceeds of Crime Act 2002 Development of Anti-Money Laundering Regulation Responsibility of the Money Laundering Reporting Office Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training Course 11: Workplace Safety Course Health and Safety at Work and the Laws Managing for Health and Safety Risk Assessment and Common Risks Workplace Health, Safety and Welfare Accidents and Ill Health at Work Electrical, Fire and Gas Safety Safety in Different Work Settings Work Equipment Hazards and Risk Control Other Health and Safety Hazards at Work CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Certificate in Compliance bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Certificate in Compliance is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Training of Compliance Officer Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Understanding financial management is crucial for the success of any business. In fact, studies have shown that poor financial management is one of the leading causes of business failure. That's why our Payroll, Tax, Accounting & Business Administration bundle is so important. Whether you're looking to enhance your CV or boost your business acumen, our bundle has something for everyone. Dive into the world of payroll management and gain an in-depth understanding of the intricacies of employee compensation. Develop your accounting skills with our introduction to accounting and accounting and tax courses, and learn to use Xero Projects & Job Costing software like a pro. Our Employment Law Level 3 and Certificate in Anti Money Laundering (AML) courses will give you the knowledge you need to stay on top of regulatory requirements, while our Financial Analysis and Data Analysis in Microsoft Excel Complete Training courses will equip you with the tools you need to make informed business decisions. And it's not just technical skills - our Business Administration Level 3, Decision Making, and Effective Communication Skills Diploma courses will teach you essential soft skills that are vital in any workplace. With hardcopy and PDF certificates included, you'll have tangible proof of your newfound expertise. Invest in yourself and take the first step towards a brighter future. Enrol in our Payroll, Tax, Accounting & Business Administration bundle today. Learning Outcomes of Payroll, Tax, Accounting & Business Administration Upon completion of this course bundle, you will be able to: Gain a comprehensive understanding of payroll management and tax regulations. Develop skills in accounting and financial analysis to make informed business decisions. Learn how to use Xero Projects and Job Costing to manage project finances effectively. Understand employment law and the role of Anti-Money Laundering (AML) regulations in business. Develop proficiency in data analysis using Microsoft Excel. Learn effective communication skills to enhance interpersonal relationships in the workplace. Develop the ability to make strategic business decisions based on critical thinking and problem-solving. Acquire knowledge and skills in business administration to manage and lead a team. This Payroll, Tax, Accounting & Business Administration Bundle Consists of the following Premium courses: Course 01: Payroll Management Course Course 02: Introduction to Accounting Course 03: Accounting and Tax Course 04: Xero Projects & Job Costing Course 05: Employment Law Level 3 Course 06: Certificate in Anti Money Laundering (AML) Course 07: Financial Analysis Course 08: Data Analysis in Microsoft Excel Complete Training Course 09: Business Administration Level 3 Course 10: Decision Making Course 11: Effective Communication Skills Diploma So, enrol now in this Payroll, Tax, Accounting & Business Administration to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses of our Payroll, Tax, Accounting & Business Administration Bundle Certificate, student ID for the title course are included with this Payroll, Tax, Accounting & Business Administration Bundle Full tutor support available from Monday to Friday with this Payroll, Tax, Accounting & Business Administration Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Payroll, Tax, Accounting & Business Administration designed by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the Payroll, Tax, Accounting & Business Administration course from your computer, tablet or mobile device CPD accredited Payroll, Tax, Accounting & Business Administration bundle - improve the chance of gaining professional skills Payroll, Tax, Accounting & Business Administration Curriculum of Payroll, Tax, Accounting & Business Administration Bundle Course 01: Payroll Management Course Payroll System in the UK Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Processing Basics Entering Payments Pre-Update Reports Updating Records e-Submissions Basics Process Payroll (November) Employee Records and Reports Editing Employee Records Process Payroll (December) Resetting Payments Quick SSP An Employee Leaves Final Payroll Run Reports and Historical Data Year-End Procedures Course 2: Introduction to Accounting Section 01: Accounting Fundamental Section 02: Accounting Policies Course 3: Accounting and Tax Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: VAT Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK Course 4: Xero Projects & Job Costing Module 01: Introduction Module 02: Getting Started Module 03: Setting up Staff Module 04: Small Project Example Module 05: Quotes Module 06: Products & Services Module 07: Invoicing Module 08: Reporting Module 09: Bigger Project Example Module 10: Projects and Profit & Loss Module 11: Thank You Course 5: Employment Law Level 3 Module 01: Basic of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination in the Workplace Module 09: Health & Safety at Work Module 10: Dismissal, Grievances and Employment Tribunals Module 11: Workplace Monitoring & Data Protection Course 6: Certificate in Anti Money Laundering (AML) Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 7: Financial Analysis Module 01: Introduction Module 02: Profitability Module 03: Return Ratio Module 04: Liquidity Ratio Module 05: Operational Analysis Module 06: Detecting Manipulation Course 8: Data Analysis in Microsoft Excel Complete Training Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08:Automating Workbook Functionality Module 09:Creating Sparklines and Mapping Data Module 10:Forecasting Data Course 9: Business Administration Level 3 Module 01: Representing Your Boss and Company Module 02: Skills of an Effective Administrator Module 03: Business Writing Skills Module 04: Communication Skills Module 05: Business Telephone Skills Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meeting and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Effective Planning and Scheduling Course 10: Decision Making Module 01: What is Decision Making? Module 02: Stress and Its Impact Module 03: Time Stress and Decision Making Module 04: Personal Level Decision making Under Stress Module 05: Organisational Level Decision making Under Stress Module 06: Decision Making for Conflict Management Course 11: Effective Communication Skills Diploma Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphics Module 06: Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Payroll, Tax, Accounting & Business Administration This Payroll, Tax, Accounting & Business Administration bundle is perfect for: Individuals looking to start a career in accounting and business administration. Accounting and finance professionals looking to upskill and stay up-to-date with industry standards. Business owners or managers looking to gain a deeper understanding of financial management and business administration. Anyone interested in a career in payroll management, financial analysis, or business administration. Those looking to progress into senior roles within accounting and business administration. Requirements Payroll, Tax, Accounting & Business Administration This Payroll, Tax, Accounting & Business Administration course has been designed to be fully compatible with tablets and smartphones. Career path This Payroll, Tax, Accounting & Business Administration bundle will be beneficial for anyone looking to pursue a career as: Payroll Manager: £23,000 - £45,000 per annum. Financial Analyst: £25,000 - £50,000 per annum. Business Administration Manager: £22,000 - £55,000 per annum. Tax Manager: £30,000 - £65,000 per annum. Finance Director: £70,000 - £120,000 per annum. Certificates Certificate of completion Digital certificate - Included

This comprehensive Microsoft Excel 2016 course is designed to take you from a complete beginner to an advanced Excel user, equipping you with essential skills for data analysis, financial modeling, and business productivity. Whether you're managing budgets, analyzing sales data, or automating repetitive tasks, this course provides hands-on training with real-world examples. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of Achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. To pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Who Is This Course For? This course is ideal for beginners with no prior Excel knowledge, office professionals looking to enhance efficiency, students preparing for careers in finance/data, and entrepreneurs managing business data. It’s also valuable for accountants, analysts, and administrative staff seeking to upgrade their skills. Whether for academic, professional, or personal use, this course provides step-by-step training for all levels. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you expand your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Entry Clerk – £18K–£24K Administrative Assistant – £20K–£28K Financial Analyst – £30K–£50K Accountant – £25K–£45K Business Intelligence Analyst – £35K–£60K Excel Trainer / Consultant – £30K–£55K Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Why Prefer this Complete Microsoft Excel Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Complete Microsoft Excel << Module 01: Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Module 02: Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Module 03: Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Module 04: Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Module 05: Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Module 06: Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Module 07: Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 08: Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Module 09: Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Module 10: Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Module 11: Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Module 12: Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Module 13: Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Module 14: Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Module 15: Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Module 16: Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Module 17: Creating Sparklines and Mapping Data Create Sparklines MapData Module 18: Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Module 19: Excel Templates Excel Templates Assessment Process Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

At HFX Training, we are passionate about business simulations because they bring learning to life through hands-on experience. This Level 1 Certification Program is the first step in our Instructor Training Certification Pathway, equipping you to confidently use the Healthcare Hero simulation in your teaching environment. In this program, you will experience the simulation as a student, navigating its complexities and dynamics. Upon successfully completing Level 1, you’ll be ready to advance to Level 2 Training, where you will deepen your expertise in simulation facilitation and administration. The program is cohort-based, and the timetable is coordinated in advance through discussions with the HFX team to ensure maximum participation. For more information on the program structure, instructional materials, and certification requirements, please read on. What to Expect: The Healthcare Hero simulation places you in charge of a fictional hospital. Over eight simulation rounds - each representing one quarter of business operations - you will make strategic decisions to optimize patient care while managing staffing, capacity, quality, and finances. Throughout the simulation, you’ll navigate challenges like healthcare and economic crises, all while balancing the needs of multiple stakeholders. Your ultimate goal is to outperform competing hospitals managed by other participants in the program. Program and Certification Requirements This program equips you to confidently lead the simulation by requiring more than attendance or participation. To earn certification, you must: Thoroughly Prepare: Review all instructional materials and the scenario manual before the course begins. Fully Participate: Attend all Zoom sessions and complete each simulation round with focus and effort. Demonstrate Mastery: Show a comprehensive understanding of the simulation’s dynamics, decision-making processes, and strategies during practice and live rounds. Engage in Reflection: Actively participate in debrief sessions, assess your performance, and identify strategies for improvement. This certification ensures you are equipped to facilitate this complex simulation with confidence. Auditing the course is an option, but participants who choose to audit will not receive certification. Program Format The program is delivered intensively over one or more Zoom sessions, totaling six hours. This compressed format demands your full attention and focus to successfully navigate the simulation’s complexities. Eligibility Requirements: By registering for this training program, you acknowledge the following: You have discussed your needs with the HFX team and confirmed that the simulation aligns with your class or program objectives. You are an instructor at an academic institution. You agree to the confidentiality terms and commit not to distribute, disclose, or replicate any program content for purposes outside of this training. This program is offered in goodwill to academic instructors as a resource to enhance their teaching. As part of this agreement, you understand that all materials, including the simulation itself, are proprietary to HFX and its partners. Any use of these materials for purposes beyond this program, such as developing similar tools or simulations, is strictly prohibited. Course Structure: After registering, you will gain immediate access to the simulation’s instructional materials. This includes: The Scenario Manual: Your guide to understanding the game. The Capacity Planner Worksheet and Financial Planning Worksheet: Tools to help you strategize. The Strategy Planning Exercise: Designed to align your decisions with overall objectives. The Portal Guide: A walkthrough of the simulation platform. The program unfolds in four key phases: Phase 1: Pre Zoom Call / Study / Set Up Register using the button at the bottom of this page. Review the instructional materials thoroughly. Once the cohort is finalized, you will be sent your login credentials for the simulation itself. Try to submit decisions for the first practice round using the simulation portal at www.simulationportal.com. Phase 2: Play We run two practice rounds over the first 2 hours of the zoom call. This allows you to familiarize yourself with the platform and decision-making process, and think through what your strategy might be in the live game. The simulation resets ("zeroed") after the practice rounds. A brief session will clarify lessons learned and expectations for the live rounds. Over eight rounds, you’ll compete against other participants while refining your strategic decisions. Phase 3: Feedback Reflect on your performance during a structured debrief, including: Strengths and areas for improvement. Insights into competitors’ strategies. Strategic lessons learned, and applicability to local healthcare organizations. Phase 4: Implementation Planning Work with the HFX team to plan your first application of the simulation in a teaching environment. Certification Outcome Upon completing this program, you will earn the HFX Instructor Training Certification: Level One, signifying your expertise in conducting impactful simulation-based training using Healthcare Hero.

Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is a useful software you can use to solve your problem. If you want to learn the complete guide on how to become a professional user on Microsoft Excel 2010, then this is the course for you. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Build great charts, use conditional formatting, help identify the trends and bring data together by using Excel 2010. Gain access to new features such as sparklines, improved pivotCharts, slicer, Access spreadsheets from anywhere and many more. Whether you are a beginner or an advanced level user at Microsoft Excel 2010, this course will help you. You will be able to learn all the relevant information on how to analyze numbers, keep track of data, and graphically represent your information using various charts. Course Highlights Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 7 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace. Who is this course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The diploma in Microsoft Excel 2010 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 for Beginners 00:00:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2010 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00