Training Course:Advanced Excel 2007School/Trainer:NEW YORK INTERACTIVE MEDIA, Inc.
New York City, New York, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Lesson 1- Quick review
Formula fundamentals
Database fundamentals
Lesson 2
Creating reusable drop down lists
Naming ranges
Validation
Lesson 3
Extracting database information quickly
Vlookups
Hlookups
Match formula- returning the position of a cell
Index Formula- returning values at the intersection of a row and column.
Combining the VLookup and Match formulas to create a modifiable database lookup.
Combining and nesting the Index and Match
Lesson 4 - Commonly used functions
Commenting cells
Protecting documents
Saving workspace and multiple worksheets
Saving documents as templates
Sending spreadsheets for review
Copying and pasting only unique records from a database list
Lesson 5
If statement
Using the If statement to sum and analyze
Sum If
Tracing Cell Precedents
Today and Now functions to auto insert today’s date and time upon opening a document
Numbering databases that will be sorted with the ROWS() function
Rounding numbers and currency up and down
Goal Seek
Lesson 6 - Pivot Tables
Analyzing raw data with Pivot Tables
Raw data dumps from external applications or databases
Grouping by categories, months, days, quarters, etc
Lesson 7
Pivot Charts
Use the same data
Lesson 8- Introduction to Macros
Recording and Playing Macros
Recording a Macro to prepare data from a data dump for use in Pivot Table
Lesson 9
Where to find answers to more complex Excel problems for free
...''
Please go to the school's official website for training price and schedule:
http://www.newyorkinteractivemedia.com/
Phone:718.795.3608
School Address:
Manhattan Location (Union Square):
1 Union Square, Suite 903
New York, NY
10003
Jobs & Resumes: New York City
Houses & Roommates: New York City
Travel Agencies: New York City
Search other schools for Advanced Excel 2007 training resources.
Other training courses offered by NEW YORK INTERACTIVE MEDIA, Inc.:
Excel 2007
Excel Power Programming with VBA
PowerPoint 2007
Advanced PowerPoint for Business
Dreamweaver Essentials
Flash ActionScript 3.0
Advanced InDesign CS3
InDesign CS3
Photoshop CS3
Advanced Photoshop CS3
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free! |
|
| 
