493 Spreadsheet courses in London delivered Online

Dive into the world of data like never before with this Power BI Training Course—where dashboards become a canvas and numbers finally make sense. Whether you're working with spreadsheets that never end or reports that need more punch, Power BI turns all that chaos into clear, useful insight. This course shows you how to shape data, build visuals, and tell a story your team will actually understand—without needing a maths degree or a magic wand. From sales figures to survey responses, learn how to make sense of it all using Microsoft's popular business intelligence tool. It doesn’t matter if you're from finance, marketing, logistics or even a tea-making department—if there's data, there’s Power BI. This course is fully online, so no awkward group exercises or cold meeting rooms involved—just clear, engaging learning designed to suit your pace. Whether you're fresh to the concept or already poking around with pivot tables, there's something here to sharpen your skills and make data feel less like a chore and more like a superpower. Curriculum Power BI - Introduction Overview of the Course Intro High-Level Flow Install and Sign Up Power Query Intro Power Pivot Intro Power View Intro Your First Power BI Dashboard Big Picture Get Data How to Get More Data Modelling Data Adding Relationships Manually Visualization Visualization Customization More Visualizations Visualization Format and Analytics Ask a Question Your Advanced Dashboard with Real Live Data Real World Example Get Data Modelling Data Visualization with multiple charts Publishing Power BI Website Course Bounses FINAL Key Features Accredited by CPD Instant e-certificate Fully online, interactive course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Accreditation All of our courses are fully accredited, including this Power BI course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Power BI course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by CPD Quality Standards Requirements No prior degree or experience is required to enrol in this course. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

Microsoft Office 2016 Complete Course Course Overview: The "Microsoft Office 2016 Complete Course" is designed to provide learners with comprehensive knowledge and essential skills in the core Microsoft Office applications. This course offers in-depth coverage of Microsoft Word, Excel, PowerPoint, Outlook, and Access, enabling participants to confidently use these programs in professional environments. By the end of the course, learners will be equipped to create, manage, and analyse documents, spreadsheets, presentations, emails, and databases with proficiency. This course is an invaluable resource for those looking to enhance their productivity and improve their digital skills, making them more competitive in the job market. Course Description: The "Microsoft Office 2016 Complete Course" delves into the key functionalities of Microsoft Office, with modules dedicated to each major application. Learners will explore the features of Word for document creation and editing, Excel for data analysis and management, PowerPoint for effective presentations, Outlook for email and calendar management, and Access for database handling. Each module is structured to help learners understand the software’s core functions and how to apply them in real-world scenarios. Upon completion, learners will have developed a strong foundation in using Office 2016, boosting their ability to operate efficiently and effectively in modern workplaces. This course is suitable for individuals seeking to increase their office productivity and streamline their daily tasks. Microsoft Office 2016 Complete Course Curriculum: Module 01: Microsoft Word 2016 Module 02: Microsoft Excel 2016 Module 03: Microsoft PowerPoint 2016 Module 04: Microsoft Outlook 2016 Module 05: Microsoft Access 2016 (See full curriculum) Who is this course for? Individuals seeking to improve their office productivity skills. Professionals aiming to advance in roles requiring Microsoft Office proficiency. Beginners with an interest in data management, communication, and office software. Those wishing to enhance their CV and increase career opportunities in administrative and support roles. Career Path: Office Administrator Executive Assistant Data Analyst Personal Assistant Administrative Support Specialist Project Coordinator

Creating a compelling social media hook for your OneNote online course can significantly boost your visibility and attract more learners. Start by crafting a message that highlights the unique benefits of your course, such as its convenience, comprehensive content, and interactive features. Use engaging visuals and testimonials to showcase the value of your course. Leverage the power of storytelling to connect with your audience on an emotional level, making the learning experience relatable and desirable. Tailor your message to fit the platform you're using; for instance, a short and catchy hook for Twitter, a visually appealing post for Instagram, or a detailed and informative article for LinkedIn. Remember to include a clear call-to-action, encouraging potential students to sign up or learn more. By combining these elements, you can create a social media hook that resonates with your target audience and sets your OneNote course apart from the competition.

Microsoft Excel is more than just rows and columns — it's a powerhouse for professionals who know how to make it work for them. This course zeroes in on four of Excel’s most essential lookup functions: VLOOKUP, XLOOKUP, MATCH, and INDEX. Whether you're reconciling data, building dynamic reports, or navigating large spreadsheets, these tools save time, reduce errors, and make you look like you actually enjoy spreadsheets — even if you don’t. You'll learn how each function behaves, when to use one over the other, and how to string them together to achieve powerful results. The course is designed for learners who want to use Excel efficiently, without getting buried in formulas that behave like they’ve had too much coffee. With clear explanations, useful examples, and a touch of logic that even your sleep-deprived Monday brain can follow, this course gets straight to the point. If you've ever stared at a dataset wondering where to begin, you're in the right place — no fluff, just formulas that do the heavy lifting. Learning Outcomes: Utilise Vlookup and Xlookup to retrieve data efficiently Understand how to use Match and Index functions Learn to compare and match large data sets Automate data processing and analysis Improve data accuracy and reliability Increase productivity and save time on manual calculations Course Curriculum: 1.1 Excel vlookup 1.2 Excel xlookup 1.3 Excel vlookup 1.4 Excel vlookup 1.5 Excel vlookup 1.6 Excel vlookup 1.7 Excel vlookup 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? 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 Data Analyst (£26,000 - £45,000) Financial Analyst (£25,000 - £50,000) Business Analyst (£26,000 - £52,000) Accountant (£22,000 - £48,000) Operations Manager (£24,000 - £61,000) Project Manager (£29,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.

