November 6-8, 2023 - EA Ignite Conference in Austin, TX

Posted on: 08/24/2023

What is EA Ignite?

EA Ignite is an exclusive training event limited to 500 like-minded peers. Take advantage of immersive training with today’s leading experts and spark conversations with other attendees around today’s innovative processes. If you support a C-suite-level executive, then EA Ignite is for you.

EA Ignite - Fall Conference

Location: Austin, TX
Hotel: JW Marriott
Dates: November 6 - 8, 2023
Photo gallery: https://www.marriott.com/en-us/hotels/ausjw-jw-marriott-austin/photos/
Website: https://www.eaignite.com/fall/

EA Ignite is an exclusive training event limited to 500 like-minded peers. Take advantage of immersive training with today’s leading experts and spark conversations with other attendees around today’s innovative processes. If you’re someone who supports a C-suite level executive, then EA Ignite is for you.

Chris Menard's Sessions at Fall's EA Ignite

Menard will present two sessions at EA Ignite's Fall Conference.

Microsoft Teams 2.0 (New Teams): What’s New and What it Means for You
Microsoft’s AI Tools: How Technology Works for You

Microsoft Teams 2.0: What’s New and What it Means for You

Date: Monday, November 6, 2023 at 12:30 p.m.

Webpage https://www.eaignite.com/session/microsoft-teams-2-0-whats-new-and-what-it-means-for-you/

Microsoft Teams came out in 2017. Teams is much more than a messaging app or video conferencing platform. Teams usage has gone up dramatically since its inception.

Microsoft Teams is a collaboration app. Teams handles chat, video calls, audio calls, schedule meetings, polling, and file integration with SharePoint and OneDrive, and supports hundreds of apps. Teams was built for the modern workplace. Teams allows you and your team to stay informed, organized, and connected — all in one place.

Microsoft’s AI Tools: How Technology Works for You

Date: Tuesday, November 7, 2023 at 12:30 p.m.

Webpage https://www.eaignite.com/session/microsofts-ai-tools-how-technology-works-for-you/

Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze Data on the Home tab and the ability to get data from a picture or screenshot.

In PowerPoint, we have the Rehearse with Coach. It will tell you if you speak too fast, slow, or use too many filler words. Teams and PowerPoint allow us to view live captions and even view the captions in another language.

Teams will do a meeting recap (part of Teams Premium.) Word has translation features, the Resume Assistant. Outlook has FindTime app to create and automatically schedule meetings with voting polls. There are other examples of AI in M365, but these are some of the popular features.

Video: AI in Microsoft 365

Video: AI in Excel - Analyze Data

Analyze Data in Excel allows you to use natural language queries to understand your data. With Analyze Data, there is no need to write complex functions like SUMIF, SUMIFS, COUNTIF, or COUNTIFS. In addition, Analyze Data provides charts, graphs, PivotTables, and summaries automatically.

LinkedIn Post

Recent Articles

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web has many features that Outlook desktop doesn't have. I'll cover three calendar features that Outlook on the web has that Outlook desktop doesn't provide.

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Your inbox in Microsoft Outlook can become overwhelming to manage. The average office worker receives around 121 emails every workday. Microsoft Outlook has some easy commands located on the Home tab to help manage your inbox.

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 in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP

You can set up a relationship with two or more tables in Excel to create a PivotTable. XLOOKUP and VLOOOKUP also work, but you can skip those great functions and set up Relationships. For example, one Excel table contains the Employee ID and name.

Excel PivotTable - Table VS. Range as source - Which is better?

In Excel, a PivotTable can be based on a Range or on a Table. I encourage you to base your PivotTable on a Table. Initially, both a range and table will be correct.

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.

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.

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