3309 Bar courses in Cardiff delivered Online

This Fitness Coaching Training aims to give you comprehensive knowledge and understanding of key topics such as coaching and training, physical fitness and more. You will learn the basics in everything from yoga to healthy living for a career in the fitness industry. Learning from here you will be able to build training and nutrition plans based on your individual goals and needs and continually tweak and adapt them so that they are always optimal for you. The course covers topics such as yoga exercises, personal health and fitness, coaching styles and techniques, outdoor adventure and land management. On completion the course, you can easily identify your problems and take useful action in an instant. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials   Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Exercise and Warm Ups Pushups 00:01:00 Jump Squat 00:01:00 Pull-Ups 00:02:00 Side Planks 00:01:00 Hanging Knee Raise 00:01:00 Bicep Workout Concentration Curls 00:01:00 Preacher Curl 00:01:00 Incline Biceps Curls 00:01:00 Hammer Curls 00:02:00 Back Workout Back Hyperextensions 00:01:00 Deadlifts 00:02:00 Bend Over Barbell Bow 00:02:00 Good Mornings 00:01:00 Hip Thrusts 00:01:00 Reverse Grip Pulldowns 00:02:00 Seated Row 00:02:00 V-bar Pulldown 00:01:00 Chest Workout Dumbbell Incline Flys 00:01:00 Dumbbell Incline Press 00:02:00 Bench Press 00:02:00 Incline Barbell Bench Press 00:01:00 Incline Barbell Bench Press 00:01:00 Close Grip Barbell Bench Press 00:01:00 Dumbbell Pullover 00:02:00 Leg Workout Bench Step-UPS 00:02:00 Lying Leg Curl 00:01:00 Dumbbell Split Squats 00:01:00 Standing Calf Raises 00:01:00 Seated Calf Raise 00:01:00 Barbell Split Lunges 00:01:00 Leg Press 00:01:00 Walking Lunges 00:01:00 Side Lunges 00:02:00 Leg Extension 00:02:00 Forward Lunges 00:01:00 Front Squat 00:03:00 Sumo Squats 00:01:00 Tricep Workout One Arm Triceps Extension 00:01:00 Skull Crushers 00:01:00 Standing Overhead Triceps Press 00:01:00 V-bar Tricep Pressdown 00:01:00 Tricep Dips 00:01:00 Bench Dips 00:01:00 Assignment Assignment - Fitness Coaching Training 02:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on Cost Control Process and Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Cost Control Process and Management comes with accredited certification, 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 Cost Control Process and Management. It is available to all students, of all academic backgrounds. Requirements Our Cost Control Process and Management 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 18 lectures • 02:08:00 total length •Introduction and Fundamental Terms: 00:09:00 •Fundamental terms - Perishable / Non Perishable cost, Inventory Terms: 00:05:00 •Qualities of Good Cost Controller: 00:07:00 •Cost Control Process and Controls related to Purchasing: 00:10:00 •How to estimate Kitchen food Order Process Simplified: 00:06:00 •How to Setup Store PAR for to identify re-order levels: 00:06:00 •Basic Receiving Process Controls: 00:07:00 •Basic Store Process controls: 00:08:00 •Production Controls: 00:05:00 •Recipe Card & Controls: 00:08:00 •Buffet Costing and Menu Pricing: 00:08:00 •Butcher test: 00:09:00 •Bar Spot Checks and Recipe Testing: 00:06:00 •Production Control Via Menu Engineering: 00:08:00 •Slow and Non Moving Inventory: 00:03:00 •Daily & Monthly Food Cost Reports: 00:11:00 •Menu Engineering Reports: 00:09:00 •Cost Control Checklist: 00:03:00

