Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: The CPD Certification Service Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want This course will take you to the fascinating world of the mind, where you will discover the hypnotherapy techniques, and practical experience in conducting hypnotherapy sessions, offering you a rewarding career path in the world of emotional wellness. This course at a glance Eligible to apply for the insurance Accredited by International Practitioners of Holistic Medicine (IPHM) Accredited by CPD UK Endorsed by Quality Licence Scheme Recognise the objectives of hypnotherapy Learn how to create the life of your dreams with this program Know the importance of deep breathing and meditation and learn to practice the same Get a better understanding of the law of attraction Get to know about quantum physics Recognise the three steps for creating your reality Learn to love yourself the way you are Understand the science of Neuroplasticity Learn the exercises to manifest your desires Know why we keep repeating patterns of thought or beliefs Why Complete Hypnotherapy Course right for you? This hypnotherapy course online will strengthen your knowledge in hypnotherapy which is highly efficient in treating various behavioural, psychological and psychosomatic issues. With this comprehensive online course, you will learn to create the life of your dream. This online complete hypnotherapy course will also explain to you how to feel good with the law of attraction and help you gain an understanding of the science of Neuroplasticity. By taking this flexible online course, you will also learn the exercises to manifest your desire, create your personal power affirmation, and change your limiting beliefs. By the end of the course, you will be able to recognise the skills and knowledge required to have a stress-free and happy life. You will also learn how to avoid anxiety, addiction, depression and more by taking this top-rated online course. Complete Hypnotherapy Course Details Accredited by International Practitioners of Holistic Medicine (IPHM) is a leading accredited organisation that certifies and regulates alternative therapists, healers, and training providers around the world. After completing the IPHM accredited course you will be eligible to apply for the insurance. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Course Curriculum Introduction How to Create the Life of Your Dreams With This Program Meet Chris Your Facilitator Important! How to Get the Most Benefit From This Course How to Feel Good With the Law of Attraction: 'theory' Module One Learn a Simple Breathing Meditation Feeling Good is the Most Important Thing You Can Do for Yourself Do You Want Change the Condition or Do You Want to Feel Better Now The Law of Attraction Explained Quantum Physics and the Law of Attraction Love Yourself as You Are Three Steps to Creating Your Reality Feeling Good Unconditionally The Deep Mind System: 'theory' Module Two The Deep Mind System Brainwave Patterns Beliefs in the Subconscious Mind New Science of Neuroplasticity The Deep Mind System Explained. Manifest Your Desires Explained Manifest Your Desires Explained Creating Your Personal Power Affirmation Creating Your Personal Power Affirmation Part 1. Creating Your Personal Power Affirmation Part 2 Creating Your Personal Power Affirmation Part 3 Creating Your Personal Power Affirmation Part 4 Creating Your Personal Power Affirmation Part 5 Changing Your Limiting Beliefs Exercise Momentum: Why We Keep Repeating Patterns of Thought or Beliefs Inspired Action Changing Your Limiting Beliefs Part 1 Changing Your Limiting Beliefs Part 2 Changing Your Limiting Beliefs Part 3 Changing Your Limiting Beliefs Explained Lessons Learned and Wrap Up Lessons Learned and Wrap Up Who should take this course? This hypnotherapy course online is ideal for anyone who desires to strengthen their understanding of hypnotherapy. Those who are willing to develop a solid foundation to become confident Hypnotherapists can also opt for this career advancement course. Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This hypnotherapy 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 can grasp from each section. In the assessment pass mark is 60% Certification Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org
Students who complete PVOL202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (â) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system
The Executive Secretarial & PA Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Executive Secretarial & PA Course consists of several modules that take around 11 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital 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 Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Introduction to Personal Assistant Introduction to Personal Assistant 00:18:00 Module 2: Business Telephone Skills Business Telephone Skills 00:20:00 Module 3: Representing Your Boss and Company Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences Organising Meeting and Conferences 00:28:00 Module 7: Time Management Time Management 00:38:00 Module 8: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills Business Writing Skills 00:43:00 Module 10: Organisational Skills Organisational Skills 00:28:00 Module 11: Communication Skills Communication Skills 00:28:00 Module 12: Customer Service Customer Service 00:19:00 Module 13: Effective Planning and Scheduling Effective Planning and Scheduling 00:49:00 Module 14: Document Proofreading and Editing Document Proofreading and Editing 00:08:00 Module 15: Advanced MS Excel Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:05:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:06:00 Microsoft Excel Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05: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.
Innovation and Design - Thinking Beyond the Obvious: On-Demand Thinking and doing the same has got to change. The world we live in is becoming more volatile, uncertain, complex, and ambiguous. Expanding our innovation and design thinking capabilities is a key to unlock solutions for some of our biggest global and local challenges. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated context, this course provides participants with the knowledge needed to not only learn about innovation and what is needed to make it sustainable in your organization but also to inspire others to innovate and think beyond the obvious, What You Will Learn At the end of this program, you will be able to: Explain the link between innovation and strategy Describe the value of expanding your innovation practice and creating an innovative culture would be Apply a basic set of Design Thinking techniques to your innovation projects Promote innovative practices within your teams and processes in your work environment Foundation Concepts The context for innovation What is innovation Comparing innovation to invention Innovation and Strategy Run and changing the business The power of disruptors Three horizons of growth Strategy and innovation portfolio links Innovation strategy and delivery Measuring value from innovation Design Thinking What is design thinking Why design thinking Design thinking frameworks Stanford university d.School model Design thinking general practices Innovative Decision Making Leaders focus on value creation Effective decision making Characteristics of great leaders and sponsors Measuring innovation leadership effectiveness Situational leadership and overcoming bias Building an Innovative Team Forming innovative teams Values and behaviors that support innovation Building an energized team culture Mindset is key Embracing collaboration and multimodal working Innovative Culture Introduction to organizational culture Benefits and barrier to enterprise agility Enabling innovation across the organization Leaders are critical Success factors for an innovative culture
Learn essential parenting skills and techniques in our online course. Discover effective approaches to create strong family bonds and foster a conducive environment for everyone. Whether you’re a new parent or seeking to enhance your existing skills, this course provides valuable insights. Enrol now and build a foundation for positive parenting!
Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Google Analytics mega bundle. This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Google Analytics bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Google Analytics bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Google Analytics Bundle consists of the following premium courses: Course 01: Google Data Studio: Data Analytics Course 02: Diploma in Data Analysis Fundamentals Course 03: Learn How To Optimize Your Google My Business Page In 2016 Course 04: How To Do Keyword Research For SEO & Ranking On Google Course 05: Excel Pivot Tables for Data Reporting Course 06: Research Methods in Business Course 07: Business Intelligence and Data Mining Course 08: Microsoft Power BI - Master Power BI in 90 Minutes! Course 09: PowerBI Formulas Course 10: Digital Marketing for Beginners to Advanced Course 11: Digital Marketing Starting an online E-Commerce Store Course 12: Marketing Strategies for Business Course 13: Strategic Planning and Analysis for Marketing Course 14: Statistical Analysis Course 15: Ultimate Social Media Marketing course Course 16: Python Course Course 17: Complete Online Marketing & Advertising Course Course 18: Social Media Marketing-The Step by Step Guide Course 19: Create Your First Responsive Website Course 20: Data Science & Machine Learning with Python Course 21: Fundamentals of Business Analysis Course 22: Excel Data Analysis Course 23: Quick Data Science Approach from Scratch Course 24: Basics of WordPress: Create Unlimited Websites Course 25: The Ultimate SEO Blueprint - Easily Ranking #1 On Google Course 26: Complete Communication Skills Master Class for Life Course 27: Public Speaking Course 28: Minute Taking Executive Training Course 29: Receptionist Skills Course 30: Time Management Training - Online Course Moreover, this bundles include 10 career-focused courses: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Course 06: Business English Perfection Course Course 07: Networking Skills for Personal Success Course 08: Boost Your Confidence and Self-Esteem Course 09: Public Speaking Training Course 10: Learn to Fight Procrastination Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Google Analytics mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Google Analytics to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free for all 40 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Google Analytics bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Google Analytics bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Google Data Studio: Data Analytics) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
ð Unlock the Power Within You: 'Hope - The Driving Force of Life' Online Course ð Are you ready to transform your life and embrace the unstoppable force that is HOPE? Welcome to a journey that will ignite your spirit, empower your mind, and propel you towards a future filled with limitless possibilities! ð Why Choose 'Hope - The Driving Force of Life' Online Course? ⨠Ignite Your Inner Flame: Discover the extraordinary strength that resides within you. Unleash the power of hope to fuel your dreams and aspirations. ⨠Overcome Challenges with Resilience: Life throws curveballs, but with hope as your guide, you'll navigate challenges with resilience, turning obstacles into stepping stones. ⨠Create a Positive Mindset: Learn the secrets to cultivating a positive mindset that attracts abundance, joy, and success into your life. ⨠Transform Adversity into Triumph: Witness the magic that happens when you channel hope to turn adversity into your greatest triumphs. ⨠Practical Tools and Strategies: Gain access to practical tools and strategies that you can implement immediately, bringing hope into every facet of your life. ⨠Expert Guidance: Our experienced instructors bring a wealth of knowledge, offering insights, stories, and proven techniques to inspire and guide you on your journey. ð What's Included in the Course? ð Comprehensive Modules: Dive into thoughtfully curated modules that cover everything from understanding the science of hope to practical exercises for daily application. ð Engaging Videos: Enjoy high-quality, engaging videos that bring the concepts to life, making your learning experience both enjoyable and memorable. ð Interactive Assignments: Apply what you've learned through interactive assignments, ensuring that the knowledge becomes a part of your daily routine. ð Community Support: Connect with a community of like-minded individuals on the same journey. Share experiences, provide encouragement, and celebrate victories together. ð Lifetime Access: Gain lifetime access to the course material, allowing you to revisit and reinforce your learning whenever you need a dose of inspiration. ð Special Limited-Time Offer: Enroll Now and Transform Your Life! Ready to embark on a life-changing adventure? Enroll in 'Hope - The Driving Force of Life' today and take advantage of our special limited-time offer. Your future self will thank you for investing in the power of hope! Don't miss out on the chance to reshape your destiny. Click the 'Enroll Now' button and let hope be the driving force that propels you towards the life you've always dreamed of. ð Embrace Hope. Ignite Your Future. Enroll Now! ð Course Curriculum
EnergyEdge's classroom training provides in-depth knowledge on project economics, risk assessment, and decision analysis for the oil and gas industry. Take your skills to the next level.
Overview This comprehensive course on Office Admin and Reception will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Admin and Reception 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 Office Admin and Reception. It is available to all students, of all academic backgrounds. Requirements Our Office Admin and Reception 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 17 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00