• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1110 Financial Analysis courses in Cardiff delivered Online

Diploma in Forex Trading

4.8(9)

By Skill Up

Level up your trading game to become a good player in Forex Trading. Learn The secret to success in Forex Trading, Risk Management, What Are Forex Pairs, What Is Trading?

Diploma in Forex Trading
Delivered Online On Demand21 hours 11 minutes
£13.99

Management of Accounts Receivable Course

5.0(2)

By Training Express

Managing accounts receivable isn't just about chasing invoices—it’s about mastering the flow of cash with the finesse of a financial conductor. This course takes you through the art and strategy behind credit control, client invoicing, and debt recovery without ever sounding like a textbook. Whether you’re polishing up your knowledge or stepping into the finance game with a keen eye, we’ve built this for the sharp-minded professional who knows every penny delayed is more than just a minor inconvenience. Expect a clear, structured approach to understanding how receivables shape business health and how to keep them in check. Learn how to minimise overdue payments, improve cash flow forecasting, and create smoother client transactions—without feeling like you’re lost in spreadsheets. If you're after savvy financial control without the fluff, this course is your ledger-friendly companion. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Accounts Receivable Management Module 02 : Credit Policies and Procedures Module 03 : Billing and Invoicing Module 04 : Receivables Collection Strategies Module 05 : Cash Application and Reconciliation Module 06 : Accounts Receivable Technologies and Trends Learning Outcomes: Analyse and implement efficient credit policies. Streamline billing and invoicing procedures. Develop effective receivables collection strategies. Master the art of cash application and reconciliation. Stay updated with the latest Accounts Receivable technologies and trends. Enhance your financial management skills for a competitive edge. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Finance professionals Business owners and managers Accountants Financial analysts Administrative professionals Anyone interested in financial management Graduates seeking to enhance their financial knowledge Those looking to advance their career in finance Career path Credit Manager Financial Analyst Accounts Receivable Specialist Finance Manager Business Owner Accounting Clerk Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Management of Accounts Receivable Course
Delivered Online On Demand1 hour
£12

Introduction to Actuarial Science Course

5.0(2)

By Training Express

Fun fact about Actuarial Science: Actuaries are often referred to as "financial doctors" because they specialise in assessing and managing financial risks, much like medical doctors diagnose and treat health risks.Actuarial Science is where logic meets numbers with purpose. This course offers a solid grounding in the mathematical and statistical methods used to evaluate risk and uncertainty—essentials in industries like insurance, pensions, finance and beyond. It's designed for those who enjoy structured thinking, precision, and the challenge of making sense of the unknown using data. You’ll explore the principles that guide informed decision-making in uncertain environments, all through the lens of actuarial methods. Whether you're curious about future career directions or simply love the clarity of numbers, this course introduces you to the mindset and models behind the actuarial profession. With theory-led insight and a strong focus on probability, statistics, and financial mathematics, you'll discover how actuaries contribute to long-term planning and forecasting. It's smart, logical, and neatly structured—just like the subject itself. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Actuary Module 02 : Actuaries and Their Environment Module 03 : The Valuation of Cash Flows Module 04 : The Basic Deterministic Model Module 05 : The Life Table Module 06 : Life Annuities Module 07 : Life Insurance Module 08 : The Stochastic Life Contingencies Model Module 09 : The Stochastic Approach to Insurance and Annuities Module 10 : Taxation and Inflation Module 11 : Probabilistic Models, Uncertain Payment and Profit Testing Module 12 : Individual Risk Models Module 13 : Principles of Premium Calculation Module 14 : Multiple Decrement Theory Learning Outcomes: Analyse and predict financial risks with confidence. Master the valuation of cash flows and basic deterministic models. Understand the intricate world of life tables and annuities. Explore the complexities of life insurance and stochastic life contingencies. Navigate tax and inflation issues in the financial realm. Gain proficiency in probabilistic models and principles of premium calculation. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring actuaries Financial analysts Risk management enthusiasts Insurance professionals Finance and economics students Anyone interested in mastering financial uncertainties Career path Actuary Financial Analyst Risk Manager Insurance Underwriter Pension Consultant Investment Analyst Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Introduction to Actuarial Science Course
Delivered Online On Demand1 hour
£12

