357 Spreadsheet courses in Sheffield delivered On Demand

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 Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Who is this Course for? Microsoft Office 2007 Excel Intermediate is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Course Curriculum Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Creating A Body Of Work 00:03:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft Office 2019 (Updated and New Features 2022) Overview In today’s digital workplace, Microsoft Office proficiency is a must-have skill across all industries. From office administrators to marketing executives, everyone benefits from mastering the MS Office suite. That’s why our Microsoft Office 2019 course (including 2022 updates) is designed to help you gain job-ready skills and stay ahead in a competitive market. Through this course, you will explore the core applications of MS Office — Excel, Word, PowerPoint, and Access. You’ll begin with Excel, learning how to perform calculations, manage workbooks, and apply formatting to make your data clear and useful. Next, you’ll move on to Microsoft Word, where you'll discover how to efficiently prepare and format professional documents, manage lists, and insert tables and graphic elements. The course then introduces PowerPoint, guiding you through designing impactful presentations using charts, images, and animations. Finally, you’ll gain a practical understanding of Microsoft Access, focusing on modifying data, working with queries, and generating meaningful reports. By the end of this course, you’ll have developed a strong grasp of MS Office tools and features — including the latest 2022 updates — giving your CV a significant edge and preparing you for a variety of career paths. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the updated features of Microsoft Office 2019 and the 2022 enhancements Learn to navigate and utilise key functions in Excel, including calculations, formatting, and workbook management Discover essential Word skills, from formatting text to publishing polished documents Develop the ability to create dynamic PowerPoint presentations with media and charts Gain working knowledge of Access, including queries, forms, and reports Prepare for a range of office roles with practical, up-to-date MS Office knowledge Who is this Microsoft Office 2019 Course for? This course is suitable for office professionals, students, job seekers, and anyone looking to improve their Microsoft Office skills. It's perfect for those aiming to work more productively or move into roles that require document creation, data handling, or presentations. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in improving their Microsoft Office skills, regardless of previous experience. Basic computer literacy is helpful but not essential. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.