2575 Accounting & Finance courses delivered Online

Accounting & Finance Accounting and finance assist businesses in measuring, monitoring, and planning their operations. This Accounting & Finance course has been designed to provide a thorough introduction to business Accounting & Finance as both an idea and a profession. This Accounting & Finance course will equip you with in-demand accounting and finance skills as well as the ability to complete practicable processes while working in an organisation. This could be tricky, especially if this is your first consignment in the accounting & finance sector. Our Accounting & Finance course provides a solid understanding of accounting and financial methods, concepts, and duties to properly prepare you for a career in the accounting finance sector. Courses: * Accounting & Finance * Anti-Money Laundering (AML) Training * Diploma in Forex Trading Accounting & Finance Detailed Course Curriculum of this Accounting & Finance Course: * Module 1: Essentials of Accounting and Finance * Module 2: Types of Cost Data and Cost Analysis * Module 3: Contribution Analysis * Module 4: Break-Even and Cost-Volume-Profit Analysis * Module 5: Relevant Cost and Making Short-Term Decisions * Module 6: Forecasting Cash Needs and Budgeting * Module 7: Cost Control and Variance Analysis * Module 8: Managing Financial Assets * Module 9: Managing Accounts Receivable and Credit * Module 10: Managing Inventory * Module 11: The Time Value of Money * Module 12: Capital Budgeting Decisions * Module 13: Improving Managerial Performance * Module 14: Sources of Short-Term Financing * Module 15: Considering Term Loans and Leasing * Module 16: Long-Term Debt and Equity Financing * Module 17: Accounting Conventions and Recording Financial Data Assessment Method After completing each module of the Accounting and Finance course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Accounting and Finance course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. WHO IS THIS COURSE FOR? Accounting & Finance This Accounting and Finance course is ideal for: * Candidates interested to start a career in accountancy * Business owners seeking to look after their own accounts * Existing accountancy workers in seeking higher positions or promotion * Accountancy workers with no formal qualifications * Anyone wishing to boost their career prospects. REQUIREMENTS Accounting & Finance There are no specific requirements for this Accounting and Finance Course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Accounting Finance Course must meet the following requirements: * Accounting Finance : Good command of the English language * Accounting Finance : Must be vivacious and self-driven * Minimum Basic computer knowledge * A minimum of 16 years of age is required CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included

