Excel Training for Somerset

Excel to Power BI: Data Preparation Essentials

This practical, hands-on course is designed for Excel users who want to prepare their data effectively for use in Power BI Desktop. Delegates will learn how to structure, clean, and optimise Excel data so it can be imported, modelled, and visualised seamlessly in Power BI. By the end of the day, participants will understand the key differences between Excel and Power BI data handling, and will be confident in applying best practices that reduce errors, improve efficiency, and create a solid foundation for insightful reporting.

Dates on request

Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

14 upcoming dates

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

17 upcoming dates

This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

13 upcoming dates

Excel Analysing and Presenting Data with Dashboards and Pivot Tables

This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.

5 upcoming dates

Excel Advanced Macros

This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

5 upcoming dates

Excel Business Intelligence using Excel Power Tools

This course is split into 3 main areas:

4 upcoming dates

VBA Essentials using Microsoft Excel

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

10 upcoming dates

Microsoft Power Apps and Power Automate Essentials

Are you ready to unlock the potential of the Power Platform? Our beginner-friendly course will empower you to build applications using Microsoft’s powerful suite of tools. Whether you’re a non-technical enthusiast or a budding developer this course is tailored for you.

10 upcoming dates

Office 365 Introduction - 365 Small Business or Enterprises

This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of Outlook as an "All in One" messaging, SharePoint for Team collaboration and Lync 2010 for unified communications.

2 upcoming dates

Office 365 User Essentials

This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course covers the role of using the Office Online Applications to create, edit, comment and share documents.

Dates on request

What delegates say

I found the course really helpful and interesting

Rowen Group Ltd

J.L, Excel Essentials

Really good course

HMP Full Sutton, HMP Gartree

J.E, Minute Taking

I would really recommend this training to people that use Excel and want to make their life a bit easier.

ASW Assurance

S.A, Excel Level 2

Whether you are a beginner looking to master the basics or an advanced user aiming to enhance your skills, our extensive range of Excel training offers something for everyone. Our expert instructors will guide you through various topics, including data analysis, pivot tables, macros, and more, ensuring you gain practical knowledge and confidence in using Excel for your professional needs. Join us in Somerset and take the next step in your Excel journey!

Some of our clients include:

More information

Excel Courses for Somerset

We provide Excel courses for Somerset, our Excel Courses can be available as scheduled or private courses, meaning that you can benefit from training that fits your exact requirements. If you are unsure which Excel Courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.

Private Courses for Somerset

Private Courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.

Public Scheduled Courses

Scheduled Courses, easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend. If a public scheduled course is not available for Excel for Somerset, we can provide private, onsite or virtual courses for you for Somerset. One way or another, contact us to let us know how we can help or to book your courses.

Great course, engaging trainer and a good pace. Just what I was looking for.

Capstone Foster Care

G.H, Excel Level 1

I found the course exceptional

British Engines

J.M, Adobe InDesign Level 1

Excellent course

G.N, PowerPoint Essentials

Search courses

We have been providing courses in the UK since 1992. Use the box below to search for your course.

Can't find exactly what you need?

Build your own course or let us design one around your systems and processes.

Contact us online

Why train with us

Flexible content
Virtual courses
Classroom training
Small class sizes
Course materials included
Lunch and refreshments At our training venues
Expert trainers
Questions encouraged

✖

We use cookies to enhance your experience. Please let us know if you accept or reject optional cookies.

Accept Optional Cookies

Reject Optional Cookies

My favourites

Evaluate a course Read 8000+ Reviews

Courses

All Courses Course Articles

Vendors

Microsoft Adobe Google ChatGPT ArcGIS MapInfo

Most Popular

ChatGPT Copilot AI Excel

Personal Development

Leadership and Management Effective Meetings Personal Effectiveness Effective Teams Customer Service and Sales Health and Safety Communication Leadership and Management

Public Schedule

View the Course Schedule

View by course View as a calendar View by month

Book

Book a place

Most Popular Scheduled Courses

Copilot level 2 Excel Level 2 Excel Level 3 Microsoft Power Apps and Power Automate Essentials Excel Business Intelligence using Excel Power Tools

About

Course Information

Course reviews Training venues Course FAQs

About Us

Terms and conditions Privacy policy Who are we

Contact

Enquire online Book on a course Full contact details

Menu

Mon-Fri, 9-5pm0191 377 8377

This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.