Excel 2008 - Advanced

Rapid Skillz

Course

Online

£ 47.16 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Ms Office
  • Office IT
  • Excel
  • Conditional Formatting
  • Pivot tables
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Excel Productively
  • Data TablesData Tables
  • Simulations & Solver

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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

Additional information

LENGTH

2 hours 16 min

See related categories

Excel 2008 - Advanced

£ 47.16 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all