Description
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2007 effectively.
- work with workbooks in Excel 2007
- format a workbook to make it more visually appealing
- insert and delete rows and columns
- create and use range names to speed up workbook operations
- customise the appearance of charts
- generate data outlines and subtotals
- consolidate data
- protect worksheet cells and workbooks from unauthorised changes
- sort data in a worksheet
- filter data in a worksheet.
- save workbooks as web pages and insert hyperlinks
|