Training Events Open to the Public

Excelling at Excel
IAAP Dallas Branch Program
Learner Outcomes:
- Apply Tips & Tricks in Microsoft Excel
- Customize the Excel User Interface
- Improve Productivity by Implementing New Skills
- Increase Marketability for New Job Roles
- Gain Confidence with New Skill Knowledge
This program is approved for one (1) recertification point.
Login information will be sent by the Branch Director prior to the event.
Branch Director: Jennifer Sanders, CAP (jennifer.sanders@willistowerswatson.com)

Microsoft Excel | Fantastic Functions
Isn’t it time you moved beyond the AutoSum? This hands-on workshop will introduce a variety of new functions you can use in your daily Excel work. Text, Logical, Lookup and Financial Functions will be covered.
- Formulas vs Functions
- Order of Operations
- Function Examples
- Text
- Logical
- Lookup
- Financial
This will be held live online via Zoom. Link available upon registration.
Limited seating available in our learning center at 239 S Pattie St, Suite #2, Wichita, KS 67211.

Get Groovy with Google
A beginner’s guide to all the Google basics to manage your small business or your personal planning.
- Gmail
- Calendar
- Contacts
- Google Docs
- Google Drive
Event will be held virtually, live online via Zoom. Link available upon registration
Classroom seating is available in the Pen Learning Center at Dawn Monroe Training, 239 S Pattie, Suite #2, Wichita, KS 67211. We can offer a few safely socially distanced seats. The training will be simultaneously broadcast live online from our classroom.

Notebook Know-How
Microsoft OneNote
IAAP Inland Empire Region Program
An introduction to Microsoft OneNote and it’s functionality in the modern workplace. OneNote is a digital version of a physical notebook that allows you to capture digital notes and keep them organized. You can add images, diagrams, audio, video, and more. Get timely information about integrations with Microsoft Teams!
- Apply Tips & Tricks in Microsoft OneNote
- Customize the OneNote User Interface
- Improve Productivity by Implementing New Skills
- Increase Marketability for New Job Roles
- Gain Confidence with New Skill Knowledge
Recertification Points: 1
Regional Director: Brenda Van Meter
12:00pm-1:00pm PACIFIC TIME
2:00pm-3:00pm CENTRAL TIME

Microsoft Excel Tips & Tricks
Back by popular demand, Certified Microsoft Office Specialist Master, Dawn Monroe, will return in 2021 with another spreadsheet session. Join us for an informative and fun program learning Microsoft Excel Tips & Tricks you can apply right away to manipulate your data more efficiently.

Microsoft Planner: The Best Laid Plans
Learner Outcomes: (What will attendees learn or be able to do after attending your program)
- Gain an understanding of the Microsoft Planner App
- Create and Assign Tasks
- Organize with Buckets & Labels
- Strategize Implementation within Microsoft Teams
- Integrate with Microsoft Outlook

Forms that Function
Microsoft Forms and Google Forms
Build functional forms, surveys, quizzes and polls with Microsoft or Google Forms. Begin with a template or create your own form from scratch. These powerful tools are great for capturing registrations, feedback and many other data collection activities. In business organizations, it can be used to collect customer feedback, measure employee satisfaction, improve your product or business, or organize company events. Gather results in a spreadsheet and you are ready for next steps.
- Compare the Microsoft Forms & Google Forms – What is right for you?
- Gain an understanding of the Forms App
- Generate Ideas for Usage in Business or Education
- Create Forms & Quizzes
- Designate Question Styles & Customize Form Settings
- Share for Responses vs. Share for Collaboration

Microsoft Teams Talk
Learn to collaborate in the Microsoft 365 chat-based workspace, Microsoft Teams. Navigate, communicate, organize, customize and optimize with unique Teams and Channels in your organization.
- Navigate the Microsoft Teams workspace
- Communicate with Audio, Video, Conversation & Chat features
- Organize with Teams, Channels and File Storage
- Customize using Connectors and turn Apps, Files and Websites into Channel Tabs
- Optimize by Integrating Microsoft OneNote
I will present live online via Zoom so that you can open and experiment with Teams while I teach without fear of messing up the meeting! Teams is so much more than just the meeting calls.
Limited seating is available in the learning center at 239 S Pattie, Suite #2, Wichita, KS 67211.

Presentations that Pop
Microsoft PowerPoint
Yes, you can make and run a presentation, but what about the advanced stuff? Join us to learn HOW to insert video and audio clips that actually play when you want them to, add animations that impact your message, learn tricks to jump to slides and websites without losing your cool in front of your audience.
We’ll cover:
- Audio & Video
- Animations
- Morph Transitions
- Slide Masters
- SmartArt
- Photo Albums
- Dictate
- Live Subtitles
Taught by certified Microsoft Office Specialist Master, Dawn Monroe, this session will be packed with great takeaways!
This event will be held via Zoom.
Limited seating available in our classroom at 239 S Pattie, Suite #2, Wichita, KS 67211.

Excelapalooza FanGirl Tips & Tricks
Conference Breakout Session at IAAP Midwest Region Event
Learn about Microsoft Excel new features, functions and tricks you may have missed! Join the data management conversation discussing HOW to reduce errors in your spreadsheets. And wrap up with favorite tips and tricks, many gathered at last year’s Excelapalooza conference directly from the Excel MVP’s.
- Explore Recently Released Features
- Discuss Data Management
- Reduce Potential Errors
- Preview New Functions
- Enjoy FanGirl Favorites
Approved for IAAP Recertification Points: 1
Session of the IAAP Midwest Regional Conference – Registration and details coming soon!