Posts

Showing posts with the label conditional formatting

Data Visualization in Excel: Mastering Traditional and Advanced Charts

Image
OVERVIEW "Every Picture Tells a Story"  is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand and engaging. Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it. This Excel data visualization training will cover one area of data  visualization  in Excel - Charts. You will learn how to create, enhance and customize charts from your Excel data. We will start with traditional charts such as bar charts and line charts, before moving on to advanced Excel charts such as combo charts, excel  Sparkline Charts  and  The People Graph . WHY SHOULD YOU ATTEND 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 mo...

Live Webinar on Visualizing Excel Data with SmartArt and Charts

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