American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session
Posted on: 11/20/2022
I presented to over 500 Administrative Professionals this past week. My presentation was Microsoft 365 New and Upcoming Features. Below are videos of some of my most popular topics during the session. The event was held by The American Society of Administrative Professionals (ASAP) on November 17, 2022.
About ASAP
The American Society of Administrative Professionals (ASAP) is the leading provider of education and training for administrative professionals and executive assistants. ASAP is a community and a resource for administrative professionals to seek the latest role-specific training, develop skills and earn recognition.
Join ASAP for free
Chris Menard's Topics for the November Annual Event
-
Outlook
-
Teams
-
Excel
-
Word
Microsoft Outlook - New Desktop look
Microsoft Outlook on the web and Outlook desktop have similar features. Still, they have a different look, and Outlook on the web has several remarkable features that the desktop version doesn't. Microsoft is working on having one codebase. Outlook desktop, at some point, will have a new look, and these features will be incorporated.
Overview of new features in Outlook desktop coming soon
-
Pin Messages
-
Snooze Email
-
Delay Delivery
-
Undo Send
-
Calendar Board
-
Day View Change by Keyboard
-
Suggested Times for Meetings
-
Multiple Timezones
Microsoft articles on the new Outlook desktop
Early First Look - Outlook Desktop Video
Overview of new features in Excel coming soon - Two new image features
Excel has a new IMAGE function coming out. I'm already using this frequently. Another great image feature is Data from Image. It is the ability to use a screenshot or add an image to Excel, and Excel will analyze the data and convert the image to text and numbers.
Early First Look - Excel Image Video
Overview of new features in Teams out now or coming soon
Teams has a new Send Chat Later feature coming out in December 2022. Another great feature already out is the ability to record a one-minute video clip in a chat. It can be a one-on-one chat or a group chat. Record a video clip is a great way to say hello to a new team member or do a short follow-up after a meeting.
Early First Look - Teams features
Chris Menard's Microsoft Teams Training Course - 2.5 hours of online training
Do you or your company need Microsoft Teams training? Chris Menard's online Teams training course is available on two platforms. Below is a coupon for 50% off the training course. It is 2.5 hours of material, and any new Teams features are added to the class.
50% off coupon for Teams online training
Other Recent Articles
Excel - Advanced Filters
Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at multiple fields but for different criteria. For example, I want to filter and only see people in Georgia and New York. That is easy to do and can be done with the drop-down filter. But, for Georgia, I want to see people who are Single, and for New York, I want to see Family. That requires an Advanced Filter.
3 AWESOME TIPS when working with OneNote & Outlook
Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. Tip 1 - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes.
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.
Excel - IF Function using AND and OR
One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.
Catch Chris in-person in 2023. Possible speaking events
-
EA Ignite - April 19 to 21, 2023 - Baltimore, MD. EA Ignite is an exclusive training event limited to 500 of the country’s senior-level executive assistants and administrative professionals.
-
Georgia Society of CPAs - The Southeastern Accounting Show in August 2023. Chris is a frequent speaker at this annual event for CPAs. His multiple sessions usually cover Analyzing Data in Excel, Latest features in Excel, Mastering PivotTables, and Microsoft 365 New and Upcoming Features.
-
Administrative Professionals Conference - October 22 to October 25, 2023 - Las Vegas, NV. Over 2,000 Administrative Professionals and Executives attend this annual event.
Chris Menard
Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube
Categories
