Our Courses
At GetDataSavvy.com, we offer a range of hands-on, expert-led courses in Excel and Power BI, designed to suit all skill levels—from complete beginners to advanced users. Whether you’re looking to master the basics, improve your data analysis, or build powerful dashboards, our small-group courses (just 4–6 learners per group) ensure personalised support and real-world learning. Each course is delivered live by an experienced industry professional, giving you the confidence to apply your new skills immediately in the workplace.
Excel Essentials for Confident Users
Take Your Excel Skills to the Next Level
Already comfortable with the basics of Excel? This intermediate Excel course is designed for professionals who want to boost productivity, streamline data tasks, and build real-world analytical skills using Excel. Over 8 weeks, you’ll learn how to confidently clean, analyse, and visualise data—skills that are essential in roles across finance, marketing, HR, operations, and more.
Whether you’re looking to save time with smarter formulas, create powerful PivotTables, or design impactful dashboards, this course gives you the tools to work more efficiently and make data-driven decisions.
This course is 2 hours per week, for 8 weeks.
Week 1: Working with Structured Data
- Learn how to manage data using Excel Tables
- Use advanced sorting and filtering techniques
- Clean and prepare data for analysis
- Best practices for organising data in Excel
Week 2: Time-Saving Formulas and Functions
- Master logical functions: IF, IFS, AND, OR
- Work with text data using TEXTJOIN, CONCAT, LEFT, RIGHT
- Build and combine nested formulas for flexible analysis
- Tips for debugging common formula errors
Week 3: Lookup and Reference Functions
- Use XLOOKUP, VLOOKUP, INDEX and MATCH like a pro
- Reference data across sheets and workbooks
- Troubleshoot and avoid common lookup issues
- Real-world examples of lookups for business data
Week 4: Working with Dates and Times
- Format and calculate with dates and time values
- Use functions like TODAY, DATEDIF, NETWORKDAYS
- Build dynamic timelines and calendars in Excel
- Automate time-based tasks for reports
Week 5: Introduction to PivotTables
- Create and customise PivotTables to summarise data
- Analyse trends, group data, and apply calculations
- Use slicers for dynamic filtering
- Gain insights from large datasets in seconds
Week 6: Data Visualisation Techniques
- Create charts that tell a story: column, line, combo, scatter
- Use conditional formatting to highlight trends
- Design simple dashboards with sparklines and visuals
- Best practices for clear, compelling reports
Week 7: Data Validation, Protection & Review Tools
- Control data input with drop-down lists and rules
- Protect workbooks and sensitive data
- Use comments, track changes, and sheet protection
- Review tools to maintain clean, accurate spreadsheets
Week 8: Final Project and Progression Pathways
- Apply everything learned in a real-world project
- Clean, analyse, and visualise a complete dataset
- Present findings with PivotTables and charts
- Get guidance on progressing to advanced Excel or Power BI
Ready to build real confidence with Excel?
This course is perfect for teams and individuals looking to go beyond the basics and start using Excel like a pro. Boost your productivity, improve your data skills, and stand out in your role.
Price: £325 per person for 8-week course
Master Advanced Excel Tools for High-Level Analysis and Automation
Ready to take your Excel skills to the expert level? This Advanced Excel course is designed for professionals who already know their way around formulas, tables, and charts—and now want to unlock the full power of Excel for business analysis, reporting, and automation.
Over 8 weeks, you’ll master advanced functions, powerful analytical tools like PivotTables and Power Query, and learn how to automate tasks with macros. By the end, you’ll be able to solve complex problems, create dynamic dashboards, and save hours on repetitive work.
This course is 2 hours per week, for 8 weeks.
Week 1: Power Functions for Smart Analysis
- Deep dive into nested IF, IFS, SWITCH, and other logical formulas
- Use ARRAY formulas and dynamic arrays (e.g. FILTER, UNIQUE, SORT)
- Apply complex text and number functions for real-world tasks
- Create powerful formulas that adapt as data changes
Week 2: Advanced Lookup Techniques
- Master INDEX & MATCH and when to use them over VLOOKUP
- Use XLOOKUP for cleaner, flexible lookups
- Handle multi-criteria lookups with advanced techniques
- Troubleshoot errors in large lookup tasks
Week 3: Working with Power Query
- Connect to multiple data sources with Power Query
- Clean and transform messy data
- Merge, append, and pivot/unpivot datasets
- Automate recurring data preparation tasks
Week 4: Advanced PivotTables and Data Analysis
- Create calculated fields and items in PivotTables
- Use PivotCharts for visual analysis
- Apply grouping, filtering, and slicers to enhance insights
- Perform year-over-year, variance, and trend analysis
Week 5: Building Interactive Dashboards
- Design user-friendly dashboards with form controls and slicers
- Link charts, formulas, and PivotTables for dynamic reports
- Use conditional formatting to highlight key metrics
- Layout best practices for executive-ready dashboards
Week 6: Introduction to Macros and VBA
- Understand how macros work and how to record them
- Create simple macros to automate repetitive tasks
- Introduction to the VBA editor and basic scripting
- Build time-saving tools with real business applications
Week 7: Auditing, Error Handling, and Data Protection
- Trace errors and audit complex formulas
- Use tools like Watch Window, Evaluate Formula, and Formula Auditing
- Lock, protect, and control user input across workbooks
- Build robust files ready for shared use
Week 8: Final Project and Expert Tips
- Complete a practical project combining Power Query, PivotTables, and macros
- Review advanced functions in a business scenario
- Share your final dashboard/report for feedback
- Guidance on continuing with Power BI or VBA development
Ready to unlock the full power of Excel?
This course is perfect for analysts, managers, and professionals who rely on Excel for deeper insights, smarter reporting, and advanced automation.
Price: £375 per person for 8-week course
Turn Raw Data Into Insightful, Interactive Reports
Power BI is one of the most powerful tools available for transforming data into clear, interactive dashboards and reports. This beginner-friendly 8-week course is designed for complete newcomers—no previous Power BI or data analysis experience required.
You’ll learn how to connect to data, clean it, build compelling visuals, and share your findings with confidence. By the end of the course, you’ll be creating dynamic dashboards that bring your data to life and support smarter business decisions.
This course is 2 hours per week, for 8 weeks.
Week 1: Introduction to Power BI
- What Power BI is and how it’s used in business
- Exploring the Power BI interface
- Understanding the difference between Power BI Desktop and Service
- Installing Power BI Desktop and getting set up
Week 2: Connecting to Data
- Importing Excel and CSV files
- Understanding data sources and file structures
- Creating basic data models
- Refreshing and managing data connections
Week 3: Cleaning and Shaping Data in Power Query
- Removing errors and blank rows
- Renaming columns, changing data types, and formatting
- Filtering, sorting, and merging datasets
- Creating reusable queries for clean data
Week 4: Building a Data Model
- Understanding relationships between tables
- Creating and managing relationships
- Using primary keys and unique identifiers
- Introduction to the data model view
Week 5: Introduction to DAX (Data Analysis Expressions)
- What DAX is and why it matters
- Creating calculated columns and measures
- Using basic functions like SUM, COUNT, and DISTINCT
- Practical examples to reinforce learning
Week 6: Designing Effective Visualisations
- Choosing the right visuals for your data
- Creating bar charts, pie charts, cards, and slicers
- Customising visuals for clarity and impact
- Using themes and layouts for professional design
Week 7: Creating Interactive Dashboards
- Combining visuals into clean, interactive dashboards
- Using filters, slicers, and drill-throughs
- Designing with the end-user in mind
- Best practices for layout and usability
Week 8: Publishing and Sharing Reports
- Publishing dashboards to Power BI Service
- Sharing reports securely with colleagues or clients
- Setting up scheduled data refresh
- Final review project and feedback session
Ready to bring your data to life with Power BI?
This course is perfect for professionals and teams who want to understand their data, communicate insights clearly, and make better decisions—no technical background required.
Price: £325 per person for 8-week course
Transform Your Reports and Analytics with Powerful, Interactive Insights
Already comfortable with the basics of Power BI? This intermediate Power BI course is designed for professionals ready to move beyond simple charts and data imports. Over 8 weeks, you’ll learn to model complex data, write powerful DAX formulas, and create dynamic, interactive dashboards that turn business data into clear, actionable insights.
With expert guidance, you’ll gain hands-on experience with Power Query, DAX, data modelling, and publishing best practices—everything you need to take your Power BI reports to the next level.
Price: £325 per person for 8-week course
Week 1: Building Stronger Data Models
- Review of data model basics
- Creating relationships between multiple tables
- Star vs snowflake schemas
- Best practices for building scalable data models
Week 2: Advanced Data Transformation with Power Query
- Creating reusable transformation steps
- Merging and appending datasets
- Working with unpivoted data
- Handling nulls, errors, and changing data types
Week 3: DAX for Calculated Measures and Columns
- Creating calculated measures and columns
- Using CALCULATE, SUMX, and FILTER for advanced analysis
- Applying context transition and row context
- Practical use cases for dynamic metrics
Week 4: Time Intelligence in Power BI
- Using built-in date tables and time functions
- Year-to-date, month-over-month, and moving averages
- Creating dynamic date slicers
- Comparing performance across time periods
Week 5: Visualising Complex Data
- Customising visuals with fields and formatting
- Using bookmarks, buttons, and tooltips
- Designing drill-down and drill-through reports
- Creating cohesive, user-friendly layouts
Week 6: Interactive Dashboards and UX Design
- Creating multi-page, interactive dashboards
- Using slicers, filters, and synced visuals effectively
- Designing dashboards for specific audiences (e.g., finance, sales)
- Balancing aesthetics with clarity and performance
Week 7: Publishing, Sharing, and Refreshing
- Publishing to Power BI Service
- Setting up workspaces and managing access
- Configuring automatic data refresh and gateways
- Sharing securely with internal and external stakeholders
Week 8: Final Project and Review
- Complete a full end-to-end Power BI project
- Use Power Query, DAX, and visuals to solve a real-world problem
- Present your dashboard and get expert feedback
- Explore next steps: Power BI advanced or Power Platform tools
Take Control of Your Data Story
This course is perfect for professionals who want to build impactful dashboards, work confidently with DAX, and deliver insight-ready reports that drive decision-making across teams.
Price: £375 per person for 8-week course