People With Excel Skills Earn More Money!

excel_2013Looking to learn Excel or brush up on your existing skills?
Our basic and advanced Excel classes are on sale for $199 (normally $299)!

The price includes the following:
-One full day training in the subject area (7 hrs with a 1 hr lunch included) or 2 or evenings (3 hrs each session)
-Free Retakes for Life!”™ of that version
-Any Upgraded version of the class taken offered at 75% off, with free retakes applied to that class/version
-Manual to keep w/ access to student files
-Free forum support for after class
-Mousepad withshortcuts to keep
-Hands on, project-based learning
-Small Classes of 4 to 9 people
-Fast NEW computers!
-Comfortable chairs, convenient location
-Patient, Fun, Experienced Trainers
-We provide coffee, tea, water and chocolate

Visit our website at www.training-nyc.com where you can view all our classes and purchase a seat 24/7.

We also offer private, one-on-one training with our Excel experts.

To arrange a private session, please call 212-658-1918 or email karyn@training-nyc.com

NYIM Training — ‘the most practical computer training in NYC”

Excel for Mac Level 1 class ON SALE for $149

Excel for Mac

Excel for Mac Level 1 class on Saturday, September 3rd, 2016 is on sale for $149! (reduced from $199).

We offer the most practical Excel group classes and private training in NYC.

Excel for Mac group class concentrates on the most common topics we see NYC businesses using on a daily basis. By the end of the Excel training course, you will feel confident managing Excel lists, databases, charts, common formulas, formatting, shortcuts and printing. This Excel class is perfect for those who are new to Excel, have been using Excel without any training or need to gain a solid grasp of how to use it effectively. We currently use Excel 2011 for Mac.
Visit us at www.training-nyc.com or call 212-658-1918 to enroll while the price is hot!

Excel for Business Level 1 class ON SALE $149

Our Excel for Business Level 1 class on August 27, 2016 is on sale for $149! (reduced from $199).

We offer the most practical Excel group classes and private training in NYC.

The Excel for Business group class concentrates on the most common tasks that we see NYC businesses using on a daily basis.

Visit us at www.training-nyc.com or call 212-658-1918 to enroll while the price is hot!

Entering Text and Numbers

Entering Text and Numbers

Excel

Entering Text and Numbers

Source: http://www.baycongroup.com/excel2003/excel01.htm

Modeling tiles in a room using Excel Conditional Formatting

Modeling tiles in a room using Excel Conditional Formatting

excel_2013

Modeling tiles in a room using Excel Conditional Formatting

Source: http://chandoo.org/wp/2014/04/22/modeling-tiles-in-a-room-using-excel-conditional-formatting/

 

 

Protecting Cells, Sheets, Workbooks, And Files

Protecting Cells, Sheets, Workbooks, And Files

fastashellwithexcelpsd

Protecting Cells, Sheets, Workbooks, And Files

Source: http://spreadsheetpage.com/index.php/tip/protecting_cells_sheets_workbooks_and_files/

Creating burndown charts for Project using Power Pivot and Power Query

Creating burndown charts for Project using Power Pivot and Power Query

excel_2013

Creating burndown charts for Project using Power Pivot and Power Query

Source: http://blogs.office.com/2014/03/24/creating-burndown-charts-for-project-using-power-pivot-and-power-query/

 

We’ve updated Excel Online: What’s new in April 2014

We’ve updated Excel Online: What’s new in April 2014

Excel

We’ve updated Excel Online: What’s new in April 2014

Source: http://blogs.office.com/2014/04/14/weve-updated-excel-online-whats-new-in-april-2014/

 

Autosum Trick in Multiple Cells (Excel 2010 Training)

1) Press the CTRL and/or Shift keys to select all of the cells where you want to add AutoSum formulas;

2) Click the AutoSum button (or press ALT+=)

Excel Formula to Create Google Directions API String (Free Excel Workbook 2007-2010)

Excel Formula to create Google Directions API String

(Free Excel 2007-2010 Spreadsheet)

Download: Google Directions Formula String.xslx

 

If this saved you days of work or you’ll use it in a business environment please consider donating $10
=HYPERLINK(IF(LEN(A6)-LEN(SUBSTITUTE(A6,” “,””))+1=3,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6),IF(LEN(A6)-LEN(SUBSTITUTE(A6,” “,””))+1=3,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6))