Excel and Data Analysis


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 Required: Knowledge of Windows and Word.

Sec 1: Tues & Thurs, Sep 17-Sep 24, 6:30-9:30 pm, Freehold Campus
Sec 2: Sat, Oct 26-Nov 9, 9 am-noon, Lincroft
Fee and Code: $175, 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 Required: Knowledge of Excel Level 1 or equivalent experience.

Tue & Thu, Jul 23-Jul 30, 6:30 pm – 9:30 pm, Lincroft
Sat, Nov 23-Dec 14, 9 am-noon (no class Nov 30), Lincroft

Fee and Code: $175, XCOMO 291

Excel 2016 Level 3

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, May 7-16, 6:30-9:30 pm Freehold Campus
Fee and Code: $229, XCOMO 292

Excel Certification Prep

Get a thorough knowledge and understanding of the most relevant features and uses of Excel 2016. Start with an introduction to worksheets and move to using advanced functions and calculations. Students will be engaged with hands on learning as they apply learned concepts. Time will be spent on practice exams in preparation for the MOS Excel exam which will be on the last night of class. Includes workbook, practice exam and exam fee.

Prerequisites Required: Microsoft Windows and Word Level 1.

Mon & Wed, Oct 14-Jan 15, 2020, 6:30-9:30 pm (no class Nov 27, Dec 23-Jan 1), Lincroft
Fee and Code: $999, XCOMT 038

Figure above created from Tableau Public data

Click here for an interactive version of the figure above.

Data Visualization With Tableau®

Tableau® is a data analytics tool used to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. This course is designed for professionals who use desktop or web-based data-management tools such as Excel to perform numerical or general data analysis. Learn to use Tableau® to capture and report on data and provide data visualizations in reports.
This era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Tableau® software is designed for this purpose. You will use Tableau®’s data connection capabilities and visualization features to go far beyond those that can be found in spreadsheets, allowing you to create interactive worksheets, dashboards, and compelling storytelling that bring data to life and turn data into thoughtful action.
In class, students will be working with Tableau® Public datasets. Workbook included. 15 hours

Prerequisites Required: Knowledge of Excel Level 2 or equivalent experience.
Note: Students have to bring their own electronic devices to Holmdel class in order to use the software.

Sec 1: Tues & Wed, Oct 29-Nov 6, 1-4:45 pm, Bell Works Holmdel Library Public Meeting Room
Sec 2: Tues & Thurs, Dec 3-Dec 17, 6:30-9:30 pm, Lincroft
Fee and Code: $525, XCOMO 308