Microsoft Technology Bundle

This bundle encompasses the major aspects of Microsoft tech. With focuses on Excel, PowerPoint, and Office 365, ou will learn how to maximize the tools your office uses.

Excel Hacks: Capitalize on the Power of Flash Fill and Power Query - Anne Marie DelPrincipe

Microsoft Excel is more than just a great spreadsheet program—it’s a powerful tool for organizing and analyzing information. Excel is also a major source of frustration when new data arrives in formats, fields, and columns that aren't so helpful. 

Learning Objectives: 

• Use Flash Fill to combine and extract names, format numbers, move text around in order to create new information
• Transform data into normalized tables and fill in blank cells 
• Separate dollars and cents; combine text, currency and date, and separate hours from minutes
• Find duplicates across multiple tables

PowerPoints SIMPLIFIED! Building Presentations for Maximum Impact - Kim Greenwood

Have you ever sat through a dull or confusing PowerPoint presentation and walked away wondering, “Now, what do I do with that information?” Do you worry that your own audiences may feel the same thing about your PowerPoints?

Learning Objectives: 

• Recognize and remove common obstacles that sabotage presentations
• Identify strategies to truly connect with your audience
• Implement simple design strategies to enhance your messaging (including how to best share large amounts of data within a presentation)
• Review presentation tips to maximize results

Understanding Office 365 Collaboration - Neil Malek

In the beginning, there was SharePoint - Microsoft's tool for sharing and collaborating on files with your coworkers. Over the last five years, they've now introduced tools like Teams and Office 365 Groups, and your choices have gotten more complicated. If you have an Office 365 subscription, it's vital that you understand what each of these tools are good for, and what your organization can use to improve your processes.

Learning Objectives:

• Understanding the Benefits, Overlaps, and Differences between OneDrive, SharePoint, Teams, and Office 365 Groups
• Use Cases for Office 365 Groups
• Creating and Using Teams
• Integration between SharePoint Sites and Teams
• Sharing and Coauthoring Files
• Communication Preferences
• Office 365 Integrations