1538 Finance Cert & Exam Prep courses delivered On Demand

Conducting fun and interactive activities are one of the ways to bond with family and loved ones. However, due to budget constraint, people are being hesitant in conducting activities. This course will help you, your family or your clients in finding several ways to have fun without spending too much money. Also, it is important that in deciding fun activities, you should consider the happiness and safety of your children. To create more interesting events, you have to learn how to plan and organise everything, and this is what this course is for. Who is the course for? People who are interested in fun but affordable activities and how to plan them well. Anyone who wants to know bonding activities that do need to spend lots of money but still have fun with family and loved ones. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Family Activities course is for those people interested in learning about free activities to enjoy with their family without sacrificing their hard-earned money. This course can also be guided to professionals dealing with event plannings and family management like: Housekeeper Nanny Personal Assistant. Family Activities Chapter-1 01:00:00 Chapter-2 01:00:00 Chapter-3 00:30:00 Chapter-4 00:30:00 Chapter-5 00:15:00 Conclusion 00:15:00 Mock Exam Mock Exam- Family Activities 00:20:00 Final Exam Final Exam- Family Activities 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Embark on a journey to master the intricacies of navigating sanctions risk with our comprehensive course, 'Navigating Sanctions Risk: A Comprehensive Management Guide.' In today's complex global landscape, understanding sanctions is not just essential but a strategic advantage. This course is your compass, guiding you through the ever-evolving world of sanctions, from the fundamentals to emerging trends. Get ready to unlock the knowledge that empowers you to navigate sanctions risk with confidence. Learning Outcomes Gain a solid foundation in the Introduction to Sanctions and their significance in the modern world. Identify and comprehend various Types of Sanctions, their implications, and enforcement mechanisms. Master the intricate web of Sanctions Regulations and Compliance, ensuring your organization remains ethically and legally sound. Acquire the skills needed for effective Sanctions Screening and Due Diligence to protect your business interests. Develop Risk Mitigation Strategies and Sanctions Compliance Programs tailored to your organization's needs, safeguarding against financial and reputational risks. Why buy this Navigating Sanctions Risk: A Comprehensive Management Guide Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Navigating Sanctions Risk: A Comprehensive Management Guide Course for? Professionals in financial services seeking to enhance their compliance knowledge. Business owners and managers responsible for international operations. Legal experts looking to specialize in sanctions law. Risk analysts and consultants focused on global risk management. Government officials involved in international trade and security. Career path Compliance Officer: £40,000 - £80,000 per annum Sanctions Analyst: £35,000 - £65,000 per annum International Trade Consultant: £45,000 - £90,000 per annum Legal Advisor (Sanctions Law): £50,000 - £100,000 per annum Risk Manager: £55,000 - £110,000 per annum Financial Investigator: £45,000 - £95,000 per annum Prerequisites This Navigating Sanctions Risk: A Comprehensive Management Guide does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Sanctions Introduction to Sanctions 00:21:00 Module 2: Types of Sanctions Types of Sanctions 00:19:00 Module 3: Sanctions Regulations and Compliance Sanctions Regulations and Compliance 00:20:00 Module 4: Sanctions Screening and Due Diligence Sanctions Screening and Due Diligence 00:20:00 Module 5: Risk Mitigation Strategies and Sanctions Compliance Programs Risk Mitigation Strategies and Sanctions Compliance Programs 00:27:00 Module 6: Emerging Trends and Future Outlook Emerging Trends and Future Outlook 00:00:00

With our course 'Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!' you can take a dynamic learning trip and advance your Excel skills to new levels. In just 50 minutes, unlock the secrets of Excel's most potent formulas, revolutionizing your approach to data manipulation and analysis. This isn't your average Excel tutorial; it's a fast-paced, immersive experience crafted to optimally utilize every minute of your learning journey. Dive into the intricacies of text, mathematical, date and time, logic, and financial formulas, demystifying their complexities with engaging exercises and comprehensive answers. Each module is strategically structured, ensuring you grasp the essence of Excel's powerhouse formulas efficiently. Whether you're a novice eager to conquer Excel or a seasoned user aiming to enhance your skills, this course offers a streamlined, time-efficient path to mastery. Learning Outcomes Text Formulas Proficiency: Master text manipulation with Excel, enhancing your ability to streamline and present information effectively. Mathematical Formula Mastery: Acquire a deep understanding of mathematical formulas, enabling you to perform complex calculations effortlessly. Date and Time Formula Expertise: Unlock the potential of Excel's date and time functions, facilitating precise chronological data management. Logic Formulas Competence: Develop proficiency in logic formulas, empowering you to create dynamic decision-making processes within your spreadsheets. Financial Formula Proficiency: Gain financial acumen by mastering Excel's financial formulas, essential for robust financial analysis and planning. Why choose this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course for? Individuals seeking to boost their Excel proficiency quickly. Students aiming to enhance their data manipulation skills. Professionals wanting to streamline their spreadsheet tasks efficiently. Entrepreneurs and small business owners looking to optimize data analysis. Anyone keen on mastering Excel's powerful formulas for personal or professional growth. Career path Data Analyst: £25,000 - £40,000 Financial Analyst: £30,000 - £50,000 Business Intelligence Specialist: £35,000 - £55,000 Project Manager: £40,000 - £60,000 Operations Manager: £45,000 - £70,000 Management Consultant: £50,000 - £80,000 Prerequisites This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Excel promo 00:01:00 Getting the most of the course 00:01: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:06: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 Additional Resources Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 00:00:00

