“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP How long would it take you to combine data from 15 workbooks into a single data set? A few minutes, an hour? If you’re using Get & Transform (previously known as […]
Power BI is Microsoft’s business intelligence (BI) solution for visualising and sharing data. Power BI enables you to quickly develop interactive reports and dashboards and share impactful visualisations with others. Course objectives: What is Power BI? Power BI Desktop Power BI service Importing Files Creating interactive visualisations Reports and Dashboards Row-Level Security Sharing reports and […]
This practical, introductory session explores how to plan and create effective pre-recorded videos to enhance student learning. Whether you're developing flipped classroom content or short instructional videos, thoughtful planning and a few simple techniques can significantly improve student engagement and knowledge retention. The session also covers core functionality in Panopto Capture, enabling you to create […]
This is a half day course that includes a presentation and a variety of practical exercises. This is an advanced course aimed at staff who are experienced at using Microsoft Excel 2010 and are interested in finding out more about PivotTables and PivotCharts. PivotTables are a popular Excel tool for dynamically exploring and analysing large […]
Power BI is Microsoft’s business intelligence (BI) solution for visualising and sharing data. Power BI enables you to quickly develop interactive reports and dashboards and share impactful visualisations with others. Access on iTrent