Outlook® Out of the Inbox

If you are familiar with previous versions of Microsoft Outlook then sending and receiving email with Outlook 2016/2013 is very simple. For many people making the transition, that is where they stop exploring. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like emailing, scheduling and responding to appointments, categorizing your mail and calendar events. We also explore new ways to be productive with flags, rules, automatic formatting, quick art, smart parts and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course: Outlook® – Out of the Inbox

 

Theoretical Objectives

  • Understand why the Inbox gets out of control and identify specific issues arising from the way you use Outlook now.
  • Understand the key actions that can arise from an email and learn Outlook shortcuts to accomplish these quickly.
  • Identify some best practices that are supported by Outlook, which can be applied to your individual situation.
  • Choose specific features or Outlook that you can use immediately.
  • Create a plan for you will start using those features.

Practical Objectives

Use the Fluent User Interface

  • Ribbon
  • Backstage View
  • Quick Access Toolbar
  • Navigation Pane
    • Folders
    • Buttons
  • To-Do Bar
    • Date Navigator
    • Appointments
    • Task List
  • Categories
  • Tasks
  • Folders
    • Search Folders
  • Quick Parts
  • Key Tips (old name – keyboard shortcuts)
  • Optional topics
    • Archiving / Backup
    • Journal

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

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.

Excel® I Introduction to Workbooks, Charting, Data Management

Excel icon

Overview

Microsoft Excel® is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Coming Tuesdays:  October 13-20 2015 at UBC Robson Square

Course Description

With Excel you can:

  • Work with your numeric data
  • Display it as charts
  • Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies.
Duration: 12 hours

Register for this course: Excel® I Introduction to Workbooks, Charting, Data Management

 

Theoretical Objectives

  • History and applications for worksheets
  • Creating formulas
  • Formatting to add meaning
  • Functions (structure and use)
  • Charts for communication
  • Database terminology & applications

Practical Objectives

  • Worksheets for manipulating numeric data
  • Formatting
  • Creating and modifying Charts
  • Creating and modifying Data tables (edit, sort and filter)
  • Budget Models
  • 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.

Outlook® Out of the Inbox

Outlook icon

Next session is Monday February 2nd. Seats still available
If you are familiar with previous versions of Microsoft Outlook then sending and receiving email with Outlook 2013/2010 is very simple. For many people making the transition, that is where they stop exploring. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like emailing, scheduling and responding to appointments, categorizing your mail and calendar events. We also explore new ways to be productive with flags, rules, automatic formatting, smart art, quick parts and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course: Outlook® – Out of the Inbox

Monday February 2nd 9:00am-4:00pm  UBC Robson Square 

 

Theoretical Objectives

  • Understand why the Inbox gets out of control and identify specific issues arising from the way you use Outlook now.
  • Understand the key actions that can arise from an email and learn Outlook shortcuts to accomplish these quickly.
  • Identify some best practices that are supported by Outlook, which can be applied to your individual situation.
  • Choose specific features or Outlook that you can use immediately.
  • Create a plan for you will start using those features.

Practical Objectives

Use the Fluent User Interface

  • Ribbon
  • Backstage View
  • Quick Access Toolbar
  • Navigation Pane
    • Folders
    • Buttons
  • To-Do Bar
    • Date Navigator
    • Appointments
    • Task List
  • Categories
  • Tasks
  • Folders
    • Search Folders
  • Quick Parts
  • Key Tips (old name – keyboard shortcuts)
  • Optional topics
    • Archiving / Backup
    • Journal

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.

Excel® I Introduction to Workbooks, Charting, Data Management

Excel icon

Overview

Microsoft Excel® is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Coming Tuesdays:  January 27 – February 4th 2015 at UBC Robson Square

Course Description

With Excel you can:

  • Work with your numeric data
  • Display it as charts
  • Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies.
Duration: 12 hours

Register for this course: Excel® I Introduction to Workbooks, Charting, Data Management

 

Theoretical Objectives

  • History and applications for worksheets
  • Creating formulas
  • Formatting to add meaning
  • Functions (structure and use)
  • Charts for communication
  • Database terminology & applications

Practical Objectives

  • Worksheets for manipulating numeric data
  • Formatting
  • Creating and modifying Charts
  • Creating and modifying Data tables (edit, sort and filter)
  • Budget Models
  • 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.

Outlook® Out of the Inbox

Outlook icon

Next session is Tuesday October 7th. Seats still available
If you are familiar with previous versions of Microsoft Outlook then sending and receiving email with Outlook 2013/2010 is very simple. For many people making the transition, that is where they stop exploring. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like emailing, scheduling and responding to appointments, categorizing your mail and calendar events. We also explore new ways to be productive with flags, rules, automatic formatting, smart art, quick parts and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course: Outlook® – Out of the Inbox

Tuesday October 7th 9:00am-4:00pm  UBC Robson Square 

 

Theoretical Objectives

  • Understand why the Inbox gets out of control and identify specific issues arising from the way you use Outlook now.
  • Understand the key actions that can arise from an email and learn Outlook shortcuts to accomplish these quickly.
  • Identify some best practices that are supported by Outlook, which can be applied to your individual situation.
  • Choose specific features or Outlook that you can use immediately.
  • Create a plan for you will start using those features.

Practical Objectives

Use the Fluent User Interface

  • Ribbon
  • Backstage View
  • Quick Access Toolbar
  • Navigation Pane
    • Folders
    • Buttons
  • To-Do Bar
    • Date Navigator
    • Appointments
    • Task List
  • Categories
  • Tasks
  • Folders
    • Search Folders
  • Quick Parts
  • Key Tips (old name – keyboard shortcuts)
  • Optional topics
    • Archiving / Backup
    • Journal

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.

Excel® I Introduction to Workbooks, Charting, Data Management

Excel icon

Overview

Microsoft Excel® is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Coming September 22-29 2 sessions Mondays 9:00am-4:00pm UBC Robson Square

Course Description

With Excel you can:

  • Work with your numeric data
  • Display it as charts
  • Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies.
Duration: 12 hours

Register for this course: Excel® I Introduction to Workbooks, Charting, Data Management

 

Theoretical Objectives

  • History and applications for worksheets
  • Creating formulas
  • Formatting to add meaning
  • Functions (structure and use)
  • Charts for communication
  • Database terminology & applications

Practical Objectives

  • Worksheets for manipulating numeric data
  • Formatting
  • Creating and modifying Charts
  • Creating and modifying Data tables (edit, sort and filter)
  • Budget Models
  • 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.