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 I

Excel for Business Level I is the first of a three part series that aims to tackle the most common and practical uses of Excel in business. This is the perfect course for those who are either new to Excel or would like to improve their understanding and efficiency of its applications in business. By the end of this course, you will feel confident navigating through Excel worksheets and working with formulas, databases, charts, formatting, shortcuts and printing. The skills you take away from this course will prove crucial to building a strong resume and boosting your job performance - you will truly be amazed at how much you will benefit from this course!

 

 

Call 212.658.1918 or Email us

 

Class Perks

 

* The most practical and hands-on training to boost productivity and skill

* State-of-the-art curriculums refined by industry experts over nearly two decades

* Interactive, personable, and engaging instructors with several years of in-field and training experience

* Revolutionary video course with several hours of premium content

* Free Retakes for Life!®

* Small classroom sizes for personalized attention

* Custom in-depth manuals and mousepads with key shortcuts

* Convenient location and comfortable learning environment

 

Example Video of what is Covered


 

Materials

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

 

Course Outline

 

Introduction  
1) Introduction What is Excel and what can it be used for?
2) Interface Provides a brief description of the user interface for Microsoft Excel
3) Data Entry Examines and describes multiple means of entering data
Formulas  
4) Autofill Explores Excel's amazing ability to predict and extrapolate paterns
5) Calculations Perform mathematical expressions and review the Order of Operations rule
6) AutoSum Functions Review the five key functions: Sum, Average, Max, Min, and Count Numbers
7) Text Functions Introduces functions used to modify text in Excel
8) Multi-Input Functions More advanced functions that require more than one input
9) Absolute Cell References Changing a cell reference into a constant, which is necessary in certain calculations
Formatting  
10) Formatting The addition of effects to an excel document to provide visual instruction
11) Format Painter The ability to copy format from one cell/range of cells to another cell/range of cells
12) Conditional Format Create rules that govern specific cell ranges and apply a predetermined format when those rules are triggered
Charts & Tables  
13) Line Chart Create a Line chart and Spark lines to visually examine data
14) Column Chart Create a Column chart to visually examine data
15) Pie Chart Create a Pie chart to visually examine data
16) Tables Explores the special functionality created when data is converted to a Table
Workbook Management  
17) Printing Rules and strategies to make printing easy
18) Worksheets Insert, move, copy and delete worksheets
19) Rows & Columns Insert, hide, group and freeze rows and columns
20) Save and Close Save, close and email your finished product
End of Class Project  
21) Project End of class project to review key concepts from the class

 

© NYIM Training 2017

 

 

Client Testimonials
Excel for Business Level 1: Garfield was a great teacher. He was thorough on each topic. The class moved at a good pace and a lot was covered in the day. I will return for the second class. 6/19/2017- Mary Kate M. attended Excel for Business Level I