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