4189 Accounting courses in Addlestone delivered Online

Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field.  The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand.  And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis 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 Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis 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 Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight 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 Analysis with SQL & Tableau for Data Analytics 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 Analysis 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 Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis 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 Analysis with SQL & Tableau for Data Analytics 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 Analysis 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 Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis 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 Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 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 Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics 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 Analysis 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

Are you ready to embark on an enlightening journey of wisdom with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Functional Skills IT with Microsoft Excel, IoT & ICT Training. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: IT Administration and Networking Course 2: Microsoft Excel Course Course 3: ICT: Information and Communication Technology Course 4: Start an IT Asset Department Course 5: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 6: Recruitment: IT Basics for IT Recruiters Course 7: Web Application Penetration Testing Course Course 8: Internet of Things Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle illuminate your path to wisdom. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Establish robust bases across each course nestled within the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Decipher intricate concepts through the articulate content of the Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Functional Skills IT with Microsoft Excel, IoT & ICT Training 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Functional Skills IT with Microsoft Excel, IoT & ICT Training journey and let knowledge guide you towards a brighter future. CPD 100 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 Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle. Career path Armed with the Functional Skills IT with Microsoft Excel, IoT & ICT Training 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, this 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

Asbestos, COSHH and Waste Management Diploma Master the complexities of COSHH regulations, asbestos awareness, and waste management. Elevate your expertise in COSHH risk assessments. Make informed decisions in waste management with this comprehensive diploma. Learning Outcomes: Identify types and usages of asbestos in line with COSHH. Evaluate the health risks of asbestos under COSHH guidelines. Conduct a COSHH risk assessment for hazardous materials. Implement effective waste management strategies, following COSHH. Analyze challenges in waste collection within a COSHH framework. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Asbestos, COSHH, and Waste Management Diploma: Asbestos Usage: Recognise common applications of asbestos and related COSHH regulations. Effects of Asbestos: Understand the health implications of asbestos exposure in line with COSHH guidelines. COSHH Awareness: Gain a robust understanding of COSHH fundamentals and its relevance to asbestos and waste management. COSHH Risk Assessment: Conduct in-depth COSHH risk assessments for substances hazardous to health, including asbestos. Understanding Waste Management: Acquire a nuanced understanding of waste management practices through a COSHH lens. Waste Collection and Challenges: Tackle the complexities and challenges of waste collection, governed by COSHH regulations.

🚀 Unlock Financial Mastery with 'Mastering Financial Stability - Part 1: Essential Principles' Online Course! 🌐   Are you ready to take control of your financial destiny? Dive into the world of financial stability and empowerment with our groundbreaking online course: 'Mastering Financial Stability - Part 1: Essential Principles.' This transformative program is designed to equip you with the fundamental knowledge and skills needed to navigate the complexities of personal finance confidently.   📚 Course Curriculum: Module 1: Introduction Lay the foundation for your financial journey by understanding the core principles of financial stability. Discover the mindset shift needed to embark on a path towards lasting financial success. Module 2: Justifying Your Financials For Best Results Learn how to analyze and justify your financial decisions for optimal results. Gain insights into making informed choices that align with your long-term goals. Module 3: Overcome Roadblocks to Financial Planning Identify and overcome common roadblocks that hinder effective financial planning. Develop strategies to navigate challenges and stay on course towards financial stability. Module 4: Create Your Financial Plan Practical guidance on crafting a personalized financial plan tailored to your unique circumstances. Understand the key components of a robust financial strategy and how to implement them effectively.   🎓 What Sets Our Course Apart?   ✨ Expert Guidance: Learn from industry experts with proven track records in financial planning and stability.   🤝 Interactive Learning: Engage with interactive modules, quizzes, and practical exercises that reinforce your understanding.   🔒 Lifetime Access: Once enrolled, you enjoy lifetime access to the course material, allowing you to revisit and reinforce your learning whenever needed.   💡 Real-world Application: Gain practical insights and actionable strategies that you can immediately apply to your financial life.   🌟 Why Wait? Start Your Journey to Financial Mastery Today! Whether you're a financial novice or looking to enhance your existing knowledge, 'Mastering Financial Stability - Part 1: Essential Principles' is your gateway to a secure and prosperous financial future.   🚨 Limited Time Offer: Enroll Now and Take Control of Your Financial Destiny! Don't miss this opportunity to revolutionize your relationship with money. Secure your spot now and embark on a transformative journey towards financial stability! Course Curriculum Introduction Financial Concepts Covered 00:00 Justifying Your Financials For Best Results Justifying Your Financials 00:00 Why Financials Matter 00:00 Keys to Success 00:00 Why Are Financials Important to Investors 00:00 Why Businesses Fail 00:00 Overcome Roadblocks to Financial Planning Financial Challenges of Entrepreneurs 00:00 Financial Resolve 00:00 Create Your Financial Plan Financial Projections Top-Down 00:00 Financial Projections Bottom-Up 00:00 Advantages and Disadvantages of Top-Down vs Bottom-Up 00:00 Revenue Models 00:00 Financial Statements 00:00 Make Your Financials Believable 00:00

