53 Spreadsheet courses in London

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

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

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Businesses that don't control their costs don't stay in business. How well are you doing? Is everyone in your organisation sufficiently aware of costs, managing them effectively and maximising opportunities to reduce them? If there is scope for improvement, this course will help get you back on track. It will demonstrate that cost reduction is so much more than cost control and cost cutting. True cost management is about being aware of costs, seeking to reduce them through good design and efficient operating practices whilst taking continuing action on overspending. This course will develop the participants' skills in: Being aware of costs at all times Seeking cost reduction from the start (including life-cycle costing) Appraising projects / production to identify and take out risk Understanding real budgeting Using techniques such as ZBB and ABC where appropriate Ensuring cost reports lead to action Managing a cost reduction process that delivers Benefits to the organisation will include: Identification of cost reduction and business improvement opportunities Better reporting and ownership of costs Greater awareness and control of everyday costs 1 Introduction - the cost management process The risks of poor cost control Capital and revenue costs The importance of cost awareness The importance of cost reduction Cost management - the key aspects How to build a cost management and control process checklist for your areas of responsibility 2 Cost removal - taking out costs Cost awareness Costs of poor design / poor processes Value engineering Removing redundant costs 3 The need for commercial, technical and financial appraisals Understand the problems before cash is committed and costs incurred Making the effort to identify commercial and technical risk The time value of money - DCF techniques for long term projects Cost models for production processes and projects Costing models - project appraisals The use of spreadsheets to identify sensitivity and risk How to focus on risk management 4 Budgeting - proper budgeting challenges costs The philosophy of the business - are costs an issue? The importance of having the right culture The need for detailed business objectives Budgetary control measures Designing budget reports - for action 5 Zero-based budgeting (ZBB) - the principles Much more than starting with a clean sheet of paper What ZBB can achieve The concept of decision packages - to challenge business methods and costs Only necessary costs should be incurred A review of an operating budget - demonstrating what ZBB challenges and the costs it may lead to being taken out 6 Awareness of overheads and other costs Definitions of cost - direct and indirect Dealing with overheads - what is meant by allocation, absorption or apportionment? The apparent and real problems with overheads Different ways of dealing with overheads Review of overhead allocation methods and accounting and reporting issues 7 Overheads and product costing Activity-based costing (ABC) - the principles Where and how the ABC approach may be helpful Know the 'true' cost of a product or a project Should you be in business? Will you stay in business? Identifying weaknesses in a traditional overhead allocation How ABC will help improve product or service costing Identifying which products and activities should be developed and which abandoned 8 Cost reduction culture The need for cost reports What measures can be used to identify over-spends as early as possible Cost control performance measures and ratios 9 Design of cost control reports Reports should lead to action and deliver Selecting cost control measures which can be acted upon Practice in designing action reports 10 Course summary - developing your own cost action plan Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs

This 3 Days programme will equip you to use, price, manage and evaluate interest rate and cross-currency derivatives. The course starts with the building blocks of money markets and futures, through yield curve building to interest-rate and cross-currency swaps, and applications. The approach is hands-on and learning is enhanced through many practical exercises covering hedging, valuation, and risk management. This course also includes sections on XVA, documentation and settlement. The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation.

