1319 Courses in Cardiff delivered On Demand

Getting Started The CMI Level 3 Certificate in Coaching and Mentoring is aimed at supervisors and first-line managers. This course is designed to help managers improve their communication and mentoring skills, performance in coaching and mentoring roles, and efficiency. Achieving the renowned CMI Level 3 qualification in coaching and mentoring will enable you to develop coaching and mentoring skills and techniques for individuals and teams, alongside working to achieve organisational objectives. This Level 3 Coaching and Mentoring certificate course is shorter than the Diploma. It introduces you to organisational culture, values and behaviour while developing your skills in managing team dynamics, equality, and diversity. Key Benefits For Learners Introduce you to the principles, skills and impact of coaching and mentoring Establishing key coaching and mentoring relationships and skills Support the development of individuals and teams Developing your skills in managing team dynamics, equality and diversity For Organisations Ensuring teams can meet organisational objectives Broader knowledge of operational processes and evaluation techniques Introduces organisational culture, values and behaviour Key Highlights Are you a supervisor or first-line manager and want to support the development of coaching and mentoring skills and techniques of individuals and teams? The CMI Level 3 Coaching and Mentoring offered by School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The CMI Level 3 Coaching and Mentoring can open many career pathways including, but not limited to: Training Manager, with an estimated average salary of £31,613 per annum Training & Development Manager, with an estimated average salary of £36,885 per annum Independent Coach or Mentor with an estimated average salary of £28,000 per annum Corporate Coach or Mentor with an estimated average salary of £38,950 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 10 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 2000 to 2500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements The Level 3 Certificate in Coaching and Mentoring is designed for practising and aspiring supervisors and first-line managers. To be eligible for this course, you must: Be 18 years of age and over Possess the ability to complete the Level 3 Qualification Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression CMI would recommend the below qualifications as a possible progression route, once complete the Coaching and Mentoring qualifications: CMI Level 3 Qualifications in First Line Management CMI Level 5 in Management Coaching and Mentoring Why gain a CMI Qualification? Achieving this CMI Level 3 Certificate in Coaching and Mentoring qualification will introduce you to the principles, skills and impact of coaching and mentoring and help you establish key coaching and mentoring relationships and skills. You will develop your skills in managing team dynamics, equality, and diversity, and you will have the opportunity to attain a good understanding of the essentials of coaching and mentoring upon completing this course. Once you complete this certificate course, you can progress to the diploma course in CMI Level 3 Coaching and Mentoring or Level 5 Professional Coaching or Mentoring. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 3 Coaching and Mentoring course, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners need to complete any combination of units to a minimum of 13 credits. The minimum Total Qualification Time is 130 hours, including 50 Guided Learning Hours. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Principles, skills and impact of coaching and mentoring Reference No : Unit 3011V1 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the principles of coaching and mentoring. 2. Understand the skills required of a coach. 3. Understand the skills required of a mentor. UNIT2- Coaching and mentoring for individual and team needs Reference No : Unit 3012V1 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the impact on the individual and team needs of the coaching process. 2. Understand the impact on the individual and team needs of the mentoring process. 3. Understand the individual and team knowledge, skills or behaviours. UNIT3- Managing the coaching and mentoring relationships Reference No : Unit 3013V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Understand the coaching and mentoring relationships. 2. Understand the goals of the coaching and mentoring relationship. 3. Understand possible barriers to the coaching process. UNIT4- Coaching and mentoring processes Reference No : Unit 3014V1 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Understand the implementation of the coaching process. 2. Understand the implementation of the mentoring process. 3. Understand the reviewing of progress and provision of feedback. UNIT5- Completing the coaching and mentoring process Reference No : Unit 3015V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Understand the skills of concluding the coaching process. 2. Understand the skills of concluding the mentoring process. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Description Conflict Management and Crucial Conversations course is designed for any individual who wants to bring productivity in both professional

Augmented Reality is one of the promising and ever-growing sectors of IT! Enter the world of Augmented Reality

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Implement machine learning-based clustering and classification in Python for pattern recognition and data analysis

Child Attachment Diploma The exceptionally fascinating mental field of kid connection is investigated in extraordinary detail in this course. Beginning with a glance at the primary hypotheses and scholars, the course clarifies the primary ideas and standards unmistakably and we ensure we cover every one of the essential focuses for you. Bowlby and Ainsworth have demonstrated to be gigantic supporters of the field of youngster connection and their work is painstakingly considered inside the course's 10 modules. This course will ideally show you how to adopt the thought process of a genuine master in the field of youngster connection hypothesis. You will be shown the signs to pay special mind to when there are any issues in this field and there are tests that can be carried out en route to more readily encourage this. Before the finish of the course, you ought to have the option to apply the core values of youngster connection hypothesis without hardly lifting a finger. From functioning as a social laborer, to a youngster analyst and surprisingly a study hall associate, this course will demonstrate to you that there is a particularly immense assortment of jobs associated with the field of kid connection. Without a doubt, the last module is given altogether to this conversation and is helpfully part between jobs that are more 'active' in the field of youngster connection, contrasted and those that may include this mental specialty in somewhat more speculative way. What You Will Learn A definite glance at the set of experiences and advancement of youngster connection hypothesis A conversation of the inside working models that are utilized in this field We take a gander at the principle supporters of this field (for example Ainsworth and Bowlby) You will have a lot of freedom to completely gain proficiency with the significant 'Weird Situation Test' You will think about the primary impacts of kid connection A glance at the moral contemplations that should be borne at the top of the priority list, particularly when working with kids How connection ought to balance out in later youth You will think about the immensely significant idea of weakness comparable to youngster connection Characterize 'mischief' and take a gander at 'levels of damage' in great detail A slippery top at only a portion of the bunch parts of business that are associated with this fascinating mental specialty. Advantages of the Course The capacity to perceive the indications of kid connection issues You will see how to carry out the 'Abnormal Situation Test' You will acquire the abilities that will empower you to work in an enormous assortment of fields associated with youngster connection Gain information on a really fascinating mental specialty Figure out how you can have a genuine effect in the field of youngster connection The capacity to concentrate from any area with an Internet association Become familiar with the material whenever and at your own speed Lifetime admittance to the course - no cutoff times Get a perceived affirmation while finishing the course, which will improve your profession possibilities.

