Kansas State University

• Nov. 3: Power BI L100 – Register
• Nov. 4: Lists L100 – Register
• Nov. 8: Teams L100 – Register
• Nov. 11: Excel L100 – Register
• Nov.16: OneNote L100 – Register
• Nov. 18: Power Automate L100 – Register

​See the session descriptions below.

All of the above sessions will be from 2-3:30 p.m. The sessions will be held in Microsoft Teams. When you click to join the meeting, you will be taken to a page where you can choose to either join on the web or download the desktop app. If you already have the Teams app, the meeting will open there automatically.

Excel L100

This course is designed to expand on the basic features of Excel. Attendees should have a basic understanding of basic features, navigation, and have a grasp on the use of functions and custom formulas.

Objectives:

• Learn about Templates and basics of Excel sheet structure
• Understand cell and sheet formatting tools
• Learn basic functions and formulas
• Learn how to use conditional formatting and see common examples
• Understand the basics of Pivot tables to filter and visualize data

Lists L100

Learn to stay on top of it all with Lists, the smart information tracking app in Microsoft 365. Lists help you track information and organize your work.

Objectives:

• Navigate and understand core functionality of Microsoft Lists
• Create, share, and track lists
• Customize with custom views
• Build lists from a template
• Understand SharePoint Online and Teams integrations
• Understand column types

OneNote L100

Registration is required. A confirmation message with a link to the session will be sent to you after you register. When you click to join the meeting, you will be taken to a page where you can choose to either join on the web or download the desktop app. If you already have the Teams app, the meeting will open there automatically.

In this course, attendees will learn how to capture their ideas, notes, and stay organized using OneNote, Microsoft’s digital notebook.

Objectives:

• Understand OneNote integration with Microsoft 365
• Access OneNote through different modalities (e.g. web, desktop) and Microsoft Teams integration
• Use Notebooks, sections, and pages to organize notes and projects
• Learn how to use Reference features
• Expand on ideas using Inking and Media
• Understand basic sharing options for collaboration using OneDrive and SharePoint

Power Automate L100

Attendees taking this course will learn the basic elements of Power Automate, including an overview of types of flows, how to create flows from templates or from scratch, and understand how these can be integrated with existing systems and applications like Microsoft Teams.

Objectives:

• Become an expert on accessing and navigating Power Automate
• Understand key components of a Flow
• Maximize efficiency through pre-built Flow templates
• Get familiar with Connectors, Data Source, and AI Builder
• Learn how to create your first Flow
• Understand how your Flows can be integrated with your existing systems and applications such as Microsoft Teams

Power BI L100

Prerequisites: Familiarity with Excel and access to the Power BI Service

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

Teams L100

Microsoft Teams is the hub for teamwork in Microsoft 365 that combines video meetings, persistent conversations, file storage, and applications together in one place. Teams allows people to communicate more effectively and work better together in a custom and secure environment. This course is designed as an introduction to Microsoft Teams that will demonstrate the value of the tool and give attendees all they need to get started working in their first Team. 

Objectives:

• Learn how to create and participate in a Team, including how to navigate across requested modalities (e.g. desktop, mobile, tablet, etc.)
• Understand how teams fits into their collaboration and productivity workflow
• Learn how Teams integrates with Microsoft 365 and understand digital identity
• Work more efficiently with connected apps in Teams
• Get familiar with creating and participating in meetings

If you have any questions about any of these courses, contact the IT Help Desk (helpdesk@k-state.edu).