Computers - Office Applications My Courses
23 courses found:
Showing: 1 - 6 Go to page: 1  2  3  4 Next

Access 2007 Level 1

GST Free Course
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
 
top

 

Access 2007 Level 2

GST Free Course
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
 
top

 

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
 
top

 

Excel 2003 Advanced

GST Free Course
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.
 
top

 

Excel 2003 Intermediate

GST Free Course
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
 
top

 

Excel 2007 Advanced

New Course!
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.
 
top

 
23 courses found:
Showing: 1 - 6 Go to page: 1  2  3  4 Next