Microsoft Excel - Levels 1 & 2

Police Academy Logo

Course Description:

Microsoft Excel provides an automated business tool you need for working with numerical information. Excel can be used for many purposes, such a performing data analysis, calculating payment information, budget forecasting, or organizing and displaying data in a chart. Advanced features allow you to work with data in a different aspect and make it easier to work with the worksheet data. This course will provide you with the basic and advanced features of the Excel program by exploring the capabilities of the software in a hands-on environment.

Instructor:

Michael Richardson, IT Specialist/Trainer – Charter Township of Plymouth. Mike has over 43 years in Municipal Government, including 15 years as Dispatch/Records Supervisor with the Plymouth Township Police Department. Mike has also taught his course to civilian and police personnel throughout the greater Detroit area and is a retired from the United States Navy after a distinguished 22 and half year career.

Topics:

Level 1

  • Working with Electronic Worksheets
  • Creating Worksheets
  • Manipulating Worksheet Data
  • Working with Formulas and Functions
  • Formatting Worksheets
  • Working with Charts/Printing Worksheets 

Level II

  • Working with Advanced Formulas and Functions
  • Managing Workbooks
  • Working with Tables
  • What-if Analysis of Data
  • Exchanging data with Microsoft Office Programs

Course Details:

- 302 Funds Eligible -