3043 Microsoft courses in Ince-in-Makerfield delivered Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

Duration 1 Days 6 CPD hours This course is intended for This is a basic course for IBM Engineering Requirements Management DOORS users. Overview Upon completion of the course, students will be able to: Navigate within a DOORS database Create structured data in a DOORS formal module Modify existing data in a DOORS formal module Review existing data in a DOORS formal module Create relationships in a DOORS database Report on relationships in a DOORS database This course is for new IBM Engineering Requirements Management DOORS (DOORS) users. It introduces basic DOORS concepts and functionality. It includes hands-on exercises that teach users to create, edit, manipulate, and analyze requirements data in DOORS. Unit 1 Navigating a DOORS Database Unit 2 Viewing information Unit 3 Editing information Unit 4 Structure Unit 5 Capturing additional information Unit 6 Working with Microsoft Word documents Unit 7 Locating information Unit 8 Manipulating the display Unit 9 Creating traceability Unit 10 Traceability analysis Unit 11 Object linking and embedding Unit 12 Discussions Additional course details: Nexus Humans QN101G IBM Engineering Requirements Management DOORS V9.6 - Foundation training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the QN101G IBM Engineering Requirements Management DOORS V9.6 - Foundation course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Windows 10 Understand the core competencies and principles of Windows 10 Explore the various areas of Windows 10 Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert Windows 10 user Certification in Windows 10 - Practical Hands-on Learning Course Master the skills you need to propel your career forward in Windows 10. This course will equip you with the essential knowledge and skillset that will make you a confident Windows 10 user and take your career to the next level. This comprehensive Windows 10 user course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this practical hands course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This certification in windows 10 - practical hands-on learning course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective Windows 10 practice and equip you with the essential skills, confidence and competence to assist you in the Windows 10 industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Windows 10. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Windows 10 user or for people who are aspiring to specialise in Windows 10.This certification in windows 10 - practical hands-on learning course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this practical hands course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive practical hands course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Windows 10 can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This practical hands course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This practical hands course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Video - Course Overview 00:05:00 Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox 00:12:00 Video and Lab - Creating a Virtual Install of Windows 10 Pro Using VirtualBox 00:16:00 Video - Taking A Snapshot Of Your Current Configuration 00:04:00 Upgrading Windows 7,8,Or 8.1 to Windows 10 Video - Perform a Windows 10 Upgrade for Free 00:09:00 Building a Microsoft Server 2016 Domain Video and Lab - Preparing Your Network for Active Directory 00:10:00 Video and Lab - Preparing Server 2016 for Promotion to a Domain Controller 00:10:00 Video and Lab - Promote Server 2016 to a Domain Controller 00:09:00 Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain 00:15:00 Windows Deployment Service Video - Install WDS on a Windows Server 00:16:00 Video - Deploy a Windows 10 Client Using WDS 00:09:00 Video and Lab - Create an Unattended Install of Windows 10 00:15:00 Windows 10 firewall, Windows Defender and UAC video - Turn the Windows 10 Firewall Off or On 00:00:00 Video - Allow an app through the Windows 10 firewall 00:05:00 video - Add a rule or port to a Windows 10 firewall 00:05:00 Video - Allow PING between Windows Server and Windows 10 00:05:00 Video - Disable the UAC User Account Control in Windows 10 00:02:00 Video - Using Netsh To Manage the Windows Firewall 00:05:00 Video - Using Powershell to Gather Firewall Information 00:04:00 Networking Video - Change your IP address in Windows 10 00:05:00 Video - Add a second IP address in Windows 10 00:09:00 Troubleshooting Video - Enable System Restore on Windows 10 00:03:00 Video - Create a System Restore point in Windows 10 00:00:00 Video - Recover using System Restore on Windows 10 00:04:00 Video - Fix TCPIP Corruption in Windows 10 Using Netsh 00:02:00 Video - Repair Windows 10 with System File Checker (SFC) 00:03:00 Video - Repair Windows 10 System files offline Using SFC 00:04:00 Video - Use ReadyBoost to Speed up Windows 10 00:05:00 Video - Reset Your Network Adapter 00:06:00 Video and Lab - Troubleshooting Internet Connectivity 00:16:00 Video - NSLookup 00:05:00 Overview of Windows Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:15:00 Performance Video - Generate a Windows Experience Index 00:06:00 Video - Windows 10 Performance Hack For a Slow PC 00:05:00 Video - Windows Reliability Monitor 00:04:00 User Preference Video - Disable the Lock Screen on Windows 10 00:03:00 Video - Disable Superfetch via Windows Services 00:03:00 Video - Disable Screen Saver in Windows 10 Using REGEDIT 00:02:00 Video - Disable Windows 10 Automatic Logoff For Inactivity 00:02:00 Video - Overview of the Windows 10 Shutdown and Restart buttons 00:01:00 Maintanence Video - Rename your Windows 10 computer 00:01:00 Video - Change the date and time in Windows 10 00:03:00 Video - Create a new local user in Windows 10 00:04:00 Video - Rearm the 30-day evaluation Period for Windows 10 Pro 00:03:00 Disk Management Video - Adding a secondary hard drive in Windows 10 Using VirtualBox 00:05:00 Video - How to use Storage Spaces in Windows 10 00:04:00 Video - How to Change drive letters in Windows 10 00:02:00 Video - How to format a volume Using FAT32 in Windows 10 00:03:00 Video - How to Convert FAT32 to NTFS in Windows 10 00:04:00 Video - How to run Chkdsk (Check Disk) in Windows 10 00:04:00 Printing Video - TCPIP Printing Overview 00:08:00 Video and lab - Adding a Printer to the Network Using TCPIP 00:10:00 Video and lab - Quickly install a network printer in Windows 10 00:03:00 Video - Printer Pooling 00:06:00 Powershell Disable UAC on Windows 10 Using PowerShell 00:03:00 Video - Using Powershell to Gather Firewall Information 00:04:00 Windows 10 Features, Tips and Tricks Video - Windows 10 Sandbox Feature 00:07:00 Video - Accessing the Extended Right-Click Menu in Windows 10 00:03:00 Wideo - Windows 10 File History 00:07:00 Video and Lab - Dumping Windows 10 Wi-Fi Credentials Using netsh 00:04:00 Video and Lab - Windows 10 God Mode 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This short online programme is designed for anyone who comes into contact with children through their work or leisure activities. Information sharing is key to delivering better, more efficient services that are coordinated around the needs of children, young people and families. It is essential to enable early intervention and preventative work, for safeguarding and promoting welfare and for wider public protection. Information sharing is a vital element in improving outcomes for all.

