4079 Courses delivered Online

Overview 1 day course on IFRS 9 expected credit loss modelling, both for financial statement and capital stress testing purposes Who the course is for Credit risk management Quants ALM staff Finance Internal audit External auditors Bank investors – equity and credit investors Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Register on the Advanced Diploma in Microsoft Excel today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced Diploma in Microsoft Excel is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced Diploma in Microsoft Excel Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced Diploma in Microsoft Excel, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.

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 Forex Trading and AML course might help you get there! Expand your expertise with high-quality training - study the Forex Trading and AML 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 Forex Trading and AML online training course. The Forex Trading and AML 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 Forex Trading and AML 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 Forex Trading and AML 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 *** Here is the curriculum breakdown of the Forex Trading and AML course: Course 01: AML (Anti Money Laundering) Module 01: Introduction to Money Laundering What Is Money Laundering? Turning 'Bad' Money into 'Legitimate' Money How Is Money Laundered? Why Are AML Efforts Important? The Three Stages of Money Laundering Module 02: Proceeds of Crime Act 2002 Introduction The Principal Offences Contained in Part 7 of POCA 2002 The Notion of Criminal Property Elements of Criminal Property The Concept of Knowledge The Notion of Suspicion Module 03: Development of Anti-Money Laundering Regulation Introduction The First Money Laundering Directive Terrorism legislation The Proceeds of Crime Act 2002 and Serious Organised Crime and money laundering offences under the Police Act 2005 The Second Money Laundering Directive The Third Money Laundering Directive The Fourth Money Laundering Directive The Fifth Money Laundering Directive Module 04: Responsibility of the Money Laundering Reporting Officer What Is a Money Laundering Reporting Officer? Who Can be Appointed as an MLRO? The Role of The Money Laundering Reporting Officer Module 05: Risk-based Approach Introduction What Is a Risk-Based Approach (RBA)? A Risk-Based Approach to Customer Due Diligence (CDD) How to Assess the Risk Profile of The Entity How to Assess Client Risk Conducting the Client Risk Assessment Module 06: Customer Due Diligence What is Customer Due Diligence? Main Elements of a Customer Due Diligence Program Enhanced Due Diligence Enhanced Due Diligence for Higher-Risk Customers Account Opening, Customer Identification and Verification Consolidated Customer Due Diligence Module 07: Record Keeping The Purpose of Record-Keeping What Records Have to be Kept? Customer Identification In What Form Should Records be Kept? Failure to Keep Records Module 08: Suspicious Conduct and Transactions What Is Suspicious Activity? What Is a Suspicious Transaction? Avoiding a National Reporting or Record-Keeping Requirement Wire or Fund Transfers Insufficient or Suspicious Information by a Customer Other Suspicious Customer Activity The Identification of Unusual Transactions The Types of Events That Might Cause Suspicion Module 09: Awareness and Training The Importance of Staff Awareness and Training The Core Obligations of Training Legal and Regulatory Obligations Staff Responsibilities Internal Training Procedures Course 02: Forex Trading Diploma Introduction Major Currencies and Market Structure87 Kinds of Foreign Exchange Market Trading Psychology Money Management Fundamental Analysis Pitfalls and Risks Managing Risk Trading Psychology Assessment Process Once you have completed all the modules in the Forex Trading and AML course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Forex Trading and AML course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) 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 Forex Trading and AML 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.

Launch your journey in stock trading with this comprehensive course, designed to demystify market mechanics, financial analysis, and advanced trading strategies. Tailored for both beginners and seasoned traders, it offers insights into stock and bond valuation, emerging market trends, and essential risk management techniques.

Real Estate Investing and Wholesaling Diploma Unlock the potential of Real Estate investing with our cutting-edge Real Estate Investing and Wholesaling Diploma. Master wholesale buyer marketing and leverage your REI experience in Real Estate sales. Learning Outcomes: Analyze Courthouse Mailing Lists for Real Estate prospects. Engage in conversations with Probate Sellers in Real Estate. Execute Wholesale Buyer Marketing strategies in Real Estate. Acquire properties at minimal costs using Real Estate tactics. Interpret the nuances of Hard Money in Real Estate financing. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Real Estate Investing and Wholesaling Diploma: Courthouse Mailing Lists in Real Estate: Utilize courthouse databases to generate lucrative Real Estate mailing lists. Talking to Probate Sellers: Master the art of communication and negotiation with probate sellers in Real Estate. Wholesale Buyer Marketing in Real Estate: Develop and implement targeted marketing strategies to attract wholesale buyers in Real Estate. Buying Houses at Minimum Cost: Real Estate Tactics: Employ specific Real Estate tactics to acquire properties at rock-bottom prices. Understanding Hard Money: Gain insights into Hard Money lending and how it influences Real Estate investments. Leveraging REI Experience in Real Estate Sales: Use your Real Estate Investment (REI) experience to excel in Real Estate sales and negotiations.