Ready to dive into the numbers without getting buried in them? This course offers a smart introduction to the world of business analytics using SASS — a widely respected tool in the data analysis landscape. Whether you're navigating spreadsheets or spreadsheets are navigating you, this course will help you make sense of the noise and focus on what matters: informed decisions based on accurate analysis. You'll explore key analytics techniques through SASS that help organisations stay ahead in a data-driven marketplace. Designed for those with an interest in decoding business performance, the course walks you through data manipulation, statistical reporting, and pattern identification using SASS. With each module, you'll gain clarity in how data speaks and how to interpret it without needing a PhD in number crunching. It’s approachable, strategic, and ideal for anyone curious about data-driven business decisions — minus the complicated jargon or tangled cables. Learning Outcomes: Understand the basics of SAS data analysis Work with SAS datasets and raw data files Use option statements, ODS statements, and date functions to streamline data analysis Learn how to use multiple SAS datasets to enhance data analysis Develop effective data analysis strategies using SAS Our Business Analytics for Beginners Using SAS course is designed to help you gain a deeper understanding of data analysis using SAS. With 13 comprehensive modules, you will learn how to work with SAS datasets and raw data files, use option statements and ODS statements to streamline your data analysis process, and use date functions to analyse time-based data. You will also learn how to use multiple SAS datasets to enhance your data analysis and develop effective data analysis strategies using SAS. This course is perfect for recent graduates, entry-level data analysts, and professionals looking to enhance their data analysis skills. Whether you're just starting out in the world of data analysis or are an experienced professional looking to take your skills to the next level, this course will provide you with the tools you need to succeed. Business Analytics for Beginners Using SASS Course Curriculum Section 01: Introduction Section 02: SAS Dataset Section 03: Raw Data File Standard And Example Section 04: Raw Data File Non Standard Section 05: Append Section 06: Option Statements Section 07: Title n Foot Note Section 08: ODS statements Section 09: Date Functions Section 10: Multiple SAS datasets Section 11: Select Group Section 12: Do Loop Section 13: Array 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? Recent graduates looking to start a career in data analysis Entry-level data analysts looking to enhance their skills Professionals looking to transition into the field of data analysis Business owners looking to gain a deeper understanding of data analysis Students looking to explore the field of data analysis Career path Data Analyst: £25,000 - £40,000 Business Analyst: £30,000 - £55,000 Marketing Analyst: £25,000 - £45,000 Data Scientist: £40,000 - £80,000 Senior Business Analyst: £50,000 - £90,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.

Microsoft Excel 2021 has quietly slipped in a bundle of new functions that can turn even the most mundane spreadsheets into efficient data-processing machines. This course introduces the latest features like XLOOKUP, LET, FILTER, SEQUENCE, and TEXTSPLIT, which not only simplify formulas but make spreadsheets smarter and tidier. Whether you’re an analyst trying to avoid circular references or someone who’s simply tired of tangled VLOOKUPs, this course brings clarity to your cells—no pun intended. Tailored for Excel users who know the ropes but want to keep up with what's new, this course ensures you don’t fall behind the curve. You’ll explore function upgrades that tidy up old formulas, save time, and help you work cleaner and quicker. With a thoughtful structure and a lightly witty tone, the course content walks you through updates that genuinely make a difference—without drowning you in geek speak. Excel’s had a makeover, and it's about time your formulas caught up. Learning Outcomes: Understand the purpose and benefits of new Excel functions. Apply the RANDARRAY function to generate random data. Use the UNIQUE function to extract unique values from a data range. Create custom number sequences with the SEQUENCE function. Sort data effectively with the SORT and SORTBY functions. Filter data easily with the FILTER function. Unlock the full potential of Microsoft Excel with our new course, "The Theory of Constraints and Throughput Accounting." In just a few modules, you'll learn how to utilise the latest functions in Excel to quickly sort, filter, and analyse data. By the end of the course, you'll be equipped with the knowledge to efficiently organise even the most complex datasets. But this course isn't just about learning new functions - it's about applying them to real-world scenarios. With practical examples and exercises throughout the course, you'll learn how to use these functions in meaningful ways. The benefits of this course are clear: increased productivity, better data analysis, and more efficient workflow. Don't miss out on this opportunity to take your Excel skills to the next level - enroll in "The Theory of Constraints and Throughput Accounting" today. 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? 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 completing the Functional Maths Training Course, you can venture into diverse job opportunities across various industries, encompassing positions and pay scales that include: Data Analyst - £31,000 per year (average salary) Financial Analyst - £34,000 per year (average salary) Business Intelligence Analyst - £39,000 per year (average salary) 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.