8 CPD UK & IPHM Accredited Courses Bundle | Recognised Certificate | MCQ based Exam and Tutor Support Included | Lifetime Access | Instant Result | Interactive Video Training Are you looking to begin your xero accounting, finance and payroll management career or want to develop more advanced skills in xero accounting, finance and payroll management? Then this accounting, finance and payroll management course will set you up with a solid foundation to become a confident xero accountant, financial analyst and payroll manager and help you to develop your expertise in xero accounting, finance and payroll management. This bundle course has been designed with 8 CPD UK & IPHM accredited courses to provide the ultimate learning experience for our learners to further develop their expertise in their chosen field. Gain the essentials skills and knowledge you need to propel your career forward as a xero accountant, financial analyst and payroll manager. This Bundle Package Includes: The following courses of the accounting, finance and payroll management course will set you up with a solid foundation in the xero accounting, finance and payroll management industry and give you the essential skills you need to succeed! * Xero Basic Skills Course * Xero Advanced Course * Payroll Administrator Training * Business Accounting and Finance * Financial Analyst * Accounting Level 1 & 2 * Creative Accountant * Interview Skills for Accountants If you're interested in working as a xero accountant, financial analyst and payroll manager or want to learn more skills in xero accounting, finance and payroll management but unsure of where to start, then this accounting, finance and payroll management course will set you up with a solid foundation to become a confident xero accountant, financial analyst and payroll manager and develop more advanced skills. The accounting, finance and payroll management course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a xero accountant, financial analyst and payroll manager. The accounting, finance and payroll management courses bundle will help learners to fully enhance their skill set in team leading and active monitoring. By combining these related courses, learners will be equipped with a wide range of desirable skills to fast track their career. This comprehensive accounting, finance and payroll management course is the perfect way to kickstart your career in the field of xero accounting, finance and payroll management. This accounting, finance and payroll management course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. This accounting, finance and payroll management course supports learners of all skill levels. Whether you're an intermediate or advanced learner looking to brush up on your skills or a beginner wanting to start a new career or learn something new, our dedicated team of expert tutors are on hand to guide you through your learning every step of the way from enrolment to course completion. 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 accounting, finance and payroll management course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. WHY CHOOSE THIS ACCOUNTING, FINANCE AND PAYROLL MANAGEMENT COURSE: * 8 Courses Bundle in your desired field * Boost your skills in xero accounting, finance and payroll management * Endorsed by The Quality Licence Scheme * Accredited by The CPD UK and International Practitioners of Holistic Medicine (IPHM) * MCQ Based Exam & Industry Expert Support Included * Dual (CPD UK and IPHM) recognised accredited certificate in 1 course * Learn from industry experts * Lifetime Access * High-quality e-learning study materials * Self-paced, no fixed schedules * 24/7 customer support through email * Available to students anywhere in the world * Study in a user-friendly, advanced online learning platform WHY CHOOSE THIS ACCOUNTING, FINANCE AND PAYROLL MANAGEMENT COURSE: This comprehensive accounting, finance and payroll management bundle course are 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 xero accounting, finance and payroll management. ENTRY REQUIREMENT * There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. COURSE CURRICULUM Xero Basic Skills Course Xero Advanced Course Payroll Administrator Training Business Accounting and Finance Financial Analyst Accounting Level 1 & 2 Creative Accountant Interview Skills for Accountants RECOGNISED ACCREDITATION CPD CERTIFICATION SERVICE This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. QUALITY LICENCE SCHEME ENDORSED The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     CERTIFICATE OF ACHIEVEMENT ENDORSED CERTIFICATE FROM QUALITY LICENCE SCHEME   After successfully passing the MCQ exam you will be eligible to obtain the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organization for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65 and will be charged separately for each course. CERTIFICATE OF ACHIEVEMENT FROM LEAD ACADEMY After successfully passing the MCQ exam, you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. You/your employer can verify your certificate through our website. Certificate can be obtained in PDF version and will be charged separately for each course, at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQS IS CPD A RECOGNISED QUALIFICATION IN THE UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. ARE QLS COURSES RECOGNISED? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. WHEN WILL I RECEIVE MY CERTIFICATE? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. CAN I PAY BY INVOICE? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. CAN I PAY VIA INSTALMENT? Yes, you can pay via instalments at checkout. HOW TO TAKE ONLINE CLASSES FROM HOME? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. DOES AGE MATTER IN ONLINE LEARNING? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. WHEN I WILL GET THE LOGIN DETAILS FOR MY COURSE? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Accounting, Finance and Banking mega bundle. This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Accounting, Finance and Banking bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Accounting, Finance and Banking bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Accounting, Finance and Banking Bundle consists of the following premium courses: * Course 01: Accounting and Finance Certification Course * Course 02: Accounting Skills for New Supervisors * Course 03: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 * Course 04: Xero Accounting Diploma * Course 05: Managerial Accounting Masterclass * Course 06: Charity Accounting * Course 07: Key Account Management for Beginners * Course 08: Pensions Training * Course 09: Tax Accounting * Course 10: Improve your Financial Intelligence * Course 11: Fundamentals of Corporate Finance * Course 12: SAP S4HANA Controlling Course - Cost Center Accounting * Course 13: Capital Budgeting & Investment Decision Training * Course 14: Financial Analysis * Course 15: Accountancy Basics * Course 16: Accounting Interview Skills * Course 17: Banking and Finance Accounting Statements Financial Analysis * Course 18: Raise Money and Valuation for Business * Course 19: Investment Banking Training Course * Course 20: Managing Budgets * Course 21: Learn How to Finance and Grow Your Startup * Course 22: Understanding Financial Statements and Analysis * Course 23: Stock Market Investment * Course 24: Diploma in Forex Trading * Course 25: Financial Business Analysis * Course 26: Financial Advisor * Course 27: Finance and Cash management for Hospitality * Course 28: Anti-Money Laundering (AML) Training * Course 29: Microsoft Excel Complete Training * Course 30: Office Skills Moreover, this bundles include 10 career-focused courses: * Course 01: Career Development Plan Fundamentals * Course 02: CV Writing and Job Searching * Course 03: Interview Skills: Ace the Interview * Course 04: Video Job Interview for Job Seekers * Course 05: Create a Professional LinkedIn Profile * Course 06: Business English Perfection Course * Course 07: Networking Skills for Personal Success * Course 08: Boost Your Confidence and Self-Esteem * Course 09: Public Speaking Training * Course 10: Learn to Fight Procrastination Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Accounting, Finance and Banking mega bundle will help you to- * Quench your thirst for knowledge * Be up-to-date about the latest advancements * Achieve your dream career goal in this sector * Know the applicable rules and regulations needed for a professional in this area * Acquire some valuable knowledge related to Accounting, Finance and Banking to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: * PDF Certificate: Free for all 40 courses * Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 400 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? The Accounting, Finance and Banking bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. REQUIREMENTS The courses in this bundle has been designed to be fully compatible with tablets and smartphones. CAREER PATH This Accounting, Finance and Banking bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included CERTIFICATE OF COMPLETION Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Accounting and Finance Certification Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

