3371 Courses

Immerse yourself in the dynamic world of trading and financing with the course 'Trading and Financing: Candlestick Pattern.' Unveil the art of reading candlestick charts and interpreting patterns to make informed trading decisions. From understanding the anatomy of candlesticks to mastering patterns like Doji, Engulfing, Morning and Evening Star, and more, you'll gain essential insights into supply, demand, support, and resistance. Equip yourself with the knowledge needed to navigate the trading platform confidently and embark on a journey towards financial empowerment. Learning Outcomes: Comprehend the significance of candlestick charts in trading analysis. Analyze the anatomy of candlesticks and their interpretation in the context of price movement. Recognize supply and demand dynamics influencing market trends. Identify key support and resistance levels to inform trading strategies. Master various candlestick patterns, including Doji, Engulfing, and Morning and Evening Star. Explore continuation and reversal candlestick patterns for trading decisions. Understand the concept of candlestick gaps and their implications. Gain practical experience on a trading platform through interactive sessions. Why buy this Trading and Financing: Candlestick Pattern? 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 Trading and Financing: Candlestick Pattern 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 Trading and Financing: Candlestick Pattern does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring traders seeking to enhance their technical analysis skills. Finance enthusiasts interested in understanding trading patterns and strategies. Professionals looking to diversify their investment knowledge and strategies. Anyone intrigued by financial markets and wanting to make informed trading choices. Prerequisites This Trading and Financing: Candlestick Pattern 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 Day Trader or Swing Trader - Potential earnings range widely based on skill and capital invested. Financial Analyst or Investment Advisor - Median salary of $85,660 per year. Fund Manager or Portfolio Manager - Median salary of $87,600 per year. Risk Analyst or Derivatives Trader - Median salary of $83,726 per year. Financial Blogger or Educator - Income potential varies based on content creation and audience engagement. Course Curriculum Trading and Financing: Candlestick Pattern Course Promo 00:02:00 Module 01: Candlestick Charts 00:05:00 Module 02: Anatomy of Candlesticks 00:04:00 Module 03: Supply and Demand 00:09:00 Module 04: Support and Resistance 00:12:00 Module 05: Standard Doji Candlesticks 00:05:00 Module 06: Dragonfly Doji 00:03:00 Module 07: Gravestone Doji 00:06:00 Module 08: Reversal Candlestick Patterns- Engulfing Candles 00:08:00 Module 09: Morning and Evening Star Patterns 00:09:00 Module 10: Hammer and Hanging Man Candles 00:07:00 Module 11: Continuation Candlestick Pattern: Mat Hold 00:05:00 Module 12: Continuation Candlestick Pattern: 3 Method Pattern 00:06:00 Module 13: Candlestick Gaps 00:03:00 Module 14: Gap Close Reversal Strategy 00:05:00 Module 15: Trading Platform 00:30:00 Module 16: Trading Practise 00:07:00 Assignment Assignment - Trading and Financing: Candlestick Pattern 00:00:00

Step into the realm of strategic financial expertise with 'Management Accounting.' This course offers a unique portal into the world of financial strategizing, equipping you with the acumen to drive businesses towards fiscal excellence. Your educational journey commences with a deep dive into the essence of management accounting, laying a robust groundwork for your ascent in the financial domain. You are not just learning about numbers; you are becoming the architect of financial success, understanding how every figure can influence a company's trajectory. Advance through the course to unravel the complexities of manufacturing costs, financial statement analysis, and various costing systems. This voyage through the modules like activity-based management and cost behaviour analysis transforms you from a learner to a financial maestro. Gain mastery over budgeting, from planning to control, and grasp the nuances of standard costs and the balanced scorecard. By the course's conclusion, you will emerge as a professional capable of wielding financial data to sculpt business strategies, an invaluable asset in the dynamic corporate world. Learning Outcomes Attain a comprehensive understanding of management accounting principles. Analyse manufacturing costs and decode complex financial statements. Implement diverse costing methods, including activity-based systems. Execute effective budget planning and maintain rigorous financial control. Apply standard cost methods and balanced scorecard for business strategy. Why choose this Management Accounting 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 Management Accounting course for? Individuals aspiring to a career in management accounting. Business executives seeking financial decision-making skills. Entrepreneurs requiring knowledge of financial strategy. Accounting students aiming to broaden their expertise. Professionals in finance roles desiring advancement. Career path Management Accountant - £28,000 to £50,000 Finance Manager - £31,000 to £56,000 Corporate Treasurer - £35,000 to £68,000 Internal Auditor - £29,000 to £54,000 Investment Analyst - £32,000 to £58,000 Business Consultant - £33,000 to £60,000 Prerequisites This Management Accounting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Management Accounting 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 Module 01 : Introduction to Management Account Introduction to Management Account 00:04:00 Module 02: Manufacturing Costs and Financial Statements Manufacturing Costs and Financial Statements 00:15:00 Module 03: Traditional Costing System - Job and Process Traditional Costing System - Job and Process 00:12:00 Module 04: Activity Based Costing System Activity Based Costing System 00:14:00 Module 05: Activity Based Management Activity Based Management 00:05:00 Module 06: Cost Behaviour and the Contribution Margin Cost Behaviour and the Contribution Margin 00:22:00 Module 07: Cost Volume Profit Cost Volume Profit 00:12:00 Module 08: Cost Volume Profit Analysis Cost Volume Profit Analysis 00:18:00 Module 09: Incremental Analysis in Decision Making Incremental Analysis in Decision Making 00:15:00 Module 10: Budget Planning Budget Planning 00:15:00 Module 11: Budget Control And Responsibility Accounting Responsibility Accounting Lecture 00:18:00 Budget Control Lecture 00:15:00 Module 12: Control Using Standard Costs and the Balanced Scorecard Control Using Standard Costs and the Balanced Scorecard 00:14:00 Downloadable Resources Resources 00:00:00 Assignment Assignment - Management Accounting 00:00:00

