close
You are not logged in
close
This Month Specials
 

Special Promotion

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

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$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)

(book before 12/31/16)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

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

Excel for Business Level III - Advanced (EXPRESS)

$159

    Show more

    CALL 212.658.1918 OR EMAIL US

    Excel for Business Level III - Advanced (EXPRESS)

    Advanced Excel for Business Level III 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 Excel features and plug-ins such as scenario management and solver. Your peers, colleagues and employers will be impressed with your ability to tackle complex problems in Excel dynamically and efficiently after you take this course.

    Express Classes

    Too busy to take a full day class but want to advance your Excel skillset? Try NYIM's Express Classes. Our Express Classes are designed to complete the course material in only three hours by moving at an accelerated pace and focusing on the essentials. You'll still receive full access to NYIM's premier video suite, which recaps each topic in the full length course. The Express class is perfect for those who work on tight schedules, learn quickly, want a brief refresher course, or wants to self-study part of the course using our revolutionary video suite. Free Retakes for Life still applies, and you can retake the full 6-hour course by paying the $50 price differential. 

     

    Call 212.658.1918 or Email us

     

    Materials

    • Custom Manual
    • Lifetime access to NYIM's revolutionary video suite
    • Shortcut sheets
    • After class resources

     

    Course Outline

     

    Data Consolidation  
    Data Consolidation Summarize data from separate ranges and consolidate into a specified output range
    Special Formatting  
    Custom Formats Number, Date and Time formats can be customized to meet specific requirements
    Date functions Calculate dates with a variety of functions
    Cell Management  
    Advanced Cell Locking Create powerful formulas by locking either the column or the row
    Cell Auditing Observe the relationship between formulas and cells
    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 an "OR" criteria into the logical test
    What If Analysis  
    Goal Seek Determine the input value the formula needs to match a certain result
    Data Table Data Tables show the range of effects of one or two different variables on a formula
    Advanced Analytical Tools  
    Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria
    Advanced Database Functions  
    Match Return the relative position (column or row number) of a lookup value
    Index-Match Efficiently returns a value or reference from a cell at the intersecton 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 Reference Macros Record relative reference macros for ad hoc reporting

     

    © NYIM Training 2017

     

     

    Client Testimonials