• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3291 Bar courses in Cardiff delivered Online

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

4.9(27)

By Apex Learning

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. 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 Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
Delivered Online On Demand8 hours 20 minutes
£12

VBA in Excel - Part 2

By Underscore Group

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

VBA in Excel - Part 2
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Functional Skills Entry Level 2 Maths Online Course

By Lead Academy

This Functional Skills Maths Entry Level 2 course will assist you in displaying a solid understanding of the foundational concepts and basic principles of mathematics appropriate to the level, as well as the ability to use mathematical reasoning to solve routine issues in everyday contexts. Course Highlights: Course Type: Self-Paced Online Learning Total Qualification Time: 58 hours Guided Learning: 55 hours Accreditation: Pearson Edexcel Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Assessment: Internally graded and externally verified Access: 1 Year Access Certificate: Certificate upon completion of the official exam (hard copy) Tutor Support: Paid Tutor Support Customer Support: 24/7 live chat available Functional Skills Entry Level 2 Maths Course This Functional Skills Entry Level 2 Maths Course is regulated by Ofqual and accredited by Pearson Edexcel making it a nationally recognised qualification that will enhance your CV, helping you stand out from the rest of the candidates. You will acquire knowledge about the number system, common measures, geometry and handling data. Upon successful completion of this course, you will be able to apply your foundational mathematics knowledge in a range of practical scenarios. Why is this course right for you? This comprehensive Functional Skills Maths Entry Level 2 Course is suitable for: Anyone looking to secure a skill-oriented job People of all ages and academic backgrounds Anyone who wants to progress to functional skills level 1 or 2 Anyone who wants to take GCSE maths Anyone seeking to add a certified qualification to their university application Anyone aspiring to accelerate their career in this sector Anyone who wants to gain in-depth knowledge of functional skills in mathematics Whether you are a beginner into the field of functional maths or any professional seeking to reinforce your expertise in functional skills maths, this Functional Skills Maths Entry Level 2 Course will set you up with the advanced skills to boost your career profile. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre Results Pearson Edexcel Book within 15 days Get results in 20 working days *Offline examinations will be held at our Swindon and London centres. Please contact us  for more information. Functional Skills Entry Level 2 Maths Qualification Purpose and Outcomes This Functional Skills Entry Level 2Maths Qualification will help you to: Develop confidence in their application of basic mathematics concepts and abilities. Prove their understanding by using their abilities and expertise to complete easy tasks or simple mathematical equations. Acquire comprehensive problem-solving and underpinning skills to utilise mathematics in the course of everyday life. Course Curriculum Count reliably up to 100 items Read, write, order and compare numbers up to 200 Recognise and sequence odd and even numbers up to 100 Recognise and interpret the symbols +, –, ×, ÷ and = appropriately Add and subtract two-digit numbers Multiply whole numbers in the range 0 × 0 to 12 × 12 (times tables) Know the number of hours in a day and weeks in a year; be able to name and sequence Divide two-digit whole numbers by single-digit whole numbers and express remainders Approximate by rounding to the nearest 10, and use this rounded answer to check results Recognise simple fractions (halves, quarters and tenths) of whole numbers and shapes Read, write and use decimals to one decimal place Calculate money with pence up to one pound and in whole pounds of multiple items and write with the correct symbols (£ or p) Use metric measures of length, including millimetres, centimetres, metres and kilometres Use measures of weight, including grams and kilograms Use measures of capacity, including millilitres and litres Read and compare positive temperatures Read and use simple scales to the nearest labelled division Recognise and name 2-D and 3-D shapes, including pentagons, hexagons, cylinders, cuboids, pyramids and spheres Use appropriate positional vocabulary to describe position and direction, including between, inside, outside, middle, below, on top, forwards and backwards Sort and classify objects using two criteria Take information from one format and represent the information in another format, including use of bar charts How This Course Will Work? This Functional Skills Entry Level 2 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 Functional Skills Entry Level 2 Maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. Exam Structure The Functional Skills Pearson Edexcel Qualification in Mathematics Level 2 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 Pearson Edexcel 25 minutes 7 25% Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 1 hour 21 75% 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. Recognised Accreditation This Functional Skills Entry Level 2 Maths has been independently accredited by Pearson Edexcel 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. Certificate of Achievement You will be rewarded with an Ofqual Regulated Pearson Edexcel Functional Skills Qualification in Mathematics at Entry Level 2 (depending on what you choose as an accreditation) upon successful completion of this Functional Skills Entry Level 2 Maths Course and passing the assessments. A certified hard copy of this qualification will be posted at your given address which is accepted by employers and universities across the globe. You can flaunt this qualification in your CV which will give you a competitive advantage over others in case of securing a job.  FAQs What are functional skills? Functional skills are practical skills in Maths, English, and ICT that enable people to apply their knowledge to real-life situations. These skills are designed to provide learners with the essential knowledge needed to succeed in the workplace and in their personal lives. Functional Skills are recognised qualifications in the UK and are offered at different levels, including Entry Level, Level 1 and Level 2. What is the difference between entry-level and level 1 and 2 functional skills? Both are recognised qualifications, but levels 1 and 2 are more advanced levels that will provide you with comprehensive skills and knowledge while entry-level courses are an introduction and basic level qualification to go to subsequent levels. Is it required to complete entry-level qualifications to move onto a level? No, you are not obliged to complete entry-level courses before moving on to higher levels. However, entry-level courses serve as a starting point for acquiring basic skills and knowledge that will help you strive and boost your chances of securing better marks at higher levels. Are functional skills qualifications recognised and accepted in the UK? Yes, functional skills qualifications are an accepted part of all apprenticeship standards and a way to progress to further education in the UK. Do I have to physically appear for the exam? Yes, you will be required to appear for the exam at our designated office in London or Swindon on the exam day. Do I have to register for the exam? Yes, you need to be registered for the exam three weeks prior to the exam date. What is the assessment procedure for an entry-level 2 maths course? This course comprises a single assessment that is externally set, internally graded, and externally verified by the exam body. Your exam results will be forwarded to Pearson Edexcel's internal verifier once you finish the exam. If you pass all three components, you'll be able to receive the qualification certificate from the awarding body. How to pass the Functional Skills Maths entry level 2 exam? Tips for preparing for the exam include understanding the exam format, practising regularly, mastering the basics and managing time well during the exam, and seeking help from a teacher or tutor. To assist you in gaining the skills and knowledge required to pass the exam, Lead Academy offers 24/7 tutor support. As a result, you will be adequately prepared to ace the exam. Can I take entry-level courses online? Yes, you can take functional skills entry-level courses online. Lead Academy offers an extensive range of entry-level courses from level 1 to 3, available for both English and Maths. Are Functional skills easier than GCSE? Functional Skills qualifications may require hard work and revision, but they can be a better fit for students who have found Maths and English challenging. Unlike GCSEs, Functional Skills qualifications are flexible and designed to meet the needs of diverse learners, making them more adaptable to different learning styles. What will I get after finishing the course? After successfully completing the Entry Level 2 Maths course, you will receive a Pearson Edexcel Functional Skills Qualification in Maths at Entry Level 2 (depending on what you choose as an accreditation) that is highly regarded by universities and employers across the UK.

