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
    • 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
    • Basic arithmetical functions and order of preference
    • AutoSum
    • Sum
    • Counta
    • Count
    • Min
    • Max
    • Average

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 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.


Please note: This workshop is fully booked. An afternoon session is now available. Please click here for more information or to register.

Date:
Tuesday, 24th August, 2021
Time:
9:30 a.m. to 11:30 a.m.
Location:
Taranaki Chamber of Commerce
Single Ticket (Member) incl GST:
$138.00
Single Ticket (Non-Member) incl GST:
$165.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.