« Back to Programs

Excel Intermediate - Advanced Fast Track 7/9-7/18/2018

Excel is the most widely used spreadsheet application in business today.  Learn advanced functions and how features in the Data Tab can help you with data analysis, financial analysis and making business decisions. New to this course is the creation of Visual Dashboards that tie multiple Excel concepts together. Build dynamic and interactive Dashboards that show key metrics, historical data and key performance indicators.  Course topics include the following:

Course time frame:

• 10 hours total
• 2.5 hours/class for 4 classes
• Monday and Wednesday, 5:30pm - 8:00pm

Course topics include the following:

1. Advanced Functions

• Logical Functions; IF, AND, OR
• Lookup Functions: VLOOKUP, HLOOKUP
• Creating Nested Functions
• Cross-worksheet calculations

2. Tables and PivotTables

• Selections and Filtering
• Calculated field options
• Power Pivot and Managing a Data Model

3. Presenting Data Visually and Creating Dashboards

• Conditional Formatting
• Charts and PivotCharts
• SmartArt
• Slicer
• Timeline

4. Working with External Data

• Importing Text
• Web Queries
• Linking Excel data to other Office documents
• Connecting to a Database

5. Productivity and Customization

• Working with Templates
• Creating and applying Macros

6. Data Tools and Analysis

• Sorting, Filtering and custom sequences
• Performing calculations on filtered data
• Data Validation
• Goal Seek
• Scenario Manager

Instructor : Frank Asciutto
Dates : 07/09/18 to 07/18/18
Days : Mon,Weds
From : 5:30pm - 8:30pm
Fee : $ 299.00
Course Number : T035I

Class is unavailable at this time please call 973-720-2354 for more information or other course options

« Back to Programs