Functional Skills Entry Level 2 Maths Online Course
Delivered Online On Demand1 hour
£149 to £355

HTML and CSS Coding: Beginner to Advanced

By The Teachers Training

Overview HTML and CSS Coding: Beginner to Advanced Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this HTML and CSS Coding: Beginner to Advanced Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Getting Started Introduction 00:03:00 Course Curriculum 00:07:00 How To Get Course Requirements 00:02:00 Getting Started On Windows, Linux Or Mac 00:02:00 How To Ask A Great Questions 00:01:00 Setting Up Development Environment Introduction 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview Of A Webpage 00:05:00 Full HTML Code Page 00:07:00 First Hello World! Webpage 00:09:00 HTML Fundamentals Introduction 00:03:00 Heading 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 ID's In CSS 00:06:00 Comments In HTML 00:04:00 Summary 00:04:00 HTML Intermediate Introduction 00:02:00 Images 00:12:00 Forms 00:05:00 Form Actions 00:04:00 Br Tag 00:03:00 Marquee 00:06:00 Text Area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div Tag 00:06:00 Google Maps 00:07:00 Summary 00:02:00 HTML Advanced Introduction 00:02:00 HTML5 Audio 00:07:00 HTML5 Video 00:05:00 Progress Bar 00:04:00 Drag And Drop 00:18:00 Canvas 00:06:00 I Frames 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 YouTube Video Linking 00:04:00 Creating Responsive Page 00:05:00 Summary 00:02:00 HTML Expert Introduction 00:02:00 Registration Form 00:04:00 Login Form 00:04:00 About Us Form 00:02:00 Contact Us Form 00:10:00 Footer Form 00:03:00 Integrate All Together 00:07:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:02:00 Summary 00:02:00 HTML Website Project Introduction 00:02:00 Challenge - HTML 5 Clock Face With Numbers 00:05:00 Project Overview 00:03:00 Conclusion On Project 00:01:00 Summary 00:02:00 CSS Fundamentals Introduction 00:03:00 CSS Syntax 00:05:00 Creating A First Page With CSS Style 00:13:00 Inline CSS 00:06:00 Internal CSS 00:05:00 CSS External 00:10:00 CSS Classes 00:09:00 CSS IDs 00:06:00 Colors 00:08:00 Backgrounds 00:04:00 Floating 00:09:00 Positioning 00:06:00 Margins 00:07:00 Padding 00:04:00 Borders 00:03:00 Summary 00:02:00 CSS Intermediate Introduction 00:02:00 Styling Text 00:07:00 Aligning Text 00:04:00 Styling Links 00:10:00 Font Family 00:07:00 Font Styles 00:03:00 Applying Google Fonts 00:07:00 Box Model 00:09:00 Icons 00:09:00 Tables 00:16:00 Navigation-Menu 00:11:00 Dropdowns 00:15:00 Summary 00:02:00 CSS Advanced Introduction 00:02:00 Advanced Selectors 00:05:00 Forms 00:17:00 Website Layout 00:21:00 Rounded Corners 00:08:00 Color Keywords 00:06:00 Animations 00:08:00 Pseudo Classes 00:03:00 Gradients 00:03:00 Shadows 00:03:00 Calculations 00:05:00 Creating Responsive Page 00:06:00 Summary 00:02:00 CSS Expert Introduction 00:01:00 Button Styles 00:06:00 Flexbox 00:14:00 CSS Grid 00:15:00 Pagination 00:07:00 Multiple Columns 00:06:00 Image Reflection 00:02:00 UI - UX Design 00:09:00 Social Media Icons 00:08:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:03:00 Summary 00:02:00 CSS Website Project Introduction 00:01:00 CSS Project Getting 00:05:00 CSS Project Overview 00:08:00 Summary 00:01:00 Publish Your Website For Live Introduction 00:02:00 Installing Free FTP Solution (FileZilla) 00:04:00 Setting Up FTP (File Transfer Protocol) 00:03:00 Publish Website To Hosting Server 00:04:00 Summary 00:01:00

