3212 Accounting & Finance courses in Cardiff delivered Online

Are you looking to elevate your professional skills to new heights? Introducing our Accountancy at QLS Level 5 Diploma, a QLS-endorsed course bundle that sets a new standard in online education. This prestigious endorsement by the Quality Licence Scheme (QLS) is a testament to the exceptional quality and rigour of our course content. The bundle comprises 11 CPD-accredited courses, each meticulously designed to meet the highest standards of learning. This endorsement not only highlights the excellence of our courses but also assures that your learning journey is recognised and valued in the professional world. The purpose of Accountancy at QLS Level 5 Diploma is to provide learners with a comprehensive, skill-enriching experience that caters to a variety of professional needs. Each course within the bundle is crafted to not only impart essential knowledge but also to enhance practical skills, ensuring that learners are well-equipped to excel in their respective fields. From gaining cutting-edge industry insights to mastering critical thinking and problem-solving techniques, this bundle is an amalgamation of learning experiences that are both enriching and empowering. Moreover, Accountancy at QLS Level 5 Diploma goes beyond just online learning. Upon completion of the bundle, learners will receive a free QLS Endorsed Hardcopy Certificate & 11 CPD Accredited PDF Certificate, a tangible acknowledgement of their dedication and hard work. This certificate serves as a powerful tool in showcasing your newly acquired skills and knowledge to potential employers. So, why wait? Embark on this transformative learning journey today and unlock your potential with Accountancy at QLS Level 5 Diploma! This premium bundle comprises the following courses, QLS Endorsed Course: Course 01: Accountancy at QLS Level 5 Diploma CPD QS Accredited Courses: Course 02: Managerial Accounting Masterclass Course 03: Sage 50 Accounts Course 04: Tax Accounting Diploma Course 05: Financial Accounting Course 06: Introduction to VAT Course 07: Xero Accounting and Bookkeeping Course 08: Charity Accounting Course 09: Applied Accounting Course 10: Theory of Constraints, Throughput Accounting and Lean Accounting Course 11: QuickBooks Online Bookkeeping Diploma Course 12: Microsoft Excel & Accounting Training Learning Outcomes Upon completion of the bundle, you will be able to: Acquire industry-relevant skills and up-to-date knowledge. Enhance critical thinking and problem-solving abilities. Gain a competitive edge in the job market with QLS-endorsed certification. Develop a comprehensive understanding of Accountancy. Master practical application of theoretical concepts. Improve career prospects with CPD-accredited courses. The Accountancy at QLS Level 5 Diploma offers an unparalleled learning experience endorsed by the Quality Licence Scheme (QLS). This endorsement underlines the quality and depth of the courses, ensuring that your learning is recognised globally. The bundle includes 11 CPD-accredited courses, each meticulously designed to cater to your professional development needs. Whether you're looking to gain new skills, enhance existing ones, or pursue a complete career change, this bundle provides the tools and knowledge necessary to achieve your goals. The Quality Licence Scheme (QLS) endorsement further elevates your professional credibility, signalling to potential employers your commitment to excellence and continuous learning. The benefits of this course are manifold - from enhancing your resume with a QLS-endorsed certification to developing skills directly applicable to your job, positioning you for promotions, higher salary brackets, and a broader range of career opportunities. Embark on a journey of professional transformation with Accountancy at QLS Level 5 Diploma today and seize the opportunity to stand out in your career. Enrol in Accountancy now and take the first step towards unlocking a world of potential and possibilities. Don't miss out on this chance to redefine your professional trajectory! Certificate of Achievement: QLS-endorsed courses are designed to provide learners with the skills and knowledge they need to succeed in their chosen field. The Quality Licence Scheme is a distinguished and respected accreditation in the UK, denoting exceptional quality and excellence. It carries significant weight among industry professionals and recruiters. Upon completion, learners will receive a Free Premium QLS Endorsed Hard Copy Certificate titled 'Accountancy at QLS Level 5 Diploma' & 11 Free CPD Accredited PDF Certificates. These certificates serve to validate the completion of the course, the level achieved, and the QLS endorsement. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Accountancy at QLS Level 5 Diploma bundle is ideal for: Professionals seeking to enhance their skills and knowledge. Individuals aiming for career advancement or transition. Those seeking CPD-accredited certification for professional growth. Learners desiring a QLS-endorsed comprehensive learning experience. Requirements You are cordially invited to enroll in this bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Upon completing the Accountancy at QLS Level 5 Diploma course bundle, each offering promising prospects and competitive salary ranges. Whether you aspire to climb the corporate ladder in a managerial role, delve into the dynamic world of marketing, explore the intricacies of finance, or excel in the ever-evolving field of technology. Certificates CPD Quality Standard Certificate Digital certificate - Included Free 11 CPD Accredited PDF Certificates. QLS Endorsed Certificate Hard copy certificate - Included

