4209 Courses

The 'Complete Investing Course' provides a comprehensive introduction to investment, covering different types and techniques of investment, key concepts in finance, and specific investment opportunities in the bond and stock markets. Additionally, the course explores risk management and portfolio strategies to enhance investment decision-making. Learning Outcomes: Understand the fundamentals of investment and its importance in personal finance. Identify various types of investments and the techniques used to analyze and evaluate them. Comprehend key financial concepts and terminology relevant to investing. Gain insights into the bond market and learn how to make informed investment decisions in bonds. Explore the stock market and understand strategies for investing in stocks effectively. Learn techniques for managing investment risks and building a diversified investment portfolio. Apply investment knowledge and principles to make informed and sound investment decisions. Why buy this Investment: Complete Investing Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Investment: Complete Investing Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Investment: Complete Investing Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Investment: Complete Investing Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Investment: Complete Investing 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Investment: Complete Investing Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction to Investment Introduction to Investment 00:14:00 Module 02: Types and Techniques of Investment Types and Techniques of Investment 00:20:00 Module 03: Key Concepts in Investment Key Concepts in Investment 00:17:00 Module 04: Understanding the Finance Understanding the Finance 00:14:00 Module 05: Investing in Bond Market Investing in Bond Market 00:14:00 Module 06: Investing in Stock Market Investing in Stock Market 00:17:00 Module 07: Risk and Portfolio Management Risk and Portfolio Management 00:16:00 Assignment Assignment - Investment: Complete Investing Course 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Price Action Day Trading with Tape Reading Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Price Action Day Trading with Tape Reading Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Price Action Day Trading with Tape Reading Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Price Action Day Trading with Tape Reading Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Price Action Day Trading with Tape Reading? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Price Action Day Trading with Tape Reading there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Price Action Day Trading with Tape Reading course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Price Action Day Trading with Tape Reading does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Price Action Day Trading with Tape Reading 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Price Action Day Trading with Tape Reading is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction 00:02:00 Unit 01: Basics of Tape Reading 1.1 Tape Reading 00:02:00 1.2 Level 1 vs Level 2 00:03:00 1.3 Supply and Demand 00:06:00 1.4 Time and sales 00:03:00 1.5 Importance of Tape Reading 00:03:00 Unit 02: Tape Reading Strategies 2.1 Hidden Buyers 00:11:00 2.2 Hidden Sellers 00:09:00 2.3 Fakeouts and Manipulation Tactics 00:05:00 2.4 Identifying Reversals with Tape Reading 00:08:00 Unit 03: Trading Platform Setup 3.1 Setting Up Trading Platform 00:30:00 3.2 Risk Free Practice Trading 00:07:00 Assignment Assignment - Price Action Day Trading with Tape Reading 00:00:00

