Training Doyens

OVERVIEW Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what they, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way. You and your staff will be instantly more productive in Excel. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session. WHY SHOULD YOU ATTEND Attend this webinar if you use Microsoft Excel on a regular basis and want to take your knowledge to the next level. AREAS COVERED ...

  OVERVIEW Many of us use Excel to create reports, dashboards, and graphs. While Excel is very versatile and includes chart templates, it does not incorporate design best practices. In this hands-on webinar, you’ll learn how to transform built-in Excel templates into graphs that incorporate the art and science of data visualization. Bonus: Rebeca will share Excel data visualization templates that she created and that you’ll be able to use moving forward. WHY SHOULD YOU ATTEND This is a hands-on webinar. In addition, Rebeca will be sharing templates of well-designed charts that you’ll be able to use moving forward to immediately elevate your data visualization skills. AREAS COVERED .  Excel data visualization tools .  Overview of charts available in Excel and how to add a chart in Excel .  Apply the 3Cs (Concise, Clean, Clear) to improve your data visualization in Excel .  Illustration of step-by- step improvements of three data visualizations ....

Customer Service One of the prime factors that drive a business towards success is great customer service.No matter how great your product is or how talented employees you have in your organization, if your customer service isn’t good, your business won’t thrive. It isn’t very easy to provide awesome customer services and it requires skills and well thought strategies. Research suggests that if people receive good customer service they tell 2 or 3 people but if it’s bad they tell 10 to 12 people. In this scenario where recommendations and word of mouth hold such great value, it’s extremely important to be consistent in delivering great customer services. Even if you have been recognized as an excellent organization in terms of customer services, you need to constantly upgrade and refresh your skills to keep your customers consistently satisfied. Your customer service team is the face of your company and their skills determine the experience of your customers. Here are some...

OVERVIEW No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, MS Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer.  Thistraining focuses on what you need to know to create an interactive professional-looking dashboard using MS Excel.  You'll learn how to: make the Excel Dashboards maintenance-free when new data becomes available; create the pivot tables needed to drive the dashboard; create great looking visuals; add interactivity using slicers; automate elements of the dashboard with a macro and protect the cells containing critical formulas. WHY SHOULD YOU ATTEND In this advanced Excel training session, you'll learn how to create a stunning, interactive professional-looking dashboard using MS Excel. AREAS COVE...