17420 Courses in Cardiff delivered On Demand

Level 7 Diploma in Management and Leadership Online This Level 7 Diploma in Leadership & Management Course will help you advance your career by providing you with the most up-to-date leadership and management information. The Level 7 Diploma in Leadership & Management Course requires no prior knowledge or experience, as candidates are introduced to the characteristics and qualities of an effective leader. You will learn how to build and optimize a high-performing team, cultivate an engaging organizational culture, and provide constructive feedback to coworkers by enrolling in this Level 7 Diploma in Management and Leadership Course. By the end of the Level 7 Diploma in Management and Leadership Course, you will have a solid understanding of what makes a great leader and how to put the strategies you have learned into practice to advance your career. Enrol in this Level 7 Diploma in Leadership & Management UK course to learn how to improve your leadership and management skills. Free Courses of this Level 7 Diploma in Management and Leadership Course Course 01: Level 7 Diploma in Leadership and Management Course Course 02: Level 3 Business Administration Course 03: Level 4 Time Management Course Other Benefits of this Level 7 Diploma in Management and Leadership Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Level 7 Diploma in Management and Leadership Course] Level 7 Diploma in Management and Leadership Industry Experts Designed this Level 7 Diploma in Leadership & Management course into 10 detailed modules. Course Curriculum of the Level 7 Diploma in Management and Leadership Module 01: Understanding Management and Leadership Module 02: Leadership over Yourself Module 03: Creativity and Innovation Module 04: Leadership and Teambuilding Module 05: Motivation and People Management Module 06: Communication and Leadership Module 07: Presentation, One-to-one Interview and Meeting Management Module 08: Talent Management Module 09: Strategic Leadership Module 10: Stress Management Assessment Method of Level 7 Diploma in Management and Leadership After completing each module of the Level 7 Diploma in Leadership & Management Online UK 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 of Level 7 Diploma in Management and Leadership After completing the MCQ/Assignment assessment for this Level 7 Diploma in Leadership & Management course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Level 7 Diploma in Management and Leadership This Level 7 Diploma in Management and Leadership Course is for anyone serious about their professional development. This Course is designed primarily for group leaders, managers at all levels, and business professionals. Students and recent graduates who want to improve their resumes and gain experience are also welcome to enrol in this Level 7 Diploma in Leadership & Management UK Course Requirements Level 7 Diploma in Management and Leadership Students who intend to enrol in this Level 7 Diploma in Management and Leadership course must meet the following requirements: Level 7 Diploma in Management and Leadership: Good command of the English language Level 7 Diploma in Management and Leadership: Must be vivacious and self-driven Level 7 Diploma in Management and Leadership: Basic computer knowledge Level 7 Diploma in Management and Leadership: A minimum of 16 years of age is required Career path Level 7 Diploma in Management and Leadership Certificates Certificate of completion Digital certificate - Included

Are you looking to enhance your Train Driver Beginners skills? If yes, then you have come to the right place. Our comprehensive course on Train Driver Beginners will assist you in producing the best possible outcome by mastering the Train Driver Beginners skills. The Train Driver Beginners course is for those who want to be successful. In the Train Driver Beginners course, you will learn the essential knowledge needed to become well versed in Train Driver Beginners. Our Train Driver Beginners course starts with the basics of Train Driver Beginners and gradually progresses towards advanced topics. Therefore, each lesson of this Train Driver Beginners course is intuitive and easy to understand. Why would you choose the Train Driver Beginners course from Compliance Central: Lifetime access to Train Driver Beginners course materials Full tutor support is available from Monday to Friday with the Train Driver Beginners course Learn Train Driver Beginners skills at your own pace from the comfort of your home Gain a complete understanding of Train Driver Beginners course Accessible, informative Train Driver Beginners learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Train Driver Beginners Study Train Driver Beginners in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Train Driver Beginners Course Train Driver Beginners Curriculum Breakdown of the Train Driver Beginners Course Module 01: Introduction to Trainee Train Driving Module 02: Train Driver Licences and Certificates: Key Facts Module 03: Train Driver Required Skills and Attitudes Module 04: Train Driver Application Form Success Module 05: Train Driver Psychometric Test Module 06: Find Success in the Train Driver Interview Module 07: References, Medical Assessment and Training CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Train Driver Beginners course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Train Driver Beginners. It is also great for professionals who are already working in Train Driver Beginners and want to get promoted at work. Requirements To enrol in this Train Driver Beginners course, all you need is a basic understanding of the English Language and an internet connection. Career path The Train Driver Beginners course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Train Driver Beginners. Train Dispatcher/Controller: £25,000 to £45,000 per year Train Operations Manager: £35,000 to £70,000 per year Rail Safety Inspector: £28,000 to £45,000 per year Train Maintenance Technician: £25,000 to £40,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

