464 Spreadsheet courses in Belfast delivered Online

Delving into the world of performance improvement and financial insight, this course explores three dynamic methodologies: Theory of Constraints (TOC), Throughput Accounting, and Lean Accounting. Designed to help learners understand how bottlenecks affect organisational flow and profitability, the course breaks down each concept into digestible, well-paced modules. TOC introduces the logic of constraint-based thinking, Throughput Accounting reshapes how financial outcomes are viewed, and Lean Accounting sharpens the focus on customer value without the clutter of traditional costing. Whether you're managing budgets or refining operational efficiency, this course offers clear strategies that speak the language of results. With easy-to-follow explanations and engaging visuals, it helps make sense of complex theories without drowning learners in jargon. By the end, you'll be equipped with fresh perspectives that can support smarter, quicker decision-making—without spreadsheets throwing tantrums. Learning Outcomes: Understand the fundamental concepts of Theory of Constraints, Throughput Accounting and Lean Accounting. Be able to measure business performance using Throughput Accounting. Understand Lean Accounting concepts and how to create lean performance measures. Learn how to manage by value stream and quantify the benefits of improvement activity. Be able to plan by value stream and use the tools of Lean Accounting. Apply the concepts learned to enhance business performance and profitability. This course offers a comprehensive understanding of the Theory of Constraints, Throughput Accounting and Lean Accounting. It is ideal for anyone interested in improving their business processes and financial management skills. You will learn how to measure business performance using Throughput Accounting, as well as how to create lean performance measures. Additionally, you will be introduced to the tools of Lean Accounting, and learn how to manage by value stream, quantify the benefits of improvement activity, and plan by value stream. By the end of this course, you will have a solid understanding of these essential business concepts, and be able to apply them to your organisation, enhancing its performance and profitability. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path You will have the opportunity to explore various job prospects in diverse industries, which offer positions and pay scales including: Operations Manager - £24,000 - £65,000 per annum Lean Six Sigma Specialist - £35,000 - £70,000 per annum Business Analyst - £25,000 - £54,000 per annum Supply Chain Manager - £29,000 - £68,000 per annum Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

