Browse and Register for CPE Programs

« Back to Programs

Excel Intermediate - Fast Track 10 hour 9/30/2019 - 10/09/2019

Learn more advanced Excel functions and how the Function Library and Data Tab can help you with data analysis, financial analysis and making business decisions.  Course topics include the following:

  1. Advanced Functions
  • Logical Functions; IF, AND, OR
  • Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
  • Create Nested Functions
  • Cross-worksheet calculations
  1. Tables and PivotTables
  • Selections and Filtering
  1. Presenting Data Visually
  • Charts
  • SmartArt
  • Sparklines
  • Slicer
  1. Working with External Data
  • Importing Text
  • Web Queries
  • Linking Excel data to other Office documents
  • Connecting to a Database
  1. Productivity and Customization
  • Data Validation
  • Creating and applying Macros

Instructor : Frank Asciutto
Dates : 09/30/19 to 10/09/19
Days : Mon,Weds
From : 5:30pm - 8:00pm
Fee : $ 299.00
Course Number : T035M

Class is full at this time please call 973-720-2354 to be placed on a waiting list


« Back to Programs