788 Courses delivered On Demand

Course Highlights: This qualification is equivalent to GCSE grade C or 4 Take the Exam from Home – Guaranteed Fast Track Results Exam Booking within 2 Working Days of Enrolment Remote Exam Online or Paper based both options available Course Duration: 55 hours Unlimited Access to Course Materials Get Free Mock Tests & Free Past Papers Extra 25% Time for people with Learning Difficulties NCFE, Pearson Edexcel, Open Awards and TQUK are all OFQUAL-regulated and nationally recognised Exam slots are available 24*7 from Monday to Sunday. If you are in a rush and would like to book your exam sooner, then you can book your remote online exam within 3 working days for Open Awards, 2 working days of enrolment for NCFE and within 7 working days for Pearson Edexcel. Please note the exam price advertised on the website for the Open Awards remote invigilation exam is applicable for weekdays (Monday to Friday between 9 am to 5 pm). If you would like to book the Open Awards remote invigilation exam at the weekend then there is an additional £25+Vat applicable. The new assessment and result dates by NCFE are: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: On-screen and RI Assessment date to and from: 16/09/2024 – 25/10/2024 Results release: 01/11/2024 The new assessment and result dates by Open Awards is: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: Remote Assessment date to and from: 02/09/2024 – 13/09/2024 Results release: 11/10/2024 Delivery mode: Remote Assessment date to and from: 04/11/2024 – 15/11/2024 Results release: 13/12/2024 (Note that this only applies to the mentioned exam type and if you book the exam during the dates mentioned above. Also, this will not affect the schedule of the other exam types and results.) Christmas Holiday Information For our remote invigilation service of Functional Skills qualifications, the last accepted booking will be on 19th December 2024. We will reopen for bookings from 3rd January 2025. Results Release For Open Awards: Any results from assessments taken after 30th November 2024 will be published after 2nd January 2025. For NCFE Exams: Results from assessments taken after 11th December 2024 will also be published after 2nd January 2025. Additionally, the period between 20th December 2024 and 2nd January 2025 will not be counted as “working days” for the result release timeframes. Please plan your assessment bookings accordingly. Our last results release prior to Christmas will be on 20th December 2024, with the next results release taking place on 3rd January 2025. Why is this course right for you? Our expert designed Functional Skills Maths Level 1 Course has smart learning options that provide the necessary numeracy knowledge and skills to excel in Functional Skills Maths. Our course is tailored to meet your specific needs and help you achieve your academic and career goals from the comfort of your home. You also get the opportunity to book Live 1:1 tutor support via Microsoft Teams. With interactive lessons, FREE mock test, personalised feedback and remote exams, our Maths Level 1 Course ensures a comprehensive and engaging learning experience. Exam Details Exam slots are available 24*7 from Monday to Sunday. If you are in a rush and would like to book your exam sooner, then you can book your remote online exam within 3 working days for Open Awards, 1 working day of enrolment for NCFE, 2 working days of enrolment for TQUK and within 7 working days for Pearson Edexcel. Please note the exam price advertised on the website for the Open Awards remote invigilation exam is applicable for weekdays (Monday to Friday between 9 am to 5 pm). If you would like to book the Open Awards remote invigilation exam at the weekend then there is an additional £25+Vat applicable. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre On-Screen Exam in Centre Remote Online Exam – From Home Results Edexcel Book within 15 days Book within 24 Hours Book within 7 working days Get results in 20 working days NCFE Book within 10 working days Book within 24 Hours Book within 2 working days Get results in only 7 days Open Awards N/A N/A Book within 2 working days Get results in only 16 working days TQUK Book within 7 working days Book within 24 Hours Book within 2 working days Get results in only 6 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Difference between NCFE, Pearson Edexcel and Open Awards and TQUK NCFE, TQUK, Pearson Edexcel and Open Awards are OFQUAL-regulated and nationally recognised; however, the only difference lies in the exam booking and result turn-around time. You can book your remote online exam within 2 working days of enrolment for NCFE, within 7 working days for Pearson Edexcel, 2 working days of enrolment for TQUK and within 3 working days for Open Awards. You can get your NCFE results in 7 days, your Edexcel results in 20 working days, your TQUK results in 6 working days and your Open Awards results within 16 working days. Universities and apprenticeships accept all of the awarding bodies. This distinction allows learners to choose the awarding body that aligns best with their educational and career goals. How This Course Will Work? This Level 1 Functional Skills Maths course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This level 1 maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. However, you will require a laptop/desktop computer and a good internet connection. Exam Structure The Functional Skills NCFE, Pearson Edexcel and Open Awards Qualification in Mathematics at Level 1 consist of one externally assessed assessment that comprises two sections- a non-calculator section (calculator prohibited) and a calculator section (calculator permitted). The assessments are available as paper-based and onscreen, on-demand assessments. Section A (Non-calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 25 minutes 16 25% NCFE / Open Awards / TQUK 30 minutes 15 25% Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 1 hour 30 minutes 48 75% NCFE / Open Awards / TQUK 1 hour 30 minutes 45 75% Pass Mark (Edexcel): Learners are required to achieve an overall (from sections A and B) (59%) mark to pass the exam. Pass Mark (NCFE): Learners are required to achieve an overall (from sections A and B) (57% – 62%) mark to pass the exam. Please note that the marks vary for individual exam papers, so for all the exam papers, the pass marks are not fixed for the NCFE exam. Pass Mark (Open Awards): Pass Marks for L 2 functional skills maths assessments vary per assessment version and are set following standardisation and awarding activities. Each Maths assessment is designed to enable a minimally competent learner to achieve a pass mark of 36 out of 60. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Pass Mark (TQUK): Pass Marks for level 1 functional skills maths assessments vary per assessment version and are set following standardisation and awarding activities. Recognised Accreditation This Functional Skills Maths Level 1 has been independently accredited by Pearson Edexcel, NCFE, TQUK and Open Awards, also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. NCFE is a charity and awarding organisation that provides qualifications in England, Wales, and Northern Ireland. It is regulated by Ofqual in England and recognised in Wales and Northern Ireland. Open Awards is an awarding organisation that offers a wide range of qualifications across various sectors, including education, health and social care, and business. Their qualifications are regulated by Ofqual and are designed to meet the needs of learners and employers. Open Awards also works closely with educational institutions and employers to ensure their qualifications are relevant and up-to-date. TQUK is an awarding organisation approved by Ofqual and offers RQF courses in a variety of sectors. RQF courses have different credit values that can be applied to the National Credit Transfer System. TQUK accredits courses developed by industry experts and collaborates with organisations to ensure the quality and value of the courses provided. Additional Features  Access to On-Demand Classes Opportunity to Book 1:1 Live Tutor Support via Zoom Enrol in Our Course and Prepare for the Exam from Home Get a Free Mock Test with Professional Feedback Course Curriculum Unit 1: Number Lesson 1.1: Numbers and the Number System The number system gives you a general insight into the mathematical operations regarding the given numbers. You will acquire skills in division, multiplication, addition and subtraction, which require steps in real-life contexts. Lesson 1.2: Fractions and Decimals You will be learning many types of fractions, including improper fractions, proper fractions, equivalent fractions and more. Along with this, you will learn Ordering Decimal Numbers, Subtracting Decimals, multiplying and dividing decimals and more, which enables you to apply real-world problem-solving. Lesson 1.3: Percentages You will learn to calculate the Percentage and how to express a Number as a Percentage of Another. Interpreting the Original Value, Calculating Percent Increase and Decrease, and so on. This learning you can easily apply in real-life counting issues along with increasing your rational thinking. Lesson 1.4: Ratio and Proportion You will be learning to calculate the Total Amounts using Ratios, direct Proportion, Inverse Proportion and many more things, which help you in doing comparisons, learning science and engineering, and more. Lesson 1.5: Formula You will learn the definition of formulas Formula Using Words, Multi-Step Formulas, Formula Using Letters and so on. Learning formulas has a large impact on real life as these formulas are used extensively in measuring, building infrastructure and more. Unit 2: Measures, Shapes and Space Lesson 2.1: Money Math You will be mastering Solving Money Related Questions, including percentage-based discounts, discounts Related to Fractions, Profit and Percentage, etc. This money math learning will help you to understand money-earning and saving-related issues that you face in daily activities. Lesson 2.2: Units You will learn units and Types of Units, Units of Weight, Units of Length, Units of Capacity, etc. Also, you will gain knowledge about steps to convert between Metric Units, Imperial to Imperial Conversions, and Other Unit Conversions will help pursue a higher university degree. Lesson 2.3: Speed and Density You will be clearing the concept of speed, calculations to find out distance and time, density, Relation between Density, Weight and Volume. Lesson 2.4: Perimeter You will learn to find perimeter and area, Circle, perimeter of triangle etc. which require in measurement, design and planning and so on. Lesson 2.5: Area and Shapes You will gain skills in formulas for calculating area, finding areas of complex shapes, applying area calculations in complex questions, different Types of 3D Shapes, surface area, finding the surface area of complex 3D Shapes, using nets, plans and elevations, etc. learning about area and shapes will certainly help you in building your dream home and more. Lesson 2.6: Volume In the volume classes, you will learn Formulas for calculating volume, Questions based on volumes of different 3D Shapes, finding the Scale in a Diagram, Making Scale Drawings, which are required in building critical thinking skills and more. Lesson 2.7: Coordinates & Angles You will be learning necessary things about the coordinate Grid, How to Read Coordinates on a Grid? Plotting Points on a Grid and more which extensively requires in making video games, medical imaging, physics and more Unit 3: Handling Data and Information Lesson 3.1: Median and Mode You will be learning about median and mode, which is one of the most interesting mathematical chapters. As you will know how to find the median and mode from the sets of numbers, you can easily implement such learning in household work and other places as well. Lesson 3.2: Mean and Range You will be able to find the mean, median and mode. Knowing how to find these is highly important in all aspects of life. Lesson 3.3: Probability You will learn Probability: Definition and Meaning, Calculating Probabilities, Probability of Something Happening and Something Not Happening, etc. Once you know how to find probability, you can easily detect business profit loss and implement other parts of your life. FAQs The Functional Maths level 1 Course is equivalent to? The Level 1 course is a fundamental level of proficiency in English, Maths, and ICT that is equivalent to a GCSE grade 1 to 3 (formerly G to D grades). It is a nationally recognised qualification in the UK that provides an alternative to GCSEs for individuals who still need to pass these subjects during their secondary education. Why should I take the Functional Skills Maths instead of the GCSE Maths? The functional maths course is comparatively easier than the GCSE math and additionally the value of it is also more than the GCSE math course. However, you should select the course that suits your needs, as both courses provide different values at different places. Which one is more difficult between Functional and GCSE Maths courses? The functional skills Maths course is more flexible than the GCSE math course since you have to sit for the official exam in the GCSE courses. What is the Difference between Functional Skills and GCSE? A Functional skills course develops for the one who wants to learn Math, English and ICT for individual achievement in daily work place and on the other hand, GCSE focuses on theories and tests your academic ability. How will I access the functional skills Maths level 1 course after payment? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with StudyPlex. Will I get access to the Course if my location is outside the UK? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having an accredited certificate once you face the corporate world. As employees, job places, and more value the accredited certificate, you must own this certificate by doing the course with us. What are the system requirements for remote exam? For Pearson Edexcel and NCFE: To sit your assessment, you’ll need: A laptop/desktop with webcam and microphone; you can’t sit the assessment on a tablet or smartphone a good Wi-Fi connection – recommended minimum 1Mbit/s Upload, minimum 10Mbit/s Download. You MUST use google chrome browser for the exam, as this is recommended by the awarding body. A smartphone or tablet (Apple iOS 8.0 / Android 4.1 or higher) - this will be used to record you taking the assessment. A suitable environment - quiet room with no distractions The link for the assessment sent to your email; remember to check your spam/junk folder. You must activate Airplane mode on your smartphone however you need to be connected to Wi-Fi, so turn on Airplane mode then reactivate your Wi-Fi. Please familiarise yourself with the potential violations as these can potentially lead to the assessment being voided. Ensure ALL equipment is plugged in (including phone for the recording of sessions). Loss of power at any point could lead to the assessment being voided. You must brief other members of your household/workplace that you’re sitting an assessment, and they must not enter the room at any point. There is a 24-hour live chat function within the assessment software for technical support should you need it at any time. For Open Awards: In order to take your exam, you need to have the following equipment: A good quality laptop or PC with a minimum screen size of approx. 14” and minimum resolution of 1024 x 768. A stable internet connection with at least 3mbps. An integrated (i.e., fixed) webcam on your PC/ laptop or a portable webcam. If using a PC/ laptop with an integrated webcam, a reflective surface (e.g., a mirror) must be available. This will be used to show the invigilator the space immediately surrounding your screen and keyboard. A basic (non-scientific) calculator for maths assessments. You will have access to an on-screen calculator but may feel more comfortable using a separate calculator. Please note that all workings need to be added to the assessment platform if you use a separate calculator so that your workings can be marked. Plain paper. You will need to show this to your invigilator at the beginning of the exam to assure them that you do not have access to notes. A dictionary (where allowed). Supported Browsers Chrome: 34.0.1847 or above Microsoft Edge: Version 88.0.705.81 or newer Firefox: 31.0 or above Safari: 6.2 or above Safe Exam Browser 2.0.2 or above Please note: Chromebooks are not compatible with the Safe Exam Browser Browser settings Popups must be allowed. Guidance on how to do this below: Chrome Edge Firefox Safari For TQUK: Exam conditions All remote exams must take place in a controlled environment. Training Qualifications UK (TQUK) defines a controlled environment as a quiet, appropriate space conducive to the undertaking of a remotely invigilated exam. The environment must be: populated only by you, the learner, and no other parties well-lit to allow maximum webcam visibility free from distractions that may cause you to divert your attention away from the computer screen or move outside of the webcam’s viewing range free from notes and posters on the wall free from noise free from personal or sensitive material free from visual or physical access to supporting materials (such as educational texts) free from electronic devices, other than the computer used to undertake the exam. The space, as described above, must meet these requirements throughout the entire duration of the exam. If the exam conditions requirements are not met, the exam may be voided. If, for any reason, you are unable to undertake the exam in a space that meets these requirements, you should inform your training provider/recognised centre at the earliest opportunity and arrange your exam at a time when these conditions can be met. You must have a desktop or laptop computer that is equipped with a working webcam, a stable internet connection, and the Google Chrome web browser (available here). Requirements and guidance for materials: The following relates to materials within the controlled environment and must be followed to ensure compliance: Mobile phones and electronic devices, except for the computer you are using to undertake the exam, must be switched off and stored in an inaccessible location. Smartwatches and other wearable technological devices must be switched off and removed. Headphones must not be worn. Water must be stored in a clear glass or a clear bottle with the labels removed. No other food or drink is permitted. Second monitors are not permitted. Identification must be clearly presented to the camera at the start of an exam. If identification is not provided, or is unclear, at the start of the exam, this will result in the exam being voided. A room sweep must be completed at the start of an exam. If a room sweep is not completed, the exam will be voided.

Medication management is a vital part of caring roles, requiring clear knowledge of how medicines work, interact, and affect individuals. This mini bundle covers pharmacy technician basics, biology, chemistry, lab techniques, and essential communication skills. Designed specifically for carers, it offers a rounded introduction to medication concepts and their role in care delivery. From understanding the science behind medications to effectively communicating about medicine schedules, this training supports carers working in diverse environments. Whether managing records or assisting with medication awareness, you’ll gain confidence through structured learning and practical information presented clearly and accessibly. It’s all online, focused, and built around supporting your vital role without any unnecessary jargon. Learning Outcomes: Understand medication types and their effects on the human body. Explore basic biological processes linked to medication use. Recognise chemical principles behind common pharmaceuticals. Learn laboratory techniques related to medication handling. Develop clear communication skills for medication support. Identify safety measures and recording procedures for carers. Who Is This Course For: Carers responsible for medication administration and supervision. Healthcare assistants supporting patient medicine routines. Home care workers assisting with medication reminders. Support staff managing medication records and documentation. New carers seeking structured medication knowledge. Residential care workers handling medicine awareness duties. Health and social care assistants needing basic pharmacology. Anyone supporting clients with medication schedules. Career Path (UK Average Salaries): Healthcare Assistant – £23,500 per year Care Worker – £22,000 per year Medication Support Worker – £25,000 per year Pharmacy Technician Assistant – £27,000 per year Residential Care Officer – £23,000 per year Support Worker – £24,000 per year

The Veterinary Assistant Diploma 8-in-1 bundle equips you with the right skills to walk confidently into any veterinary support role. By combining Veterinary Assistant, Dog Basics, Animal Care, Dog Grooming, Proofreading, Minute Taking, Telephone Etiquette, and Health and Safety, you’ll be both job-ready and workplace polished. Veterinary employers want someone who can support animal needs while also navigating the fast-paced, detailed world of reception, reporting, and scheduling. That’s why this bundle packs it all in. Plus, with Compete High rated 4.8 on Reviews.io and 4.3 on Trustpilot, you're learning with quality that others already trust. Description The modern vet assistant needs range. That’s exactly what this Veterinary Assistant Diploma delivers. From pet support knowledge like Dog Basics, Animal Care, and Dog Grooming, to essential workplace disciplines like Minute Taking, Telephone Etiquette, and Proofreading, this course prepares you to do more than just assist—you’ll be essential. You’ll build confidence in every key area of veterinary operations, from Health and Safety and Animal Care, all the way to clear Telephone Etiquette and accurate Minute Taking. The balance of clinical, clerical, and customer-facing skills makes this bundle ideal for those who want to break into the field and instantly contribute. Whether it’s recording precise notes with Minute Taking, maintaining top Health and Safety practices, or presenting yourself with impeccable Telephone Etiquette, you’ll be prepared for it all—without needing to invest in multiple courses. Now is the time. Get job-ready before someone else beats you to it. FAQ Q: Is this suitable for total beginners? A: Absolutely. Whether you're new to Veterinary Assistant work or transitioning from another field, this bundle is your first and best step. Q: What kind of jobs does this help with? A: Roles like Vet Assistant, Animal Care Support, or admin-based positions within animal clinics, where Proofreading, Health and Safety, and Dog Basics are essential. Q: Will this give me a competitive edge? A: Yes. The blend of Dog Grooming, Telephone Etiquette, and Veterinary Assistant makes you a prime candidate for versatile roles.

Cosy Corner Conversations are part of the our community: Mindful Heart Connections: (https://create-harmony.cademy.io/mindful-heart-connections) where we meet online to meditate, be mindful, be inspired and share our thoughts and experiences. Here I provide a short recording which gives you a taste of a Cosy Corner Experience, provided in the community. Why not curl up under a blanket on a comfortable chair, with a cuppa, a notepad and enjoy listening to this calming recording to help you walk the path of mindfulness. Taking time to heal our hearts, soothe our minds and relax our body, so that we can live with more love, compassion and peace.

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This comprehensive course on HashiCorp Vault will make you an expert in deploying, configuring, and managing all key Vault services. It covers all objectives for passing the HashiCorp Certified: Vault Associate certification exam. Learn the latest HashiCorp concepts and master the core components to become a HashiCorp Vault expert.

The Control and Administration of Medication is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Control and Administration of Medication consists of several modules that take around 6 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts.

Content Marketing Level 2 Course Overview Take your digital content strategy to the next level with our Content Marketing Level 2 course — a hands-on, instructor-led training designed for learners who want to deepen their understanding of content creation, video production, SEO, email marketing, and social media management. Whether you're a budding marketer, small business owner, or creative professional, this course equips you with the practical tools and techniques needed to build authority, attract an audience, and drive conversions. From optimising blog articles for SEO to scheduling your posts using HootSuite, this course covers it all with real-time examples and actionable strategies. Learn at your own pace, develop career-ready skills, and earn a CPD-accredited certificate to showcase your growth in the competitive digital marketing space. Extra Included: Lifetime Access Free Student ID Card Learning Outcome Understand the step-by-step process of planning and outlining high-quality content Learn tools and best practices for recording professional video and audio Discover cost-effective ways to create a high-quality content background Master email marketing strategies like Soap Opera and Seinfeld sequences Optimise articles for SEO using readability tools and real-time analysis Explore content syndication through social platforms with HootSuite Get hands-on experience managing and automating your social media posts Learn how to outsource content tasks efficiently through Fiverr Why Choose This Course This course offers a well-rounded and practical learning experience in content marketing, delivered by industry professionals. Whether you're working solo or part of a team, the flexible, online structure of this course ensures you can study anywhere, anytime. With expert-led tutorials and real-world tools, you’ll build the confidence to plan, create, optimise, and distribute content that truly connects with your audience. Who is this Content Marketing Level 2 Course for? This course is ideal for digital marketers, content creators, small business owners, and aspiring freelancers looking to enhance their online presence. It’s also perfect for professionals who want to expand their content marketing skills to include SEO, email strategies, and social media automation — all within one streamlined course. Entry Requirements There are no formal entry requirements for this course. Anyone with an interest in content marketing can enrol. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Efficient minute taking is the unsung hero of productive meetings. This CPD Accredited Course is designed to guide learners through every aspect of the minute-taking process, from initial preparation to final documentation. Whether you're recording board meetings, team huddles or informal discussions, this course equips you with a structured approach to capture essential points with clarity and accuracy. You’ll learn how to organise your notes, understand meeting structures, and document decisions and actions in a clear, concise format that’s easy for others to follow. Throughout the course, you'll explore key elements such as roles and responsibilities, confidence building, and the use of technology in modern minute taking. With a focus on professional communication and time-efficient methods, this course is ideal for anyone responsible for documenting meetings or looking to refine their organisational communication skills. By the end, you'll be well-prepared to handle any meeting with confidence and precision, producing minutes that are timely, relevant, and action-focused. What you will learn from the Minute Taking - CPD Accredited course: Demonstrate in-depth knowledge of the role of the Minute-Taker Understand the key elements that make a meeting successful Identify the stages of minute taking and steps to arranging a meeting List all the things that should be included in a meeting agenda Deal with stressful meetings and conversations that go off-track Address all matters arising and close a meeting successfully Manage meeting tasks and chase up action items effectively Creating a Minutes template and distributing notes to all attendees Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Introduction to Minute Writing Module 02: Preparation for Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision and Action Module 05: Roles and Responsibility of Minute Taker Module 06: Tips for Minute Taking Module 07: Technology in Minute Taking Module 08: Building Confidence Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Minute Taking - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Minute Taking - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Minute Taking - CPD Accredited training.

Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00