Training
Provided by Training Connection
Excel Training - Chicago
 ABCDEFGH25.jpg" alt="Excel Training Class" width="145" height="150" align="left" />
http://www.trainingconnection.com
1. Excel 2003/2007 Level 1 - $275 (1 day / instructor-led)
2. Excel 2003/2007 Level 2 - $295 (1 day / instructor-led)
3. Excel 2003 Level 3 - $295 (1 day / instructor-led)
4. Excel 2003 VBA - $395 (1 day / instructor-led)
Excel Training Packages
Book any 2 levels of Excel Training and save $100.
Excel 2003 Level 1
This course is ideal for people new to Excel that need to produce reports, budgets, lists and other spreadsheets. No prior knowledge of Microsoft Excel is required, however it would be beneficial to have a general understanding of personal computers and the Windows operating system.
What you will learn
- Start Microsoft Excel, navigate and exit correctly
- Setup a new spreadsheet
- Copy and fill data in a spreadsheet
- Select ranges of cells in spreadsheet
- Create formulas to perform basic calculations
- Manage data
- Format the look and feel of a spreadsheet
- Print spreadsheets
Outline
Creating an Excel 2003 Workbook
- What's New In Excel 2003
- How To Start Excel 2003
- How To Create a New Default Excel Workbook
- How To Create A New Excel Workbook Using Template
Getting Familiar with the Excel Screen
- How To Use Menu
- How To Show Or Hide Toolbars
- How To Move Toolbar And Menu Bar
- How To Use Toolbar Button
- How To Use Shortcut Menu Using Right Mouse Click
- How To Use Shortcut Key
Getting Help and Maintenance
- How To Search Help
- How To Use Content Help
- How To Use Microsoft Office Online
- How To Use Type A Question For Help Box
- How To Use Office Assistant Help
- How To Use Get Help In A Dialog Box
- How To Get Office Updates From Microsoft Office Online
- How To Detect And Repair Errors In Excel
- How To Recover Excel When It Is Not Responding
- 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 Keyboard
- How To Move Using Go To Command
- How To Move using Name Box
- How To Move Within Selected Range
- How To Move To Other Sheets Within A Workbook
Selecting Range in Workbook
- How To Select A Single Cell
- How To Select A Range of Cells
- How To Select A Range Of Cells Using Shift key
- How To Select The 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 Cell Content
- How To Edit Contents Using Formula Bar
- How To Replace Contents In A Cell
- How To Delete Contents In A Cell
- How To Undo And Redo
- How To Enter Number As A Value Into A Cell
- How To Enter Number As A Label Into 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 Sequence Numbers
- How To Customize AutoFill
- How To Use Pick 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 Save A Workbook For The First Time
- How To Save Another Copy Using Save As'
- How To Save To Another Folder
- How To Save Into A Memory Stick
- How To Save Into A Different File Format
- How To Close The Current Workbook
- How To Open A Workbook
- How To Exit Excel 2003
Using Simple Formula
- How To Enter A Formula Using Keyboard
- How To Enter A Cell or A Range Reference Using Mouse
- How To Use AutoSum To Calculate Total Quickly
- How To Use Relative References
- How To Use Absolute References
Using Simple Functions
- How To Enter A Function Directly
- How To Use Paste Function
Using AutoCalculate and Labels
- How To Use AutoCalculate To Calculation Without Using Formula
- How To Accept Labels In Formulas
- How To Use Label (Natural Language) In Formula
Managing Worksheet Information
- How To Move Information Using Cut And Paste
- How To Move Information Using Drag And Drop
- How To Copy Information Using Copy And Paste
- How To Use Paste Options
- How To Copy Information Using Drag And Drop
- 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 New Worksheet
- How To Rearrange Worksheet
- How To Copy Worksheet
- How To Hide And Unhide Worksheet
- How To Hide And Unhide Workbook
- How To Format Worksheet Tab
- How To Add Worksheet Background
- How To Delete Worksheet
Adjusting Column Width / Row Height
- How To Adjust Column Width Using Mouse
- How To Adjust Column Width Using Menu
- How To Adjust Row Height Using Mouse
- How To Adjust Row Height Using Menu
- How To Hide / Unhide Rows / Columns
- How To Freeze A Column / A Row
- How To Slit A Worksheet In Panes
Formatting Cell Using Toolbar
- How To Change Font
- How To Change Font Size
- How To Bold
- How To Italic
- How To Underline
- How To Change Font Color
- How To Align Data In A Cell
- How To Indent Data In A Cell
- How To Merge Cells And Center Data
- How To Change Number To Percentage
- How To Increase / Decrease Decimal Points
- How To Copy Format Using Format Painter
Formatting Cell Using Menu Options
- How To Double Underline Using Menu Option
- How To Align Vertically
- How To Change Text Orientation
- How To Wrap Text In A Cell
- How To Format Numbers
- How To Format Date
- How To Change Cell Background Color
- How To Add Outline Border
- How To Add Double Line Border
- How To Format Table Using AutoFormat
Setting Up a Page
- How To Insert And Remove A Page Break
- How To Set And Clear The Print Area
- How To Change The Page Orientation
- How To Change The Scaling
- How To Change The Paper Size
- How To Change The Page Margin
- How To Align To The Center Of The Page
- How To Add A Header and Footer
Previewing and Printing
- How To View The Print Preview
- How To Print Active Sheets
- How To Print Selected Cells
- How To Print A Chart
- How To Print Multiple Copies
Excel Training Chicago - http://www.trainingconnection.com/excel-training.php
Training Avaliability and Delivery
| This is primarily ilt training |  | Computer Lab Work |  | Contact Training Connection for more information |
|
| Course Level: | introductory | | Schedule: | 1 days | | Training Presented in: | English |
|
Related Keywords:
excel course
microsoft excel course
excel course chicago
microsoft excel course chicago
excel class
microsoft excel class
learn microsoft excel
learn excel
Training Program Details
--
About Training Connection - Training Provider
Training Connection - Training Connection
Training Connection provides training in the world's most popular desktop applications and in business skills.
All our hands on training sessions are delivered by a qualified industry leading professionals. We keep our class sizes small so that each student is well looked after.
www.trainingconnection.com
Computer Courses include Photoshop Training, Dreamweaver...
More Training from Training Connection
Click here for more information or to take this course
| 