HTML and CSS Coding: Beginner to Advanced
Delivered Online On Demand11 hours 42 minutes
£24.99

Functional Skills Entry Level 2 Maths Online Course

By Study Plex

This Functional Skills Maths Entry Level 2 course will assist you in displaying a solid understanding of the foundational concepts and basic principles of mathematics appropriate to the level, as well as the ability to use mathematical reasoning to solve routine issues in everyday contexts. Course Highlights: Course Type: Self-Paced Online Learning Total Qualification Time: 58 hours Guided Learning: 55 hours Accreditation: Pearson Edexcel & Open Awards Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Assessment: Internally graded and externally verified Access: 1 Year Access Certificate: Certificate upon completion of the official exam (hard copy) Tutor Support: Paid Tutor Support Customer Support: 24/7 live chat available Functional Skills Entry Level 2 Maths Course This Functional Skills Entry Level 2 Maths Course is regulated by Ofqual and accredited by Pearson Edexcel making it a nationally recognised qualification that will enhance your CV, helping you stand out from the rest of the candidates. You will acquire knowledge about the number system, common measures, geometry and handling data. Upon successful completion of this course, you will be able to apply your foundational mathematics knowledge in a range of practical scenarios. Why is this course right for you? This comprehensive Functional Skills Maths Entry Level 2 Course is suitable for: Anyone looking to secure a skill-oriented job People of all ages and academic backgrounds Anyone who wants to progress to functional skills level 1 or 2 Anyone who wants to take GCSE maths Anyone seeking to add a certified qualification to their university application Anyone aspiring to accelerate their career in this sector Anyone who wants to gain in-depth knowledge of functional skills in mathematics Whether you are a beginner into the field of functional maths or any professional seeking to reinforce your expertise in functional skills maths, this Functional Skills Maths Entry Level 2 Course will set you up with the advanced skills to boost your career profile. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre Results Pearson Edexcel Book within 15 days Get results in 20 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Functional Skills Entry Level 2 Maths Qualification Purpose and Outcomes This Functional Skills Entry Level 2 Maths Qualification will help you to: Develop confidence in their application of basic mathematics concepts and abilities. Prove their understanding by using their abilities and expertise to complete easy tasks or simple mathematical equations. Acquire comprehensive problem-solving and underpinning skills to utilise mathematics in the course of everyday life. Course Curriculum Count reliably up to 100 items Read, write, order and compare numbers up to 200 Recognise and sequence odd and even numbers up to 100 Recognise and interpret the symbols +, –, ×, ÷ and = appropriately Add and subtract two-digit numbers Multiply whole numbers in the range 0 × 0 to 12 × 12 (times tables) Know the number of hours in a day and weeks in a year; be able to name and sequence Divide two-digit whole numbers by single-digit whole numbers and express remainders Approximate by rounding to the nearest 10, and use this rounded answer to check results Recognise simple fractions (halves, quarters and tenths) of whole numbers and shapes Read, write and use decimals to one decimal place Calculate money with pence up to one pound and in whole pounds of multiple items and write with the correct symbols (£ or p) Use metric measures of length, including millimetres, centimetres, metres and kilometres Use measures of weight, including grams and kilograms Use measures of capacity, including millilitres and litres Read and compare positive temperatures Read and use simple scales to the nearest labelled division Recognise and name 2-D and 3-D shapes, including pentagons, hexagons, cylinders, cuboids, pyramids and spheres Use appropriate positional vocabulary to describe position and direction, including between, inside, outside, middle, below, on top, forwards and backwards Sort and classify objects using two criteria Take information from one format and represent the information in another format, including use of bar charts How This Course Will Work? This Functional Skills Entry Level 2 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 Functional Skills Entry Level 2 Maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. Exam Structure The Functional Skills Pearson Edexcel Qualification in Mathematics Level 2 consists 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 Pearson Edexcel 25 minutes 7 25% Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 1 hour 21 75% 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. Recognised Accreditation This Functional Skills Maths Level 2 has been independently accredited by Pearson Edexcel 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. Certification You will be rewarded with an Ofqual Regulated Pearson Edexcel Functional Skills Entry Level 2 English Online Course (depending on what you choose as an accreditation) upon successful completion of this Functional Skills English Entry Level 3 Course and passing the assessments. A certified hard copy of this qualification will be posted at your given address which is accepted by employers and universities across the globe. You can flaunt this qualification in your CV which will give you a competitive advantage over others in case of securing a job. FAQs What are functional skills? Functional skills are practical skills in Maths, English, and ICT that enable people to apply their knowledge to real-life situations. These skills are designed to provide learners with the essential knowledge needed to succeed in the workplace and in their personal lives. Functional Skills are recognised qualifications in the UK and are offered at different levels, including Entry Level, Level 1 and Level 2. What is the difference between entry-level and level 1 and 2 functional skills? Both are recognised qualifications, but levels 1 and 2 are more advanced levels that will provide you with comprehensive skills and knowledge while entry-level courses are an introduction and basic level qualification to go to subsequent levels. Is it required to complete entry-level qualifications to move onto a level? No, you are not obliged to complete entry-level courses before moving on to higher levels. However, entry-level courses serve as a starting point for acquiring basic skills and knowledge that will help you strive and boost your chances of securing better marks at higher levels. Are functional skills qualifications recognised and accepted in the UK? Yes, functional skills qualifications are an accepted part of all apprenticeship standards and a way to progress to further education in the UK. Do I have to physically appear for the exam? Yes, for the writing and reading assessment, you will be required to appear for the exam at our designated office in London or Swindon on the exam day. You will be required to take the speaking, listening, and communicating assessment via Zoom. Do I have to register for the exam? Yes, you need to be registered for the exam three weeks prior to the exam date. What is the assessment procedure for an entry-level 2 Maths course? This course comprises a single assessment that is externally set, internally graded, and externally verified by the exam body. Your exam results will be forwarded to Pearson Edexcel's internal verifier once you finish the exam. If you pass all three components, you'll be able to receive the qualification certificate from the awarding body. How to pass the Functional Skills Maths entry level 2 exam? Tips for preparing for the exam include understanding the exam format, practising regularly, mastering the basics and managing time well during the exam, and seeking help from a teacher or tutor. To assist you in gaining the skills and knowledge required to pass the exam, Lead Academy offers 24/7 tutor support. As a result, you will be adequately prepared to ace the exam. Can I take entry-level courses online? Yes, you can take functional skills entry-level courses online. Lead Academy offers an extensive range of entry-level courses from level 1 to 3, available for both English and Maths. Are Functional skills easier than GCSE? Functional Skills qualifications may require hard work and revision, but they can be a better fit for students who have found Maths and English challenging. Unlike GCSEs, Functional Skills qualifications are flexible and designed to meet the needs of diverse learners, making them more adaptable to different learning styles. What will I get after finishing the course? After successfully completing the Entry Level 2 Maths course, you will receive a Pearson Edexcel Functional Skills Qualification in Maths at Entry Level 2 (depending on what you choose as an accreditation) that is highly regarded by universities and employers across the UK.

