Excel 2002 Basic

123-CBT Computer Based Training
Excel 2002: Basic Microsoft
<span class=product_header>Lesson 1: The Excel 2002 Interface</span><br> Introduction<br> Lesson Objectives<br> Opening Excel<br> About Workbooks<br> The Title Bar<br> Menu Bar Overview<br> Standard Toolbar Overview<br> Formatting Toolbar Overview<br> Displaying Other Toolbars<br> Repositioning A Toolbar<br> Docking A Toolbar<br> Hiding A Toolbar<br> Overview Of Task Panes<br> Switching Between Task Panes<br> Hiding The Task Pane<br> Showing The Task Pane<br> The Formula Bar<br> The Insert Function Button<br> The Name Box<br> The Worksheet Area<br> Column Headings<br> Row Headings<br> The Select All Button<br> The Vertical Scroll Bar<br> The Horizontal Scroll Bar<br> Sheet Tabs<br> Inserting A Worksheet<br> The Insert Dialog Box<br> Renaming A Worksheet<br> Changing Sheet Tab Order<br> Deleting A Worksheet<br> The Tab Scrolling Buttons<br> The Status Bar<br> Overview Of Menus<br> The File Menu<br> The Edit Menu<br> The View Menu<br> The Insert Menu<br> The Format Menu<br> The Tools Menu<br> The Data Menu<br> The Window Menu<br> The Help Menu<br> The Ask A Question List Box<br> The New Blank Document Button<br> The Open Button<br> The Save Button<br> The E-mail Button<br> The Search Button<br> The Basic Search Task Pane<br> The Print Button<br> The Print Preview Button<br> The Spelling Button<br> The Cut, Copy & Paste Buttons<br> The Format Painter Button<br> The Undo & Redo Buttons<br> The Insert Hyperlink Button<br> The AutoSum Button<br> The Sort Ascending & Sort Descending Buttons<br> The Chart Wizard Button<br> The Drawing Button<br> The Zoom List Box<br> The MS Excel Help Button<br> The Toolbar Options Button<br> Selecting A Cell<br> Entering Data<br> The Enter And Cancel Buttons<br> The Font List Box<br> The Font Size List Box<br> The Bold Button<br> The Italic Button<br> The Underline Button<br> The Align Left Button<br> The Center Button<br> The Align Right Button<br> The Merge And Center Button<br> The Currency Style Button<br> The Percent Style Button<br> The Comma Style Button<br> The Increase Decimal Button<br> The Decrease Decimal Button<br> The Outside Border Button<br> The Fill Color Button<br> The Font Color Button<br> Accessing Hidden Buttons<br> The Increase Indent Button<br> Undoing The Last Action<br> Undoing Multiple Actions Simultaneously<br> Displaying The Office Assistant<br> Hiding The Office Assistant<br> Closing Excel<br> <br> <span class=product_header>Lesson 2: Working With Data</span><br> Introduction<br> Lesson Objectives<br> Opening Excel<br> Preparing To Work<br> Renaming A Worksheet<br> Color Coding Sheet Tabs<br> Entering Text<br> Moving The Cell Marker<br> Changing Orientation Of Text<br> The Undo Command<br> Rotating Text<br> Moving The Cell Marker<br> Entering Numerical Values<br> The Name Box<br> Resizing A Column<br> Selecting Adjacent Cells<br> Selecting Non Adjacent Cells<br> Formatting Multiple Cells<br> Centering Text<br> Drawing A Border<br> Erasing A Border<br> Applying A Border To Multiple Cells<br> Applying A Fill<br> Deselecting Cells<br> Inspecting Changes<br> Inserting A Row<br> The Insert Options Button<br> Inserting A Column<br> Entering Formulas In A Worksheet<br> The AutoFill Handle<br> The AutoFill Options Button<br> Entering A Function<br> Correcting Errors<br> Formatting Decimal Places<br> The Number Tab<br> Adding More Rows<br> Shortcut Menus<br> Revising A Formula<br> Sorting<br> Inserting A Comment<br> Hiding A Comment<br> Deleting A Comment<br> The If Function<br> The Logical Test<br> Using Absolute Cell References<br> Reviewing Results<br> Saving A Workbook<br> The Save As Dialog Box<br> <br> <span class=product_header>Lesson 3: Objects & Formatting</span><br> Introduction<br> Lesson Objectives<br> The New Workbook Task Pane<br> The Recently Used File List<br> Changing The Zoom Percentage<br> Selecting Non Adjacent Cells<br> Changing Font Color<br> Accessing The Clip Art Task Pane<br> Searching For Clip Art<br> Search Options<br> Viewing Results<br> Inserting A Clip<br> Deleting A Clip<br> Modifying A Search<br> The Microsoft Clip Organizer<br> Using The Mouse To Resize A Clip<br> Design Gallery Live<br> Inserting WordArt<br> Repositioning WordArt<br> Formatting WordArt<br> Using AutoShapes<br> Resizing An AutoShape<br> Repositioning An AutoShape<br> Formatting An AutoShape<br> Replicating An AutoShape<br> Adding An Arrow Shape<br> Using Connectors<br> Adding A Text Box<br> Formatting Text In A Text Box<br> Repositioning A Text Box<br> Replicating A Text Box<br> Adjusting An Arrow Shape<br> Changing Text Box Orientation<br> Adding A Title<br> Merging And Centering Cells<br> Inserting A Picture From A File<br> Formatting A Picture<br> Reviewing Your Work<br> <br> <span class=product_header>Lesson 4: Charts & OLE</span><br> Introduction<br> Lesson Objectives<br> Opening An Existing Spreadsheet<br> Selecting A Range Of Data<br> The F11 Key<br> Chart Elements<br> The Legend<br> The X Axis<br> The Y Axis<br> Deleting A Chart<br> The Chart Wizard<br> Bar Charts<br> The Line Chart<br> Pie Charts<br> Column Charts<br> Previewing A Chart Type<br> Altering The Data Range<br> Adding A Title To A Chart<br> Showing Or Hiding Axis Labels<br> Altering Gridlines<br> Altering A Chart Legend<br> Data Labels<br> The Data Table<br> Chart Placement<br> Modifying An Existing Chart<br> Changing The Chart Area<br> Fill Effects<br> Modifying Chart Area Fonts<br> Increasing Chart Area Font Size<br> Changing Font Style<br> Changing The Chart Area Font Color<br> Deleting A Series<br> Formatting The Legend<br> Undoing A Change<br> Resizing A Chart Component<br> Formatting The Chart Title<br> Formatting Data Series<br> Changing Series Order<br> Adding A Picture As A Background<br> Object Linking<br> Other Chart Types<br> Copying A Chart To A Spreadsheet<br> Saving Your Work<br> <br> <span class=product_header>Lesson 5: Document Setup, Printing & The Help System</span><br> Introduction<br> Lesson Objectives<br> Opening A Workbook<br> Page Setup<br> Page Orientation<br> Scaling<br> Changing Paper Size<br> Print Quality<br> Centering A Spreadsheet<br> Adjusting Margins<br> Headers And Footers<br> Creating A Custom Footer<br> Printing Gridlines<br> Printing In Black & White<br> Printing Comments & Cell Errors<br> Page Order<br> Print Preview<br> Print Preview Zoom<br> Changing Margins In Print Preview<br> Page Break Preview<br> Updating Page Setup<br> The Print Dialog Box<br> Changing The Number Of Copies<br> Collate<br> Print Area<br> Previewing A Selection<br> Increasing The Scale<br> Adjusting Orientation<br> Clearing The Print Area<br> The Help System<br> What's This? <br> Microsoft Excel Help<br> The Answer Wizard<br> Hiding The Office Assistant<br> The Help Window<br> The Contents Tab<br> The Index Tab<br> The Auto Tile Button<br> The Hide Button<br> The Show Button<br> The Back & Forward Buttons<br> The Print & Options Buttons<br> <br>
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
cd romThis program may be available on CD
Training Presented in:English
Training Provided by 123-CBT Computer Based Training
Excel 2002 Basic
Microsoft
Prerequisites
Target Audience
Lessons
Test Prep
Simulations
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...
Sell microsoft training?
Custom Search
tcw11-v473M-02/05/12-00:13:27-()[A]-[B]-[A] -12:43:24