3565 Courses in Cardiff delivered On Demand

Housekeeping: Housekeeping Online Training Have you ever dreamt of launching a new company in the UK or advancing your career as a housekeeper? With our housekeeping: housekeeping training, you may improve your abilities in this crucial field. The key subjects of our special housekeeping: housekeeping course include health and safety regulations and housekeeping: housekeeping laws. You'll learn the principles of housekeeping: housekeeping. In addition to teaching how to organise and structure a housekeeping: housekeeping department, this course also covers staff management. Budgeting and inventory control are also included in this housekeeping: housekeeping training. You will also learn how to operate the laundry and maintain the carpet during this housekeeping: housekeeping training. Take this housekeeping: housekeeping course to learn best practices and have a thorough understanding of housekeeping! Main Course: Housekeeping Course Others benefit Included with Housekeeping: Housekeeping Course. Free 01 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam Special Offers of this Housekeeping: Housekeeping Course: This Housekeeping: Housekeeping Course includes a FREE PDF Certificate. Lifetime access to this Housekeeping: Housekeeping Course Instant access to this Housekeeping: Housekeeping Course 24/7 Support Available to this Housekeeping: Housekeeping Course [ Note: Free PDF certificate as soon as completing the Housekeeping: Housekeeping Course] Housekeeping: Housekeeping Course Online This housekeeping Course consists of 05 modules. Course Curriculum of Housekeeping: Housekeeping Course Module 01: Introduction to Housekeeping Module 02: Housekeeping Operations Module 03: Specialized Housekeeping Areas Module 04: Sustainability Practices in Housekeeping Module 05: Housekeeping Career in the UK Assessment Method of Housekeeping: Housekeeping Course After completing housekeeping: housekeeping Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Housekeeping: Housekeeping Course After completing the housekeeping: housekeeping Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Housekeeping: Housekeeping Course Online This housekeeping: housekeeping course is open to anybody, regardless of expertise level. Requirements Housekeeping: Housekeeping Course Online To enroll in this housekeeping: housekeeping Course, students must fulfil the following requirements: Good Command over English language is mandatory to enroll in our housekeeping: housekeeping Course. Be energetic and self-motivated to complete our housekeeping: housekeeping Course. Basic computer Skill is required to complete our housekeeping: housekeeping Course. If you want to enrol in our housekeeping: housekeeping Course, you must be at least 15 years old. Career path Housekeeping: Housekeeping Course Online Your job options in this profession may become more apparent if you take this housekeeping: housekeeping course.