Functional Skills Entry Level 2 Maths Online Course
Delivered Online On Demand1 hour
£185 to £375

Python in Practice - 15 Projects to Master Python

By Packt

This course will help you learn the programming fundamentals with Python 3. It is designed for beginners in Python and is a complete masterclass. This course will help you understand Python GUI, data science, full-stack web development with Django, machine learning, artificial intelligence, Natural Language Processing, and Computer Vision.

Python in Practice - 15 Projects to Master Python
Delivered Online On Demand20 hours 40 minutes
£44.99

Django with Tailwind CSS

By Packt

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

Django with Tailwind CSS
Delivered Online On Demand12 hours 38 minutes
£52.99

Legal Secretary and Office Skills

4.7(160)

By Janets

Register on the Legal Secretary and Office Skills today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Legal Secretary and Office Skills course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Legal Secretary and Office Skills course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Assessment To successfully complete the Legal Secretary and Office Skills course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a CPD-accredited certificate as proof of your subject-knowledge. Certification 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 To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Legal Secretary and Office Skills course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Legal Secretary Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems English Law and Legal Systems 00:22:00 Module 03: The Legal Workplace & Professionals The Legal Workplace and Professionals 00:20:00 Module 04: Law of Contract & Law of Tort Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice Wills, Probate, Estate Law 00:23:00 Module 06: Property Law & Conveyancing Practice Property Law & Conveyancing Practice 00:22:00 Module 07: Family Law and Insurance Practice Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents Professional Writing and Documents 00:30:00 Module 09: Document Proofreading and Editing Document Proofreading and Editing 00:24:00 Module 10: Meeting Management & Minute Taking Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping Data Management and Record-Keeping 00:16:00 Module 13: Other Essential Skills for Secretarial Role Other Essential Skills for Secretarial Role 00:22:00 Module 14: Professional Conduct and Ethics Professional Conduct and Ethics 00:25:00 Microsoft Word Essentials New Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Powerpoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Legal Secretary and Office Skills 00:20:00 Final Exam Final Exam - Legal Secretary and Office Skills 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Legal Secretary and Office Skills
Delivered Online On Demand8 hours 32 minutes
£25

