Melissa Esquibel began her career in audit and data security at a time when systems and hardware were kept in tightly secured boxes, and IT gatekeepers doled out functionality within a rigid systems architecture. Now, in the present, where end-users know how to access the power of technology independently and according to the agile timelines they require, this push and pull has created quite a mess in many organizations. With her unique experience as the conduit between the gatekeepers and the gate Stormers, she offers a unique perspective as “bridge-builder” in training programs designed to make sense of new productivity platforms, like Office 365 and G Suite and ensure effective implementations.
For most organizations, the “how” of communications is not as defined as the “what.” But it may be every bit as important. In this topic, we discuss the various ways organizations use these methods of communication, how governance may be applied, what the legal implications may be and how to get everyone on board. Knowing which methods of communications are being employed and for what is only half the battl..
Some have learned how to connect data sources using Excel's powerful Power Query tool. But, did you know that you can also repair data right in Power Query? We’ll cover the different types of repairs you can affect in Power Query and how these can be made durable over time and data refreshes. We’ll also show how multiple datasets can be used together to create new fields that can be aggregated and calculate..
We’ll begin by understanding what exactly a Pivot Table is and why they’re so popular! You’ll learn how your data should be set up in order `to take advantage of this and other Excel tools. You’ll even learn some valuable clean-up steps that turn data that’s not ideal into data that can support key decisions, become the infrastructure for dashboards, and answer questions in a snap. Once we go through the ba..
Often the user community has moved from a well-understood structure of network shared drives and email attachments to, what must seem like, the wild west. In this program, we will pull back the covers on the structures used to organize people and share information in an Office 365 world. You’ll get a look at Teams App, Outlook, SharePoint, and how these work together to create a collaboration platform for y..
The worst error you can get in Excel is the wrong information. In this session, you’ll first learn what can go wrong in your Excel workbooks that might deliver inaccurate information and how to prevent it. You’ll discover ways to build integrity checks to make sure your data stays reliable. We’ll cover the pros and cons of each protective measure, enabling you to make the right decision for your workbooks. ..
In the recent past, it was necessary to have some coding skills, an available data analyst or some very strong VLOOKUP skills in order to join related datasets to perform meaningful data analysis. With the new Get & Transform tools and Power Query (which you probably already have, but don’t know it!), you can do this sort of thing yourself with a few clicks. Over the past several versions of Excel, Micr..