Excel Beginning 2: Cell Formatting and Charting
Class Details
Length of class: three hours
Price per person: $99
Version covered: for Office 365
Description
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.
Prerequisites
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.
Outline
Formatting Cells
- formatting values
- changing font, size and style
- setting alignment and indents
- using text wrap and rotation
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
Upcoming Dates
Tue, Oct 27, 2026
8:00 AM - 11:00 AM
Wed, Nov 18, 2026
8:00 AM - 11:00 AM
Mon, Dec 7, 2026
12:00 PM - 3:00 PM
Fri, Jan 8, 2027
12:00 PM - 3:00 PM
Tue, Jan 26, 2027
8:00 AM - 11:00 AM