Microsoft Excel: Spreadsheet Basics

This is a basic/intermediate level course for those who are mainly self-taught users of Excel and would like to improve their skills and become more proficient users.

Skills introduced:

  • Workbooks/Worksheets
    • Navigating
    • Auto-fill
    • Entering and editing cells
    • Naming cells and ranges
    • Moving and copying worksheets
    • Hiding data
    • Number formatting
    • Protecting worksheets/workbooks
  • Excel Tables
    • Creating
    • Sorting and filtering
    • Adding data
    • Themes and styles
    • Referenced formula
  • Data Validation Lists
    • Allows users to determine and limit what data can be entered in cells
  • Conditional Formatting
    • Allows cells to be automatically formatted (e.g. colour of text/cell etc.) if they meet certain criteria set by the user (e.g. over or under a set value, top 10 values etc.)
  • Formulas
    • AutoSum
    • Absolute and relative references
    • Sum(ifs)
    • Sum
    • Counta
    • Count
    • Min
    • Max
    • Average

Requirements: 
Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher.  To check version, open a spreadsheet, click on File then Account.  
Please inform the training provider if you will be bringing a Mac laptop.

This workshop is interactive and attendees will gain hands-on experience.  Raw data to work with and useful summary notes will be provided.

Limited spaces to ensure student-centred learning.

Read about the trainer here

Register to attend below.

For more information, contact Julia at
julia@taranakichamber.co.nz,
or call 06 759 9080

Date:
Wednesday, 24th February, 2021
Time:
9:30 a.m. to 11:30 a.m.
Location:
TSB Hub Hawera
Single Ticket (Member) incl GST:
$138.00
Single Ticket (Non-Member) incl GST:
$165.00
Event Details
  
Booking Details
  
Attendees
  
Payment/Invoice
   Confirmation

Step 1 of 5 - Event Details

Membership

Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.

Forgotten Password

Event

Total (incl GST)

Registration Policy:

Payment is required prior to course attendance, and your registration will be confirmed once payment has been made.

Cancellation Policy:
Any cancellation and/or changes must be made in writing to the Taranaki Chamber of Commerce no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this or for non-attendance at the course.

IN THIS SECTION