Overview of Medical Math and Pharmacy Calculations Mastery Join our Medical Math and Pharmacy Calculations Mastery course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Medical Math and Pharmacy Calculations Mastery course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Medical Math and Pharmacy Calculations Mastery course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Medical Math and Pharmacy Calculations Mastery Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Medical Math and Pharmacy Calculations Mastery. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Medical Math and Pharmacy Calculations Mastery course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Medical Math and Pharmacy Calculations Mastery is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Medical Math and Pharmacy Calculations Mastery course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Medical Math and Pharmacy Calculations Mastery Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Introduction 1 lecture Medical Math and Pharmacy Calculations Mastery - 01 00:01:00 Conversions Medical Math and Pharmacy Calculations Mastery - 02 00:04:00 Medical Math and Pharmacy Calculations Mastery - 03 00:09:00 Medical Math and Pharmacy Calculations Mastery - 04 00:13:00 Conversions Using Ratio - Proportion or Dimensional Analysis Medical Math and Pharmacy Calculations Mastery - 05 00:05:00 Medical Math and Pharmacy Calculations Mastery - 06 00:07:00 Medical Math and Pharmacy Calculations Mastery - 07 00:14:00 Medical Math and Pharmacy Calculations Mastery - 08 00:04:00 Medical Math and Pharmacy Calculations Mastery - 09 00:08:00 Pharmacy Math Medical Math and Pharmacy Calculations Mastery - 10 00:07:00 11- Quantity To Be Dispensed 00:03:00 12 - Single Dose, Single Day, Total Volume 00:12:00 Business Math 13 - Business Math Terminologies 00:08:00 14 - Business Math Mark-up Discount 00:16:00 15 - Retail Business Math Mark-up Amount & Mark-up Percentage 00:08:00 16 - Retail Business Math Discount Amount & Discount Percentage 00:15:00 17 - Pharmacy Business Math Purchase Price, Discount, and Discount Percentage 00:03:00 18 - Pharmacy Business Math Percentage Markup Rate 00:02:00 19 - Pharmacy Business Math Gross Profit Net Profit 00:03:00 Understanding Percentages, Strengths & Concentration 20 - Percentages, Strengths & Concentration 00:15:00 21 - % wv, % ww, % vv 00:06:00 Hospital and Compounding Math: Alligation & Dilution 22 - Review of Percentages, Strengths & Concentration 00:02:00 23 - Alligation & Dilution 00:04:00 24 - Application of Percentage, Alligation & Dilution 00:03:00 25 - Practice Problems 00:17:00 26 - More Practice Problems 00:02:00 Hospital Math: Flow Rate & Drip Rate 27 - Flow Rate vs Drip Rate 00:12:00 28 - Finding the R 00:07:00 29 - Finding the T 00:06:00 30 - Finding the V 00:03:00 Dosage Calculation 31 - Dosage Calculation Based on Weight & Age 00:05:00 32 - Dosage Calculation Based on Body Surface Area (BSA) 00:06:00 33 - BSA Practice Problems 00:03:00 34 - Therapeutic Dose versus Lethal Dose 00:02:00 35 - Therapeutic Range Minimum and Maximum Dose 00:08:00 36 - Dosage Calculation Based on Weight mgkgday & mgkgdose 00:07:00 37 - Pediatric Daily Rate 00:06:00
In a buzzing co-working space right in the heart of Manchester, you feel the weight of managing a diverse team. As you sip your morning tea, you ponder on how to handle remote teammates, delegate tasks effectively, and maintain a balance of equality and diversity. The pressure mounts as decisions await and targets loom. Then, as you scroll through online resources, you stumble upon a solution: a comprehensive team management training bundle... Embark on a transformative journey into the realm of team management and leadership. This Team Management, Leadership & Delegation Skills bundle, consisting of eight meticulously crafted courses, is designed to furnish you with the theoretical expertise needed to lead teams with flair, make precise decisions, and uplift workplace productivity. Courses like 'Leadership and Management', 'Team Management Level 5', 'Delegation Skills', and 'Decision-Making in High-Stress Situations' beckon, promising to redefine your team management prowess. The essence of this Team Management, Leadership & Delegation Skills bundle is to nurture leaders who are adept at navigating the challenges of modern team management. Through mastering delegation, optimising remote teamwork, ensuring equality and diversity, and bolstering decision-making capabilities, you are set to shine in any organisational setup. Courses Included in the Bundle: Course 01: Leadership and Management Course Course 02: Team Management Level 5 Course 03: Delegation Skills Course 04: Leading and Managing Remote Team Course 05: Performance Management Level 3 Course 06: Equality, Diversity and Discrimination Course 07: Workplace Productivity Training Course 08: Decision-Making in High-Stress Situations Learning Outcomes Grasp the foundational principles of leadership and effective team management. Understand the intricacies of managing remote teams and enhancing productivity. Master the art of delegation to ensure optimal team performance. Acquire insights on maintaining equality, diversity, and preventing discrimination in the workplace. Develop proficiency in making informed decisions, especially in high-stress situations. Gain a comprehensive understanding of performance management strategies. Leadership and Management Course: Dive deep into the principles that shape great leaders and mould productive teams. Team Management Level 5: Elevate your team management strategies to new heights and overcome intricate challenges. Delegation Skills: Learn to effectively delegate tasks and responsibilities, ensuring seamless team operations. Leading and Managing Remote Team: Understand the dynamics of remote teamwork and how to lead from afar. Performance Management Level 3: Enhance your team's capabilities and maximise their potential. Equality, Diversity and Discrimination: Promote an inclusive environment and tackle workplace discrimination. Workplace Productivity Training: Drive productivity and ensure your team consistently delivers. Decision-Making in High-Stress Situations: Equip yourself with the skills to make sound decisions under pressure. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring leaders looking to sharpen their team management capabilities. Professionals aiming to improve team productivity and cohesion. Individuals looking to broaden their knowledge on workplace diversity and inclusivity. Managers seeking to lead remote teams effectively. Decision-makers wanting to bolster their decision-making prowess in stressful situations. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Team Manager - £30K to £50K/year. Project Leader - £35K to £55K/year. Performance Analyst - £28K to £45K/year. Remote Team Supervisor - £32K to £48K/year. HR Specialist (Diversity and Inclusion) - £40K to £60K/year. Productivity Consultant - £35K to £52K/year. Decision-making Strategist - £38K to £56K/year. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99
Are you ready to embark on an enlightening journey of wisdom with the Digital Marketing & Email Marketing bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - ChatGPT, Social Media, Digital Marketing with Email Marketing. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: A Beginner Crash Course on ChatGPT Course 02: ChatGPT Complete Guide with Expertise Course 03: PR : Public Relation Course 04: Media Studies Course 05: Screenwriting & Scriptwriting Course 06: ICT: Information and Communication Technology Course 07: Social Media Marketing Course -The Step by Step Guide Course 08: ChatGPT for Marketing and Productivity with AI Tools Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the ChatGPT, Social Media, Digital Marketing with Email Marketing bundle illuminate your path to wisdom. The ChatGPT, Social Media, Digital Marketing with Email Marketing bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the ChatGPT, Social Media, Digital Marketing with Email Marketing package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Digital Marketing & Email Marketing bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the ChatGPT, Social Media, Digital Marketing with Email Marketing community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Digital Marketing & Email Marketing bundle. Establish robust bases across each course nestled within the Digital Marketing & Email Marketing bundle. Decipher intricate concepts through the articulate content of the Digital Marketing & Email Marketing bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Digital Marketing & Email Marketing bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Digital Marketing & Email Marketing bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Digital Marketing & Email Marketing bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Digital Marketing & Email Marketing bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Digital Marketing & Email Marketing bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Digital Marketing & Email Marketing journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Digital Marketing & Email Marketing bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Digital Marketing & Email Marketing bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99
Are you ready to embark on an enlightening journey of wisdom with the Administrator bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Administrator: PA, HR, Delegation Skills & Paralegal Training. Delve into eight immersive CPD Accredited courses, each a standalone course: Office Administration Personal Assistant HR Management Course Online Meeting Management Performance Management Level 3 Delegation Skills Paralegal Training Workplace Stress Management Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Administrator: PA, HR, Delegation Skills & Paralegal Training bundle illuminate your path to wisdom. The Administrator: PA, HR, Delegation Skills & Paralegal Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Administrator: PA, HR, Delegation Skills & Paralegal Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Administrator bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Administrator: PA, HR, Delegation Skills & Paralegal Training community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Administrator bundle. Establish robust bases across each course nestled within the Administrator bundle. Decipher intricate concepts through the articulate content of the Administrator bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Administrator bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Administrator bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Administrator bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Administrator bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Administrator bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Administrator journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Administrator bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Administrator bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99
Advance your Python skills with Level 2 Programming! From strings and operators to control flow and games, this course sharpens your coding prowess, culminating in a hands-on Python project. Ideal for those seeking to deepen their understanding and application of Python.
Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours 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 Excel for financial modelling Understand the core competencies and principles of Excel for financial modelling Explore the various areas of Excel for financial modelling Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Quick Excel for Financial Modeling Course Online Master the skills you need to propel your career forward in accounting. This course will equip you with the essential knowledge and skillset that will make you a confident accountant and take your career to the next level. This comprehensive Quick Excel for Financial Modeling Course Online is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Quick Excel for Financial Modeling Course Online will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This Quick Excel for Financial Modelling at QLS Level 5 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. This comprehensive course will teach you the theory of effective accounting practice and equip you with the essential skills, confidence and competence to assist you in the accounting industry. You'll gain a solid understanding of the core competencies required to drive a successful career in accounting. 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 accountant or for people who are aspiring to specialise in accounting.This Quick Excel for Financial Modelling at QLS Level 5 course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Enrol in this Quick Excel for Financial Modeling Course Online 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 Quick Excel for Financial Modeling Course Online 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 accounting 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 Quick Excel for Financial Modeling Course Online 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 Quick Excel for Financial Modeling Course Online 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 Quick Excel for Financial Modeling Course Online 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 Introduction Course Overview 00:04:00 Planning your Financial Model 00:09:00 Building a Model Template 00:12:00 Projecting the Income Statement 00:13:00 Projecting the Balance Sheet 00:17:00 Projecting Cash Flows 00:14:00 Advanced Financial Modeling 00:14:00 BONUS LESSON: Top 5 Excel Features for Financial Modellers 00:08:00 Supporting Materials Slides: Financial Modeling Using Excel 00:00:00 Financial Modeling Using Excel Glossary/Index 00:00:00 Excel Files âStart and Solutionâ 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00
SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. This Azure - SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure's data services, from a single database instance to a massive scale data warehouse for working with Big data. You'll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database. Finally, you'll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. What Will I Learn? Overview and provision Azure SQL Connect to Azure SQL DB and Migrate DB to Azure Work with SQL security and metrics Configure SQL DB auditing Copy and export a database Use DB Self-Service Restore and SQL DB Geo-Replication Who is the target audience? Students wanting an understanding of Azure SQL and to build their skills. Requirements Basic understanding of Azure and SQL concepts Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Course Certification
Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended. Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00