Excel III Advanced Formatting & Charting
Scheduled Dates
| This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information. |
Topics Include:
- Chart Types
- Create a chart
- Verify or change the chart source data
Add or modify chart elements:
- Titles
- Axes
- Legends
- Labels
- Scale
- Data Tables
- Chart Location
- Move and Resize
Format the chart
- Add Borders, colors, and fill effects
- Select font size, color, and orientation
Drawing tools:
- Text boxes, arrows, AutoShapes
- Transform (or resizing) a drawing object
- Understanding object ordering
- How to group and ungroup objects
- Inserting a picture or clipart image
- Using the new SmartArt Feature
- Use the Format Painter
- Change displayed gridline colors
- Select and change spreadsheet fonts
- Add borders, shading and patterns
- Combine Text (Fill Justify)
- Shrink to Fit for Headers
- Cell Styles
- Themes
- Number format codes
- Placeholders and the Cheat Sheet