| |
Quick Links to Popular Courses:
Excel
MS Project
Project Management
Time Management
PowerPoint
Word
More Courses |
Microsoft Excel
Microsoft Excel is a data manipulation package. You can hold large or small amounts of data in many different ways. It enables you to:
- Work with lists
- Produce charts/graphs
- Use calculations and functions
The different levels of training are listed below and the topics can be mixed and matched to suit your specific requirements.
- Understand how to work with Excel
- Enter, edit and delete data
- Select data
- Format your spreadsheets
- Apply calculations to data
- Print your worksheet
Click here to view course outline
- Understand and use range names
- Use Statistical functions
- Work with large spreadsheets and multiple workbooks
- Link data
- Utilise the database and filtering features
- Add and remove subtotals
- Create, format and modify charts/graphs
Click here to view course outline
Excel Advanced - Level 1 (1 day)
- Extend your knowledge of functions (using IF and VLookup)
- Protect your data
- Use the error checking features
- Create PivotTables
- Use the analysis features within Excel
- Import and export data
Excel Advanced - Level 2 (1 day)
- Create and use templates and styles
- Share your workbook
- Track any changes
- Automate your work with macros
- Use Data Tables
- Excel options
- Customise the menu and toolbars
|