|
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
Abs
ACos
ACosH
ACot
ACotH
Aggregate
ASin
ASinH
ATan
ATan2
ATanH
Average
AverageIf
AverageIfS
Ceiling
Combin
Cos
CosH
Cot
CotH
Count
CountIf
CountIfS
Degrees
Even
Exp
Fact
Floor
Gcd
Int
Lcm
Ln
Log
Log10
Max
MDeterm
Min
MInverse
MMult
Mod_
MRound
Multinomial
Odd
Power
Product
Quotient
Radians
Rand
RandBetween
RndPermutation
RndSample
Roman
Round
RoundDown
RoundUp
SeriesSum
Sign
Sin
SinH
Sqrt
SqrtPi
Sum
Sumif
SumIfS
SumSq
SumX2MY2
SumX2PY2
SumXMY2
Tan
TanH
Trunc
References and Arrays
Date and Time
Text Functions
Functions for Working with Report
Financial Functions
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
|