The starting point for this module is to look at why you need to undertake training on the protection of children and young people. All adults who come into contact with children in their work have a duty of care to safeguard and promote their welfare. Practitioners have a key role in shaping the futures of young people. The vast majority of adults working with young children act professionally to provide a safe and supportive environment. However, in this area of work, tensions and misunderstandings can also occur.

Description: This VMware Ultimate Bootcamp vSphere 4.1 will teach you advanced virtualization concepts and explore the VMware vSphere 4.1 product suite. The course objective is to install the knowledge required for you to do your job effectively and effectively, starting from installation of the product to real-world troubleshooting issues. The course focus is not limited only to learning and harnessing the power of VMware but the entire concept of virtualization, and other 3rd party tools and technologies that will enhance VMware capabilities and increase the student's virtualization expertise. In this course you will be introduced with Expert Lectures, Certificate of Completion, PowerPoint Visuals, demonstrations, Review Quizzes, Mobile Access, work books, and more. This course will help you to prepare yourself to become a certified professional virtualization expert. Assessment & Certification: To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our VMware Ultimate Bootcamp vSphere 4.1 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. Course Introduction and Methodology Learn IT! Do IT! Know IT! FREE 00:06:00 Virtualization Overview Why Virtualize 00:46:00 Planning and Installing ESX/ESXi Planning the ESX ESXi Deployment 00:12:00 vSphere 4.1 Deployment Guidelines 00:12:00 vSphere Hypervisor (ESXi) Installation 00:05:00 ESX Installation 00:20:00 Configuring Hostname Resolution and NTP 00:08:00 Troubleshooting ESX ESXi 00:11:00 Using Tools to Administer a VMware Environment Overview of 3rd Party Tools 00:10:00 ESX ESXi Management 00:21:00 Linux Command Review 00:07:00 Troubleshooting the vSphere Client (VIC) 00:02:00 Configuring Networking Creating & Modifying Virtual Networks 00:31:00 Creating & Modifying Virtual Networks Using CLI 00:27:00 Configuring Storage Storage Concepts 00:26:00 iSCSI Storage (GUI & Command Line) 00:38:00 Fibre Channel Storage 00:09:00 VMFS Datastores (GUI & Command Line) 00:29:00 NAS Storage and NFS Datastores (GUI & Command Line) 00:11:00 Raw Device Mapping (RDM) 00:04:00 vCenter Server 4.1 and Licensing Licensing 00:16:00 vCenter Server Installation 00:13:00 vCenter Server Inventory 00:34:00 Managing vCenter Server 00:08:00 Planning vCenter Server Deployment 00:07:00 Troubleshooting vCenter Server and Database 00:12:00 VM Creation, Configuration, and Snapshots Create a VM 00:27:00 Create Multiple VMs, Templates, & Clones 00:10:00 Virtual Appliances 00:22:00 VMware Converter (P2V - V2V) 00:20:00 Manage VMs 00:22:00 Virtual Machine Startup/Shutdown 00:07:00 Virtual Machine Snapshots 00:18:00 Web Access 00:13:00 Virtual Machine Troubleshooting & Best Practices 00:03:00 Security and Permissions Controlling User Access and Passwords 00:39:00 ESX ESXi Active Directory (AD) Integration 00:10:00 Managing Firewalls 00:11:00 SSH Access 00:06:00 Running Elevated Commands (su, sudo, setuid setgid) 00:07:00 VMsafe and vShield Zones 00:09:00 Server and VM Monitoring Optimizing Resources 00:31:00 Performance Monitoring 00:32:00 Configuring Alarms 00:07:00 ESXi ESX and vCenter Logs 00:10:00 Advanced ESX/ESXi and vCenter Management Storage Views & Topology Maps 00:09:00 Storage vMotion 00:13:00 Configuring vMotion 00:16:00 Distributed Resource Scheduler (DRS) Cluster 00:22:00 vNetwork Distributed Virtual Switches 00:27:00 Host Profiles 00:10:00 Linked Mode Group of vCenter Servers 00:04:00 Patching and Upgrading ESX Patching ESX ESXi Standalone Hosts 00:07:00 Patching with Update Manager 00:24:00 Upgrades and Migrations 00:18:00 Disaster Recovery and Backup Site Recovery Manager (SRM) 00:07:00 High Availability (HA) 00:19:00 VM Fault Tolerance 00:06:00 Microsoft Clustering 00:04:00 Backup Strategies 00:01:00 Using VCB Command Line Utilities 00:05:00 VMware Data Recovery 00:24:00 Third Party Backups 00:07:00 Mock Exam Mock Exam- VMware Ultimate Bootcamp vSphere 4.1 00:20:00 Final Exam Final Exam- VMware Ultimate Bootcamp vSphere 4.1 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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.

Overview Become a skilled professional by enrolling in the Office Skills course.This comprehensive Office Skills is designed to cover all the key topics you need to excel in the field of office administration and reception. This extensive course will teach you how to handle a comprehensive range of essential office admin duties, compose critical business letters and handle complex mail and shipping requirements. It will provide you with technical skills to meet the dynamic challenges facing modern companies.Convert your passion and enthusiasm into a prosperous career by enrolling in the Office Skills course. 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 Office Skills. It is available to all students, of all academic backgrounds. Requirements Our Office Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •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

We will follow a hands-on approach in this course to learn how to use and apply HTML5 and CSS3 concepts to the front-end page of your projects. A carefully structured beginner-level course that will help you level up your web development skills. You need not have any prior experience in HTML and CSS to take up this course.