click on PRICES link to see how we can train you safely and effectively

Tony Davis Excel Advanced
ring/email for a free consultation

Tony Davis Excel Advanced ring/email for a free consultation Tony Davis Excel Advanced ring/email for a free consultation Tony Davis Excel Advanced ring/email for a free consultation

07946 576 364

  • Home
  • Contact
  • PRICES
  • Excel
  • Power BI
  • PowerPoint
  • Access
  • Word
  • Project
  • More
    • Home
    • Contact
    • PRICES
    • Excel
    • Power BI
    • PowerPoint
    • Access
    • Word
    • Project

07946 576 364

Tony Davis Excel Advanced
ring/email for a free consultation

Tony Davis Excel Advanced ring/email for a free consultation Tony Davis Excel Advanced ring/email for a free consultation Tony Davis Excel Advanced ring/email for a free consultation

  • Home
  • Contact
  • PRICES
  • Excel
  • Power BI
  • PowerPoint
  • Access
  • Word
  • Project

outlines (all versions) - all courses can be customised

Power BI Introduction 1 Day

Power BI Intermediate/Advanced 1 Day

Power BI Intermediate/Advanced 1 Day


Power BI overview


Importing data

Data from multiple sources

Create tables within Power BI

Transform data

Creating table relationships



Visualisations

Creating reports

Creating charts

Mapping data

Interactive slicers and filters

Drilling through data



Creating dashboards

Adding visualisations to dashboards

Interactive dashboards

Sharing Dashboards


Power BI Intermediate/Advanced 1 Day

Power BI Intermediate/Advanced 1 Day

Power BI Intermediate/Advanced 1 Day

Recap on basics  (if needed)

 

Importing Data and Creating a Simple Report

Applying Conditional Formats

Creating Calculated Columns

Creating Measures (DAX)

Grouping Data and Creating Visualisations

Creating KPIs

Creating Conditional Columns

MODELLING DATA

Using relationships to improve the ability to analyse data

Pivoting and Grouping Data

Creating Conditional Columns

Creating Tables from existing Data

Importing Data via a database query

Exploring DAX further 

IMPROVING REPORTS AND OUTPUTS

Working with multiple report pages

Adding Graphics and drawing elements to Reports

Exporting data to CSV

Exporting data to PowerPoint

Exporting Data to Excel

Creating a Power BI Template

Creating a Power BI App

Excel Advanced

Ilford Essex

07946576364

Copyright © 2018 Excel Advanced - All Rights Reserved.

Powered by GoDaddy