🌟 Unleash Financial Freedom with Expense-Free Tactics Training! 🌟   Are you tired of feeling constrained by financial burdens? Ready to take control of your expenses and pave the way towards a life of financial freedom? Introducing the ultimate solution: Expense-Free Tactics Training!   🚀 Transform Your Financial Reality 🚀 Our comprehensive online course is designed to equip you with powerful strategies and actionable tactics that will revolutionize the way you manage your expenses. Say goodbye to financial stress and hello to a future filled with abundance and prosperity!   💡 What You'll Learn: Budget Mastery: Discover expert techniques to create and stick to a budget that works for your lifestyle, allowing you to save more and spend wisely. Smart Spending Habits: Learn the art of discerning between needs and wants, and unlock the secrets to making mindful purchasing decisions effortlessly. Debt Demolition: Gain valuable insights on tackling debt effectively, whether it's student loans, credit card debt, or other financial obligations. Generating Additional Income Streams: Explore various avenues for supplementing your income without investing significant capital, enabling you to grow your wealth. Long-Term Financial Planning: Build a solid financial future by understanding investments, retirement planning, and securing your financial legacy.   🎓 Why Choose Expense-Free Tactics Training? Expert Guidance: Led by seasoned financial experts with a proven track record in helping individuals achieve financial success. Flexible Learning: Access our course content at your own pace, anytime and anywhere, fitting seamlessly into your busy schedule. Practical Strategies: Practical, real-world tactics that you can implement immediately for tangible results. Supportive Community: Join a community of like-minded individuals, share experiences, and gain motivation and support along your financial journey.   🌟 Special Limited-Time Offer 🌟 Enroll now and take the first step toward a financially liberated future! As a limited-time offer, we're providing an exclusive discount for early birds! Don't let expenses hold you back from the life you desire. Seize this opportunity to transform your financial landscape with Expense-Free Tactics Training! Course Curriculum