Master Abrasive Wheel Safety with our expert training course. Learn about wheel types, safe operations, and inspection techniques to ensure workplace safety and compliance. Perfect for professionals in manufacturing, engineering, and construction sectors.

This Leisure management course will teach you how to manage and maintain a leisure facility, including a six-stage facility life cycle, benchmarking, quality management, asset management, operations, and activities. Furthermore, with modules packed with in-depth knowledge, this leisure management course lets you become acquainted with travel and tourism features. This Level 4 Leisure Management course is endorsed by The Quality Licence Scheme and accredited by CPD,(with 120 CPD points) to make your skill development and career progression related to Leisure Management substantial and easier than ever! After finishing this leisure management course, you will learn about managing hotels and accommodations as well as making choices to ensure the efficient running of the firm. In addition, after completing this leisure management course, you will have a better grasp of how to use human resources in the leisure business and how to apply leisure management or tourism marketing tactics. This leisure management course provides the learners with the knowledge of: Leisure industry and its management Discussion of the hotel and lodging sector and how to manage it Leadership skills in the leisure business to their full potential leisure industry's health and safety aspects The methods for managing and maintaining a recreational facility The essential characteristics of high-quality travel, tourist, and leisure facilities How to run a hotel or lodging business The fundamentals of leisure service planning Human Resource Management in the leisure industry leisure and recreation marketing Procedures for health and safety in recreational activities Why Prefer This Leisure Management Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another certificate accredited by CPDQS after completing this course Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. ****Course Curriculum**** Here is the curriculum breakdown of this course: Module 01: Introduction In this module, we will cover the following topics: Origin of Leisure in History Leisure in the 21st Century Understanding the Leisure Sector Tourism, Heritage and LeisureThe Environment, Countryside and Open SpaceThe Arts, Museums and LibrariesSport, Physical Recreation and Physical Activity Management Functions in Leisure Sector Career Opportunities in Leisure Sector Module 02: Managing and Maintaining a Leisure Facility In this module, we will cover the following topics: Six-Stage Facility Life-Cycle Benchmarking Steps of Benchmarking Customer Service: Expectations and Perceptions Customer Evaluation Criteria Quality Management Facility Asset Management Goals of Facility Asset Management Operations and Maintenance Sustainable Design Module 03: Travel, Tourism and Leisure In this module, we will cover the following topics: Characteristics of the Tourism Industry Core Industry SectorsTourism Business Factors Affecting Travel and Tourism EconomyPolitics and Government PoliciesSocio-Cultural ConflictsEnvironmentTechnology Tourism Destinations Elements of Influence in Destination Selection The Economic Significance of Tourism Module 04: Managing Hotel and Lodging In this module, we will cover the following topics: Classifications of Hotel Properties Hotels Classified by PriceHotels Classified by FunctionHotels Classified by LocationHotels Classified by Market Segment Major Functional Departments The Front OfficeHousekeepingSecuritySales and MarketingAccountingHuman ResourcesEngineering The Economics of the Hotel Business Dimensions of the Hotel Investment DecisionHotel Cycles and Financial Performance Module 05: Planning for Leisure Services In this module, we will cover the following topics: Planning In Organisations Some Planning Concepts Goal Setting Characteristics of Well-Thought-Out GoalsGoal CongruenceGoals and Policies Planning in Operations Strategic IssuesFrom Strategy to Tactics Individual Worker as Planner Planning as a Personal Process Long-Range Planning Tools Return on InvestmentCost-Benefit Analysis Module 06: Leadership in Leisure Industry In this module, we will cover the following topics: Characteristics of an Ideal Leader Deciding How to Lead Team Leading Goals and Skills Decision Making The Decision-Making Process Coaching, Mentoring and Motivational Leadership Motivational Leadership Module 07: Human Resource Management in Leisure Industry In this module, we will cover the following topics: Importance of HRM Tourism and HRM Human Resource Development Strategy Training Types and Levels of TrainingFuture Training Needs Rewards, Bonus, and Compensation Human Resource Information System Module 08: Marketing of Leisure and Recreation In this module, we will cover the following topics: Understanding the Marketing Process Understanding the Marketplace and Customer NeedsDesigning Customer Value-Driven Marketing StrategyPreparing an Integrated Marketing PlanBuilding Customer RelationshipsCapturing Value from Customers Developing Marketing Opportunities and Strategies Gaining Knowledge about the Marketing EnvironmentManaging Customer Information to Gain Customer InsightsConsumer Markets and Consumer Buying BehaviourOrganisational Buyer Behaviour Developing the Marketing Value-Driven Strategy and Mix Designing and Managing Products and BrandsInternal MarketingPricingDistribution Channels Delivering Customer ValueEngaging Customers and Communicating Customer Value and AdvertisingPromoting Products Managing Leisure and Tourism Marketing Marketing Tourism DestinationsCommunicating with the Tourist MarketOrganising and Managing Tourism Marketing Module 09: Health, Safety and Welfare In this module, we will cover the following topics: Health and Safety for Leisure Activities The Purpose of the Health and Safety Regulations The Basics of Health and Safety in an Organisation Health and Safety Law for Leisure Activities Health and Safety Law for Swimming Pools Health and Safety Law for Sports Club Organisers Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Travel Agency Owner Airline customer service agent Tourist information centre assistant Care escort Requirements The Leisure Management software does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path Travel agent (£18,000 to £27,000) Travel agency manager (£20,000 to £40,000) Tourist guide (£18,000 to £30,000) Tour manager (£16,000 to £30,000) Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Leisure Management at QLS Level 4 Hard copy certificate - £99 After successfully completing the Diploma in Leisure Management at QLS Level 4 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Overview The Advanced Diploma in Microsoft Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain certificates after completing the course. Enrol now for a limited-time discounted price. Like all the courses of The Teachers Training, this Advanced Diploma in Microsoft Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily. We don't just provide courses at The Teachers Training; we provide a rich learning experience. After purchasing a course from The Teachers Training, you get complete lifetime access with tutor support.  Our expert instructors are always available to answer all your questions and make your learning experience exquisite. After completing the Advanced Diploma in Microsoft Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV. What You Will Learn Get to know about relevant job opportunities. Format data labels, create excel values and build basic formulas in excel. Learn all the functions like SUM(), MIN(), MAX() etc Be able to insert images and shapes and customise icons Change layout views, convert spreadsheets into PDFs and print specific ranges of cells Learn how to group and filter pivot table data Skills You Will Gain Keyboard shortcuts Conditional formatting Flash Fill Filters/ AutoFilter Fast Track your Excel skills Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Assessment To successfully complete the course you must have to attend the MCQ assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Certification CPD Certification from The Teachers Training: Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Unleash the power of data with our Data Analysis in Excel course, where you'll journey through the realm of spreadsheet analysis and uncover the secrets hidden within your data. In today's data-driven world, the ability to navigate, interpret, and extract insights from data is a coveted skill. Whether you're a professional looking to enhance your analytical capabilities or a student aiming to excel in data-driven fields, this course empowers you to harness Excel's full potential for data analysis. From modifying worksheets to forecasting future trends, you'll master the art of data manipulation, visualization, and analysis with confidence and precision. Learning Outcomes Master the art of modifying Excel worksheets to suit your data analysis needs. Discover advanced data analysis techniques, including working with lists and lookup functions. Create compelling data visualizations using charts, PivotTables, and PivotCharts. Effortlessly manage multiple worksheets and workbooks, making data organization a breeze. Apply data forecasting techniques and automate workbook functionality, saving time and boosting productivity. Why choose this Data Analysis in Excel 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 Data Analysis in Excel course for? Professionals seeking to enhance their data analysis skills. Students preparing for careers in data-driven industries. Analysts, researchers, and data enthusiasts eager to upskill. Business professionals looking to make data-driven decisions. Anyone interested in harnessing Excel for powerful data analysis. Career path Data Analyst: £25,000 - £47,000 Business Analyst: £26,000 - £50,000 Financial Analyst: £26,000 - £56,000 Market Research Analyst: £24,000 - £40,000 Operations Analyst: £23,000 - £48,000 Business Intelligence Analyst: £27,000 - £56,000 Prerequisites This Data Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis in Excel 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 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 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:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 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 Recommended Materials Workbook - Data Analysis in Excel 00:00:00 Assignment Assignment - Data Analysis in Excel 00:00:00

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways. Learning Outcomes: Master the art of efficient worksheet modification and effective list management. Harness the power of data analysis tools to make informed decisions. Craft compelling visuals using charts, Sparklines, and data mapping techniques. Implement PivotTables and PivotCharts to dissect complex data sets effortlessly. Automate workbook functionalities for optimised and streamlined processes.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Data Analysis, Automating and Visualisation in Excel? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis, Automating and Visualisation in Excel 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 Who is this Data Analysis, Automating and Visualisation in Excel course for? Individuals looking to enhance their data visualisation and analysis prowess. Managers wanting a streamlined approach to handling large datasets. Academic researchers aiming to present their data in a more compelling format. Finance professionals seeking efficient ways to dissect and forecast financial data. Marketing strategists aiming to leverage data for improved decision-making. Career path Data Analyst: £30,000 - £50,000 per annum Financial Analyst: £35,000 - £55,000 per annum Market Research Analyst: £28,000 - £45,000 per annum Business Intelligence Analyst: £32,000 - £56,000 per annum Operations Analyst: £30,000 - £52,000 per annum Research Scientist (Data-oriented): £35,000 - £60,000 per annum Prerequisites This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel 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 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 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 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 Assignment Assignment - Data Analysis, Automating and Visualisation in Excel 00:00:00