Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2019 Intermediate

Course Outline

Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019 Introduction. Learn data setup, formula techniques, functions, formatting and linking, sorting and filtering data. This course would suit those who have basic day to day excel skills but want to learn more advanced techniques and functions of the software.

Topics include

  • Page Setup
  • Filling Data
  • Formula Referencing
  • Formula Techniques
  • Logical Functions
  • Number Formatting Techniques
  • Conditional Formatting
  • Worksheet Techniques
  • Data Linking
  • Sorting Data
  • Filtering Data Charting Techniques

Zoom

This course will be delivered using virtual classroom via Zoom in Term 3 2021.

Zoom is easy to use video conferencing software with a simple set up. You will be able to see your trainer and classmates and interact as though you were in the same room, all from the comfort of your own home!

This is what you need to join a Zoom classroom:

. Understanding the basics of using Zoom – see our free Zoom tutorial by clicking here.
. Access to a computer, iPad/tablet or smartphone; and
. A webcam* so that you can be seen by the trainer; and
. A microphone* so that you can participate in the class and be heard by the trainer; and
. A good Internet connection.

*Please note if you have a laptop computer a webcam and microphone are usually built into the top of the screen frame. Smartphones and iPad/tablets also contain cameras and microphones.

Once you have watched our free tutorial and experimented with Zoom, if you still have questions, we are offering free Q & A Zoom sessions with one of our experienced trainers. Please contact the office on 9970 1000 or email enquiries @nbmc.nsw.edu.au for further details.

Using Zoom for Computer Classes

Please paste this link into your browser for further information on how to use Zoom for computer students.

https://youtu.be/mKfPsFp2nkQ

This video demonstrates how you can use two screens or split your computer screen if you are attending one of our computer / software application courses.

Prerequisites

  • Confident keyboarding skills and Excel Introduction course or equivalent skills and knowledge
  • Students must have Excel 2016/2019 or Office 365 installed on their computer.

Funding

This course may be fully funded under the NSW Government’s Adult & Community Education funding or Tech Savvy for Small Business Program in 2021. See ACE Community Service Obligation Funding page for details or See Tech Savvy for Small Business Program page or contact Susan Wilkinson on 9970 1000 or email vet@nbmc.nsw.edu.au to check eligibility or for further information.

$136 Limited GST free / $122.40
Excel 2019 Intermediate

<h3 id="CourseOutline">Course Outline</h3><p>Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019

...
If you have been impacted by the COVID-19 lockdown and wish to apply for a funded position in this course, please email Susan Wilkinson at vet@nbmc.nsw.edu.au or phone her on 9970 1000.
$155 Limited GST free / $139.50
Excel 2019 Intermediate

<h3 id="CourseOutline">Course Outline</h3><p>Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019

...
If you have been impacted by the COVID-19 lockdown and wish to apply for a funded position in this course, please email Susan Wilkinson at vet@nbmc.nsw.edu.au or phone her on 9970 1000.

If there isn't a class to suit you, please the waiting list.

Course testimonials:

  • The whole day was great, I learnt so much. Thanks Nicky for a great course.
  • Who thought that an Excel course could have you focused for a full day without a dull moment. Excellent trainer, learnt a lot with very practical applications. Highly recommended.
  • I really enjoyed the course and learnt a lot. Nikki is a very knowledgeable and engaging trainer. Highly recommended.
  • Great session. Great Teacher. Nicky was lovely and very helpful and thorough in her teaching.

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113