Overview This comprehensive course on Google Data Studio: Data Analytics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Google Data Studio: Data Analytics 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 Google Data Studio: Data Analytics. It is available to all students, of all academic backgrounds. Requirements Our Google Data Studio: Data Analytics 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 4 sections • 17 lectures • 02:32:00 total length •Course Overview: 00:01:00 •Format Data in Google Sheets: 00:08:00 •Sheet Functions 1: Query & Import Range: 00:07:00 •Sheets Function 2: Vlookup & Defined Range: 00:10:00 •Sheets Function 3: Cross Table Calculations: 00:09:00 •Connect Data to Google Data Studio: 00:04:00 •GDS Calculated Fields: 00:08:00 •GDS Theme Customization: 00:07:00 •GDS Page Layout Design: 00:17:00 •GDS Charts: Scorecards: 00:12:00 •GDS Charts: Time Series Graphs: 00:09:00 •GDS Blending and Joining Data Tables: 00:07:00 •GDS Charts: Bar, Donut, and Treemap: 00:17:00 •GDS Charts: Interactive Filters: 00:08:00 •GDS Project Page Completion: 00:17:00 •GDS Client Page Completion: 00:11:00 •Additional Resources - Google Data Studio: Data Analytics: 00:00:00

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Description: This Microsoft Project 2007 Advanced - Complete Video Course designed to provide you with the necessary skills to plan and schedule a building or construction project. It focuses on setting u a project in MS Project, updating and revising project schedules, assigning resources and dealing with constraints. You will learn to create time-scaled diagrams (bar charts), resolve activity clashes/problems and update and monitor activity completion, consolidating multiple projects, tools for resource types and defining costs, discover how to use and customize reports, how to assign, level, and divert resources to overcome problems, delegation and tracking tasks. You can join this course if you have an understanding of project management concepts, and responsible for creating and modifying project plans, and need a tool to manage these project plans. By taking this course you will have a complete understanding of the higher functions of Project. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Project 2007 Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Project 2007 Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Exchanging Information and Updating a Plan Exchanging Project Plan Data with Other Applications FREE 00:22:00 Updating a Project Plan 00:46:00 Costs, Visualization, and Reusing Plan Information Managing Project Costs 00:23:00 Reporting Project Data Visually 00:30:00 Reusing Project Plan Information 00:37:00 Mock Exam Mock Exam- Microsoft Project 2007 Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2007 Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 5 QLS Course With QLS Endorsed Certificate | 11 CPD Courses & PDF Certificates | 160 CPD Points | CPD Accredited

Embark on a transformative learning journey with our 'Read Construction & Structural Drawing Like Expert' course, meticulously crafted for those with a zeal to decode the intricate language of architectural blueprints. This course unlocks the gateway to understanding the complex layers of G+3 residential building designs. From the foundational footing layout to the sophisticated slab reinforcements, you will be guided through the arcane world of construction drawings, emerging with the knowledge to navigate this technical terrain with ease and precision. The curriculum is an architect's treasure map, leading you from the initial sketches of a residential project to the high-level detailing required for successful execution. As you traverse the course, you will witness the fusion of theory and practice with site videos, unraveling the real-world applications of structural drawings. You'll not only learn the principles of Vastu in planning but also grasp the nuances of load calculations and material specifications, all geared towards equipping you with a keen eye for structural details and the skill to interpret them expertly. Learning Outcomes Interpret architectural and structural drawings of multi-story residential buildings with clarity. Apply the principles of Vastu Shastra in building design and planning. Analyze load calculations and material requirements for construction projects. Develop the ability to detail beams, columns, and slabs from structural analysis results. Synthesize practical construction knowledge with technical drawing acumen. Why choose this Read Construction & Structural Drawing Like Expert course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Read Construction & Structural Drawing Like Expert Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Read Construction & Structural Drawing Like Expert course for? Aspiring construction professionals eager to master architectural drawing interpretation. Civil engineers seeking to refine their understanding of multi-story building structures. Architects looking to align design concepts with structural integrity. Technical draftspersons aiming to enhance their detailing capabilities. Project managers and site supervisors wishing to bridge the gap between drawings and physical construction. Career path Construction Project Manager: £35,000 - £70,000 Architectural Technologist: £25,000 - £50,000 Structural Engineer: £28,000 - £55,000 Building Surveyor: £22,000 - £50,000 CAD Technician: £20,000 - £40,000 Site Engineer: £25,000 - £50,000 Prerequisites This Read Construction & Structural Drawing Like Expert does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Read Construction & Structural Drawing Like Expert 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Architectural & Structural Drawings of G+3 Residential Building Reading The Architectural Plan of G+3 Residential Building & Planning It 00:36:00 Understanding To Read Footing Layout drawing Of G+3 Building 00:31:00 Learn to Read Footing Schedule and Reinforcement Drawing of G+3 Building 00:24:00 How Combined Footing Reinforcement Is given practically at Site & What is Chair 00:26:00 Learn To Read Column Layout & Column Schedule Drawings of G+3 Building 00:14:00 Learn to Read Column Reinforcement & Column Lateral Ties & SP-34 Detailing 00:49:00 Video Explaining depth of footing, PCC, Development Length & Column Placing 00:16:00 What is Vastu & How this G+3 Building Is planned According to vastu Theory 00:38:00 Plinth Beam Layout, How to Frame Plinth Beam layout & Understand Reinforcement 00:20:00 Practical Video of Plinth Beam Reinforcement, Shuttering & Concreting 00:07:00 Learn First Floor Shuttering Layout & Slab Centering Layout with Site Videos 00:19:00 Learn to Read 1st Floor Beam Reinforcements of a G+3 Residential Building 00:24:00 Practical Video Of Beam Reinforcement and Extra Bar Provided in Beam R/F 00:06:00 Difference Between 1-way Slab & 2-way Slab 00:35:00 Practical Video of How Crank Bars are Put Up In The Slab 00:22:00 Theory of 2 way Slab & Its Importance & How it is Provided Practically at Site 00:32:00 Learn to Read slab 1st Floor Slab Reinforcement Details & Slab practical Video 00:26:00 Second Floor Shuttering Layout & Minor Changes With Respect to 1st Floor Layout 00:18:00 Second Floor Beam Details & Theory Behind Extra Bar at Support ( MUST WATCH ) 00:29:00 Second Floor Slab Details & Theory Behind Simply Supported & fixed Support Slab 00:25:00 Third-floor Slab shuttering Layout, Beam Details & Slab Reinforcement Details 00:11:00 Terrace Floor Plan & Head Room Architectural & Structural Details. 00:13:00 Section 02: Etabs Model of G+3 Residential Building Learn How the G+3 Residential Building is Modeled On E tabs Software 00:15:00 How to Define Beam, Column & Slab Sizes in the Etabs Model 00:23:00 How Dead Load & Live loads are calculated practically and Applied On The Slab 00:28:00 How to Apply Wall load on Beams & How to calculate Wall Load Manually 00:22:00 How to Create Load Pattern & Load Combinations in Etabs 00:21:00 How to check Footing Reaction & How to Size the footing Using excel Sheets 00:39:00 Check Bending Moment of Beam & understand it with Structural drawings 00:16:00 Detailing of Beam from Etabs Results & Excel Sheet Values 00:19:00 Detailing Of Stirrups, Spacing between stirrups & Logic Behind Providing Them 00:17:00 Column Detailing Manually & with Excel Sheet from Etabs Results 00:13:00

