June 6, 2023 - Support Staff Conference in Sun Valley, ID - Microsoft 365

Posted on:  05/21/2023
June 6, 2023 - Support Staff Conference in Sun Valley, ID - Microsoft 365

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

  1. Cleaning up data
  2. Creating and working with PivotTables
  3. Using Dynamic Array functions
  4. Advanced Sorting
  5. Filtering Data
  6. Flash Fill
  7. Text functions
  8. Timelines in PivotTables
  9. Working with Slicers in Tables and PivotTables
  10. Power Query
  11. Conditional Formatting

Teams topics

  1. Top 10 chat tips
  2. Working with Polls
  3. Using Breakout Rooms
  4. Attendance Report
  5. Four meeting rolls in Teams
  6. PowerPoint Live
  7. Excel Live
  8. Teams Group Chat vs. Channels
  9. Going from Classic Teams to NEW Teams
  10. Outlook and Teams integration

Outlook tips

  1. Mail Tips
  2. Calendar Tips
  3. Outlook and Teams integration
  4. 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

SSC 2023 Sun Valley (Size: 579.9KB)

Recent Excel Articles

Excel 3D Reference - easily reference data on another worksheet

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

What is the Middle Class and Are You in the Middle Class?

What is the Middle Class and Are You in the Middle Class?

What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live.

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.

Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Excel Essential Skills you should know include AutoFit, Absolute Reference, Inserting and Deleting Rows and Columns, and why not to use Merge and Center.

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

The Contribution Margin is a company's revenue minus its variable cost. You can use the Contribution Margin to find the Breakeven Point.

Excel - Combine the SORT, UNIQUE, and COUNT functions

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

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.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel.

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

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

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. Teams Meetings
    1. Scheduling Meetings
    2. Meeting controls
    3. Roles in a meeting
    4. Sharing resources
    5. PowerPoint in a meeting
    6. Scheduling Team meetings from Outlook
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. Using apps in Teams
Lifetime access to Teams Course Beginner to Pro with coupon

Categories