Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Excel 2008 – Intermediate

Excel 2008 – Intermediate

[ TTEX2008IN ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


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.

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.


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



PACKAGE INCLUDES:
Length of Subscription: 12 Months Online On-Demand Access
Running Time: 2 hrs 18 min
Platform: Windows & MAC OS
Level: Beginner to Advanced
Project Files: Included

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.


More from this collection