| THE ARTS |
| BUSINESS & PROFESSIONAL DEVELOPMENT |
| LIFE SKILLS & WELLBEING |
| LANGUAGE & LITERACY |
| RECREATION & SPORT |
 |
|
|
| HOME |
WHATS NEW |
VENUES |
ABOUT US |
NEWS AND EVENTS |
STUDENT RESOURCES |
LINKS |
SUBSCRIBE |
| |
|
| |
 |
| Computers - Office Applications |
 |
| 23 courses found: | | Showing: 1 - 6 Go to page: 1 2 3 4 Next |
Access 2007 Level 1 |
|
Statement of Attainment in BSBITU301A Create and use databases, from BSB30407 Certificate III in Business Administration
Learn how to: Design and create tables to store data, * input, edit and delete data, *Sort and filter data, *Create Queries to extract informaton, *Create and use Reports, *Create and use forms to enter data; *Create and modify reports to display information |
| |
 |
 |
| | |
Access 2007 Level 2 |
|
Statement of Attainment in BSBITA401A Design databases, from BSB40207 Certificate IV in Business Administration
Learn how to: use data validation, format tables; create and use parameter and calculation queries; create and use reports; import data; create forms and subforms; create and use macros; use macros on forms |
| |
 |
 |
| | |
Excel 2003 Introduction |
|
| Learn how to: *Create and format simple spreadsheets *Create and use simple formulas and functions *Use copy and fill *Sort data *Use printing techniques *Create simple charts |
| |
 |
 |
| | |
Excel 2003 Advanced |
|
| Learn how to: nest functions to create complex formulas; use advanced filters to analyse; data validation techniques; create, use and modify data tables; pivot tables; linking to create more efficient workbooks; summarise data using subtotals and relative range naming; create recorded macros. |
| |
 |
 |
| | |
Excel 2003 Intermediate |
|
| Learn how to use: *Insert and delete cells, rows and columns *Formatting techniques like freezing , *Statistical, logical, date, and lookup functions *Modify and format charts *Work with absolute and relative references *Use autofilters |
| |
 |
 |
| | |
Excel 2007 Advanced |
|
| Learn how to; use lookup functions, protect data, summarise, data linking, data consolidation, create pivot tables and pivot table charts, goal seeking and recorded macros. |
| |
 |
 |
| | |
| 23 courses found: | | Showing: 1 - 6 Go to page: 1 2 3 4 Next |
|
|
|
|
|