🚀 Unlock Your Financial Future with 'Strategic Wealth Blueprint: A MasterClass in Financial Planning' 🚀   Are you tired of financial uncertainty? Do you dream of achieving true wealth and financial freedom? Look no further! Welcome to the 'Strategic Wealth Blueprint: A MasterClass in Financial Planning' - your key to unlocking the secrets of financial success.   🌟 What You'll Gain from This MasterClass: ✅ Strategic Wealth Building Techniques: Learn the proven strategies that successful individuals use to build and grow their wealth strategically. No more guessing - it's time to have a clear roadmap to financial success.   ✅ Personalized Financial Planning: Tailor your financial plan to fit your unique goals, aspirations, and lifestyle. This MasterClass empowers you with the knowledge and tools to create a plan that works for YOU.   ✅ Investment Mastery: Discover the art and science of smart investing. From stocks and real estate to alternative investments, you'll gain the insights needed to make informed decisions and maximize your returns.   ✅ Risk Management Strategies: Understand how to protect your wealth from unforeseen challenges. Learn how to assess and manage risks effectively, ensuring a secure and resilient financial future.   ✅ Passive Income Generation: Explore various avenues for creating passive income streams, allowing you to build wealth while you sleep. Say goodbye to the traditional 9-to-5 and hello to financial independence.   ✅ Tax Optimization Techniques: Navigate the complex world of taxes with confidence. Uncover legal strategies to minimize your tax liability and keep more of your hard-earned money in your pocket.   🎓 Why Choose 'Strategic Wealth Blueprint'? 🌐 Accessible Anytime, Anywhere: Learn at your own pace from the comfort of your home. Our online platform allows you to access the MasterClass content whenever and wherever it suits you.   👩‍💼 Expert Instructors: Benefit from the expertise of seasoned financial professionals who have a track record of success in wealth management. Our instructors are committed to guiding you on your journey to financial mastery.   🤝 Community Support: Join a vibrant community of like-minded individuals who share your aspirations. Exchange ideas, ask questions, and build valuable connections with fellow participants.   📈 Invest in Your Financial Future Today! Ready to take control of your financial destiny? Enroll in the 'Strategic Wealth Blueprint' MasterClass now and embark on a transformative journey toward financial success.   🔥 Don't miss out on this opportunity! Act now to secure your spot and start building the wealth you deserve. Your financial freedom awaits - let's make it happen together!     Course Curriculum Part 01- Introduction Financial Concepts Covered 00:00 Part 01- Justifying Your Financials For Best Results Justifying Your Financials 00:00 Why Financials Matter 00:00 Keys to Success 00:00 Why Are Financials Important to Investors 00:00 Why Businesses Fail 00:00 Part 01- Overcome Roadblocks to Financial Planning Financial Challenges of Entrepreneurs 00:00 Part 01- Create Your Financial Plan Financial Resolve 00:00 Part 01- Create Your Revenue Model Financial Projections Top-Down 00:00 Financial Projections Bottom-Up 00:00 Advantages and Disadvantages of Top-Down vs Bottom-Up 00:00 Revenue Models 00:00 Financial Statements 00:00 Make Your Financials Believable 00:00 Part 02- Revenue Worksheet Walk-Through Revenue Models Explained 00:00 Financial Worksheets Overview 00:00 The Revenue Worksheet 00:00 The Four Pricing Models 00:00 Part 02- Revenue Model Walk-Through When to Count Your Revenue 00:00 Your Revenue Model 00:00 The Revenue Worksheet - Walk-Through 00:00 The Revenue Worksheet Unit Based Model 00:00 The Revenue Worksheet Billing Based Model 00:00 The Revenue Worksheet The Subscription Recurring Revenue Model 00:00 Part 03- Your Staffing Model Your Staffing Model 00:00 Employee ROI Staffing Classifications 00:00 Part 03- Staffing Model Walk-Through Working with the Staffing Worksheet 00:00 Inputting Contractors 00:00 Employee Overhead 00:00 Part 03- Your Expense Model Expense Model Explained 00:00 Part 03- Expense Model Walk-Through Expense Worksheet Explained 00:00 Part 04- Income Statement Explained Income Statement and Cash Flow Considerations 00:00 Income Statement (P_L) Basics 00:00 Income Statement (P_L) Tells a Story about Your Business 00:00 Part 04- Income Statement Walk-Through Explained 5 Key Areas of an Income Statement (P_L) 00:00 Income Statement (P_L) Inputs 00:00 Part 04- Cash Flow Statement The Cash Flow Statement Worksheet 00:00 Modeling Styles Aggressive, Conservative, and Most Likely 00:00

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 31 lectures • 04:46:00 total length •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 •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 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •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 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •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

Level 2 Microsoft Office Essentials