|
Provided by: New York Interactive Media Advanced Excel 2003 for BusinessExcel |
 |
Class Type:
* Can retake the class, for free, up to 3 months.
* Free forum support for 1 year after class
* Hands on, goal based
* Small Classes of 4 to 9 people
* Fast computers
* Comfortable chairs, convenient location
* Patient, Fun, Experienced Trainer
When you are finished with this class you will be able to:
* Extract data from large databases based on dynamic criteria
* Save time with recording and replaying straight forward macros
* Quickly organize and analyze large amounts of raw data with Pivot Tables and Charts
* Increase your Excel knowledge with efficiency techniques, advanced formulas and collaborating techniques.
Examples of people who will benefit greatly from this class:
* Those working with databases
* Those who have been working with Excel and would like to cut out hours of work from their weekly tasks.
* Those looking to quickly analyze large amounts of data
* Can retake the class, for free, up to 3 months.
* Free forum support for 1 year after class
* Hands on, goal based
* Small Classes of 4 to 9 people
* Fast computers
* Comfortable chairs, convenient location
* Patient, Fun, Experienced Trainer
When you are finished with this class you will be able to:
* Extract data from large databases based on dynamic criteria
* Save time with recording and replaying straight forward macros
* Quickly organize and analyze large amounts of raw data with Pivot Tables and Charts
* Increase your Excel knowledge with efficiency techniques, advanced formulas and collaborating techniques.
Examples of people who will benefit greatly from this class:
* Those working with databases
* Those who have been working with Excel and would like to cut out hours of work from their weekly tasks.
* Those looking to quickly analyze large amounts of data
|
|
||||||||
Training
Provided by New York Interactive Media
Advanced Excel 2003 for Business
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
New York Interactive Media 2008
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
New York Interactive Media 2008
About The Training Provider: New York Interactive Media
New York Interactive Media - NEW YORK INTERACTIVE MEDIA provides the most practical computer training in NYC. We offer both customized Private/ Corporate Training and Group Classes in many programs including: Excel, PowerPoint, QuickBooks and Financial Excel (to name a few). Training may take place at our convenient Manhattan location or at your home or office. Since 1998, we have trained thousands of clients from all over...
