Excel 2008 - Intermediate

Course

Online

£ 47.05 VAT inc.

*Indicative price

Original amount in USD:

$ 59

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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.
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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

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

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

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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

Additional information

LENGTH

2 hours 18 min

Excel 2008 - Intermediate

£ 47.05 VAT inc.

*Indicative price

Original amount in USD:

$ 59