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 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 Excel data visualization training, 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 you...

Learning how to efficiently use Excel is so critical in many of today’s office jobs as it helps you produce meaningful, impactful and insightful reports. Our upcoming boot camp discusses tips, tricks, and techniques for managing and analyzing lengthy lists of data in Excel, quickly and easily. Webinar highlights : ·          Sorting and Filtering - use custom filter techniques, create, view, and remove Subtotals and more ·          Using Conditional Formatting - highlighting cells rules, applying data bars, color scales and icon sets and more ·          Using Data Validation - creating data validation criteria, modifying and removing data validation and more ·          Creating SmartArt Diagrams - inserting diagrams, modifying illustrations and more ·          Creating Charts...

OVERVIEW Your business landscape might be exacting but you don’t have to compromise on your aspirations. Just brush up your skills with our upcoming webinar. 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. Join the webinar to learn how to create icon- and map-based visuals, as well as dynamic dashboards that update as your data changes. Key points to be covered in the webinar: ·          Data visualization tools in Excel and creating graphical charts with symbols, pictures, maps, and more ·          Highlighting relevant data dynamically with conditionally formatted charts ·          Isolating critical points with logical functions LEARNING OBJECTIVES Excel can create an incredible assortment of chart and visualization types, far beyond the bar ch...

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...

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. Infographic Maker Through Microsoft Excel AREAS COVERED Session highlights include… Charting 101 - create a basic chart From drab to fab - enhance and customize a basic chart Combination charts - line and bar in a ...