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 II - Intermediate (EXPRESS)

$159

    Show more

    CALL 212.658.1918 OR EMAIL US

    Excel for Business Level II - Intermediate (EXPRESS)

    Intermediate Excel for Business Level II is the second 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 I or already have a basic working knowledge of Excel and would like to improve efficiency and expand into Excel's more complex functions and data management features. By the end of this course, you will feel confident dynamically extracting data from large databases, using advanced functions such as Vlookup and quickly organizing and analyzing large amounts of raw data with Pivot Tables. The skills acquired in this course are what many employers have come to expect and look for in new applicants and existing employees.

    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

    Worksheet Management  
    Navigation Keyboard shortcuts that facilitate quick and easy navigation around the worksheet
    Paste Special Use Paste Special to apply formats, as well as perform calculations on selected cells
    Text  
    Splitting Text Use Text to Columns to split text into multiple cells
    Joining Text Join text from separate cells
    Database Management  
    Named Ranges Assign a name to a range of cells to to reference in calculations
    Data Validation Create a dropdown menu to make data entry quicker and more efficient
    Sort & Filter Use Sort & Filter to find and organize data in large databases
    Remove Duplicates Use Remove Duplicates to eliminate duplicate data
    Database Functions  
    Vlookup Find information in one column and return information from another column
    Logical Functions  
    And & Or functions Use AND/OR functions to determine whether cell(s) meet either or both criteria
    IF statement function Use IF statements to return output based on the contents of another cell
    Statistical Functions  
    Countifs function Use Countifs function to count cells based on one or more conditions
    Sumifs function Use Sumifs function to sum cells based on one or more conditions
    Pivot Tables  
    Pivot Tables Create Pivot Tables to quickly summarize large databases

     

    © NYIM Training 2017

     

     

    Client Testimonials