In this three-hour session, you will learn the most efficient ways to format 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.
PrerequisitesThis class is ideally suited for people with at least basic Excel skills, including making and editing entries, covered in our Excel Beginning class.
OutlineFormatting 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
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