Course Preview
The following options give examples of Course content ...
Section
Contents
Page
One
Introduction
2
- What is Discoverer?
3
- What is Discoverer AS?
4
- Understanding Discoverer Terminology
5
- How to run Discoverer
15
Two
Discoverer Desktop Interface
17
- Connecting
18
- Anatomy
19
- Menu Bar
20
- Shortcut Bars
21
- Toolbar
22
- Formatting Bar
24
- Analysis Bar
26
Three
Working with Existing Workbooks
28
- Introduction
29
- Opening
31
- Write Permissions
33
- Different Accounts
34
- Missing Items
37
- Multiple EULs
39
- Running the Query
42
- Re-Sizing
43
- Pivoting
45
- Saving
51
- Parameters
52
- Exercise One
56
Four
Simple Workbooks
62
- Creating
63
- Modifying
78
- Duplicating
79
- Exercise Two
80
Five
Formatting
86
- Introduction
87
- Data
88
- Column Headings
96
- Backgrounds
97
- Titles
99
- Sorting
104
- Exceptions
110
- Creating Exceptions
116
- Managing Exceptions
117
- Page Setup
118
- Exercise Three
122
Six
Advanced Worksheets
134
- Introduction
135
- Page Items
136
- Cross-Tabs
138
- Exercise Four
143
Seven
Totals
148
- Introduction
149
- Creating
152
Eight
Percentages
157
- Introduction
158
- Creating
160
- Exercise Five
163
Nine
Conditions
170
- Introduction
171
- Administrator Conditions
173
- Creating
177
- Advanced
187
- Exercise Six
192
Ten
Calculations
197
- Introduction
198
- Creating
200
- Functions
204
- Exercise Seven
207
Eleven
Parameters
214
- Introduction
215
- Creating
216
- Disabling
225
- Advanced
226
- Exercise Eight
230
Twelve
Aggregation
234
- Introduction
235
- Example
236
- Data Points
240
- Dates
243
- Exercise Nine
246
Thirteen
Drilling
251
- Introduction
252
- Hierarchies
253
- Types
254
- Using
257
- Drill Dialog
258
- Drill Down/Drill Up
261
- Drill to a Related Item
262
- Drill to Detail in Another Sheet
263
- Drill to an External Application
264
- Exercise Ten
265
Fourteen
Graphs
270
- Introduction
271
- Incorporating
272
- Graph Wizard
273
- Graph Window
278
- Modifying
279
Fifteen
Summaries
288
Sixteen
Worksheet Options
291
- Introduction
292
- General
293
- Query Governor
294
- Table
296
- Crosstab
298
- Formats
299
- Advanced
300
- Additional
301
Seventeen
Additional Features
302
- Exporting
303
- Copy and Paste
305
- Excel Direct
306
- Sharing Workbooks
307
- Deleting a Workbook
309
- Scheduling a Workbook
310
- Managing Scheduled Workbooks
316
Eighteen
Line Commands
322
- Introduction
323
- DOS
324
- Options
332
- Exercise Eleven
337
Nineteen
Complex Queries
338
- Creating a worksheet using SQL
339
- Subqueries
342
- Creating a Subquery
343
- Alternative Subquery Creation
344
Twenty
Help
347
- Introduction
348
- Help Topics
349
- Using Help
350
- About Discoverer
351
- Exercise Twelve
352