Microsoft Excel 2003 Advanced
Sasha Norén shows you how to use Excel as a database crunching tool. This popular course teaches you how to extract the information you need to make the right decisions for a new millennium from extensive spreadsheet data. Excel comes packed with powerful features beyond the basic spreadsheet tasks, and Sasha Norén is your professional guide to master them. The power of Microsoft Excel and the power of Klick Data, combined for your benefit.
|
Titel: Microsoft Excel 2003 Advanced
Item: E302E-W3
Teacher: Sasha Norén
Runningtime: aprox 2h
Price: 995 sek excl. VAT
Kursinnehåll:
1. Fetching Data
1.1 Under construction
XML Lists
3-D Reference
Consolidate
Outline
Importing
2. Lists
2.1 Under construction
Sorting
Subtotals
Auto Filter
List Area
Database Functions
3. Pivot
3.1 Under construction
Selecting
Pivoting
Pivot Chart Report
Coaxing Pivot
Show Details
4. Analysis Tools
4.1 Under construction
Summary Reports
Custom Views
Iteration
Goal Seek
Solver
5. Forms
5.1 Under construction
Screen Forms
Lookup
Validation
Controls
Protection
6. Sharing Data
6.1 Under construction
Send for Review
Save Changes
Shared Workspace
Document Update
Web Queries
