MICROSOFT EXCEL: INTERMEDIATE
With David Cox ICT Technician.
In this course you will learn about some of the more advanced features of this very powerful program. Topics will include advanced functions, database queries, Pivot Tables, conditional formatting, data validation and Macro basics. PC's used but also relevant to Macintosh users.
DESCRIPTION
This course is designed to extend your knowledge of Excel by introducing some more advanced features of this package.
RECOMMENDED FOR
People with experience in developing spreadsheets and writing formulas.
Course enquiries: Christy Dangerfield cdangerfield@ccgs.wa.edu.au
Tuesday 6pm - 8pm October 21, 28 November 4, 11 $295.00. Limit: 13
BOOK THIS COURSE ONLINE
NOW!
Type in the unit code (eg 071303) or course title to locate the enrolment page.
DOWNLOAD THE ENROLMENT FORM (PDF)
|
What is covered in this course
- Revision - Formula entry
- Relative and absolute addressing
- Using the If function
- Looking up values in tables: VLOOKUP function
- Date and time calculations
- Data validation & conditional formatting
- Macro basic concepts
- Databases
- Pivot tables
Examples
can be saved to CD at the
end of the session, so please bring a
blank CD.
|
 |