If spreadsheets make your eyes glaze over, this course will change your perspective. “Financial Modelling Using Excel” is designed for professionals, entrepreneurs, and finance enthusiasts who want to make Excel sing with numbers. With a touch of logic and a bit of flair, you'll learn how to structure financial models that are not only functional but elegantly built. Whether it’s forecasting revenue, building balance sheets, or calculating project viability, this course simplifies the complex into cells and formulas that actually make sense. From budgeting to scenario analysis, this training helps you transform raw data into clear financial insights—all within Excel. It’s ideal for anyone who prefers to work smart with numbers, rather than wrestle them into submission. Tidy sheets, structured models, and the kind of clarity that would make even your accountant raise an eyebrow—this is Excel used at its finest. No fluff, no drama—just formulas, logic, and a satisfying sense of order. Learning Outcomes: Develop a strong understanding of financial modelling and forecasting Build effective financial model templates using Excel Project income statements, balance sheets, and cash flows with ease Gain insight into advanced financial modelling techniques Learn how to apply financial modelling skills in real-world scenarios This comprehensive course is divided into six distinct modules, each focusing on a specific aspect of financial modelling using Excel. The course starts with an introduction to financial modelling and planning your financial model, before moving on to building a model template. You will then learn how to project the income statement, balance sheet, and cash flows. In the advanced financial modelling module, you will gain insight into more complex techniques such as sensitivity analysis, scenario analysis, and Monte Carlo simulation. By the end of this course, you will have the skills and knowledge to build accurate and effective financial models and forecasts, and apply them in real-world scenarios. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Upon completion of this course, you will be equipped with the skills and knowledge to pursue a career in finance. Here are some potential salary ranges for these positions in the UK: Financial Analyst: £26,000 - £70,000 Investment Analyst: £28,000 - £82,000 Risk Analyst: £29,000 - £65,000 Corporate Finance Analyst: £30,000 - £75,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Numbers never lie—but they often try to hide the truth. This Forensic Accounting course is your gateway to understanding how financial frauds are uncovered and financial mysteries solved. With a sharp focus on the analytical methods behind forensic investigations, this course walks you through how experts interpret financial records to detect embezzlement, asset misappropriation, financial statement manipulation and more. From tracing hidden assets to identifying red flags in accounts, each topic is designed to sharpen your eye for financial irregularities. Whether you're drawn to corporate investigations, financial auditing or simply intrigued by how financial wrongdoing is exposed, this course lays the groundwork for exploring the deeper story behind the spreadsheets. You’ll learn the language of forensic accountants, understand the methods behind financial scrutiny, and develop the insight to see through even the most polished balance sheet. Ideal for learners curious about forensic finance and those keen to pursue roles in investigation and analysis, this course puts clarity, strategy and detail front and centre—without a magnifying glass in sight. Award in Forensic Accounting at QLS Level 2 Enrol now to discover everything you need to know about the Forensic Accounting - Course and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand! Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Key Features CPD Accredited Quality License Endorsed Certificate Available Upon Course Completion Course Curriculum: Forensic Accounting Course Forensic Accounting: An Overview Essentials of Forensic Accounting Understanding the Basics of Financial Accounting Characteristics of Financial Crimes The Role of the Accounting Professional Money Laundering Fraud Prevention and Detection Fraud Prevention for Consumers Fraud Prevention for Business Fraud in Digital World Exam and Assessment MCQ based test 60% Marks to pass Instant Assessment and Feedback Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Forensic Accounting - Course course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Forensic Accounting - Course course is open to all, with no formal entry requirements. Career path Upon successful completion of the Forensic Accounting - Course Course, learners will be equipped with many indispensable skills and have the opportunity to grab. Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £69 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £69 International: £69 + £10 (postal charge) = £79 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Choosing the right HR system isn’t just about ticking features off a checklist — it’s a strategic decision that shapes the future of your organisation’s people management. This course offers a focused and insightful look at what matters most when selecting an HR system. From understanding your organisation’s specific needs to evaluating providers with a sharp eye, you'll be guided through the selection process with clarity and confidence. In a world of endless software options and over-promises, this course helps you cut through the clutter. Learn how to avoid common pitfalls, ask the right questions, and assess systems not just for today’s tasks but tomorrow’s growth. Whether you're moving away from spreadsheets or reviewing outdated tools, this course equips you with the essentials to make smart, future-minded choices — all without the fluff. Learning Outcomes: Understand the fundamental elements of HR systems and how they relate to the needs of their organisation. Learn how to conduct a needs assessment to identify the specific requirements of their organisation for an HR system. Develop an understanding of the different types of reporting and analytics available within HR systems, and how these can be leveraged to inform decision-making and improve HR processes. Understand the key considerations involved in selecting an HR system, including evaluating vendors, assessing system capabilities, and weighing the costs and benefits of different options. Learn best practices for implementing a new HR system, including planning, testing, and training strategies to ensure a successful transition. Gain familiarity with industry-specific terminology, trends, and challenges related to HR systems and be able to participate in conversations around system selection and implementation with confidence. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voice-over and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Here is a curriculum breakdown of the HR System Selection Essentials course: Lesson 01: Introduction Lesson 02: Elements of HR System Lesson 03: Reporting and Analytics Lesson 04: Selecting an HR System Lesson 05: Implementing the New System Exam and Assessment MCQ based test 60% Marks to pass Instant Assessment and Feedback Certification CPD Certified PDF and Hardcopy Certificate Level 2 QLS Endorsed Hardcopy Certificate for Award in HR System Selection Essentials at QLS Level 2 CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HR System Selection Essentials course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This HR System Selection Essentials course is open to all, with no formal entry requirements. Career path Upon successful completion of the HR System Selection Essentials Course, learners will be equipped with many indispensable skills and have the opportunity to grab. Jobs you can explore such as: HR Systems Manager HRIS Analyst HR Systems Administrator HR Systems Specialist HR Systems Consultant HR Operations Manager HR Systems Support Analyst HR Systems Project Manager HR Data Analyst Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £69 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £69 International: £69 + £10 (postal charge) = £79 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Inventory management is the backbone of a well-functioning business, and understanding how to streamline it using Management Information Systems (MIS) is a game-changer. This course offers a strategic view of inventory control, showing you how to track, analyse, and optimise inventory levels using digital tools and data-driven methods. Whether you're overseeing stock in a retail environment or managing supplies in manufacturing, this course teaches the essentials of controlling costs and improving efficiency through the power of MIS. You’ll explore topics such as inventory forecasting, automated reporting, and MIS integration—all designed to support smarter decision-making. Through structured modules, you'll gain insight into how data flows, system configuration, and inventory analytics work together to help maintain accuracy, avoid overstocking, and reduce losses. Perfect for professionals aiming to refine inventory processes and enhance performance without being buried in spreadsheets or manual logs. Learning Outcomes: Understand the principles of inventory control and its importance in business operations. Analyse inventory data using management information systems (MIS). Identify and solve inventory issues such as slow-moving and non-moving items. Apply Pareto analysis to prioritise inventory control efforts. Utilise Excel functions such as reorder level and economic order quantity (EOQ) for effective inventory control. "Inventory Control Using MIS" is a comprehensive course bundle designed to equip learners with the knowledge and skills necessary to streamline inventory control processes. This course covers a range of topics, including inventory procurement, Pareto analysis, and Excel inventory control. Through hands-on exercises and real-world scenarios, learners will develop the ability to analyse and interpret inventory data, making informed decisions with confidence. This course bundle is ideal for inventory managers, supply chain professionals, and business owners seeking to optimise their inventory control processes. With a focus on practical applications and the use of management information systems (MIS), learners will come away from this course with a valuable skill set that can be applied in a range of professional settings. Inventory Control Using MIS Course Curriculum Lesson 01: Introduction to Inventory Control Lesson 02: Inventory Control Lesson 03: Inventory Issues Lesson 04: Pareto Analysis Lesson 05: Application of Pareto Lesson 06: Slow Moving and Non Moving Items Lesson 07: Inventory Procurement Lesson 08: Reorder Level and EOQ Lesson 09: Excel Inventory Control Lesson 10: Excel Inventory Control Continued How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Inventory managers seeking to streamline their inventory control processes. Supply chain professionals looking to enhance their knowledge of inventory control. Business owners seeking to optimise their inventory management. Students and individuals interested in inventory control and management information systems. Professionals looking to enhance their skill set in the field of inventory management. Career path Inventory Manager: £25,000 - £65,000 Supply Chain Manager: £30,000 - £85,000 Logistics Manager: £25,000 - £70,000 Operations Manager: £30,000 - £80,000 Business Analyst: £25,000 - £65,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Understanding financial accounting is no longer just for number crunchers in grey suits—it’s a core skill that brings clarity to the often-confusing world of business finances. This course introduces you to the bedrock principles of financial accounting, designed in a logical flow that even your sleep-deprived inner auditor would approve of. From double-entry bookkeeping to balance sheets and income statements, you’ll gain insight into how businesses track, report, and evaluate financial performance with purpose and precision. Whether you’re trying to make sense of your business's financial reports or just tired of nodding blankly during budget meetings, this course offers you the language of numbers in a way that makes sense. With a structured, theory-based format, you'll explore the essential components of accounting with clarity and relevance. Perfect for professionals, entrepreneurs, or those with a healthy distrust of spreadsheets, this is your chance to understand the financial ropes—minus the accounting jargon headache. Learning Outcomes: Understand the basics of financial accounting Learn the balance sheet equation and how to prepare financial statements Acquire knowledge of the recording process in financial accounting Gain an understanding of adjusting entries and their impact on financial statements Be able to complete the accounting cycle The Learn the Fundamentals of Financial Accounting course is designed to provide students with a comprehensive understanding of the basics of financial accounting. The course covers the balance sheet equation, financial statements, the recording process, adjusting entries, and completing the accounting cycle. Students will gain a deep understanding of the concepts and principles behind financial accounting and how they are applied in real-world scenarios. This course is perfect for anyone who wants to gain a solid understanding of financial accounting, whether they are new to the field or have some prior knowledge. It is also ideal for small business owners who want to manage their finances more effectively and make informed decisions based on financial data. ⊱⊱ Learn the Fundamentals of Financial Accounting Course Curriculum Module 01: Introduction to Business Module 02: Balance Sheet Equation Module 03: Financial Statements Module 04: Recording Process Module 05: Adjusting Entries Module 06: Completing the Account How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is designed for individuals who are interested in learning the fundamentals of financial accounting. It is suitable for: Students who want to pursue a career in accounting or finance Business owners who want to manage their finances effectively Professionals who want to enhance their accounting skills for career advancement Individuals who want to improve their personal finance management skills Anyone who is interested in learning about financial accounting Career path Accounting Clerk: £16,000 - £25,000 per year Bookkeeper: £18,000 - £30,000 per year Accounts Payable/Receivable Clerk: £18,000 - £30,000 per year Financial Analyst: £30,000 - £50,000 per year Certified Public Accountant (CPA): £40,000 - £90,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Managing your finances as a self-employed professional shouldn’t feel like decoding ancient scrolls. Our QuickBooks Self-Employed Course is designed to make numbers less terrifying and taxes far less confusing. This expertly structured course helps freelancers, sole traders, and independent contractors understand how to keep their finances in order, track expenses efficiently, and manage income without losing sleep over spreadsheets. Whether you’re logging miles for client visits or sorting receipts for the hundredth time, this course guides you through QuickBooks Self-Employed step-by-step—minus the jargon overload. Learn how to organise your records, stay HMRC-ready, and take charge of your tax responsibilities with confidence. It's not about becoming an accountant; it's about making sure you don't need one every time a tax return looms. Why People Love And Enrol The QuickBooks Self-Employed Course From One Education Eligibility for an CPD accredited certificate on successful completion of Course Learning materials of our course contains engaging voiceover and visual elements for your comfort Freedom to study at your own pace 24/7 access to the course materials for 12 months Full Tutor support on weekdays (Monday - Friday) This training course is designed by industry experts and will give you an in-depth understanding of this topic. The course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. If you want to work in this rapidly growing sector and stand out from the competition, then our QuickBooks Self-Employed is the perfect place to kickstart your dream career. On the course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the course will help you land the job you want in a related field. Enjoy a pleasant and professional 100% online learning experience and enrol in our QuickBooks Self-Employed today and take control of your career! Course Curriculum: Here is a curriculum breakdown of the course: Module 01: User of QuickBooks Self-Employed Module 02: QBSE - Features Module 03: Pros Module 04: Cons Module 05: Comparison Module 06: Tax Profile Module 07: Vechile Module 08: Health Insurance Module 09: Bank Account Module 10: Create an Invoice Module 11: Manage Invoice Module 12: Expense Receipts Module 13: Adding Transactions Module 14: Import Transactions Module 15: Exclude a Duplicate Module 16: Export Data Module 17: Categorization Module 18: Income and Expenses Module 19: Transfers Module 20: Rules Module 21: Split a Transaction Module 22: Miles Module 23: Profit and Loss Report Module 24: Tax Summary Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? The training course is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This course also suits people aspiring for some in-depth knowledge on this topic and keep up to date with the latest information. Study the QuickBooks Self-Employed course today and increase your professional skillset from the comfort of your home! Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Anyone and everyone with a knack for learning can enrol on this course without any hesitation. Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the QuickBooks Self-Employed course at your own pace. All students must have a passion for learning and literacy, as well as being over the age of 16. Career path Studying the course is designed to help you get the job of your dreams, or even that promotion you've always wanted! Learn the essential skills and knowledge you need to exceed in your professional life with the help & guidance from our QuickBooks Self-Employed course.