Learning Outcomes Get the basics of accounting for bookkeeping Understand the manual, computerised system of bookkeeping Deepen your understanding of ledgers, trail balance and coding Know the basics of PNL accounting and balance sheet management Enrich your knowledge of debits, credits, budgeting, and financial analysis as well as identify high and low-risk of companies Description For effective bookkeeping, you have to establish a solid understanding of accounting principles. The Accounting Basics For Bookkeepers course is an excellent place to work on your accounting skills. It will give you the opportunity to get quality training without even stepping out of the house. In this course, you will get an overall understanding of the key aspects of accounting in bookkeeping. Besides providing the fundamental of accounting this course will also teach you manual and computerised bookkeeping systems. Alongside that, it will also show you the procedure of ledgers, trail balance and coding as well in this course. Lastly, the course will talk about PNL accounting, balance sheet management further in the course. So, if you are keen to acquire about all these mentioned topics then enrol in our course and start learning. It will also offer you a CPD- certificate to boost your resume. So, hurry up and join now! Certificate of Achievement 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 After completing this course, you will be provided with some assessment questions. To pass that assessment you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career path The knowledge and skills in accounting basics will help you hunt jobs for the mentioned positions: Auditor Tax Accountant Accountant Manager Financial Advisor Financial Executive

Step into the world of efficient data management and analysis with the 'Microsoft Excel Complete Bundle' course. Discover the power of Excel through comprehensive modules designed to transform your understanding of spreadsheets. From basic functions to advanced data analysis techniques, this course is your gateway to mastering Excel like never before. Whether you're a novice eager to grasp the fundamentals or a seasoned user aiming to refine your skills, this course promises to elevate your proficiency in Excel to new heights. Unlock the secrets of data manipulation and visualization as you embark on a journey that blends creativity with precision. Imagine creating complex formulas effortlessly and presenting data insights with clarity and impact. With engaging tutorials and practical exercises, you'll not only learn the tools but also gain the confidence to apply them in real-world scenarios. Excel becomes more than a tool; it becomes your strategic partner in decision-making and problem-solving. Join us and embark on a transformative learning experience that empowers you to excel in Excel. Why buy this Microsoft Excel? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 'Microsoft Excel Complete Bundle' 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 £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Microsoft Excel 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 skills. Prerequisites This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Microsoft Excel was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Administrative Assistant: £22,000 - £28,000 Annually Financial Analyst: £30,000 - £45,000 Annually Project Manager: £35,000 - £50,000 Annually Data Analyst: £25,000 - £40,000 Annually Accountant: £25,000 - £40,000 Annually Business Consultant: £30,000 - £60,000 Annually    

Are you looking to enhance your Internal Audit skills? If yes, then you have come to the right place. Our comprehensive course on Internal Audit will assist you in producing the best possible outcome by mastering the Internal Audit skills. The Internal Audit course is for those who want to be successful. In the Internal Audit course, you will learn the essential knowledge needed to become well versed in Internal Audit. Our Internal Audit course starts with the basics of Internal Audit and gradually progresses towards advanced topics. Therefore, each lesson of this Internal Audit course is intuitive and easy to understand. Why would you choose the Internal Audit course from Compliance Central: Lifetime access to Internal Audit course materials Full tutor support is available from Monday to Friday with the Internal Audit course Learn Internal Audit skills at your own pace from the comfort of your home Gain a complete understanding of Internal Audit course Accessible, informative Internal Audit learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Internal Audit Study Internal Audit in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Internal Audit Course Internal Audit Curriculum Breakdown of the Internal Audit Course Course Outline: Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Auditor CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Internal Audit course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Internal Audit. It is also great for professionals who are already working in Internal Audit and want to get promoted at work. Requirements To enrol in this Internal Audit course, all you need is a basic understanding of the English Language and an internet connection. Career path Internal Auditor: £35,000 to £65,000 per year Risk Manager: £45,000 to £80,000 per year Compliance Officer: £30,000 to £60,000 per year Financial Analyst: £35,000 to £70,000 per year Audit Manager: £55,000 to £95,000 per year Fraud Investigator: £40,000 to £75,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

