As part of K-State’s Office 365 subscription, the Microsoft Store provides free training on Office 365 applications. We have scheduled the following sessions with them for May:
- 5/2- Tasks 100 – Register
- 5/5 – Teams L100 – Register
- 5/9 – Teams Channels and Files – Register
- 5/12 – Power BI L100 – Register
- 5/16 – SharePoint L100 – Register
- 5/19 – Excel L100 – Register
- 5/23 – Lists – Register
- 5/26 – OneNote L100 – Register
All of the above sessions will be from 2-3:30 p.m. Registration is required. After you register, a confirmation will be sent to you with a link to the session.
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
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
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 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
SharePoint L100
This course focuses on the SharePoint Online experience. Attendees will learn how to share and manage content, find information, and collaborate with others.
Objectives:
- Successfully navigate SharePoint team and communication sites.
- Understand Microsoft 365 groups.
- Work with SharePoint document libraries.
- Share files and folders with users outside of a group.
- Utilize shared resources in team sites including lists, plans, and notebooks.
Tasks L100
This course introduces the unified task experience in Microsoft 365 with a focus on To Do and Planner.
Objectives:
- Manage your work with tasks across Microsoft 365.
- Work with tasks in Outlook, shared Office documents, and in Teams.
- Manage individual tasks and build “your day”.
- Assign team tasks and build a plan.
- Explore various views to get the most out of task management.
Teams Channels and Files
This training focuses on Team channels and working with shared
files. Channels are where work gets done it is where you’ll find
conversations, apps, and shared files.
Objectives:
- Understand shared resources in Microsoft Teams.
- Learn about owner, member, and guest capabilities.
- Organize teamwork using channels.
- Work in channels by having conversations, sharing files, and
connecting apps. - Collaborate on shared files.
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, contact the IT Help Desk (helpdesk@k-state.edu).
