FREE Certification: QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support | All-Inclusive Cost
Have you ever wondered how data speaks its complex language? Are you curious to unlock the code and understand its intricate dialects? Welcome to our course - Data Analysis for Data Analyst - a comprehensive theoretical exploration of data and its manifold intricacies. In this Data Analysis for Data Analyst course bundle, we will journey together through a diverse range of theories and concepts, from the fundamentals of data analysis to business data interpretations, MySQL database management, GDPR UK regulations, and Excel data analysis. All without touching a single tool! This expedition will empower you to comprehend data's multifaceted universe and the essential role it plays in various sectors. With us, data is not just numbers or facts but a powerful storyteller, a strategic guide, and a rulemaker. We offer you the keys to understanding this universal language, revealing how it shapes businesses, influences decisions, and regulates processes. Join us on this enlightening path as we explore the vast, intricate world of data. Are you ready to become fluent in the language of data? The seven CPD Accredited courses are: Course 01: Basic Data Analysis Course 02: Business Data Analysis Course 03: Learn MySQL from Scratch for Data Science and Analytics Course 04: Diploma in Data Analytics with Tableau Course 05: GDPR UK Training Course 06: Google Data Studio: Data Analytics Course 07: Excel Data Analysis Learning Outcomes Grasp the foundations of data analysis Understand the application of data in a business context Gain deep knowledge about MySQL for data analysis Acquire a working knowledge of GDPR in the UK Enhance your data interpretation skills through Excel Embrace a holistic understanding of the data landscape. Diploma in Data Analysis Fundamentals: Learn to unravel the layers of data and extract meaningful insights. Business Data Analysis: Decode the relationship between data and business strategies. Learn MySQL from Scratch for Data Science and Analytics: Delve deep into the database management system MySQL, its structure, and usage in data analytics. GDPR UK Training: Understand data protection regulations in the UK context. Excel Data Analysis: Uncover how Excel is more than just a spreadsheet application for data analysis. Theoretical Approach: Our course provides a theoretical exploration of data analytics, allowing you to understand data beyond its application. Comprehensive Bundle: This well-rounded course offers a unified approach to understanding data in diverse fields. So, are you ready to unlock the language of data? Embark on this journey today! CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring data analysts keen on understanding data theories. Professionals looking to delve deeper into data analysis. Business enthusiasts wanting to understand the influence of data on decision making. IT professionals seeking knowledge about data protection in the UK. Career path Data Analyst - £30K to £45K/year Business Analyst - £35K to £55K/year Data Science Specialist - £50K to £70K/year GDPR Compliance Officer - £35K to £55K/year Excel Analyst - £28K to £42K/year Database Administrator (MySQL focus) - £40K to £60K/year. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.
Overview With the ever-increasing demand for Data Analysis in Microsoft Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Data Analysis in Microsoft Excel may be. Learning about Data Analysis in Microsoft Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Data Analysis in Microsoft Excel . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Data Analysis in Microsoft Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Data Analysis in Microsoft Excel course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Data Analysis in Microsoft Excel course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Data Analysis in Microsoft Excel course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Data Analysis in Microsoft Excel , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Data Analysis in Microsoft Excel , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Data Analysis in Microsoft Excel , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Data Analysis in Microsoft Excel course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1_ Introduction to Microsoft Excel Introduction to Microsoft Excel 00:00 Module 2_ Data Visualization and Advanced Functions Data Visualization and Advanced Functions 00:00 Module 3_ PivotTables and Regression PivotTables and Regression 00:00 Module 4_ Time Series Analysis in Excel Time Series Analysis in Excel 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
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
Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course will set you up with a solid foundation to become a confident accountant and finance assistant and develop more advanced skills. Lead Academy Scholarship Programme | Enrol Today & Save £347 This comprehensive Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course is the perfect way to kickstart your career in the field of accounting & finance. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. How Will I Benefit? Boost your career in accounting & finance Deepen your knowledge and skills in your chosen field just in hours not years! Study a course that is easy to follow. Save money and time by studying at your convenient time Have access to a tutor whenever you are in need So, what are you thinking about! Start getting the benefits by enrolling today! Why Choose Lead Academy: Lifetime Access High-quality e-learning study materials Learn the most in-demand skills Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world No hidden fee Study in a user-friendly, advanced online learning platform Who is this course for? This comprehensive Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of accounting & finance. Entry Requirement There are no academic entry requirements for this Business Accounting and Finance course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This Business Finance course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Business Accounting and Finance What is Business finance. What is Business finance. Why Businesses Fail Why Businesses Fail The Principles of Business Finance Part 1 The Principles of Business Finance Part 1 The Principles of Business Finance Part 2 The Principles of Business Finance Part 2 The Balance Sheet The Balance Sheet The Income Statement The Income Statement The Cashflow Statement The Cashflow Statement A Business Finance Exercise A Business Finance Exercise Financial Performance Indicators Financial Performance Indicators Investment Analysis Investment Analysis Investment Analysis Exercise Investment Analysis Exercise Key Learning Points in Business Finance Key Learning Points in Business Finance Business Performance Management Assessment Social Media Marketing Masterclass 2019 Introduction General Tips & Tricks Series SEO (Search Engine Optimization) YouTube Google Analytics Email Marketing Linkedln Facebook Instagram Mobile App
Overview Join our Business Data Analysis course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Business Data Analysis course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Business Data Analysis course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You Will Learn Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Business Data Analysis. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Business Data Analysis course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Business Data Analysis is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. 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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Business Data Analysis 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 course. Career path The certification and skills you get from this Business Data Analysis Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Business Data Analysis Module 01: Introduction to Business Analysis 00:17:00 Module 2: Business Environment 00:19:00 Module 3: Business Processes 00:47:00 Module 4: Business Analysis Planning and Monitoring 00:30:00 Module 5: Strategic Analysis and Product Scope 00:31:00 Module 6: Solution Evaluation 00:27:00 Module 7: Investigation Techniques 00:48:00 Module 8: Ratio Analysis 00:29:00 Module 9: Stakeholder Analysis and Management 00:25:00 Module 10: Process Improvement with Gap Analysis 00:28:00 Module 11: Documenting and Managing Requirements 00:31:00 Module 12: Business Development and Succession Planning 00:27:00 Module 13: Planning & Forecasting Operations 00:23:00 Module 14: Business Writing Skills 00:39:00 Mock Exam Mock Exam - Business Data Analysis 00:20:00 Final Exam
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Computer Programming and Data Analysis and Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Computer Programming and Data Analysis and Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Computer Programming and Data Analysis and Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Computer Programming and Data Analysis and Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01: C++ Development: The Complete Coding Guide Course 02: Basic C# Coding Course 03: Computer Vision: C++ and OpenCV with GPU support Course 04: Python Basic Programming for Absolute Beginners Course 05: Python Programming for Everybody Course 06: Intermediate Python Coding Course 07: Quick Data Science Approach from Scratch Course 08: Root Cause Analysis Course 09: Google Data Studio: Data Analytics Course 10: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 11: Business Intelligence and Data Mining Masterclass Course 12: Level 2 Microsoft Office Essentials Course 13: SQL NoSQL Big Data and Hadoop Course 14: Introduction to Data Analysis Course 15: Data Science and Visualisation with Machine Learning Course 16: Data Analytics with Tableau Course 17: R Programming for Data Science Course 18: Complete Google Analytics Course Course 19: JavaScript Promises Course 20: JavaScript Foundations for Everyone Course 21: Javascript for Data Structures Course 22: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 23: Microsoft SQL Server Development for Everyone Course 24: SQL Programming Masterclass Course 25: Level-3 Machine Learning Course with Python Course 26: Learn to Use Python for Spatial Analysis in ArcGIS Course 27: Microsoft Azure Machine Learning Course 28: Javascript Programming for Beginners Course 29: Basic Asynchronous JavaScript Course 30: JavaScript Functions 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made Computer Programming and Data Analysis and Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Computer Programming and Data Analysis and Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Computer Programming and Data Analysis and Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Computer Programming and Data Analysis and Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00