The Diploma in Event Management is a comprehensive online course designed to equip you with the essential skills and knowledge to excel in the fast-paced event industry. Whether you dream of organizing corporate conferences, weddings, music festivals, or sporting events, this course covers event planning, budgeting, marketing, logistics, and risk management. You’ll learn from industry experts through real-world case studies, interactive modules, and hands-on projects. This course blends theoretical knowledge with practical insights, ensuring you understand the latest trends, digital tools (like event management software), and sustainability practices in events. By the end, you’ll be able to plan, execute, and evaluate successful events while managing clients, vendors, and teams efficiently. Perfect for aspiring event planners, entrepreneurs, or professionals looking to switch careers, this diploma provides a globally recognized certification to boost your credibility in the industry. With flexible online learning, you can study at your own pace and gain access to exclusive resources, networking opportunities, and career support. Start your journey towards becoming a skilled event manager today! Learning Outcomes Master end-to-end event planning, from concept to execution. Develop budgeting and financial management skills for profitable events. Learn effective marketing strategies, including social media & branding. Understand venue selection, logistics, and vendor management. Gain expertise in risk assessment and crisis management. Utilise event technology & software (e.g., Eventbrite, Cvent). Enhance client communication and negotiation skills. Explore sustainable and eco-friendly event practices. Build a professional portfolio with real-world projects. Who is This Course For? This course is ideal for aspiring event planners, hospitality professionals, marketing executives, entrepreneurs, and career changers seeking entry into the event industry. It’s also beneficial for small business owners who want to organize their own events or corporate professionals handling company meetings and conferences. No prior experience is required—just a passion for creating unforgettable experiences! Career Path Event Coordinator – £22,000 - £30,000 Wedding Planner – £25,000 - £40,000 Corporate Event Manager – £30,000 - £50,000 Festival Organizer – £28,000 - £45,000 Conference Producer – £35,000 - £55,000 Exhibition Manager – £32,000 - £48,000 Why Enroll? Industry-recognised certification Flexible online learning Expert-led training & case studies Career support & job placement guidance Start your journey in event management today and turn your passion into a thriving career! 🎉

Unlock your potential as a trainer with our Train the Trainer Course: Facilitation Skills Workshop. Master the basics of training, understand adult learners' needs, and learn to assess, plan, and deliver effective training sessions. Explore various training methods, utilize visual aids, and discover your unique training style. Develop coaching and mentoring skills, enhance your training abilities, and learn to navigate group dynamics. Elevate your facilitation skills and become a confident, impactful trainer. Join us on a transformative learning journey to shape the future of education and professional development.

Proofreading and Editing Diploma Welcome to the Proofreading and Editing Diploma-an all-encompassing course aimed at honing your skills in the domains of proofreading and text editing. Whether you're an aspiring editor, a freelance writer, or someone who wants to elevate the quality of your written work, this course offers a rigorous curriculum designed to transform your editing prowess. Learning Outcomes: Master a wide array of proofreading strategies. Develop skills in content, structure, and presentation editing. Acquire essential IT skills for modern proofreading. Adopt best practices to ensure the highest quality in all your written works in proofreading. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Proofreading and Editing Diploma: Proofreading Strategies: Learn an array of effective strategies to identify and correct errors, ensuring high-quality written content. Content Edit in Proofreading: Focus on the essence of the text, improving clarity, coherence, and overall message impact. Structure Edit for Proofreading: Discover how to optimize text flow, organization, and formatting to enhance readability. Presentation Edit: Proofreading Focus: Examine the visual elements of the text, including layout, typography, and imagery. IT Skills in Proofreading: Familiarize yourself with indispensable software and digital tools that facilitate a smoother proofreading process. Proofreading Best Practices: Explore best practices in proofreading, ensuring that you adhere to the highest industry standards.

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Sales Analysis in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Welcome to the Course 00:03:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00

