Course
Visualizing data with Excel («ME3»)
A picture tells more than words or numbers. Learn how to visualize your numbers and data using Excel charts, sparklines, conditional formatting, and other techniques.
Duration
1 day
Price
700.–
Course documents
Digital Digicomp courseware
Course facts
- Visualizing numbers and using the different charts in a targeted way
- Understanding and using special charts such as waterfall, map, and funnel charts
- Using histograms
- Creating compelling visualizations
In this course you will deal intensively with data visualization; which diagram is useful when and what formatting options are available? This and more will be discussed in this course.
- The chart types
- Column
- Line
- Bar
- Pie and doughnut
- Area
- XY (scatter) and bubble
- Stock
- Surface
- Radar
- Combo
- Create chart
- Chart retrieving
- Elements of a chart
- Adjust chart
- Context tab chart tools
- Chart buttons
- Align to cell grid
- Format data series
- Axis options
- Legend
- Data label
- Chart and axis titles
- Gridlines
- Data tables
- Add data tables and adjust order
- Change chart
- Statistical elements
- Trend lines
- Error bars
- Secondary axis
- Moving and printing charts
- Dynamic data ranges
- Special diagrams
- Gantt
- Waterfall
- Funnel
- Alternatives to charts
- Data visualization with sparklines
- Charts from symbols
- Tips and Tricks
- Adjust data point symbol
- Chart templates
- Beginning of line for value axis
- Highlight bars dynamically
- High-Low lines
- Series lines
- Adjust data label form
This course is aimed at people who want to gain in-depth knowledge of charts to skillfully visualize their data.
Practical experience with Excel as well as knowledge according to our Excel courses: