1250 Statistics courses

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

Any organisation's main expenses are its labour, and that is why there is a need to find the perfect match in order to minimize costs. This part of the job falls under the Human Resources team of the given company, where the HR managers have to match skills against the job available. If these things interest you then you are in luck, as this Level 2 Certificate in HR & Employment Law can teach you more on the subject. The course is divided into two sections, one focusing on Human Resource Management and the other on employment laws. In the first section you will learn about how modern day human resource management works, recruiting, interviewing, retention and orientation. You will discover more about following up with new employees, health and safety, discrimination and much more. Next you look into employment law by learning about immigration, rights, termination, transfers and such. The course covers multiple disciplines as you learn about management and UK employment law, which in turn could be extremely useful for you since you will stand out from the competition in your employer's eyes. Employment Law Course Highlights HR & Employment Law Course is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed HR & Employment Law Course into 42 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 8 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose HR & Employment Law Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? HR & Employment Law Course is CPD Qualification Standards and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our HR & Employment Law Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. HR & Employment Law Course (Updated Version) Human Resource Management Introduction to Human Resources 00:17:00 Employee Recruitment and Selection Procedure 00:32:00 Employee Training and Development Process 00:22:00 Performance Appraisal Management 00:19:00 Employee Relations 00:15:00 Motivation and Counselling 00:19:00 Ensuring Health and Safety at the Workplace 00:16:00 Employee Termination 00:15:00 Employer Records and Statistics 00:11:00 Essential UK Employment Law 00:38:00 Employment Law Basics of Employment Law 00:24:00 Legal Recruitment Process 00:40:00 Employment Contracts 00:21:00 Employee Handbook 00:20:00 Disciplinary Procedure 00:21:00 National Minimum Wage & National Living Wage 00:33:00 Parental Right, Sick Pay & Pension Scheme 00:44:00 Discrimination in the Workplace 00:49:00 Health & Safety at Work 00:15:00 Dismissal, Grievances and Employment Tribunals 00:33:00 Workplace Monitoring & Data Protection 00:11:00 HR & Employment Law Course (Old Version) Human Resource Management Module One - Getting Started FREE 00:30:00 Module Two - Human Resources Today FREE 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Employment Law Introduction FREE 01:00:00 Immigration Requirements FREE 01:00:00 Contractual Terms 01:00:00 Rights During Employment 02:00:00 Termination of Employment 02:00:00 Discrimination 02:00:00 Business Transfers 01:00:00 Collective Rights 01:00:00 Useful Websites 00:30:00 Mock Exam Mock Exam- HR & Employment Law Course 00:30:00 Final Exam Final Exam- HR & Employment Law Course 00:30:00

Duration 3 Days 18 CPD hours This course is intended for Ideal candidates are Network Administrators who monitor and troubleshoot wireless networks, and Network and System Administrators responsible for installing and configuring network monitoring systems. Overview This hands-on course prepares you with the knowledge and experience required to install and use the AirWave Wireless Management Suite: AirWave Management Platform (AMP), RAPIDS, Visual RF, network health diagnostics, client troubleshooting, alerts and reporting.  In this course, you learn about AirWave?s capabilities in troubleshooting network health and client status via the various stages of association and authentication, as well as redundancy and master consoles for large networks. Introduction to AWMS Airwave Platform. Features and Benefits of AMP RAPIDS and Visual RF. Airwave products. Basic operations using AWMS Installing AWMS Installing AMP. Hardware requirements. Cent OS and AWMS software. Basic configuration steps. Upgrade AWMS software. Licensing AWMS. AWMS documentation Adding Device to AWMS Folders and Groups. Adding devices general process. Manually adding devices. Device discovery and managing device discovery. Moving a device to a folder. Troubleshooting IAP Organizaion and Groups Overview of IAP.Airwave integration. Golden configuration. IAP Organization options. IAP Whitelist Using Visual RF and Visual RF Plan Navigation. Setup. Heat-maps and location information. Import floorplan graphics. Plan deployments. Provision APs. Manage Visual RF performance Network Health Diagnostics page indicators. Network performance tabs. Source of issues. Network issues Troubleshooting Clients and Wireless Networks Searching for users and Diagnostics tab. Client issues. Network issues. AP issues. Switch/Controller issues. General Issues Rogue Detection and Using RAPIDS Why use RAPIDS. Threat Detection Methods. Rules. Classifications. IDS Events Report. New Rogue Devices Report. Visualization. PCI Compliance.WMS Offload Managing Administrative Access, Alerts, Triggers and Reporting Configure role-based administrative use access to the AMP system. Triggers. Alerts. Define and generate reports Scalability and Redundancy VM Redundancy. Failover for Redundancy. Master Console for large deployments. Multiple AMP Server deployments. Large Deployment example System Administration AMP Maintenance. Device Maintenance Wired Device Management Monitoring wired devices in AWMS. Wired device port and interface information. Wired device bandwith statistics and counters. Managing and configuring wired devices via AWMS templates AirWave Aruba Groups How AWMS configures devices. Using groups to control policies. Creating and controlling groups. Basic Group Design.Configuration Audits IAP Template Configuration Fetching a Template. Template Variables. Templates Configuration IAP GUI Configuration Golden configuration. GUI mode. GUI configuration Additional course details: Nexus Humans Managing Campus Networks with Aruba AirWave, Rev. 19.21 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 Managing Campus Networks with Aruba AirWave, Rev. 19.21 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.

