Sun Oct 27, 6:00 PM - Sun Nov 24, 9:00 PM
Hudson County Community College
4800 Kennedy Blvd., Union City, NJ 07087
Community: Union City
Description
Intermediate Word & Excel Course Many people use Word & Excel at home or at work, but many are not utilizing all its benefits. This quick course is designed to help you maximize productivity by learning some essential, intermediate Excel functions. Students will learn
Event Details
Intermediate Word & Excel Course
Many people use Word & Excel at home or at work, but many are not utilizing all its benefits. This quick course is designed to help you maximize productivity by learning some essential, intermediate Excel functions. Students will learn how to create basic formulas, tables, group, sort, and filter data, use VLOOKUP, and create pivot tables.
This workshop will review:
Sorting & Filtering Data
Introduction to Formula and Functions
Perform common calculations
Checking for Errors
Managing Multiple Sheet Worksheets
3D References in Formulas
Format Painter and Quick Styles
Using What-If analysis and assumptions in a worksheet
Date Functions and Custom Formats
Naming Cells and Ranges
Creating formulas using criteria IF functions
Using conditional formatting
Function Syntax
Using Goal Seek and Solver
This Class is 3 Sessions Long!
Sundays : October 27th - November 24th, 2019
6 p.m. – 9 p.m.
Price: $185
Location: Hudson County Community College - North Hudson Campus
4800 Kennedy Blvd. Union City, NJ 07087
4th Fl., Room: N414
For more information, please contact Djadji Sylla-Samassa at dsylla@hccc.edu or 201-360-4234/201-360-5327.
Many people use Word & Excel at home or at work, but many are not utilizing all its benefits. This quick course is designed to help you maximize productivity by learning some essential, intermediate Excel functions. Students will learn how to create basic formulas, tables, group, sort, and filter data, use VLOOKUP, and create pivot tables.
This workshop will review:
Sorting & Filtering Data
Introduction to Formula and Functions
Perform common calculations
Checking for Errors
Managing Multiple Sheet Worksheets
3D References in Formulas
Format Painter and Quick Styles
Using What-If analysis and assumptions in a worksheet
Date Functions and Custom Formats
Naming Cells and Ranges
Creating formulas using criteria IF functions
Using conditional formatting
Function Syntax
Using Goal Seek and Solver
This Class is 3 Sessions Long!
Sundays : October 27th - November 24th, 2019
6 p.m. – 9 p.m.
Price: $185
Location: Hudson County Community College - North Hudson Campus
4800 Kennedy Blvd. Union City, NJ 07087
4th Fl., Room: N414
For more information, please contact Djadji Sylla-Samassa at dsylla@hccc.edu or 201-360-4234/201-360-5327.