Description Geology Diploma Elearncollege offers a diploma course in Geology that starts with a glance at the basics of the history of the geological formation of planet Earth, the different layers of the planet's interior and their properties, and the geological structures of continents and oceans. It explores the importance of tectonic forces through geological timescales, subduction zones, hot spots, and seafloor spreading. This course will teach you the significance of rock cycles for Earth, various methods used to classify sediment, and the basis of defining and classifying different types of rocks. Elearncollege's diploma course on Geology covers many aspects of the discipline, like mineral formation and the environmental factors associated with it, rock-forming minerals, silicate, 'Big Ten', and many other methods of classifying minerals, along with the benefits that these minerals have. You will be familiar with volcanoes' external and internal features, their types and categories of eruption, volcanic tephra constituents, lava flow types, and subduction zone volcanoes. The course also explores seismology, the processes leading to earthquakes, building mountains, and other activities associated with the field. It also covers the hazards associated with earthquakes. The Geology Diploma course will teach you climate trends that have come and gone throughout the geological history of Earth, different systems that cause modifications in climate, the importance of the ocean for the environment, different anthropogenic factors that influence climate, the formation of soil and the distribution, the planet's watershed, and processes that lead to contamination. It also teaches how to define geological times, differentiate relative dating techniques from absolute dating techniques, and understand various dating methods using evidence from fossils through radiometric isotope decay. Industrialisation and agriculture are examples of anthropogenic influences that are direct factors that lead to environmental changes on the planet. The course goes through the history of such. It looks at the ecological effects of industrialisation and agriculture and the adverse geological effects caused by urbanisation. The diploma course on Geology offered by Elearncollege has been infused with all necessary fundamental knowledge on geology to equip students with a deep and solid understanding of geology. The course will provide information about the weather, solar system, plate tectonics, rock types, volcanoes, and many other intriguing topics. Experienced instructors can provide detailed explanations about each topic and concept and pictures that will enhance comprehension. The Geology Diploma course ends with a discussion on fossil fuels, geological values associated with fossil fuels, the process of extraction and development, the effects on the environment, and a look into the future in the possible effects of economic mining, geothermal energy as a substitute for fossil fuel, and the geological implications that this could have. The diploma course in Geology is open for registration for any individual interested in geology and the environment in general. It would be beneficial for any person who considers obtaining a degree in environmental science or for teachers who want to gain additional knowledge on geography and geology that they can use to enhance their classroom teaching. What you will learn  1: Rocks  2: Mineral Deposits  3: Fossil Fuels  4: History Of Earth  5: Environmental Geology  6: Earthquakes  7: Geological Hazards and Disaster Management  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Description US History Diploma Embark on a compelling journey through time with the US History Diploma, meticulously designed to provide a comprehensive understanding of the major events, movements, and eras that have shaped the United States of America. This online course is tailored to quench the thirst of history enthusiasts, students, or anyone keen on gaining a robust grasp of the vast tapestry of American history. Every chapter in the US History Diploma course has been carefully curated to shed light on significant periods that have left indelible marks on the nation's evolution. Starting with the profound circumstances surrounding the Founding of the United States, learners will navigate through the tumultuous waves of The American Revolution, understanding its impact and implications on the modern world. As students progress, they will encounter the Expansion and Manifest Destiny period, delving into the intricate tales of frontier pioneers, their ambitions, and the consequences of westward movement. The deep scars of Slavery and the Civil War come alive in this course, painting a vivid picture of the battles, both ideological and physical, that threatened the very fabric of the nation. The subsequent chapters address the trials and tribulations of Rebuilding and Reuniting the Nation, offering insights into how a nation torn apart tried to stitch itself back together. The US History Diploma doesn't stop there. The vibrant tales of The Gilded Age unfold, revealing stories of opulence, innovation, and change. As learners move into the 20th Century, they are introduced to seismic Social and Political Changes that reshaped societal norms and values. The epic sagas of The World Wars are covered in depth, examining the role of the United States on the global stage and how these colossal conflicts reshaped international dynamics. The struggle for equality comes to the fore as the course delves into The Civil Rights Movement. This chapter is an eye-opener, revealing the strength, resilience, and determination of those who fought for justice and equality in the face of adversity. And lastly, Modern America awaits, offering a close look at contemporary challenges, achievements, and the path forward. The US History Diploma stands out due to its online format. It offers flexibility, allowing learners to embark on this historical journey at their own pace and convenience. High-quality multimedia materials, interactive sessions, and expert insights ensure that this is not just another history course but an immersive experience. In conclusion, the US History Diploma is more than just a course; it's a journey. It's an invitation to traverse through time, understand the core events that have sculpted America, and gain a profound appreciation for the nation's legacy. Enrolling in this online course is not just an investment in knowledge but a commitment to understanding the intricate layers of a nation's story. Join now and be a part of this enlightening journey. What you will learn 1:The Founding of the United States 2:The American Revolution 3:Expansion and Manifest Destiny 4:Slavery and the Civil War 5:The Challenge of Rebuilding and Reuniting the Nation 6:The Gilded Age 7:Social and Political Change in the Early 20th Century 8:The World Wars 9:The Civil Rights Movement 10:Modern America Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

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