Excel 2016 Level 1
Discover how to create and develop worksheets and workbooks in order to work with and analyze data. Topics include calculations, modifying and formatting a worksheet and managing workbooks. Workbook included. 9 hours.
Prerequisites: Knowledge of Windows and Word.
Sec 1: Tues & Thurs, Jan 16-Jan 23, 6:30-9:30
Sec 2: Sat, Apr 14 – Apr 28 10, 9 am-noon • Brookdale at Long Branch
Sec 3: Mon & Wed, Jun 11 – Jun 18, 6:30-9:30 pm • Freehold Campus
Fee and Code: $165, XCOMO 290
Excel 2016 Level 2
Learn to mine critical information from your raw data. This course covers the more sophisticated functions in Excel needed to analyze and present data. You will work with functions and lists and analyze data. Learn how to develop PivotTables and PivotCharts to present data in an organized manner. Workbook included. 9 Hours.
Prerequisites: Knowledge of Excel Level 1 or equivalent experience.
Sec 1: Tues & Thurs, Feb 13-Feb 20, 6:30-9:30
Sec 2: Tues & Thurs, May 15-May 22, 6:30-9:30
Sec 3: Mon & Wed, Jul 9 – Jul 16, 9 6:30-9:30 pm • Freehold Campus
Fee and Code: $165, XCOMO 291
Excel 2016: Data Analysis
Learn to analyze with large amounts of data and gain actionable insight by using advanced PivotTable and PivotCharts. You will be able to summarize and organize the data in a way that can be meaningfully presented to others. Additionally, gain a solid understanding of how to use Excel Power Pivot to manipulate, and report on your data in the best way possible. Workbook included. 12 Hours.
Prerequisites: Knowledge of Excel Level 2 or equivalent experience.
Tues & Thurs, Jun 5-Jun 14, 6:30-9:30 pm
Fee and Code: $219, XCOMO 302