689 Courses in Cardiff delivered On Demand

Are you ready to embark on an enlightening journey of wisdom with the Data Analytics & Database Development Using SQL bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analytics & Database Development Using SQL. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Data Analytics Course 2: SQL Database Basics for Everyone Course 3: SQL for Data Science, Data Analytics and Data Visualization Course 4: Microsoft Access Databases Forms and Reports Course 5: Microsoft SQL Server Development for Everyone! Course 6: Python Programming from Scratch with My SQL Database Course 7: Google Data Studio: Data Analytics Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analytics & Database Development Using SQL bundle illuminate your path to wisdom. The Data Analytics & Database Development Using SQL bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analytics & Database Development Using SQL package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analytics & Database Development Using SQL bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analytics & Database Development Using SQL community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analytics & Database Development Using SQL Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analytics & Database Development Using SQL bundle. Establish robust bases across each course nestled within the Data Analytics & Database Development Using SQL bundle. Decipher intricate concepts through the articulate content of the Data Analytics & Database Development Using SQL bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analytics & Database Development Using SQL bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analytics & Database Development Using SQL bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analytics & Database Development Using SQL bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analytics & Database Development Using SQL bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analytics & Database Development Using SQL bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analytics & Database Development Using SQL journey and let knowledge guide you towards a brighter future. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analytics & Database Development Using SQL Bundle. Career path Armed with the Data Analytics & Database Development Using SQL bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analytics & Database Development Using SQL bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Business Management: Level 7 Business Management Overseeing all aspects of a business! - enrol our Level 7 Business Management course to be an expert in this field. Do you want to join the business management team? Do you want to launch your own company? If so, then this Level 7 Business Management course is right for you!The goal of this Level 7 Business Management course is to equip students with fundamental business and management knowledge. This Level 7 Business Management course is divided into a variety of in-depth courses to give you the most convenient and thorough learning experience possible. You can learn about the functions, rules, and policies of contemporary organisations through this Level 7 Business Management course. You will have a thorough understanding of project management, planning and forecasting operations, performance management, negotiation strategies, and human resource management by the end of this Level 7 Business Management course. To get into the business field, enrol our Level 7 Business Management course as soon as possible to make a career as a business expert! Main Course: Level 7 Business Management Free Courses are including with this Business Management: Business Management Course Along with The Business Management: Business Management Course, We Offer a free Level 5 Diploma in Business Analysis Course Along with The Business Management: Business Management Course, We Offer a free Business Law Course Along with The Business Management: Business Management Course, We Offer a free Level 3 Business Administration Special Offers of this Business Management: Business Management Course This Business Management: Business Management Course includes a FREE PDF Certificate. Lifetime access to this Business Management: Business Management Course Instant access to this Business Management: Business Management Course Get FREE Tutor Support to this Business Management: Business Management Course Business Management: Level 7 Business Management By enrolling in a business management course, you can advance both your technical proficiency and your comprehension of business management. In the business management course, you will study risk and operational management. In addition, project management, succession planning, and other subjects are included in business management. You can learn about a range of strategic approaches and business management planning with this business management course. In order to help you make informed management decisions, this comprehensive business management course also explains numerous issues and their solutions. Who is this course for? Business Management: Level 7 Business Management For those who are considering entering or are already working in this field, the Business Management: Level 7 Business Management course is recommended. Requirements Business Management: Level 7 Business Management To enrol in this Business Management: Business Management Course, students must fulfil the following requirements. To join in our Business Management: Business Management Course, you must have a strong command of the English language. To successfully complete our Business Management: Business Management Course, you must be vivacious and self driven. To complete our Business Management: Business Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Business Management: Business Management Course. Career path Business Management: Level 7 Business Management After finishing this Business Management: Level 7 Business Management course, you can investigate well-liked and in-demand occupations in the area of Business Management.