COURSE OVERVIEW Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Accounting, Finance and Payroll Management course is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. LEARNING OUTCOMES * Discover the crucial steps to project success * Familiarise yourself with different types of projects * Identify the steps involved in project initiation, execution, monitoring and closing * Understand what makes a successful project management team * Learn about Earned Value Management (EVM) for project performance measurement  * Determine what is a change control process in project management WHO IS THE ACCOUNTING, FINANCE AND PAYROLL MANAGEMENT COURSE FOR? This Accounting, Finance and Payroll Management course is perfect for aspiring professionals in the relevant industry, such as people with careers in: * Project Manager * Project Executive * Project Administrator * Project Co-ordinator * Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. WHY CHOOSE THIS DIPLOMA IN ACCOUNTING, FINANCE AND PAYROLL MANAGEMENT COURSE? * 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 * The UK & internationally recognised accredited qualification * Access the course content on mobile, tablet, or desktop from anywhere, anytime * Excellent career advancement opportunities * 24/7 student support via email. ENTRY REQUIREMENT * This course is available to all learners of all academic backgrounds. * Learners should be aged 16 or over to undertake the qualification. * A good understanding of the English language, numeracy, and ICT are required to attend this course. ASSESSMENT   At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION * After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. * PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Section 01: Payroll System in the UK Payroll System in the UK 01:05:00 Section 02: Payroll Basics Payroll Basics 00:10:00 Section 03: Company Settings Company Settings 00:08:00 Section 04: Legislation Settings Legislation Settings 00:07:00 Section 05: Pension Scheme Basics Pension Scheme Basics 00:06:00 Section 06: Pay Elements Pay Elements 00:14:00 Section 07: The Processing Date The Processing Date 00:07:00 Section 08: Adding Existing Employees Adding Existing Employees 00:08:00 Section 09: Adding New Employees Adding New Employees 00:12:00 Section 10: Payroll Processing Basics Payroll Processing Basics 00:11:00 Section 11: Entering Payments Entering Payments 00:12:00 Section 12: Pre-Update Reports Pre-Update Reports 00:09:00 Section 13: Updating Records Updating Records 00:09:00 Section 14: e-Submissions Basics e-Submissions Basics 00:09:00 Section 15: Process Payroll (November) Process Payroll (November) 00:16:00 Section 16: Employee Records and Reports Employee Records and Reports 00:13:00 Section 17: Editing Employee Records Editing Employee Records 00:07:00 Section 18: Process Payroll (December) Process Payroll (December) 00:12:00 Section 19: Resetting Payments Resetting Payments 00:05:00 Section 20: Quick SSP Quick SSP 00:09:00 Section 21: An Employee Leaves An Employee Leaves 00:13:00 Section 22: Final Payroll Run Final Payroll Run 00:07:00 Section 23: Reports and Historical Data Reports and Historical Data 00:08:00 Section 24: Year-End Procedures Year-End Procedures 00:09:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

