People respond better to visual displays of data. In Microsoft Excel, charts and graphs are two ways to create those visuals. This half-day course will examine charts and graphs in an in-depth manner. Become a chart and graph guru – and be the popular kid on the block!
See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."
Who Should Attend
This course is designed for students desiring to gain the skills necessary to use data to create graphs and charts in Excel.
Attend and You Will Receive
Upon successful completion of this course, you will receive a certificate of completion from NC State University.
To ensure your success in this course, you should have experience working with Excel. You should already understand spreadsheet concepts and be comfortable creating basic spreadsheets. You can obtain this level of skill and knowledge by taking Excel Level 1.
Attend and You Will Learn / Expected Outcome
Upon successful completion of this course, you will be able to produce charts and graphs in Excel.
Attend And You Will Learn
- Creating a chart
- Renaming sheets
- Adding chart items
- Linking chart titles to worksheet cells
- Selecting a chart style
- Filtering chart data
- Formatting chart items
- Changing the chart type
- Pie charts
- Exploding a pie
- Pie rotation
- Combination charts
- Combination charts with a secondary axis
- Embedding a chart
- Moving and sizing the embedded chart
- Creating a dashboard
- Copying and deleting chart data