16693 Courses

This course teaches you astro navigation, ocean passages, worlwide meteorology, and the practical skills required to use a Sextant for Ocean Navigation.

Each year, people are killed, injured, or suffer work-related illnesses while carrying out their jobs in the United Kingdom. As a result, health and safety is a major concern. The government, employers, and workers all have an important role in minimizing workplace fatalities and accidents and preventing health-related illnesses at work. The Health and Safety : Health and Safety in a Construction Environment - Level 1qualification covers an introduction to the legal aspects of health and safety before moving on to the fundamentals of risk assessment and safe working practices. It then goes into detail to cover the most common hazards encountered in construction sites, such as working at heights and respiratory hazards, as well as electrical and chemical hazards. Learning Outcomes After completing Health and Safety: Health and Safety in a Construction Environment - Level 1 course, the learner will be able to: Understand the legal aspects of health and safety in construction. Assess the safety of a workplace and conduct a health & safety risk assessment. Understand the importance of safe manual handling in the workplace. Gain a solid understanding of risks to health within a construction environment. Understand the importance of working around plants and equipment safely. Why Choose Health and Safety: Health and Safety in a Construction Environment - Level 1 Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Health & Safety in a Construction Environment Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing this course. ***Others benefits of this Health and Safety in a Construction Environment course*** Free One PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Health and Safety: Health and Safety in a Construction Environment - Level 1 course] Detailed Course Curriculum of *** Health and Safety in a Construction Environment *** Module 01: Health and Safety in a Construction Environment Know the principles of risk assessment for maintaining and improving health and safety at work Know the importance of safe manual handling in the workplace Know the importance of working safely at height in the workplace Know risks to health within a construction environment Know the importance of working around plant and equipment safely Assessment Method After completing each module of the Health and Safety: Health and Safety in a Construction Environment - Level 1 Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Health and Safety: Health and Safety in a Construction Environment - Level 1 course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Health and Safety: Health and Safety in a Construction Environment - Level 1 course is designed for those who work on construction sites. Requirements There are no specific requirements for Health & Safety in a Construction Environment course because it does not require any advanced knowledge or skills. Career path Working in Construction Sites Certificates Certificate of completion Digital certificate - Included

The Actuary Online Course offers a comprehensive exploration of these scientific foundations, delving into deterministic and stochastic models, life insurance, annuities, and the complex interplay between taxation, inflation, and risk.

AAT Bookkeeping Course Overview Are you looking to develop a career in Bookkeeping? As a successful Bookkeeper, you could earn on average more than £25,000 per year. (Source: National Career Service). And if you want to become a certified bookkeeper with AATQB (AAT Qualified Bookkeeper) status, then it is mandatory that you complete the AAT bookkeeping course to build a successful career in bookkeeping.  Bookkeeping Course Duration You can expect the AAT bookkeeping distance learning courses to take up to 6 months to complete for most students given that you attend classes and assessments regularly. Bookkeeping Courses Tutors Osborne Training tutors are highly qualified with extensive knowledge of bookkeeping. They helped thousands of students to achieve over 96% pass rate and to reach their career goal. They are industry recognised for bookkeeping courses in UK. Bookkeeping Courses from London Campus  Evening, Weekend and Daytime sessions for AAT Bookkeeping courses are offered from London campus. Why Osborne Training? Osborne Training tutors are expert and with many years of industry experience You get 24/7 Access to the State of the Art Virtual Learning Campus Free High quality study material Free exam preparation kit Flexible payment option available Expert Tutorial support from the tutor Student Discount Card from NUS* Exam Booking Service at our campus Various Campus around UK Free Tablet PC ( For Limited Period) Osborne Books are provided for AAT Bookkeeping Courses. Once you successfully complete the bookkeeping course, you will get a certificate from AAT to confirm your professional bookkeeping qualification achievement. Jobs available for Bookkeeper Senior Credit Controller Sales/Purchase Ledger Clerk Accounts senior Senior Bookkeeper In these roles, you could earn on average more than £25,000 annually. (Source: National Career Service) This AAT bookkeeping course is awarded by AAT and broken down into two levels, AAT Foundation Certificate in Bookkeeping  (also known as AAT Level 2 Bookkeeping) Bookkeeping Transactions Bookkeeping Controls Advanced Certificate in Bookkeeping Advanced Bookkeeping Final Accounts Preparation Indirect Tax Once you pass all 5 assessments successfully, you can gain AATQB status giving you competitive edge to build a successful career as a bookkeeper.

