June 6, 2023 - Support Staff Conference in Sun Valley, ID - Microsoft 365
Posted on: 05/21/2023
Chris Menard is presenting in person for The Support Staff Conference for POWER Engineers on Tuesday, June 6, 2023. Menard's session will be Microsoft 365 Tips and Tricks for Excel, Outlook, and Teams.
Excel topics
-
Cleaning up data
-
Creating and working with PivotTables
-
Using Dynamic Array functions
-
Advanced Sorting
-
Filtering Data
-
Flash Fill
-
Text functions
-
Timelines in PivotTables
-
Working with Slicers in Tables and PivotTables
-
Power Query
-
Conditional Formatting
Teams topics
-
Top 10 chat tips
-
Working with Polls
-
Using Breakout Rooms
-
Attendance Report
-
Four meeting rolls in Teams
-
PowerPoint Live
-
Excel Live
-
Teams Group Chat vs. Channels
-
Going from Classic Teams to NEW Teams
-
Outlook and Teams integration
Outlook tips
-
Mail Tips
-
Calendar Tips
-
Outlook and Teams integration
-
Web features coming to the Outlook desktop
7 Tips for Outlook Destkop
Location - Sun Valley Lodge in Idaho
Guests are presented with 108 guestrooms, a 20,000 square-foot destination spa, a world-class fitness center and yoga studio, a glass-enclosed outdoor pool and pool café, as well as restaurants, lounges, lobbies, and event space.
Sun Valley Lodge in Sun Valley, ID
-
Tuesday, June 6th - Limelight B - Sun Valley Inn
-
Microsoft 365 Tips and Tricks for Excel, Outlook, and Teams (Presenter: Chris Menard)
-
10:30 am to noon and 1 pm to 2:30 pm
SSC 2023 Sun Valley Downloads
Recent Excel Articles
Excel - Combine the SORT, UNIQUE, and COUNT functions
Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.
Other Recent Articles
Microsoft Word to Adobe Acrobat with Bookmarks
We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.
MS Forms - 3 new features: Format surveys, send to specific users, and receipt
Microsoft Forms has three new features that were recently rolled out. I'll cover all three in under three minutes. You can now format your surveys or quizzes using bold, italics, or underline. You can also send a survey out to specific users or groups in your organization, and you can have users get a receipt of their responses.
Chris Menard Teams Online Training Course
50% off Coupon
Just some of the topics covered
-
Navigation Teams
-
Using private Chat
-
Using group Chat
-
Teams Meetings
-
Scheduling Meetings
-
Meeting controls
-
Roles in a meeting
-
Sharing resources
-
PowerPoint in a meeting
-
Scheduling Team meetings from Outlook
-
Working with Teams and Channels
-
Conversations
-
Files
-
Wiki and OneNote
-
Using Outlook and Teams
-
Using apps in Teams
Categories