Microsoft Excel 2021 Course for Everyone - Complete Excel Course

4.7(160)

By Janets

Register on the Microsoft Excel 2021 Course for Everyone - Complete Excel Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel 2021 Course for Everyone - Complete Excel Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel 2021 Course for Everyone - Complete Excel Course Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel 2021 Course for Everyone - Complete Excel Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: Getting Started Introduction 00:03:00 Course Curriculum 00:04:00 Getting started on Windows, macOS, Android, and IOS 00:01:00 How to ask great questions 00:02:00 FAQ's 00:01:00 Starting Excel 00:04:00 Section 02: Excel Basics Introduction 00:02:00 Worksheet basics 00:22:00 Entering values and formulas 00:12:00 Data formats 00:10:00 Data handling basics - cut copy and paste 00:07:00 Save and print in excel 00:10:00 Excel Ranges 00:05:00 Section 03: Excel essential functions Introduction 00:01:00 Basic formula operations 00:06:00 Mathematical functions level 1 00:20:00 Mathematical functions level 2 00:12:00 Text functions level 1 00:09:00 Text functions level 2 00:13:00 Logical functions 00:11:00 Date time functions 00:06:00 V Lookup formula 00:12:00 HLookup formula 00:04:00 HLookup + Match formula 00:09:00 Match + Index formula 00:05:00 Section 04: XLookup only for Excel 2021 and Office 365 Introduction 00:02:00 XLookup 00:08:00 Handling #NA and Approximates match in XLookup 00:11:00 Wildcard matching in XLookup 00:06:00 Section 05: Get Data and tools Introduction 00:02:00 Split text into columns 00:07:00 Flash Fill 00:07:00 Remove Duplicates 00:08:00 Data Validation 00:07:00 Get- import Data from Text 00:06:00 Get - import Data from CSV 00:03:00 Section 06: Formatting data and tables Introduction 00:01:00 Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Number 00:05:00 Formatting Date 00:03:00 Formatting tables 00:05:00 Section 07: Pivot Tables Introduction 00:01:00 Creating Pivot Table 00:07:00 Value field settings 00:04:00 Number format 00:02:00 Pivot Table Design 00:03:00 Excel Exercise 00:01:00 Solution for Excel Exercise 00:02:00 Section 08: Excel Charts Introduction 00:01:00 Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Easy way to create charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line charts 00:02:00 Area charts 00:02:00 Pie and Doughnut charts 00:04:00 Format AreaPlot or XY chart 00:08:00 Scatter or bubble charts 00:02:00 Section 09: Advanced Excel charts Introduction 00:01:00 Frequency Distribution and Histograms 00:04:00 Waterfall charts 00:02:00 Hierarchy charts: sunburst and tree map 00:03:00 Combination charts 00:02:00 Sparklines 00:05:00 Section 10: Pivot Charts Pivot charts 00:02:00 Section 11: Maps Chart above 2019 Maps chart 00:04:00 3D Maps chart 00:03:00 Section 12: Business-Geo charts Introduction 00:01:00 Stock charts 00:02:00 Radar charts 00:02:00 Surface charts 00:02:00 Heat maps 00:04:00 Section 13: Named Ranges Indirect Name range Function 00:06:00 Named ranges 00:05:00 Section 14: Import Data into Excel Import Data from Website - Excel 2019 above 00:09:00 Import Data table from PDF file - Excel 2021 00:04:00 Section 15: Advanced Excel Product Sale Tax invoice: Tax Calculations 00:05:00 Project: Sales forecast tracker 00:07:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Microsoft Excel 2021 Course for Everyone - Complete Excel Course
Delivered Online On Demand6 hours 51 minutes
£25

Modern JavaScript from The Beginning [Second Edition]

By Packt

This second-edition JavaScript course covers fundamental concepts, including variables, data types, functions, and control flow, as well as advanced topics such as object-oriented programming, modules, and testing. With practical projects and clear explanations, learners can gain a solid understanding of the language and develop their skills.

Modern JavaScript from The Beginning [Second Edition]
Delivered Online On Demand36 hours 58 minutes
£125.99