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)

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