Description: Matching the skills sets of thousands of people for a single open position could be exhausting. But you don't have to waste your time if you learn the tricks of how to filter the right people, with the help of this HR Management Online Course. First, this course will introduce you to the working mechanism of how HR management works. You will discover the processes of recruitment, interviewing, retention and orientation. You will also learn to manage health & safety, different sorts of harassment and much more. Next you focus on developing your leadership skills by learning to inspire your team, incentivize, improve charisma and authority. You will also be able to deal with crisis situations and dissident employees as well. Finally you will look at HR management from a psychological perspective, and learn different theories, motivating yourself along with the employees. Overall the course covers a lot of ground in HR management and also helps you stand out by improving your leadership skills. And getting this course now will also help you get recruited easily as you will learn to think like a HR manager. Who is the course for? Individuals looking to start a new career in human resources or recruitment People who want to improve their skills and develop their career further in HR management Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: HR Management Online Course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: HR Manager Recruitment consultant HR Administrator HR Assistant HR Management Online Course - Updated Version Introduction to Human Resources 00:20:00 Employee Recruitment and Selection Procedure 00:35:00 Employee Training and Development Process 00:24:00 Performance Appraisal Management 00:22:00 Employee Relations 00:19:00 Motivation and Counselling 00:22:00 Ensuring Health and Safety at the Workplace 00:19:00 Employee Termination 00:18:00 Employer Records and Statistics 00:17:00 Essential UK Employment Law 00:30:00 HR Management Online Course - Old Version Human Resource Management Concepts Module One - Getting Started 00:30:00 Module Two - Human Resources Today 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Advanced Diploma in Human Resource Management 00:00:00 HR and Leadership Skills INTRODUCTION 00:30:00 WHAT MAKES A GREAT LEADER? 01:00:00 HOW TO INSPIRE YOUR TEAM 01:00:00 HOW TO INCENTIVIZE THE RIGHT WAY 01:00:00 HOW TO INCREASE YOUR CHARISMA AND AUTHORITY 01:00:00 HOW TO DEAL WITH A CRISIS 01:00:00 IS IT BETTER TO BE FEARED OR LIKED? 01:00:00 DEALING WITH DISSIDENTS 01:00:00 CREATING TEAMS AND ENCOURAGING TEAMWORK 00:30:00 UNDERSTANDING CHARACTERS AND CHOOSING THE RIGHT PERSON 00:30:00 THE 10 MOST POWERFUL TIPS FOR LEADERS 00:30:00 CONCLUSION 00:15:00 HR Management Module One - Getting Started 01:00:00 Module Two - A Psychological Approach 01:00:00 Module Three - Object-Oriented Theory 01:00:00 Module Four - Using Reinforcement Theory 01:00:00 Module Five - Using Expectancy Theory 01:00:00 Module Six - Personality's Role in Motivation 01:00:00 Module Seven - Setting Goals 01:00:00 Module Eight - A Personal Toolbox 01:00:00 Module Nine - Motivation on the Job 01:00:00 Module Ten - Addressing Specific Morale Issues 01:00:00 Module Eleven - Keeping Yourself Motivated 00:30:00 Module Twelve - Wrapping Up 00:30:00 HR Management: Employee Motivation- Activities 00:00:00 Mock Exam Mock Exam- HR Management Online Course 00:30:00 Final Exam Final Exam- HR Management Online Course 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course first equips you with the fundamentals of Python and then progresses to teach you how to use various libraries such as NumPy, Pandas, Seaborn, Bokeh, and so on. This course contains several mini projects so that, by the end of this course, you will be equipped with the essential tools you need to become a visualization expert.

