Mastering Synergy: Excel & PowerPoint
What you'll learn
- Recognize principles for effective communications when using Excel
- Recognize principles for effective communications when using PowerPoint
- Understand psychological motivators for communications
- Recognize examples for better communications
- Basic knowledge of Excel and PowerPoint applications
This course is designed to help you master the art of effective communication by introducing you to innovative and captivating techniques. As a project manager, you are often responsible for driving progress and achieving goals. To accomplish this, you need to be well-versed in the tools that facilitate productivity. In this course, we will focus on two such tools: Excel and PowerPoint, which are widely recognized as the standard Microsoft Office suite applications in most office environments.
While these software tools have been known to produce both spectacularly good and spectacularly bad outputs, it is important to note that the quality of the output is not solely determined by the tool itself, but rather by its usage and the user’s proficiency.
Rather than providing an in-depth tutorial on specific features, this course will delve into strategic considerations when using Excel and PowerPoint. We will explore how to leverage these applications to their full potential, guiding you through a comprehensive example from start to finish. By focusing on key concepts, this course aims to equip you with the necessary skills to utilize these tools effectively within a short timeframe.
The course is divided into two parts. The first part will delve into the psychological aspects of working with Excel and PowerPoint, helping you develop a mindset conducive to success. The second part will provide a step-by-step demonstration of how to utilize these tools through a practical example.
Who this course is for:
- Beginner to Intermediate Project Management Professionals
I'm a big fan of data crunching, data analysis, effective communication and using a bit of psychology to tell a story.
My first introduction to spreadsheets was Excel 95 and I was hooked so I guess I'm a data crunching nerd. I was a casual user until I really needed to use it for data analysis ten years ago. The group I worked for was looking at product failures and trying to convince the engineering teams to change. It was easy...not! But that's when I discovered Pivot Tables and all those great look-up functions. I could plug in historical data, run it through Excel and make all these fancy charts. Then I actually got an engineering team to add a feature!
Of course it wasn't all data that convinced people to do things. The other side was communication; telling a good story and giving the WIIFM (What's in it for Me?). I've spent a lot of time putting together visual communications using PowerPoint so I guess you can say I'm well versed in that too. Powerpoint is a great tool to tell a story and can definitely influence without too much text (hint: high quality images).
Lastly I'm a fan of psychology, especially individual behavior and group dynamics. What makes people tick and how to influence for the greater good.