Excel Courses Groningen
Excel Courses Groningen
November 4, 2026 Comments Off on Excel Courses GroningenExcel Courses Groningen
Groningen is a growing university and energy technology city with a diverse economy spanning healthcare, academia, and industry. Excel skills are in demand across the region’s research institutions, commercial organisations, and public sector bodies — where the ability to manage and analyse data, build dashboards, and automate workflows with macros is increasingly expected at all levels.
School of IT offers live, 1-on-1 online Excel training in English — from absolute beginners through to advanced users who need to work with Power Query, dynamic array formulas, VBA macros, and Microsoft 365 integration. All sessions are delivered by a real Excel trainer via MS Teams or Google Meet, with flexible scheduling so you can study around your existing commitments from Groningen.
Excel Fundamentals
Build a solid foundation in Microsoft Excel — navigate worksheets, enter and format data, use essential formulas and functions, and create basic charts and reports.
- Navigate Excel’s interface — worksheets, ribbons, cell references, and workbook structure
- Enter, format, and validate data using data types, number formats, and validation rules
- Essential formulas — SUM, AVERAGE, COUNT, IF, VLOOKUP, and cell referencing
- Create and format charts — bar, line, pie, and combination charts
- Print and share workbooks — page setup, print areas, and sharing options
Excel Intermediate
Take Excel to the next level — work with PivotTables, intermediate lookup functions, conditional formatting, and start building structured data models for business reporting.
- PivotTables and PivotCharts — summarise, group, and visualise large datasets
- Intermediate functions — XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, and AVERAGEIFS
- Conditional formatting — highlight cells, data bars, colour scales, and icon sets
- Named ranges, tables, and structured references for organised data management
- Protecting workbooks, sheets, and cells for secure data sharing
Excel Advanced
Master advanced Excel features — dynamic array formulas, Power Query for data transformation, complex financial and statistical functions, and Excel dashboards.
- Dynamic array formulas — FILTER, SORT, UNIQUE, SEQUENCE, XLOOKUP, and spill ranges
- Power Query — connect to data sources, transform and reshape data, and automate refresh
- Financial functions — NPV, IRR, PMT, FV, and financial modelling best practices
- Statistical functions — STDEV, FORECAST, regression analysis, and what-if scenarios
- Dashboard design — slicers, timelines, dynamic charts, and interactive reporting
Excel for Data Analysis
Use Excel as a powerful data analysis platform — data cleaning, advanced PivotTables, statistical analysis, and connecting Excel to external databases and business systems.
- Data cleaning and transformation — removing duplicates, handling blanks, text functions
- Advanced PivotTables — calculated fields, grouping, slicers, and multiple data sources
- Data analysis tools — Goal Seek, Solver, Scenario Manager, and Data Tables
- Statistical analysis — regression, correlation, histograms, and descriptive statistics
- Power Query M language basics — custom transforms and automated data pipelines
Excel VBA & Macros
Automate Excel with VBA macros — record and write macros, build custom functions, create automated reporting solutions, and interact with other Office applications.
- VBA fundamentals — the editor, variables, data types, loops, and conditional logic
- Working with Excel objects — Workbooks, Worksheets, Ranges, Cells, and Charts
- Recording and editing macros — automating repetitive tasks and formatting sequences
- Custom functions (UDFs) — build reusable functions for formulas and reports
- Automating reports — generating reports from data, interacting with Word and Outlook
Excel Master Programme
The complete Excel Master Programme — advanced formulas, Power Query, Power Pivot, VBA automation, financial modelling, and Excel integration with Microsoft 365 and Power BI.
- Complete advanced formula library — dynamic arrays, text, date, and financial functions
- Power Query and Power Pivot — data modelling, DAX measures, and large dataset analysis
- VBA automation — custom macros, event-driven programming, and UI forms
- Financial modelling — DCF models, sensitivity analysis, scenario planning, and dashboards
- Excel and Microsoft 365 integration — Power BI, SharePoint, and Teams connectivity
What You Will Learn
Our Excel courses take you from building your first workbook through to deploying advanced analytics dashboards, automated VBA solutions, and Power BI-connected Excel models. By the end of the programme you will be able to:
- Build structured Excel workbooks with data validation, named ranges, and table references
- Write essential formulas — IF, VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, and dynamic arrays
- Summarise and analyse large datasets using PivotTables, PivotCharts, slicers, and timelines
- Transform and clean data using Power Query and the M language
- Build Excel dashboards with interactive charts, conditional formatting, and dynamic reports
- Perform financial and statistical analysis using Excel’s built-in analytical tools
- Automate repetitive tasks and build custom solutions with VBA macros and user-defined functions
- Connect Excel to external data sources, Microsoft 365 services, and Power BI
Compare Excel Courses
Choose the course that fits your current skill level and professional goals:
| Course | Price | Duration | Level |
|---|---|---|---|
| Excel Fundamentals | €694 | 10h | Beginner |
| Excel Intermediate | €748 | 10h | Beginner–Intermediate |
| Excel Advanced | €909 | 20h | Intermediate |
| Excel for Data Analysis | €909 | 20h | Intermediate–Advanced |
| Excel VBA & Macros | €1016 | 20h | Advanced |
| Excel Master Programme | €1549 | 40h | Advanced |
Excel Courses Groningen — FAQs
Yes — all our Excel courses are delivered 100% online via MS Teams or Google Meet. You study from Groningen (or anywhere with internet access) with a qualified, experienced Excel trainer. Sessions are booked at a time that suits you — there are no fixed class times and no commuting required.
If you are new to Excel or coming back after a gap, start with Excel Fundamentals (10 hours, €694). If you already use Excel regularly and want to work with PivotTables and lookup functions, Excel Intermediate is the right next step. For professionals who need to build dashboards, use Power Query, or analyse large datasets, Excel Advanced or Excel for Data Analysis are ideal. The Excel Master Programme covers everything from advanced formulas through to VBA and Power BI integration.
No prior Excel experience is required for the Excel Fundamentals course. For intermediate and advanced courses, some existing experience with Excel formulas and basic worksheets is recommended. When you enquire we will help you identify the right starting point based on what you currently know and what your work requires.
The Fundamentals and Intermediate courses are each 10 hours. The Advanced, Data Analysis, and VBA & Macros courses are 20 hours each. The Excel Master Programme is 40 hours and covers the full skill range from advanced formulas to VBA and Power BI integration. Because training is 1-on-1, you can progress at your own pace.
Excel courses start at €694 for the Fundamentals course. The range runs from €694 to €1549 for the Master Programme. All prices are in EUR. Payment plans are available on selected courses — ask when you enquire.
Yes — you will receive a School of IT certificate of completion after finishing your Excel course. Our courses also prepare you to sit the Microsoft Office Specialist (MOS) Excel certification, which is an industry-recognised credential that you can add to your CV and LinkedIn profile. The MOS exam is booked separately through a Microsoft testing centre.
Advanced Excel skills are relevant to a wide range of roles: Financial Analyst, Business Analyst, Data Analyst, Accountant, Operations Manager, Project Manager, HR Analyst, Marketing Analyst, and many more. In Groningen, Excel remains one of the most consistently requested skills in job advertisements across finance, logistics, healthcare, consulting, and technology sectors.
Start Your Excel Training Today
Live 1-on-1 online instruction in English. Flexible scheduling. Start anytime from Groningen.
Enquire Now →