Overview This comprehensive course on Banking and Finance Accounting Statements Financial Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Banking and Finance Accounting Statements Financial Analysis 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 Banking and Finance Accounting Statements Financial Analysis. It is available to all students, of all academic backgrounds. Requirements Our Banking and Finance Accounting Statements Financial Analysis 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 11 sections • 54 lectures • 04:53:00 total length •Introduction to Financial Statements and Analysis: 00:05:00 •Why are Financial Statements Important: 00:07:00 •What do we mean by Financial Accounting?: 00:04:00 •Accounting Standards and why they are important: 00:06:00 •The Concepts and Principles Underlying Accounting: 00:06:00 •Single Entry vs Double Entry Book Keeping: 00:08:00 •Understanding The Accounting Equation: 00:06:00 •The Accounting Cycle: 00:05:00 •Financial Statements: 00:07:00 •Section Introduction - Understanding Financial Statements: 00:02:00 •Overview of Financial Statements: 00:03:00 •GAAP: Accruals and Cash Accounting: 00:06:00 •Income Statement or Profit and Loss Account: 00:08:00 •Introduction to the Balance Sheet: 00:11:00 •Introduction to the Cash Flow Statement: 00:06:00 •Cash Flow Metrics Explained: 00:09:00 •Case Study- Apple Financial Statements: 00:04:00 •What is Working Capital: 00:03:00 •What is the Working Capital Cycle?: 00:05:00 •Why is working Capital Management important: 00:05:00 •Working Capital Analysis: 00:05:00 •Working Capital Ratios: 00:07:00 •Working Capital Policies: 00:05:00 •Working Capital Summary: 00:03:00 •Section Introduction: Strategic Financial Analysis: 00:01:00 •What is Financial Analysis?: 00:11:00 •Measures of Profitability Financial Analysis: 00:04:00 •Balance Sheet Ratio Analysis: 00:12:00 •Cash Flow Statement Analysis: 00:05:00 •Valuation Ratios: 00:04:00 •Section Introduction: Financial Analysis - Case Study and Assignment: 00:01:00 •Case Study Assignments Apple Inc Financial Analysis: 00:06:00 •Apple Inc Financial Analysis - Solution: 00:03:00 •Discussion of Measurements of Growth Analysis: 00:05:00 •Discussion of Measures of Profitability Analysis: 00:07:00 •Discussion of Trading Performance Analysis: 00:03:00 •Discussion of Working Capital (Liquidity and Efficiency) Analysis: 00:12:00 •What do we mean by Corporate Finance?: 00:06:00 •Financial Ratios in Corporate Finance: 00:03:00 •Liquidity Ratios in Corporate Finance: 00:08:00 •Operational Risk Ratios in Corporate Finance: 00:08:00 •Profitability Ratios in Corporate Finance: 00:08:00 •Efficiency Ratios in Corporate Finance: 00:07:00 •Why is modelling so critical: 00:03:00 •Three Models You Will Need: 00:08:00 •Understanding The Integrated Financial Statements Model: 00:06:00 •The Integrated Financial Statements Model Example: 00:07:00 •Key Tips to Modelling the Integrated Financial Statements Model: 00:02:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Understanding the Discounted Cash Flow Formula: 00:06:00 •Understanding the Merger Model: 00:08:00 •Course Summary and Wrap Up: 00:03:00 •Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00
Overview This comprehensive course on Financial Ratio Analysis for Business Decisions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Ratio Analysis for Business Decisions 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 Financial Ratio Analysis for Business Decisions. It is available to all students, of all academic backgrounds. Requirements Our Financial Ratio Analysis for Business Decisions 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 6 sections • 22 lectures • 02:42:00 total length •Financial Statement Analysis Objectives: 00:02:00 •Financial Analysis Methods in Brief: 00:10:00 •Ratio Analysis: 00:05:00 •Gross Profit: 00:10:00 •Net Profit: 00:05:00 •ClassRoom Discussion for some other expenses: 00:07:00 •Use of Profitability Ratio to understand Competitive advantage and business model: 00:08:00 •Return on Assets and Fixed Assets: 00:11:00 •Return on Capital Employed: 00:08:00 •Case Study Analysis of three telecom companies: 00:15:00 •Cautions for using return ratios on face value: 00:04:00 •Ratios which help to understand how efficiently assets are used: 00:17:00 •How do we measure utilisation of assets not recorded in the Balance Sheet: 00:09:00 •Liquidity Ratio to understand Risk inherent in companies: 00:05:00 •Long Term Liquidity Ratios: 00:06:00 •Financial Analysis Measure meant to understand efficiency in other operations: 00:04:00 •Summarise - Ratios use for operational analysis: 00:03:00 •Dupont Analysis to understand opportunities in optimising return on equity: 00:04:00 •Detecting Manipulation in accounts - Fake Sales: 00:11:00 •Detecting Manipulation - Wrong Depreciation and others: 00:06:00 •Pricing Decisions: 00:07:00 •How to make Capex Decisions: 00:05:00
Overview This comprehensive course on Financial Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Analysis comes with accredited certification 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 Financial Analysis. It is available to all students, of all academic backgrounds. Requirements Our Financial Analysis 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 6 sections • 22 lectures • 02:42:00 total length •Financial Statement Analysis Objectives: 00:02:00 •Financial Analysis Methods in Brief: 00:10:00 •Ratio Analysis: 00:05:00 •Gross Profit Operating Margin Ratios: 00:10:00 •Net Profit Expense Control Ratios: 00:05:00 •ClassRoom Discussion for some other expenses: 00:07:00 •Use of Profitability Ratio to Understand Competitive advantage and Business Models: 00:08:00 •Return on Assets and FIxed Assets: 00:11:00 •Return on Capital Employed: 00:08:00 •Case Study Analysis of three telecom companies: 00:15:00 •Cautions for using return ratios on face value: 00:04:00 •Ratios which help to understand how efficiently assets are used: 00:17:00 •How we measure utlisation of assets not recorded in Balance Sheet: 00:09:00 •Liquidity Ratio to understand Risk inherent in companies: 00:05:00 •Long Term Liquidity Ratios: 00:06:00 •Financial Analysis Measure meant to understand efficiency in other operations: 00:04:00 •Summarise - Ratios use for operational analysis: 00:03:00 •Dupont Analysis to understand opportunities in optimising return on equity: 00:04:00 •Detecting Manipulation in accounts - Fake Sales: 00:11:00 •Detecting Manipulation - Wrong Depreciation and others: 00:06:00 •Pricing Decisions: 00:07:00 •How to make Capex Decisions: 00:05:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Computer Simulation of Realistic Mathematical Models Training Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Computer Simulation of Realistic Mathematical Models Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Computer Simulation of Realistic Mathematical Models Training Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Computer Simulation of Realistic Mathematical Models Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Computer Simulation of Realistic Mathematical Models Training? 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 Computer Simulation of Realistic Mathematical Models Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Computer Simulation of Realistic Mathematical Models Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Computer Simulation of Realistic Mathematical Models Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Computer Simulation of Realistic Mathematical Models Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Computer Simulation of Realistic Mathematical Models Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:04:00 Section 02: Prey-Predator Model Pure prey-predator model 00:06:00 Equilibrium points and their stability 00:05:00 Equilibrium points in the prey-predator model 00:03:00 Section 03: Constructing the Model with Open-Source Software Introduction to Scilab 00:03:00 Constructing the model with Scilab part 1 00:09:00 Constructing the model with Scilab part 2 00:18:00 How parameters affect the output of the model 00:09:00 Influence of fishing on the model 00:11:00 Addition of logistic terms to the model 00:13:00 Section 04: Evolution of Epidemics Model on the evolution of epidemics 00:16:00 Assignment Assignment - Computer Simulation of Realistic Mathematical Models Training 00:00:00
Overview This comprehensive course on Financial Statement Analysis Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Statement Analysis Masterclass 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 Financial Statement Analysis Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Financial Statement Analysis Masterclass 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 20 sections • 20 lectures • 03:24:00 total length •Introduction: 00:02:00 •Why Analyse Financial Statements?: 00:10:00 •GAAP Rules: 00:10:00 •Correct Timing: 00:15:00 •Earnings Management: 00:11:00 •Balance Sheet: 00:11:00 •Balance Sheet Part-2: 00:11:00 •Balance Sheet Part-3: 00:07:00 •Statement of Cash Flow: 00:07:00 •Time Series: 00:11:00 •Ratios- Introduction: 00:16:00 •Applying Ratios: 00:19:00 •Valuation: 00:14:00 •Credits: 00:07:00 •Contracts@: 00:10:00 •Executive Compensation: 00:12:00 •Lease: 00:08:00 •Owners' Equity: 00:07:00 •Earnings Per Share: 00:16:00 •Assignment - Financial Statement Analysis Masterclass: 00:00:00
Overview This comprehensive course on Capital Budgeting & Investment Decision Rules will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Capital Budgeting & Investment Decision Rules comes with accredited certification, 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 Capital Budgeting & Investment Decision Rules. It is available to all students, of all academic backgrounds. Requirements Our Capital Budgeting & Investment Decision Rules 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 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 6 sections • 15 lectures • 01:27:00 total length •Preview: 00:01:00 •Basics of Time Value of Money: 00:10:00 •Concepts of Compounding, Discounting, Present Values: 00:09:00 •NPV Method Meaning and Decision Rules: 00:07:00 •Use of NPV with an Example and Practical Life Limitation of NPV Method: 00:06:00 •NPV Profile of the Project to Understand Sensitivity: 00:04:00 •Payback Period Meaning and Calculations: 00:02:00 •Drawback of Payback Period Method: 00:03:00 •IRR, Meaning and Method of Calculation with Limitation: 00:07:00 •Example of Demonstrate NPV and IRR Calculation and Inconsistent Result: 00:04:00 •Case of Multiple IRR and MRR as an Attempt to Fix the Problem: 00:08:00 •How to Choose between Mutually Exclusive Project: 00:11:00 •Choosing Project with Different Life: 00:06:00 •Choosing Project in Budget Constraints: 00:05:00 •Final Summary: 00:04:00
Overview Marginal costing is an integral part of business management, accounting and finance. Acquiring solid skills in marginal costing can open doors of career opportunities for you. You can develop a strong foundation in marginal costing with our exclusive online Marginal Costing Course. The course is divided into 7 highly informative modules. Through these modules, you will be introduced to the costing methods. The course will help you understand the fundamentals of marginal costing and learn the cost-volume-profit analysis process. Furthermore, you will learn to use marginal costing in decision-making and profit planning. Along with valuable skill sets, this course will also provide you with a recognised certificate of achievement. This certificate will boost your career in the business and finance industries. Join now! Course Preview Learning Outcomes Enhance your knowledge of costing methods Learn the basic principles of marginal costing Understand the process of cost-volume-profit analysis Know how to use margin costing in decision-making Build your expertise in profit planning Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Marginal Costing CVP Analysis Profit Planning Decision-Making Who Should Take this Marginal Costing Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Marginal Costing Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Pathâ This exclusive Marginal Costing Course will equip you with effective skills and abilities and help you explore career paths such as Financial Analyst Cost Accountant Budget Analyst Operations Manager Module 01: Introduction to Costing Methods Introduction to Costing Methods 00:12:00 Module 02: Understanding Marginal Costing Understanding Marginal Costing 00:12:00 Module 03: Cost Classification Cost Classification 00:11:00 Module 4: Cost-Volume-Profit (CVP) Analysis Cost-Volume-Profit (CVP) Analysis 00:15:00 Module 05: Decision-Making Using Marginal Costing Decision-Making Using Marginal Costing 00:16:00 Module 06: Contribution Margin Ratio and Profit Planning Contribution Margin Ratio and Profit Planning 00:14:00 Module 07: Limitations and Criticisms of Marginal Costing Limitations and Criticisms of Marginal Costing 00:13:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Make Business Plans: Forecasting and Budgeting Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Make Business Plans: Forecasting and Budgeting Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Make Business Plans: Forecasting and Budgeting Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Make Business Plans: Forecasting and Budgeting Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Make Business Plans: Forecasting and Budgeting? 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 Make Business Plans: Forecasting and Budgeting there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Make Business Plans: Forecasting and Budgeting course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Make Business Plans: Forecasting and Budgeting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Make Business Plans: Forecasting and Budgeting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Make Business Plans: Forecasting and Budgeting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction & Fundamentals Why Budget and Forecasts 00:11:00 Is budget planning a paper exercise 00:05:00 Operational and Financial Budget 00:07:00 Detail Budget Requirement Components - Revenue Budgets 00:05:00 Components - Cost Budget 00:11:00 Qualitative Aspects 00:05:00 Process of making budget Process of Budgeting - Logical Steps 00:09:00 Revenue Budget - What Information we need to make revenue budgets 00:08:00 The example we used in class to demonstrate a broad process in budget and planning 00:17:00 Cost Budget Process - Link from revenue and operational plan 00:05:00 Cost Budget Process - Other aspects 00:10:00
This comprehensive Microsoft Excel 2016 course is designed to take you from a complete beginner to an advanced Excel user, equipping you with essential skills for data analysis, financial modeling, and business productivity. Whether you're managing budgets, analyzing sales data, or automating repetitive tasks, this course provides hands-on training with real-world examples. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of Achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas. CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment At the end of the course, there will be an MCQ assessment. To pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Who Is This Course For? This course is ideal for beginners with no prior Excel knowledge, office professionals looking to enhance efficiency, students preparing for careers in finance/data, and entrepreneurs managing business data. It’s also valuable for accountants, analysts, and administrative staff seeking to upgrade their skills. Whether for academic, professional, or personal use, this course provides step-by-step training for all levels. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you expand your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Entry Clerk – £18K–£24K Administrative Assistant – £20K–£28K Financial Analyst – £30K–£50K Accountant – £25K–£45K Business Intelligence Analyst – £35K–£60K Excel Trainer / Consultant – £30K–£55K Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources