Basic Training of excel 2007

Posted on by TrustScore

Ø Getting Started

v Spreadsheets

v Microsoft Office Button

v Ribbon

v Quick Access Toolbar

v Mini Toolbar

v Customize

v Popular

v Formulas

v Proofing

v Save

v Advanced

v Customize

Ø Workbook

v Create a Workbook

v Save a Workbook

v Open a Workbook

v Entering Data

Ø Data

v Select a Row or column

v Copy and Paste

v Cut and paste

v Undo and redo

v Auto Fill

Ø Modifying

v Insert Cells, Rows, and Columns

v Delete Cells, Rows and Columns

v Find and Replace

v Go To Command

v Spell Check

Ø Calculations

v Calculate with functions

v Function Library

v Relative, Absolute and Mixed References

v Linking Worksheets

Ø Macros

v Recording a Macro

v Running a Macro

Ø Sort and Filter

v Basic Sorts & Custom Sorts

v Filtering

Ø Graphics

v Adding Clip Art

v Editing Pictures and ClipArt

v Adding Shapes

v Adding Smart Art

Ø Charts

v Create a Chart

v Modify a Chart

v Chart Tools

v Copy a Chart to Word

Ø Format Worksheet

v Convert Text to Columns

v Modify Fonts

v Format Cells Dialog Box

v Add Borders and Colors to Cells

v Change Column Width and Row Height

v Hide or Unhide Rows or Columns

v Merge Cells

v Align Cell Contents

Ø Developing a Workbook

v Format Worksheet Tab

v Reposition Worksheets in a Workbook

v Insert and Delete Worksheets

v Copy and Paste Worksheets

Ø Page Properties and Printing

v Set Print Titles

v Create a Header or Footer

v Set Page Margins

v Change Page Orientation

v Set Page Breaks

v Print a Range

Ø Layout

v Freeze Rows and Columns

v Hide Worksheets

Dummy Posts

The Power of Blog

Basic Training of excel 2007

Our Angles

AdsRom Advertisement

eLeavers Ads

SpeedyAds

Advertisement

RevenueHits Ads

Adhitz Advertisement

YllixMedia Ads

Adhitz Advertisement

AdClickMedia Ads

Popular Dummys

About Me

Followers

Kontera Ads

Infolinks In Text Ads

Dummy Posts

About Us