Microsoft Excel Training

Microsoft Office 2016 Excel Public Training


Located in the BETA Computer Lab, Butler CC – Andover
715 E. 13th St.
Andover, KS

Classes meet 3rd Tuesday of the month. Classes are from 8:30 am -4:30 p.m.

COST: $179 Including your book!

Register for Training

Excel Part 1 November 15, 2016 April 18, 2017 July 18, 2017
Excel Part 2 January 17, 2017 May 23, 2017
Excel Part 3 February 21, 2017 June 20, 2017

 

 

 
Excel 2016 Part 1

Course Objectives:

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

  • Get started with Microsoft Office Excel 2013.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Target Trainee:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.

Excel 2016 Part 2

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will:

  • Customize the Excel environment.
  • Create advanced formulas.
  • Analyze data by using functions and conditional formatting.
  • Organize and analyze datasets and tables.
  • Visualize data by using basic charts.
  • Analyze data by using PivotTables, slicers, and PivotCharts.

Target Trainee:

This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Excel 2016 Part 3

Course Objectives:

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

  • Work with multiple worksheets and workbooks simultaneously.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Apply conditional logic.
  • Audit worksheets.
  • Use automated analysis tools.
  • Present your data visually.

Target Trainee:

This course is intended for students who are experienced Excel 2013 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Contact and Registration Info

If you have any questions, please contact the BETA Office at 316.218.6118 or email us at beta@butlercc.edu. You can also register for training by clicking the button below.