Updated: Sep 16
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, April 18- Excel 100
Friday, April 22- Excel 200
Monday, April 25- Power BI 100
Friday, April 29- Power BI Desktop
Monday May 2nd- Power Platform Foundations
All classes will be held virtually from 12pm-1pm EDT
PLEASE NOTE: This program is designed to be progressive from one class to another, so please register for every class. That will also create calendar reminders for you for each session.
WHO SHOULD TAKE THIS COURSE
Staff members who are responsible for tracking any data for your business.
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.
Any web browser
This is a lecture type presentation. No projects will be required. However, we will share details on the software used so that you can practice the knowledge learned.
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.