Discover the vital link between finance and climate change in the Accountant's Guide to Climate Change. In today's rapidly evolving business landscape, understanding and addressing climate change are imperative for accountants. This course delves into crucial aspects, from emerging business trends to sustainable investing and governmental regulations. The course guides accountants through the complexities of climate impacts, providing an actionable plan. The main problem it solves is the lack of expertise in integrating climate considerations into financial practices. By completing this course, professionals gain the skills to navigate the evolving environmental landscape, ensuring financial resilience and responsible practices. By enrolling, participants benefit from a comprehensive understanding of climate-related challenges. This knowledge empowers accountants to contribute to a sustainable future, aligning financial strategies with global goals. The course offers practical insights into the circular and zero-carbon economies, sustainable investing, and technological solutions. It is a transformative learning experience, equipping accountants to proactively address climate issues in their professional roles. By enrolling, you're not just learning; you're gaining the tools to make your financial decisions climate-smart. Join us to make a positive impact on the planet while enhancing your career prospects. Enroll now and explore the financial dimensions of environmental responsibility. Learning Outcomes Understand current climate change business trends impacting financial landscapes. Analyse the principles of the circular and zero-carbon economies. Evaluate the role of sustainable investing in financial decision-making. Recognise the influence of people, values, and technology in climate strategies. Interpret government policies and regulations affecting financial practices. Develop strategies for climate adaptation and mitigation in financial contexts. Create an accountant's action plan for addressing climate-related challenges. Appraise the perspectives of accounting institutes on climate change responsibilities. Apply knowledge to address diverse impacts, including on habitats and populations. Summarise the key takeaways in closing remarks for effective implementation. Why choose this Accountant's Guide to Climate Change course? Accountants seeking to integrate climate considerations into financial practices. Finance professionals aiming to understand and navigate sustainable investing. Business leaders committed to aligning financial strategies with environmental goals. Graduates entering the finance sector interested in climate-resilient practices. Environmental enthusiasts with an interest in the financial aspects of climate change. Who is this Accountant's Guide to Climate Change course for? 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. Career Path Climate-conscious Accountant: £40,000 - £60,000 per annum. Sustainability Analyst: £35,000 - £50,000 per annum. Environmental Financial Consultant: £45,000 - £70,000 per annum. Corporate Social Responsibility Manager: £50,000 - £75,000 per annum. Financial Policy Advisor on Climate Change: £55,000 - £80,000 per annum. Prerequisites No prior qualifications or experience are necessary to enrol in the Accountant's Guide to Climate Change. This professionally crafted course is compatible with PCs, Macs, tablets, and smartphones, allowing flexible learning anytime, anywhere, provided there is a reliable internet connection. Certification  Upon completion of the Accountant's Guide to Climate Change course materials, a written assignment test is available for £4.99. Successfully passing the test enables you to obtain a downloadable PDF certificate, with the option to order an original hard copy certificate for an additional £8. Course Curriculum Accountant's Guide To Climate Change Module 01: Introduction and Agenda 00:05:00 Module 02: Climate Change Business Trends 00:02:00 Module 03: The Circular Economy 00:03:00 Module 04: The Zero Carbon Economy 00:03:00 Module 05: Sustainable Investing 00:04:00 Module 06: The Power of People and Values 00:04:00 Module 07: Business as a Force for Change 00:05:00 Module 08: New Technological Solutions 00:04:00 Module 09: Government Policy and Regulation 00:04:00 Module 10: Climate Adaptation 00:03:00 Module 11: People and Habitats on the Move 00:02:00 Module 12: Other Impacts of Climate Change 00:11:00 Module 13: The Accountant's Action Plan 00:07:00 Module 14: What the Accounting Institutes are saying 00:03:00 Module 15: The Accountant's Guide to Climate Change: Closing Remarks 00:02:00

