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 have been offered in the past. Some of them were recorded. You can access those recordings at the links 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
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
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
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
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
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
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
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