Advanced Excel 2003 for Business

Training Provided by New York Interactive Media 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

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

About The Training Provider: New York Interactive Media