Excel 2007 - Introduction
Duration: 1 day
Cost: $95.00 per student
Course Content
GETTING STARTED
Creating An Excel 2007 Workbook
- What's New In Office Excel 2007
- How To Start Excel 2007
- How To Create a New Default Excel Workbook
- How To Create A New Excel Workbook Using A Template
Becoming Familiar With The Excel 2007 Screen
Using the Excel 2007 Ribbon
- 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
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
Creating A Chart
- How To Insert A Chart
- How To Move A Chart
- How To Resize A Chart
- How To Change The Chart Type
- How To Add, Edit or Remove A Chart Data Source
- How To Swap Labels In The Legend With The Horizontal Axis
- How To Change The Order Of A Data Series
- How To Move An Existing Chart To A New Worksheet
- How To Format A Table Quickly
