Employee and Organizational Development

Excel 2016 Courses

Windows 10 and Office 365 updates bring you a new way of learning software! We've divided and targeted our courses; you learn what you want! Take one course or take them all, it's your choice on your time.

Please be sure that you choose the course that coresponds with your software version. Office 2010 software users are welcome to take 2016 courses in preperation for the update, but your office software may not have the features taught in 2016 courses until your agency has updated to Windows 10.

 

Excel 2016: Basics

4-hour class - Cost: $80
AFE # for DOT- 77C7

Prerequisites: Basic computer skills.

Description:
Get started with Excel! Learn the basics and put your data to work.

Objectives:

  • Open, create, and work with a spreadsheet
  • Enter values and edit cell contents
  • Enhance spreadsheets using formatting techniques
Date
Time
City
Location
October 23, 2018
8 am - 12 noon
Pierre

 

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II

 

 

Excel 2016: Charts

3-hour class - Cost: $60
AFE # for DOT- 77F2

Prerequisites: Excel 2016: Basic or a basic Microsoft Excel skill set.

Description:
Turn your raw data into graphically enhanced results!

Objectives:
  • Select the source data
  • Create and modify a chart
  • Emphasize data
  • Create a Sparkline
Date
Time
City
Location
October 23, 2018
1 pm - 4 pm Pierre

 

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II

 

 

Excel 2016: Pivot Tables

4-hour class - Cost: $80
AFE # for DOT- 77C8

Prerequisites: Excel 2016: Basic or a advanced Microsoft Excel skill set.

Course Description:
Are you getting bogged down in the details? Unleash the full potential of Excel! Pivot tables are some of the most powerful and time saving tools Excel has to offer.

Objectives:
The participant will:
  • Create a pivot table
  • Group and filter data
  • Insert PivotCharts
Date
Time
City
Location
October 24, 2018
8 am to Noon
Pierre

 

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II

 

 

 

Excel 2016: Formulas

3-hour class - Cost: $60
AFE # for DOT- 77C8

Prerequisites: Excel 2016: Basic or a basic Microsoft Excel skill set.

Description:
Take the fear out of formulas! Make the numbers add-up every time, learn shortcuts for data manipulation, and so much more. Learn the codes that make Excel exquisite.

Objectives:
  • Use basic formulars and functions
  • Learn logical and text functions
  • Use VLOOKUP
  • Troubleshoot formula errors
Date
Time
City
Location
October 24, 2018
1 pm to 4 pm
Pierre

 

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II

 

 

 

Excel 2016: Large Files

3-hour class - Cost: $60
AFE # for DOT- 77C9

Prerequisites:Excel 2016: Basic or an intermediate Microsoft Excel skill set.

Description:
Know the basics? Now it's time for big data!

Objectives:
  • Formulas across multiple files
  • Printing large document
  • Customizing and saving views
  • Collaborate with others using OneDrive
Date
Time
City
Location
November 27, 2018
9 am - Noon
Pierre

 

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II