Data isn’t just for tech wizards anymore — it’s at the heart of smart business decisions. This course takes a light-footed yet sharp approach to show you how data shapes strategies, informs choices, and reveals what’s really going on behind the numbers. Whether you're managing a small team or eyeing growth opportunities, understanding the basics of business and data analytics can help you avoid the guesswork and focus on what truly drives performance. We’ve designed this course to make numbers less intimidating and more insightful. Through clear explanations and well-paced modules, you’ll grasp how data trends, patterns, and reports can support better decision-making across departments. If spreadsheets usually send you running, don’t worry — we keep things clear, logical, and surprisingly engaging. This course is for beginners, but the mindset you’ll develop is fit for any boardroom conversation. Learning Outcomes: Develop an understanding of the principles and practices of business and data analytics Learn effective strategies for problem framing and business process modelling Develop analytical skills for data preparation, evaluation, and deployment Understand how to exploit data to gain a competitive edge Be able to make informed decisions and navigate the complex and dynamic world of business and data analytics The "Business and Data Analytics for Beginners" course is designed to provide a comprehensive understanding of the principles and practices that underpin successful data analysis in a business context. Through engaging modules and real-world case studies, learners will gain insights into the basics of business and data analytics, advanced techniques for data preparation, evaluation, and deployment, and effective strategies for exploiting data to gain a competitive edge. By the end of the course, learners will be equipped with the knowledge and skills to make informed decisions and navigate the complex and dynamic world of business and data analytics. Whether you're a business professional looking to enhance your skills or a beginner looking to enter the world of data analysis, this course is a must-have for anyone interested in the world of business and data analytics. Business and Data Analytics for Beginners Course Curriculum Section 01: Business and Data Analytics Introduction to Business and Data Analytics Where are Insights Business Analytics Being Used Problem Framing Process Section 02: Business Process Model Business Process Modelling Outcome of the First Step Outcome of the Second Step Data Understanding How Do You Exploit Data that no One Else Has? Informational System Usually Section 03: Working on Data Data Preparation Evaluation Deployment Major Health Insurance Company Process How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business professionals looking to enhance their data analysis skills Beginners interested in the world of business and data analytics Business students interested in the field of data analysis Entrepreneurs looking to incorporate data analysis into their business practices Anyone interested in gaining a comprehensive understanding of data analysis in a business context Career path Data Analyst: £20,000 - £50,000 per year Business Analyst: £25,000 - £60,000 per year Marketing Analyst: £25,000 - £50,000 per year Financial Analyst: £25,000 - £70,000 per year Operations Analyst: £25,000 - £60,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Overview This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Excel Sheet Comparison with VBA is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 23 lectures • 02:10:00 total length •Introduction to Compare Data Workbook: 00:06:00 •Download Resources: 00:00:00 •Key requirements for Comparing any Datasets or Worksheets: 00:03:00 •Tool to Compare Datasets or Worksheets: 00:06:00 •Overview of Compare Data Workbook: 00:09:00 •Most Important things to remember before you use compare data workbook: 00:03:00 •IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00 •Deep Dive into Compare Data Workbook's Environment: 00:10:00 •How to Change Header Rows for your data: 00:06:00 •Basics of Using macro enabled Excel files and Code Modules: 00:04:00 •Changing the Main two sheets name, variance tags in VBA Code: 00:05:00 •Changing various elements across VBA Code modules: 00:05:00 •Clear Sheet data button VBA Code: 00:04:00 •Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00 •Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00 •Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00 •IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00 •Conclusion: 00:01:00

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report