Data Bundle

Upon completion of this course, you will be able to:

• Navigate the Excel interface, customise settings and manage multiple worksheets efficiently
• Learn best practices for inputting, editing and formatting data for clarity and readability
• Adjust, insert, delete and freeze panes to keep data structured and accessible
• Use formulas, including SUM, AVERAGE, IF, COUNT and LOOKUP functions to calculate and analyse data
• Organise data alphabetically, numerically and by multiple criteria to extract insights easily
• Create and customise bar, pie and line charts to communicate trends and patterns clearly
• Apply validation rules and implement best practices for data integrity
• Discover formatting shortcuts, templates and essential Excel functions to work smarter

> See the full 2-day agenda for Excel for Business: Data Management in our expanded Course Guide

Upon completion of this course you will be able to:

• Understand the fundamental concepts and benefits of Power BI.
• Navigate and utilise the Power BI Desktop interface effectively.
• Connect to various data sources and import data into Power BI.
• Perform data transformations and cleansing using Power Query.
• Establish relationships between tables for data modelling.
• Create visually appealing and interactive reports using different visualisation types.
• Customise visual properties to enhance the visual representation of data.
• Implement interactivity through the use of filters and slicers.
• Design and organise reports and dashboards for optimal user experience.
• Apply best practices for data visualisation to effectively communicate insights.
• Publish and share reports on the Power BI Service for collaboration and distribution.

> See the full 1-day agenda for Power BI Fundamentals for Business in our expanded Course Guide