X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
Excel_2008_Intro.jpg

Excel 2008 - Intro

Indian : Rs.3835
International : $59
INTRODUCTION
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.
OBJECTIVE
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.
CONTENT
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
LENGTH
2 hours 40 min
Frequently Asked Questions


traingtoatalcrse.png

Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners

×