Course Overview The demand for iOS apps is increasing every day. If you want to build your career as an app developer or programmer, learning iOS app development will be a smart choice for you. Learn how to create iOS apps using Swift 5 from this Build your first iOS 14 apps using swift 5 course and take your first step to be a pro developer. This course will help you understand Swift coding and solve your problems with app development. In this Build your first iOS 14 apps using swift 5 course, you will learn about the functions of Swift programming, variables and types, operations, collections, flow control, classes and inheritance. You will be able to create your first iOS app using swift 5 and enhance your skill to start your career as an iOS app developer.  This course will help you understand the app development process step by step with easily understandable bite-sized lessons.  Learning Outcomes Get a clear understanding of the fundamentals of iOS and Swift development Learn iOS development programming from scratch Be able to operate Swift 5 Learn the functions of Swift 5 Learn what you should consider before making an iOS app Gain the skills to be an efficient app developer Who is this course for? This course is designed for you to learn how to design iOS applications using swift 5. Anyone interested in app development can learn effective app development skills from this course 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 Build your first iOS 14 apps using swift 5 is a useful qualification to possess and would be beneficial for any related profession or industry such as: Ios Developers Programmers Designers Unit 01: Introduction Module 01: Setup 00:02:00 Module 01: A Quick Reminder 00:01:00 Unit 02: Variables and Types in Swift Programming Module 01: Variables Strings and Constants in Swift 00:08:00 Module 02: Solution - Variables Strings and Constants in Swift 00:01:00 Module 03: Variables and Numbers in Swift 00:07:00 Module 04: Solution - Variables and Numbers in Swift 00:01:00 Module 05: Type conversions in Swift - Danger Will Robinson 00:05:00 Module 06: Solution - Type conversions in Swift - Danger Will Robinson 00:02:00 Module 07: Tuple Types in Swift 00:05:00 Module 08: Solution - Tuple Types in Swift 00:02:00 Unit 03: Optionals in Swift and the Null Problem Module 01: Optionals Nulls and Variables in Swift 00:05:00 Module 02: Solution - Optionals Nulls and Variables in Swift 00:01:00 Unit 04: Operators in Swift Module 01: Operators in Swift - Assignment Arithmetic and Concatenation 00:04:00 Module 02: Solution - Operators in Swift - Assignment Arithmetic and Concatenation 00:01:00 Module 03: Operators in Swift - Unary Compound Logic and Comparison 00:04:00 Unit 05: Collections in Swift Module 01: Collections in Swift - Arrays 00:05:00 Module 02: Solution - Collections in Swift - Arrays 00:02:00 Module 03: Collections in Swift - Sets 00:06:00 Module 04: Collections in Swift - Dictionaries 00:05:00 Module 05: Solution - Collections in Swift - Dictionaries 00:03:00 Unit 06: Flow Control in Swift Module 01: Controlling Flow in Swift - for in loops 00:08:00 Module 02: Solution - Controlling Flow in Swift - for in loops 00:03:00 Module 03: Controlling Flow in Swift - While loops 00:04:00 Module 04: Solution - Controlling Flow in Swift - While loops 00:02:00 Unit 07: Conditional Statements in Swift Module 01: Conditional Statements in Swift - If Else 00:04:00 Module 02: Solution - Conditional Statements in Swift - If Else 00:02:00 Module 03: Conditional Statements in Swift - Switch Case 00:04:00 Module 04: Solution - Conditional Statements in Swift - Switch Case 00:02:00 Unit 08: Control Transfer in Swift Module 01: Control Transfer in Swift - continue break fallthrough return throw 00:06:00 Unit 09: Functions in Swift Module 01: Functions in Swift 00:10:00 Module 02: Solution - Functions in Swift 00:03:00 Module 03: Nested Functions in Swift 00:04:00 Module 04: Solution - Nested Functions in Swift 00:03:00 Unit 10: Enumerations in Swift Module 01: Enumerations in Swift 00:05:00 Module 02: Solution - Enumerations in Swift 00:01:00 Unit 11: Classes and Inheritance in Swift Module 01: Classes in Swift 00:05:00 Module 02: Solution 1 - Classes in Swift 00:02:00 Module 03: Solution 2 - Classes in Swift 00:02:00 Module 04: Inheritance in Swift 00:07:00 Module 05: Solution - Inheritance in Swift 00:04:00 Unit 12: Your First iOS App Module 01: Your First iOS App and Familiarisation 00:05:00 Module 02: The Key iOS Project Files 00:06:00 Module 03: How to Implement a Button in the User Interface 00:05:00 Module 04: How to Connect a Button to Code in Xcode 00:05:00 Module 05: Writing Code to Change a Views Appearance and a TASK 00:02:00 Module 06: Solution to the Task and If Else View Colors 00:07:00 Unit 13: Temperature Conversion App - iOS Layouts Positioning and Buttons Module 01: A Preview of the App We Will Build 00:01:00 Module 02: Create the App and Its User Interface 00:02:00 Module 03: iOS Layouts and Positioning 00:10:00 Module 04: Connecting UI Elements to Code 00:05:00 Module 05: Converting Temperature via Button Click 00:06:00 Module 06: Adding a Bit of Excellence to the UI and a Task for You 00:06:00 Module 07: Task Solution - Adding a Conversions Counter Label 00:07:00 Unit 14: Gods App - Navigation Table Views and Data Passing Module 01: What we are Building 00:02:00 Module 02: Creating the GreekGod Data Model 00:06:00 Module 03: Navigation Controllers in iOS 00:06:00 Module 04: Creating Fake Gods 00:04:00 Module 05: How to Set Up a Table View and Its Controller 00:11:00 Module 06: Task Solution - How to Fix the Table View 00:04:00 Module 07: How to Navigate from Table View to New View in iOS 00:04:00 Module 08: Create a View Controller for the Detail View 00:03:00 Module 09: Passing Data from Table View to View Controller 00:04:00 Module 10: Setting up a Detail View Controller with Passed Data 00:11:00 Module 11: Using Images and ImageViews in Swift - And a Task 00:04:00 Module 12: Solution to the Task 00:04:00 Unit 15: Will I Burn App - Accessing APIs and Device Hardware - GPS Module 01: Preview of the App We Will Make 00:02:00 Module 02: Structures Instead of Classes 00:05:00 Module 03: How to Request Permissions and Capabilities in iOS 00:04:00 Module 04: Requesting User Permissions in iOS - Part 2 00:09:00 Module 05: Requesting User Permissions in iOS - Part 3 00:07:00 Module 06: Creating a SWEET User Interface 00:09:00 Module 07: Task - Connect the UI to Code 00:01:00 Module 08: Connecting User Interface to Code 00:02:00 Module 09: Action Sheet Alerts in iOS 00:05:00 Module 10: Update a Label and Thoughts on Storage 00:03:00 Module 11: User Defaults Storage in iOS 00:05:00 Module 12: Getting and Setting User Defaults in iOS 00:04:00 Module 13: Getting a Location in Latitude and Longitude in iOS Apps 00:04:00 Module 14: Selecting an API Provider for Your Apps 00:07:00 Module 15: Generating an API Key and Exploring the Docs 00:04:00 Module 16: Create an API Access Class in Swift 00:04:00 Module 17: Using Third Party Libraries in iOS - AlamoFire 00:06:00 Module 18: How to Use AlamoFire in iOS 00:08:00 Module 19: How to Extract JSON Data from an API Call 00:06:00 Module 20: Performing Background Calculations in iOS 00:06:00 Module 21: Performing Background Calculations in iOS - Part 2 00:07:00 Module 22: Activity Indicators in iOS and Swift 00:07:00 Module 23: Local Notifications in iOS 00:06:00 Module 24: Solution to the Task - UI Smoothing 00:05:00 Unit 16: Whatsapp Clone Using Google Firebase Module 01: Preview of What We're Building 00:03:00 Module 02: Should you Choose Firebase or Firestore 00:10:00 Module 03: Create a Firebase Application 00:03:00 Module 04: Installing Firebase in your iOS App 00:09:00 Module 05: Firebase Authentication Options 00:05:00 Module 06: Designing the Auth Screen 00:10:00 Module 07: Connecting UI to Code 00:04:00 Module 08: Showing the Auth Screen 00:11:00 Module 09: Validating User Input for Firebase Authentication 00:08:00 Module 10: Register a User in Firebase 00:05:00 Module 11: Logging in via Firebase 00:06:00 Module 12: Set Activity Indicator to Show Network Processing 00:07:00 Module 13: How to Reset a Firebase User Password 00:11:00 Module 14: How to Prevent Dismissal of a View Controller 00:02:00 Module 15: Setting up a Table View and Cell Manually 00:11:00 Module 16: Connecting a TableView and ViewController Manually 00:05:00 Module 17: Implementing TableView Functions in the ViewController 00:06:00 Module 18: Listening to Firebase Data Streams on iOS 00:09:00 Module 19: Demo with Dummy Data 00:03:00 Module 20: Using a TextField Delegate in iOS 00:03:00 Module 21: Sending Data from iOS to Firebase Database 00:05:00 Module 22: Well Done and a Couple HARD TASKS with NO SOLUTION 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Join the club of big players in the pet business world. Build your brand's image with the best service. Learn Running A Dog Training Business, How To Choose A Niche Or Target Market.