As an aspiring Internal Auditor, it's time to take your career to the next level with our comprehensive Internal Auditor online training course. This Internal Auditor course is designed to equip you with the necessary knowledge and tools to perform internal audits effectively, improve organisational efficiency, and increase profitability. This Internal Auditor course will guide you through the key principles of internal auditing, including risk management, internal control, and auditing standards. You'll learn how to develop effective audit programmes, gather valuable evidence, and communicate your findings to management. This self-paced Internal Auditor online training course offers you the flexibility to learn at your own pace and on your own schedule. Upon completion of the Internal Auditor course, you will receive a certificate of completion that showcases your newly acquired skills and knowledge. Don't miss this opportunity to excel in your career. Enrol today in our Internal Auditor online training course and take the first step towards achieving your career goals. Internal Auditor Course Basic Learning Outcomes: Discover the five fundamental components of consent. The Functions of the Compliance Management System (CMS). What and why do compliance audits? Ethics and compliance ideas. Risk and its various forms. The basics of risk management. Method for managing risks. Key Highlights for Internal Auditor Course: CPD AccreditedInternal Auditor Course Lifetime Internal Auditor course access & update without any limits Unlimited Internal Auditor course retake exam and premium support for life 100% online and self-paced Internal Auditor course Easy Accessibility to the Internal Auditor course course materials- anytime, anywhere 100% learning satisfaction guarantee Curriculum Breakdown of the Internal Auditor Course: Module 01: Introduction to Compliance Module 02: Five basic elements of compliance Module 03: Compliance Management System (CMS) Module 04: Compliance Audit Module 05: Compliance and Ethics Module 06: Risk and Types of Risk Module 07: Introduction to Risk Management Module 08: Risk Management Process Certification CPD Accredited (CPD QS) Certificate PDF & Hardcopy certificates are available CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Requirements Learners seeking to enrol for the Internal Auditor Course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing this course, you can explore trendy and in-demand jobs related to Internal Auditor, such as- Internal Auditor Internal Audit Manager Internal Auditors-Financial Services Internal Audit Operational Risk Explore each of the roles available and how you can start your career in Internal Auditor course. Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - Included After successfully completing this Internal Auditor course, you can get a digital and a hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Overview This comprehensive course on Introduction to VAT will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Introduction to VAT 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 Introduction to VAT. It is available to all students, of all academic backgrounds. Requirements Our Introduction to VAT 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 • 07:22:00 total length •Module 01: Understanding VAT: 00:36:00 •Module 02: VAT Terminology and Calculation: 00:35:00 •Module 03: VAT Taxable Persons: 00:46:00 •Module 04: VAT Registration: 00:40:00 •Module 05: VAT Rates: 00:32:00 •Module 06: Invoicing and Records: 00:27:00 •Module 07: VAT Application in Goods, Services and Vehicles: 00:31:00 •Module 08: Supply: 00:43:00 •Module 09: The VAT Return: 00:25:00 •Module 10: Tips on VAT Compliance: 00:21:00 •Module 11: VAT Exemptions and Zero-Rated VAT: 00:39:00 •Module 12: Miscellaneous VAT Issues and Penalties: 00:41:00 •Module 13: Making Tax Digital: 00:26:00 •Assignment - Introduction to VAT: 00:00:00

