| Price per person: | $99 |
| Length of class: | three hours |
| Version covered: | for Office 365 |
| Delivery format: | live over Zoom |
In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create and enhance dual-axis and combination charts.
This class is ideally suited for people with at least basic Excel skills, including making and editing entries, covered in our Excel Beginning 1 class.
We have a self-assessment tool to help determine if this class would benefit you. Download this skills assessment file and open it up. See if you can perform the tasks listed in it. It will test you on the exact skills you would learn in this class.
Formatting Cells
- formatting values
- changing font, size and style
- setting alignment and indents
- using text wrap and rotation
Using Cell Styles
- applying styles
- modifying styles
- defining custom styles
- deleting styles
- copying styles from another workbook
Basic Conditional Formatting
- apply data bars, color scales and icon sets
- conditionally format high or low values
- edit or remove conditional formatting rules
Creating Charts
- selecting data to chart
- discerning between chart types
- creating a chart
- formatting charts and chart elements
Enhancing Charts
- charting non-adjacent ranges of cells
- rotating and exploding pie charts
- optimizing Excel charts for use in other programs
- creating dual-axis combination charts
- adding and rearranging series of data
- adding trendlines and forecasts