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

Microsoft Excel 2003 Advanced
Pris per enhet (st):
995 SEK

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

Microsoft och är ett registrerat varumärke av Microsoft Corp, USA. Adobe är ett registrerat varumärke av Adobe Corp, USA. Klick Data AB (publ) är ett utbildningsföretag som inte skall sammanblandas med dessa varumärken.
Alla utbildningar framtagna av Klick Data sedan 1992 i syfte att utbilda programvaror från programvaruleverantörer skall inte sammanblandas med produkter framtagna av ägare av dessa varumärken.
The course / e-course represented at this page is an independent education from Klick Data AB (publ) and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation, Adobe Corp or any other software manufacture.