Training Doyens

OVERVIEW Join Mike Thomas for an informative webinar to learn how to quickly and easily build reports and charts in Excel that summarize and analyze large amounts of raw data and help you to spot trends and get answers to the important questions. In this insightful webinar you’ll learn: ·          Calculating month-on-month difference ·          Calculating a running/cumulative total ·          Displaying a unique count LEARNING OBJECTIVES In this advanced Excel training , you'll learn how to calculate differences (e.g. month-on-month, quarter-on quarter) and running/cumulative totals. You'll learn how to display a unique count (e.g. number of customers, not number of orders) and how to use formulas to create additional calculated items. You'll learn how to create Slicers which are the new visual way to filter a pivot table. You'll also learn how to create pivot table in Excel from multiple tables and from external data. WHO WILL BENEFIT

OVERVIEW You may just be nervous or quiet in public, but others see you as aloof or unfriendly. If you want to overcome your social anxiety and awkwardness , join our upcoming webinar to learn how to calm your nerves, read the room, and respond thoughtfully. The webinar covers the following key areas: ·          How to let go of social anxiety at work by tapping into everyone’s secret shared desire ·          Recognizing perception vs. reality and how you can ground yourself in the moment ·          How to challenge yourself to gradually step outside of your comfort zone LEARNING OBJECTIVES This webinar will arm you with concrete skills for overcoming social anxiety and awkwardness in and out of the office. WHO WILL BENEFIT New and seasoned managers and leaders who are not “outgoing” or tend to be introverted. SPEAKER With more than 20 years of experience in the corporate/techworld, Mélanie Hope has learned hands-on the importance of clear, co

OVERVIEW FDA regulated companies want to transition to electronic records for economy and efficiency. FDA, because of its concern for patient safety, wants to prevent electronic records from being compromised with possible resulting harm to the patient. FDA has set up regulations that address both data security and patient safety. We will show how 21 CFR part 11 considers both. The confusion over the original FDA regulation and its subsequent “selective enforcement” will be explained. FDA requirements for 21 CFR Part 11 validation will be explained. The requirements are composed of technical and procedural aspects. Open, Closed and  H ybrid  (paper and electronic) systems will be explained. WHY SHOULD YOU ATTEND Companies want to transition to electronic records but are afraid of compromising their quality system and receiving 483’s at their next inspection. Part of this fear originates from confusion. FDA originally published a rather severe 21 CFR Part 11. After

OVERVIEW As enterprises have been growing far and wide, often international in scope, we find ourselves as executives and managers with our talent spread farther and farther, often at dozens and hundreds of locations.  How do we ‘get a better handle’ on all this? WHY SHOULD YOU ATTEND Are you concerned about how much time and productivity your people are wasting? What about lost energy, efficiency and effectiveness, especially because people are so “spread out”? Would you like to ‘tame the paper tiger’ and reduce so much needless paperwork? Have you ever been concerned about people “following the rules” … you know, ‘out of sight, out of mind’? Would you like to be able to more effectively spot problems, even when you are hundreds to thousands of miles away? If you answered “yes” to any of these questions, then come laugh, listen and learn as Chris DeVany leads us all through those important topics, key questions and

OVERVIEW Are you a Pivot TablePower User? Are you frustrated by the limitations of Pivot Tables such as lack of support for multiple tables, limited support for complex calculations, no support for "Big Data"?  If you ever need to create pivot tables from multiple datasets, Power Pivot is your friend. No more vlookup. No more multiple consolidation ranges. If you’ve been frustrated by other limitations of pivot tables then Power Pivot is for you.  Simply put, Power Pivot takes pivot tables and data analysis to the next level. If you’re a fan of pivot tables, you’ll love Power Pivot. WHY SHOULD YOU ATTEND If you work with, analyze and generate reports from large datasets in Excel, having a good understanding and working knowledge of Power Pivot is a must! how to use powerpivot AREAS COVERED Importing your data into Power Pivot Using the Data Model to create and manage relationships Hierarchies in PowerPivot Creating a pivot table

OVERVIEW Work remotely is becoming more of a norm in the tech industry. Various studies have shown that virtual team building is more difficult and it becomes harder for informal leaders to emerge tougher to create genuine dialogue, and easier for misunderstandings to escalate. Leaders must deal with an array of cultural issues that can include differences in business protocol, decision-making, dealing with authority, the concept of time, negotiation styles, and the emotional reactions allowed – or expected – in a business environment. In this webinar you will learn managing remote employees bestpractices including how to communicate, establish trust and build strong working relationships. remote employee engagement  WHY SHOULD YOU ATTEND There are a couple key techniques that are specific to remote management. Attend the webinar to learn how to supervise across time zones and even cultures. AREAS COVERED Create a virtual workplace strategy Develop, implement, an

OVERVIEW Management and leadership are two entirely different things. Many people function as supervisors without exhibiting the traits that position them as leaders with their staff members and peers within their organizations. Leadership is an intangible quality, yet it is key component of professional success. WHY SHOULD YOU ATTEND What is it that separates leaders from managers? It's a fact that the most effective supervisors are viewed as leaders by their subordinates and that the quality of a company’s leadership impacts its potential for strategic growth and long-term success. Whether you’re a small business owner, an executive, a supervisor, or a human resources professional, if you want to learn leadership and management skills and find out how to reach your potential as a manager, this webinar is for you. AREAS COVERED The nature of leadership  What leadership is not  How leadership differs from management  Characteristics of effective leaders