Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 73 lectures • 10:39:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00
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 A Legal Secretary or PA plays a crucial role in reducing costs and the success of legal professionals. Moreover, with technological advances and fierce competition in the law industry, the demand for the Legal Secretary and PA is constantly rising. To become a legal secretary or PA, you need to acquire certain office skills and learn multiple laws such as- business law, international law, employment law, etc. This Legal Secretary and PA Training cover all these office skills and branches of law to help you take your first step to become one. Moreover, this bundle will also help you better understand your roles and responsibilities as a Legal Secretary or PA. This Legal Secretary and PA Training online course consist of our 11 high-ranked courses: Course 1: Legal Secretaries Advanced Diploma Course 2: Business Law Course 3: Contract Law UK Level 3 Course 4: Employment Law Level 3 Course 5: International Law Course 6: Medical Law Course 7: Family Law 2021 Course 8: Understanding Wills and Probate Laws - Level 2 Course 9: Criminal Law and Criminology Diploma Course 10: Level 2 Effective Minute Taking Course Course 11: Office Skills All through this Legal Secretary and PA Training online course, you will comprehend the concept of Legal Secretary or PA, including - Legal Secretaries Advanced Diploma Comprehend the whole idea of legal secretary Get a solid understanding of meeting management and minute taking Recognise the roles and responsibilities of a Legal Secretary or PA Business Law Acquire fundamental knowledge about Business Law Be fully aware of the Court System Familiarise with the Law of Tort Contract Law UK Level 3 Get comprehensive knowledge about UK Laws A firm grasp of the employee contracts Recognise solutions for any contract breach Employment Law Level 3 Apprehend the fundamental of Employment Law Be conscious of discrimination in the workplace Gain knowledge about workplace monitoring and data protection International Law Grasp a solid understanding of the notion of International Law Comprehend the International Law of Human Rights Be thoroughly aware of Territory and Jurisdiction 6. Medical Law Get an elaborate introduction to Medical Law Hold a fundamental understanding of the legislation on Coronavirus Comprehend the legislation on public health and health service Family Law 2021 Be well acquainted with Family Law Get the hang of gender equality in family law Perceive the Feminist Perspectives on Family Law Understanding Wills and Probate Laws - Level 2 Get a detailed introduction to Estate and Wills Gain a clear understanding of Revocation of Wills Acquire knowledge about the power of attorney Criminal Law and Criminology Diploma Identify different classifications of crimes Gain Knowledge about the legal workplace & professionals Understand the criminal justice system in England and Wales Level 2 Effective Minute Taking Course Know how to prepare for minute taking Learn the roles and responsibilities of minute taker Build up unbreakable confidence Office Skills Get complete knowledge about the receptionist's duties Master the art of communication skills Get the hang of other required office skills You are just a click away from stepping into the most affluent industry! Click that add to basket button now! What You Get Out Of Studying With Apex Learning? Lifetime access to Legal Secretary and PA Training bundle materials Full tutor support is available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative video modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams Study the course from your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential Curriculum: Course 1: Legal Secretaries Advanced Diploma Legal Secretary Meeting Management & Minute Taking Other Secretarial Roles and Responsibilities Customer Service Role Telephone Etiquette Organizing Work Using MS Word Proof Reading Course 2: Business Law Understanding Business Law European Community Law The Court System Civil and Alternative Dispute Resolution Contract & Business Law Employment Law Agency Law Consumer Law and Protection Law of Tort Business Organisations Company Law Business Property Competition Law Course 3: 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 4: 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 5: International Law Basics of International Law Sources of International Law International Law and Municipal Law International Organisations International Law of Human Rights Private International Law International Criminal Law Law of Treaties Territory and Jurisdiction Law of the Sea International Commercial Law International Environmental Law Course 6: Medical Law An Introduction to Medical Law Legislation on Access to Health, Medical Report, Treatment Legislation on Adult Support Legislation on Public Health and Health Service (Part 1) Legislation on Public Health and Health Service (Part 2) Legislation on Public Health and Health Service (Part 3) Legislation on Public Health and Health Service (Part 4) Legislation on Coronavirus Legislation on Mental Health (Part 1) Legislation on Mental Health (Part 2) Legislation on Abortion Other Legislation (Part 1) Other Legislation (Part 2) Course 7: Family Law 2021 Introduction to Family Law Framing Family Law Marriage in Family Law Civil Partnership and Cohabitation Nullity in Marriage Divorce and Family Law Child Custody Property and Finance on Divorce Child Support and Family Law Adoption Process Domestic Violence Gender Equality in Family Law Feminist Perspectives on Family Law Course 8: Understanding Wills and Probate Laws - Level 2 An Introduction to Estate and Wills Making a Will Trusts and Dispositions Intestacy Probate Correcting Errors in a Will Revocation of Wills Power of Attorney Course 9: Criminal Law and Criminology Diploma Classification of Crime UK Law & Legal System Understanding Criminal Psychology Dealing with Crime Forensic Science Criminal Profiling: Science, Logic and Metacognition Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice The Legal Workplace & Professionals Criminal Law The Criminal Justice System in England and Wales Course 10: Level 2 Effective Minute Taking Course Introduction to Minute Writing Preparation for Minute Taking The Meeting Structure Minute Meeting, Decision and Action Roles and Responsibility of Minute Taker Tips for Minute Taking Technology in Minute Taking Building Confidence Course 11: Office Skills Introduction to Reception and Receptionist Business Telephone Skills Representing Your Boss and Company Mail Services and Shipping Travel Arrangements Organising Meeting and Conferences Time Management Record Keeping and Filing Systems Business Writing Skills Organisational Skills Communication Skills Customer Service Effective Planning and Scheduling Invoicing/Petty Cash Business Environment Advanced MS Excel How will I get my certificate? After successfully completing the bundle, you will be able to order your certificates as proof of your achievement. ***For a limited period of time, we are offering a flat 100% discount on the certificates.*** ***Hurry Up Before Its Over*** PDF Certificate: Free (Previously it was £10*11 = £110) Hardcopy Certificate: Free (Previously it was £15*11 = £165) CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Legal Secretary and PA training bundle is carefully put together for those passionate about starting their career in the Law Industry and also for those who want to educate themselves about different laws to avoid any trouble in the future. Hence, this course is appropriate for- Students Fresh Graduates Job Seekers Job Holders Entrepreneurs Requirements If you are reading this, it means you already have all the requirements to enrol for this Legal Secretary bundle; a stable internet connection and a smart device! Anybody with any academic or professional background can take up this Legal Secretary and PA Training course. Career path Completion of this Legal Secretary bundle will pave the way to different career opportunities for the learners; few examples: Legal Assistant Legal Administrative Assistant Legal Receptionist Legal Admin Assistant Legal Receptionist Legal Support Assistant Legal Administrator Team Legal Secretary For these career opportunities, the average salary generally varies from £15,000 to £40,000 a year. Certificates Certificate of completion Digital certificate - Included
Master the essentials of wound care with our comprehensive training course. Explore the wound healing process, types of wounds, dressing techniques, and wound assessment. Ideal for healthcare professionals and caregivers looking to enhance their knowledge and skills in wound management.
Gain the knowledge and skills for safe and effective intravenous therapy with our "Intravenous Administration of Fluid and Medication" course. Ideal for healthcare professionals administering IV fluids and medications.
Duration 5 Days 30 CPD hours This course is intended for Built for IT Professionals working with Citrix ADC and Gateway, with little or no previous Citrix networking experience. Potential students include administrators, engineers, and architects interested in learning how to deploy or manage Citrix ADC or Citrix Gateway environments. Overview Identify the functionality and capabilities of Citrix ADC and Citrix Gateway Explain basic Citrix ADC and Gateway network architecture Identify the steps and components to secure Citrix ADC Configure Authentication, Authorization, and Auditing Integrate Citrix Gateway with Citrix Virtual Apps, Citrix Virtual Desktops and other Citrix components Expand your Citrix networking knowledge and skills by enrolling in this five-day course. It covers Citrix ADC essentials, including secure load balancing, high availability and operations management, and also focuses on Citrix Gateway. You will learn to deliver secure remote access to apps and desktops integrating Citrix Virtual Apps and Citrix Desktops with Citrix Gateway Getting Started Introduction to Citrix ADC Feature and Platform Overview Deployment Options Architectural Overview Setup and Management Basic Networking Networking Topology Citrix ADC Components Routing Access Control Lists ADC Platforms Citrix ADC MPX Citrix ADC VPX Citrix ADC CPX Citrix ADC SDX Citrix ADC BLX High Availability Citrix ADC High Availability High Availability Configuration Managing High Availability In Service Software Upgrade Troubleshooting High Availability Load balancing Load Balancing Overview Load Balancing Methods and Monitors Load Balancing Traffic Types Load Balancing Protection Priority Load Balancing Load Balancing Troubleshooting SSL Offloading SSL Overview SSL Configuration SSL Offload Troubleshooting SSL Offload SSL Vulnerabilities and Protections Security Authentication, Authorization, and Auditing Configuring External Authentication Admin Partitions Monitoring and Troubleshooting Citrix ADC Logging Monitoring with SNMP Reporting and Diagnostics AppFlow Functions Citrix Application Delivery Management Troubleshooting Citrix Gateway Introduction to Citrix Gateway Advantages and Utilities of Citrix Gateway Citrix Gateway Configuration Common Deployments AppExpert Expressions Introduction to AppExpert Policies Default Policies Explore Citrix ADC Gateway Policies Policy Bind Points Using AppExpert with Citrix Gateway Authentication, Authorization, and Secure Web Gateway Authentication and Authorization Multi-Factor Authentication nFactor Visualizer SAML authentication Managing Client Connections Introduction to Client Connections Session Policies and Profiles Pre and Post Authentication Policies Citrix Gateway Deployment Options Managing User Sessions Integration for Citrix Virtual Apps and Desktops Virtual Apps and Desktop Integration Citrix Gateway Integration Citrix Gateway WebFront ICA Proxy Clientless Access and Workspace App Access Fallback SmartControl and SmartAccess for ICA Configuring Citrix Gateway Working with Apps on Citrix Gateway RDP Proxy Portal Themes and EULA
Duration 5 Days 30 CPD hours This course is intended for This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are: Entry-level network engineer Network administrator Network support technician Help desk technician Overview This course will help you: Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network Gain a foundation in the essentials of networking, security, and automation Earn 30 CE credits toward recertification The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 Cisco© Certified Network Associate (CCNA©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification. Course Outline Exploring the Functions of Networking ? Lecture Introducing the Host-to-Host Communications Model ? Lecture Operating Cisco IOS Software ? Lecture Introducing LANs ? Lecture Exploring the TCP/IP Link Layer ? Lecture Starting a Switch ? Lecture Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture Explaining the TCP/IP Transport Layer and Application Layer ? Lecture Exploring the Functions of Routing ? Lecture Configuring a Cisco Router ? Lecture Exploring the Packet Delivery Process ? Lecture Troubleshooting a Simple Network ? Lecture Introducing Basic IPv6 ? Lecture Configuring Static Routing ? Lecture Implementing VLANs and Trunks ? Lecture Routing Between VLANs ? Lecture Introducing OSPF ? Lecture Building Redundant Switched Topologies ? Self-study Improving Redundant Switched Topologies with EtherChannel ? Lecture Exploring Layer 3 Redundancy ? Self-study Introducing WAN Technologies ? Self-study Explaining Basics of ACL ? Lecture Enabling Internet Connectivity ? Lecture Introducing QoS ? Self-study Explaining Wireless Fundamentals ? Self-study Introducing Architectures and Virtualization ? Self-study Explaining the Evolution of Intelligent Networks ? Lecture Introducing System Monitoring ? Lecture Managing Cisco Devices ? Lecture Examining the Security Threat Landscape ? Self-study Additional course details: Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.