Training Doyens

When you can visualize and communicate the important insights in your business, you are far ahead in many different areas. Our upcoming webinar discusses how to create icon- and map-based visuals, as well as dynamic dashboards that update as your data changes. The webinar covers the following key areas: ·        Data visualization tools in Excel for creating graphical charts with symbols, pictures, maps, and more ·        Highlighting relevant data dynamically with conditional formatting ·        Leveraging essential design skills to understand and deliver for your audience LEARNING OBJECTIVES Excel can create an incredible assortment of chart and visualization types, far beyond the bar charts and pie charts you’ve seen a thousand times. In this session, we’ll demonstrate how to create icon- and map-based visuals, as well as dynamic dashboards that update as your data changes. ...

OVERVIEW Use a SmartArt graphic if you want to do any of the following: Create an organization chart or Excel sparkline charts Show hierarchy, such as a decision tree Illustrate steps or stages in a process or workflow Show the flow of a process, procedure, or other event List information Use a chart if you want to do any of the following: Create a bar chart or column chart Create a line or XY scatter (data point) chart Create a stock chart, used to graph various stock prices Create a surface, donut, bubble, or radar chart Create a combination chart, such as a bar and line chart Excel data visualization training WHY SHOULD YOU ATTEND They say that ‘a picture is worth a thousand words’. Using SmartArt and Charts to visually display complex Excel data helps in communicating the data’s message much more effectively to your target audience. SmartArt graphics and Charts can be created not just in Excel, but also in PowerPoint, Word and Outlook. Thi...

OVERVIEW There is a saying,  “a picture is worth a thousand words” . In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart, a graph or something visual than to just look at a set of figures. WHY SHOULD YOU ATTEND Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like Data Visualization and Infographic . It's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world. AREAS COVERED Charting 101 - create a basic chart From drab to fab - enhance and customize a basic chart Combination charts - line and bar in a single chart Dynamic charts - automate adding new data ...

OVERVIEW As we hurtle toward 2020, every list of essential job skills and core competencies contains the following ideas: Data Analytics, Data Visualization, and Communication . While there are certainly a host of new tools and technologies to help us with that, the tools we already know and use daily have vast untapped potential. Microsoft Excel, certainly, gets a bad rap when it comes to ‘data visualization,’ but that’s almost entirely because people don’t know how to use the tools in the box! In this webinar, we’ll highlight a number of professional and compelling techniques for analyzing and visualizing data with Excel. These can be used to build Excel infographics, slide decks, reports, or any other sort of communication medium. You don’t need to invest money in new software – Excel can handle nearly anything. When you can visualize and communicate the important insights in your business, you are far ahead in many different areas. Market your ideas to a new audience wi...