In-House Microsoft Office 95 – 2003 Training
Are your staff using Microsoft Office applications as a tool to increase their productivity? Streamlining their use of these applications will save your staff time, increase their productivity and make a better contribution to your bottom line.
All our Microsoft Office courses can be designed around the results of the initial application exercises and can be delivered at Beginner, Intermediate or Advanced level depending on the needs of your business and your staff.
We can offer training in Word, Excel, Outlook, PowerPoint and Access. Suggestions of the content of each level are given below. The exact content and length of each course will be developed based on our discussion.
Microsoft Word 95 – 2003
Beginner
- Text formatting (size, font style, colour, bold, underline and italic)
- Paragraph formatting (bullets, numbering, line spacing, borders, shading)
- Page layout (orientation, margins, page breaks, page numbering)
- Tables (insert, delete rows and columns, adjust column width)
- Copy / paste.
Intermediate:
- Templates
- Tables / Columns
- Mail Merge
- Hyperlinks
- Styles
- Page Layout (Header / Footer, Section breaks).
Advanced:
- Create templates
- Link information between documents
- Protection
- Version control
- Track changes / Compare and merge
- Forms
- Tables of content / Indexes, Bookmarks
- Macros
Microsoft Excel 95 – 2003
Beginner
- Enter numbers and text into spreadsheet
- Format cells
- Insert / delete rows and columns
- Find and replace
- Simple formulae
- Common functions
- Create graphs
Intermediate
- Absolute and relative cell references
- Format charts and graphs
- Analyse spreadsheets using Lists / Filters
- Graphs and Charts
- Mathematical, statistical, financial, conditional and logical functions
Advanced
- Protect cells, sheets, workbooks
- Data validation and Lookup functions
- What-if scenarios and Goal seek
- Pivot tables and charts
- Merge multiple copies of workbook
- Macros
Microsoft Outlook 95 – 2003
- Email – use folders, rules, filters, templates
- Calendar
- Tasks to keep your ‘to do’ list
- Contacts – create, maintain and organise using categories
Microsoft PowerPoint 95 – 2003
Beginner
- Slide layout and design, use existing templates
- Format slides (bullets, numbering, line spacing, alignment, colour, fonts, size, background)
- Handouts and speaker notes
Intermediate
- Master Slides
- Clipart and pictures
- Audio and video clips, understand formats
- Tables, Graphs and Hyperlinks
- Animations
- Slide transition
Advanced
- Create templates
- Animation sequences
- Action buttons
- Visual and sound effects
- Interactive elements
Microsoft Access 95 – 2003
Beginner
- Create single table
- Enter information into database
- Single criteria queries
- Create single table reports
Intermediate
- Modify database table
- Understand field types
- Put validation onto field
- Create form
- Multiple criteria query
- Format reports
Advanced
- Plan and create mutiple tables
- Setup relationships between tables
- Ensure data integrity is maintained
- Create and format forms and subforms
- Multiple criteria & multiple table queries.
Interested?
Contact us to discuss your specific requirements.
