CCS 424-01 Advanced Excel: Functions and Data Analysis
One of the most in-demand office skills today is having knowledge and experience with Microsoft Excel. If you use Excel regularly but feel it could do more, you’re right!
This one day course is hands-on. This course teaches the basics of building custom, nested, and 3D formulas; how to use powerful Excel functions such as IF, AND, OR, and VLOOKUP to create “smart” spreadsheets; how to create and use named ranges; and how to use Excel’s table function to manage lists. In order to get the most out your data you will learn how to analyze and extract custom information using the SUMIF, COUNTIF, AVERAGEIF, DGET, and DSUM functions and pivot tables.
Participants will also learn how to create dynamic charts from raw spreadsheet data.
Instructor: Paul Proudian
Registration Deadline: TBD
Location: K108, CMCC, Auburn ME
Click here to register online