Description: Microsoft Excel Intermediate level

The objective of this course is to become familiar with the more detailed features of Excel

• Shortcuts
• Formatting techniques
• Printing 
• Paste Function
• Data Validation
• Absolute Cell References
• If Function
• Vertical & Horizontal Lookup
• Conditional Formatting
• Format Painter
• Creating a chart with excel data
• Editing your chart
• Data Tables in Charts
• Using charts within Word
• Using Workgroups
• Macros and Personal.xls
• Using Excel as a database
• Sorting and Querying Data
• Autofilter / Advanced Filter
• Subtotals

Note:  Where possible, courses can be tailored and designed to meet the needs of the participant/group in order to maximise the knowledge gained from the programme