Introduction to Excel Training
Learn Excel fundamentals in a fast paced intensive one day boot camp.
Formulas include Vlookup and Xlookup, SumIfs, and PivotTables.
Database topics include sort and filter.
Courses are hands-on and include practice exercises.
Includes a printed 85 page illustrated manual.
The only course that offers a library of over 160 self assessment tests, 45 minutes of Vlookup and 45 minutes of Pivot Tables!
The only course that includes recorded videos for unlimited review.
Training Schedule
Weekdays:
January 9th 9am-5pm
January 22nd-23rd 9am-1pm
Weekends:
January 11th-12th 1pm-5pm
Introduction To Excel Outline
Start Excel
Open Excel Workbooks
Worksheets
Cells
Ribbon
Keyboard
Mouse
Zoom
Navigate cells
Keyboard navigation techniques
Mouse navigation techniques
Navigate sheets
Keyboard navigation techniques
Mouse navigation techniques
Goto
Templates
Blank
Add sheets
Name sheets
Move sheets
Copy sheets
Tab color
Freeze panes
Table
Insert/delete rows/columns
Data entry techniques
Cut, Copy, Paste
Shortcuts
Autofill
Undo
Addition, subtraction, multiplication, division
PEMDAS and the order of operations
Autosum
Average
Absolute references
Today Function
Payment Function
SumIfs
Vlookup
PivotTables
Column widths and row heights
Font
Name
Size
Bold
Borders
Cell fill color
Font color
Alignment
Horizontal and vertical
Orientation and rotation
Wrap text
Merge and center
Number formatting
Currency and accounting
Percentages
Decimals
Dates
Zip codes
Tables
Views
Orientation
Rows to repeat
Headers and footers
Export a PDF
Create charts
Column charts
Pie charts
Apply chart styles
Change colors
Format axis
Add data labels
Move chart
Switch row and column
Edit data series
Where to get help 24/7
Keyboard shortcuts
Paste special
Excel cursor shapes
Frequently Asked Questions
Most classes typically start at either 9am or 1pm
We provide a Windows computer.
Yes, upon completion you will receive an attractive gold foil certificate.
The ability to use a mouse and a keyboard.
31 West 34th Street. Near Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.
The entrance may be challenging to spot. We are between Steve Madden and Zara.
Introduction To Excel Reviews On Yelp
https://www.yelp.com/biz/excel-class-new-york#reviews
Read Sandy N.‘s review of Excel Class on Yelp
Read Mary H.‘s review of Excel Class on Yelp