Accounting and Finance: Accounting and Finance Course Online Would you like to know exactly how businesses track, analyse, and schedule their operations? The goal of this Accounting and Finance: Accounting and Finance Course is to provide students with a thorough introduction to company finance as a concept and a career. This Accounting and Finance: Accounting and Finance Course will give you a solid understanding of accounting and financial processes. Also, this Level 5 Accounting and Finance course teaches all the concepts, and responsibilities of an employee. Through the help of this Level 5 Accounting and Finance course, you can prepare yourself for a career in the accounting and finance industry. This Level 5 Accounting and Finance course is helpful in understanding money value, inventory management and other related issues. Join our Accounting and Finance: Accounting and Finance Course now. This Level 5 Accounting and Finance course is ideal for you if you have a strong desire to work as an account assistant or financial manager; otherwise, there are alternative options. Main Course: Level 5 Accounting and Finance Course Free Courses are including with this Accounting and Finance: Accounting and Finance Course Along with The Accounting and Finance Course, We Offer a free Level 5 Diploma in Business Analysis Course Along with The Accounting and Finance Course, We Offer a free HR and Payroll Management Course Special Offers of this Accounting and Finance: Accounting and Finance Course This Accounting and Finance: Accounting and Finance Course includes a FREE PDF Certificate. Lifetime access to this Accounting and Finance: Accounting and Finance Course Instant access to this Accounting and Finance: Accounting and Finance Course Get FREE Tutor Support to this Accounting and Finance: Accounting and Finance Course Accounting and Finance: Accounting and Finance Course Online The daily inflow and outflow of funds from a company or organization is the focus of accounting. The management of assets and liabilities as well as the planning of future expansion are referred to as finance. Accounting and finance support businesses in measuring, tracking, and organizing their activities. Accounting and finance support businesses in measuring, tracking, and organizing their activities. The goal of this accounting and finance course is to give students a thorough introduction to business accounting and finance as a concept and a career. Who is this course for? Accounting and Finance: Accounting and Finance Course Online This Accounting and Finance: Accounting and Finance Course is for anyone who wants to advance their professional life. Requirements Accounting and Finance: Accounting and Finance Course Online To enrol in this Accounting and Finance: Accounting and Finance Course, students must fulfil the following requirements. To join in our Accounting and Finance: Accounting and Finance Course, you must have a strong command of the English language. To successfully complete our Accounting and Finance: Accounting and Finance Course, you must be vivacious and self driven. To complete our Accounting and Finance: Accounting and Finance Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Accounting and Finance Course. Career path Accounting and Finance: Accounting and Finance Course Online After completing this Accounting and Finance: Accounting and Finance Course, you may be able to pursue a variety of promising career opportunities, such as: Account manager Finance manager Administrative Specialist and many more.

Level 4 Diploma Course in Travel & Tourism Course Online Even in the wake of intensifying economic and political pressures on a global basis, the travel and tourism industry continues to grow, expand, and diversify. The Level 4 Diploma Course in Travel & Tourism is designed to provide students with a thorough understanding of this industry. More countries than ever before rely on tourism to fuel both local and national economies, and the industry is always in need of talented, dedicated, and resourceful professionals. As the majority of modern business sectors falter, global travel remains unaffected and grows in importance. With so many countries and regions around the world relying on travel and tourism as key economic drivers, those with the required backgrounds and talents are in high demand. Travel and tourism is a thriving industry, and those who want to travel are always in need of assistance when it comes to vacation and travel plans. If you enjoy traveling and providing excellent customer service, this Level 2 Certificate in Travel and Tourism course is just what you need. This Level 2 Certificate in Travel and Tourism course aims to provide you in-depth knowledge of Travel and Tourism, putting you on the right track to starting a career in Travel and Tourism. After completing this Level 2 Certificate in Travel and Tourism course, you will have a solid understanding of working in the travel and tourism industry, and you may even be able to start your own Travel and Tourism business. Why choose this Level 2 Certificate in Travel and Tourism Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Level 4 Diploma Course in Travel & Tourism Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Level 4 Diploma Course in Travel & Tourism Course.. Main Course: Level 4 Diploma Course in Travel & Tourism Course Free Courses Course 01: Level 5 Diploma in Business Analysis Course 02: Level 3 Business Administration [ Note: Free PDF certificate will provide as soon as completing the Level 4 Diploma Course in Travel & Tourism Course] Level 4 Diploma Course in Travel & Tourism Course Online This Level 4 Diploma Course in Travel & Tourism Course consists of 04 modules. Course Curriculum of Level 4 Diploma Course in Travel & Tourism Course Module 01: Customer Service in Travel and Tourism Module 02: The UK Travel and Tourism Industry Module 03: Travel and Tourism Destinations Module 04: Travel Agency Operations Certification of Level 4 Diploma Course in Travel & Tourism Course After completing the Level 2 Certificate in Travel and Tourism course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Level 4 Diploma Course in Travel & Tourism Course After completing Level 2 Certificate in Travel and Tourism Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Level 4 Diploma Course in Travel & Tourism Course online This Level 2 Certificate in Travel and Tourism course is suitable for anyone who is looking to work in the travel industry. Requirements Level 4 Diploma Course in Travel & Tourism Course online To enrol in this Level 4 Diploma Course in Travel & Tourism Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 4 Diploma Course in Travel & Tourism Course. Be energetic and self-motivated to complete our Level 4 Diploma Course in Travel & Tourism Course. Basic computer Skill is required to complete our Level 4 Diploma Course in Travel & Tourism Course. If you want to enrol in our Level 4 Diploma Course in Travel & Tourism Course, you must be at least 15 years old. Career path Level 4 Diploma Course in Travel & Tourism Course online After completing this Level 2 Certificate in Travel and Tourism course, you may be able to pursue a variety of promising career opportunities. This includes: Travel agent Holiday rep Sales coordinator Customer care representative

