Microsoft Office Courses
Web/Graphic Design Courses
Microsoft Certification
Cisco Certification
CompTIA
Linux Certification
Testing Tool courses
Database Courses
Programming courses
MYOB
Engineering / AutoCAD
Networking / VoIP Courses
Security Courses
VMWare Course
Project Management Courses
Microsoft Excel 2007 Level 2
Duration:  8 Hours
Price:  $399 AUD
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
Course Content
  1. Excel 2007 Orientation
  2. Working With Multiple Workbooks
  3. Advanced Formatting
  4. Advanced Charting
  5. Combining Data from Multiple Sources
  6. Names And Labels
  7. Summarising Data
  8. Protecting Data
  9. Sorting
  10. Basic Filtering
  11. Web and Internet Features
ENROLL