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: Mon: Oct 2-16, 6:30-9:30 pm
Sec 2: Sat, Dec 2-16, 9 am-noon • 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
Mon: Oct 30-Nov 13, 6:30-9:30 pm
Fee and Code: $165, XCOMO 291
Excel 2016 Level 3
Learn to execute complex data analysis, collaborate on workbooks with other users, and automate workbook functionality. Work with multiple worksheets and workbooks. Discover how to use Lookup functions and formula auditing. Other topics include protecting workbooks, automate workbook functionality and forecasting data. Workbook included. 9 Hours.
Prerequisites: Knowledge of Excel Level 2 or equivalent experience
Mon: Nov 27-Dec 11, 6:30-9:30 pm
Fee and Code: $165, XCOMO 292
NEW! Microsoft Excel for Accounting
Connect Excel to accounting tasks. Learn the ideal blend of accounting principle coverage and detailed, step-by-step instruction on using Microsoft Excel. This unique solution offers a sequential progression of material for both accounting and Excel topics, while simultaneously offering a variety of exercises that allow students to perfect the associated concepts and skills. Students are also taught how to apply their newly acquired Excel skills when solving real-world accounting problems. Workbook included. 30 hours. 85% attendance required.
Prerequisites: Knowledge of Excel Level 1 or equivalent experience and basic Accounting
Wed: Sept 27-Dec 6, 6:30-9:30 pm, no class Nov 22
Fee and Code: $529, XCOMO 298