Uncover the secrets behind financial foresight in our captivating Actuarial Science course. Navigate through the intricate world of financial risk assessment and valuation with a curriculum meticulously designed to empower you with the skills demanded in today's dynamic financial landscape. Delve into the realm of cash flow valuation and deterministic models, gaining insights into the backbone of financial decision-making. Explore life tables, annuities, and insurance, mastering the stochastic approach to contingencies. Confront challenges posed by taxation and inflation, unravel probabilistic models, and refine individual risk assessment. Embrace the principles of premium calculation and delve into the intricacies of multiple decrement theory. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this riveting exploration, discover the art of individual risk models and the principles of premium calculation. Craft a profound understanding of multiple decrement theory, equipping yourself with indispensable knowledge for navigating the complexities of financial landscapes. Elevate your financial acumen with this comprehensive exploration of actuarial science, where each module unravels a layer of strategic financial insight. Course Curriculum Module 1: Introduction to Actuary Module 2: Actuaries and Their Environment Module 3: The Valuation of Cash Flows Module 4: The Basic Deterministic Model Module 5: The Life Table Module 6: Life Annuities Module 7: Life Insurance Module 8: The Stochastic Life Contingencies Model Module 9: The Stochastic Approach to Insurance and Annuities Module 10: Taxation and Inflation Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Module 12: Individual Risk Models Module 13: Principles of Premium Calculation Module 14: Multiple Decrement Theory Learning Outcomes: Analyze and value cash flows with precision for strategic decision-making. Master the stochastic life contingencies model for advanced risk assessment. Apply principles of premium calculation to craft financially sound strategies. Develop a deep understanding of taxation and inflation in financial scenarios. Navigate uncertainties with individual risk models for robust financial planning. Acquire expertise in multiple decrement theory for comprehensive risk management. CPD 10 CPD hours / points Accredited by CPD Quality Standards The World of Actuaries 2:31:13 1: Module 1: Introduction to Actuary 12:29 2: Module 2: Actuaries and Their Environment 14:21 3: Module 3: The Valuation of Cash Flows 11:39 4: Module 4: The Basic Deterministic Model 10:50 5: Module 5: The Life Table 10:37 6: Module 6: Life Annuities 13:35 7: Module 7: Life Insurance 12:16 8: Module 8: The Stochastic Life Contingencies Model 10:46 9: Module 9: The Stochastic Approach to Insurance and Annuities 10:47 10: Module 10: Taxation and Inflation 07:58 11: Module 11: Probabilistic Models, Uncertain Payment and Profit Testing 07:58 12: Module 12: Individual Risk Models 07:11 13: Module 13: Principles of Premium Calculation 10:22 14: Module 14: Multiple Decrement Theory 09:24 15: CPD Certificate - Free 01:00 Who is this course for? Financial Analysts seeking advanced risk assessment skills. Actuarial Enthusiasts eager to delve into stochastic life contingencies models. Strategic Planners aiming to apply premium calculation principles effectively. Financial Managers wanting to master taxation and inflation dynamics. Risk Management Professionals looking to enhance individual risk modeling skills. Career path Financial Analyst Risk Manager Actuarial Consultant Investment Strategist Insurance Analyst Pension Fund Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Uncover the secrets behind financial foresight in our captivating Actuarial Science course. Navigate through the intricate world of financial risk assessment and valuation with a curriculum meticulously designed to empower you with the skills demanded in today's dynamic financial landscape. Delve into the realm of cash flow valuation and deterministic models, gaining insights into the backbone of financial decision-making. Explore life tables, annuities, and insurance, mastering the stochastic approach to contingencies. Confront challenges posed by taxation and inflation, unravel probabilistic models, and refine individual risk assessment. Embrace the principles of premium calculation and delve into the intricacies of multiple decrement theory. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this riveting exploration, discover the art of individual risk models and the principles of premium calculation. Craft a profound understanding of multiple decrement theory, equipping yourself with indispensable knowledge for navigating the complexities of financial landscapes. Elevate your financial acumen with this comprehensive exploration of actuarial science, where each module unravels a layer of strategic financial insight. Course Curriculum Module 1: Introduction to Actuary Module 2: Actuaries and Their Environment Module 3: The Valuation of Cash Flows Module 4: The Basic Deterministic Model Module 5: The Life Table Module 6: Life Annuities Module 7: Life Insurance Module 8: The Stochastic Life Contingencies Model Module 9: The Stochastic Approach to Insurance and Annuities Module 10: Taxation and Inflation Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Module 12: Individual Risk Models Module 13: Principles of Premium Calculation Module 14: Multiple Decrement Theory Learning Outcomes: Analyze and value cash flows with precision for strategic decision-making. Master the stochastic life contingencies model for advanced risk assessment. Apply principles of premium calculation to craft financially sound strategies. Develop a deep understanding of taxation and inflation in financial scenarios. Navigate uncertainties with individual risk models for robust financial planning. Acquire expertise in multiple decrement theory for comprehensive risk management. CPD 10 CPD hours / points Accredited by CPD Quality Standards The World of Actuaries 2:31:13 1: Module 1: Introduction to Actuary 12:29 2: Module 2: Actuaries and Their Environment 14:21 3: Module 3: The Valuation of Cash Flows 11:39 4: Module 4: The Basic Deterministic Model 10:50 5: Module 5: The Life Table 10:37 6: Module 6: Life Annuities 13:35 7: Module 7: Life Insurance 12:16 8: Module 8: The Stochastic Life Contingencies Model 10:46 9: Module 9: The Stochastic Approach to Insurance and Annuities 10:47 10: Module 10: Taxation and Inflation 07:58 11: Module 11: Probabilistic Models, Uncertain Payment and Profit Testing 07:58 12: Module 12: Individual Risk Models 07:11 13: Module 13: Principles of Premium Calculation 10:22 14: Module 14: Multiple Decrement Theory 09:24 15: CPD Certificate - Free 01:00 Who is this course for? Financial Analysts seeking advanced risk assessment skills. Actuarial Enthusiasts eager to delve into stochastic life contingencies models. Strategic Planners aiming to apply premium calculation principles effectively. Financial Managers wanting to master taxation and inflation dynamics. Risk Management Professionals looking to enhance individual risk modeling skills. Career path Financial Analyst Risk Manager Actuarial Consultant Investment Strategist Insurance Analyst Pension Fund Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Debt collection calls are a fact of life, whether you're in debt or not. Take this course on Debt Management and Financial Problem Resolving to learn how to deal with your debts without going bankrupt. This course will show you what you can do to reduce your exposure and minimize debt and the financial impact of debt. You'll be more prepared for the legal aspects of debt management with knowledge of laws regarding debt, bankruptcy, and insolvency. Enrol and let Debt Management and Financial Problem Resolving course guide you on your debt management. Learning Outcome Create effective debt management plans Learn about debt financing and budgeting Get lessons in debt counselling and good debt Handle debt collectors and manage your debt well Learn the legal consequences of debt What will Make You Stand Out? On completion of this Debt Management and Financial Problem Resolving online course, you will gain: CPD QS Accredited course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. Enroling in the Course has no additional cost. 24x7 Tutor Support You can study and complete the course at your own pace. Course Curriculum Debt Management and Financial Problem Resolving Module 01: Introduction to Debt Management Module 02: Long Term and Short Term Debt Module 03: Identifying Your Debt Module 04: Debt Management Plan Module 05: Debt Assessment Module 06: Debt Financing Module 07: Building Budget Module 08: Debt Counselling Module 09: When Is Debt Good? Module 10: Avoiding Debt Problems Module 11: How to Handle Debt Collectors Module 12: How to Get Out of Debt Module 13: Dealing with Bankruptcy and Insolvency Module 14: Laws and Regulations Show off your new skills with a certificate of completion. After successfully completing the course, you can order your CPD Accredited Certificates as proof of your achievement absolutely free. Please Note: The delivery charge for a Hardcopy Certificate inside the U.K. is £4.99, and international students have to pay £8.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course the Right Option for You? This Debt Management and Financial Problem Resolving course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. Requirements Without any formal requirements, you can delightfully enrol in this Debt Management and Financial Problem Resolving course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this course at your own pace. Career path The aim of this exclusive Debt Management and Financial Problem Resolving course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Essentials of UK VAT course might help you get there! Expand your expertise with high-quality training - study the Essentials of UK VAT course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Essentials of UK VAT online training course. The Essentials of UK VAT course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Essentials of UK VAT course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Essentials of UK VAT training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** ***Essentials of UK VAT*** Module 1: Understanding VAT Module 2: VAT Terminology and Calculation Module 3: VAT Taxable Persons Module 4: VAT Registration Module 5: VAT Rates Module 6: Invoicing and Records Module 7: VAT Application in Goods, Services and Vehicles Module 8: Supply Module 9: The VAT Return Module 10: Tips on VAT Compliance Module 11: VAT Exemptions and Zero-Rated VAT Module 12: Miscellaneous Issues and Penalties Module 13: Making Tax Digital Assessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Unlock the secrets of the wealthy by mastering diverse investment strategies designed to balance risk and reward. From value investing to real estate, cryptocurrencies to tax strategies, this course offers a holistic guide to building and sustaining wealth like never before.

