1630 Courses delivered Online

Motorsport is as much a business as it is a sport. Our new master’s programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. From governance, structure and international sports law, through to the importance and interdependence of commercial rights holders, promoters, manufacturer, teams, sponsors and the role played by the media, this course is aimed at enhancing the professional and career prospects of those with an aspiration of working within this exciting and challenging global industry. Our programme will help you to develop as professionals with a strong grounding in ethics and a clear sense of how motorsport relates to various cultures, stakeholders and the sectors it interacts with.

Course Overview A library holds the history and literature of a culture or the whole world in the pages of its books. To make all these information accessible and enjoyable to people, proper library management is essential. Learn library management skills from this Diploma in Library and Information Science course and take the first step to be a librarian. This Diploma in Library and Information Science course will teach you how you can manage and organise information. You'll be familiarised with library infrastructure and acquire managerial and financial skills you need to be a librarian. You'll also learn about virtual library management skills. This course will help you to understand the functions of library networking and boost your skill. The easily understandable lessons will provide you with the updated skills and knowledge of library management. You'll be able to learn about information science from scratch in this course. Learning Outcomes Learn about the roles and responsibilities of a librarian Understand the ethical values in library management Be able to use library networking efficiently Familiarise with data management and the duties of library management Know about UK legislation of data storage and library management Be able to understand how to manage a digital library Familiarise with the virtual library system Learn to manage finance and budgeting for library resources Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Network Building Financial Management Library Management Who Should Take this Diploma in Library and Information Science Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Diploma in Library and Information Science course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Diploma in Library and Information Science Certification After completing and passing the Diploma in Library and Information Science course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path The Diploma in Library and Information Science is a useful qualification to possess and would be beneficial for any related profession or industry such as: Librarians Library Assistants Researchers Data Analysts Data Scientists Diploma in Library and Information Science Module 01: Organisation Systems 00:27:00 Module 02: Ethics and Values in the Library Professions 00:23:00 Module 03: Library Networking 00:19:00 Module 04: Library as Infrastructure 00:27:00 Module 05: Finance and Budgeting 00:19:00 Module 06: Digital and Virtual Libraries 00:21:00 Module 07: Library Legislation 00:25:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 2 hours 34 minutes 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 life coaching Understand the core competencies and principles of life coaching Explore the various areas of life coaching Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert life coach Time Management and Planning Course for Life Coaches Course Master the skills you need to propel your career forward in life coaching. This course will equip you with the essential knowledge and skillset that will make you a confident life coach and take your career to the next level. This comprehensive time management and planning course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this time management and planning course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective life coaching practice and equip you with the essential skills, confidence and competence to assist you in the life coaching industry. You'll gain a solid understanding of the core competencies required to drive a successful career in life coaching. 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 life coach or for people who are aspiring to specialise in life coaching. Enrol in this time management and planning 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 time management and planning 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 life coaching 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 time management and planning 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 time management and planning 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%. Advance Your Career This time management and planning course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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 Introduction What You Will Learn 00:04:00 Your Personal Values Personal Values Introduction 00:01:00 Why Defining Your Values Is Important 00:02:00 How To Define Your Personal Values 00:05:00 What Does Your Ideal Life Look Like? 00:04:00 Goal Setting Basics Goal Setting Introduction 00:01:00 Why You Have To Set Goals To Get Ahead In Life 00:05:00 The 4 Biggest Goal Setting Mistakes You Must Avoid 00:06:00 SMART Goal Setting 00:01:00 HARD Goal Setting 00:02:00 WOOP Goal Setting 00:04:00 The Secret: Stretch Goal Philosophy 00:03:00 Setting Your First Goal Setting Your First Goal Introduction 00:01:00 Why You Should Start With Long Term Goals 00:05:00 How To Set Long Term Goals Correctly 00:05:00 Turning Long Term Goals Into Short Term Goals 00:05:00 Creating Your Action Plan Action Plan Introduction 00:01:00 How To Create Your List Of Actions 00:02:00 How To Set A Timeline & Create Milestones 00:02:00 How To Allocate Resources Correctly 00:02:00 Habit Building Habits Introduction 00:01:00 What Are Habits 00:01:00 Why Habits Matter 00:01:00 How To Build A New Habit 00:05:00 Habit Stacking - How To Boost Your Results 00:03:00 Choosing The Right Triggers 00:02:00 How To Write Down Your Sequence 00:01:00 How To Create Accountability 00:02:00 Small Goals Every Day 00:01:00 Advanced Goal Setting Strategies & Tips Advanced Strategies Introduction 00:01:00 The Success Cycle 00:06:00 Why New Year's Resolutions Don't Work 00:03:00 Accountability Buddies & Sharing Your Goals Correctly 00:05:00 The 80/20 Rule In Goal Setting 00:03:00 Using Visualization To Reach Your Goals Faster 00:04:00 Designing An Inspiring Vision Board 00:04:00 Affirmations For Goals 00:02:00 Memory Focus & Stress Reduction Memory & Mental Clarity Explained 00:01:00 Memory Building Techniques 00:03:00 Understanding & Reducing Stress 00:06:00 The Best Foods To Fight Stress 00:03:00 Supplements For Better Memory & Focus 00:02:00 Client Coach Relationship Client Coach Relationship Intro 00:01:00 What Clients Expect From Their Coaches 00:03:00 Why Clients Choose One Coach Over Another 00:01:00 What Qualifications Do You Need As A Coach 00:02:00 Client Coach Boundaries 00:02:00 How To Retain Clients Long Term 00:05:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced 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 can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

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

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! There's an old saying: 'Advertising is what you pay for; publicity is what you pray for.' It's time for you to stop praying for publicity and learn the skills needed to build, maintain and manage the reputation of your clients using all forms of media and communication. This Advanced Diploma in Public Relation at QLS Level 7 course is Endorsed by The Quality Licence Scheme Accredited by CPDQS (with 200 CPD points) You will learn everything from the basics of working as a public relations officer to handling PR crises like a pro. Each lesson is structured, and the course is made in a way that answers all your Public Relation related questions. You will get everything you need all in one place. Learning Outcome of this PR : Public Relation course: Grasp the core concepts of public relations Learn about the PR techniques like storytelling, public speaking, body language etc Develop the skills to manage a culturally diverse team Build the expertise for crisis management and handling defamation issues Understand the techniques of perforation evaluation and performance reporting Start your learning journey with this Level 7 Diploma in PR: Public Relation course straight away and take a step forward in securing a better future! The course is entertaining and packed with step-by-step lessons on: Module 01: Introduction Provides an overview of public relations, its importance, and the role it plays in organizational success. Module 02: Concepts Explores fundamental PR concepts, including communication strategies and media relations. Module 03: Management and Organisation of Public Relations Covers the structure, management, and organization of PR departments and agencies. Module 04: Public Relations Tactics and Research Focuses on various PR tactics and the importance of research in developing effective strategies. Module 05: Major Fields of PR Practice Part I Introduces key areas of PR practice, such as media relations and corporate communications. Module 06: Major Fields of PR Practice Part II Continues exploring major PR fields, including crisis management and community relations. Module 07: Social Media and PR Examines the role of social media in PR and strategies for effective online engagement. Module 08: Public Speaking Teaches essential public speaking skills for delivering impactful and persuasive messages. Module 09: Power of Storytelling Explores the importance of storytelling in PR to create compelling and relatable narratives. Module 10: Becoming an Influencer Focuses on building personal influence and leveraging it for PR success. Module 11: Importance of Body Language Covers how body language can impact communication and perception in PR. Module 12: Implementing CSR Discusses the role of corporate social responsibility (CSR) in PR and its implementation. Module 13: Performance Evaluation and Performance Reporting Explains methods for evaluating PR performance and reporting results to stakeholders. Module 14: Introduction to Cross-Cultural Awareness Introduces the basics of cross-cultural awareness and its importance in global PR. Module 15: Cross-Cultural Communication Teaches effective communication strategies for engaging with diverse cultural groups. Module 16: Corporate Cross-Cultural Awareness Focuses on building cross-cultural awareness within corporate settings for better PR practices. Module 17: Cultural Values Explores different cultural values and how they influence communication and PR strategies. Module 18: Working with and Managing a Culturally Diverse Team Covers best practices for managing and collaborating with culturally diverse teams. Module 19: Defamation Explains the legal aspects of defamation and how to manage and prevent reputational damage. Module 20: Crisis Management Teaches strategies for managing PR crises and maintaining organizational reputation. Module 21: Media Regulatory Bodies Provides an overview of media regulatory bodies and their impact on PR practices. Module 22: Ethics & Professionalism in Public Relations Discusses ethical considerations and professional standards in the PR industry. Module 23: Decision-Making with Critical Thinking Enhances decision-making skills using critical thinking techniques for effective PR strategies. Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. After passing the Advanced Diploma in Public Relation at QLS Level 7 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 200 CPD hours / points Accredited by CPD Quality Standards Module 01 - Introduction 12:45 1: Introduction to Public Relations Preview 12:45 Module 02 - Concepts 14:29 2: Concepts of Public Relations 14:29 Module 03- Management and Organisation of Public Relations 10:21 3: Management and Organisation of Public Relations 10:21 Module 04 - Public Relations Tactics and Research 16:35 4: Public Relations Tactics and Research 16:35 Module 05 - Major Fields of PR Practice Part I 14:09 5: Major Fields of Public Relations Practice Part I 14:09 Module 06 - Major Fields of PR Practice Part II 14:25 6: Major Fields of Public Relations Practice Part II 14:25 Module 07: Social Media and PR 13:22 7: Social Media and PR 13:22 Module 08: Public Speaking 12:35 8: Public Speaking 12:35 Module 09: Power of Storytelling 21:27 9: Power of Storytelling 21:27 Module 10: Becoming an Influencer 14:16 10: Becoming an Influencer 14:16 Module 11: Importance of Body Language 10:49 11: Importance of Body Language 10:49 Module 12: Implementing CSR 11:37 12: Implementing CSR 11:37 Module 13: Performance Evaluation and Performance Reporting 09:29 13: Performance Evaluation and Performance Reporting 09:29 Module 14: Introduction to Cross-Cultural Awareness 06:51 14: Introduction to Cross-Cultural Awareness 06:51 Module 15: Cross-Cultural Communication 07:24 15: Cross-Cultural Communication 07:24 Module 16: Corporate Cross-Cultural Awareness 07:09 16: Corporate Cross-Cultural Awareness 07:09 Module 17: Cultural Values 06:42 17: Cultural Values 06:42 Module 18: Working with and Managing a Culturally Diverse Team 06:59 18: Working with and Managing a Culturally Diverse Team 06:59 Module 19: Defamation 10:57 19: Defamation 10:57 Module 20: Crisis Management 19:14 20: Crisis Management 19:14 Module 21: Media Regulatory Bodies 19:12 21: Media Regulatory Bodies 19:12 Module 22: Ethics & Professionalism in Public Relations 09:02 22: Ethics & Professionalism in Public Relations 09:02 Module 23: Decision Making with Critical Thinking 14:28 23: Decision Making with Critical Thinking 14:28 Assessment 03:00 24: ASSIGNMENT ON - ADVANCED DIPLOMA IN PUBLIC RELATION AT QLS LEVEL 7 03:00 Order Your Certificate 02:00 25: Order Your CPD Certificate 01:00 26: Order Your QLS Endorsed Certificate 01:00 Who is this course for? This PR : Public Relation course is designed for Anyone with an interest in public relations Individuals who wish to elevate their resume with a valuable skill set Job seekers aspiring to secure a career in the relevant industry Exciting professionals who wish to polish their PR skills Requirements You will not need any prior background or expertise to enrol in this course. Career path Content Creation. Media Relations. Social Media Community. Community Relations. Financial Communications. Spokesperson. Reputation Management. Crisis Management. The average salary for Public Relations jobs is £22,000 to £50,000 per year in the United Kingdom. Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certificate of completion Digital certificate - £10 Public RelationAdvanced Diploma in Public Relation at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After completing the Advanced Diploma in Public Relation at QLS Level 7, 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

