Excel Quick Tips to be More Productive

Content Restricted

Sign up for MPUG Membership to view this on-demand webinar and get unlimited access to our Webinars

Event Description

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.

Supporting Lesson Files for Download

[wpdm_package id=’512624′]

[wpdm_package id=’512621′]

Project Management Institute (PMI)® Professional Development Units (PDUs):
This Webinar is eligible for .5 PMI® PDU in the Technical category of the Talent Triangle.

 

Next Webinar

Overview of the PMBOK® Guide Seventh Edition - Lesson 1

Written by TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, 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 for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. 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.
Share This Post
Have your say!
10

Leave a Reply