Microsoft Excel
Microsoft Excel Training
Take Excel to the Next Level
Microsoft Excel
Microsoft Excel Training
Take Excel to the Next Level
Microsoft Certified Trainers
We've Partnered With Microsoft
After Training Support Packages
Additional Free Resources
Excel Power Tools
Excel Power Tools: Power Query & Power Pivot Essentials
Length: 1 Day
Public Remote Online: £575
Next Date: By Request
Training time: 09:30 – 16:30 UK
- Overview of Excel Data Modelling Tools
- Importing and Transforming Data
- Data Modelling Concepts
- Working with DAX
- Report Building and Final Project
This hands-on course is ideal for Excel users who want to go beyond formulas and VLOOKUPs.
You’ll discover how to use Power Query and Power Pivot to manage, clean, and analyse data more effectively, transforming how you work with Excel.
Whether you’re automating a monthly report or building a full analytics model, this refresher will help you streamline your process and build confidence with advanced Excel tools.
Excel VBA
Microsoft Excel VBA for Data Analysis
Length: 2 Days
Public Remote Online: £895
Next Date: By Request
Training time: 09:30 – 16:30 UK
Introduction to VBA for Analysts
The Excel Object Model
Automating Data Cleaning Tasks
Data Aggregation & Analysis with VBA
Interacting with Users
Reporting and Output Automation
User-Defined Functions (UDFs) for Analysis
Integrating with External Data Sources
This hands-on VBA course is designed for Excel users who want to go beyond formulas and harness the power of VBA for data analysis.
You’ll learn to automate data cleaning, build dynamic reports, create user-defined functions (UDFs), and integrate data from multiple sources.
By the end of the course, you’ll be able to build custom tools that streamline your analysis workflows and turn repetitive tasks into single-click solutions—all inside Excel.
IN PARTNERSHIP WITH MICROSOFT TO DELIVER HIGH QUALITY TRAINING
Excel Training Classes
Take your data skills to the next level with this immersive one-day training workshop designed for Excel users ready to move beyond traditional functions and unlock the power of Excel’s advanced data modelling tools.
Whether you’re automating tedious reporting tasks or aiming to create insightful dashboards for stakeholders, this course gives you the confidence and capability to streamline your workflow and make data work for you.
Why Choose us for Excel Training?
As a trusted Microsoft Solution Partner since 2016, we are committed to providing top-notch training solutions that enable organizations to fully leverage Microsoft technologies. Our vast experience and in-depth knowledge ensure that our training programs are not only thorough but also customized to address the specific needs of your team. By partnering with us, you will benefit from industry-leading resources, practical learning experiences, and continuous support from certified experts. Enhance your team’s capabilities and drive innovation within your organisation with our proven training methods. Choose us for a partnership that prioritizes your success and promotes a culture of ongoing learning.
Why Attend Excel Training Courses?
Master the key Excel tools—Power Query, Power Pivot, and DAX—to build efficient, scalable, and interactive data models directly in Excel.
- Connect to and clean data from multiple sources using [Power Query](/content/power-bi-tip-discovering-power-query-m-functions/ "Power BI Tips: Discovering Power Query ‘M’ functions"/index.html)
- Build structured models using relationships and calculated fields in Power Pivot
- Write DAX formulas for analysis, including time intelligence and filters
- Create dynamic dashboards with PivotTables, charts, and slicers
- Apply performance and troubleshooting techniques to optimise your work
What will you learn:
- Regularly work with data and want to go beyond basic formulas and VLOOKUPs
- Want to improve efficiency working with large or multiple datasets
- Need to build robust, scalable Excel data models
- Aim to tell compelling data stories with stunning dashboards
This hands-on course covers the full spectrum of Excel’s modern data capabilities. You’ll gain practical experience through real-world examples and guided exercises:
Power Query Essentials
Learn how to import, connect, and shape data with ease. Clean messy datasets, transform structures, and automate repetitive steps with intuitive tools.Data Modelling with Power Pivot
Master the Excel Data Model by creating structured relationships, calculated columns, and efficient data structures built for scalability.DAX Formulas Demystified
Understand key DAX functions and write powerful formulas that enhance your analytics—perfect for creating KPIs, rolling totals, or dynamic time comparisons.Dashboard & Report Building
Create engaging dashboards using PivotTables, charts, slicers, and more. Learn tips to improve usability and performance, with a final case study to bring it all together.
Why Choose Data Bear as your Microsoft Excel Training Provider?
Based on our customer feedback, we have created a list of reasons why you should choose our team for Microsoft Excel Training Courses:
- Microsoft Solution Partner
- Established business with a reputable reputation
- Microsoft Certified Trainer (MCT)
- Microsoft Most Value Professional (MVP)
- Options for a group, live online training, and bespoke private training
- Ongoing support packages available
Data Bear’s Fabric Training offers a comprehensive approach to enhancing data management skills. Participants benefit from hands-on experience with advanced data integration techniques, enabling them to streamline workflows and improve data accuracy. The training emphasises practical applications, equipping professionals with the tools to effectively analyse and visualise data. By fostering a deeper understanding of data fabrics, attendees can drive better decision-making and enhance organisational efficiency. Overall, Data Bear’s Fabric Training empowers individuals to leverage data as a strategic asset in their respective fields.
Frequently Asked Questions
What is Power Query and Power Pivot?
Power Query is a data connection technology that lets you discover, connect, combine, and refine data across a wide variety of sources.
Power Pivot enables you to build advanced data models, create relationships, and perform powerful calculations using DAX—all within Excel.
Do I need prior experience with Power Query or Power Pivot?
No prior experience is required. The course is beginner-friendly, though you should be comfortable using Excel and familiar with basic formulas and PivotTables.
What software do I need installed?
You’ll need:
- Excel (2016 or later, or Excel 365 for best compatibility)
- [Power BI](/content/powerbi-the-good-the-wonderful-the-magnificent/ "The good, the wonderful, the magnificent Power BI!!!"/index.html) Desktop (free to install from Microsoft)
- A modern browser or Microsoft Teams to join the live session
What happens if I don’t have two screens?
Two screens (or a screen plus a tablet/second device) are highly recommended to get the most out of the training. However, if you only have one screen, you can still participate—you may just need to toggle between the trainer’s screen and your workbook.
Is the training hands-on?
Yes! The course is highly interactive. You’ll follow along with the trainer’s demos, complete practical exercises, and work on a final case study using real-world data.
Do I get any materials after the course?
Yes. You’ll receive:
- A downloadable training manual
- All course example files
- Certificate of attendance (on request)
Can I book this training for my team?
Absolutely. We offer private sessions for teams that can be tailored to your data and industry. Contact us for group pricing and custom options.
What if I need support after the course?
We offer follow-up support and [Power BI consulting](/content/8-top-features-in-power-bi-consulting-packages/ "8 Top Features in Power BI Consulting Packages"/index.html) packages. If you hit a roadblock applying what you’ve learned, we’re here to help.
How do I book my place?
Click the booking link on this page or contact us directly via email at training@databear.com or call +44 20 8720 6880 to reserve your spot.