Course Details
Course Details
Course ID
8951
Course Name
Excel Basic
Contact Hours
7.0
Approved Industry
Drinking Water and Wastewater
Partner Name
Butler County Community College
Primary Contact
Tom Baughman
thomas.baughman@bc3.edu
7242878711 Ext. 8355
Website
Description
The purpose of this course is to provide water/wastewater operators and mangers the ability to use multiple worksheets and workbooks, charts, and sort data in Excel.
Course Level
Basic thru Advanced
Course Content
• Worksheet concepts & terminology
• Entering and Editing Data – Text, values & basic formulas. Saving & updating workbooks.
• Modifying a worksheet – Moving & Copying Data, Moving, copying & viewing formulas, Absolute vs relative cell references. Inserting & deleting rows & columns
• Function Basics – Entering Functions, AutoSUM, Additional common functions
• Formatting – Text formatting, Row & column formatting, Number formatting, Conditional formatting
• Charts – Chart basics, Formatting charts
• Printing – Preparing for printing, Page Setup Options, Printing worksheets
Target Audience
Wate/wastewater operators and managers
Training Format
Classroom