Kansas State University

• March 3: Word L200 – Register
• March: 8: Teams L100 – Register
• March 9: Power Automate – Register
• March 15: Teams L200 – Register
• March 16: Lists – Register
• March 18: Excel L200 – Register
  This session has been rescheduled from 2-3:30 to noon-1:30.
• March 22: Teams Meetings – Register
• March 24: Power BI – Register
• March 29: Teams Live (Organizer) – 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 L200

Take a dive into the intermediate features of Excel formatting, functions, and accessibility. Attendees taking this course should have a strong understanding of Excel’s basic features, 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

Register

Lists 

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

Register

Power Automate

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

Register

Power BI

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

Register

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

Register

Teams L200

Objectives:

• Revisit application navigation to fortify understanding and introduce advanced features
• Deep dive into integration with Microsoft 365 and third-party apps (e.g. Tabs, Apps, Bots)
• In-depth look at SharePoint Online integration and document collaboration
• Best practices for pre-meeting, meeting, and post-meeting
• Utilize best practices for increasing response rates and managing their own notifications
• Use Command/Search bar to navigate and find content more quickly

Register

Teams Live Events (Organizer)

Teams is for more than just communication and collaboration. Host a companywide keynote presentation or host a digital event for larger audiences.

Objectives:

• Organizing a Teams live event including creation and sharing
• Presenter functions including screen sharing, audio and video
• Best practices to consider

Register

Teams Meetings L100

Objectives:

• Understand meeting scenarios
• Experience the meeting lifecycle and how to utilize Teams for better collaboration
• Learn to schedule meetings from Teams or Outlook
• Optimize settings to look and sound your best on camera during video meetings
• Make use of all features within Teams meetings (e.g. whiteboard, etc.)
• Utilize the meeting recording, notes, and chat for ongoing collaboration

Register

Word L200

This course will teach how to take word documents to the next level with advanced features. We will be looking at some of the advanced features including comparing and merging documents, creating and formatting a table of contents, document translation, and more.

Objectives:

• Review where to find relevant features with the Ribbon
• Learn how Compare and Merge can save time
• Organize your work by creating a Table of Contents
• Gather ideas and thoughts with Comments and Suggestions
• Learn to quickly translate your work in sections or the entire document.
• Convert documents into emails with Mail Merge, while preserving
  Formatting Options

Register

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