Excel & Power BI Virtual Summit 2019

If you've purchased a pass to this Summit, you can access the sessions below by clicking 'Watch Session' and then 'Unlock' using the email address you used to make your purchase. Once unlocked, all the videos will be available on that same browser for 12 months.

Would you like to purchase A Pass?

Now that Summit  is finished, you'll need a pass to watch the recordings. 

SESSION

On-DEMAND

Excel for IT beginners

In this session we will take a deep dive into the basics of Microsoft Excel. By the end of this session you will have a basic knowledge of Excel, and be able to create graphs, formulas, and name cell ranges, in addition to learning various "toolbars" with-in Ms Excel.

Scott Johnson

MAJENZE International

Speaker

SESSION

On-DEMAND

Do you know where your Data's been?

When you do not get the result you have been looking for, 9 out of 10 times it is because Excel is understanding the data differently.

Let us look at some key features to clean your data and get to a well structured data set before we start analyzing and creating reports.

Dinah Coetzer

Altron Bytes People Solutions

Speaker

SESSION

On-DEMAND

An Introduction to Data Manipulation in Excel.

Although Excel is an amazing tool and can be used for many different purposes, one of the most common uses is to hold lots of data from which reports can be generated and business decisions can be made. In this session, I will introduce some basic ways to manipulate data in Excel. Specifically we'll look at sorting / filter / pivot / find / and groups functions - and I'll suggest some really clever tips and tricks to help ensure that you don't lose or corrupt any data along the way.

Helen Jones

Collaboris Ltd

Speaker

SESSION

On-DEMAND

Integrating Excel with other Apps - it really is easier than you might think!

In this introductory session, Mark showcases how Excel can be integrated with Power Apps to create a mobile app that creates and updates a spreadsheet. He also demonstrates how to synchronise a SharePoint List with a spreadsheet (and vice versa). If that's not enough then there's a great demo on how to pipe real time Microsoft Forms responses straight into an Excel spreadsheet (accessible from Teams). In the last demo we demonstrate how to co-author Excel docs across Excel Online, Desktop, IPAD and in Teams! If you've not used Power Apps, Power Automate, Teams, Forms then this session is good primer

Mark Jones

Collaboris Ltd

Speaker

SESSION

On-DEMAND

Things you won't learn in a typical Excel class

Tips, Tricks, and Best Practices from 20-year Excel user, Microsoft Certified Office Master, and Microsoft Certified trainer...

Sharon Fry MCT

PPO Help, Inc.

Speaker

SESSION

On-DEMAND

Linking Outlook with Excel to Produce mail outs

In this session you will learn how you can with the help of a little VBA link Excel to Outlook so that you can send email directly from Excel. This allows you to mail-out to a large number of people on a list in Excel, personalizing each email. It allows you to send email with attachments or to send email with data, with borders, from the Excel sheet itself.

Barb Henderson

Barb Henderson Consulting Ltd

Speaker

SESSION

On-DEMAND

Introducing Excel and how you can use it to help in your work

In this session I will introduce Excel and take you on a guided tour around the major features to help you get familiar with the Excel environment. I will also show you how to, perform basic calculations, create nested calculations, use the analysis tool (goal seek & pivot table) and create charts.

Mohamed Medhat Ibrahim Hayder MCT MCM

Ministry of Interior, Qatar

Speaker

SESSION

On-DEMAND

Getting Started with Power BI

We will start with the very basics and walk through building your first Power BI report. Topics covered will include loading your data and doing some transformations to get it into shape. Then we will move onto putting in some relationships and calculated columns and finally building the report. This session is aimed at the complete beginner.

Laura Graham-Brown

Consultant

Speaker

SESSION

On-DEMAND

BI Powers - The A.I. Who Tagged Me

So everyone knows how to make some nice graphs in Power BI from Excel or SQL Server... But what about getting "intelligent" results from unusual data sources?
Disclaimer: A.I. will eventually take over the world. Unlike Doctor Evil, it won't ask for a ransom.

Andre Melancia MCT

LunarCat.PT

Speaker

SESSION

On-DEMAND

The Power Query Editor: Having your cake and eating it too!