Elevate your investment skills by building a resilient all-season portfolio. This course equips you with the advanced strategies and psychological insights to make informed investment choices, regardless of market conditions. Navigate through volatility and stay committed to your long-term goals with our comprehensive guide to all-season investing.

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Excel Course (Formula, VLOOKUP & Power Query) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Excel Course (Formula, VLOOKUP & Power Query) Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Excel Course (Formula, VLOOKUP & Power Query) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Excel Course (Formula, VLOOKUP & Power Query) Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Excel Course (Formula, VLOOKUP & Power Query)? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Excel Course (Formula, VLOOKUP & Power Query) there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Excel Course (Formula, VLOOKUP & Power Query) course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Excel Course (Formula, VLOOKUP & Power Query) does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Excel Course (Formula, VLOOKUP & Power Query) was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Excel Course (Formula, VLOOKUP & Power Query) is a great way for you to gain multiple skills from the comfort of your home. 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: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 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:07: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 Assignment Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query) 04:41:00 Order Your Certificate Order Your Certificate QLS

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced MS Office Excel Course Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced MS Office Excel Course Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced MS Office Excel Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced MS Office Excel Course Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced MS Office Excel Course ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced MS Office Excel Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced MS Office Excel Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced MS Office Excel Course does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Advanced MS Office Excel Course was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced MS Office Excel Course is a great way for you to gain multiple skills from the comfort of your home. Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Final Exam