Office Applications - Hornsby - Ku-ring-gai Community College

MS Office - Intermediate

In this course you will learn: MS Word: Learn about basic formatting styles and key functions of this word-processing application. MS Excel: Learn to manipulate data, including the use of formulae, present in columns and rows and convert data into charts and graphs. MS PowerPoint: Learn to present information in a slide show, which can be used in meetings, seminars, training or other purposes. [More]

Assessments are made against units of competency from the Certificate II in Workplace Skills BSB20120.

Use business software applications (BSBTEC201)

MS Office - Intermediate

Wed 7 Jun - Wed 28 Jun 2023
9:30am - 3pm (UTC+10:00)
4 sessions, 22 hours total

Craig Hamilton

To claim NSW Government funding* under the Adult Community Education (ACE) and Tech Savvy Small Business (TSB) Programs**,** please contact us on 9482 1189, email clients@hkcc.nsw.edu.au,

or complete the online enrolment form:

http://www.hkcc.tech/enrolment/

*This training attracts full NSW Government funding under the Adult Community Education (ACE) and Tech Savvy Small Business (TSB) Programs, if you meet the following eligibility criteria:

• Are an AUS citizen, permanent resident, humanitarian visa holder, or a NZ citizen
• 15 years or older
• Live or work in NSW
• No longer at school or equivalent

AND (ONE of the following for ACE)

• Have very low literacy, language and/or numeracy skills, or
• Have limited employability skills where you require considerable additional support, or
• Have persistent and ongoing personal issues impacting on educational achievements, or
• Have a significant educational disadvantage impacting a student's ability to succeed in training

OR (for TSB)
• An owner or employee of a small business**

**A small business is defined as: 20 employees or less or an annual turnover of less than $2,000,000

Please note, if you chose not to be assessed against this unit of competency, class will finish at 12.30pm.

When	Time	Where
Wed 7 Jun 2023	9:30am - 3pm (UTC+10:00)	Room 6 - Hornsby Head Office
Wed 14 Jun 2023	9:30am - 3pm (UTC+10:00)	Room 6 - Hornsby Head Office
Wed 21 Jun 2023	9:30am - 3pm (UTC+10:00)	Room 6 - Hornsby Head Office
Wed 28 Jun 2023	9:30am - 3pm (UTC+10:00)	Room 6 - Hornsby Head Office

Register your interest

Excel: Beyond Charts

Pre-requisite: Intermediate Excel skills. In this course you will learn advance Excel features: Pivot Tables Using Macros and Automation Reference Functions Conditional Formatting [More]

Excel: Beyond Charts

Thu 15 Jun
2pm - 5pm (UTC+10:00)
1 session, 3 hours total

Craig Hamilton

To claim NSW Government funding* under the Adult Community Education (ACE) and Tech Savvy Small Business (TSB) Programs**,** please contact us on 9482 1189, email clients@hkcc.nsw.edu.au,

or complete the online enrolment form:

http://www.hkcc.tech/enrolment/

*This training attracts full NSW Government funding under the Adult Community Education (ACE) and Tech Savvy Small Business (TSB) Programs, if you meet the following eligibility criteria:

• Are an AUS citizen, permanent resident, humanitarian visa holder, or a NZ citizen
• 15 years or older
• Live or work in NSW
• No longer at school or equivalent

AND (ONE of the following for ACE)

• Have very low literacy, language and/or numeracy skills, or
• Have limited employability skills where you require considerable additional support, or
• Have persistent and ongoing personal issues impacting on educational achievements, or
• Have a significant educational disadvantage impacting a student's ability to succeed in training

OR (for TSB)
• An owner or employee of a small business**

**A small business is defined as: 20 employees or less or an annual turnover of less than $2,000,000

When	Time	Where	Session Notes
Thu 15 Jun 2023	2pm - 5pm (UTC+10:00)	Room 6 - Hornsby Head Office

Register your interest

Spreadsheets Level 1

In this course you will be taught how to use a spreadsheet application to create and format spreadsheets. You will learn how to: • Create and format a spreadsheet • Enter simple formulae and use the auto-fill function • Include charts and other objects in a spreadsheet • Save and print a spreadsheet [More]

Spreadsheets Level 1

no session

Venue TBA

Register your interest

E-Presentations Level 3

This course details the skills and software functions needed to create effective electronic presentations. You will learn how to: • Identify the purpose and audience of a presentation, along with any requirements or constraints for delivery • Design slides with a balance between readability and interest • Use templates and slide masters to ensure consistency • Finalise, save and print your presentation Please contact our office if you wish to enrol in the accredited unit BSBITU302... [More]

Register your interest

MS Office Advanced

In this course you will learn: MS Word Advanced: Plan, draft and finalise a document. MS Excel Advanced: Plan and create spreadsheets, while learning about layout, formulae and charts. MS PowerPoint Advanced: Design and produce electronic presentations using various applications and platforms. [More]

Register your interest

MS Office for Beginners

In this course you will gain the skills and knowledge required to select and use software and organise electronic information and data. The unit applies to those who use a limited range of practical skills with a fundamental knowledge of equipment use and the organisation of data in a defined context, under direct supervision or with limited individual responsibility. Technology and software covered in this course include: MS Word MS Excel MS PowerPoint Desktop Publishing [More]

Assessments are made against units of competency.

Use business software applications (BSBTEC201)

Register your interest

Job Seeker Breakfast

Every Monday, 9.45am to 11am from 25 July to 12 Sep Use HKCC’s computers or bring your own. Search for jobs, write your resume or cover letter. Assistance using digital technology is available. Places are limited, we therefore recommend you register beforehand. [More]

Register your interest

Microsoft Excel Intermediate

In this training you will learn the skills and knowledge required to correctly create and use spreadsheets and charts: Key elements of basic formatting styles appropriate to workplace documents Key functions of spreadsheet applications, both cloud-based and non-cloud based Key features of organisational requirements for ergonomic standards Key features of organisational guidelines on spreadsheet manipulation and processing This training consists of the accredited unit BSBITU212... [More]

Register your interest

Microsoft Word Intermediate

In this course you will learn the skills and knowledge required to digitally produce word documents in a workplace context: Key elements of basic formatting styles and their effect on formatting, readability and appearance of documents Key functions of word processing applications Key features of organisational requirements for ergonomics Key features of organisational style and presentation guide. This course consists of the accredited unit BSBITU211 Produce digital text documents. [More]

Register your interest

MS Office - Intermediate

In this course you will learn: MS Word: Learn about basic formatting styles and key functions of this word-processing application. MS Excel: Learn to manipulate data, including the use of formulae, present in columns and rows and convert data into charts and graphs. MS PowerPoint: Learn to present information in a slide show, which can be used in meetings, seminars, training or other purposes. [More]

Register your interest