Excel 2008 – Intro

$49.99

In this Excel 2008 – Intro training course, presenter Beth Bruestle introduces you to Microsoft Office Excel 2008 for Mac. This application is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new results-oriented interface and rich data visualization, professional-looking charts are easier to create and use.

Platform: Mac

Length: 2 hours 40 min

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

Subscribe Now

Description

With Excel 2008 – Intro, you’ll get up and running with Microsoft Office Excel 2008 for Mac. The course starts by discussing the new features of this 2008 version of the software and then moves on to interface fundamentals such as navigating and saving your worksheets. Next, Beth discusses topics such as working with cells, formulas, and functions, and finally concludes with options for printing your work.

By the time you’ve finished this course, you’ll have a good understanding of creating, formatting, and sharing your Excel projects.

This training course is for Microsoft Office Excel 2008 for Mac.

Sample clip

A. Basics
Introducing the new features in Office 2008 pt. 1
Introducing the new features in Office 2008 pt. 2
Using the toolbars
Using the Office Toolbox
Using the Elements gallery
Understanding a worksheet and entering information into a cell
Changing the default worksheets and cell movement
Using ledger sheets
Using Save and Save As
Understanding the new XML file format pt. 1
Understanding the new XML file format pt. 2
Opening Excel 2008 files in earlier versions of Excel
Moving with the keyboard pt. 1
Moving with the keyboard pt. 2
Creating a PDF

B. Working with Cells
Using AutoComplete
Editing a cell
Using spell check
Selecting cell ranges pt. 1
Selecting cell ranges pt. 2
Entering values in a cell range
Using AutoFill
Using cut, copy and paste
Using paste options
Using paste special
Using the scrapbook
Using drag and drop editing
Using undo and redo
Using the clear command

C. Formulas & Functions
Using AutoCalculate
Using AutoSum
Creating formulas
Using functions in formulas
Using the Formula Builder
Editing formulas
Checking formulas for errors
Using relative cell referencing
Understanding absolute cell references
Creating an absolute cell reference

D. Formatting Cells
Formatting numbers using the Formatting Palette
Formatting numbers using the Formatting toolbar
Formatting text using the Formatting palette
Formatting text using the Formatting toolbar
Using the alignment and indentation commands
Rotating information in a cell
Wrapping text in a cell
Using the Merge and Center command
Using the Borders command
Drawing cell borders
Formatting information using the format cells dialog box
Using the Format Painter command

E. Working with Columns & Rows
Selecting columns and rows pt. 1
Selecting columns and rows pt. 2
Changing column width
Changing row height
Hiding and unhiding columns and rows
Inserting columns
Inserting rows
Deleting columns and rows
Inserting and deleting cells

F. Using Styles & AutoFormat
Creating a custom cell style by example
Creating a custom cell style
Deleting a custom cell style
Modifying a custom cell style
Merging custom cell styles
Applying AutoFormat

G. Workbook Views & Page Setup
Using Normal view
Using Page Layout view
Changing the margins
Changing the page orientation and the paper size
Setting manual page breaks
Setting print titles
Creating headers and footers pt. 1
Creating headers and footers pt. 2

H. Printing
Printing
Setting, adding to, and removing print areas