As part of K-State’s Office 365 subscription, the Microsoft Store provides free training on Office 365 applications. The following are the sessions scheduled for August:
- Aug. 5: Teams L100 – Register
- Aug. 9: Power Automate – Register
- Aug. 11: Outlook and Outlook Mobile L100 – Register
- Aug. 12: Teams L200 – Register
- Aug. 16: Excel L100 – Register
- Aug. 17: Word L100 – Register
- Aug. 19: Teams Meetings – Register
- Aug. 23: Power BI L100 – Register
- Aug. 25: OneNote L100 – Register
- Aug.26: Teams Live Events (organizer) – Register
See the session descriptions below.
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
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
Outlook and Outlook Mobile L100
This introductory course will expand on Outlook and Exchange Online basics, terms, and features of the
Outlook Desktop and Outlook Mobile applications.
Objectives:
- Understand the relationship between Exchange Online and Email Client
- Become familiar with accessing and navigating different modalities like Outlook Online, Outlook for Desktop, and Outlook Mobile
- Become an expert in the navigation of the Outlook for Desktop Client
- Understand new Microsoft 365 features in Outlook such as @Mentions and MyAnalytics
- Review advanced topics such as Import/Export and Rules
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
Power BI L100
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
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
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
Teams Live Events (Organizer)
Teams is for more than just communication and collaboration. Host a company-wide keynote presentation or host a digital event for larger audiences.
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
Word L100
Microsoft Word is part of the Microsoft 365 applications that can help you create and format documents, review work and track changes and polish your words with proofing reading tools, save and share your work to your
OneDrive. This course covers the fundamentals of Microsoft Word while introducing new features of the Microsoft 365 application.
Objectives:
- Understand the use of Word as a part of Microsoft 365 and various
use cases of the application - Learn the basics of navigation within Word
- Master Word tools such as Formatting, Insert, Design, and Layout
- Take your application usage to the next steps with references and
Curriculum Vitae (CV) assistance - Proof your document with Inspect, Save, and Share
