What you'll learn:
- At the end of this course, students will be able to master their Excel skills by learning both basic and extended data visualization and business intelligence related functions using the ExTool Application. Through this mastery, work efficiency will increase and result in a more productive, positive work or educational environment.
This course will teachstudents how to master their Excel skills by learning both basic and extended data visualizationand business intelligence related functions using the ExTool Application. In the first section of the course, students will learn how to create the following data visualizations: 3D Surface Plot, Force Arrow Chart,Plot Pins on a Google Map,Plot Data on a Google Map, andBiomedical Batch Analysis Chart, Loss Analysis Chart, Scatter Plot, Multiple Stock Analysis Chart, Risk Analysis Map. The second section of the course will demonstrate the following functions: Air Quality Heat Map, Candlestick Chart,Stacked Area Line Chart, ColoredChina Air Quality Chart, Multiple Funnel Chart,Basic Radar Chart,BarNegative Chart, Sized Pie Chart, Migration Map, Sankey Diagram, Stepped Waterfall Chart,andFunnel Align Chart.Through the mastery of these functions, users will be able to transform their data into beautiful, animated graphics that are easy to work with and understand.