Overview This comprehensive course on Develop Big Data Pipelines with R & Sparklyr & Tableau will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Develop Big Data Pipelines with R & Sparklyr & Tableau 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 Develop Big Data Pipelines with R & Sparklyr & Tableau. It is available to all students, of all academic backgrounds. Requirements Our Develop Big Data Pipelines with R & Sparklyr & Tableau 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 6 sections • 20 lectures • 02:59:00 total length •Introduction: 00:12:00 •R Installation: 00:05:00 •Installing Apache Spark: 00:12:00 •Installing Java (Optional): 00:05:00 •Testing Apache Spark Installation: 00:03:00 •Installing Sparklyr: 00:07:00 •Data Extraction: 00:06:00 •Data Transformation: 00:18:00 •Data Exporting: 00:07:00 •Data Pre-processing: 00:18:00 •Building the Predictive Model: 00:10:00 •Creating the Prediction Dataset: 00:10:00 •Installing Tableau: 00:02:00 •Loading the Data Sources: 00:05:00 •Creating a Geo Map: 00:12:00 •Creating a Bar Chart: 00:08:00 •Creating a Donut Chart: 00:15:00 •Creating the Magnitude Chart: 00:09:00 •Creating the Dashboard: 00:15:00 •Source Code: 00:00:00

Overview This comprehensive course on Spatial Data Visualization and Machine Learning in Python Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Spatial Data Visualization and Machine Learning in Python Level 4 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Spatial Data Visualization and Machine Learning in Python Level 4. It is available to all students, of all academic backgrounds. Requirements Our Spatial Data Visualization and Machine Learning in Python Level 4 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 21 lectures • 04:40:00 total length •Introduction: 00:14:00 •Python Installation: 00:03:00 •Installing Bokeh: 00:04:00 •Data Preparation: 00:24:00 •Creating a Bar Chart: 00:18:00 •Creating a Line Chart: 00:12:00 •Creating a Doughnut Chart: 00:22:00 •Creating a Magnitude Plot: 00:31:00 •Creating a Geo Map Plot: 00:20:00 •Creating a Grid Plot: 00:12:00 •Data Pre-processing: 00:21:00 •Building a Predictive Model: 00:21:00 •Building a Prediction Dataset: 00:07:00 •Adding predicted data to our plots - Part 1: 00:13:00 •Adding predicted data to our plots - Part 2: 00:14:00 •Adding predicted data to our plots - Part 3: 00:15:00 •Adding the Grid Plot: 00:08:00 •Installing Visual Studio Code: 00:01:00 •Creating the Project and Virtual Environment: 00:08:00 •Building and Running the Server: 00:12:00 •Resources: 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00