Hornsby - Ku-ring-gai Community College
Results for excel

Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel: Advanced

Topics to be covered: Power Query Conditional formatting PivotTables Data validation Automation Functions including logical, text, and lookup Pre-requisites:   Prior experience of excel, know common IT and MS Office terminology, and be able to perform common MS Office functions [More]
$120 Limited inc GST
Excel: Advanced

<p>Topics to be covered:</p>

<ul>

<li>Power Query</li>

<li>Conditional formatting</li>

<li>PivotTables</li>

<li>Data validation</li>

<li>Automation</li>

<li>Functions including logical, text, and

...

**Please note class now starting on 2 April 2024**

To claim NSW Government funding* under the Adult Community Education (ACE) and Targeted Skills for 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 Targeted Skills for 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 

Experience significant barriers to training and employment

OR (for TSB)

Small business owners and employees and non-for-profit employees, who meet the Smart and Skilled eligibility criteria, can access fully funded training in targeted courses in information technology, business

services and foundation skills

Register your interest

Computer: Basics 3

In this course you will gain the skills and knowledge required to use multiple functions on computers, such as settings, tools for security, collecting data to construct tables, graphs and charts in a spreadsheet. [More]
$150 Limited GST free / $141
Computer: Basics 3

In this course you will gain the skills and knowledge required to use multiple functions on computers, such as settings, tools for security, collecting data to construct tables, graphs and charts in a

...

To claim NSW Government funding* under the Adult Community Education (ACE) and Targeted Skills for 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 Targeted Skills for 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 

Experience significant barriers to training and employment

OR (for TSB)

Small business owners and employees and non-for-profit employees, who meet the Smart and Skilled eligibility criteria, can access fully funded training in targeted courses in information technology, business

services and foundation skills

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

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]

Register your interest

Spreadsheets Level 3

In this class you will learn the skills and knowledge required to develop spreadsheets through the use of spreadsheet software. You will learn how to: Select and prepare resources Plan spreadsheet design Create spreadsheet Produce simple charts Finalise spreadsheets This training applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. Please contact our office if you wish... [More]

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]
$0 Limited / $0
Spreadsheets Level 1

In this course you will be taught how to use a spreadsheet application to create and format spreadsheets.<br/>You will learn how to:<br/>• Create and format a spreadsheet<br/>• Enter simple formulae

...
no session
2024-03-30 2024-03-30
Venue TBA

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 Training

This class will cover the following MS Office applications: MS Word MS Excel MS PowerPoint [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]
Assessments are made against units of competency from the Certificate II in Workplace Skills BSB20120.
  • Use business software applications (BSBTEC201)

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