Excel Training - Chicago
Training
Provided by Training Connection
Excel Training - Chicago
TEL: 312. 698. 4475
1. Excel 2003/ 2007 Level 1 - $295 (1 day / instructor-led)
2. Excel 2003/ 2007 Level 2 - $295 (1 day / instructor-led)
3. Excel 2003/ 2007 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.
Upcoming dates:
Excel 2003 Level 1
Nov 10
Dec 3
Jan 6
Jan 28
Feb 23
Excel 2003 Level 2
Nov 11
Dec 4
Jan 7
Jan 29
Feb 24
Excel 2003 Level 3
Nov 12
Dec 5
Jan 8
Jan 30
Feb 25
Excel 2007 Level 1
Nov 17
Dec 15
Jan 19
Feb 18
Excel 2007 Level 2
Nov 18
Dec 16
Jan 20
Feb 19
Excel 2007 Level 3
Nov 19
Dec 17
Jan 21
Feb 20
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
--
About The Training Provider: Training Connection
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...