Overview Our comprehensive course is designed to provide you with the necessary skills and knowledge to excel in your field. Developed by professionals with years of experience, this course is perfect for anyone looking to kick start their career or advance their skills. It features an audio-visual presentation and easy-to-learn modules, allowing for a self-paced learning experience. Our expert online support team is available during weekdays to assist you throughout the course. Learning Outcomes Upon completion of the course, you will be able to: Understand the fundamentals and its applications. Develop the necessary skills to succeed in the field . Apply your newly acquired knowledge to real-world scenarios. Create effective and efficient solutions for relevant topics. Enhance your employability and career prospects. It is designed to provide you with the knowledge needed to stand out in the competitive job market. With lifetime access to course materials and the ability to learn at your own pace, this course is the perfect opportunity to improve your skills and advance your career. You can learn at your own pace, from the comfort of your home, as all course materials are accessible online at any time. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Why should you study this course? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path The course is designed to equip you with the skills and knowledge you need to succeed in the field. After completing the course, you will be able to pursue a variety of career opportunities in different industries. Course Content END OF LIFE CARE TRAINING Module 1: Understanding End-of-Life Care Module 2: Legal and Ethical Aspects of End-of-Life Care Module 3: Identification of the Stage of Illness Module 4: Breaking Bad News & Communication in End-of-Life Care Module 5: Pain and Symptom Management Module 6: Psychosocial, Emotional, and Spiritual Care Module 7: Care in the Last Days of Life Module 8: Child and Young Adult End-of-Life Care Module 9: Hospice and Palliative Care Module 10 Nutrition and Hydration at the End of Life

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Have you ever flicked through a magazine and been mesmerised by flawless makeup looks or glowing skin? The UK beauty industry is booming, expected to reach a staggering £31 billion by 2025! Wish you could actually understand the science behind that perfect glow or flawless foundation? If so, this comprehensive Beauty Therapy and Make-Up course bundle is the perfect place to begin your journey. Our course bundle offers a well-rounded education, from mastering advanced makeup techniques to understanding the science behind beautiful skin. Learn how to create flawless complexions, flawless makeup applications, and personalised skincare regimes for every client. Gain insights into fashion trends and industry secrets, all while developing the essential skills to excel in this dynamic field. This Advanced Diploma in Makeup Artist Training at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Our Bundle contains 5 of our premium courses for one discounted price: Course 01: Beauty Therapy at QLS Level 7 Course 02: Indian Bridal Makeup Course 03: Diploma in Skin Care Treatments Course 04: Diploma in Dermatology Course 05: Gel Manicure and Nail Technician Take control of your future in the beauty industry. Enrol today and unlock a world of creative possibilities! Learning Outcomes of Beauty Therapy and Make-Up Apply advanced skincare treatments & analyse client needs. Master advanced makeup artistry techniques for various occasions. Understand the science of skin health and diagnose common concerns. Perform advanced gel manicures and nail enhancement techniques. Adhere to industry health, safety, and hygiene regulations. Develop exceptional communication and client consultation skills. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Beauty Therapy and Make-Up Get a free student ID card with Beauty Therapy and Make-Up Training program (£10 postal charge will be applicable for international delivery) The Beauty Therapy and Make-Up is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Beauty Therapy and Make-Up course materials The Beauty Therapy and Make-Up comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Course 01: Beauty Therapy at QLS Level 7 Lesson 1 - Brushes Lesson 2 - Your Makeup Kit Lesson 3 - Etiquette On Set Lesson 4 - How to Use Color Correctors Lesson 5 - Film & Television Artistry Lesson 6 - Tattoo Covering Lesson 7 - Tips On Natural Lesson 8 - Tips On Glamour Lesson 9 - How-To Tips for Teenage Lesson 10 - Tips for Sophisticated Ladies Lesson 11 - Airbrush Lesson 12 - Bridal Lesson 13 - Eyes and Lips Lesson 14 - Be Camera Ready Lesson 15 - Skin Nutrition Lesson 16 - Detox Your Bag & Travel Like a Boss Lesson 17 - Henna Hair Color Lesson 18 - Fast Start Business Training Lesson 19 - What Does Bethany do to Stay Fresh Skin Care Lesson 1 - Tanning Lesson 2 - Facials Lesson 3 - Hair Removal Options Lesson 4 - Dermaplaning Lesson 5 - Esthetician Tools Lesson 5 - Know your Toxic ingredients Lesson 6 - LED Light Therapy Lesson 7 - Microneedling Lesson 8 - Natural and Chemical Peels Lesson 9 - Skincare Using Spices Lesson 10 - Skin Disorder and Diseases Lesson 11 - Sugaring Lesson 12 - Tinting Lesson 13 - How To Be and Get Camera Ready Lesson 14 - Why No Microdermabrasion Lesson 15 - Food Knowledge Lesson 16 - Skincare Using Spices Things to Know As a Professional Lesson 1- Aromatherapy and Essential Oils Lesson 2- Detox Your Deodorant Lesson 3 - Dry Brushing Lesson 4 - Face Masks Lesson 5 - Find Your Perfect Color Lesson 6 - Go Earthing Lesson 7- Good Morning Detox Lesson 8- Hot Flashes Lesson 9 - Luxury Spa Treatments at Home Lesson 10 - How to Conceal and Correct Under Your Eyes Lesson 11 - Your Health Routine Lesson 12- Oil Pulling- Natural Teeth Whitening Lesson 13 - Tanning Beds or Spray Tanning Lesson 14 - What's in Your Lipstick Lesson 15 - What's All the Fuss About LED Light Ther Course 02: Indian Bridal Makeup Makeup Look Part 1 Module 1: Introduction to Indian Bridal Makeup Module 2: Preparing & Priming A Combinational Skintype Module 3: Applying Golden, Copper, Brown Eyeshadow Shades Module 4: Applying Eyeliner on Eyeliner on Eyes with Slightly Hoodedness Module 5: How to Curl Flat Lashes and Apply False Lashes Module 6: Applying a Smoked Out Look on the Lower Lashline & Completing the Eye makeup Look Module 7: Colour Correcting Dark Pigmentations Module 8: Applying Foundation, Highlight & Contour a Medium to Tan Complexions Makeup Look Part 2 Module 15: Skincare & Primer Module 16: Create a Smokey Eyeliner Module 17: Applying the Half Cut Crease Technique Module 18: Face Makeup Application Module 19: Cherry Red to Burgundy Ombre Lips & Results Makeup Look Part 3 Module 20: Skin Prepping & Priming with Different Products Module 21: Master the Cut-Crease Eyemakeup Technique Module 22: Apply Eyeliner & Complete Cut-Crease Eye-Makeup Module 23: Complete the Face Makeup Module 24: Pink to Purple Ombre Lips and Results Course 03: Diploma in Skin Care Treatments Module 01: Skin Anatomy Module 02: Skin Nutrients Module 03: Skin Care For Different Skin Types Module 04: Skin Care For Different Ethnicities Module 05: Reducing Ageing Effects Module 06: Hair Removal Examined Module 07: Diagnosis Of Skin Disease Module 08: Eczema Module 09: Keratinising And Papulosquamous Disorders Module 10: Skin Infections Module 11: Remedies For Acne Prone Skin Module 12: Seasonal Skin Care Module 13: Effect Of The Sun And Its' Remedies =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 230 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring makeup artists and skincare professionals Beauty enthusiasts looking to improve their makeup and skincare techniques Individuals seeking to add new skills to their existing repertoire Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Makeup Artist: £18,000 - £35,000 Esthetician: £14,000 - £30,000 Skincare Specialist: £15,000 - £30,000 Beauty Advisor: £12,000 - £22,000 Cosmetics Counter Manager: £16,000 - £25,000 Salon Owner: £18,000 - £50,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Advanced Diploma in Makeup Artist Training at QLS Level 7 Hard copy certificate - £139 Please note that International students have to pay an additional £10 as a shipment fee.

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00