3681 Relationships courses in Cardiff delivered Online

*** Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now In the ever-evolving world of marketing, staying ahead of the competition is crucial for career success. The Sales and Marketing Training course is designed to provide you with cutting-edge marketing strategies and essential skills needed to thrive in today's competitive market. Whether you want to boost your digital marketing knowledge, improve social media marketing techniques, or master content marketing, this course will help you achieve your goals. Throughout the programme, you'll gain hands-on knowledge of SEO, email marketing, and consumer psychology to enhance your ability to connect with customers and increase sales. Learn how to create targeted marketing campaigns, optimize brand visibility, and analyze market trends to make data-driven decisions that improve performance. This course is ideal for professionals looking to expand their marketing expertise or pursue a career in sales and marketing management. Gain a competitive edge, develop advanced marketing skills, and take your career to new heights. Along with this Sales and Marketing course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Sales & Selling Management Course Course 02: Sales Negotiation Training Course 03: Telesales Executive Training Course 04: Marketing Fundamentals Course 05: Strategic Planning and Analysis for Marketing Course 06: Digital Marketing Course 07: SEO - Search Engine Optimisation Level 5 Course 08: Retail Management - Level 5 Course 09: Customer Relationship Management Course 10: Sales: Psychology of Customers Course 11: Basic Product Management Course 12: Product Photography Course 13: Commercial Law 2021 Course 14: Public Speaking and Presentation Skill Course Learning Outcomes: Upon completing the Sales and Marketing Training course, you will be able to: Develop and implement effective marketing strategies and sales techniques to drive business growth. Understand and apply the principles of consumer psychology and marketing analytics to influence purchasing decisions and improve sales. Utilise digital marketing tools and techniques, including social media marketing, email marketing, and SEO, to enhance brand visibility and reach. Create and execute compelling content marketing campaigns that engage target audiences and boost conversions. Analyze sales data, marketing performance, and market trends to optimize marketing efforts and improve decision-making processes. Manage customer relationships and improve communication through relationship marketing to increase sales and customer retention. Key Features of the Course: FREE Sales and Marketing Training CPD-accredited certificate Get a free student ID card with Sales and Marketing Training training (£10 applicable for international delivery) Lifetime access to the Sales and Marketing Training course materials The Sales and Marketing Training program comes with 24/7 tutor support Get instant access to this Sales and Marketing Training course Learn Sales and Marketing Training training from anywhere in the world The Sales and Marketing Training training is affordable and simple to understand The Sales and Marketing Training training is an entirely online Description: The Sales and Marketing Training course equips you with the essential skills and knowledge to excel in the dynamic world of marketing. From mastering digital marketing and social media marketing to understanding consumer psychology and content marketing, this comprehensive course covers all aspects of marketing strategies that drive sales and business growth. You will learn how to create impactful marketing campaigns, optimize brand visibility, and analyze market data to make informed decisions. Whether you're looking to advance in your current role or pursue a new career in marketing management, this course will give you the tools to succeed in today’s competitive landscape. Enrol in this Sales and Marketing Training course today and start your journey to becoming a successful marketing professional or sales expert! ★★★ Course Curriculum of Sales and Marketing Training Bundle ★★★ Course 01: Sales & Selling Management Course Module 01: Understanding the Talk Module 02: Getting Prepared to Make the Call Module 03: Creative Openings Module 04: Making Your Pitch Module 05: Handling Objections Module 06: Sealing the Deal Module 07: Following Up Module 08: Setting Goals Module 09: Managing Your Data Module 10: Using a Prospect Board Course 02: Sales Negotiation Training Course 03: Telesales Executive Training Course 04: Marketing Fundamentals Course 05: Strategic Planning and Analysis for Marketing Course 06: Digital Marketing Course 07: SEO - Search Engine Optimisation Level 5 Course 08: Retail Management - Level 5 Course 09: Customer Relationship Management Course 10: Sales: Psychology of Customers Course 11: Basic Product Management Course 12: Product Photography Course 13: Commercial Law 2021 Course 14: Public Speaking and Presentation Skill Course How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free Hard Copy Certificate: Free CPD 140 CPD hours / points Accredited by CPD Quality Standards Requirements There is no time limit for completing thiscourse; it can be studied in your own time at your own pace. Career path Elevate your professional journey with Sales and Marketing Training. This comprehensive course opens doors to a wide range of career opportunities in the dynamic world of marketing. Explore these exciting roles: Marketing Manager: £30,000 - £55,000 Digital Marketing Specialist: £25,000 - £45,000 Social Media Marketing Manager: £22,000 - £40,000 SEO Specialist: £24,000 - £42,000 Content Marketing Manager: £28,000 - £50,000 Email Marketing Specialist: £23,000 - £38,000 PPC Marketing Specialist: £26,000 - £42,000 Certificates Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Sales & Selling Management Course) absolutely Free! Other hard-copy certificates are available for £14.99 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

