Updated: Sep 16
Second Session Registration Now Open!
Louisville Future of Work Initiative powered by Microsoft is excited to announce that we are providing free, instructor-led training to businesses on the following courses:
Monday, May 9- Excel 100
Friday,May 13- Excel 200
Monday, May 16- Power BI 100
Friday, May 20- Power BI Desktop
Monday, May 23- Power Platform Foundations
All classes will be held virtually from 12pm-1pm EDT
You can register for any one class or all of them via EventBrite at the link below.
WHO SHOULD TAKE THIS COURSE
Anyone interested in tracking, analyzing and displaying data.
WHY SHOULD SOMEONE FROM MY COMPANY PARTICIPATE
Data is no longer just something to be collected. It is key to every business decision such as determining your staff make up, you marketing tactics, your process flow applications, and key financial decisions. Businesses that take advantage of data analytics are finding their decisions are easier to make and the outcomes far more successful. The more people in your business who understand how to collect, visualize and apply data the more successful your business will be.
WHAT SKILLS ARE NEEDED
A basic understanding of how to use a computer.
An understanding of the data that your business collects.
Critical thinking skills (to enable you to understand how to leverage the data you collect to support your business)
WHAT TECHNOLOGY IS NEEDED
A computer with access to the internet. We recommend you view it on a a larger screen so you can see the details.
The lecture will be presented via Microsoft Live. This software allows you to see and text the presenter, however you cannot be seen or heard.
You DO NOT need the software to view the presentation. It can be seen through most web browsers.
WHAT WILL THEY LEARN
Power BI Level 100
Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. This course will provide an overview Power BI and how its services and applications work together to connect a data source to begin visualizing data.
Learn about Power BI and how its services and applications work together to make your business more efficient
Understand the building blocks of a Power BI dashboard
Connect a data source to a Power BI dashboard and begin visualizing data
Save a Report and share within the Power BI service
Power BI Desktop
Power BI enables everyone at every level of your organization to make confident decisions using analytics. Once you get started with Power BI Desktop, you can go from data to insight to action with hundreds of data visualizations, built-in AI capabilities, a tight Excel integration and prebuilt and custom data connectors to develop rich and interactive reports to share with colleagues.
Understand the building blocks of Power BI Desktop
Explore the data prep capabilities of Power Query
Write formulas and model your data
Begin visualizing data and formatting a report
Save and publish a report to the Power BI service
Microsoft Excel, the spreadsheet app, lets you create, view, edit, and share files quickly and easily. Get started by learning to navigate excel, organize data, and use basic formulas.
Navigate Excel ribbon options.
Format Excel workbooks and worksheets.
Use formulas, functions and validate to work with data.
Learn print processes for excel workbooks.
Take a dive into the intermediate features of Excel’s navigation, functions, and custom formulas.
Expand knowledge of notable functions in Excel.
Understand a wide variety of cell formatting to manipulate and interpret data.
Learn to create Pivot tables for data analyzation.
Understand options to restrict and protect data in Excel.
Utilize accessibility options in Excel using the Check Accessibility tool and how to add alternative text.