Live Webinar – March 30th, 2022 12:00 pm – 12:30 pm EDT
Activity Type: Education – Course or Training 1 Hour 1 PDU
Provider: MPUG WebnLearn ( REP 1369 )
Mpug Member Free – Members only event
In this training you’ll learn some powerful tips, tricks, and shortcuts to help you become more productive in your use of Excel.
Learn how converting list-based data into a Table can save you a ton of time. Learn how to quickly and easily combine data from several cells and how to break apart data stored in a single cell. Learn how to change the appearance of data in cells based on the cell value or the value in another cell.
When it comes to formulas, Dynamic Array Functions and XLOOKUP are the new kids in town and are a real game-changer when it comes to simplification.
Finally you’ll get a glimpse of the power of the Query Editor which lets you turn poorly-structured and untidy data into useable data with a few simple clicks.
Learning Objectives/Topics Covered:
- Tables: What are the benefits of storing list-based data in a Table and how to create and manage Tables
- Use CONCATENATE, Text-to-Columns and Flash Fill to combine and split data
- Conditional Formatting: What is it and how to use it
- Dynamic Array Functions: SORT, UNIQUE and FILTER are 3 new functions that are a potential game-changer to the way that worksheets are designed and constructed (Microsoft 365 Only)
- XLOOKUP: A modern, flexible and more powerful replacement for VLOOKUP and HLOOKUP (Microsoft 365 Only)
- The Power Query Editor: Learn how to restructure and clean data in seconds!
Presenter: Mike Thomas (LinkedIn profile) an SME in IT training business since 1989, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
If you are NOT ALREADY a member JOIN MPUG!
This event is for members only BUT… You can take one of the MPUG Certificated Masterclass (Usually 6 Category A PDUs) Or over 30 other Category A PDUs for free each year. The $129 Per Year Membership Fee is a terrific value!
MPUG Membership includes:
- MPUG’s Project Server and SharePoint certificated courses available to members
- Over 30 other virtual PDU events per year
- You can network with other MPUG (Microsoft Project Users Group) members at in person meetings and events.
- Work with Microsoft MVPs in MS Project Project Server & SharePoint
- And so much more …
Click to register for:
Excel: Quick Tips To Help You Be More Productive
| 0.5 | 0 | 0 |
| Technical Project Management | Leadership | Strategic & Business Management |
NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.
