Excel® II Designing and Troubleshooting Excel Workbooks

Excel® II starts Tuesday April 12th – seats still available. Register here: Excel®  II Designing and Troubleshooting Worksheets

Overview

You have  been working with Excel for a while, (more than six months) and you have experienced some or all  of the following symptoms:

  • Large worksheets are difficult to navigate and manage
  • Work that made perfect sense when you created it is difficult to fathom when revisited
  • Sharing your worksheets with others has led to a new role for you… software support technician
  • You are certain that there have to be better ways to do things, but you haven’t got time to find them
  • As you get better at working with Excel, you want to expand your Excel vocabulary so you can recognize new opportunities to apply this tool to your work

Course Description

This course covers planning and designing worksheets, protecting files, working with large and multiple worksheets, named ranges, built-in and user-defined functions, macros, data functions, pivot tables, and integration for Excel with other Microsoft Office products. The course includes templates that can be modified.

 

Duration: 12 hours

Register for this course: Excel®  II Designing and Troubleshooting Worksheets

Available Sessions

Apr 12Apr 19, 2016   | Tue | 9:00am-4:00pm | UBC Robson Square | $375.00
Nov 16Nov 23, 2016 | Wed | 9:00am-4:00pm | UBC Robson Square | $375.00

 

Theoretical Objectives

  • Worksheet Designers and Worksheet Users
  • Large Worksheets
  • Protecting Your Work
  • Formats / Custom Formats
  • Templates
  • Multiple Sheets – 3 D Issues
  • Documentation
  • Functions (anatomy, applications, user defined)
  • Lookup functions
  • Names
  • Goal Seeking and Solver
  • Scenarios
  • Macros
  • Database operations
  • Charting
  • Pivot Tables

Practical Objectives

  • In addition to Theoretical Objectives
  • Create models and templates
  • Decision Support Tool

 


Lab Equipment and Devices

The sessions are conducted in a computer lab and you will have a lab computer for you to use.

You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.

At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.

Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.

Instructional Methods

  • Hands-on labs
  • Discussion
  • Online collaboration
  • Lecture

Course Materials

  • Web site
  • Course notes
  • Printed copies of on-screen lecture notes available on request during lectures

No Recording or Pictures in the Lab

Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s