Excel 2008 – Intermediate


Microsoft Office Excel 2008 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With this Excel 2008 – Intermediate training course, take your understanding of this versatile application to the next level.

Platform: Mac

Length: 2 hours 18 min

This title is available in the
Total Training All-Access library.

Subscribe Now


Created by Beth Bruestle and Philip K. Harmer, this Excel 2008 – Intermediate training course begins with a focus on worksheet manipulation, and then delves into topics such as working with ranges and understanding cell comments. Then, you’ll be guided through charts, graphics, functions, and more!

This training is for Microsoft Office Excel 2008 for Mac.

Sample clip

A. Working with Worksheets
Adding a worksheet to a workbook
Activating and moving between worksheets
Selecting multiple worksheets
Deleting a worksheet from a workbook
Changing the name of a worksheet
Rearranging the worksheets pt. 1
Rearranging the worksheets pt. 2
Hiding and unhiding worksheets

B. Controlling the Worksheet View
Zooming in and out of a worksheet
Viewing a worksheet in multiple windows
Splitting the worksheet window
Freezing and unfreezing panes
Viewing using full screen
Creating custom views

C. Using Names to Work with Ranges
Creating range names pt. 1
Creating range names pt. 2
Moving to a named range
Using range names in formulas
Creating a 3-D range name
Editing a named range
Deleting a named range

D. Understanding Cell Comments
Adding a comment to a cell
Reading comments
Showing and hiding comments
Using the Comments toolbar
Editing comments
Formatting comments
Printing comments
Deleting a comment

E. Working with Charts
Creating a chart
Changing the chart type
Understanding chart types pt. 1
Understanding chart types pt. 2
Creating an embedded chart or a chart sheet
Moving and resizing an embedded chart
Changing the data orientation in a chart
Adding a chart title
Adding axis titles
Changing the location of the chart legend
Adding data labels
Adding a data table to a chart
Changing the gridlines
Formatting chart elements
Moving, resizing, and deleting chart elements
Deleting a chart
Printing a chart

F. Working with Graphics
Inserting a shape
Inserting a picture
Inserting clip art
Inserting a SmartArt graphic
Inserting a text box
Inserting WordArt
Selecting objects
Resizing a graphic object
Reshaping a graphic object
Rotating a graphic object
Moving a graphic object
Aligning graphic objects
Copying a graphic object
Deleting a graphic object
Grouping graphic objects
Stacking graphic objects
Formatting the fill of a graphic object
Formatting the outline of a graphic object

G. Conditional Formatting
Applying Conditional Formatting
Adding additional Conditional Formatting
Finding Conditional Formatting
Modifying existing Conditional Formatting
Adding records to conditional formatted cells
Deleting Conditional Formatting

H. Functions
Using COUNT functions
Using the IF function
Using the VLOOKUP function
Using the HLOOKUP function

I. Working with Lists
Creating a list using the List wizard pt. 1
Creating a list using the List wizard pt. 2
Adding records to the list
Adding records using a data form
Inserting a column into the list
Inserting a row within the list records
Moving columns and rows
Deleting a column or row
Using the Total Row command
Changing the column settings and formatting the list
Filtering a list
Sorting a list