Microsoft Excel 2007 Training ManualTable of Contents: Level 1
GETTING STARTED
What’s New In Office Excel 2007 Becoming Familiar With The Excel 2007 Screen
How To Work With The Ribbon
How To Use The Contextual Tabs
How To Use the Dialog Box Launchers
How To Use Live Preview
How To Use Access Keys
How To Use The Office Button
How To Use the Quick Access Toolbar
How To Add a Command To The Quick Access
Toolbar
How To Remove A Command From the Quick
Access Toolbar
How To Customize the Quick Access Toolbar
How To Move the Quick Access Toolbar
How To Use the Mini-Toolbar How To Access The Shortcut Menu Using The Mouse
How To Customize The Status Bar How To Change The Views How To Show And Hide Workbook Elements How To Use The Zoom Getting Help And Maintenance How To Search Help How To Use The Help Contents
How To Get Help From Office Online How To Get Help On A Command How To Get Help In A Dialog Box
How To Get Office Updates From Microsoft
Update Site
How To Run Microsoft Office Diagnostics How To Repair A Corrupted Workbook Manually How To Set The AutoRecover Options How To Recover An Excel File Moving Around Your Cursor How To Activate A Cell Using The Mouse How To Move To A Cell Using The Keyboard How To Move Around Using The Go To Command How To Move To A Cell Using The Name Box How To Move Within A Selected Range How To Move To Other Sheets Within A Workbook Selecting A Range Of Cells In Workbook How To Select A Single Cell How To Select A Range of Cells How To Select A Range Of Cells Using <Shift> How To Select An Entire Column How To Select The Entire Row How To Select The Entire Worksheet How To Select Non-Adjacent Ranges How To Select Multiple Worksheets Entering Data into Worksheet How To Enter Text (Label) Into A Cell How To Edit The Contents Of A Cell How To Edit Text In A Cell Using The Formula Bar How To Replace The Contents Of A Cell How To Delete The Contents Of A Cell How To Undo And Redo Changes How To Enter A Number As A Value In A Cell How To Enter A Number As A Label In A Cell How To Enter Date Into A Cell How To Use AutoFill To Enter Text How To Use AutoFill Options How To Use AutoFill To Enter A Sequence Of Numbers How To Customize AutoFill How To Use A List To Enter Data How To Enter Data Into A Range Of Cells How To Fill A Range Of Cells With The Same Data How To Document Workbook Properties How To Save A Workbook For The First Time How To Save Another Copy Using `Save As’ How To Save With A Different File Format How To Save To Another Folder How To Save On A Diskette How To Close The Current Workbook How To Open A Workbook How To Exit Excel 2007 PERFORMING CALCULATIONS Using A Simple Formula
How To Resize The Formula Bar How To Enter A Formula Using The Keyboard How To Enter A Cell or A Range Reference Using The Mouse How To Use AutoSum To Calculate Totals How To Use Relative References How To Use Absolute References Using Simple Functions How To Enter A Function Directly
How To Use AutoComplete To Create Formulas How To Turn Formula AutoComplete On Or Off
How To Insert Other Functions Using
AutoSum Button How To Use The Insert Function Using AutoCalculate How To Use AutoCalculate To Do A Calculation Without Using A Formula MANAGING WORKSHEETS AND WORKBOOK INFORMATION Managing Worksheet Information How To Move Information Using Cut And Paste How To Drag And Drop Information How To Copy And Paste Information How To Use Paste Options How To Drag And Drop To Copy Information How To Insert A New Row How To Insert Multiple Rows How To Delete Rows How To Insert A New Column How To Insert Multiple Columns How To Delete Columns How To Insert A Cell Managing Workbook Information How To Rename Worksheet How To Add A New Worksheet How To Rearrange Worksheets How To Copy Worksheet How To Hide And Unhide A Worksheet How To Hide And Unhide A Workbook
How To Format A Worksheet Tab How To Add A Sheet Background How To Delete A Worksheet FORMATTING WORKSHEETS Adjusting Column Width / Row Height How To Adjust The Column Width Using The Mouse How To Adjust The Column Width Using The Menu How To Adjust The Row Height Using The Mouse How To Adjust The Row Height Using The Menu How To Hide / Unhide Rows / Columns
How To Freeze A Column / A Row How To Split A Worksheet Into Panes Formatting Cells Using The Ribbons How To Change The Font How To Change The Font Size How To Make Text Bold How To Italicize Text How To Underline Text How To Change The Font Color How To Align Data In A Cell How To Indent Data In A Cell How To Merge Cells How To Change Numbers To Percentages How To Increase / Decrease Decimal Places How To Copy A Format Using Format Painter Formatting Cells Using The Format Cells Dialog Box How To Double Underline Using The Menu Option How To Align Cell Data Vertically How To Change Text Orientation How To Wrap Text In A Cell How To Format Numbers As Currency How To Format Dates How To Change The Background Color Of A Cell How To Add An Outline Border How To Add A Double Line Border How To Draw A Border Using The Mouse
How To Format A Table Quickly ©2007 EBook Publishing. All rights reserved.
|
