Details
The Career Center’s Advanced Excel training in New York City is a hands on, instructor-led class that will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. This classroom based live Excel class with a live instructor will cover topics such as Using Multiple Worksheet and Workbooks, VLOOKUPS, HLOOKUPS, Sharing and Protecting Worksheets and Workbooks, Data Validation, Sparklines, Data Mapping and Forecasting data. The Career Center’s Classroom Excel Training Course is conducted at our facility in Midtown Manhattan NYC. We also provide Onsite Excel Training Courses, Offsite Excel Training Classes or 1:1 Private Excel Lessons.
Upon successful completion of this Microsoft Excel 2016 training, students will be able to:
- Work with multiple worksheets and workbooks
- Use Lookup functions and formula auditing
- Share and protect workbooks
- Automate workbook functionality
- Create sparklines and map data
- Forecast data
Prerequisites:
Students are recommended to take the following course or possess equivalent knowledge:
- Microsoft Excel Level 1 2016
- Microsoft Excel Level 2 2016
Outline
Lesson 1: Working with Multiple Worksheets and Workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
Lesson 2: Using Lookup Functions and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
Lesson 3: Sharing and Protecting Workbooks
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
Lesson 5: Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
- Topic B: Map Data
Lesson 6: Forecasting Data
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecasting Data Trends
The Career Center is a full-service training provider that offers training services in a wide array of courses, including applications such as Microsoft Office, the Adobe Creative Suite, SQL, QuickBooks and AutoCAD.
As a Microsoft Silver Learning Partner we also offer all of the Microsoft Official Courses (MOC) and proudly accept Microsoft Software Assurance Training Vouchers.
The Career Center offers computer courses and hands-on training that helps people of all levels, from beginners to advanced users, increase their computer knowledge & efficiency. Conveniently located on the corner of 34th Street & Madison Avenue, The Career Center offers over 100 public classes in popular softwares.
The Career Center also offers other training solutions including:
- Onsite Training
- Private Corporate Classes
- Private Computer Tutoring
- Lab Rentals
For more information about individual or corporate training, please contact us at your convenience at (212) 684-5151 or [email protected]