Business Management: Business Management Course Online Do you aspire to be a part of the corporate management team? Do you want to start your own business? If yes, then this course is for you! This Business Management: Business Management Course is divided into several in-depth modules to provide you with the most convenient and rich learning experience possible. The qualification allows students to learn new skills and gain new knowledge through a variety of topics. You will learn strategies for building strong work teams, delegating work, managing business risks, change, workplace conflict, and customer service. Learning Objectives You will be able to do the following at the end of the Business Management: Business Management Course: Learn everything there is to know about business management and why it is so important. Familiarize yourself with all of the terms used in the field of business management. Promote organizational direction, learn and apply leadership and management theory. Develop a variety of important skills, such as communication, negotiation, and dispute resolution. Learn about project management, risk management, supply chain management, and human resource management. Determine the personal and technical abilities needed to achieve strategic goals. Create a solid personal development strategy. Learn how to run a company strategically. Examine the company laws and regulations in the United Kingdom. Create an action plan for your business. This Business Management: Business Management Course is designed to provide students with essential knowledge about business and management, as well as their role in modern organisations. By the end of this course, you will have a solid understanding of project management, planning and forecasting operations, performance management, negotiation techniques and human resource management. Why choose this Business Management: Business Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Business Management: Business Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Business Management: Business Management Course. Courses Including with this Business Management: Business Management Course Course 01: Level 7 Business Management Course 02: Level 5 Diploma in Business Analysis Course 03: Level 2 Diploma in Business Administration Course 04: Level 3 Business Administration Others benefit Included with Business Management: Business Management Course Free 4 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Business Management: Business Management Course] Business Management: Business Management Course Online This Business Management: Business Management Course consists of 13 modules. Course Curriculum of Level 7 Business Management Module 01: Introduction Module 02: Financial Resource and Investment Management Module 03: Succession Planning Module 04: Risk Management Module 05: Supply Chain Management Module 06: Human Resource Management Module 07: Leadership and Management Module 08: Change Management Module 09: Conflict Management Module 10: Project Management Module 11: Communication Techniques for Business Management Module 12: Entrepreneurship and Small Business Management Module 13: UK Business Law Assessment Method of Business Management Course After completing Business Management: Business Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Business Management Course After completing the Business Management: Business Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Business Management: Business Management Course Online Anyone who aspires to the top of the corporate ladder in any business or workplace setting should take this Business Management: Business Management Course. Those who are self-employed or own small businesses should consider taking this Business Management: Business Management Course. Professionals in the field of business, program managers, facility managers, and program administrators should enrol. Students and recent graduates will also benefit from this. Requirements Business Management: Business Management Course Online To enrol in this Business Management: Business Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Management: Business Management Course. Be energetic and self-motivated to complete our Business Management: Business Management Course. Basic computer Skill is required to complete our Business Management: Business Management Course. If you want to enrol in our Business Management: Business Management Course, you must be at least 15 years old. Career path Business Management: Business Management Course Online Enrolling on this Business Management: Business Management Course can lead you to the following career paths: Business Manager Assistant CEO Asset Management Management Analyst Business Management Support Analyst Business Management Assistants Sales & Business Management Trainee

