Search

Over 500 Participate 1st Free Microsoft Excel/Power BI Course

Updated: May 4

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


Description

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.


Objectives

  • 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


Description

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.


Objectives

  • 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


Excel 100


Description

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.


Objectives

  • Navigate Excel ribbon options.

  • Format Excel workbooks and worksheets.

  • Use formulas, functions and validate to work with data.

  • Learn print processes for excel workbooks.


Excel 200


Description

Take a dive into the intermediate features of Excel’s navigation, functions, and custom formulas.


Objectives

  • 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.


42 views0 comments