In today's competitive business environment, effective customer relationship management (CRM) is a must. This CPD Accredited CRM Course provides a solid understanding of the strategies and tools used to manage customer interactions and drive business growth. Designed to provide you with a thorough grounding in CRM principles, this course equips you with the knowledge needed to build strong customer connections, enhance loyalty, and improve overall business performance. Whether you're an aspiring marketer or looking to expand your skill set in the customer service realm, this course will give you the critical insights to handle customer relationships with confidence. The course content covers a wide range of topics including CRM strategy, customer segmentation, database management, and the role of technology in enhancing customer engagement. Delivered entirely online, it allows you to learn at your own pace while building up essential CRM expertise. By the end of the course, you’ll have a comprehensive understanding of the CRM landscape, along with the tools to implement successful strategies within your organisation, enhancing customer satisfaction and retention. This course provides the flexibility to improve your knowledge base from anywhere, with no need for physical attendance—ideal for busy professionals. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The CRM - Customer Relationship Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our CRM - Customer Relationship Management - CPD Accredited training.

In today’s fast-paced business environment, effective material management is a cornerstone for operational efficiency. This CPD Accredited course offers a comprehensive exploration of the core principles and best practices involved in managing materials within any organisation. From procurement and inventory control to forecasting and distribution, you will gain valuable insights that will directly contribute to streamlining operations and reducing costs. Designed for professionals across various industries, this course delves into key aspects that will enhance your ability to manage materials with precision and foresight. By completing this course, you’ll build a solid foundation in material management, learning how to optimise stock levels, improve supplier relationships, and implement strategies that contribute to a smoother supply chain. Whether you’re looking to improve processes within your current role or looking to advance your career, this course offers a flexible and effective approach to mastering material management. With its clear structure and in-depth content, it provides the knowledge you need to navigate the complexities of this vital area with confidence. Course Curriculum: Module 01: Introduction to Material Management Module 02: Purchasing and Supply Chain Management Module 03: Inventory Management, Planning and Control Module 04: Stores Management and Control Module 05: Forecasting Module 06: Material Requirements Planning Module 07: Materials Handling Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Material Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Material Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Material Management - CPD Accredited training.

Corporate Social Responsibility (CSR) is no longer just a moral footnote tucked away in annual reports; it’s become a defining aspect of how organisations are perceived, trusted, and remembered. Our CPD Accredited CSR course dives into the heart of modern business responsibility—offering insight into the ethical, environmental, and social expectations placed on companies today. Whether you're managing a business or just trying to make sense of ESG headlines over your morning coffee, this course is designed to bring clarity to the murky world of corporate accountability. Expect to explore how CSR strategies influence stakeholder relationships, shape public reputation, and affect long-term sustainability goals (without needing a whiteboard or awkward team-building exercise in sight). You'll cover everything from environmental impact and supply chain ethics to community engagement and governance—all online, all self-paced. It's CSR education that gets to the point, avoids jargon, and adds just enough wit to make the subject more palatable than your average policy memo. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: CSR Module 01: Introduction to Corporate Social Responsibility CSR Module 02: Stakeholders & the Social Contract CSR Module 03: A Sustainable Perspective CSR Module 04: Implementing CSR CSR Module 05: Performance Evaluation and Performance Reporting Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this CSR - Corporate Social Responsibility - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The CSR - Corporate Social Responsibility - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our CSR - Corporate Social Responsibility - CPD Accredited training.

