Book your Microsoft Excel 2003 Fundamentals Training Course
This one day course is being run ten times between Tuesday 6th March 2012 and Wednesday 5th December 2012 in London,
Book this course with us today from as little as £179.10 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses provided by 2-e-2Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Tuesday 06 March 2012 | London |  | Save £19.90 | £179.10+VAT | |
| Wednesday 04 April 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 09 May 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 06 June 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 11 July 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 15 August 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 12 September 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 03 October 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 07 November 2012 | London | | Save £19.90 | £179.10+VAT | |
| Wednesday 05 December 2012 | London | | Save £19.90 | £179.10+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
The skills and knowledge acquired in Microsoft Excel 2003 Fundamentals are sufficient to be able to use and operate the software at an efficient level.
PreRequisites:
Microsoft Excel 2003 Fundamentals assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Audience:
Microsoft Excel 2003 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software.
Objectives:
At the completion of Microsoft Excel 2003 Fundamentals you should be able to:
- start Microsoft Excel, navigate workbooks, and exit correctly
- create, modify, save, and close a simple workbook
- print data in a workbook
- copy and fill data in a workbook
- adjust the sizing of columns and rows in a workbook
- enter a range of data types and formulas
- move the contents of cells within and between workbooks
- create formulas that perform calculations in a workbook
- create and work with functions in a workbook
- understand and use absolute referencing in a workbook
- edit data in a workbook
- use the fill technique to enter data into cells
- format cells in a workbook
- create a variety of charts (graphs) in Excel
- use hyperlinks to provide navigational tools in a workbook
Excel 2003 Orientation
Starting Excel 2003
The Excel 2003 Screen
Understanding The Workbook
Moving The Cell Pointer
Moving About The Workbook
Using Go To
Menus And Toolbars
Using Menus And Toolbars
Using Context Sensitive Menus
Exiting Excel 2003
A Simple Workbook
Creating A New Workbook
Entering Data In A Workbook
Saving A New Workbook
Opening A Saved Workbook
Creating An Input Range
Saving Your Work
Essential Formatting
Column Best Fit
Closing A Workbook
Printing
Print Preview
Simple Printing
Previewing Large Worksheets
Page Orientation
Scaling To Fit
Printing To Multiple Pages
Creating Page Headers And
Footers
Formatting Headers And Footers
Printing Formulas
Scale To A Specific Number Of
Pages
Specifying Number Of Copies
Printing An Entire Workbook
Specifying Paper Size
Understanding Paper Sizes
Copying And Filling
Understanding Copying In Excel
Using Fill For Quick Copying
Copying From One Cell To
Another
Copying From One Cell To
Multiple Cells
Copying From Many Cells To
Many Cells
Copying Relative Formulas
Copying To A Non-Contiguous
Range
Copying Between Worksheets
Copying Between Open
Workbooks
Adjusting A Worksheet
Inserting Cells
Deleting Cells
Inserting Columns
Inserting Rows
Deleting Rows And Columns
Resizing Columns
Resizing Rows
Hiding Gridlines
Simple Data Entry
Typing Text
Typing Numbers
Typing Dates
Typing Simple Formulas
Moving Cell Contents
Moving A Cell To Another
Location
Moving A Range To Another
Location
Moving A Cell To Another
Worksheet
Moving A Range To Another
Worksheet
Moving A Cell To Another
Workbook
Moving A Range To Another
Workbook
Formulas
Understanding Formulas
Formulas That Add
The Sum Function
Formulas That Subtract
Formulas That Multiply And Divide
Referential Formulas
What If Formulas
More Complex Formulas
Formula Error Checking
Common Error Messages
Viewing Formulas
Working With Functions
Functions
Typing A Sum Function
Summing Non-Contiguous
Ranges
Calculating An Average
The Maximum Function
The Minimum Function
Absolute Referencing
Absolute And Relative
Referencing
Problems With Relative Formulas
Tracing Precedents
Creating Absolute References
Creating Mixed References
Circular References
Tracing Dependent Cells
Editing Data
Overwriting Cell Contents
Editing Long Cell Entries
Editing Formulas
Editing Functions
Using Undo
Using Redo
Filling Series
Filling A Series
Filling A Growth Series
Filling A Series Backwards
Filling Using Options
Creating A Custom Series
Modifying And Deleting Custom
Series
Formatting Cells
Using The Font Tools
Using The Alignment Tools
Using The Number Tools
The Format Cells Dialog Box
Formatting Fonts Using The Menu
Superscript, Subscript And
Strikethrough
Changing Horizontal Alignment
Centring Across A Selection
Wrapping Text
Changing Text Orientation
Changing Vertical Alignment
Formatting Dates
Formatting Numbers
Formatting Currency
Creating Custom Formats
Borders And Shading
Clearing Cell Formats
Charting
Using The Chart Wizard
Choosing The Chart Type
Changing The Chart Type
Modifying A Chart
Printing A Chart
Creating A Pie Chart
Creating A Bar Chart
Moving A Chart
Deleting A Chart
Creating A Column Chart
Creating A Line Chart
Moving A Chart To Another
Workbook
Copying A Chart Within A
Worksheet
Copying A Chart To Another
Workbook
Resizing A Chart
Hyperlinks
Hyperlinking Within A Workbook
Using A Hyperlink
Hyperlinking To A Range
Hyperlinking Between
Applications
Description:
The skills and knowledge acquired in Microsoft Excel 2003 Fundamentals are sufficient to be able to use and operate the software at an efficient level.
2-e-2
2e2 Training offer superb courses in many IT training fields, and have done for over ten years.
Renowned for delivering engaging technical training in Cisco, Citrix, IBM Lotus, Linux, Microsoft, Novell, Oracle, UNIX and VMWare, 2e2 are proven leaders in delivering relevant course material that is easily digested.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.