close
You are not logged in
close
This Month Specials
 

Special Promotion

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

PowerPivot Fundamentals $199 (Normally $299)

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

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Fast as Hell at Excel

$209

SessionPriceSeatsLocation
May 9, May 10: 6:00pm–9:00pm$2099185 Madison Avenue, NYC
May 29: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 11, Jun 12: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Jun 15: 10:00am–5:00pm$20910185 Madison Avenue, NYC

Call 212.658.1918 or email us

Fast as Hell at Excel

Intermediate Excel classes focused on time-saving tricks & techniques

Fast as Hell at Excel® is NYIM's revolutionary course that will double your productivity and efficiency in Excel. The course reviews essential keyboard shortcuts, including navigation, formatting, calculations, and hot keys. You'll also learn some specialized time-saving (and sometimes life-saving) techniques using applications of Paste Special, Go To Special, Find & Replace, and Macros. We'll review database management techniques, advanced functions, and Pivot Table with an emphasis on how to speed up daily tasks. By the end of this course you'll have the tools, tricks and techniques to breeze through your workload, impressing colleagues and cutting down hours of unnecessary work.

Prerequisite: Basic proficiency in Excel. This is an intermediate-level course with a bent towards shortcuts and time-saving techniques. PC only.

The Best Excel Course for Speed & Tricks in NYC

  • Practical and hands-on training focused on real-world applications of Excel
  • Engaging and interactive instructors
  • Revolutionary video suite with several hours of premium content
  • Proprietary course manual and shortcut sheets
  • Small class sizes for personalized attention

Course Outline

Fast as Hell PDF Outline

Keyboard Shortcuts
1) Navigation Shortcuts that enable quick cursor movement and cell selection
2) Formatting Shortcuts that facilitate quick formatting
3) Calculations Shortcuts that enable faster input of formulas and functions
4) Hot Keys Transform the ribbon into a visual listing of pre-assigned shortcuts
5) Quick Access Toolbar Access customized commands on the Quick Access Toolbar
6) Insert Screenshots Shortcut to directly insert a screenshot
7) Repeat Command Shortcut key to repeat commands
8) Workbook Management Shortcuts pertaining to general Excel operations
9) Worksheets Shortcuts to allow editing of active windows
Database Management
10) Splitting Text Use Text to Columns to split text into multiple cells
11) Joining Text Join text from separate cells
12) Data Validation Create a dropdown menu to make data entry quicker and more efficient
13) Sort & Filter Use Sort & Filter to find and organize data in large databases
14) Remove Duplicates Use Remove Duplicates to eliminate duplicate data
Advanced Functions
15) Advanced Cell Locking Anchor cells to quickly copy and paste formulas
16) VLOOKUP Quickly retrieve data from a table
17) COUNTIFS Count cells based on one or more conditions
18) SUMIFS Sum cells based on one or more conditions
Pivot Tables
19) Table review Use a Table as the source data for a Pivot table, due to its special functionality
20) Pivot Tables Create Pivot Tables to quickly summarize large databases
Specialized Time-Saving Techniques
21) Paste Special Use Paste Special for various time-saving techniques
22) Go To Special Use Go To Special to perform several time-saving tricks
23) Find & Replace Use Find & Replace to expedite certain processes
24) Working Across Sheets Perform calculations and formatting across worksheets
25) Recording Macros Record macros to automate repetitive work
Cumulative Project
26) End of Class Exercise End of class project to review key concepts from the class

See More Excel Classes at NYIM

All Excel Classes Basic Intermediate Advanced VBA Certification

© NYIM Training 2018

Client Testimonials
I had a great experience with NYIM. I took "Fast as Hell Excel" course and really enjoyed it. It was very informative and Joe the instructor knew how to deliver the course in a fun way. I am thinking about taking other Excel classes with NYIM and will recommend it to my friends. 5.0 star rating 3/22/2016- Iryna D. attended Fast as Hell at Excel