Excel in Excel with Charts and Graphs
This course covers Charts and Graphs in Excel. What is the difference between charts and graphs? What kind of charts and graphs are offered and the purpose of each? You will learn this as well looking at each Ribbon Group and how to use the tools in each group to aid you in creating and editing charts and many formatting tips and tools.
What you’ll learn
- The difference between Charts and Graphs.
- The different types of Charts and Graphs and their intended use.
- The Ribbons associated with Charts and Graphs and how to use the tools in each Ribbon Group.
- Tips and shortcuts to make your use of Charts and Graphs in Excel more efficient.
- How to create and edit Charts and Graphs.
- Use the Format Panel to make a more professional Chart.
Course Content
- Introduction –> 8 lectures • 28min.
- Format Ribbon –> 8 lectures • 25min.
- Scatter Chart –> 1 lecture • 4min.
- Stock Chart –> 1 lecture • 5min.
- Sparklines –> 1 lecture • 7min.
- Closing –> 1 lecture • 1min.
Requirements
This course covers Charts and Graphs in Excel. What is the difference between charts and graphs? What kind of charts and graphs are offered and the purpose of each? You will learn this as well looking at each Ribbon Group and how to use the tools in each group to aid you in creating and editing charts and many formatting tips and tools.
Additional shortcuts are provided to aid you in producing a more professional and efficient product more quickly; F11 and Alt+F1 to create charts on the current or new worksheet, Ctrl+A to select your table, Ctrl+Shift and roll the mouse wheel to scroll left and right in your worksheet, how to link a text box to a particular cell.
This course is presented for Beginning to Intermediate level students. The length of the class is short enough to keep your attention but long enough to give you as much information as possible for your knowledge level.
We will be covering the following topics:
· Intro to Charts and Graphs
o Types of Charts
· Chart Design Ribbon
o Chart Layout Group
o Chart Styles Group
o Data Group
o Type Group
o Location Group
· Format Ribbon
o Current Selection Group
o Insert Shapes Group
o Shape Styles Group
o WordArt Styles Group
o Accessibility Group
o Arrange Group
o Size Group
· Sparklines Ribbon
o Type Group
o Show Group
o Style Group
o Group Group
Upon successful completion of this course, you will be able to perform the following tasks in Microsoft Excel.
You will:
· Learn the difference between Charts and Graphs
· Identify the different charts available and their intended uses
· Demonstrate skills in creating and editing charts
· Learn the two ribbons associated with charts, the groups on each one and the tools within each group
· Demonstrate skills in formatting the chart and the chart elements using the Format Panel
· Identify a Sparkline, why and how to use it