Accounts Clerk And MS Excel Training

5.0(1)

By Course Gate

Enhance your accounting skills and proficiency in Microsoft Excel with our Accounts Clerk and MS Excel Training course. Learn the fundamentals of bookkeeping, accounting principles, and Excel functions. Ideal for aspiring accounts clerks and professionals seeking to improve their Excel proficiency for efficient data management and analysis.

Accounts Clerk And MS Excel Training
Delivered Online On Demand11 hours 29 minutes
£11.99

Accountancy

4.9(27)

By Apex Learning

Overview Do you want a fast-paced, well-paying job in accounting? Your first step is the Accountancy course! We'll provide you with the tools you need to understand today's concepts, negotiate the financial world, and establish yourself as a valuable asset to any company. Immerse yourself in a master class on practical accounting. Discover how to balance any budget and discover the keys to becoming a financial giant. This is your launching pad to a fulfilling career, not just technical instruction. One balanced sheet at a time, take courses today to reshape your financial future! How will I get my certificate? Upon successful completion of the Accountancy course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is this course for? There is no experience or previous qualifications required for enrolment on this Accountancy. It is available to all students, of all academic backgrounds. Requirements Our Accountancycourse is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career path Having this qualification will increase the value of your CV and open you up to multiple sectors, such as : Accountant: £25k - £60k per year Financial Analyst: £30k - £70k per year Auditor: £35k - £75k per year Tax Consultant: £40k - £80k per year Finance Manager: £45k - £90k per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 3 sections • 22 lectures • 01:13:00 total length •Chris Moore - Accounting: 00:01:00 •Chris Moore - 1. Introduction: 00:03:00 •Chris Moore - 2. First Transactions: 00:05:00 •Chris Moore - 3. T Accounts introduction: 00:03:00 •Chris Moore - 4. T-Accounts conclusion: 00:03:00 •Chris Moore - 5. Trial Balance: 00:02:00 •Chris Moore - 6. Income Statement: 00:03:00 •Chris Moore - 7. Balance Sheet: 00:03:00 •Chris Moore - 8. Balance Sheet Variations: 00:03:00 •Chris Moore - 9. Accounts in practise: 00:05:00 •Chris Moore - 10. Balance Sheets what are they: 00:05:00 •Chris Moore - 11. Balance Sheet Level 2: 00:03:00 •Chris Moore - 12. Income Statement Introduction: 00:06:00 •Chris Moore - 13. Are they Expenses, or Assets: 00:03:00 •Chris Moore - 14. Accounting Jargon: 00:02:00 •Chris Moore - 15. Accruals Accounting is Fundamental: 00:03:00 •Chris Moore - 16. Trial Balance 3 days ago More: 00:04:00 •Chris Moore - 17. Fixed Assets and how it is shown in the Income Statement: 00:03:00 •Chris Moore - 18. Stock movements and how this affects the financials: 00:03:00 •Chris Moore - 19. Accounts Receivable: 00:03:00 •Chris Moore - 20. How to calculate the Return on Capital Employed: 00:05:00 •Chris Moore - 21. Transfer Pricing - International Rules: 00:02:00

Accountancy
Delivered Online On Demand1 hour 13 minutes
£12

Payroll Management Course

4.9(27)

By Apex Learning

