|
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
Statistical Functions
_Frequency
AveDev
BetaDist
BetaInv
BinomDist
ChiDist
ChiInv
ChiTest
Confidence
Correl
Covar
CritBinom
DevSq
Dispersion
DispersionP
ExponDist
FDist
FInv
Fisher
FisherInv
Forecast
FTest
GammaDist
GammaInv
GammaLn
GeoMean
HarMean
HypGeomDist
Intercept
JarqueBeraStat
Kurt
Large
Linest
LogInv
LogNormDist
Median
Mode
NegBinomDist
NormDist
NormInv
NormsDist
NormsInv
Pearson
Percentile
PercentRank
Permut
Poisson
Prob
Quartile
Rank
Rsq
Skew
Slope
Small
Standardize
StDev
StDevP
SteYX
TDist
TInv
Trend
TrimMean
TTest
Weibull
ZTest
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
|