Embark on a transformative journey with 'Demystifying Depreciation Accounting: Financial Insights'. This course unravels the intricate world of depreciation accounting, offering a comprehensive understanding from its foundational concepts to its real-world applications. Dive deep into the depreciation model, explore enlightening case studies, and stay ahead with insights on emerging trends and future developments. By the end of this course, you'll possess a robust knowledge of depreciation reporting and compliance, positioning you at the forefront of financial expertise. Learning Outcomes Understand the fundamental principles of depreciation accounting. Analyse and interpret the depreciation model in-depth. Evaluate real-world scenarios through case studies. Master the nuances of depreciation reporting and compliance. Stay updated with the latest trends and anticipated shifts in depreciation accounting. Why buy this Demystifying Depreciation Accounting: Financial Insights? 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 Demystifying Depreciation Accounting: Financial Insights for? Finance and accounting students seeking a deeper understanding of depreciation. Business owners aiming to enhance their financial literacy. Accountants looking to refresh or expand their knowledge. Financial analysts aiming to strengthen their analytical skills. Professionals transitioning into finance or accounting roles. Career path Financial Accountant: £40,000 - £55,000 Management Accountant: £45,000 - £60,000 Financial Analyst: £35,000 - £50,000 Finance Manager: £50,000 - £70,000 Compliance Officer: £30,000 - £45,000 Financial Consultant: £45,000 - £65,000 Prerequisites This Demystifying Depreciation Accounting: Financial Insights does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 Module 1: Introduction to Depreciation Accounting Introduction to Depreciation Accounting 00:20:00 Module 2: Accounting for Depreciation Accounting for Depreciation 00:22:00 Module 3: Deep Dive into the Depreciation Model Deep Dive into the Depreciation Model 00:14:00 Module 4: Case Studies and Real-World Applications Case Studies and Real-World Applications 00:11:00 Module 5: Depreciation Reporting and Compliance Depreciation Reporting and Compliance 00:13:00 Module 6: Emerging Trends and Future Developments Emerging Trends and Future Developments 00:18:00

Overview This comprehensive course on Excel spreadsheet 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 spreadsheet 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 spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet 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 2 sections • 14 lectures • 01:29:00 total length •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 - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 2 sections • 23 lectures • 01:56:00 total length •Excel promo: 00:01:00 •Getting the most of the course: 00:01:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:06:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00

Overview This comprehensive course on New Functions in Microsoft Excel 2021 will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This New Functions in Microsoft Excel 2021 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 New Functions in Microsoft Excel 2021. It is available to all students, of all academic backgrounds. Requirements Our New Functions in Microsoft Excel 2021 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 1 sections • 10 lectures • 01:11:00 total length •Introduction and Agenda: 00:07:00 •RANDARRAY: 00:04:00 •UNIQUE: 00:05:00 •SEQUENCE: 00:04:00 •SORT and SORTBY: 00:09:00 •SORT A Practical Example: 00:04:00 •FILTER: 00:07:00 •FILTER A Practical Example: 00:08:00 •Other Useful New Functions: 00:15:00 •Using the New Functions in Reports: 00:08:00

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 2 sections • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Overview This comprehensive course on Diploma in Excel Vlookup Xlookup Match and Index will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Diploma in Excel Vlookup Xlookup Match and Index 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 Diploma in Excel Vlookup Xlookup Match and Index. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Excel Vlookup Xlookup Match and Index 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 2 sections • 8 lectures • 00:46:00 total length •1.1 Excel vlookup: 00:08:00 •1.2 Excel xlookup: 00:06:00 •1.3 Excel vlookup: 00:08:00 •1.4 Excel vlookup: 00:03:00 •1.5 Excel vlookup: 00:11:00 •1.6 Excel vlookup: 00:05:00 •1.7 Excel vlookup: 00:05:00 •Assignment - Diploma in Excel Vlookup Xlookup Match and Index: 00:00:00

Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. 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 Microsoft Excel Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Level 3 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 21 sections • 73 lectures • 10:39:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •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 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •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 •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:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08: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 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00