Excel Courses Portsmouth
Excel Courses Portsmouth
November 7, 2026 Comments Off on Excel Courses PortsmouthExcel Courses Portsmouth
Live 1-on-1 online Excel training in English. Flexible scheduling, start anytime from Portsmouth.
Enquire NowExcel Training in Portsmouth — Online & Flexible
Portsmouth is a major port city with a diverse economy spanning defence, maritime, and technology. The city’s strong naval and defence sector alongside its growing digital economy are driving demand for IT and technology skills across a wide range of organisations.
School of IT offers live, 1-on-1 online Excel training in English. All sessions are delivered by an experienced trainer via MS Teams or Google Meet, with flexible scheduling so you can build your skills around your existing commitments from Portsmouth.
Excel Fundamentals
Learn Excel from scratch — formatting, formulas, functions, charts, and working with data professionally. The fastest path from no Excel knowledge to confident everyday use.
- ✓Excel interface, navigation, and workbook management
- ✓Formatting — cells, tables, conditional formatting, and number formats
- ✓Essential formulas — SUM, AVERAGE, IF, VLOOKUP, and COUNT
- ✓Charts — bar, line, pie, and creating professional-looking visuals
- ✓Sorting, filtering, and working with data tables in Excel
Intermediate Excel
Go beyond the basics — advanced formulas, pivot tables, data validation, named ranges, and working with large datasets efficiently.
- ✓Advanced formulas — XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, and IFS
- ✓Pivot tables and pivot charts — summarising and exploring data
- ✓Data validation — drop-down lists, input messages, and error alerts
- ✓Named ranges, structured table references, and formula auditing
- ✓Working with large datasets — filtering, sorting, and removing duplicates
Excel for Data Analysis
Use Excel as a professional data analysis tool — Power Query for data cleaning, advanced pivot tables, statistical functions, and building analytical dashboards.
- ✓Power Query — connecting to data sources and automating data cleaning
- ✓Advanced pivot tables — calculated fields, grouping, and slicer connections
- ✓Statistical functions — STDEV, CORREL, FORECAST, and RANK
- ✓What-if analysis — Goal Seek, Scenario Manager, and Data Tables
- ✓Building professional analytical dashboards in Excel
Excel VBA & Automation
Automate Excel with VBA macros — recording macros, writing VBA code, automating reports, building user forms, and creating custom Excel tools.
- ✓Recording and editing macros — the VBA Editor and macro security
- ✓VBA fundamentals — variables, loops, conditions, and procedures
- ✓Working with workbooks, worksheets, ranges, and cells in VBA
- ✓Automating repetitive tasks — data processing, formatting, and report generation
- ✓User forms — building custom data entry and reporting interfaces
Excel Power Pivot & BI
Build Excel business intelligence solutions — Power Pivot, DAX, data models, and professional dashboards connected to multiple data sources.
- ✓Power Pivot — enabling and working with the data model
- ✓Relationships and star schema design in Power Pivot
- ✓DAX in Excel — calculated columns, measures, and KPIs
- ✓Connecting multiple data sources — SQL, CSV, and SharePoint
- ✓Building executive dashboards with Power Pivot, charts, and slicers
Excel Master Programme
The complete Excel education — fundamentals, intermediate, data analysis, VBA automation, and Power Pivot BI in one comprehensive programme.
- ✓Excel fundamentals — formulas, formatting, charts, and data management
- ✓Intermediate Excel — XLOOKUP, pivot tables, and large dataset management
- ✓Excel for data analysis — Power Query, statistics, and dashboards
- ✓VBA and automation — macros, user forms, and custom Excel tools
- ✓Power Pivot and BI — data modelling, DAX, and executive reporting
What You Will Learn
- ✓Build professional Excel spreadsheets with correct formatting and structure
- ✓Write advanced formulas — XLOOKUP, INDEX/MATCH, SUMIFS, and nested IF
- ✓Create pivot tables and pivot charts to summarise and explore data
- ✓Clean and transform data with Power Query for reliable, automated reporting
- ✓Automate repetitive tasks with VBA macros and custom user forms
- ✓Build executive dashboards combining charts, pivot tables, and slicers
- ✓Use Power Pivot and DAX to create multi-source data models in Excel
- ✓Apply Excel to financial analysis, data reporting, and business intelligence
Compare Excel Courses
| Course | Price | Duration | Level |
|---|---|---|---|
| Excel Fundamentals | £549 | 10h | Beginner |
| Intermediate Excel | £599 | 10h | Intermediate |
| Excel for Data Analysis | £749 | 10h | Intermediate |
| Excel VBA & Automation | £849 | 20h | Advanced |
| Excel Power Pivot & BI | £849 | 20h | Advanced |
| Excel Master Programme | £1,249 | 40h | Advanced |
Excel Courses Portsmouth — FAQs
Yes — all our Excel courses are delivered 100% online via MS Teams or Google Meet. You study from Portsmouth with an experienced Excel trainer at a time that suits you.
If you are new to Excel or use it only at a basic level, start with Excel Fundamentals (10 hours, £549). If you already use Excel regularly, start with Intermediate Excel and move straight to data analysis or VBA. The Master Programme (40 hours, £1,249) covers the complete Excel skill set.
We work with Microsoft 365 Excel (the subscription version), which includes Power Query, XLOOKUP, and all modern features. If you use an older version (Excel 2016/2019), let us know and we will advise on any limitations. Excel Online (the browser version) is not recommended for the more advanced courses.
Beginner and intermediate courses are each 10 hours. Advanced courses (VBA, Power Pivot) are each 20 hours. The Master Programme is 40 hours. All are 1-on-1 with flexible scheduling from Portsmouth.
Excel courses start at £549 for Excel Fundamentals, ranging up to £1,249 for the Master Programme. All prices are in GBP.
Absolutely — Excel remains one of the most widely used business applications in the world. In Portsmouth and across the UK, proficiency in Excel is required or expected for a wide range of roles in finance, accounting, operations, HR, marketing, and data analysis. Advanced Excel skills — pivot tables, Power Query, and VBA — command a significant premium in the job market.
Start Your Excel Training Today
Live 1-on-1 online instruction in English. Flexible scheduling. Start anytime from Portsmouth.
Enquire Now →