Duration 5 Days 30 CPD hours This course is intended for The skills covered in this course converge on four areas-software development, IT operations, applied math and statistics, and business analysis. Target students for this course should be looking to build upon their knowledge of the data science process so that they can apply AI systems, particularly machine learning models, to business problems. So, the target student is likely a data science practitioner, software developer, or business analyst looking to expand their knowledge of machine learning algorithms and how they can help create intelligent decisionmaking products that bring value to the business. A typical student in this course should have several years of experience with computing technology, including some aptitude in computer programming. This course is also designed to assist students in preparing for the CertNexus Certified Artificial Intelligence (AI) Practitioner (Exam AIP-210) certification Overview In this course, you will develop AI solutions for business problems. You will: Solve a given business problem using AI and ML. Prepare data for use in machine learning. Train, evaluate, and tune a machine learning model. Build linear regression models. Build forecasting models. Build classification models using logistic regression and k -nearest neighbor. Build clustering models. Build classification and regression models using decision trees and random forests. Build classification and regression models using support-vector machines (SVMs). Build artificial neural networks for deep learning. Put machine learning models into operation using automated processes. Maintain machine learning pipelines and models while they are in production Artificial intelligence (AI) and machine learning (ML) have become essential parts of the toolset for many organizations. When used effectively, these tools provide actionable insights that drive critical decisions and enable organizations to create exciting, new, and innovative products and services. This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, all while following a methodical workflow for developing data-driven solutions. Solving Business Problems Using AI and ML Topic A: Identify AI and ML Solutions for Business Problems Topic B: Formulate a Machine Learning Problem Topic C: Select Approaches to Machine Learning Preparing Data Topic A: Collect Data Topic B: Transform Data Topic C: Engineer Features Topic D: Work with Unstructured Data Training, Evaluating, and Tuning a Machine Learning Model Topic A: Train a Machine Learning Model Topic B: Evaluate and Tune a Machine Learning Model Building Linear Regression Models Topic A: Build Regression Models Using Linear Algebra Topic B: Build Regularized Linear Regression Models Topic C: Build Iterative Linear Regression Models Building Forecasting Models Topic A: Build Univariate Time Series Models Topic B: Build Multivariate Time Series Models Building Classification Models Using Logistic Regression and k-Nearest Neighbor Topic A: Train Binary Classification Models Using Logistic Regression Topic B: Train Binary Classification Models Using k-Nearest Neighbor Topic C: Train Multi-Class Classification Models Topic D: Evaluate Classification Models Topic E: Tune Classification Models Building Clustering Models Topic A: Build k-Means Clustering Models Topic B: Build Hierarchical Clustering Models Building Decision Trees and Random Forests Topic A: Build Decision Tree Models Topic B: Build Random Forest Models Building Support-Vector Machines Topic A: Build SVM Models for Classification Topic B: Build SVM Models for Regression Building Artificial Neural Networks Topic A: Build Multi-Layer Perceptrons (MLP) Topic B: Build Convolutional Neural Networks (CNN) Topic C: Build Recurrent Neural Networks (RNN) Operationalizing Machine Learning Models Topic A: Deploy Machine Learning Models Topic B: Automate the Machine Learning Process with MLOps Topic C: Integrate Models into Machine Learning Systems Maintaining Machine Learning Operations Topic A: Secure Machine Learning Pipelines Topic B: Maintain Models in Production

