Building Powerful Spreadsheets in Excel



Course Date: 23rd August, 2016

Location: Kelowna Heritage Loft, 201-339 Bernard Ave Kelowna (access is via stairs only)

Course Times: 9am – 4pm

Harness the Power of Excel – Without the Hard Work

Most People either use pre-existing Excel spreadsheets or attempt to build their own. But did you know that most people only use a fraction of the tools available to them in Excel? Knowing the correct way to build spreadsheets and store data in Excel opens up a world of never before used tools and functionality to you.

In this 6 hour workshop we will cover how to store and structure your data properly, build user friendly spreadsheets and how to lay out your spreadsheet to maximize Excels powerful tools. Time is also built in to the sessions to allow for specific questions and for customization specific to individual users.

Topics will include:

  • Understanding Spreadsheet Layout
  • Data Entry
  • Creating Calculations
  • Using Functions
  • Linking between Spreadsheets
  • Formatting Data
  • Sorting
  • Print Settings
  • Charting Essentials
  • Hints, Tips and Shortcuts

This workshop session will be instructor-led, hands-on and specifically designed for maximum retention and understanding.

Each student will have use of a computer during the day and practice exercises will be provided for each topic.

All students will have access to full support via telephone and email after the session.