£185 (includes course materials, lunch and refreshments) Corporate rates available please contact us for further information
Intending, new or recent users of Excel 2003.
Delegates should be familiar with the Windows operating system. No knowledge of Excel 2003 is expected.
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.
This practical course will introduce the delegate to Excel 2003. It will provide “hands on” experience of many of the features found in this programme. By the end of the course, the user will be competent with the following skills:
Fundamentals
- Spreadsheet Principles
- The Excel Screen
- Menus/Toolbars
- Taskbar
Save, Open and Close Workbooks
- Start a New Workbook
- Save and Close a Workbook
- Open a Saved Workbook
- Open Multiple Workbooks
Spreadsheet Modelling
- Spreadsheet Structure
- Create a Spreadsheet
- Labels and Numbers
- Moving Around a Worksheet
Formulas
- Add, Subtract, Multiply and Divide
- Brackets
- Percentages
- Ranges
- AutoSum
Editing Cells
- Edit Data
- Edit Directly in a Cell
- Delete Cell Contents
- Undo and Redo
- Copying and Moving
- Cut, Copy and Paste
- Copy a Range of Cells
- Use the Fill Handle
- Copy Formulas
- Drag and Drop
Printing
- Print Preview
- Page Setup/Margins
- Headers and Footers
- Gridlines and Headings
Formatting Cells
- Bold, Italic and Underline
- Numbers
- Date and Time
- Alignment
- Font Size and Colour
- Cell Borders and Shading
Formatting Worksheets
- Change Column Width and Row Height
- Insert and Delete Rows and Columns
- Hide Rows and Columns
Charts
- Create, Format and Print Charts
- Move and Resize
This course outline is a guide. All our courses can be tailored to customer requirements.
Microsoft Excel 2003 Intermediate or explore the benefits of using other Office applications including Access, Word, PowerPoint.
Microsoft Office Specialist
(MOS 2007)
MOS - Excel
MOS - Word
MOS - PowerPoint
MOS Outlook
MOS Access
Intensive Training (Office 2007)
Government funding available for local businesses through Train to Gain Enhancement Fund.
Click on icon to print this page
Email: info@ictacademy.co.ukTel: 01302 554958Address: ICT Academy, DBIC, Doncaster, DN4 5QA