Diamond Valley Learning Centre
MENUMENU
  • Home
  • Courses
    • Business Skills

      • Accounting For Small Business
      • Bookkeeping for Beginners / Small Business
      • Social Media Skills
      • MYOB for Beginners
      • XERO For Beginners (Level 1)
      • Xero Essentials (Level 2)
    • Enrich Your Life

      • Acrylic Painting
      • Introduction To Barista Course
      • Introduction To Gita Yoga
      • Advanced Barista Training
      • Floristry Beginners
      • Floristry Arrangement Set 1
      • Floristry Arrangement Set 2
      • An Introduction to Digital Photography
    • Vocational Courses

      • Certificate II in Auslan PSP20218
      • Certificate III in Auslan PSP30218
      • SFL20115 Certificate II in Floristry (Assistant)
      • CHC33021 – Certificate III in Individual Support (Ageing and Disability)
      • FNS40222 – Certificate IV in Accounting and Bookkeeping
      • HLTAID009 Provide Cardiopulmonary Resuscitation
      • First Aid Course (Includes CPR)
    • Computer Skills

      • Excel Skills Level 2
      • Digital Essentials Level 1
      • Digital Essentials Level 2
      • Introduction to Google Docs and Google Sheets
      • Introduction to Microsoft Word and Excel
      • Introduction to Microsoft Outlook and Email
      • Staying Safe Online
    • Language

      • Sign Language for Beginners
      • Sign Language Intermediate
      • Sign Language Advanced
      • Italian Beginners
      • Italian Intermediate
      • Spanish Beginners
      • Spanish Conversational
    • Health & Community

      • Aspektism For Teens and Adults
      • First Aid for Babies and Toddlers
    • Community Groups

      • Auslan Corner
      • Creative Connections
      • Exploring Women’s Issues Group
      • Literature for Pleasure
      • Social Drop-In Greensborough
      • Walking Group Greensborough
      • Words of Wonder
  • About
    • About DVLC
    • Community Network
    • Complaints Process
    • Student Handbook
    • USI Number
    • Childsafe statement
  • Reconnect
  • Spelling Guide
  • Contact
  • Get Involved
    • Donate
    • Volunteering
      • Volunteering Opportunity
    • Membership

Call us today! Call us today! (03) 9435 9060 Login

Home / Courses / Excel Skills Level 2

Excel Skills Level 2

Excel Skills Level 2

Upcoming Workshops
 
NameDateTimeAvailable SpacesCostEnrol Myself
Excel Skills Level 225 July - 29 August 202501:00 pm - 03:00 pm4$0.00
Enrol

Elevate Your Excel Proficiency in Just 6 Weeks!

Are you looking to enhance your Excel skills to excel in your professional journey? Our Advanced Excel Skills course is meticulously designed for individuals aiming to bolster their Excel expertise. Tailored specifically for those in small to medium-sized enterprises (SMEs), this course equips you with the essential tools and techniques to navigate Excel proficiently and efficiently.

 

Course Topics:

  1. Formulas and Special Functions: Explore the power of Excel formulas, including SUM, COUNT, AVERAGE, and IF statements, to streamline your data analysis processes.
  2. Texts and Numbers in Excel: Learn effective techniques for manipulating and managing text and numerical data within Excel.
  3. Relative & Absolute References: Master the art of using relative and absolute references to efficiently navigate and manipulate data across Excel spreadsheets.
  4. Macros: Automate repetitive tasks and boost your productivity by creating and deploying macros in Excel.
  5. VLookup vs. SumIf: Understand the differences between VLOOKUP and SUMIF functions and learn when to use each to extract valuable insights from your data.
  6. Pivot Tables: Unlock the full potential of Excel’s pivot tables to analyze, summarize, and visualize complex datasets with ease.
  7. Data Validation: Ensure data accuracy and integrity by implementing robust data validation techniques in Excel.
  8. Protect Sheet/Workbook: Safeguard your sensitive data and prevent unauthorized access by implementing sheet and workbook protection measures.
  9. Fixing Errors: Acquire troubleshooting skills to identify and rectify common errors encountered in Excel spreadsheets.

 

Who Should Attend?

  • Professionals working in SMEs seeking to enhance their Excel proficiency.
  • Individuals aspiring to excel in roles requiring advanced Excel skills, such as analysts, accountants, and project managers.
  • Small Business Owners

 

Enroll Today and Take Your Excel Skills to the Next Level!

Don’t miss this opportunity to invest in your professional growth. Join our Advanced Excel Skills course and unlock the full potential of Excel to drive success in your career.

Course Content

1. Formulas and special functions (Sum, Count, Ave, If statements)
2. Texts and numbers in Excel
3. Relative & absolute references
4. Macros
5. VLookup vs SumIf
6. Pivot tables
7. Data validation
8. Protect Sheet/Workbook
9. Fixing errors

Fee Structure

 

 TotalTuition FeeEnrolment FeeStudent Amenities
Funded$59.900509.90
Concession$49.900409.90

 

Funded Fee: Applies to all Australian or New Zealand Citizens, Holder of an Australian permanent visa, An Asylum seeker holding a valid visa that confers eligibility for Skills First training.

Concession Fee: Applies only to holders of a current Health Care Card, Pensioner Concession Card or Veteran’s Gold Card

Full Fee: Applies to those who do not qualify for government funding, ie. overseas residents and school students

Enrolment Fee is Non-Refundable*

Location

1 Diamond Creek Road, Greensborough, VIC 3088
Closest train station: Greensborough (5 minutes walk)
Limited free parking available on site

Facilitator

Winnie Ward

Related Courses

Introduction to Google Docs and Google Sheets

Introduction to Microsoft Word and Excel

Introduction to Microsoft Outlook and Email

Details



Enquire

Contact

03 9435 9060

1 Diamond Creek Rd,
Greensborough, VIC 3088

Office hours: 9am - 4pm
Monday to Friday

courses@dvlc.org.au

Nurture Possibility. Stir Change.

More

  • Childsafe statement
  • Complaints Process
  • Coronavirus information
  • Donations
  • Fees
  • Learner Plans & Learner Reviews
  • Policies & Procedures
  • Quality Compliance
  • Room Hire Greensborough
  • Disclaimer
  • Blog

© 2025 Diamond Valley Learning Centre. All Rights Reserved.

Diamond Valley Learning Centre Inc | ABN 58 891 533 250 | RTO TOID 3769 | Reg No. A 0000983G