------------------------NEW YEAR SALE ENDS TODAY------------------------ The Leadership & Management Diploma offers a robust foundation for anyone aspiring to excel in leadership & management roles across various sectors. This comprehensive program includes essential courses such as Facilities Management Level 3 and the Applied Business Analysis Diploma, providing you with a well-rounded understanding of effective leadership & management practices. You will explore critical areas such as decision-making, stress management, and the development of people management skills that are vital for successful leadership & management. In addition to foundational courses, the diploma incorporates specialized training in motivation skills and performance management, equipping you with the tools to inspire and drive your team effectively. The Level 3 Project Management course will further enhance your ability to manage projects efficiently, while Sales Negotiation Training offers practical techniques to strengthen your negotiation skills—essential for any leader in today’s competitive leadership & management environment. By enrolling in the Leadership & Management Diploma, you will gain valuable insights into decision-making and critical thinking, enabling you to navigate complex challenges with confidence. This course is designed to boost your career prospects in leadership & management, providing the skills needed to lead effectively and make informed decisions that contribute to your organization's success in the field of leadership & management. Along with this Leadership & Management Diploma course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Leadership & Management Diploma Bundle Consists of the following Premium courses: Course 01: Leadership & Management Diploma Course 02: Facilities Management Level 3 Course 03: Applied Business Analysis Diploma Course 04: Decision Making Course 05: Stress Management Training Course 06: People Management Skills Level 3 Course 07: Motivation Skills Course 08: Level 3- Project Management Course 09: Performance Management Course 10: Sales Negotiation Training Course 11: Decision-Making and Critical Thinking Enrol now in the Leadership & Management Diploma to advance your career, and use the premium study materials from Apex Learning. Key Features of the Course: FREE Leadership & Management Diploma CPD-accredited certificate Get a free student ID card with Leadership & Management Diploma training (£10 applicable for international delivery) Lifetime access to the Leadership & Management Diploma course materials The Leadership & Management Diploma program comes with 24/7 tutor support Get instant access to this Leadership & Management Diploma course Learn Leadership & Management Diploma training from anywhere in the world The Leadership & Management Diploma training is affordable and simple to understand The Leadership & Management Diploma training is entirely online Learning Outcomes: Understand key leadership & management principles and practices. Master effective decision-making techniques for organizational challenges. Enhance people management skills to foster a motivated team. Learn stress management strategies for a positive work environment. Acquire performance management expertise to improve team effectiveness. Implement negotiation techniques for successful interactions. Gain insights into project management methodologies for timely delivery. Understand facilities management's role in operational efficiency. Description The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Leadership & Management Diploma expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Course 1: Leadership & Management Diploma Understanding Management and Leadership Leadership Theories Improving Management and Leadership Performance High Performance Teams Motivating Employees Organisational Skills Talent Management Succession Planning Business Process Management Communication Skills Negotiation Techniques Managing Meetings and Giving Feedback Managing Change Time Management Stress Management Emotional Intelligence in Leadership Managing Conflict Dealing with Office Politics Risk Management Corporate Responsibility and Ethics Course 2: Facilities Management Module 01: Introduction to Facility Management Module 02: Space Management Module 03: Managing Workplace Services Module 04: Human Resource and Contract Management Module 05: Lease Purchase and Vendor Management Module 06: Health and Safety at Work Module 07: Sustainable Facility Management Module 08: Maintenance and Repairs Module 09: Project Management Module 10: Business Development and Succession Planning Course 3: Applied Business Analysis Diploma Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Documenting and Managing Requirements Module 09: Career Prospect as a Business Analyst in the UK Course 4: Decision Making Module 01: What is Decision Making? Module 02: Stress and Its Impact Module 03: Time Stress and Decision Making Module 04: Personal Level Decision making Under Stress Module 05: Organisational Level Decision making Under Stress Module 06: Decision Making for Conflict Management Course 5: Stress Management Training Module 01: Beginning Concepts Module 02: Specific Stress Management Techniques Module 03: MORE Stress Reduction Strategies Module 04: Still MORE Stress Reduction Techniques - Part 1 Module 05: Still MORE Stress Reduction Techniques - Part 2 Module 06: Still MORE Stress Reduction Techniques - Part 3 Module 07: BONUS Video & Wrap Up! Module 08: Special LIVE Bonus Video! Course 6: People Management Skills Level 3 Module 01: Introduction to Human Resources Module 02: Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Performance Appraisal Management Module 05: Employee Relations Module 06: Motivation and Counselling Module 07: Ensuring Health and Safety at the Workplace Module 08: Employee Termination Module 09: Employer Records and Statistics Module 10: Essential UK Employment Law Course 7: Motivation Skills Module 01: Introduction Module 02: Motivational Skills Module 03: Motivational Strategies Module 04: Conclusion Course 8: Level 3- Project Management Key Concepts (I) Key Concepts (II) Initiation (I) Initiation (II) Planning (I) Planning (II) Planning Tools Executing the Project Maintaining and Controlling the Project Closing Out Course 9: Performance Management Module 01: Introduction Module 02: Performance Module 03: Key Performance Indicators Module 04: Reporting Module 05: Rewarding Module 06: Conclusion Course 10: Sales Negotiation Training Sales Negotiation Training Negotiation Station - How To Negotiate Successfully Course 11: Decision Making and Critical Thinking Module 01: Introduction to Critical Thinking Module 02: Critical Thinking and the Judgment of Claims Module 03: Benefits and Barriers of Critical Thinking Module 04: Importance of Critical Thinking Module 05: Recognising a Critical Thinker Module 06: What Are the Critical Thinking Steps? Module 07: Critical Thinking Strategies Module 08: Problem-Solving Through Critical Thinking Module 09: Decision Making with Critical Thinking Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Leadership & Management Diploma bundle. Requirements This Leadership & Management Diploma course has been designed to be fully compatible with tablets and smartphones. Career path With the Leadership & Management Diploma, you can explore a variety of rewarding career opportunities, including: Team Leader: £25,000 - £40,000 Project Manager: £30,000 - £50,000 Operations Manager: £35,000 - £60,000 Department Manager: £30,000 - £55,000 HR Manager: £35,000 - £60,000 General Manager: £40,000 - £70,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Leadership & Management Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

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