Overview It is estimated that between 2-5% of global GDP, or $800 billion to $2 trillion, is laundered annually. The Fraud Management & Anti Money Laundering Awareness Complete Diploma delves deep into this intricate world, elucidating key legislation, responsibilities, and risk management strategies essential for the modern professional.Commencing with a comprehensive exploration in "Introduction to Money Laundering", the course navigates the intricacies of the "Proceeds of Crime Act 2002". Grasp the historical and ongoing evolutions in "Development of Anti-Money Laundering Regulation", understand the pivotal role of the "Money Laundering Reporting Office", and discern the essentials of a "Risk-based Approach". As the curriculum advances, learners will acquaint themselves with "Customer Due Diligence" nuances, the imperatives of "Record Keeping", indicators of "Suspicious Conduct and Transactions", and conclude with the all-important "Awareness and Training" module.Enrol today and elevate your potential in the dynamic realm of Fraud Management & Anti Money Laundering! 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 Fraud Management & Anti Money Laundering Awareness Complete Diploma. It is available to all students, of all academic backgrounds. Requirements Our Fraud Management & Anti Money Laundering Awareness Complete Diploma 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 9 sections • 9 lectures • 02:57:00 total length •Module 01: Introduction to Money Laundering: 00:15:00 •Module 02: Proceeds of Crime Act 2002: 00:18:00 •Module 03: Development of Anti-Money Laundering Regulation: 00:24:00 •Module 04: Responsibility of the Money Laundering Reporting Office: 00:19:00 •Module 05: Risk-based Approach: 00:22:00 •Module 06: Customer Due Diligence: 00:22:00 •Module 07: Record Keeping: 00:19:00 •Module 08: Suspicious Conduct and Transactions: 00:20:00 •Module 09: Awareness and Training: 00:18:00

Overview This comprehensive course on Essentials of UK VAT will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Essentials of UK VAT 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 Essentials of UK VAT. It is available to all students, of all academic backgrounds. Requirements Our Essentials of UK VAT 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 • 07:22:00 total length •Module 01: Understanding VAT: 00:36:00 •Module 02: VAT Terminology and Calculation: 00:35:00 •Module 03: VAT Taxable Persons: 00:46:00 •Module 04: VAT Registration: 00:40:00 •Module 05: VAT Rates: 00:32:00 •Module 06: Invoicing and Records: 00:27:00 •Module 07: VAT Application in Goods, Services and Vehicles: 00:31:00 •Module 08: Supply: 00:43:00 •Module 09: The VAT Return: 00:25:00 •Module 10: Tips on VAT Compliance: 00:21:00 •Module 11: VAT Exemptions and Zero-Rated VAT: 00:39:00 •Module 12: Miscellaneous VAT Issues and Penalties: 00:41:00 •Module 13: Making Tax Digital: 00:26:00 •Assignment - Essentials of UK VAT: 00:00:00

