Microsoft Excel 2003 Level 1 Training Course
Microsoft Excel 2003 Level 1 Training Course Summary
Training Course Price : £249
Training Course Length : 1 Day
This Microsoft Excel training course is aimed at individuals who have a basic competency with using a computer - for example you will idealy have the skill to use and a mouse, have used the internet before and are comfortable with using Windows as your operating system.
It is also ideally suited towards people who may have traditionally used a paper based system to store data and run calculations through, but are now preparing to switch to an electronic system such as excel. The course starts at a very basic level and works through in an intelligent manner - so it would also be beneficial to those who had previously used excel for the simplest of functions.
This Excel training course will give you the knowledge to perform the following functions :
- Use Microsoft® Office Excel 2003 to manage, edit, and print data.
- Create and edit basic Microsoft® Office Excel 2003 work
More specifically, completion of this Level 1 Microsoft Excel training course will allow you to perform the following tasks confidently :
- create a basic worksheet.
- modify a worksheet.
- perform calculations.
- format a worksheet.
- develop a workbook.
- print the contents of a workbook.
- customize the layout of the Excel window.
- sheets and workbooks.
Entry Level for Participants wanting to attend Microsoft Excel 2003 Level 1 Training Course
There are no set entry level criteria for participation in this course, however, it would be very beneficial for all attendee's to have taken the Microsoft Office Windows XP : Introduction course, or have an equivalent working knowledge.
If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.
Who is this Microsoft Excel 2003 Level 1 Training Course aimed at?
This Excel training course is ideally levelled at anyone preparing to become certified as a Microsoft® Office Specialist in Excel, and who already has knowledge of the Microsoft® Office Windows 98 (or above) operating system, but who also wishes to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.
It also perfect for anyone who just wishes to get a basic grounding in how to operate Microsoft Excel and what its capabilities are.
Training Course Overview/Content:
Getting Started
- Enter data in a worksheet
- Edit data
- Change the appearance of data
- Save a workbook
Editing Your Worksheet
- Moving data to other cells
- Copy data to other cells
- Fill cells with a series of data
- Insert and delete rows and columns
- Undo and Redo an entry
- Find and replace numbers
- Enter data in a range
- Verify data in a range
Performing Calculations
- Sum a Range of Data
- Use a Built-in Function
- Copy a Formula
- Create an Absolute Reference
Formatting
- Number Formats
- Custom number formats
- Font Size and Type
- Styles
- Borders and Colours to cells
- Column Width and Height
- Align Cell Contents
- Merge and Center Cells
- AutoFormat
Working with multiple worksheets
- Format worksheets Tabs
- Reposition Worksheets in a workbook
- Copy Worksheets
Customising layout
- Split a worksheet
- Arrange worksheets
- Freeze and unfreeze rows and columns
- Hide & Unhide worksheets
Page Display & Printing Options
- Freeze rows and columns
- Print Title
- Set Page Margins
- Headers and Footers
- Page Orientation
- Insert and remove page breaks
- Print a range
For more general information on Microsoft Excel, check out the Wikipedia Microsoft Excel information page.