Overview of MySql Masterclass Join our MySql Masterclass 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 MySql Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The MySql Masterclass 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! This MySql Masterclass Course will help you to learn: 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 MySql Masterclass. 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 Certificate of Completion – Digital / PDF Certificate After completing the MySql Masterclass course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This MySql Masterclass 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 You don’t need any educational qualification or experience to enrol in the MySql Masterclass 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 MySql Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Business Process Management: Business Process Management Course Online Unlock the Power of Business Process Management: Business Process Management Course: Enrol Now! Are you a working professional with a focus on business processes or management who aspires to take the lead in various methods for discovering, modelling, analysing, measuring, improving, optimising, and automating business processes? Then our Business Process Management: Business Process Management Course is just what you need! Through this Business Process Management: Business Process Management Course you will gain a thorough understanding of the evolution of enterprise systems architectures, Business Process Management: Business Process Management Course and an introduction to the business process life cycle. You will also learn the steps of business process mapping with flow charts and diagrams, establishing business functions, identifying function leaders and adequately planning the modelling, monitoring and optimising phase. Main Course: Business Process Management course Free Courses included with Business Process Management: Business Process Management Course: Course 01: Level 5 Diploma in Business Analysis Course 02: Level 7 Diploma in Operations Management Course 03: Level 7 Life Coaching [ Note: Free PDF certificate as soon as completing Business Process Management: Business Process Management Course] Business Process Management: Business Process Management Course Online This Business Process Management: Business Process Management Course consists of 08 modules. Course Curriculum of Business Process Management: Business Process Management Course Module 01: Introduction to Business Process Management Module 02: Evolution of Enterprise Systems Architectures Module 03: Business Process Modelling Foundation Module 04: Process Orchestrations Module 05: Process Choreographies Module 06: Properties of Business Processes Module 07: Architectures and Methodologies Module 08: Business Process Management Methodology Assessment Method of Business Process Management: Business Process Management Course After completing Business Process Management: Business Process Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Business Process Management: Business Process Management Course Online This Business Process Management: Business Process Management Course is designed for anyone who wants to enhance their business process management skills. Requirements Business Process Management: Business Process Management Course Online To enrol in this Business Process Management: Business Process Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Process Management: Business Process Management Course. Be energetic and self-motivated to complete our Business Process Management: Business Process Management Course. Basic computer Skill is required to complete our Business Process Management course. If you want to enrol in our Business Process Management course, you must be at least 15 years old. Career path Business Process Management: Business Process Management Course Online After completing this Business Process Management: Business Process Management Course, you may able to pursue a variety of promising career opportunities, such as: Business Process Manager Business Analyst Entrepreneur Business Owner

Private Investigator: Private Investigator Course Online As a private investigator, are you keen to hone your investigation skills? Then, for comprehensive knowledge and practical skills in this field, we kindly welcome you to join our engaging and comprehensive Private Investigator Course. You will dig into the core ideas of Private Investigator and examine a variety of its facets during this Private Investigator: Private Investigator Course. Furthermore, the Private Investigator Course elucidates sophisticated methods and practical applications. Additionally, the Private Investigator Course will meet your demands and assist you in reaching your educational objectives. Learning the many travels and tricks of the investigation industry is facilitated by the Private Investigator Course. Enrol in our Private Investigator: Private Investigator Course as soon as possible to learn about company operations, ethics, professionalism, and information sources! Main Course: Private Investigator Course Free courses included with Private Investigator: Private Investigator Course: Along with Private Investigator Course you will get free Criminology Course Along with Private Investigator Course you will get free Close Protection Special Offers of this Private Investigator: Private Investigator Course: This Private Investigator: Private Investigator Course includes a FREE PDF Certificate. Lifetime access to this Private Investigator: Private Investigator Course Instant access to this Private Investigator: Private Investigator Course 24/7 Support Available to this Private Investigator: Private Investigator Course Private Investigator: Private Investigator Course Online Throughout the Private Investigator: Private Investigator Course, you will learn the basics of private investigation, its process, classification and investigation. The Private Investigator: Private Investigator Course also explains crime scene investigation and photography. In the next module of the Private Investigator: Private Investigator Course, you will find out how to collect evidence, locate missing persons and do these related things. The Private Investigator: Private Investigator Course also help you to improve your ethics and professionalism. Moreover, the Private Investigator: Private Investigator Course will describe briefly about the business and its improvement techniques. Who is this course for? Private Investigator: Private Investigator Course Online Those who wish to advance their skills and knowledge in the field of private investigation can consider enrolling in the Private Investigator: Private Investigator Course Diploma. Requirements Private Investigator: Private Investigator Course Online To enrol in this Private Investigator: Private Investigator Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Private Investigator: Private Investigator Course. Be energetic and self-motivated to complete our Private Investigator: Private Investigator Course. Basic computer Skill is required to complete our Private Investigator: Private Investigator Course. If you want to enrol in our Private Investigator: Private Investigator Course, you must be at least 15 years old. Career path Private Investigator: Private Investigator Course Online Numerous exciting work opportunities in private investigator-related businesses might arise from successfully completing the Private Investigator: Private Investigator Course. As an illustration: Expert in Private Investigations Researcher and Private Investigator Instructor and Private Investigator