Overview of Recruitment Consultant Training In today’s competitive job market, Recruitment Consultants play an important role in connecting skilled candidates with businesses looking to grow. The UK recruitment industry is strong, with over £38.9 billion in yearly revenue and more than 115,000 people working in around 31,000 recruitment companies. This Recruitment Consultant Training course is designed to help you build a successful career in this fast-moving field by teaching you both the practical and strategic parts of recruitment. The course covers everything you need to know, from UK recruitment laws to building strong relationships with clients. You’ll learn useful methods for attracting the right candidates, running successful interviews, and managing clients in a way that brings results. Whether you are just starting in recruitment or already have some experience, this Recruitment Consultant Training gives you a clear structure to follow and helps you improve your skills. With many UK industries facing skill shortages, there’s a growing need for trained Recruitment Consultants who understand how to meet the needs of both job seekers and employers. This Recruitment Consultant Training will help you become more than just a recruiter—it will help you become a trusted advisor who brings real value. By the end of the course, you’ll be ready to succeed and make a positive impact in the world of recruitment.   By completing this Recruitment Consultant Training, you will be able to: Understand the main rules and standards of the recruitment industry. Use UK recruitment laws correctly in real work situations. Find the best ways to attract, manage, and support candidates. Build strong methods for getting and keeping clients. Study key numbers that show how well your recruitment work is doing. Design clear and fair interview steps to help choose the right candidates. Who is this course for? This Recruitment Consultant Training course is perfect for: Anyone who wants to start a career in recruitment and needs a full understanding of how it works, including the laws and best practices. People already working in recruitment who want to improve in areas like getting clients, managing candidates, or checking performance. Business owners or HR staff who want to learn better ways to hire the right people. Staff at job agencies who want deeper knowledge of recruitment in the UK. Anyone planning to start their own recruitment agency and needs to learn the full process and how to grow the business. Process of Evaluation After studying the Recruitment Consultant Training Course, your skills and knowledge will be tested with an MCQ exam or assignment. 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 Recruitment Consultant Training Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements There is no prerequisite to enrol in this Recruitment Consultant Training course. Career Path This Recruitment Consultant Training Course will lead you to many different career opportunities. Here are a few prospects: Recruitment Consultant - £25K to £35K/year Senior Recruitment Consultant - £35K to £50K/year Recruitment Team Leader - £40K to £55K/year Recruitment Manager - £50K to £65K/year Recruitment Agency Director - £65K to £100K+/year Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Recruitment Consultant Training - Updated Version Module 1 - Introduction to Recruitment: Importance and Implications 00:17:00 Module 2 - An Overview of the Recruitment Industry 00:26:00 Module 3 - The UK Recruitment Legislation 00:19:00 Module 4 - Sales and Selling in the Recruitment Industry 00:11:00 Module 5 - The Recruitment Process 00:47:00 Module 6 - Key Performance Indicators for the Recruitment Industry 00:25:00 Module 7 - Candidate Attraction for Recruitment 00:35:00 Module 8 - Candidate Management 00:22:00 Module 9 - Candidate Interview Processes 00:24:00 Module 10 - Client Acquisition 00:36:00 Module 11 - Client Strategy in the Recruitment Sector 00:25:00 Module 12: Client Management 00:27:00 Module 13 - Steps to Starting and Running a Successful Recruiting Service 00:23:00 Recruitment Consultant Training - Old Version Recruitment Basics Introduction to Recruitment 00:15:00 Recruitment 01:00:00 Shortlisting 00:15:00 Selection 01:00:00 Definitions of Training and Development 00:15:00 Considerations in the Design of Training Programmes 00:15:00 Implementing Training 00:15:00 Learning Methods 00:30:00 Recruitment Module One - Getting Started 00:15:00 Module Two - Introduction to Recruitment 00:30:00 Module Three - The Selection Process 00:30:00 Module Four - Goal Setting 00:30:00 Module Five - The Interview 00:30:00 Module Six - Types of Interview Questions 00:30:00 Module Seven - Avoiding Bias in Your Selection 00:30:00 Module Eight - The Background Check 00:30:00 Module Nine - Making Your Offer 00:30:00 Module Ten - Orientation and Retention 00:30:00 Module Eleven - Measuring the Results 00:30:00 Module Twelve - Wrapping Up 00:15:00 Managing Recruitment Module One - Getting Started 00:30:00 Module Two - Defining and Knowing the Position 01:00:00 Module Three - Hiring Strategy 01:00:00 Module Four - Lure in Great Candidates 01:30:00 Module Five - Filtering Applicants to Interview 01:00:00 Module Six - The Interview (I) 01:00:00 Module Seven - The Interview (II) 01:00:00 Module Eight - Selection Process (I) 01:00:00 Module Nine - Selection Process (II) 01:00:00 Module Ten - Making an Offer 01:00:00 Module Eleven - Onboarding 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recruitment - Interview Process History of the Interviewing Process 00:30:00 The Recruitment and Selection Process 00:15:00 Factors in the Hiring Process 00:15:00 Cost Analysis 00:15:00 Job Analysis and Position Profiles 00:30:00 Determining the Skills You Need 00:15:00 Finding Candidates 00:30:00 Advertising Guidelines 00:00:00 Screening Resumes 00:30:00 Performance Assessments 00:30:00 Problems Recruiters Face 00:15:00 Interviewing Barriers 00:15:00 Non-Verbal Communication 00:15:00 Types of Questions 00:30:00 Case Study 00:15:00 Traditional vs. Behavioral Interviews 00:30:00 Other Types of Questions 00:15:00 The Critical Incident Technique 00:15:00 Listening for Answers 00:30:00 Difficult Applicants 01:00:00 Interview Preparation and Format 00:00:00 Other Interview Techniques 00:30:00 Scoring Responses 00:15:00 Checking References 00:30:00 Human Rights 00:15:00 Assignment Assignment - Recruitment Consultant Training 00:00:00