Description: The Thinking Critically in the Workplace - Video Training Course will help you to think critically about the problems and solutions in the workplace. Throughout the course, you will learn how to face problems and how to find a solution based on the problems so that you can take decisions. Facing any problem is a challenging. The courses will teach you an in-depth analysis of critical thinking process, group dynamics, different essential methods of thinking and the types of problem-solving approaches. After the details analysis of the ways of facing the problem, the course will teach you the strategies of exploring the problem and guides you to discover the probable solution. Finally, the course will help you to take and accept a decision on the problem. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Thinking Critically in the Workplace - Video Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Thinking Critically in the Workplace - Video Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Facing New Problems The Critical Thinking Process FREE 00:24:00 Group Dynamics 00:17:00 Critical Thinking Methods 00:04:00 Problem Solving Approaches 00:09:00 Establishing the Problem A Identify the Problem 00:08:00 Exploring the Problem 00:06:00 Discovering the Solution Assembling Potential Ideas 00:09:00 Determining the Best Solution 00:04:00 Evaluating Cost and Benefit 00:05:00 Building Your Case 00:02:00 Accepting a Decision Accepting a Decision 00:13:00 Mock Exam Mock Exam- Thinking Critically in the Workplace - Video Training Course 00:20:00 Final Exam Final Exam- Thinking Critically in the Workplace - Video Training Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: In addition to proper organization, in any business requires planning and scheduling, two key elements of effective projects management. As a responsible business owner it's beneficial to set out a clear plan with an accompanying schedule, so that you and your employees can accomplish your goals. This Project Planning and Scheduling Diploma will provide the factors and fundamental elements that you should consider and address when creating any schedule. You will learn to define and create a Work Breakdown Structure, how to estimate task duration and determine project duration, and more important points you need to know to get success. Learning Outcomes: Provide a definition to produce a Work Breakdown Structure Recognise as well as realise task relationship Measure task durations as well as learn determining the project duration Build a network diagram Assess the critical routes of a project Apply the Program Evaluation Review Technique (PERT) to generate estimates Set strategy in case of risk matters Produce a communication method Learn distributing project resources Know how to upgrade and monitor the project schedule Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Project Planning and Scheduling Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Project Planning and Scheduling Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Project Planning and Scheduling Diploma Course Overview - (Project Planning and Scheduling Diploma) 00:05:00 The Work Breakdown Structure (WBS) 00:15:00 Estimating Activity Durations 00:15:00 Identifying Task Dependencies 00:15:00 Aligning Resources with Activities 00:15:00 Project Planning 00:30:00 Scheduling Software 00:15:00 Uncertainty and Risk Management 00:15:00 Communication Strategies 00:45:00 Creating a Viable Schedule 00:05:00 Updating and Monitoring the Schedule 00:15:00 Mock Exam Mock Exam- Project Planning and Scheduling Diploma 00:20:00 Final Exam Final Exam- Project Planning and Scheduling Diploma 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

AML and Financial Investigator course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This AML and Financial Investigator course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease. Anti-Money Laundering (AML) - Level 3 This Anti-Money Laundering Course is for anyone who wants to learn more about money laundering and the career opportunities in this field. It provides up-to-date information to protect your organization from suspicious activity, with step-by-step training on how to conduct a client risk assessment. Financial Investigator Financial Investigator teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. Key Features of this bundle Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum of Anti-Money Laundering (AML) - Level 3 The detailed curriculum outline of our Anti-Money Laundering (AML) - Level 3 course is as follows: Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course Curriculum of Financial Investigator The detailed curriculum outline of our Financial Investigator course is as follows: Module 01: Introduction to Financial Investigator Module 02: Introduction to Financial Investigation Module 03: Characteristics of Financial Crimes Module 04: Categories of Financial Crimes Module 05: Financial Crime Response Plan Module 06: Collecting, Preserving and Gathering Evidence Module 07: Laws against Financial Fraud Accreditation All of our courses, including this bundle course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your bundle course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Who is this course for? Anyone with a knack for learning new skills can take this AML and Financial Investigator course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00

Overview This comprehensive course on Investment will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Investment comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Investment. It is available to all students, of all academic backgrounds. Requirements Our Investment is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 01:59:00 total length •Introduction to Investment: 00:15:00 •Types and Techniques of Investment: 00:21:00 •Key Concepts in Investment: 00:18:00 •Understanding the Finance: 00:15:00 •Investing in Bond Market: 00:15:00 •Investing in Stock Market: 00:18:00 •Risk and Portfolio Management: 00:17:00 •Assignment - Investment: 00:00:00

Overview This comprehensive course on Learn to Read, Analyse and Understand Annual Reports will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn to Read, Analyse and Understand Annual Reports 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 Learn to Read, Analyse and Understand Annual Reports. It is available to all students, of all academic backgrounds. Requirements Our Learn to Read, Analyse and Understand Annual Reports is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 17 lectures • 02:59:00 total length •Introduction to the annual Reports: 00:04:00 •Annual Report information requirements from stock exchanges: 00:12:00 •Sample of Annual Reports: 00:06:00 •How to Download reports from Stock Exchanges: 00:05:00 •How to Download reports from Company Websites: 00:05:00 •Overview of annual report downloaded in the previous video: 00:02:00 •Explaining the Structure of 10K and annual reports: 00:13:00 •Key Steps in getting around with Annual Reports: 00:09:00 •Understanding Company and its business: 00:17:00 •Understanding Risks related to the company: 00:16:00 •Understanding market news and development to understand risks and manage: 00:08:00 •Reading Management Discussion and Analysis: 00:16:00 •Using vertical analysis and horizontal analysis to identify the concerned area: 00:18:00 •Understanding the balance sheet and using Ratio analysis, cash flow: 00:26:00 •Completed Example of Southwest Airlines: 00:18:00 •Final Video on presentation and assignment: 00:04:00 •Resource - Learn to Read Analyse and Undertand Annual Reports: 00:00:00

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 5 sections • 41 lectures • 02:56:00 total length •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 •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 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00