Facilities Management: Facilities Management Course Online This Facilities Management: Facilities Management course will assist you in broadening your knowledge and understanding of the facilities management: facilities management sector. The course is designed for senior managers in the sector and emphasises a balance between the practical and theoretical aspects of working in facilities management: facilities management. Throughout this Facilities Management: Facilities Management course, you will be able to develop your ability to reformulate and apply relevant knowledge, skills, and techniques in the field to meditate and solve complex problems. The Level 7 Diploma in Facilities Management: Facilities Management course covers facilities planning, change management, vendor management & outsourcing, facilities management: facilities management service providers and much more. By the end of this Facilities Management: Facilities Management course, you will be able to examine the art of effective vendor relations and contract management, the significance of quality management, human resource management strategies, and the purpose of contingency planning. Learn how to be an invaluable contributor in any organisational setting by enrolling in our exclusive Level 7 Diploma in Facilities Management: Facilities Management course. Main Course: Facilities Management Diploma Additional Courses included with Facilities Management : Facilities Management course Course 01: Level 2 Certificate in Business Management Course 02: Level 7 Diploma in Operations Management Course 03: Level 4 Time Management Course 04: Level 7 Leadership & Management Course 05: Level 7 Business Management [ Note: Free PDF certificate as soon as completing the Facilities Management: Facilities Management course] Facilities Management: Facilities Management Course Online This Facilities Management: Facilities Management Course consists of 14 modules. Assessment Method of Facilities Management: Facilities Management Course After completing Facilities Management: Facilities Management - Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Facilities Management: Facilities Management Course After completing the Facilities Management: Facilities Management - Course, you can instantly download your certificate for FREE. Who is this course for? Facilities Management: Facilities Management Course Online This Facilities Management: Facilities Management - Course is ideal for those looking for a formal qualification to advance their careers in any of the following fields: - Facilities Managers, Facilities Coordinator, Facilities Assistant, Facilities Administrator. Requirements Facilities Management: Facilities Management Course Online To enrol in this Facilities Management: Facilities Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Facilities Management: Facilities Management Course. Be energetic and self-motivated to complete our Facilities Management: Facilities Management Course. Basic computer Skill is required to complete our Facilities Management: Facilities Management Course. If you want to enrol in our Facilities Management: Facilities Management Course, you must be at least 15 years old. Career path Facilities Management: Facilities Management Course Online This Facilities Management: Facilities Management Course will lead you to many different career opportunities; here are few prospects: - Facilities Management: Facilities Management Tutor: £27,000 - £27,001 per annum Head of Facilities Management: £11.50 per hour Administrator - Facilities Management: £10.58 per hour.

