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 […]
Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a series of practical exercises, participants will learn about a variety of techniques which can be employed to make spreadsheets more comprehensible, such as sorting, basic […]
This specialised course looks at the improved charting feature in Excel 2007 and discusses some of the different types of charts that can be created, in particular, line, scatter, pie, bar and column charts. It also covers how to edit scientific or statistical charts to include features such as secondary axes and error bars and […]
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 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 […]
This advanced course looks at some of the data analysis tools and functions available in Excel 2010 and involves a range of practical exercises using different types of data. Participants will learn how to use a variety of what-if analysis tools that can be employed in data analysis and decision making, such as Data Tables, […]
This is part 1 of a 2 part course to help staff prepare for ECDL Module 5. The course covers: what a database is in terms of tables, records and fields; how to specify fields with data types and field property settings; how to set a field as a primary key, switch between view modes […]