Browse and Register for CPE Programs
If you have any questions, please call 973.720.3698 or email CertificateProgram@wpunj.eduCourse Cart
No courses registered.
Browse our online catalog to register.
Important Information
« Back to Programs
Excel - Advanced 10 Hours 04/07 - 04/14/18
Excel is the most widely used spreadsheet application in business today. Learn more advanced functions and how features in the Data Tab can help you with data analysis, financial analysis and making business decisions. Course topics include the following:
- Advanced Functions
- Logical Functions; IF, AND, OR
- Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
- Create Nested Functions
- Cross-worksheet calculations
- PivotTables
- Selections and Filtering
- Calculated field options
- Presenting Data Visually
- Charts
- SmartArt
- PivotCharts
- Slicer
- Timeline
- Working with External Data
- Importing Text
- Web Queries
- Linking Excel data to other Office documents
- Connecting to a Database
- Productivity and Customization
- Working with Templates
- Create and apply Macros
Instructor : Frank Asciutto
Dates : 04/07/18
to 04/14/18
Days : Sat
From : 9:00 am - 2:00pm
Fee : $ 225.00
Course Number : T115D
Class is unavailable at this time please call 973-720-2354 for more information or other course options