A lunch and learn is an informal, less structured, hour long, lunch time training event covering a need to know topic for a company’s employees. This course helps students learn how to create and present an effective and successful meeting. Students will learn how to select a topic, create an agenda, design a presentation, schedule a Lunch and Learn, and make the presentation.
This course covers the basic functions and features of Project 365. Students will learn how to create, and enter task information into Project plans. They will learn how to manage project resources and assign them to tasks. They will also create custom project elements such as calendars, tables and views that can be used to monitor and manage important project information.
This course will cover topics from the Microsoft MS-101 exam, which measures a student’s ability to accomplish the following technical and administrative tasks: Identify threat vectors; use Secure Score; configure Azure Identity Protection; configure Exchange online protection; implement modern device services; implement Microsoft 365 security and threat management; and manage Microsoft 365 governance and compliance.
This course will cover topics from the Microsoft MS-100 exam, which measures a student's ability to design and implement Microsoft 365 services, manage user identity and roles, manage access and authentication, and plan Office 365 workloads and applications. In this course, students will review how to configure Exchange Online and SharePoint Online, how to work with Office Pro Plus, and how to migrate to Office 365. Students will also learn how to configure Microsoft 365 Tenant, how to manage user and security groups and licenses, and how to use authentication in 365.
This course is an introduction to Office 365 Sites. Upon completion of this course, users will have a basic understanding of SharePoint Sites and Sites structure, navigation, libraries, searching, newsfeeds, views, permissions, and organization. Students will learn the differences of Libraries and Lists and how to create different kinds of Libraries and Lists, add files to Libraries, add items to Lists, learn to use the Newsfeed to keep abreast of action on the site, and create and customize Views. In addition, students will explore Site and content organization, understand navigation of sites, search for content, and learn the basics of Permissions.
This course gives students a comprehensive overview of Flow, an office 365 app which allows users to create automated workflows between apps in order to receive notifications, and synchronize files, collect data. In this course, students will review the various types of Flows, learn how to build a Flow, and how to work with actions. They will also learn how to use approvals as well as how to share, import, and export a Flow.
This course is an introduction to, and in-depth look at the OneNote 2016 program. During the course, students will learn how OneNote can help them to organize their notes more efficiently, and allow them to access their content from anywhere. Students will also learn how to share the contents of their OneNote notebooks with others, and collaborate.
This course is designed for advanced Microsoft SharePoint site owners and administrators who want to integrate data sources, customize content types, and automate common tasks using workflows. Students will learn about SharePoint Designer and connecting to sites, explore the interface and learn about Designer best practices. Additionally, students will create and modify libraries and lists using Designer, and modify site settings using Designer. Students will get an introduction to workflows and create list and site workflows, adding stages and steps, work with workflow settings, create variables, error check, and publish workflows. Students will learn about important workflow actions, then view a complete list workflow demonstration.
This course is designed to give users an understanding and the skills to troubleshoot Windows 10. In this course, students will become familiar with the troubleshooting process and available tools, troubleshoot the boot process and drivers, trouble shoot login and user profile issues, troubleshoot network issues and group policies, and much more.
This course introduces the user to Microsoft InfoPath 2013, a tool that allows you to create forms and gather data. In this course, you will learn how to use InfoPath within SharePoint and how to create, edit, and publish a form. You will also look at working with list forms and how to properly utilize the different controls and their associated properties. This course will also review some of the more advanced features of InfoPath, such as creating and modifying a data source or working with repeating sections. Finally, you will look at how to use InfoPath forms within Sharepoint using WebParts.
This course introduces the user to Microsoft PowerApps, a tool that allows you to create forms and gather data. PowerApps is part of the Microsoft 365 suite and is the successor to InfoPath. In this course, you will learn how to modify SharePoint List Forms using PowerApps as well as how to work with PowerApp formulas. This course will also review some of the more advanced features of InfoPath, such as working with data sources. Finally, you will look at how to distribute your PowerApp, including how to share, embed, and export your app.
This course will teach students proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.
Slack is a collaboration software tool that allows teams to work together to share information and communicate through calls. Slack features organized conversations, a searchable history, and allows teams to work with external users. This course will provide an in-depth look at Slack, including joining a workspace and working with channels. It will also look at how to send and view messages as well as make calls to others. Finally, it will look at how to share files and to improve efficiencies search techniques and shortcuts.
This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.
This course will cover the Office 365 program Power BI. Power BI is a powerful business intelligence tool for analyzing your data and presenting it visually. This course will cover both the Power BI web app as well as the Power BI Desktop app. Topics covered include getting started with Power BI, connecting to data, visualizing data, publishing your visualizations in dashboards and reports, and connecting to other apps like Excel.
In this course, students will get started with PowerPoint 365 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, various graphic options and insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options.
This course teaches the basic functions and features of Visio Professional 365. The primary focus is to get acquainted with creating the different diagrams using the stencils and templates. You will learn how to draw basic shapes and compound lines and arrange objects. You will also learn how to create diagrams, work with text, and apply formatting. Finally, you will create organization charts and brainstorming diagrams, set shape properties, and work with pages.
This course is designed to familiarize users with the Microsoft Windows 10 operating system. Users will login and learn basic functionality and navigation, review new functionality to Windows 10, review file management and customization with File Explorer, customize and personalize various areas of the Windows 10 operating environment, and work with applications and programs including installing, updating, and troubleshooting.
This is the intermediate course in the Microsoft Word 2019 series. This course expands upon the topics covered in the Word 2019 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.
This is the intermediate course in the Microsoft Word 365 series. This course expands upon the topics covered in the Word 365 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.