Dive into the numbers that shape today’s business decisions with our Learn Financial Analytics and Statistical Tools Course. This online course is designed to help you explore financial patterns, trends, and performance indicators using statistical techniques. Whether you're assessing company performance or examining market behaviour, this course sharpens your analytical thinking and equips you with tools commonly used in financial reporting, forecasting, and data-driven decision-making. You'll explore concepts such as regression, time series analysis, risk modelling, and data interpretation—without needing a maths degree or a calculator the size of a dinner plate. Ideal for finance professionals, analysts, business students, or anyone curious about what the numbers really mean, this course brings clarity to the complex. Learn at your pace, from wherever you are, and give your understanding of financial data the polish it deserves—minus the jargon and dry lectures. Learning Outcomes: Understand the fundamentals of statistical tools and their applications in finance. Analyze financial data using statistical tools such as trimmed mean, geometric mean, and standard deviation. Interpret financial data with a deeper understanding of concepts such as mode, max and min value, and exponential absolute and log. Apply statistical tools to real-world financial scenarios for effective decision-making. Utilize Excel functions such as Sum Product and Sum If for financial analysis. "Learn Financial Analytics and Statistical Tools" is a comprehensive course bundle that equips learners with the knowledge and skills necessary to navigate the complex world of finance. This course covers a range of statistical tools, including trimmed mean, geometric mean, standard deviation, mode, max and min value, and exponential absolute and log. Through real-world examples and Excel functions, learners will develop the ability to analyze and interpret financial data, making effective decisions with confidence. This course bundle is ideal for anyone looking to advance their career in finance, accounting, or data analysis, or those who simply want to gain a deeper understanding of statistical tools and their applications in finance. ⊱⊱ Learn Financial Analytics and Statistical Tools Course Curriculum Section 01: Introduction Introduction to Statistical Tool Section 02: Getting Started Statistical Tool Trimmed Mean Geometric Mean What is Mode Max and Min Value Standard Deviation Sum Product and Sum If Exponential Absolute and Log Section 03: Example Example 1 Example 2 Example 3 Example 4 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? Finance professionals looking to enhance their data analysis skills. Accounting professionals seeking to gain a deeper understanding of financial data. Data analysts interested in applying statistical tools to financial data. Business owners and entrepreneurs seeking to make informed financial decisions. Students and individuals looking to develop a valuable skill set in finance and data analysis. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Financial Analyst: £25,000 - £70,000 Data Analyst: £24,000 - £60,000 Accountant: £20,000 - £50,000 Business Analyst: £25,000 - £65,000 Financial Manager: £30,000 - £100,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.

Unlock the power of numbers in ways your school textbooks never quite managed. This Math Tricks & Shortcuts Course is designed for anyone who wants to calculate faster, think sharper, and impress their friends—or their spreadsheets—with mental maths wizardry. From simple tips for everyday arithmetic to clever techniques used by competitive exam-takers, this course turns number crunching into second nature. You'll discover speedy solutions for addition, subtraction, multiplication, division, percentages, and more—all explained with clarity and a touch of cleverness. Whether you're revising for exams, brushing up on rusty skills, or simply curious about how maths can be easier (and a lot more fun), this course makes your calculator feel like it’s just along for the ride. All content is delivered online, so you can learn at your own pace—no chalkboards required. Learning outcomes: Gain knowledge of various math tricks and shortcuts to solve complex problems quickly. Develop skills to solve geometry problems with ease. Understand the concepts of unit digits and how to use them to simplify calculations. Learn how to simplify complex problems using digital sums. Gain proficiency in solving time, work, and distance-related problems. The Geometry module of this course teaches the students about the different areas and mensuration of 2-dimensional figures, and the practice test helps to test their knowledge of the subject. The course also teaches students about the concept of the unit digit and how it can be used to simplify calculations. The Simplification Problems module teaches students various tricks and techniques to simplify complex problems, and the Practice Test helps to evaluate their understanding. The Time and Work, Pipes and Cisterns, Speed, Distance and Time, and Boats and Streams modules of this course teach students various tricks and shortcuts to solve problems related to these topics. The course also includes practice tests to help students assess their knowledge and understanding of the topics. 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 15 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 The Math Tricks & Shortcuts course can be useful for anyone who wishes to improve their math skills, speed, and accuracy. Additionally, this course can also benefit professionals who work with numbers, such as accountants, bankers, and data analysts. Accountant: £21,000 - £50,000 Banker: £18,000 - £65,000 Data Analyst: £24,000 - £50,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.

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.