YOUR

TRAINING

Excel training workshop – Power Query and Power Pivot for controller and analyst (Level 1)

$ 300

AF3659

et|icon_check_alt|

Webinar training - Online

et|icon_check_alt|

2 days of 4 hours

et|icon_check_alt|

English

et|icon_check_alt|

Live Webinar

Summary :

The addition of the Power Suites will revolutionize the way you work with Excel. To date, “Business Intelligent” (BI) has been almost exclusively reserved for IT developers. This course explores the Power Query and Power Pivot add-ins of Excel.

SEE MORE

Power Query

Import data
- Automate the import of data from external sources
  - Excel, Access, SQL
  - Text
  - Web
  - ODBC link
Data manipulation
- Fit data in the query editor
- Transform data with Power Quercy
- Sort and filter data
- Combine different sources
- Consolidate files inside a directory
Formulas
- Use Power Query formulas (Language M)
- Modify a query
- Insert custom columns

.

PowerPivot

Import data
- The different sources (SQL, Access, SharePoint, ...)
- Update data
Create the data model
- What is the data model
- Create relationships
- Create hierarchies
DAX functions
- Time intelligence
  - DATESYTD
  - SAMEPERIODLASTYEAR
- Statistics
  - SUM
  - SUMX
  - AVERAGE
  - AVERAGEX
- Logic
  - IF / AND / OR
  - SWITCH

YOUR TRAINERS:

CONTACT US FOR MORE INFORMATION ON THIS TRAINING

CALENDAR :

02/12/2024	Webinar training - Online	Stéphanie Perreault
14/04/2025	Webinar training - Online	Stéphanie Perreault
25/08/2025	Webinar training - Online	Stéphanie Perreault