Advanced Excel for Business

Advanced Excel Classroom Training in NYC

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

This course is part of our Excel Bootcamp - enroll in our three-course package and save 15%.

  • Small classes
  • Computer provided
  • Book included
  • Free retake

Advanced Excel for Business

$209 7 Hours 185 Madison Avenue, NYC In-person classroom training

Register for a class

Nov 20 10am–5pm
Nov 27–28 6–9pm
Dec 6 10am–5pm
Dec 9 10am–5pm
Dec 21 10am–5pm
Dec 26–27 6–9pm
Jan 6 10am–5pm
Jan 11 10am–5pm
Jan 21–22 6–9pm
Jan 23 10am–5pm
Feb 2 10am–5pm
Feb 4 10am–5pm
Feb 14 10am–5pm
Feb 20–21 6–9pm
Feb 27 10am–5pm
Mar 3 10am–5pm
Mar 11 10am–5pm
Mar 18–19 6–9pm
Mar 21 10am–5pm
Mar 30 10am–5pm
Show more dates

Corporate training available

Call 212-658-1918 or email us

What You'll Learn

  • What-if Analysis: Goal Seek & Data Tables
  • Advanced cell locking
  • Create more flexible lookup functions with INDEX-MATCH
  • Advanced Pivot Table techniques
  • Record relative and absolute macros
  • Advanced nested functions
  • Work without a mouse using Hot Keys

Full Course Syllabus

Download PDF Outline

Cell Management

Advanced Cell Locking

  • Create powerful formulas by locking either the column or the row

Hot Keys

  • Transform the ribbon into a visual listing of pre-assigned shortcuts

Windows

  • Techniques and keyboard shortcuts to allow editing of active windows

Cell Auditing

  • Observe the relationship between formulas and cells

Special Formatting

Date functions

  • Calculate dates with a variety of functions

Conditional Formatting-Formulas

  • Create custom rules for Conditional Formatting with formulas

Advanced Functions

Nested IF statements

  • Nested "IF" statements allow for more than just two possibilities in a single cell

IF statements with AND/OR

  • Expand the functionality of the IF function by adding an AND / OR criteria

What If Analysis

Goal Seek

  • Find the desired result by adjusting an input value

Data Tables

  • Data Tables show the range of effects of one or two different variables on a formula

Advanced Analytical Tools

Data Consolidation

  • Summarize data from separate ranges and consolidate into a specified output range

Conditional SumProduct

  • Use SumProduct with conditions to exclude data that does not meet certain criteria

Pivot Table-Calculations

  • Create calculated rows or columns in a Pivot Table that go beyond the source data

Pivot Charts

  • Create dynamic, graphical representations of Pivot Table data

Advanced Database Functions

MATCH function

  • Return the relative position (column or row number) of a lookup value

VLOOKUP-MATCH

  • Create a more accurate VLookUp by enhancing the determination of the Column Index number

INDEX-MATCH

  • Efficiently return a value or reference from a cell at the intersection of the row and column

INDEX-Double MATCH

  • Use a second Match function to create a powerful, two-way lookup tool

Introduction to Macros

Recording Macros

  • Record Macros that involve formatting and calculations

Relative Macros

  • Record relative reference macros for ad-hoc reporting

End of Class Project

Project

  • End of class project to review key concepts from the class