Employee and Organizational Development

Excel 2010 Courses

Please be sure that you choose the course that coresponds with the software version you would like to learn. Office 365 software users will not get the most up to date information on new or different features included in the Windows 10/Office 365 update by taking 2010 courses.

 

Excel 2010: Basics

4-hour class - Cost: $68
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
July 24, 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.

 

 

Excel 2010: Charts

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

Prerequisites: Excel 2010: 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
July 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.

 

 

Excel 2010: Pivot Tables

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

Prerequisites: Excel 2010: 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
July 25, 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

 

 

Excel 2010: Formulas

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

Prerequisites: Excel 2010: 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
July 25, 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.

 

 

Excel 2010: Large Files

3-hour class - Cost: $51
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
TBD

 

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