Overview Mastering payroll systems across regions has become crucial because of globalisation. The Payroll Management Course offers an expansive curriculum designed meticulously, considering the intricacies and latest trends in payroll systems, especially emphasising the UK model.Module 01 provides an in-depth view of the Payroll System in the UK, laying the foundation for the subsequent modules. The course paves the way for advanced knowledge, from understanding the payroll basics (Module 02) to getting acquainted with company and legislation settings (Modules 03 & 04). Delve into the essentials ofpension schemes (Module 05) and the intricacies of pay elements (Module 06), and get a grip on payroll processing basics (Module 10), among various other critical topics.As we move towards the latter modules,we address standard procedures and contingencies such as employee leaving (Module 21) andyear-end procedures (Module 24), ensuring a holistic grasp of payroll management. 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 in this Payroll Management Course. It is available to all students, of all academic backgrounds.The Payroll Management Course is designed for professionals in payroll, HR, accounting, and business owners who want to master payroll systems, with a focus on the UK model. It covers a wide range of topics, from basics to advanced concepts, ensuring a holistic understanding of payroll management in the UK. Requirements Our Payroll Management Course has been designed to be fully compatible with tablets and smartphones. Here are some common requirements you may need: Computer, smartphone, or tablet with internet access. English language proficiency. Required software/tools. (if needed) Commitment to study and participate. There is no time limit for completing this course; it can be studied at your own pace. Career Path Popular and Top Career Paths in a Payroll Management Course: Payroll Specialist - Salary Range: £35,000 - £50,000 annually. Payroll Manager - Salary Range: £45,000 - £80,000 annually. HR Manager - Salary Range: £50,000 - £95,000 annually. Financial Analyst - Salary Range: £40,000 - £80,000 annually. Accounting Manager - Salary Range: £55,000 - £100,000 annually. It's essential to research specific job opportunities and market conditions in your area to get a more accurate understanding of potential salaries. Course Curriculum 1 sections • 24 lectures • 04:37:00 total length •Module 01: Payroll System in the UK: 01:05:00 •Module 02: Payroll Basics: 00:00:00 •Module 03: Company Settings: 00:08:00 •Module 04: Legislation Settings: 00:07:00 •Module 05: Pension Scheme Basics: 00:06:00 •Module 06: Pay Elements: 00:14:00 •Module 07: The Processing Date: 00:07:00 •Module 08: Adding Existing Employees: 00:08:00 •Module 09: Adding New Employees: 00:12:00 •Module 10: Payroll Processing Basics: 00:11:00 •Module 11: Entering Payments: 00:12:00 •Module 12: Pre-Update Reports: 00:09:00 •Module 13: Updating Records: 00:09:00 •Module 14: e-Submissions Basics: 00:09:00 •Module 15: Process Payroll (November): 00:16:00 •Module 16: Employee Records and Reports: 00:13:00 •Module 17: Editing Employee Records: 00:07:00 •Module 18: Process Payroll (December): 00:12:00 •Module 19: Resetting Payments: 00:05:00 •Module 20: Quick SSP: 00:10:00 •Module 21: An Employee Leaves: 00:13:00 •Module 22: Final Payroll Run: 00:07:00 •Module 23: Reports and Historical Data: 00:08:00 •Module 24: Year-End Procedures: 00:09:00

Payroll Management Course
Delivered Online On Demand4 hours 37 minutes
£12

Data Analysis in Excel Level 3 Course

4.9(27)

By Apex Learning

Course Overview: Data analysis is a hot skill in today's job market. According to a recent study by LinkedIn, demand for data analysts is growing 15 times faster than the average for all occupations. And the salaries are good too. The average salary for a data analyst in the UK is £40,000. If you're looking to get ahead in your career or learn a new skill that's in high demand, then the Data Analysis in Excel Level 3 Course is for you. In this course, you'll learn how to use Excel to analyse data like a pro. You'll learn how to clean, format, and analyse data using various Excel tools and techniques. You'll also learn how to create charts and graphs to visualise your data. This course won't merely make you adept at Excel. It will mould you into a data wizard, wielding Excel as a potent tool to make data sing and secrets reveal themselves. Enrol Today and Start Learning! Key Features of the Course: Embark on your data analysis journey with us and discover these exciting features: A CPD Certificate to validate your newfound skills. 24/7 Learning Assistance for any hour inspiration strikes. Engaging learning materials to ensure an enriching learning experience. Who is This Course For? Our Data Analysis in Excel Level 3 Course caters to ambitious individuals with a basic understanding of Excel, eager to take their skills to new heights. This course welcomes everything from budding data enthusiasts to established business analysts seeking to fortify their analytical toolkits. What You Will Learn: Dive deep into the labyrinth of data as you master essential modules such as 'Search for and Replace Data,' 'Sort and Filter Data,' and 'Query Data with Database Functions.' Venture further into data exploration with our 'Outline and Subtotal Data' module, where you'll learn to summarise your data for a more organised view efficiently. The journey continues with modules like 'Create Charts' and 'Modify and Format Charts,' enabling you to translate complex data into easy-to-understand visuals. Furthermore, our dedicated modules on 'Creating a PivotTable' and 'Analysing PivotTable Data' promise a comprehensive understanding of one of Excel's most powerful tools. Why Enrol in This Course: Rated as a top-reviewed course and constantly updated to keep up with the latest trends, our Data Analysis in Excel Level 3 Course equips you with sought-after skills like data forecasting, creating sparklines, using advanced chart features, and more. Requirements: While no specific prerequisites are required, a basic understanding of Excel and an eagerness to explore the fascinating world of data analysis would be beneficial. Career Path: On completion of this Data Analysis in Excel Level 3 Course course, you'll be ready to step into diverse roles such as: Data Analyst (£30,000-£35,000) Business Intelligence Analyst (£32,000-£37,000) Market Research Analyst (£28,000-£33,000) Operations Analyst (£31,000-£36,000) Financial Analyst (£35,000-£40,000) Supply Chain Analyst (£30,000-£35,000) Sales Analyst (£29,000-£34,000) Certification: Upon successful completion of the course, you'll be awarded a prestigious CPD Certificate, demonstrating your expertise in data analysis using Excel. So, are you ready to discover the hidden stories in data and revolutionise decision-making? Enrol in our Data Analysis in Excel Level 3 Course and start your journey today! Course Curriculum 11 sections • 32 lectures • 04:43:00 total length •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 •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 •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 •Assignment - Data Analysis in Excel Level 3 Course: 00:00:00

Data Analysis in Excel Level 3 Course
Delivered Online On Demand4 hours 43 minutes
£12

Business Administration Level 3

4.9(27)

By Apex Learning

Course Overview: According to the World Economic Forum, business administration is one of the most in-demand professions, with an impressive 5% annual job growth rate. The Business Administration Level 3 course is pivotal in shaping these industry leaders. Delving deep into critical topics such as 'Representing Your Boss and Company', 'Skills of an Effective Administrator', and 'Business Writing Skills', it aims to equip learners with the robust skill set essential for today's dynamic business environment. The curriculum further accentuates real-world application through modules on 'Communication Skills', 'Business Telephone Skills', and 'Mail Services and Shipping', preparing students to take on multifaceted roles with finesse. The significance of this course is not just about knowledge acquisition; it's about nurturing adept administrators who can charter the rough waters of global business.This course isn't just about lessons; it's about moulding future leaders in business administration. Enrol now! Key Features of the Course: CPD Certificate: Upon completing this course, you will receive a Continuing Professional Development (CPD) certificate recognised by employers across various industries. 24/7 Learning Assistance: Our dedicated support team is available round the clock to provide guidance and resolve any queries or concerns you may have throughout your learning journey. Who is This Course For? This Business Administration Level 3 course is ideal for individuals aspiring to pursue a career in business administration or those already working in administrative roles seeking to enhance their skills and progress in their careers. Whether you are a recent graduate, a job seeker, or a professional looking to upskill, this course will provide you with the knowledge and competencies necessary to succeed. What You Will Learn: Throughout this Business Administration Level 3 course, you will delve into various modules, each focusing on a specific aspect of business administration. By the end of the program, you will have gained a comprehensive understanding of: Skills of an Effective Administrator: Develop the core skills required to excel in an administrative role, such as organisational abilities, problem-solving, and attention to detail. Business Writing Skills: Master the art of effective written communication, including email etiquette, report writing, and professional correspondence. Communication Skills: Enhance your interpersonal skills, including active listening, conflict resolution, and effective communication in diverse workplace environments. Business Telephone Skills: Learn the essentials of professional phone etiquette, handling calls, and effectively addressing customer queries or concerns. Mail Services and Shipping: Gain insights into managing mail services, handling shipments, and maintaining efficient mailing systems. Travel Arrangements: Understand the processes of organising travel arrangements, including booking flights, accommodations, and itineraries. Organising Meetings and Conferences: Learn how to plan, coordinate, and execute successful meetings and conferences, ensuring smooth operations and optimal productivity. Time Management: Discover effective strategies for prioritisation, task delegation, and time optimising to maximise productivity. Record Keeping and Filing Systems: Develop essential skills in maintaining accurate records, implementing effective filing systems, and ensuring data security. Effective Planning and Scheduling: Master efficient planning and scheduling to meet deadlines, manage projects, and streamline operations. Why Enrol in This Course: Enrolling in this Business Administration Level 3 course will give you a competitive edge in the job market. With top learner reviews, this course has been recently updated to align with industry trends and practices. The skills you acquire will make you a highly sought-after candidate in various administrative roles, opening up exciting career opportunities. Requirements: To enrol in this course, you only need a basic understanding of the English language and access to a computer with an internet connection. No prior experience or qualifications are necessary. Career Path: Upon completion of the Counselling Course - Business Administration Level 3, you will be equipped with the skills and knowledge for various professions, such as Administrative Assistant - £20,000 to £30,000 per year Office Manager - £25,000 to £40,000 per year Executive Assistant - £30,000 to £50,000 per year Human Resources Manager - £40,000 to £70,000 per year Operations Manager - £40,000 to £80,000 per year Marketing Manager - £35,000 to £70,000 per year Financial Analyst - £35,000 to £60,000 per year Business Development Manager - £40,000 to £80,000 per year Project Manager - £40,000 to £70,000 per year Management Consultant - £40,000 to £100,000 per year Certification: Upon successfully completing the Counselling Course - Business Administration Level 3, you will receive a CPD certificate, confirming your newfound expertise and enhancing your professional credibility in business administration. Course Curriculum 11 sections • 11 lectures • 05:16:00 total length •Representing Your Boss and Company: 00:34:00 •Skills of an Effective Administrator: 00:15:00 •Business Writing Skills: 00:40:00 •Communication Skills: 00:25:00 •Business Telephone Skills: 00:19:00 •Mail Services and Shipping: 00:25:00 •Travel Arrangements: 00:24:00 •Organising Meeting and Conferences: 00:25:00 •Time Management: 00:35:00 •Record Keeping and Filing Systems: 00:28:00 •Effective Planning and Scheduling: 00:46:00