ICA ADVANCED CERTIFICATE IN BUSINESS COMPLIANCE The ICA Advanced Certificate in Business Compliance has been specifically designed for those working outside financial services. The need for guidance and training in meeting regulatory requirements extends to many industry sectors including oil and gas, aerospace, pharmaceuticals, telecoms, and manufacturing. This course will enable practitioners working in areas such as these to gain knowledge of the essentials of compliance in a practical business context as well as understand the roles of both the compliance function and compliance professionals. The Advanced Certificate will develop the compliance/risk management knowledge and skills of individuals and thereby help to enhance the overall reputation and performance of their firms. Benefits of studying with ICA: * Flexible learning solutions that are suited to you * Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role * Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria * Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification * The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Upon successful completion of this course, students will be awarded the ICA Advanced Certificate in Business Compliance and will be able to use the designation - Adv.Cert(Bus.Comp). This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. What will you learn? * The context of compliance and its origins * Building an effective control framework * The skills needed to be an effective compliance professional * Risk management, alert systems and investigations * Managing financial crime risk * Creating competitive advantage How will you be assessed? * Assessed by a one-hour, question-based exam and one research-based assignment

Performance and efficiency-enhancing Excel skills for everyday users.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 LESSON 1: BLENDING DATA FROM MULTIPLE SOURCES * Topic A: Blend Data * Topic B: Refine Blends to Visualize Key Information LESSON 2: JOINING DATA * Topic A: Create Joins * Topic B: Troubleshoot Joins * Topic C: Merge Data with Unions LESSON 3: ACCESSING DATA IN PDFS * Topic A: Connect to PDFs * Topic B: Clean Up and Organize PDF Data LESSON 4: REFINING VISUALIZATIONS WITH SETS AND PARAMETERS * Topic A: Create Sets * Topic B: Analyze Data with Sets * Topic C: Apply Parameters to Refine Visualizations * Topic D: Create Advanced Visualizations LESSON 5: ANALYZING DATA WITH CALCULATIONS * Topic A: Create Calculated Fields to Analyze Data * Topic B: Manipulate Data with Functions * Topic C: Analyze Data with Table Calculations LESSON 6: VISUALIZING DATA WITH ADVANCED CALCULATIONS * Topic A: Create Groups and Bins with Calculations * Topic B: Analyze Data with LOD Expressions LESSON 7: PERFORMING STATISTICAL ANALYSIS AND FORECASTING * Topic A: Perform Statistical Analysis * Topic B: Forecast Data Trends LESSON 8: CREATING GEOGRAPHIC VISUALIZATIONS * Topic A: Create Maps * Topic B: Customize Mapped Data LESSON 9: GETTING ANSWERS WITH ASK AND EXPLAIN * Topic A: Ask Data * Topic B: Explain Data ADDITIONAL COURSE DETAILS: Nexus Humans Tableau Desktop - Part 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Tableau Desktop - Part 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS * Introduction to Data Science * Create and Modify Tables * Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL * Visualize Data with Charts * Modify and Format Charts * Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS * Analyze Data with Formulas and Named Ranges * Analyze Data with Functions * Implement Data Validation, Forms, and Controls * Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES * Create a PivotTable * Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL * Visualize Data with PivotCharts * Filter Data Using Slicers and Timelines * Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL * Create Map Charts in Excel * Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS * Visualize Trendlines and Sparklines with Excel * Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA * Connect to Data with Queries * Clean and Combine Data * Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT * Install Power Pivot in Excel * Create Data Models with Power Pivot * Create Power Pivots * Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) * Plan a Report * Create a Report

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS * Working with Named Ranges * Link Cells Across Worksheets and Workbooks * Use 3D References to Calculate Across Worksheets * Consolidate Data USE FORMULA AUDITING AND ERROR CHECKING * Reveal Formulas * Trace Cell Precedents and Dependents * Locate Errors in Formulas * Watch and Evaluate Formulas REVIEWING AND PROTECTING WORKBOOKS * Control Data Entry via Data Validation * Protect Workbook Access * Protect Worksheets and Cell Content * Add and Edit Comments * Prepare a Workbook for Distribution * Modify Excel's Default Settings USING MACROS TO AUTOMATE WORKBOOK FUNCTIONALITY * Create Macros via Recording * Run Macros via Buttons and Shortcuts * Assign Macros to the Quick Access Toolbar and Ribbon * Assign Macros to Objects * View Macro Code FORECASTING AND ANALYSIS DATA * Use Conditional Formatting to Highlight, Sort and Filter Key Data * Advanced Conditional Formatting using Formulas * Create Sparklines to Visualise Data * Add Trendlines to Charts to Visualise and Forecast Trends * Use Data Tables and Scenarios to Project Potential Outcomes * Use Goal Seek to Calculate Outcomes * Forecast Data Trends Using Solver