Excel - Intermediate

Take your Microsoft Excel skills to the next level with our comprehensive intermediate course designed to enhance your proficiency in this powerful spreadsheet software. Whether you're an office worker, business professional, or data enthusiast, this course will empower you with the knowledge and skills to efficiently manage and analyze data like a pro.

In this intermediate Excel course, you will explore a wide range of topics to expand your capabilities. From advanced formulas and functions to data visualization techniques and data analysis tools, you'll gain the expertise to handle complex datasets, streamline workflows, and extract meaningful insights from your data.

Harness the power of Excel's advanced features and unleash your data management potential. Book our intermediate Excel course today and embark on a transformative learning journey that will elevate your skills, boost your productivity, and make you a valuable asset in any data-driven environment. Get ready to excel in Excel!


REVIEW OF INTRODUCTION

  • Minimising, maximising and arranging windows
  • Cutting and pasting between spreadsheets
  • Linking spreadsheets
  • Consolidating data and using workbooks

DATABASE AND SORTING

  • Sorting rows based on a column
  • Subtotals
  • Outlining
  • Setting criteria and extracting records using Filters
  • Advanced Filter
  • Using the data form
  • Basic functions and function wizard

WORD AND GRAPHIC TOOLS

  • Adding and editing word processing frames
  • Using the drawing tools to add graphic objects

MISCELLANEOUS CONTENT AND TIPS

  • Absolute referencing
  • Freezing columns and rows for easy editing
  • Naming ranges for linking and quick positioning
  • Grouping Worksheets
  • Autofill and Series fills
  • Inserting comments and notes
  • Transpose columns and rows
  • Tips and techniques

Class Details

3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $150 + GST (per person)
3 people - $175 + GST (per person)
1 or 2 people - $205 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST

At Your Site

4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
2 or fewer people - $275 + GST (per person)

Venue:

Level 2 Primeproperty House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Upcoming Sessions

Date Time Cost excl. GST
Thu 7 - Thu 7 March 1:30 pm - 4:30 pm $205.00
Fri 5 - Fri 5 April 1:30 pm - 4:30 pm $205.00

Dates don't suit? Call or E-mail.