Microsoft Excel Courses


Microsoft Excel Beginner

Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision-makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish and in much less time. This course aims to provide you with a foundation for Excel knowledge and skills, which you can eventually build upon to become an expert in data manipulation. This course is intended for students who wish to gain a foundational understanding of Microsoft Office Excel necessary to create and work with electronic spreadsheets.

Upon completing this course, you will be able to create and develop Excel worksheets and workbooks to work with and analyze the data that is critical to your organization's success.

The course will be using the textbook Microsoft Office Excel 2019: Part I (textbook sold separately), which includes data files to practice and assessments to reinforce the lessons at home. The book is moderately priced and can be purchased using the following link.
Microsoft Office Excel 2019: Part 1

Prerequisites:
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment.

Topics covered:

  • Getting started with Excel
  • Performing calculations
  • Modifying a worksheet
  • Formatting a worksheet
  • Printing workbooks
  • Managing workbooks

Register Here

This live class will be held at our Jersey City Campus, and participants will receive an email with details on how to access the campus 48 to 72 hours before the start of class.

For more information and to register, please email amunizFREEHUDSONCOUNTYCOMMUNITYCOLLEGE.

 

Microsoft Excel Intermediate

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. You already know how to get Microsoft Office Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract information from your raw data. You need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

The course will be using the textbook Microsoft Office Excel 2019: Part II (sold separately), which includes data files to practice and assessments to reinforce the lessons at home. The book is moderately priced and can be purchased using the following link.
Microsoft Office Excel 2019: Part II

Upon successfully completing this course, you will be able to leverage the power of data analysis and presentation to make informed, intelligent organizational decisions.

Topics covered:

  • Working with functions
  • Working with lists
  • Analyzing data
  • Visualizing data with charts
  • Using PivotTables and PivotCharts

Register Here

This live class will be held at our Jersey City Campus, and participants will receive an email with details on how to access the campus 48 to 72 hours before the start of class.

For more information and to register, please email amunizFREEHUDSONCOUNTYCOMMUNITYCOLLEGE.

 

Microsoft Excel Advanced

This course builds upon the foundational and intermediate knowledge of Microsoft Office Excel to help you get the most of your Excel experience.

By now, you're already familiar with Microsoft Office Excel 2019, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are called upon to analyze and report on data frequently, collaborate with others to deliver actionable organizational intelligence and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered issues and challenges. You need to know how to get Excel to do more for you to focus on what's important: staying ahead of the competition. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

The course will be using the textbook Microsoft Office Excel 2019: Part III (sold separately), which includes data files to practice and assessments to reinforce the lessons at home. The book is moderately priced and can be purchased using the following link.
Microsoft Office Excel 2019: Part III

Course Objectives:

  • Working with Multiple Worksheets and Workbooks
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Using Lookup Functions and Formula Auditing
  • Forecasting Data
  • Creating Sparklines and Mapping Data

Register here

This live class will be held at our Jersey City Campus, and participants will receive an email with details on how to access the campus 48 to 72 hours before the start of class.

For more information and to register, please email amunizFREEHUDSONCOUNTYCOMMUNITYCOLLEGE.

 

Excel Tips and Tricks Workshop

Excel is a versatile program with many ways to slice and dice numbers and make the data work for you. Students will learn essential Excel functions in this workshop that can be useful as you work with the program daily. Some of the topics that will be covered include making AutoCorrect work for you, working with multiple sheets or workbooks, quickly replacing or adding text to multiple cells, protecting your workbook from unwanted access or accidental modification, and much more. The workshop is designed for users at any skill level, but a basic understanding of Excel is recommended for all attendees. Upon completing the workshop, you will have gained new skills that will make your time using the program a little easier and make you look like a guru with spreadsheets.

This live class will be held at our Jersey City Campus, and participants will receive an email with details on how to access the campus 48 to 72 hours before the start of class.

For more information and to register, please email amunizFREEHUDSONCOUNTYCOMMUNITYCOLLEGE.

 

Data Analysis and Visualization

The era of "big data" has exploded, which provides opportunities for organizations of all sorts to capture and store data. This can lead to an overwhelming amount of data, which creates a need for people who can quickly analyze large amounts of data. Analyzing this data to find issues, insights, and opportunities is critical for many roles. Individuals must be able to present and communicate their findings in visually compelling ways effectively.

Fortunately, Excel can connect to various data sources, perform data analysis, create diverse and robust data-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. It can help you organize, manipulate, and report on your data in the best way possible. Since tools are only as good as the person using them, it is essential to gain a solid understanding to maximize your effectiveness when analyzing data.

This course is designed for students who already have intermediate knowledge and skills in Excel and wish to perform robust and advanced data and statistical analysis with Microsoft Excel. Using PivotTables, Power Pivot, and Data Analysis ToolPak, you will gain a deeper insight into your data.

Course Objectives:

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.

Prerequisites:
This course is designed for students who already have intermediate knowledge and skills in Excel and wish to perform robust and advanced data and statistical analysis with Microsoft Excel. Using PivotTables, Power Pivot, and Data Analysis ToolPak, you will gain a deeper insight into your data.

Register Here

This live class will be held at our Jersey City Campus, and participants will receive an email with details on how to access the campus 48 to 72 hours before the start of class. For more information, please contact Alexis Muniz at amunizFREEHUDSONCOUNTYCOMMUNITYCOLLEGE or call (201) 360-4224.

 

 

Contact Information

Office of Continuing Education
161 Newkirk Street, Room E504
Jersey City, NJ 07306
(201) 360-4224
CEFREEHUDSONCOUNTYCOMMUNITYCOLLEGE