Has something just happened? Did you just break up? Did you have an argument? Found out you were being cheating on or feeling extremely low whatever the problem your M.D.D date coach will come to your home with a gourmet meal, magazines and fresh fruit and will stay with you for 90 mins to discuss the issue and give you a relationship coaching session.(Available between 9- 7 pm appointment based.) £300 https://relationshipsmdd.com/product/m-d-d-v-i-p-relationship-crisis-delivery/

Confidence training Eradication of materialism thoughts Learning more about your needs Dating advice Dating coaching Discuss goals and aspirations Dating assistance 5 x 30 mins sessions Per day https://relationshipsmdd.com/product/m-d-d-i-want-a-girlfriend-but-i-dont-feel-financially-stable-package/

open discussion Listen to both parties issues Relationship coaching Relationship analysis Discuss expectations Implement compromise options Honesty session Mindset and thoughts for future Mediation Resolve differences 3 sessions 50 mins https://relationshipsmdd.com/product/my-career-is-taking-over-but-i-dont-want-to-lose-my-girlfriend-package/

Support via WhatsApp and phone Women’s needs training Emotional intelligence training Guidance Coaching Break up support Assessment Positivity training Ascertain needs Examine past relationship Self-improvement and self-building training 4 x 40 mins https://relationshipsmdd.com/product/i-am-struggling-to-move-on-from-my-ex-girlfriend-package/

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