Overview Interest Rate Options are an essential part of the derivatives marketplace. This 3-Day programme will equip you to use, price, manage and evaluate interest rate options and related instruments. The course starts with a detailed review of option theory, from a practitioner’s viewpoint. Then we cover the key products in the rates world (caps/floors, swaptions, Bermudans) and their applications, plus the related products (such as CMS) that contain significant ’hidden’ optionality. We finish with a detailed look at the volatility surface in rates, and how we model vol dynamics (including a detailed examination of SABR). The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Course Duration: Half-day or full-day (can also be delivered as a 3-part virtual workshop series) Target Audience: Professionals in non-technical roles (e.g. executive assistants, HR, marketing, project managers, operations staff, trainers, and admin support) who want to use generative AI to enhance their work—without needing coding skills. Course Objectives By the end of this course, participants will be able to: Understand what generative AI is and how it works in plain language. Identify use cases relevant to their role or industry. Use popular generative AI tools (like ChatGPT, Gemini, and Copilot) confidently. Write effective prompts to get better, more relevant results. Apply AI ethically and responsibly in the workplace. Course Outline Module 1: Demystifying Generative AI What is generative AI? (Plain language explanation) How AI models like ChatGPT, Copilot, and Gemini work Examples of what generative AI can (and can’t) do Myths, risks, and benefits of AI in non-tech roles Module 2: Everyday Use Cases for Professionals Time-saving applications: Drafting emails, reports, meeting summaries Creating checklists, plans, or SOPs Enhancing creativity: Brainstorming ideas for events, campaigns, or training Writing social media posts, newsletters, or job ads Organising information: Summarising documents Structuring spreadsheets or creating templates Supporting communication: Improving tone and clarity Translating or simplifying content Module 3: Prompting Essentials What is a “prompt” and why does it matter? How to write clear, specific, and effective prompts Prompting frameworks (e.g., “Role–Task–Goal” method) Live practice: transforming a vague prompt into a powerful one Troubleshooting: when AI gives poor answers and how to improve them Module 4: Hands-On Exploration Try-it-yourself exercises using ChatGPT or Gemini (guided) Real workplace examples and team challenges Create an AI-generated email, checklist, or idea list Optional: use industry-specific examples (e.g., HR, admin, events, comms) Module 5: Responsible AI Use at Work Understanding AI limitations and biases Protecting privacy and sensitive data When not to use AI Workplace policies and guidelines (customisable for your organisation) Ethical use: attribution, transparency, and human review Module 6: Getting Started in Your Role Tools overview: free vs paid options (ChatGPT, Microsoft Copilot, Gemini) Building your own AI toolkit Tips for staying up to date as tools evolve 30-day challenge: how to build AI into your daily workflow Delivery Style Highly interactive, practical, and low-jargon No coding or tech background required Hands-on demos, guided practice, and scenario-based activities Group discussion and peer learning Course Materials Provided Quick-start guide: Top 10 prompts for non-tech roles AI Prompt Library for your job type Do’s and Don’ts for ethical use of AI at work “AI in Action” workbook with examples and checklists Personal AI Action Plan Optional Add-ons Team-based AI hackathon (mini workplace challenge) Tailored follow-up webinar for Q&A and deeper use cases Co-branded playbook for organisational AI use Integration with digital transformation or innovation initiatives

Course Duration: Half-day or full-day (can also be delivered as a 3-part virtual workshop series) Target Audience: Professionals in non-technical roles (e.g. executive assistants, HR, marketing, project managers, operations staff, trainers, and admin support) who want to use generative AI to enhance their work—without needing coding skills. Course Objectives By the end of this course, participants will be able to: Understand what generative AI is and how it works in plain language. Identify use cases relevant to their role or industry. Use popular generative AI tools (like ChatGPT, Gemini, and Copilot) confidently. Write effective prompts to get better, more relevant results. Apply AI ethically and responsibly in the workplace. Course Outline Module 1: Demystifying Generative AI What is generative AI? (Plain language explanation) How AI models like ChatGPT, Copilot, and Gemini work Examples of what generative AI can (and can’t) do Myths, risks, and benefits of AI in non-tech roles Module 2: Everyday Use Cases for Professionals Time-saving applications: Drafting emails, reports, meeting summaries Creating checklists, plans, or SOPs Enhancing creativity: Brainstorming ideas for events, campaigns, or training Writing social media posts, newsletters, or job ads Organising information: Summarising documents Structuring spreadsheets or creating templates Supporting communication: Improving tone and clarity Translating or simplifying content Module 3: Prompting Essentials What is a “prompt” and why does it matter? How to write clear, specific, and effective prompts Prompting frameworks (e.g., “Role–Task–Goal” method) Live practice: transforming a vague prompt into a powerful one Troubleshooting: when AI gives poor answers and how to improve them Module 4: Hands-On Exploration Try-it-yourself exercises using ChatGPT or Gemini (guided) Real workplace examples and team challenges Create an AI-generated email, checklist, or idea list Optional: use industry-specific examples (e.g., HR, admin, events, comms) Module 5: Responsible AI Use at Work Understanding AI limitations and biases Protecting privacy and sensitive data When not to use AI Workplace policies and guidelines (customisable for your organisation) Ethical use: attribution, transparency, and human review Module 6: Getting Started in Your Role Tools overview: free vs paid options (ChatGPT, Microsoft Copilot, Gemini) Building your own AI toolkit Tips for staying up to date as tools evolve 30-day challenge: how to build AI into your daily workflow Delivery Style Highly interactive, practical, and low-jargon No coding or tech background required Hands-on demos, guided practice, and scenario-based activities Group discussion and peer learning Course Materials Provided Quick-start guide: Top 10 prompts for non-tech roles AI Prompt Library for your job type Do’s and Don’ts for ethical use of AI at work “AI in Action” workbook with examples and checklists Personal AI Action Plan Optional Add-ons Team-based AI hackathon (mini workplace challenge) Tailored follow-up webinar for Q&A and deeper use cases Co-branded playbook for organisational AI use Integration with digital transformation or innovation initiatives