SpreedSheets

Apply Now
  • Course Duration3 months
  • Learning FormatFlexible Learning
  • Course Fee£ 125 GBP

Course Overview

The Spreadsheets with Microsoft Excel course is designed to give learners comprehensive, job-ready skills in data handling, analysis, and reporting using Excel—one of the most in-demand tools in business, finance, administration, and data-driven roles. Whether you are looking to build professional spreadsheets from scratch or upgrade your Excel knowledge for business use, this course walks you through formulas, functions, data management, visualisation, PivotTables, automation, and more. Delivered through hands-on exercises and a final capstone project, you’ll gain real experience applying Excel to solve practical problems in workplace scenarios.

Course Curriculum

5 lessons 48 hours
  • Overview of Excel layout, workbook and worksheet management, data entry, and basic navigation.
  • Formatting cells, numbers, dates, text alignment, and applying styles.
  • Using arithmetic formulas, SUM, AVERAGE, MIN, MAX, and basic functions for calculations.
  • Creating tables, sorting, filtering, and data validation techniques.
  • Logical functions (IF, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH), and text functions.
  • Creating and customizing charts: column, line, pie, bar, scatter, and combo charts.
  • Building PivotTables for data summarization and PivotCharts for dynamic visual analysis.
  • Using Goal Seek, Data Tables, and Scenario Manager for decision making.
  • Recording and running macros, basic VBA introduction, and automating repetitive tasks.
  • Developing a full spreadsheet project applying formulas, data analysis, visualization, and pivot tables.

Skills Covered

  • • Spreadsheet navigation and interface mastery
  • • Cell formatting and data organisation
  • • Formula and function writing (basic to advanced)
  • • Data sorting, filtering, validation, and structuring
  • • Visualisation with charts and graphs
  • • PivotTable creation and dynamic dashboards
  • • What-If analysis for forecasting and modelling
  • • Macro recording and task automation
  • • Real-world spreadsheet project design

Why join this program?

  • • Gain essential Excel skills used in every industry.
  • • Learn by doing through step-by-step exercises and practical scenarios.
  • • Develop spreadsheet models you can use in finance, HR, marketing, operations, and more.
  • • Suitable for beginners, professionals, administrators, and career switchers.
  • • Taught using UK-based business and data use cases.
  • • Build a strong Excel portfolio for interviews, promotions, and freelance work.

Course Objectives/key Features

  • • Fully online, self-paced course.
  • • 10 expert-designed modules with practical assignments.
  • • Downloadable Excel templates and datasets.
  • • Interactive activities and formula challenges.
  • • Tutor support and peer interaction via forums.
  • • Capstone project simulating a real business case.

Learning Outcomes

By the end of this course, learners will be able to:
  • • Create, format, and manage Excel workbooks with confidence.
  • • Use Excel functions to analyse, clean, and manipulate data.
  • • Build and style simple websites.
  • • Visualise data using charts, graphs, and dashboards.
  • • Implement advanced logic and lookup formulas.
  • • Automate routine tasks with macros.
  • • Apply Excel techniques to real-world data projects.

Why Choose London Technology College?

  • • Open to All – Whether you're brand new or brushing up your skills, our courses are designed to meet you where you are.
  • • Practical Approach – Learn by doing, with hands-on exercises that reflect real-world office tasks.
  • • Experienced Tutors – Our instructors bring real industry know-how and a passion for teaching.
  • • Certificate of Completion – Add an accredited certificate to your CV or LinkedIn profile to boost your job prospects.
  • • Flexible Learning Options – Study at your own pace, from anywhere in the world. Ideal for working professionals and international students seeking flexibility without compromising quality.
  • • Job-Ready Skills – Get trained in tools and techniques that employers actually look for.
  • • Support That Stays With You – Need help? Our team is here from start to finish—no question is too small.
  • • Learn at Your Own Pace – Take your time or move quickly—the course is designed to adapt to your needs.
  • • Hands-On Projects – Put your skills into action with tasks like reports, spreadsheets, resumes, and more

Certificate of Completion

Upon completing the course and final project, you will receive a Certificate of Completion from London Technology College. This certificate is an excellent addition to your professional profile and demonstrates your applied Excel competency to employers or clients.

Earn Your Certificate in Software Program:

  • • Build and format professional-grade spreadsheets.
  • • Apply complex formulas and functions to real-world data.
  • • • Create clear and compelling charts and dashboards.
  • • Use PivotTables for advanced data summarisation.
  • • Automate tasks using macros.
  • Your certificate can support career advancement, job applications, or consulting opportunities.

Frequently Asked Questions (FAQs)

Yes! It starts from the basics and builds up to advanced functions step-by-step.

Yes, you’ll need Microsoft Excel (2016 or later). We help online students get setup.

Yes, you will get a Certificate of Completion from London Technology College.

Absolutely! Excel is one of the top skills in admin, finance, HR, and tech support roles.

Yes. This course covers many of the skills required for Microsoft Office Specialist certification.

Yes, Microsoft Excel is required. The course supports Excel 2016 or later, including Office 365. A trial version is acceptable.

Absolutely. The course includes practical skills and templates you can immediately apply in real projects.

Yes. The capstone project involves building a complete, functional spreadsheet solution that integrates all the skills learned.