Facebook images (71).jpg

Overview

For years, businesses have collected data. Thanks to new technology, we can now leverage that data to make better business decisions. Businesses that take advantage of data analytics and artificial intelligence 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 become.

The following free, 1-hour courses are an excellent introduction to data analytics. Each course is offered twice (once on a Monday from 2 to 3 p.m. and once on a Friday from noon until 1 p.m. EDT). Feel free to take as many subjects as you would like. The more you take, the more you will know. 

Register for each individual course you want to take at the links provided below: 

 

Get Started with Excel 

A beginner overview of Microsoft Excel for the new or novice user, this training will review overall navigation, formatting, simple formulas, charts and tables, and an overview of printing.

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

Next live virtual session on December 5, 2022 at 1 p.m.. Register by clicking here. 

Click here to view recording of past session.

Go Further with Excel: Tables, Formatting and Collaboration 

Take your Microsoft Excel skills to the next level and learn more advanced features! Create tables, learn conditional formatting, and share and collaborate with your colleagues.

Objectives:

•Create spreadsheets using tables

•Analyze your data using conditional formatting and data validation

•Collaborate and share your work with others

•Use accessibility options in Excel

Next live virtual session on December 6, 2022 at 1 p.m. Register by clicking here. 

Click here to view recording of past session.

 

Go Further with Excel: Advanced Functions and Charts 

Take your Microsoft Excel skills to the next level with more advanced features. Learn advanced functions to better manage and analyze data, create and format charts to present information simply, and learn import and export options within Excel.

Objectives:

•Analyze data using advanced functions​

•Create and format charts​

•Use import and export functions

•Use accessibility options in Excel

Next live virtual session on December 7, 2022 at 1 p.m. Register by clicking here. 

The sessions have ended. Recordings of these session will be posted here soon. 

Power BI Service 

Microsoft 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 of Power BI and how its services and applications work together to connect a data source to begin visualizing data.

Objectives:

•Learn how Power BI 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

Next live virtual session on December 8, 2022 at 1 p.m. Register by clicking here.

Click here to view recording of past session.

 

Power BI Desktop 

Microsoft 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

Next live virtual session on December 12, 2022 at 1 p.m. Register by clicking here.

The sessions have ended. Recordings of these session will be posted here soon. 

 

Power Platform Foundations 

Using Microsoft Power Platform in Microsoft Teams allows organizations to bring key information, common tools, and trusted process to the place where they gather, learn, and work. This training will show the capabilities of Microsoft Power Platform in Teams and the ways business can use them.

Objectives:

•Identify types of apps, data types, relational data

•Build concepts for low-code apps in Teams

•Understand how to create workflows using templates

•Create and enable chatbots for simple conversational AI (artificial intelligence)

•Organize and filter data for easy-to-use reporting purposes

Next live virtual session on December 13, 2022 at 1 p.m. Register by clicking here. 

The sessions have ended. Recordings of these session will be posted here soon. 

 

Get Started with Artificial Intelligence in Power BI

With the no-code artificial intelligence (AI) experiences in Microsoft Power BI, users can easily leverage highly interactive and intelligent visuals to detect patterns in their data, ask questions of their data and discover new insights that can empower every individual and every team in their decision-making.

Objectives:

•Collaborate with Power BI in Microsoft Teams

•Connect to a sample Power BI dataset

•Explore how to make confident decisions using AI capabilities

•Create a report with the Power BI service

Next live virtual session on December 14, 2022 at 1 p.m. Register by clicking here. 

The sessions have ended. Recordings of these session will be posted here soon. 

 

Discover Insights with Power BI

With the no-code artificial intelligence (AI) experiences in Microsoft Power BI, users can easily leverage highly interactive and intelligent visuals to detect patterns in their data, ask questions of their data and discover new insights that can empower every individual and every team in their decision-making.

Objectives:

•Collaborate with Power BI in Microsoft Teams

•Connect to a sample Power BI dataset

•Explore how to make confident decisions using AI capabilities

•Create a report with the Power BI service

Next live virtual session on December 15, 2022 at 1 p.m. Register by clicking here.