Course Code: M-Data-Excel

Modern Excel Analyst in One Day

This One-day training aims to bring awareness of advanced capabilities available in Excel, to empower Modern Excel analysts to see what’s possible, to explore how Excel & Power BI are best used together and how Excel & Power BI can be integrated in Microsoft Teams & SharePoint Online.

Price 1.400 €

Delivery Type Classroom

Location On-Site

Length 1 Day

Course Outline Book your place

Educators

Vedran Hromalic

With more than 18 years of experience in IT, mostly in project management, the last 8 years my focus is primarily on MS Cloud and Data Platform - and he is specialized in that area. Focused on a deeper understanding of Azure Data Platform services like Data Factory, Spark, Synapse, SSAS/AAS, T-SQL, and a Power BI/Power Platform. Also constantly strive to be updated with Cloud Architecture, Data Engineering best practices and actively following activities in the PASS community. More you can find on his blog: vedranh.com

Currently, he is involved in various Azure Architecture, ETL, SSAS/AAS and Power BI projects, as a developer or a consultant. As a participant in many Microsoft programs and closed groups like Azure Advisors, Power BI Embedded, SQL Server Partners… really have all the support that projects may need.

Follow Vedran

Work Experience

01/2020 -

VS Office AS

Oslo, Norway

Mentorship for colleagues and clients about Microsoft Azure Cloud
Constantly improving relationships with clients and their Data Platform
In-house courses about Power BI and Advanced Analytics
Improving ETL and Machine Learning skills with C# and F#

12/2017 - 12/2019

CGI Norge AS

Oslo, Norway

Oil & Gas Sector – Azure production setup, SQL Data Warehouse Infrastructure setup, Cloud Analytics Hybrid setup with Azure Cloud
Client/In-House Hackathons – Azure Architecture/Data Engineering SQL Data modeling, Hackathon Infrastructure setup based on Azure Cloud
Maritime Industry Sector – Azure production setup Designed and implemented Hybrid BI Architecture for the client

Education

RRiF College of Financial Management

Zagreb, Croatia

Gallery

Course outline

Course description

This one-day (In-House / On-Site) training aims to bring awareness of advanced capabilities available in Excel, to empower Modern Excel analysts to see what’s possible, to explore how Excel & Power BI are best used together and how Excel & Power BI can be integrated in Microsoft Teams & SharePoint Online.

It targets:

Power BI analysts
Excel analysts
Data enthusiasts

Course objectives

On completion of this course, you will…

Have Awareness of Power Query & Power Pivot In Excel
Learn how Power Query & Power Pivot In Excel can improve efficiency, provide reusable seamless solutions and transform existing manual reporting into actionable insights
Understand how Excel maps into Power BI Desktop
Identify opportunities to use Excel & Power BI together
Integrate Excel & Power BI solutions into Microsoft Teams & SharePoint

Course prerequisites:

There are no specific prerequisites
It will be helpful, however, if you have basic familiarity with Excel

Computer prerequisites:

Windows 8 / Windows 10
Excel 2016 64-bit is recommended for using Power Pivot In Excel & also includes Power Query
Latest version of Power BI Desktop 64-bit (Download options)
Microsoft Edge (based on Chromium) recommended—or, another web browser supported by Power BI

On-line Experience:

Presentation hours: 9AM – 5PM
Breaks: 15-minute breaks 10:30AM & 3:45PM
Meals: 1-hour break for lunch 12PM – 1PM
Mute + Headset
Chat
Feedback

In-house Experience:

Presentation hours: 9AM – 5PM
Breaks: 15-minute breaks 10:30AM & 3:45PM
Meals: 1-hour break for lunch 12PM – 1PM
Discussion
Feedback

Course outline / Modules:

Analytics in Excel
Mapping learning to Power BI
Power BI + Excel better together
Power BI + Office better together
Questions & Wrap-Up

Module 1: Analytics In Excel

Introducing Modern Excel
Modern Tools
Power Query In Excel
Power Pivot In Excel
Relationships
Multiple Table Pivot Tables
Measures
Slicers & Timeline
Conditional Formatting

Module 2: Mapping Learning to Power BI

Power BI Desktop – Introduction
Power Query in Power BI Desktop
Modeling in Power BI Desktop

Module 3: Power BI & Excel Better Together

Power BI & Excel better together – Ecosystem
Connecting to Power BI from Excel
Cube Formulas
Microsoft Information Protection/Row Level Security (RLS)
Roadmap: Featured Tables, Data Types, Lineage

Module 4: Power BI & Office Better Together

Power BI & Microsoft Teams
Power BI & SharePoint

Module 5: Questions & Wrap-Up

Book your place