Overview This comprehensive course on Bookkeeping Tool : Google Sheets will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bookkeeping Tool : Google Sheets 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 Bookkeeping Tool : Google Sheets. It is available to all students, of all academic backgrounds. Requirements Our Bookkeeping Tool : Google Sheets 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 1 sections • 12 lectures • 00:38:00 total length •Unit 1: Introduction: 00:03:00 •Unit 2: Google Sheets Users: 00:03:00 •Unit 3: Cash Bookkeeping: 00:04:00 •Unit 4: Advantages of Google Sheets in Bookkeeping: 00:02:00 •Unit 5: Chart of Accounts: 00:03:00 •Unit 6: Templates view: 00:02:00 •Unit 7: Invoice Template: 00:02:00 •Unit 8: Creating an Expense Book: 00:03:00 •Unit 9: Creating the Profit and Loss Statement: 00:06:00 •Unit 10: Making Records in the Revenue Book: 00:03:00 •Unit 11: Making Records in the Expense book: 00:04:00 •Unit 12: How the Profit and Loss Statement Updates: 00:03:00

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now in this Data Analyst Course! Unlock the power of Data Analysis and become a master of insights with our Data Analyst (Data Analytics) course. Gain the Data Analyst skills to decipher complex datasets, extract valuable information, and make data-driven decisions that drive success as a Data Analyst. Join us on this Data Analyst (Data Analytics) course and embark on a journey to transform raw data into actionable intelligence, empowering businesses to thrive in the digital age with Data Analyst (Data Analytics) Courses Included in This Data Analyst (Data Analytics) Training: Course 01: Diploma in Data Analysis at QLS Level 5 Course 02: Diploma in Business Data Analysis at QLS Level 5 Course 03: SQL Masterclass: SQL For Data Analytics Learning outcome of this Data Analyst (Data Analytics) course: Master retail Data analytics for data-driven decisions. Uncover consumer behavior with retail psychology. Enhance retail performance through data analytics. Apply data-driven strategies for retail planning. Optimise inventory and product assortment in retail. Why Prefer This Data Analysis at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with 24/7 tutor support Start your learning journey straight away with this Data Analyst (Data Analytics) course and take a step toward a brighter future! Why Prefer This Data Analyst (Data Analytics) Course? FREE certificate on Data Analyst (Data Analytics) accredited by CPDQS Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime Access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with Data Analysis Assessment Process of Data Analyst(Data Analytics) QLS Course: Assignment & MCQ Based 60% Marks to pass Instant Assessment Certificate of Data Analyst QLS Endorsed Certificate (additional cost) CPD Approved Certificate CPD 150 CPD hours / points Accredited by CPD Quality Standards Course 01- Data Analysis: Modifying a Worksheet 25:59 1: Insert, Delete, and Adjust Cells, Columns, and Rows Preview 10:08 2: Search for and Replace Data 08:38 3: Use Proofing and Research Tools 07:13 Working with Lists 37:47 4: Sort Data 10:03 5: Filter Data 09:49 6: Query Data with Database Functions 09:02 7: Outline and Subtotal Data 08:53 Analyzing Data 12:33 8: Apply Intermediate Conditional Formatting 06:50 9: Apply Advanced Conditional Formatting 05:43 Visualizing Data with Charts 38:03 10: Create Charts 13:18 11: Modify and Format Charts 12:16 12: Use Advanced Chart Features 12:29 Using PivotTables and PivotCharts 44:25 13: Create a PivotTable 13:28 14: Analyze PivotTable Data 12:00 15: Present Data with PivotCharts 07:35 16: Filter Data by Using Timelines and Slicers 11:22 Working with Multiple Worksheets and Workbooks 24:00 17: Use Links and External References 12:24 18: Use 3-D References 05:51 19: Consolidate Data 05:45 Using Lookup Functions and Formula Auditing 30:28 20: Use Lookup Functions 12:45 21: Trace Cells 09:05 22: Watch and Evaluate Formulas 08:38 Automating Workbook Functionality 35:27 23: Apply Data Validation 13:28 24: Search for Invalid Data and Formulas with Errors 04:06 25: Work with Macros 17:53 Creating Sparklines and Mapping Data 07:19 26: MapData 07:19 Forecasting Data 27:54 27: Determine Potential Outcomes Using Data Tables 08:47 28: Determine Potential Outcomes Using Scenarios 09:16 29: Use the Goal Seek Feature 04:16 30: Forecasting Data Trends 05:35 Course 02- Module 1: Introduction to Retail Analytics 32:03 31: Introduction to Retail Analytics Preview 32:03 Module 2: Retail Psychology 07:06 32: Retail Psychology 07:06 Module 3: Retail and Data Analytics 12:00 33: Retail and Data Analytics 12:00 Module 4: Benefits of Retail Analytics 16:26 34: Benefits of Retail Analytics 16:26 Module 5: Retail Strategy 09:44 35: Retail Strategy 09:44 Module 6: Retail Buying and Merchandising 11:27 36: Retail Buying and Merchandising 11:27 Module 7: Forecasting 23:27 37: Forecasting 23:27 Module 8: Retail Pricing 16:30 38: Retail Pricing 16:30 Module 9: Analytics Software 19:37 39: Analytics Software 19:37 Module 10: Supply Chain Management in Retailing 07:37 40: Supply Chain Management in Retailing 07:37 Module 11: The Sales Process and Dealing with Customers at the Checkout 04:57 41: The Sales Process and Dealing with Customers at the Checkout 04:57 Module 12: Selling in Multiple Channels 12:40 42: Selling in Multiple Channels 12:40 Module 13: Taking Trends and Targeting Customers Effectively 05:38 43: Taking Trends and Targeting Customers Effectively 05:38 Assessment (Optional) 12:00 44: MCQ Question 12:00 Order Your Certificate 02:00 45: Order Your CPD Certificate 01:00 46: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Data Analyst (Data Analytics) Training This course is for people who want to quickly and easily learn about Data Analyst (Data Analytics). Requirements Data Analyst (Data Analytics) Training You will not need any prior background or expertise to enrol in this Data Analyst (Data Analytics) course. Career path Data Analyst: £25,000 - £50,000 Junior Data Scientist: £30,000 - £60,000 Senior Data Analyst/Scientist: £50,000 - £100,000 Data Analytics Manager: £60,000 - £120,000 Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certificate of completion Digital certificate - £10 Diploma in Retail And Data Analytics at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Retail And Data Analytics at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)