close
You are not logged in
close
This Month Specials
 

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel for Business Level III - Advanced

$209

SessionPriceSeatsInstructorLocation
Mar 1: 10:00am–5:00pm$2096Michael M.185 Madison Avenue, NYC
Mar 10: 10:00am–5:00pm$2099Michael M.185 Madison Avenue, NYC
Mar 16: 10:00am–5:00pm$2097Garfield S.185 Madison Avenue, NYC
Mar 21, Mar 22: 6:00pm–9:00pm$20910Garfield S.185 Madison Avenue, NYC
Mar 28: 10:00am–5:00pm$2099Garfield S.185 Madison Avenue, NYC
Apr 6: 10:00am–5:00pm$2099TBD185 Madison Avenue, NYC
Apr 7: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 16, Apr 17: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Apr 18: 10:00am–5:00pm$2099TBD185 Madison Avenue, NYC
May 1: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 5: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 14: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 14, May 15: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
May 24: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jun 8: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jun 10: 10:30am–5:30pm$20910TBD185 Madison Avenue, NYC
Jun 13, Jun 14: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Jun 20: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 2: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 7: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Show more

CALL 212.658.1918 OR EMAIL US

Excel for Business Level III - Advanced

Excel 2010 Training Class Logo

Excel for Business Level III - Advanced is the last of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level II or already have a strong working knowledge of Excel and would like to take their skills and efficiency to an advanced level. By the end of this course, you will feel confident using advanced formatting techniques, multi-input and conditional functions, and recording basic macros. Additionally, you will gain experience will advanced features such as Goal Seek, Data Tables, and Pivot Charts.

Call 212.658.1918 or Email us

Class Perks

 
  • Practical and hands-on training classes
  • Proprietary curriculum refined by industry experts
  • Interactive courses taught by engaging instructors
  • Revolutionary video suite with premium content
  • Personalized attention in small class sizes

Materials

  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

Course Outline

Cell Management  
1) Advanced Cell Locking Create powerful formulas by locking either the column or the row
2) Cell Auditing Observe the relationship between formulas and cells
Special Formatting  
3) Custom Number Formats Number formats can be customized to meet specific requirements for values, dates, and times
4) Text function Embed formatted numbers inside text
5) Date functions Calculate dates with a variety of functions
6) Conditional Formatting-Formulas Create custom rules for Conditional Formatting with formulas
Advanced Functions  
7) Nested If statements Nested "IF" statements allow for more than just two possibilities in a single cell
8) If statements with And/Or Expand the functionality of the IF function by adding an "AND" or an "OR" criteria into the logical test
9) Small & Large functions Identify the "n" value in a range
What If Analysis  
10) Goal Seek When the desired result of a formula is known, Excel can determine the input value the formula needs to match that result
11) Data Tables Data Tables show the range of effects of one or two different variables on a formula
Advanced Analytical Tools  
12) Data Consolidation Summarize data from separate ranges and consolidate into a specified output range
13) Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria
14) Pivot Table-Calculations Create calculated rows or columns in a Pivot Table that go beyond the source data
15) Pivot Charts Pivot Charts are dynamic, graphical representations of Pivot Table data that work in tandem with Pivot Tables
Advanced Database Functions  
16) Match function Return the relative position (column or row number) of a lookup value
17) VLookUp Match Create a more accurate VLookUp by enhancing the determination of the Column Index number
18) Index-Match Efficiently returns a value or reference from a cell at the intersecton of the row and column
19) Index-Double Match Use a second Match function to create a powerful, two-way lookup tool
Introduction to Macros  
20) Recording Macros Record Macros that involve formatting and calculations
21) Relative Macros Record relative reference macros for ad hoc reporting

© NYIM Training 2018

Client Testimonials
Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend! 11/26- Rebecca H. attended Excel for Business Level III - Advanced
Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business. 9/27- Alexandria A. attended Excel for Business Level III - Advanced