Business Administration Level 3
Delivered Online On Demand5 hours 16 minutes
£12

Microsoft Excel Course for Everyone - Complete Excel Course

4.9(27)

By Apex Learning

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Microsoft Excel Course for Everyone - Complete Excel Course
Delivered Online On Demand6 hours 51 minutes
£12

Data Analytics with Tableau

4.9(27)

By Apex Learning

Course Overview: According to a report by the World Economic Forum, data analysts and scientists are among the top emerging job roles. The "Data Analytics with Tableau" course is tailored to equip learners with the vital skills required to excel in this dynamic field. The course delves into the intricacies of data visualisation and analysis using Tableau, a leading software in the industry. It's not merely about understanding data but transforming it into actionable insights that drive business decisions. The course is structured to provide a comprehensive understanding of various aspects of data analytics, including sales, HR, and shipping analytics.Don't miss this opportunity to advance your career with cutting-edge skills in data analytics. Enrol in "Data Analytics with Tableau" now and embark on a journey of professional growth and endless possibilities! Key Features of the Course: CPD Certificate: Upon completion, you will receive a prestigious Continuing Professional Development (CPD) certificate, recognised globally for enhancing your career prospects. 24/7 Learning Assistance: Our dedicated support team ensures you receive prompt assistance, providing a seamless learning experience. Who is This Course For? This course is tailored for individuals who aspire to become data analysts, business intelligence professionals, marketing strategists, or decision-makers seeking to leverage data effectively. No experience with Tableau or coding is required, making it accessible and engaging for beginners. What You Will Learn: Data Analytics with Tableau, This course covers a wide range of topics, starting with connecting and preparing data, where you will learn how to import, clean, and transform data to make it analysis-ready within Tableau. Next, you will master the art of building insightful charts and visualisations using Tableau's rich set of tools, enabling you to communicate data trends and insights effectively. Additionally, you will explore the creation of captivating headline cards and interactive dashboards, gaining expertise in presenting key information and facilitating data exploration. Real-world projects, including Discount Mart, Green Destinations, Super Store, Northwind Trade, and Tesla, will provide you with outstanding experience in applying Tableau to solve practical data challenges. Lastly, you will develop a solid understanding of database concepts and learn to create compelling data stories using Tableau's storytelling features. By the end of this course, you will have the skills and confidence to make data-driven decisions and communicate insights effectively using Tableau. Why Enrol in This Course: Join the recently updated top-reviewed Data Analytics course with Tableau to keep you at the forefront of the field. Expand your analytical skills, unlock career opportunities, and stay current in the rapidly evolving world of data analytics by mastering Tableau, the industry-standard tool for visual analytics. Requirements: No prior experience with Tableau or coding is required. All you need is a computer with internet access, a curious mind, and a passion for exploring the world of data analytics. Career Path: By acquiring data analytics skills with Tableau, you open doors to exciting career paths, such as: Data Analyst (Average Salary: £35,000 - £45,000) Business Intelligence Analyst (Average Salary: £40,000 - £55,000) Marketing Analyst (Average Salary: £30,000 - £40,000) Financial Analyst (Average Salary: £35,000 - £50,000) Data Visualization Specialist (Average Salary: £40,000 - £60,000) Database Administrator (Average Salary: £40,000 - £55,000) Data Scientist (Average Salary: £45,000 - £70,000) Certification: Upon successful completion of the course, you will receive a CPD certificate, internationally recognised for its validation of your expertise in data analytics with Tableau. Enrol now and embark on a transformative journey to become a proficient data analyst and visualisation expert with Tableau! Course Curriculum 9 sections • 41 lectures • 06:47:00 total length •Introduction to the Course: 00:02:00 •What is Tableau? An Introduction to Tableau: 00:03:00 •How this course is Structured: 00:01:00 •Installing the Free Full Version of Tableau: 00:02:00 •Project Brief for Discount Mart: 00:03:00 •Connecting and Preparing Data for Discount Mart: 00:15:00 •Building Charts on Tableau for Discount Mart (Part 1): 00:33:00 •Building Charts on Tableau for Discount Mart (Part 2): 00:16:00 •Creating Headline Cards on Tableau for Discount Mart: 00:10:00 •Building and Publishing Dashboards on Tableau: 00:15:00 •Project Brief for Green Destinations: 00:02:00 •Connecting and Preparing Data for Green Destinations: 00:09:00 •Building Charts on Tableau (Part 1) for Green Destinations: 00:28:00 •Building Charts on Tableau (Part 2) for Green Destinations: 00:08:00 •Creating Headline Cards on Tableau: 00:15:00 •Building a Dashboard for Green Destinations: 00:12:00 •Publish your Dashboard to Tableau Public: 00:02:00 •Project Brief for Super Store: 00:02:00 •Connecting and Preparing Data for Super Store: 00:17:00 •Building Charts on Tableau (Part 1) for Super Store: 00:34:00 •Building Charts on Tableau (Part 2) for Super Store: 00:23:00 •Building a Dashboard: 00:18:00 •Publish your Dashboard to Tableau Public: 00:03:00 •Project Brief for Northwind Trade: 00:03:00 •Connecting and Preparing Data for Northwind Trade: 00:14:00 •Building Charts on Tableau for Northwind Trade: 00:37:00 •Building and Publishing Dashboards for Northwind Trade: 00:10:00 •Project Brief for Tesla: 00:02:00 •Creating a Data Source through Google Sheet Functions: 00:05:00 •Connect to the Data for Tesla: 00:04:00 •Building Charts on Tableau for Tesla: 00:22:00 •Building Headline Cards: 00:09:00 •Building a Tesla Dashboard: 00:08:00 •Publish your Dashboard to Tableau Public: 00:03:00 •Introduction to Database Concepts: 00:01:00 •Understanding Relational Databases: 00:04:00 •Relationships of Database Entities: 00:02:00 •Primary and Foreign Keys: 00:01:00 •Data types and Naming Conventions: 00:04:00 •Creating Stories on Tableau: 00:05:00 •Resources - Data Analytics with Tableau: 00:00:00

Data Analytics with Tableau
Delivered Online On Demand6 hours 47 minutes
£12