Microsoft Excel: Basics/Intermediate

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.

Focus is on features that can be applied immediately to your data – especially tables – and make the biggest impact on your use of spreadsheets – whatever type of data you work with.

SKILLS INTRODUCED:

  • Workbooks/Worksheets:
    • Navigating
    • Auto-fill
    • Moving and copying worksheets
    • Worksheet tabs
    • Number formatting
    • Protecting worksheets/workbooks
  • Excel Tables:
    • Advantages
    • Creating
    • Sorting and filtering
    • Adding data
    • Forms to enter data
    • Themes and styles
  • Introduction to making professional looking Charts:
    • Choosing the correct chart type
    • Creating and editing charts
  • 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:
    • Basic arithmetical functions and order of preference
    • AutoSum
    • Sum
    • Counta
    • Count
    • Min
    • Max
    • Average

Read about the Training Provider, Excel Taranaki, and other workshops here

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.
Attendees will require a My Vaccine Pass to attend*

Tea, coffee, water and light refreshments will be provided.
This workshop is fully booked
To be added to a waitlist for a future workshop
contact Julia at julia@taranakichamber.co.nz, or call 06 759 9080
Date:
Tuesday, 5th July, 2022
Time:
9:30 a.m. to 11:30 a.m.
Location:
42 Egmont Street, New Plymouth
Single Ticket (Member) incl GST:
$159.00
Single Ticket (Non-Member) incl GST:
$189.00

Sorry this event is sold out or no longer available.

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.

Taranaki Chamber of Commerce Covid-19 Policy:

  • All Taranaki Chamber of Commerce events follow Government and Ministry of Health guidelines.
  • If you are feeling unwell with cold or flu symptoms, please stay at home.
  • The wearing of face coverings is recommended.