Course Details
Course Details
Course ID
8532
Course Name
in30minutes: Excel Basics
Contact Hours
3.0
Approved Industry
Drinking Water and Wastewater
Partner Name
Pennsylvania Rural Water Association
Primary Contact
Joel Jordan
jjordan@prwa.com
8143539302 Ext. 201
Website
Description
Microsoft Excel® and spreadsheets are an essential tool in business and project management, including the water and wastewater utility industry. The in30minutes®: Excel Basics course is a quick start guide to help water operators and managers understand the basics of spreadsheet use. The goal is to provide core competence so that you can use spreadsheets for calculations and data storage with confidence.
Course Level
Basic/Precertification
Course Content
INTRODUCTION Excel: not just for nerds!
CHAPTER 1 The basics: cells, functions, and formulas
INTERLUDE Excel Ninja skill #1: AutoFill
CHAPTER 2 More basic skills, from pasting to percentages
INTERLUDE Excel Ninja skill #2: charts
CHAPTER 3 Sorting and filtering
CHAPTER 4 Printing, import/export features, and collaboration
Appendix - resource materials
Target Audience
Water utility operators and managers
Training Format
Virtual Asynchronous