Clearwater Training

02/09/2026

Excel, PowerPoint and Word Live Online Courses

Just to let you know we are now running courses live online in the evenings and at weekends for Excel, PowerPoint and Word.
These courses are instructor-led and discounts are available for multiple bookings. If you would like help in deciding which courses are most appropriate for you, please let me know and I will design a tailored pathway for you based on our free Training Needs Analysis questionnaire.

For more information please email: [email protected]

or visit our website: www.ittrainingherts.co.uk

Our schedule of dates is available here: https://ittrainingherts.co.uk/public-courses-36-w.asp

10/08/2026

New Power BI & Excel Image Series!

Want to learn how to use photographs in Excel and Power BI reports?

This four-part tutorial series shows you how to:

✅ Store images directly in Excel
✅ Create interactive Excel charts and Pivot Charts with photos
✅ Plot latitude and longitude data on interactive Power BI maps
✅ Display photographs in Power BI reports using image URLs, with synced filters and professional formatting

These techniques are ideal for dashboards, product catalogues, wildlife surveys, asset management, inspections, property databases, education and many other real-world projects.

Whether you're an Excel user looking to move into Power BI, or you're already building dashboards, I hope you'll find some useful ideas to add to your own reports.

🎥 Watch the full playlist here:
https://www.youtube.com/playlist?list=PLO74avi9rBtM

Learn how to use images in Excel and Power BI to build spreadsheets that really stand out. Most people think spreadsheets are just rows of numbers, but moder...

07/08/2026

Want to display photographs in your Power BI reports?

In this video, I'll show you how to use image URLs from Excel to display photographs in Power BI, format image columns for a professional look, and create an interactive report with synced filters and maps.

This technique is ideal for dashboards, product catalogues, wildlife surveys, inspections, asset management, and any report where images help bring your data to life.

🎥 https://youtu.be/ebR1vC7o2Wc

Learn how to display images in Power BI reports using data stored i...

07/08/2026

Want to plot latitude and longitude data on a Power BI map?

In this video, I'll show you how to import latitude and longitude coordinates from Excel into Power BI and display them on an interactive map.

This is perfect for mapping customer locations, survey results, wildlife sightings, assets, or any other location-based data. We'll also look at creating an interactive report that responds to your filters.

🎥 https://youtu.be/kSiz3kpjxAA

06/08/2026

Want to add images to your Excel charts and Pivot Charts?

In this video, I'll show you how to use Excel's image feature to create interactive charts and Pivot Charts with photographs that update automatically as you filter your data.

It's a great technique for dashboards, product catalogues, wildlife surveys, inventory management, and any report where pictures make your data easier to understand.

🎥 https://youtu.be/k4Agqa1548s

Did you know you can use pictures instead of bars or columns in Exc...

06/08/2026

Free Microsoft Office Quick Fixes Video Series

Need a quick solution to a frustrating Microsoft Office problem?

This free playlist covers some of the most common issues in Excel and Word, including dates that won't sort, PivotTables that won't group, unwanted blank pages and other everyday problems, with simple step-by-step fixes.

I'm gradually building a free library of practical software training videos on YouTube. If there's a topic you'd like me to cover, just let me know.

https://www.youtube.com/playlist?list=PLZokKzfJB4UU

A collection of short videos explaining some of the most common Microsoft Office problems. Each video focuses on a single issue and shows you how to fix it q...

06/08/2026

Want to store images directly in Excel?
In this video, I'll show you how to use Excel's built-in image feature to store photographs inside your workbook instead of linking to separate files.

This is ideal for species identification, product catalogues, stock control, inspections, surveys, and any spreadsheet that needs to display images alongside your data.

🎥 https://youtu.be/3svkOmLhC-8

In this step-by-step tutorial you'll learn how to create a fun but ...

05/08/2026

Free Exchange Rates in Excel & Power BI Video Series

Need to work with exchange rates in Excel or Power BI?

This free playlist shows you how to build currency conversion tools using named ranges, import live exchange rates from the Bank of England, and use the data in both Excel and Power BI reports.

I'm gradually building a free library of practical software training videos on YouTube. If there's a topic you'd like me to cover, just let me know.

https://www.youtube.com/playlist?list=PLDqa2EcAoido

Learn how to convert currencies automatically in Microsoft Excel and Power BI using practical, real-world examples. This playlist starts with simple GBP to U...

05/08/2026

Free Google Forms & Power BI Video Series

Want to collect data with Google Forms and turn it into meaningful reports?

This free playlist takes you through the whole process, from creating a Google Form and managing responses to analysing the data in Excel and building interactive Power BI reports.

I'm gradually building a free library of practical software training videos on YouTube. If there's a topic you'd like me to cover, just let me know.

https://www.youtube.com/playlist?list=PLZBFbFqCB44I

Collect data via a form. Create spreadsheets and charts from the data. Publish and share the results.

04/08/2026

Free Excel Charts & PivotTables Video Series

Want to become more confident with Excel charts and PivotTables?

This free playlist covers everything from creating your first column chart to building PivotTables, PivotCharts, slicers, lookups and interactive dashboards. Whether you're just getting started or looking to sharpen your Excel skills, there's something here to help.

I'm gradually building a free library of practical software training videos on YouTube. If there's a topic you'd like me to cover, just let me know.

https://www.youtube.com/playlist?list=PLG-Mxig5ho6Q2kZqvSsTmzueUqw_vpjYz

Create Excel charts and Excel Pivot Charts.