24-Hour Flash Sale! Prices Reduced Like Never Before!! Health and Social Care professionals are the backbone of our society that supports public health and well-being. This is more true, particularly during this time as the UK faces the challenges of an ageing population and increasing mental health concerns. Statistics reveal that the Health & Social Care sector in the UK is huge, employing more than 2 million people in NHS, Care Homes or any other private or independent organisations. So, get ready to step into a role that not only demands excellence but also provides immense personal satisfaction! The Advanced Certificate in Health & Social Care in the UK provides deep insight into the health and social care system, equipping you with the knowledge and skills necessary to thrive in this demanding field. This course covers everything from the Structure of the UK health system to the core principles and legislation that guide daily operations within the sector. You'll explore the ethical considerations and the quality of care expected in various settings, preparing you for a successful career in health and social care. This Advanced Certificate in Health & Social Care in the UK at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Key Topics to be covered: Career Opportunities in this Sector The role of NHS in the UK Key Areas Five Fundamental Aspects of Quality Health & Social Care in the UK This course offers you the tools and insights to become a proficient health and social care personnel, an advocate for health and well-being, and a leader in your community. By joining the Advanced Certificate in Health & Social Care in the UK course, you're not just pursuing a job; you're embracing a lifetime commitment to helping others. Enrol now and transform your potential into meaningful action! Learning Outcomes of this Course: An understanding of the fundamental differences between Health & Social Care The role of the NHS in the Health & Social Care sector Awareness of adult safeguarding practices in this setting Knowledge of key legislation within Health & Social Care Understanding the fundamental aspects of providing quality care Development of essential skills required to become an adequate Health & Social Care worker Skills You Will Gain: Adult safeguarding Person-centred communication How to work as a team in this sector Active listening Why Prefer this Course? Get a chance to order a QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of Health & Social Care. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Health & Social Care setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Health & Social Care-related fields, impacting their Health & Social Care experiences and long-term development. Course Curriculum Module 01: Introduction to Advanced this course Module 02: Introduction to the UK Health System Module 03: Essential Principles, Policies and Legislations in Health & Social Care Work Module 04: Fundamental Aspects of Providing Quality with this course in the UK Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Advanced Certificate in Health & Social Care in the UK at QLS Level 3 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is ideal for: Aspiring health professionals Social care workers Nursing candidates Care home managers Public health students Career switchers Progression: Once you have completed this course, you can continue on to: Level 5 Diploma In Health & Social Care Level 2 RQF Health And Social Care Level 3 RQF Health And Social Care Level 5 RQF Health And Social Care RQF Health And Social Care Level 2 RQF Health And Social Care Level 5 NVQ Health And Social Care Management Certificate In Management For Level 5 NVQ Health And Social Care QCF Level 3 NVQ Health And Social Care Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Health Care Assistant: £18,000 - £25,000 Social Worker: £28,000 - £40,000 Care Home Manager: £30,000 - £50,000 Public Health Specialist: £32,000 - £52,000 Clinical Services Manager: £35,000 - £55,000 Health Service Manager: £37,000 - £70,000 Certificates CPD Accredited Digital Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 Upon finishing the Health & Social Care in the UK course, you need to order to receive a Certificate Accredited by CPDQS that is accepted all over the UK and also internationally. The pricing schemes are: 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery) Advanced Certificate in Health & Social Care in the UK at QLS Level 3 Hard copy certificate - £89 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Certificate in Health & Social Care in the UK at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 89 GBP inside the UK 99 GBP (including postal fees) for International Delivery

11-in-1 Premium Bundle | Diploma in Real Estate & Property Development | Legal System UK | Property Law & Legislation | Sales & Marketing Skills

This course will fully prepare you for virtually any Excel-related career path

An essential part of your skillset as an office worker and administrator is an excellent understanding of the many uses of Microsoft Excel. This superb course will enable your abilities to use it as a primary tool to create workbooks and formulas. But you will also be guided in the use of more complicated functions involving automation, formatting, and calculation. By the end of the lessons, you will be more than accomplished at producing stunning graphs and worksheets that will perform the bulk of the work for you. Learning Outcomes: Learn how to create worksheets and workbooks Use functions and formulas to calculate results Create attractive charts and graphs for meetings Write automated workbooks that drive activities Impress senior colleagues with dynamic presentations of data Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. 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?  This course is designed for senior administrators or PAs that need to store and manipulate company data or employee statistics.  Requirements This Microsoft Excel Course is fully compatible with any kind of device. Whether you are using Windows computer, 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 The course is suitable for those in the roles of; Personal Assistant Secretary Heads of Departments Administrator Receptionist Course Content Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00 Assignment Assignment - Microsoft Excel 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00: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.