High Performing Teams. Moccasin Approach, Moccasin Manager,

Highlights of the Course Course Type: Online Learning Duration: 45 minutes 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 person-centred care Understand the core competencies and principles of person-centred care Explore the various areas of person-centred care Know how to apply the skills you acquired from this course in a real-life context Become a confident and health and social care worker Person-Centred Care This person-centred care course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. What do we mean by Person Centred Care, well the term originated in the 1940s and proposed taking a holistic view of service users in care settings. This means getting to know the person and then tailoring their care as much as possible to meet their specific needs. Person centred care is now a key principle outlined in current legislation and it plays an important part in the standards that they set out which must be followed by all care professionals working in this country. This person-centred care course will give you an understanding of person centred approaches for care and support, and how to implement a person-centred approach in an adult social care setting. It starts by explaining what we mean by person centred care and where this term originated. It then goes on to analyse the values represented by person centred care and explains why care should be as much as possible tailored to each service user. Finally it will give you an overview of care plans, daily reports, the importance of obtaining consent and much more. Who is this Course for? This comprehensive Person-Centred Care 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 person-centred care 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 Person-Centred Care 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 Person-Centred Care 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%. Advance Your Career This Person-Centred Care course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Module 1: Course Overview Module 2: Definitions and Values Module 3: Care Plans and Consent Module 4: Daily Reports Module 5: Example Care Plans Module 6: Case Study Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Discover the power of knowledge and build a more inclusive and respectful workplace with our comprehensive bundle of 8 courses: Unconscious Bias, Sexual Harassment & Domestic Violence Awareness. This unique bundle offers you the opportunity to enhance your understanding of these critical topics and make a lasting impact on your organization. With three QLS-endorsed courses and five relevant CPD QS-accredited courses, you'll gain valuable insights and receive hardcopy certificates to showcase your achievements. Empower yourself and your organization with this comprehensive bundle of courses, designed to create lasting change. Expand your understanding, challenge biases, and foster a workplace that values inclusivity. Enroll now and unlock a world of knowledge! Key Features of the Unconscious Bias, Sexual Harassment & Domestic Violence Awareness Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Unconscious Bias, Sexual Harassment & Domestic Violence Awareness bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Unconscious Bias Training For Supervisors QLS Course 02: Sexual Harassment Awareness Training QLS Course 03: Domestic Violence 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Equality, Diversity and Discrimination Course 02: Workplace Harassment Course 03: Dealing with Conflict at Work Course 04: Workplace Confidentiality Course 05: Cross-Cultural Awareness Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Unconscious Bias, Sexual Harassment & Domestic Violence Awareness courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Develop a deep understanding of Unconscious Bias, Sexual Harassment, and Domestic Violence. Identify and challenge biases to create an inclusive and respectful workplace. Gain knowledge and strategies to prevent and address sexual harassment incidents effectively. Understand the dynamics of domestic violence and support survivors sensitively. Promote equality, diversity, and discrimination-free environments. Enhance conflict resolution skills and foster positive relationships at work. Cultivate cross-cultural awareness and sensitivity towards diverse backgrounds. Immerse yourself in a transformative learning experience with our Unconscious Bias, Sexual Harassment & Domestic Violence Awareness bundle. Explore the intricate nuances of these crucial topics through our three QLS-endorsed courses and broaden your knowledge with five relevant CPD QS-accredited courses. Uncover the roots of biases, learn strategies to prevent and address harassment incidents, and gain valuable insights into promoting equality and diversity. With our comprehensive content, you'll develop a deep understanding and the tools needed to foster an inclusive and respectful workplace. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Human Resources professionals seeking to create a more inclusive work environment Managers and supervisors responsible for preventing and addressing workplace issues Employees interested in expanding their knowledge of unconscious bias, harassment, and domestic violence Individuals passionate about promoting equality and diversity in the workplace Career path Human Resources Manager: £35,000 - £70,000 per year Diversity and Inclusion Specialist: £30,000 - £55,000 per year Training and Development Manager: £30,000 - £60,000 per year Employee Relations Consultant: £25,000 - £50,000 per year Equality and Diversity Officer: £22,000 - £40,000 per year Workplace Mediator: £30,000 - £55,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master 2 (PSM II). This is an advanced scrum master training course - designed for experienced Scrum Masters seeking professional growth. Course Description This advanced Professional Scrum Master (PSM II) qualification is designed to elevate you to a level of total Scrum mastery. Deepen your understanding of the Scrum framework and Agile practices while transforming your team into an Agile powerhouse. Gain the skills to teach Agile and support your organisation, regardless of your role. Whether you aim to lead Agile transformation within your organisation or progress your Agile career, this advanced Scrum mastery course is your ideal opportunity. Our Scrum.org certified advanced professional scrum master training course is delivered by industry experts with unrivalled interactivity. We combine real world experience with industry leading practicals that embed key principles. The PSM 2 course if focussed on developing practical skillsets and best practice implementation to achieve tangible results. Through these tried and tested learning techniques, Fractal Systems delivers a 98% first-time pass rate. Learn how to become an advanced Scrum Master: Understand how Scrum principles and values guide decision-making. Enhance servant-leadership abilities. Support Development Teams and Product Owners to improve effectiveness. Foster a conducive environment for successful Scrum Teams with greater agility. Gain tips and techniques for collaboration with the organisation. Improve overall organisational impact as a successful Scrum Master. Address team conflict and remove impediments. Communicate the significance of a "Done" Increment. Grasp how to support the Scrum Team and navigate middle management challenges. Why Train With Us? This immersive two day PSM II course prioritises your growth and success in the industry. We believe in hands-on learning experiences that deliver practical applications that are specific to your individual workplace challenges. This not only helps to frame key principles of an advanced Scrum Master but also enables you to have a more immediate impact in your role. The PSM II training course is led by our Scrum Trainers, all of which have real world industry experience. Gain a deep understanding of advanced Scrum theory, empower your Scrum teams with best practices and be supported by industry professionals throughout - from passing test to implementing learnings into your role. Who Should Attend This Course? The Professional Scrum Master II course is an advanced program tailored for experienced Scrum Masters with a deep understanding of the Scrum framework. We recommend this to individuals with at least one year of Scrum Master experience. Your Professional Scrum Trainer Meet Jay, the founder of Fractal Systems and an experienced Professional Scrum Trainer. With over 20 years in leadership and team roles, Jay excels in delivering practical value. He adopts an interactive teaching style, avoiding PowerPoint in favour of engaging, experience-based learning, using techniques from Liberating Structures and Neuro-Linguistic Programming. Jay specialises in business transformations, providing training, mentoring, coaching, and consulting to drive success through teamwork. For those pursuing the Professional Scrum Master II (PSM II) certification, Jay and the Fractal team are committed to supporting your learning journey with a range of valuable resources: Complimentary Scrum Resource Bundle Access to a PSM Exam Simulator Free PSM II Exam Coaching Sessions Personalised 1:1 Coaching At Fractal Systems, our goal is to ensure you have the support and resources needed for a successful PSM II learning experience. Our Clients Our Testimonials