School age children can enroll onto our Beginners, Intermediate or Advance Level swimming lessons. At the majority of these lessons, the teacher is in the water for best teaching practice and support. At Beginners Level, an assistant may help in the water. At more Advance Level, the teacher may instruct and supervise the group lesson from poolside. Nervous swimmers are introduced to move around the pool with buoyancy aids in a group. Your teacher will help your child to develop confidence and submerge the face in the water from the first lesson.

The Executive Mini MBA will teach you all those things you learn from an MBA course that too in a shorter period. From learning theories to implying it in practical life, the course plan carries all the important aspects. This beneficial program will help you to gain in-depth knowledge about Economics and business. The administrative and managerial aspects of the business will become clearer to you. The course will also familiarise yourself with a wide variety of topics such as strategy planning, marketing strategy, resource management, etc. Most importantly, the course will play a significant role to develop the required leadership skill to lead a business organisation. By completing this course, you will become efficient enough for securing a high position in a business organisation.  Who is this Course for? This Executive Mini MBA course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. 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. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Certification After successfully completing the course, you will be able to obtain the certificates. You can claim a PDF certificate by paying a little processing fee of £2. There is an additional fee to obtain a hardcopy certificate which is £9. Course Curriculum Module 1:- Business Planning and Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Module 2: -Business Administration and Branding Introduction 00:15:00 Make Yourself Well Recognised Before Your Customers 00:30:00 Wow Your Customers 00:30:00 Develop a Personal Style 00:30:00 Use Creative Imageries to Catch the Attention 00:30:00 Be a Traditionalist, Not a Fad Chaser 00:15:00 Bringing Out the Purple Cow in Your Business 00:30:00 Conclusion 00:15:00 Module 3: - Business Succession Planning Getting Started 00:30:00 Succession Planning Vs. Replacement Planning 01:00:00 Preparing for the Planning Process 01:00:00 Initiating Process 00:00:00 The SWOT Analysis 01:00:00 Developing the Succession Plan 01:00:00 Executing the Plan 00:30:00 Gaining Support 00:30:00 Managing the Change 01:00:00 Overcoming Roadblocks 01:00:00 Reaching the End 01:00:00 Wrapping Up 00:15:00 Module 4: -Business Development Budgeting Businesses Budgeting Basics 00:15:00 Steps To Better Business Budgeting 00:15:00 How And What To Consider When Preparing A Business Plan And Budget 01:00:00 The Ins And Outs Of Corporate Budgeting 00:15:00 Including Social Business Budgets In The Plan 00:15:00 Impacts Of Debts On Business Budgets 00:15:00 Managing Business Budgets And Finances Together 01:00:00 Module 5: -Management Introduction 01:00:00 How to Build Trust and Confidence 01:00:00 A Manager's Pitfalls 01:00:00 How to Build Team Spirit 01:00:00 Dealing with Problem Employees 01:00:00 Using Your Emotional Intelligence 00:30:00 Conclusion to Management 00:15:00 Module 6:- Business Management Skills Business Plan Basics 00:30:00 The Executive Summary 01:00:00 The Mission Statement 00:30:00 Exploring Financial Needs 00:30:00 Evaluating Competition 01:00:00 The Troubles You Can Run Into Without The Proper Business Plan 00:30:00 Wrapping Up 00:15:00 Module 7: Project Management Introduction 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Managing A Budget 00:30:00 Taking Action - Execution of the Plan 01:00:00 Rules to Manage The Projects 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:30:00 Keeping It Moving Forward 01:00:00 Problems and Solutions in Project Management 01:00:00 Module 8: HR and Leadership Management Leader and HR Management 00:30:00 Commitment and HR Management 01:00:00 Team Management 00:30:00 Build A Mastermind Group 02:00:00 People Recognition in HR Management 00:30:00 Performance, Goals and Management 00:30:00 Think Outside The Box 00:30:00 Be Passionate about Your Work 00:30:00 The Importance Of A Good Team Leader 00:30:00 Module 9: Business Systemization Introduction 00:30:00 The Idea of Systemizing Your Business 01:00:00 Why You Should Systemize Your Business 01:00:00 A Lesson Learned From The Book 'The E-Myth' 01:00:00 So, How Do I Create This Wonderful Business System? 01:00:00 Outsourcing As a Way of Systemizing Your Business 00:30:00 How to Keep It Growing: The Systemized Business 01:00:00 Some General Ideas To Consider As You Systemize Your Business 00:30:00 Conclusion 00:15:00 Module 10: - Business Ethics Fundamentals Getting Started To Business Ethics 00:15:00 What is Ethics? 01:00:00 Implementing Ethics in the Workplace 00:30:00 Employer/Employee Rights 01:00:00 Business & Social Responsibilities 01:00:00 Ethical Decisions 01:00:00 Whistle Blowing 00:30:00 Managerial Ethics 00:30:00 Unethical Behavior 00:30:00 Ethics in Business (I) 01:00:00 Ethics in Business (II) 00:30:00 Wrapping Up 00:15:00 Module 11: Sales Analysis and Sales What Is A Sales Funnel? 00:30:00 What is Internet Commerce 00:30:00 What Can I Sell 00:30:00 Clickbank 00:30:00 Drop Shipping 00:30:00 Affiliate Marketing 00:30:00 The Link Between Products, Key Words and Prospects 00:15:00 The Front-end and Back-end of Sales Funnels 00:30:00 Sales Funnel Success 00:30:00 Sales Funnel Planning 00:30:00 Putting Your Theory to Practice 00:30:00 Content Marketing 00:30:00 Article Marketing 01:00:00 Google's Adwords Program 00:30:00 Marketing Offline 00:30:00 Blogs 00:30:00 Social Media 00:30:00 Auto Responders 00:30:00 The Joint Venture 00:30:00 Measuring Success 00:30:00 Top Sales Funnel Products 00:30:00 Mock Exam Mock Exam- Executive Mini MBA 00:30:00 Final Exam Final Exam - Executive Mini MBA 00:20:00 Recommended Readings Recommended Readings - Executive Mini MBA 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Level 2 Award in Support Work in Schools and Colleges Are you thinking about becoming a trained teaching assistant to help in the growth and development of students in the classroom? If so, our special course on Level 2 Award in Support Work in Schools and Colleges is ready for you to support on teaching and learning. The goals of the Level 2 Award in Support Work in Schools and Colleges programme is to enables learners to work directly with children and young people in educational settings. Through Level 2 Award in Support Work in Schools and Colleges training, you can provide essential information and insights to your students. Level 2 Award in Support Work in Schools and Colleges places a focus on the students development and wellbeing. As well as the Level 2 Award in Support Work in Schools and Colleges, discover how to help kids and teenagers build their self-worth, independence, and academic abilities. To begin your fulfilling career in education, enrol in our Level 2 Award in Support Work in Schools and Colleges course right away. Main Course: Level 2 Award in Support Work in Schools and Colleges Free Courses are including with this Level 2 Award in Support Work in Schools and Colleges Course Along with The Level 2 Award in Support Work in Schools and Colleges Course, We Offer a free School Administrator Training Course Along with The Level 2 Award in Support Work in Schools and Colleges Course, We Offer a free Level 2 Certificate in Behaviour that Challenges in Children Course Special Offers of this Level 2 Award in Support Work in Schools and Colleges Course This Level 2 Award in Support Work in Schools and Colleges Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Award in Support Work in Schools and Colleges Course Instant access to this Level 2 Award in Support Work in Schools and Colleges Course Get FREE Tutor Support to this Level 2 Award in Support Work in Schools and Colleges Course Level 2 Award in Support Work in Schools and Colleges Online Upon completion of this Support Worker: Support Worker course, you will possess the specialized skill set needed to help families with all kinds of issues. Furthermore, this thorough Support Worker: Support Worker course will improve your employability and equip you with all the knowledge you need to achieve the best possible results. Enroll in Support Worker: Support Worker now to get started on your education! Who is this course for? Level 2 Award in Support Work in Schools and Colleges These occupations are appropriate for this Level 2 Award in Support Work in Schools and Colleges qualification: Existing or prospective teaching assistants People who are considering a career in education Professionals who work in educational institutions such as colleges or schools and who want to get a recognized certification in supporting teaching and learning Requirements Level 2 Award in Support Work in Schools and Colleges To enrol in this Support Work in Schools and Colleges Course, students must fulfil the following requirements. To join in our Support Work in Schools and Colleges Course, you must have a strong command of the English language. To successfully complete our Level 2 Award in Support Work in Schools and Colleges Course, you must be vivacious and self driven. To complete our Level 2 Award in Support Work in Schools and Colleges Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Support Work in Schools and Colleges Course. Career path Level 2 Award in Support Work in Schools and Colleges Learners who successfully complete the Level 2 Award in Support Work in Schools and Colleges may pursue a number of employment choices in the education industry. Listed below are a few prospective job paths: Teacher Education Professional Education Trainer Teaching Assistant Early Years Practitioner Welfare Officer Childcare Worker

