Excel: Introduction, Intermediate, and Advanced

 

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