You: a skilled, experienced analyst who is used to solving problems with Excel, but wants to explore what Power BI has to offer.
This webinar: A conversation where we examine how to use the Power Query Editor to prepare data for use in both Power BI and Power Pivot (within Excel 2016).
You have spent many years developing your expertise in Excel, and along comes Power BI and you wonder "do I have to quit using Excel and switch over to Power BI?"
Absolutely not! You can continue to use Excel and take the dive into Power BI, a task made easier because there is one tool that both have in common: the Power Query Editor (PQE). You can use the PQE to prepare data to use in Power Pivot within Excel 2016, where you can create pivot tables using multiple worksheets. You can then load the same data into Power BI, and create visual reports with it. Or publish it to the Power BI Service so others can use the data that you have prepped.
If you want to follow along during the webinar you will need Excel 2016, the Power BI Desktop, and an account in the Power BI Service (you can use "My Workspace" if you only have a free account).
Experience within Excel is assumed, but no experience with Power BI is required.
Join us to find out why your mother was wrong when she said you can't have your cake and eat it too!

Jessica Jolly MCT

ALT-Enter LLC

Speaker

SESSION

On-DEMAND

Data Visualization – think about what you are asking for

You want reports, you want dashboards, but what you really want is data that you can use to make informed decisions! The problem is it is difficult to articulate what kind of data visual would best inform your needs--so you often end up with a big report or an Excel spreadsheet full of columns and rows. There must be a better way!
In this session, we will focus on effectively requesting and presenting data. With the goal of reducing the noise, improving user adoption, and turning data into information that you can use to make effective decisions.

Learning Objectives:
•Why is data visualization important?
•How does the human brain & eye interpret data?
•Choosing the right visualization type
•Telling a story with the data

Dan Edwards

Crowe LLP

Speaker

SESSION

On-DEMAND

Diving into implementing Row Level Security in while working with Power BI Report

If you are working with Power Bi report that displays some sensitive data that needs some row level security and you are looking to develop an ability that will help you to restrict the specific rows of data from irrelevant users then this session is for you because here you will learn to implement a Row Level Security with Power BI reports.
Apart from this, you will also learn what are the advantages of implementing the RLS in Power BI, also I will be discussing some of the common issues that we can face while implementing RLS and how to get rid of those issues.

Aakash Maurya

Treta Infotech Pvt Ltd

Speaker

SESSION

On-DEMAND

Learn Excel from Power BI

If you think Power BI is tough to learn then you are absolutely not right (that means you are wrong ha ha ha :))
Specifically in this session I will cover:
1 - InfoGraphic Charts
2 - PowerQuery in Excel and Power BI
3 - A quick Report using Q&A in Power BI

Vijay Perepa

A meet Z Tech

Speaker

SESSION

On-DEMAND

Your charts & reports, and how they are making your brain work harder

You have the data, but how best to present that information? In this session you'll discover a little bit of psychology and how it applies to your reports, to better layout, colour and present your Excel charts, and Power BI reports.
You'll discover the difference between intuitive and attentive mental process, how to reduce cognitive burden the help your users quickly see and understand what is presented to them.

Jon Lunn

Ricoh Digital Services

Speaker

SESSION

On-DEMAND

Introduction to the Excel Training Nuggets

A series of 12 Excel training nugget videos presented by Jon Manderville are included as part of the Excel and Power BI Summit All Access Pass, in this bonus session Mark Jones introduces 2 of the nugget videos so whet your appetite.
If you have already purchased the All Access Pass, details of how to download all 12 nugget videos will be emailed directly to you.

Jon Manderville

Consultant

Speaker

SESSION

On-DEMAND

Enhancing your SharePoint Solutions with Beautiful Power BI Dashboards

By now you have heard of PowerApps and SharePoint. You may even have some solutions already created. But what if you want more dynamic views of the data you're storing in SharePoint? With Power BI, you can do just that! In this session join Nick Brattoli and Steve Wilson as they discuss and demonstrate connecting Power BI to SharePoint lists and create advanced analytics that can be understood by even the least technical among us.
If you're new to Power BI, or just want to hear and see some cool things, don't miss this session!

Nick Brattoli MVP MCT

Three Six Five Consulting

Speaker

SESSION

On-DEMAND

Power BI and PowerApps - better together!

Take your Power BI reports and PowerApps to the next level by integrating the two together to give users great insight and act right away. This session will show you how to incorporate a PowerApp into a Power BI report as well as bring BI reports into a PowerApp.

Suzanne George, Microsoft Regional Director

Cognizant

Speaker

SESSION

On-DEMAND

The Latest Releases and Updates for Power BI

In this session, our favorite, newly created MVP, Laura Graham-Brown explains the latest features for Power BI that have just been released.
It's so new - even we don't know what is included - for the latest news, please join this session.

Laura Graham-Brown, MVP

Consultant

Speaker

SESSION

On-DEMAND

Chat Jam

Join in our fun Chat Jam and see how much you've learned over the last few days!

Collab365 Team

Collab365

Speaker