£185 (includes course materials, lunch and refreshments) Corporate rates available please contact us for further information
This course is aimed at anyone who has some experience of Excel 2003 and wishes to examine some of the more advanced features.
Delegates should be familiar with the basics of Excel 2003, either from attending our Introductory Course or knowledge gained from their own experience.
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 course allows the delegate to experience the power of Excel 2003. By the end of the course, the user will be competent with the following skills:
Workbooks
- Renaming Sheets
- Display Multiple Sheets
- Copy and Moving Sheets
- Inserting and Deleting Sheets
- Grouping Sheets
Cell Referencing
- Relative Addressing
- Absolute Addressing
Functions
- Insert Function
- Count, CountA and Average
- Minimum and Maximum
- IF
- CountIF and SumIF
Options
- Control Display Options
- Create Custom Lists
Setting Chart Parameters
- Add Data Labels
- Add/Remove Legends
- Change Axis Intervals/Limits
- Add a Trendline
- Data Series Colour
Worksheet Views
- Multiple Windows
- Freeze Panes
Advanced Cell Formatting
- Text Wrap and Merge Cells
- Text Orientation
- Format Painter
- Conditional Formatting
- Paste Special
- AutoFormat
- AutoCalculate
Cell Comments
- Create, Edit and Delete Comments
Using Names
- Create, Apply and Paste
- Names in Formulas
Advanced Cell Editing
- Repeat
- Transposing Data
- Delete and Insert Cells
Templates
- Create a basic Template
- Using a Template
Advanced Printing
- Scaling
- Print Titles, an Area and a Selection
Advanced Formulas
- Data Series
- Custom Number Formats
Views
- Create, Display and Delete Views
Linking Cells
- Create a Link
- Link Workbooks
- Link to a Word Document
Filter Lists
- AutoFilter
- Custom AutoFilter
Sorting
- Multiple Column sorts
- Custom Date Sorts
Importing Data
- Import Text Files
This course outline is a guide. All our courses can be tailored to customer requirements.
Microsoft Excel 2003 Advanced 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