Categories

Our Workshops

Advanced Excel & Power BI Beginner

Microsoft Office Suite

.

Description

 

2-Day Workshop

Advanced Excel and Power BI are complementary business intelligence tools. Excel is used for data manipulation and analysis, and Power BI for creating dynamic, interactive visualizations and dashboards from larger datasets and multiple sources.

Mastering advanced Excel skills, provides a strong foundation for Power BI, which allows users to connect to diverse data sources, clean and model data as well as share insights across an organization. 

Excel Advanced

Master Excel at the advanced level
Our Excel Advanced workshop aims to take you on to the next level of Excel functionality with an intensive 1 day course offering. This is your opportunity to learn how to make the most of everything Excel has to offer – everyday.


Discover the full potential of this powerful offering
Covering advanced functionality such as the consolidation of workbooks, automating worksheets, file collaboration, auditing features and more, this course allows you to confidently and efficiently maximise your use – and the full potential - of Microsoft Excel.

Day One

  • Automating Worksheets     
  • Data Structure and Default Settings          
  • File Collaboration     
  • Auditing Features     
  • Data Analysis
  • Work with Multiple Workbooks     
  • Data Import with XML         

Power BI - Beginner

Learn to connect, to transform, and model data, create compelling visualizations and reports, build interactive dashboards to share insights with others, ultimately empowering you to make data-driven decisions and bring raw data to life for business use. 

Day Two

  • What is Power BI?
  • The parts of Power BI
  • Opening Power BI Desktop
  • Power BI Desktop Screen Layout
  • Getting Data
  • Connecting to a Data source to Get Data
  • Edit Data before loading
  • Power Query Editor Screen Layout
  • Create Visualizations
  • Modelling Data
  • Create Calculated Tables
  • Create Calculated Columns
  • Optimising Data models
  • Creating Calculated Measures
  • DAX Syntax
  • Visualizations
  • Page Layouts and Orientation
  • Duplicate a report page
  • Introduction to the Power BI Service
  • Publish a Power BI Dashboard to the Service

------------------------------------------------------------------------------------------------------------------------------------------

On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 

Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Workshop Dates