Microsoft Excel 2003 Level 1 Course
Course DescriptionYou have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Excel 2003 to manage, edit, and print data.
|
£235 1 day course Scheduled Dates: 16 January 2012 13 February 2012 12 March 2012 10 April 2012 08 May 2012 11 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
To ensure your success, we recommend you have a basic knowledge of how to use a computer, mouse (etc).
This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.
Topics covered on the 1 day Microsoft Excel 2003 Level 1 course
Getting Started with Excel
- An Overview of Excel
- Navigate in Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
Modifying a Worksheet
- Move and Copy Data Between Cells
- Fill Cells with Series of Data
- Edit Cell Data
- Insert and Delete Cells, Columns, and Rows
- Find, Replace, and Go To Cell Data
- Spell Check a Worksheet
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Colour to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
Printing Workbook Contents
- Set a Print Title
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
Customizing Layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
16 January 2012 to 16 January 2012
13 February 2012 to 13 February 2012
12 March 2012 to 12 March 2012
10 April 2012 to 10 April 2012
08 May 2012 to 08 May 2012
11 June 2012 to 11 June 2012
View full schedule of Microsoft Excel courses
View full schedule of Microsoft Excel 2003 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses