Excel Beginning 2: Cell Formatting and Charting

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

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