|
Building Report for Printing
Getting Started with the Reports Tool
Building Report
Using Table Sheet
Adding a New Sheet and Working with It
Adding a Sheet
Renaming Sheet
Moving or Copying Sheet
Sheet Protection
Hiding Sheet
Deleting Sheet
Sheet Parameters
Working with Report Sheet Elements
Working with Table Sheet Data
Entering Data into Sheet Cell
Editing Cell Contents
Copying and Pasting Data
Adding a Comment
Adding a Named Range
Using Formulas
Formula Bar
Setting Up Report Formulas
Function Wizard
Mathematical Functions
References and Arrays
Date and Time
Text Functions
Functions for Working with Report
Financial Functions
Accrint
AccrintM
AmorDegrC
AmorLinC
CoupDayBs
CoupDays
CoupDaysNc
CoupNcd
CoupNum
CoupPcd
CumIpmt
Cumprinc
Db
Ddb
Disc
DollarDe
DollarFr
Duration
Effect
Fv
FvSchedule
Intrate
Ipmt
Irr
Ispmt
MDuration
MIrr
Nominal
NPer
Npv
OddfPrice
OddfYield
OddlPrice
OddlYield
Pmt
Ppmt
Price
PriceDisc
PriceMat
Pv
Rate
Received
RedemptionYield
Sln
Syd
TBillEq
TBillPrice
TBillYield
Vdb
XIrr
Xnpv
YieldDisc
YieldF
YieldMat
Statistical Functions
Logical Functions
Functions for Working with Python
Custom Functions
Selecting Data Sources and Working with Them
Adding Data Slices and Working with Them
Data Visualization
Setting Up Report Parameters
Adding Interactive Report Contents Controls
Inserting Graphics, Shapes and Text Blocks
Selecting Report Formatting Styles
Displaying Data Access Permissions
Working with Report Templates
Setting Up Report for Printing
Using Text Sheet
Handling Report Events
Viewing Ready Report
Saving Report
Speeding Up High Volume Report
Working with Ready Report
Questions and Answers
|