|
|
|
Course ID: 21438
| Course Duration: 1 Day
| CEUs: 0
|
|
Course Dates:
|
| |
|
| |
Advanced Excel 2003 for Business Training Class
Course ID: 21438
|
|
| |
|
|
| |
|
|
| |
Advanced Excel 2003 for Business Training Seminar
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.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Course Outline
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 |
|
| |
|
|
|
| |
|
|
| |
Audience |
|
| |
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
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Prerequisites
* Those who have taken our "Excel for Business" Course or has equivalent knowledge.
o Please note, that you will not do well in this class if you are uncomfortable with less than 80% of or our Excel for Business class. You will generally need about 14- 16 hours of Excel class time from other training schools to compare with our Excel for Business class.
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Advanced Excel 2003 for Business Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 21438
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |
|
|
|
|