Upcoming Events and Webinars

Microsoft Excel: Preparing Data & Creating PivotTables

DATE:  08/05/2020

TIME:  9:00 am PDT / 12:00 pm EDT / 5:00 pm GMT

PRESENTER:  Tom Keen, New Horizons Instructor

A PivotTable is a dynamic Excel data object that enables users to perform data analysis by reorganizing and summarizing data. Often you have data in multiple worksheets. In this webinar, you’ll see how to prepare data and create a PivotTable from multiple local data sources.

Register Now

Tags: Microsoft Office|Excel

Leadership & Development - Courage in Chaos: An Introduction to Daring Leadership

DATE:  08/11/2020

TIME:  9:00 am PDT / 12:00 pm EDT / 5:00 pm GMT

PRESENTER:  Barb Van Hare, Brené Brown Certified Facilitator

While much of our personal attention has been focused on the extraordinary global year we’ve been experiencing, business professionals are faced with navigating the complexity of the new world of work. There has never been a more crucial time to find your courage. To be the daring leader you must be to navigate today’s challenges, you need to start with self, connect with others, and build your resilience to handle the inevitable setbacks. Dr. Brené Brown has spent over 20 years studying courage, vulnerability, shame, empathy, and brave leadership. This introduction to Daring Leadership is critical for business professionals at all levels including individual contributors, team leaders, department leaders, senior leaders, and HR professionals.

In this thoughtful webinar, you will:

Gain more awareness on the dynamics of change, complexity, and chaos

Identify typical reactions to chaos (yours and others) and the impacts on your work and life

Recognize the business case for courage and why being brave is worth it

Learn three things you can focus on to be brave and have courage in the chaos

Register Now

Tags: Leadership and Professional Development

Power BI, Part 2: Making Data Transformation a Breeze

DATE:  08/19/2020

TIME:  9:00 am PDT / 12:00 pm EDT / 5:00 pm GMT

PRESENTER:  Eric Satterfield, New Horizons Instructor

As the age of social media, Big Data, and the cloud continues to unfold, the various data sources that business users must weave together for reports is growing rapidly. Like many, you may find yourself having to tie data from Salesforce to Excel workbooks, CSVs to Access and SQL databases, or SurveyMonkey to data in Azure. This already-laborious process may only be further complicated by the fact that large portions of your data need to be trimmed, cleansed, wrangled, “macroed”, massaged, “VLOOKUPed”, and transformed before ever seeing the light of day.

Thanks to Microsoft Power BI, you can finally start putting your data transformation woes to rest. With the help of the Power Query Editor, you can apply powerful cleansing and transforming actions with the click of a button and record every step in the process, all without ever having to write a line of code.

Join us on August 19 for Part 2 in our Power BI webinar series in which we will explore just a few ways you can automate your ETL process with the Power Query Editor.

Register Now

Tags: Microsoft Technical