About This Class
Introduction to Excel
This class will introduce students to MS Excel basics including creating spreadsheets,
formulas, functions, text, formatting and graphics. Students will be able to perform
basic level excel skills such as modifying an existing worksheet, building worksheets,
and copying and moving cells.
Intermediate Excel
This class will reinforce the elements learned in the introductory class and expand
upon that base to include more complex but necessary activities such as functions,
charts, linking worksheets, adding pictures and more.
Advanced Excel
Students will further build on the skills acquired in the Microsoft Excel Basic and
Intermediate courses. They will work with advanced functions and formulas, as well
as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will
learn about data validation, and will use advanced data filtering.
Takeaways
Upon completion of the training, students/participants will be able to:
Introduction
- Use the Excel menu system and Excel toolbars
- Use Excel task panes
- Display help information
- Modify an existing worksheet
- Move the cell pointer, change data in a worksheet
- Reverse an edit operation, save a workbook
- Add data to a worksheet
- Enter a formula into a worksheet
- Adjust column width in a worksheet
- Adjust row height in a worksheet
- Build a new worksheet
- Edit a worksheet
- Format a worksheet
- Change the page setup for a worksheet
- Insert a manual page break into a worksheet/including print titles in a printout
- Use Basic Excel functions, i.e. Sum, Average and Count
Intermediate
- Find a specific entry in a worksheet
- Use options in the paste special dialog box
- Use alignment options in the format cells dialog box
- Use and understand absolute cell references
- Use and understand logical functions, i.e. the IF function, nesting IF functions
- Use and understand financial functions, i.e. the PMT function
- Use and understand date/time functions, i.e. using the DATE function, using the NOW
function
- Create a chart
- Modify and enhance a chart
- Work with a list, inc. sorting the records of a list, specifying a range of values
as criteria for a filter operation
- Link worksheets within a workbook
- Split the workbook window into panes, freezing window panes
- Hide rows and columns of a worksheet
- Add pictures and diagrams to worksheets
- Use an Excel template to create a workbook
- Insert a hyperlink into a worksheet, using the research feature
- Insert comments into a worksheet
Advanced
- Apply advanced chart formatting options, and create more complex charts
- Work with PivotTables and PivotCharts
- Export and import data
- Query external databases
- Learn about the analytical features of Excel, such as Goal Seek, and how to create
scenarios
- Run and record macros, and explore VBA code
Preparation
- Must be able to speak and understand English <link TBD>
- Pre and post assessment for all classes and students taking part in this program.
- Assessment scores from the TABE, Best Literacy, Customer Service Inventory and the
NJCCC PC Skills assessment instruments will be compiled.
- Understand, read and write English language
- Have basic computer knowledge
- Basic knowledge of video conference platforms
- Internet connection
- Laptop, Personal Computer, notebook
Contact Information
School of Continuing Education and Workforce Development
161 Newkirk Street, Suite E504
Jersey City, NJ 07306
(201) 360-5327