Excel 2008 – Advanced

$49.99

Microsoft Office Excel 2008 is a spreadsheet application that features calculation, graphing tools, pivot tables, and more.  With this Excel 2008 – Advanced training course, you'll learn about the more advanced features of this very popular and versatile office tool.

Platform: Mac

Length: 2 hours 16 min

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

Subscribe Now

Description

Presented by Beth Bruestle, this Excel 2008 – Advanced online training course begins with working with templates and then moves on to topics such as entering dates and times and formatting numbers. Next, Beth delves into more complex topics such as charting, data validation, and “what-if” analysis. By the end of this course, you’ll even know how to protect your worksheets, check for errors, and share your data.

This training course is for the Mac version of Microsoft Office Excel 2008.

Sample clip

A. Templates
Creating custom templates
Creating a workbook from a template
Modifying a template file

B. Working with Dates and Times
Entering dates into a cell
Formatting date entries
Displaying the current date
Generating a series of dates
Using date related functions
Entering times into a cell
Formatting time entries
Displaying the current time

C. Custom Number Formats
Formatting numbers automatically
Understanding custom number formatting
Creating a custom number format
Creating custom date and time formats
Hiding the contents of a cell using a custom format
Deleting a custom format

D. Advanced Charting
Selecting elements in a chart
Formatting chart elements
Modifying the chart area
Modifying the plot area
Adding text to a chart
Modifying the legend
Modifying the value axis
Modifying the category axis
Deleting a data series from a chart
Adding a data series to a chart pt. 1
Adding a data series to a chart pt. 2
Adding a trend line to a chart
Creating a combination chart
Creating picture charts

E. Data Validation
Specifying data validation criteria
Creating Data Validation Rule messages pt. 1
Creating Data Validation Rule messages pt. 2
Creating a data validation drop-down list
Finding cells that contain Data Validation Rules
Clearing existing Data Validation Rules

F. Sorting and Filtering
Sorting data in a worksheet
Sorting by multiple columns or criteria
Filtering data in a worksheet using AutoFilter pt. 1
Filtering data in a worksheet using AutoFilter pt. 2
Clearing a filter in a worksheet
Creating and/or statements using AutoFilter
Creating a criteria range
Defining criteria using the criteria range
Creating and/or statements using the criteria range pt. 1
Creating and/or statements using the criteria range pt. 2

G. Outlines
Creating an outline automatically
Creating a manual outline
Displaying levels in an outline
Hiding the outline symbols
Clearing an outline
Adding subtotals to a worksheet pt. 1
Adding subtotals to a worksheet pt. 2

H. Linking and Consolidating Worksheets
Creating a Link formula within the same workbook
Creating a Link formula to another workbook
Consolidating worksheets using formulas pt. 1
Consolidating worksheets using formulas pt. 2
Consolidating worksheets using formulas pt. 3
Using the Consolidate command pt. 1
Using the Consolidate command pt. 2
Opening a workbook with External Reference formulas
Breaking links to external references

I. What-if Analysis
Creating scenarios pt. 1
Creating scenarios pt. 2
Displaying scenarios
Modifying scenarios
Generating a Scenario report
Deleting a scenario
Using Goal Seek
Protecting a worksheet
Unprotecting a worksheet
Using a password to protect a worksheet

J. Workbook Protection
Protecting a workbook pt. 1
Protecting a workbook pt. 2
Protecting a workbook pt. 3
Unprotecting a workbook

K. Auditing and Error Checking
Displaying formulas
Identifying precedent cells
Identifying dependent cells
Checking for errors pt. 1
Checking for errors pt. 2

L. Sharing Data with Word
Copying and pasting static information
Copying and pasting as a link
Importing a text file into Excel