Business Administration: Level 2 Diploma in Business Administration Course Would you like to improve your business acumen? This Level 2 Diploma in Business Administration course will help you comprehend all business-related themes. Constructive criticism, support for colleagues, conflict resolution techniques, collaboration principles and many more topics you can get in our Level 2 Diploma in Business Administration! You will be responsible for organising and controlling your workload, priorities, and both personal and professional performance during the Level 2 Diploma in Business Administration course. This Level 2 Diploma in Business Administration course also covers how to use time management techniques and technologies to support the organisation in achieving its operational objectives. This Level 2 Diploma in Business Administration course includes business communication, administrative service concepts, and management of personal performance and growth. The Level 2 Diploma in Business Administration training also covers managing and supplying stationery and supplies, as well as touch typing notes into text. Enrol in the Level 2 Diploma in Business Administration course to get knowledge about managing the hiring and selection procedure as well as helping to create and manage an information system. Learning Outcomes of Level 2 Diploma in Business Administration After completing this Level 2 Diploma in Business Administration course, the learner will be able to: Know how to communicate in a business environment from Level 2 Diploma in Business Administration. This Level 2 Diploma in Business Administration course helps to gain a solid understanding of the principles of business. The Level 2 Diploma in Business Administration course explains document production and information management. Gain extensive skills in developing working relationships with colleagues through the Level 2 Diploma in Business Administration course. Gain an in-depth understanding of employer organisations with the help of the Level 2 Diploma in Business Administration. This Level 2 Diploma in Business Administration course can enhance communication and performance skills in a business environment. You can manage personal and professional development and know how to work safely in a business environment via the level 2 Diploma in Business Administration course. Main Course: Level 2 Diploma in Business Administration Course Free Courses are including with this Business Administration: Level 2 Diploma in Business Administration Course Level 2 Diploma in Business Administration Course, We Offer a free Level 5 Diploma in Business Analysis Course Level 2 Diploma in Business Administration Course, We Offer a free Level 3 Business Administration Course Special Offers of this Business Administration: Level 2 Diploma in Business Administration Course This Level 2 Diploma in Business Administration Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Diploma in Business Administration Course Instant access to this Level 2 Diploma in Business Administration Course Get FREE Tutor Support to this Level 2 Diploma in Business Administration Course Business Administration: Level 2 Diploma in Business Administration Course The core ideas and a range of administrative skills needed to operate in a business are taught to students enrolled in our Business Administration course. In addition to covering the role of administration work with both large and small corporations, the Business Administration: Business Administration Course teaches a variety of admin systems and how to manage a team in a business setting. Who is this course for? Business Administration: Level 2 Diploma in Business Administration Course This Level 2 Diploma in Business Administration course is suitable for learners who work in business administration and want to improve their knowledge and skills. Special Note: Our Level 2 Diploma in Business Administration Course is not a regulated course. If you prefer to get qualified, you can look at the following options: Level 2 Diploma in Business Administration Course Level 2 Diploma in Business Administration (RQF) Requirements Business Administration: Level 2 Diploma in Business Administration Course To enrol in this Level 2 Diploma in Business Administration Course, students must fulfil the following requirements. To join in our Level 2 Diploma in Business Administration Course, you must have a strong command of the English language. To successfully complete our Level 2 Diploma in Business Administration Course, you must be vivacious and self driven. To complete our Level 2 Diploma in Business Administration Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Business Administration Course Career path Business Administration: Level 2 Diploma in Business Administration Course This Level 2 Diploma in Business Administration qualification will increase your chances in the business field.

Learn essential techniques for successful trading & investing through Technical Analysis Masterclass. Explore key indicators, chart patterns, and strategies to decipher market trends effectively.

Unlock the power of data with our comprehensive course on Business and Data Analysis with SQL. Learn essential SQL skills to extract meaningful insights, make data-driven decisions, and drive business success. Whether you're a beginner or looking to enhance your expertise, our course empowers you with the tools and knowledge needed to excel in the dynamic world of data analysis. Enroll now to master SQL for business intelligence and elevate your analytical skills to new heights.

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? 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 Sales Analysis in Excel 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? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales 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. Career path Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum 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 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11: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 Welcome to the Course 00:03:00 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 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 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