Cleaning: Level 5 British Cleaning Certificate Training Online Taking care of the environment ! - Enrol in our Level 5 British Cleaning Certificate Course if you are passionate about maintaining a healthy and clean environment. The Level 5 British Cleaning Certificate Course covers all you need to know to advance in the cleaning industry in the United Kingdom. By enrolling in the Level 5 British Cleaning Certificate Course, you have the opportunity to significantly boost your earning potential. A major focus of the Level 5 British Cleaning Certificate Course is enhancing your competency as a person in your industry of choice and learning vital career insights in the relevant employment area. This Level 5 British Cleaning Certificate Course is jam-packed with the advice and methods you require for increasing the number of clients you take on, expanding your clientele, marketing your business online, and developing the most effective business plan. You will learn how to complete these jobs with our Level 5 British Cleaning Certificate Course. The Level 5 British Cleaning Certificate Course is intended for those who want to start a cleaning business or become professional cleaners. The Level 5 British Cleaning Certificate Course offers practical training in a variety of topics, including cleaning techniques, chemical safety, housekeeping, kitchen maintenance, and more. The Level 5 British Cleaning Certificate Course offers crucial information on marketing your cleaning services, instructing staff, and interacting with clients. Join our Level 5 British Cleaning Certificate Course to strengthen your resume and find employment swiftly! Special Offers of this Cleaning: Level 5 British Cleaning Certificate Course This Cleaning: Level 5 British Cleaning Certificate Course includes a FREE PDF Certificate. Lifetime access to this Cleaning: Level 5 British Cleaning Certificate Course Instant access to this Cleaning: Level 5 British Cleaning Certificate Course Get FREE Tutor Support to this Cleaning: Level 5 British Cleaning Certificate Course Cleaning: Level 5 British Cleaning Certificate Training Online The Cleaning: Level 5 British Cleaning Certificate is the ultimate course for anyone looking to build a career in the cleaning industry or start their own cleaning business. This Cleaning: Level 5 British Cleaning course offers hands-on training in essential cleaning procedures, chemical safety, and housekeeping skills. You’ll also gain knowledge in kitchen maintenance, making this Cleaning: Level 5 British Cleaning qualification highly versatile. Additionally, the Cleaning: Level 5 British Cleaning course teaches you how to effectively promote your services, train employees, and maintain excellent customer relations, setting you up for success in the competitive cleaning industry. Who is this course for? Cleaning: Level 5 British Cleaning Certificate Anyone seeking to begin a career in the cleaning industry should enrol in our Cleaning: Level 5 British Cleaning Certificate Course. It includes the following: Cleaning Supervisor Hotel Cleaner Office Cleaner School Cleaner Requirements Cleaning: Level 5 British Cleaning Certificate To enrol in this Level 5 British Cleaning Certificate Course, students must fulfil the following requirements. To join in our Cleaning: Level 5 British Cleaning Certificate Course, you must have a strong command of the English language. To successfully complete our Cleaning: Level 5 British Cleaning Certificate Course, you must be vivacious and self driven. To complete our Cleaning: Level 5 British Cleaning Certificate Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Cleaning: Level 5 British Cleaning Certificate Course. Career path Cleaning: Level 5 British Cleaning Certificate With a salary range of £9.00 to £12.00 per hour, this Cleaning: Level 5 British Cleaning Course will open up a wide number of job options for you. such as a housekeeper, custodian, or cleaner.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum 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:03: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:03: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.mp4 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 Little Slice of Pie Charts 00:05: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:06: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.mp4 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 Excels 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 The 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:13: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 Loop 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 00:00:00

MiDAS is the Minibus Driver Awareness Scheme, organised by the Community Transport Association UK (CTA) which promotes a nationally recognised standard for the assessment and training of minibus drivers. The course is designed to enhance minibus driving standards and promote the safer operation of minibuses.