This Hotel & Hospitality Management Diploma with Holiday Representative Training will provide you with an understanding of the interrelationships between departments that drive performance in the hotel and resort industry. The course will introduce to the central philosophies of facilities and resource management, operating procedures and compliance requirements. You will focus on developing and maintaining effective teamwork and the management of staff relationships within a hospitality team. You will become proficient in developing food and beverage menus that meet cost requirements and the management of staff training processes. You'll learn about food service operations alongside a variety of academic disciplines, including foreign languages. This course covers a range of topics such as hotels, resorts, cruise ships, private / corporate owned restaurants and special catering events. You'll also be provided with cash handling, function, restaurant service, and barista skills. Who is this course for? Retail Customer Service and Visual Merchandising Training is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Retail Customer Service and Visual Merchandising Training is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. 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. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Starting a Restaurant Are you ready for the challenge? 00:15:00 How to decide on a concept 00:30:00 Designing your restaurant 00:15:00 Friends and family 00:15:00 Writing a Business Plan 00:30:00 Insurance 00:15:00 Restaurant Organizations that you need to check out. 00:15:00 What are the best Catering Industry Trade Shows? 00:15:00 Managing a Restaurant Managing Yourself 00:30:00 Managing Others 00:30:00 Managing Your Money 00:15:00 Managing Your Food and Supplies 00:30:00 Managing Everything Else 00:30:00 Starting Food Catering Where You Work 00:15:00 Health and safety 00:15:00 Staff, Suppliers and Transport 00:00:00 Food Hygiene 01:00:00 Rules about Menus 00:15:00 Paperwork and Finances 00:15:00 Law 00:15:00 Food Business Food Business Basics 00:45:00 Put Together Your Business Concept 00:10:00 Identify Your Target Market 00:10:00 Identify Your Competition 00:10:00 Write A Mission Statement 00:10:00 Downline Basics 00:15:00 Equipment And Supplies 00:10:00 Marketing And Quality Control 00:10:00 Wrapping Up 00:05:00 Hospitality Introduction to Hospitality 00:15:00 Characteristics of the Hospitality Industry 00:15:00 Relationship Between the Hospitality Industry and Tourism 00:15:00 Types of Accommodation 00:15:00 Types of Room 00:30:00 Types of Hotel Guests 00:15:00 Hospitality Management Introduction to Hospitality Management 01:00:00 Influences Which Affect the Industry 00:05:00 The Development of the Hospitality Industry 00:05:00 Hospitality Brands 00:15:00 Accommodation 00:05:00 Food Service 00:05:00 Successful Quality Management 00:05:00 Holiday Representative Your Introduction to Becoming a Holiday Rep 00:15:00 Defining the Career of a Holiday Rep 00:30:00 Exploring the Various Types of Holiday Reps 00:30:00 Exploring the Origins and Growth of British Tourism 00:30:00 The Components of the Travel and Tourism Industry 00:15:00 Factors that Affect Your Career 00:30:00 Nailing the Teamwork Element Required to Surpass Expectations 01:00:00 The Standard Duties of Holiday Reps 00:15:00 The Legalities Holiday Reps Need to Know About 01:00:00 The Holiday Reps Role in Keeping their Guests Safe 00:30:00 Effective Handling of Customer Complaints 00:30:00 Administration Duties 00:15:00 Crushing It With Customer Services 00:30:00 Creating the Perfect Welcome Meeting 00:15:00 Guide to Selling Excursions 00:15:00 Preparing and Conducting Transfers Successfully 00:05:00 Tallying Floats and Converting Currencies 00:30:00 Mock Exam Mock Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Final Exam Final Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00