- # -
#DIV/0!
#N/A
#NAME?
#NULL!
#NUM!
#REF!
#VALUE!
- $ -
$ sign
- % -
% sign (operator)
- 3 -
3D effect (for objects)
3D view
for charts
- A -
ABS (absolute value)
Absolute cell references
Absolute value (ABS)
Accounting (number format)
ACOS (arccosine)
ACOSH (inverse hyperbolic cosine)
ACOT (arccotangent)
ACOTH (inverse hyperbolic cotangent)
Actual size (view)
Add/edit text
for AutoShapes
for text frames
Addition (operator)
ADDRESS (cell address as text)
Align (object)
align and distribute objects
snap to cells
to other objects with guides
Alignment
of cell contents
of text in text frames
All caps
option for the character format
PROPER (function)
UPPER (function)
Analyze sheets
AND (logical AND function)
Android/iOS
context menu
input method
select
share a document
user interface
Annuity
see PMT
ANSI code of a character (CODE)
Anti-aliasing
Arabic scripts
Arccosine (ACOS)
Arccotangent (ACOT)
Arcsine (ASIN)
Arctangent
ATAN
ATAN2
Area chart
AREAS (number of areas)
Array functions
MDETERM (matrix determinant)
MINVERSE (inverse)
MMULT (product of matrices)
MSOLVE (solution)
TRANSPOSE (transpose matrix)
working with arrays
Asian scripts
ASIN (arcsine)
ASINH (inverse hyperbolic sine)
Associate file types
ATAN (arctangent)
ATAN2 (arctangent)
ATANH (inverse hyperbolic tangent)
Auto input mode
Autocomplete cells
AutoFilter
AutoFormat
Automatic percent input
Auto-Recover
AutoShape
add/edit text
AutoShape effects
AutoShape templates
change on ribbon tab Object
change on the ribbon tab Object
change text area
change via the dialog box
drawing
AutoSum
AutoText
AVEDEV (average deviation)
Average
arithmetic mean (AVERAGE)
arithmetic mean (AVERAGEA)
if condition is true (AVERAGEIF)
if condition is true (AVERAGEIFS)
AVERAGE (arithmetic mean)
Average deviation (AVEDEV)
Average square deviation (DEVSQ)
AVERAGEA (arithmetic mean)
AVERAGEIF (average if condition is true)
AVERAGEIFS (average if conditions are true)
Axes (in charts)
Axis title (in charts)
- B -
B (compatibility function)
Background color
of cells
of text
Backup copies
Backup folder
BAK files
Banded rows and columns
Bar chart
BASE (convert decimal number into another base)
Based on (for cell styles)
Based on (for character styles)
BasicMaker
Beep on errors
Beep on errors (for spell check)
BESSELI (modified Bessel function In(x))
BESSELJ (Bessel function Jn(x))
BESSELK (modified Bessel function Kn(x))
BESSELY (Bessel function Yn(x))
Beta distribution
BETA.DIST
BETA.INV
BETADIST
BETAINV
BETA.DIST (beta distribution)
BETA.INV (percentiles of the beta distribution)
BETADIST (beta distribution)
BETAINV (percentiles of the beta distribution)
BIN2DEC (binary to decimal)
BIN2HEX (binary to hexadecimal)
BIN2OCT (binary to octal)
Binary to decimal (BIN2DEC)
Binary to hexadecimal (BIN2HEX)
Binary to octal (BIN2OCT)
BINOM.DIST (binomial distribution)
BINOM.DIST.RANGE (binomial distribution)
BINOM.INV (binomial distribution)
BINOMDIST (binomial distribution)
Binomial distribution
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
CRITBINOM
NEGBINOM.DIST
NEGBINOMDIST
Bold (font)
Boolean (number format)
Borders
of cells
of objects
Box and whisker plot
Boxplot chart
Bring forward one level (object)
Bring to front (object)
Bubble chart
- C -
Calculation in status bar
Calculations
update
Category axis (in charts)
CEILING (round up to a multiple of base)
Cell
alignment
borders
change size
delete
do not print
enter data
fill automatically
hide
insert
merge
number format
protect
protection
select
shading
CELL (information about a cell)
Cell address as text (ADDRESS)
Cell contents
copy
cut
delete
paste
Cell formatting, transfer
Cell frame
Cell marker
Cell protection
Cell styles
apply
based on
change
create
default style "Normal"
shortcut keys
Centered
Change shape
Change text area
of AutoShapes
of text frames
CHAR (character from ANSI code)
Character format
all caps
background color
bold
character pitch
font
font color
font size
italic
kerning
letter spacing
small caps
strikethrough
superscripts and subscripts
text styles
underline
Character formatting
apply to entire words
reset
Character pitch
Character styles
apply
based on
change
create
default style "Normal"
shortcut keys
Chart (dialog box)
Chart (ribbon tab)
Chart area
Chart title
Charts
add/delete data series
arrangement of data series
change chart location
change chart type
change properties
data in columns
data in rows
edit
insert
save as picture
select chart elements
update
Check for updates
Checkboxes (form object)
CHIDIST (chi-square distribution)
CHIINV (percentiles of the chi-square distribution)
CHISQ.DIST.RT (chi-square distribution)
CHISQ.INV.RT (percentiles of the chi-square distribution)
CHISQ.TEST (chi-square test)
Chi-square distribution
CHIDIST
CHIINV
CHISQ.DIST.RT
CHISQ.INV.RT
Chi-square test
CHISQ.TEST
CHITEST
CHITEST (chi-square test)
CHOICE (x>0, x=0, x<0?)
CHOOSE (choose value from list)
Circular reference
Classic menus with toolbars
list of all ribbon commands and menu commands
user interface
CLEAN (remove non-printable characters)
Close (File)
Close document
CODE (ANSI code of a character)
Color
of cells
of objects
of text
Color gradient (for objects)
Column
change width
delete
hide/show
insert
optimum width
select
COLUMN (function: column number of cells)
Column chart
Column header
change column width
print
show/hide
use for selection
COLUMNS (function: number of columns)
COMBIN (combinations)
Combine (object shapes)
Combine shapes
Command-line parameters
Comments
always show
delete
edit
insert
print
show always
Common logarithm (LOG10)
Complex numbers
absolute value (IMABS)
angle (IMARGUMENT)
build complex number (COMPLEX)
conjugate (IMCONJUGATE)
cosine (IMCOS)
difference (IMSUB)
division (IMDIV)
exponential (IMEXP)
imaginary coefficient (IMAGINARY)
logarithm, base 10 (IMLOG10 )
logarithm, base 2 (IMLOG2 )
negative value (IMNEG)
power (IMPOWER)
product (IMPRODUCT)
real coefficient (IMREAL)
sine (IMSIN)
square root (IMSQRT)
sum (IMSUM)
Complex scripts
CONCAT (concatenate strings from list)
CONCATENATE (concatenate text strings)
Concatenation (operator)
Concatenation of strings (functions)
CONCAT
CONCATENATE
TEXTJOIN
Condition
CHOICE
IF
IFS
Conditional formatting
delete rules in selected cells
manage rules
new rule
types of conditions
Cone chart
CONFIDENCE (confidence interval)
Confidence interval
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.NORM (confidence interval)
Consolidate data
Context menu
CONVERT (unit conversion)
Convert decimal number into another base (BASE)
Convert EU currencies (EUROCONVERT)
Copy
cell contents
formula
insert copied cells
object
text
Corners (in charts)
CORREL (correlation coefficient)
Correlation coefficient
CORREL
PEARSON
Correlation coefficient (RSQ)
COS (cosine)
COSH (hyperbolic cosine)
Cosine (COS)
COT (cotangent)
Cotangent (COT)
COTH (hyperbolic cotangent)
Count
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COUNT (number of cells filled with numbers)
COUNTA (number of cells filled)
COUNTBLANK (number of blank cells)
COUNTIF (count if condition is true)
COUNTIFS (count if conditions are true)
COUNTP (PlanMaker 97 compatibility function)
COVAR (population covariance)
Covariance
COVAR (population)
COVARIANCE.P (population)
COVARIANCE.S (sample)
COVARIANCE.P (population covariance)
COVARIANCE.S (sample covariance)
Create a complex number (COMPLEX)
Create new document
CREATEDATE (date the document was created)
Creation date
CRITBINOM (binomial distribution)
Cropping (of pictures)
CSV file format
CUMIPMT (cumulative interest)
CUMPRINC (cumulative principal)
CURRENCY (format number as currency)
Currency (number format)
Custom number formats
Customize
create user-defined icons
customize shortcut keys
customize toolbars
ribbon
Cut
cell contents
formula
object
text
Cylinder chart
- D -
Data consolidation
Data labels (in charts)
Data points (in charts)
Data series (in charts)
add
delete
edit
Data series, fill automatically
Data source area (of charts)
Data validation
Database functions
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
Date
create a date value (DATE)
current (TODAY)
current, with time (NOW)
enter
DATE (create a date value)
Date before/after n months (EDATE)
Date difference (DATEDIF)
Date filters (AutoFilter)
Date last changed
Date the document was created (CREATEDATE)
Date/time (number format)
DATEDIF (date difference)
DATEVALUE (convert text into date value)
DAVERAGE (database function)
DAY (day of a date)
DAYS (days between two dates)
DAYS360 (days between two dates)
DAYSP (compatibility function)
DAYSPERMONTH (days per month)
DAYSPERYEAR (days per year)
DB (fixed-declining balance depreciation)
dBASE file format
DCOUNT (database function)
DCOUNTA (database function)
DDB (double-declining balance depreciation)
DEC2BIN (decimal to binary)
DEC2HEX (decimal to hexadecimal)
DEC2OCT (decimal to octal)
DECIBEL (decibel value of two quantities)
DECIMAL (convert number from any base into decimal)
Decimal point after input
Decimal separator
Decimal to binary (DEC2BIN)
Decimal to hexadecimal (DEC2HEX)
Decimal to octal (DEC2OCT)
DECIMALS (fractional part of a number)
Default cell style "Normal"
Default character style "Normal"
Default currency
Default file format when saving
Default language for spell check
Default number format
Default template (document template)
"Normal"
change
switch
Default unit of measure
Defined names
Defined names (for cell ranges)
apply in existing formulas
export names as list
DEGREES (convert radians to degrees)
Degrees to radians (RADIANS)
Delete
cell contents
cells
duplicate rows
empty rows
object
special
text
DELTA (test for equality)
Depreciation
double-declining balance (DDB)
fixed-declining balance (DB)
straight-line (SLN)
sum-of-years’ digits (SYD)
Design Science
Determinant of a matrix (MDET)
DEVSQ (average square deviation)
DGET (database function)
Dialog language
Dictionaries for spell check
edit
install
Disable sheet protection
Display help content (F1 key)
Display the formula a cell contains (FORMULATEXT)
Distance to edge
Distribute (object)
Division (operator)
DMAX (database function)
DMIN (database function)
Document management
Document properties
Calculate tab
Colors tab
Fonts tab
Options tab
Protection tab
Statistics tab
Summary tab
Document protection
Document statistics
Document summary
enter
prompt for summary information when saving
Document tabs
Document templates
apply
change
create
default template "Normal"
Document, print
Document, save
DOLLARDE (convert to dollar price decimal)
DOLLARFR (convert to dollar price fraction)
Doughnut chart
DPRODUCT (database function)
Drag and drop
Draw circles
Draw connectors
Draw curves
Draw ellipses
Draw rectangles
Drawing object (dialog box)
Drawing object (ribbon tab)
Drawings
change properties
combine
edit retroactively
insert
rotate
Dropdown lists (form object)
DSTDEV (database function)
DSTDEVP (database function)
DSUM (database function)
Duplicate (objects)
Duplicate rows (delete)
DVAR (database function)
DVARP (database function)
Dynamic tables
- E -
EDATE (date before/after n months)
Edit
links (OLE objects)
Edit chart elements
axis title
chart area
chart title
corners
data labels
data series
error bars
floor
gridlines
legend
lines
plot area
trendline
up/down bars
walls
X axis
Y axis
Z axis
Edit color palette
Edit lists (for filling)
Edit mode
Edit points (of objects)
Edit script
Edit shapes retroactively
Edit toolbar
EFFECT (effective interest rate)
Effective interest rate (EFFECT)
Effects (for objects)
E-mail a document
Empty rows, remove
En dashes, different widths
Enable OpenGL for AutoShapes
Encryption
Enter data in cells
EOMONTH (end of month in n months)
Equality (DELTA)
Equation Editor
ERF (Gaussian error function)
ERFC (complement to Gaussian error function)
Error bar (in charts)
Error function
ERF
ERFC (complement)
Error type (ERROR.TYPE)
Error values in calculations
ERROR.TYPE (error type)
EUROCONVERT (convert EU currencies)
EVEN (round up to next even number)
EXACT (compare texts)
Excel file format
Exclusive or (XOR)
Exit (file)
EXP (power of e)
EXPON.DIST (exponential distribution)
EXPONDIST (exponential distribution)
Exponential distribution
EXPON.DIST
EXPONDIST
Exponential regression
statistics (LOGEST)
values (GROWTH)
Exponentiation
operator
POWER function
Export (other file format)
Export/Import of settings
Extended support
for Arabic text
for Asian fonts
External cell references
External references
enter
manage
update
- F -
F distribution
F.DIST.RT
F.INV.RT
FDIST
FINV
F.DIST.RT (F distribution)
F.INV.RT (percentiles of the F distribution)
F.TEST (F-test)
FACT (factorial)
FACTDOUBLE (double factorial)
FALSE (logical value FALSE)
FDIST (F distribution)
Fields (in headers/footers)
File
export as PDF
send by e-mail
File formats
File manager
File properties
Calculate tab
Colors tab
Fonts tab
Options tab
Protection tab
Statistics tab
Summary tab
File type
File versions
File: Close
File: Exit
File: New
File: Open
File: Page setup
File: Print
File: Print preview
File: Properties
File: Save
File: Save all
File: Save as
FILENAME (file name of the document)
Fill
of objects
Fill cells (automatically)
Filling
of cells
Filters
AutoFilter
special filter
FIND (search for text)
FINV (percentiles of the F distribution)
First column (emphasize)
First column, freeze
FISHER (Fisher transformation)
FISHERINV (Inverse of the Fisher transformation)
FIXED (format number as text with fixed decimals)
Flip (objects)
Floor (in charts)
FLOOR (rounding off to a multiple of n)
Folder for file versions
Font
bold
italic
underline
Font color
Font lists, hide fonts
Font size
Footers
FORECAST (forecast using linear regression)
Form object (ribbon tab)
Form objects
edit
evaluate
Form objects, insert
checkboxes
dropdown lists
groupboxes
labels
listboxes
pushbuttons
radio buttons
scrollbars
spinners
Format painter
Formatting toolbar
Forms
Formula auditing
Formulas
FORMULATEXT (display formula contained in cell)
Fraction (number format)
Freehand drawing
Freeze rows/columns
FREQUENCY (frequency)
F-test
F.TEST
FTEST
Full screen mode (view)
Functions
functions from A to Z
insert
Future value
FV
FVSCHEDULE
FV (future value)
FVSCHEDULE (future value)
- G -
GAMMA (gamma function)
Gamma distribution
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
Gamma function
GAMMA
GAMMALN
GAMMA.DIST (gamma distribution)
GAMMA.INV (percentiles of the gamma distribution)
GAMMADIST (gamma distribution)
GAMMAINV (percentiles of the gamma distribution)
GAMMALN (logarithm of the gamma function)
GAUSS (standard normal distribution)
Gauss test
Z.TEST
ZTEST
Gaussian distribution (NORM.DIST)
Gaussian distribution (NORMDIST)
Gaussian error function
ERF
ERFC complement
GCD (greatest common divisor)
GEOMEAN (geometric mean)
Geometric mean (GEOMEAN)
GESTEP (number greater or equal to threshold value?)
GETPIVOTDATA
Glow effect (for objects)
Go to
Goal seek
Greatest common divisor (GCD)
Gridlines between table cells
paint behind cells
print
show
Gridlines in charts
Group
cells (outliner)
in pivot tables
objects
show/hide cells
Groupboxes (form object)
GROWTH (values of an exponential regression)
Guidelines for text frames, show
- H -
Hamburger menu
HARMEAN (harmonic mean)
Harmonic mean (HARMEAN)
Headers and footers
Height of a row
HEX2BIN (hexadecimal to binary)
HEX2DEC (hexadecimal to decimal)
HEX2OCT (hexadecimal to octal)
Hexadecimal to binary (HEX2BIN)
Hexadecimal to decimal (HEX2DEC)
Hexadecimal to octal (HEX2OCT)
Hide
cells contents
objects
Hide cells
manually
using the outliner
High-low chart
HLOOKUP (look up row-wise)
HOLIDAY (dates of movable Christian holidays)
Horizontal alignment of cell contents
HOUR (hour)
HTML document
Hunspell dictionaries
Hyperbolic cosine (COSH)
Hyperbolic cotangent (COTH)
Hyperbolic sine (SINH)
Hyperbolic tangent (TANH)
Hypergeometric distribution
HYPGEOM.DIST
HYPGEOMDIST
HYPERLINK (function: hyperlink)
Hyperlinks (links)
applied to cells
for objects
for OLE objects
HYPERLINK function
remove
to jump target
HYPGEOM.DIST (hypergeometric distribution)
HYPGEOMDIST (hypergeometric distribution)
Hyphen
non-breaking hyphen
soft hyphen
Hyphenation
in table cells
in text frames
set language
- I -
IF (if-then-else condition)
IFEMPTY (return a value if cell is empty)
IFERROR (return a value on errors)
IFNA (return defined value for #N/A)
IFS (first condition met)
Ignore words that start with a number
IMABS (absolute value of a complex number)
IMAGINARY (imaginary coefficient of a complex number)
IMARGUMENT (angle of a complex number)
IMCONJUGATE (conjugate a complex number)
IMCOS (cosine of a complex number)
IMDIV (division of complex numbers)
IMEXP (exponential of a complex number)
IMLN (natural logarithm of a complex number)
IMLOG10 (base-10 logarithm of a complex number)
IMLOG2 (base-2 logarithm of a complex number)
IMNEG (negative value of a complex number)
Import (other file format)
Import/Export of settings
IMPOWER (power of a complex number)
IMPRODUCT (product of complex numbers)
IMREAL (real coefficient of a complex number)
IMSIN (sine of a complex number)
IMSQRT (square root of acomplex number)
IMSUB (difference of complex numbers)
IMSUM (sum of complex numbers)
In-cell editing
Indents (text frames only)
INDEX (cell in a particular row/column)
INDIRECT (create reference from text)
Information about a cell (CELL)
Inner margins
of cells
of text frames
of text in AutoShapes
Input method (Android)
Input validation
Insert
cells
characters
charts
columns
comments
copied cells
drawings
Equation Editor objects
form objects
functions
headers and footers
objects
OLE objects
page break
pictures
rows
SmartText entries
special characters
text frames
Insert characters
Insert frames and drawings immediately
Insert mode / Overwrite mode
disable
Insert pictures from the gallery/camera (Android and iOS only)
Insert special characters
Installation
Android
iOS
Linux
macOS
Windows
INT (round down to nearest integer)
INTERCEPT (intercept point of a regression line)
Interest payment
(IPMT)
CUMIPMT (cumulative)
ISPMT
Interest rate
PCF
per period (RATE)
RRI
Internal rate of return
IRR
MIRR
Intersection
INTERSECTION function
operator
INTERSECTION (intersection of two ranges)
Inverse hyperbolic cosine (ACOSH)
Inverse hyperbolic cotangent (ACOTH)
Inverse hyperbolic sine (ASINH)
Inverse hyperbolic tangent (ATANH)
Inverse matrix (MINVERSE)
iOS/Android
context menu
input method
select
share a document
user interface
IPMT (interest payment)
IRR (internal rate of return)
ISBLANK (is empty?)
ISERR (is an error value except #N/A?)
ISERR (is an error value other than #N/A?)
ISERROR (is an error value?)
ISEVEN (is an even number?)
ISFORMULA (is a formula?)
ISLOGICAL (is a logical value?)
ISNA (is not available?)
ISNONTEXT (is no text?)
ISNUMBER (is numeric?)
ISNUMBERP (PlanMaker 97 compatibility function)
ISODD (is an odd number?)
ISOWEEK (ISO week number)
ISOWEEKNUM (ISO week number)
ISPMT (interest payment)
ISREF (is a valid reference?)
ISTEXT (is text?)
Italic (font)
Iterations for calculations
- J -
Jump target (hyperlink)
Justification (in text frames)
- K -
Keep aspect ratio
Keep scaling
Kerning
KURT (kurtosis)
Kurtosis (KURT)
- L -
Labels (form object)
Landscape format
Language
for spell check and hyphenation
for user interface
LARGE (k-th largest number)
Last column (emphasize)
LASTPRINTED (date last printed)
LASTSAVED (date last saved)
LCM (least common multiple)
Least common multiple (LCM)
LEFT (function: left part of a text string)
Left align
Left arrow key never exits cell editing
Legend (in charts)
LEN (length)
Letter spacing
Line chart
Line spacing (text frame)
Linear regression
FORECAST
INTERCEPT
show trend in charts
statistics (LINEST)
values (TREND)
Lines
as borders of objects
drawing
Lines (in charts)
LINEST (statistics of a linear regression)
Links (hyperlinks)
applied to cells
for objects
HYPERLINK function
Links (OLE objects)
edit
update
Listboxes (form object)
Live preview
LN (natural logarithm)
LOG (logarithm)
LOG10 (base-10 logarithm)
Logarithm
any base (LOG)
base 10 (LOG10)
natural (LN)
LOGEST (statistics of an exponential regression)
LOGINV (percentiles of the lognormal distribution)
LOGNORM.DIST (lognormal distribution)
LOGNORM.INV (percentiles of the lognormal distribution)
Lognormal distribution
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOGNORMDIST (lognormal distribution)
LOOKUP (search cell range)
LOWER (convert text to lower case)
Lower case
LOWER
PROPER
- M -
Macros
Manage (button in the settings)
Manual (PlanMaker)
Margins
inner margins of AutoShapes
inner margins of cells
inner margins of text frames
page margins
Mark invalid data
MATCH (relative position in a range)
MathType
Matrix equation (MSOLVE)
MAX (maximum)
MAXA (maximum)
MAXIFS (conditional maximum)
Maximum number of undo steps
MDETERM (matrix determinant)
Mean
geometric (GEOMEAN)
harmonic (HARMEAN)
without marginal values (TRIMMEAN)
MEDIAN
Menu bar
Menus with toolbars or ribbon?
MID (part of a text string)
Middle mouse button
MILLISECONDS (milliseconds)
MIN (minimum)
MINA (minimum)
MINIFS (conditional minimum)
MINUTE (minute)
MINVERSE (inverse matrix)
MIRR (modified internal rate of return)
Mirror (objects)
MMULT (product of matrices)
MOD (remainder of a division, Excel method)
MODE (most frequently occurring value)
MODE.SNGL (most frequently occurring value)
Modified internal rate of return
MIRR
MODP (remainder of a division, PlanMaker method)
MONTH (month of a date)
Move by ... decimals
Move selection after input to ...
MROUND (round to a multiple of base)
MSOLVE (solution of matrix equation Ax=B)
MULTINOMIAL (multinomial coefficient)
Multinomial coefficient
MULTINOMIAL
POLYNOMIAL
Multiplication (operator)
- N -
N (convert value into number)
NA (error value #N/A)
Name of a worksheet (SHEETNAME)
Names (for cell ranges)
apply in existing formulas
assign
create from selection
edit
insert list
Names (of objects)
Names (of tables)
NEG (negative value)
Negation (NEG)
Negative binomial distribution
NEGBINOM.DIST
NEGBINOMDIST
NEGBINOM.DIST (negative binomial distribution)
NEGBINOMDIST (negative binomial distribution)
Net present value
NPV
XNPV
NETWORKDAYS (number of workdays)
Neumann function (BESSELY)
New (File)
New pivot table
New program window
New table (tables in worksheets)
NOMINAL (nominal interest rate)
Non-breaking hyphen
Non-breaking space
NORM.DIST (normal distribution)
NORM.INV (percentiles of the normal distribution)
NORM.S.DIST (standard normal distribution)
NORM.S.INV (percentiles of the standard distribution)
Normal
cell style
character style
Normal distribution
NORM.DIST
NORM.INV
NORMDIST
NORMINV
Normal distribution, logarithmic
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
Normal.pmvx
NORMDIST (normal distribution)
NORMINV (percentiles of the normal distribution)
NORMSDIST (standard normal distribution)
NORMSINV (percentiles of the standard distribution)
NOT (logical NOT function)
NOW (current date and time)
NPER (number of periods)
NPV (net present value)
Number (number format)
Number filters (AutoFilter)
Number format
Number of periods (NPER)
Number of worksheets (SHEETS)
Number separators
Number series, fill automatically
Numbers, enter
NUMBERVALUE (convert text to a number)
- O -
Object
copy
cut
delete
paste
select
Object (dialog box)
Object mode
Object properties
change default settings
for charts
for checkboxes
for drawings
for dropdown lists
for groupboxes
for labels
for listboxes
for OLE objects
for pictures
for pushbuttons
for radio buttons
for scrollbars
for spinners
for text frames
general properties
Objects
align and distribute
change order
change position and size
change properties
combine
distribute
duplicate
edit retroactively
group
hide
insert
rotate
rotate or flip
show hidden objects
show text frame guidelines
ungroup
OCT2BIN (octal to binary)
OCT2DEC (octal to decimal)
OCT2HEX (octal to hexadecimal)
Octal to binary (OCT2BIN)
Octal to decimal (OCT2DEC)
Octal to hexadecimal (OCT2HEX)
ODD (round up to next odd number)
OFFSET (shifted reference)
OLE object (dialog box)
OLE object (ribbon tab)
OLE objects
change properties
edit
edit links
Equation Editor
insert
update links
warning when loading
Open (File)
Operators in formulas
Optimum height
Optimum width
OR (logical OR function)
Order (of objects)
Orientation
of printed pages
Other file formats
Outline pane
Outlines
automatically show outline pane
change settings
clear outline
group cells
options
protect
show/hide grouped cells
ungroup
Overlapping objects
Overwrite mode / Insert mode
disable
- P -
Page break preview
Page breaks
adjust manually
show/hide
Page setup
copy to other worksheets
headers and footers
number of pages
page format
page margins
page number
page orientation
page size
print options
Paper size
Paper trays
Paragraph format (text frame)
line spacing
spacing above/below
text alignment
Paragraph format (text frames)
indents
Pascal distribution
NEGBINOM.DIST
NEGBINOMDIST
Paste
contents (selective)
reference
Paste copied content
Paste reference
Paste special
Payment (PMT)
PCF (interest rate)
PDF export
PDF/A, create
Peakedness of a distribution (KURT)
PEARSON (Pearson correlation coefficient)
Percent (operator)
Percentage (number format)
PERCENTILE (percentiles of a data set)
PERCENTILE.EXC (percentiles of a data set)
PERCENTILE.INC (percentiles of a data set)
PERCENTRANK (percent rank in a data set)
PERCENTRANK.EXC (percent rank in a data set)
PERCENTRANK.INC (percent rank in a data set)
PERIOD (duration of fixed-interest investments)
PERMUT
PHI (standard normal distribution)
Photo frames
PI (pi)
Picture (dialog box)
Picture (ribbon tab)
Pictures
change properties
change source
copy to document's folder
export
from scanner
insert
recolor
rotate or flip
save within document
select source
Pie chart
Pinned files
Pinned templates
Pivot tables
change the source data range
column labels
copy
create from existing data
create from external data
create from tables in worksheets
custom name for fields
custom name for pivot table
defer layout update
delete
field list: areas section
field list: configure the pivot table
field list: exercises
field list: fields section
field list: further options
field list: starting screen
field settings
fields: move and remove
filter
filter labels/filter values
form (field settings)
GETPIVOTDATA
group
layout (pivot table settings)
modify pivot table ranges
move
number format
outline form
pivot table settings
Pivot table sidebar
refresh when opening the file
report filter
row labels
save source data with file
sort A-Z (fields in the field list)
sort A-Z (fields in the pivot report)
styles for pivot tables
subtotals
tabular form
update
value settings
values area
Plain text file format
PlanMaker
basics
customize
settings
user interface
PlanMaker basics
PlanMaker file format
PlanMaker manual
PlanMaker Tour
Plot area (in charts)
PMBAK files
PMD file format
PMDX file format
PMT (payment)
POISSON (Poisson distribution)
Poisson distribution
POISSON
POISSON.DIST
POISSON.DIST (Poisson distribution)
POLYNOMIAL (polynomial coefficient)
Polynomial coefficient
MULTINOMIAL
POLYNOMIAL
Portrait format
Position (of objects)
Position of a value in a range (MATCH)
POWER (power)
PPMT (payment on the principal)
Precision as displayed
Present value (PV)
Preview (of a document)
Primary axes (in charts)
Principal
CUMPRINC (cumulative)
PPMT
Print a document
Print date
Print order
Print preview
Print range
define print range
remove print range
Print time
PROB (probability)
PRODUCT (product)
Product of matrices (MMULT)
Prompt for summary information when saving
PROPER (convert text to upper/lower case)
Properties (document)
Calculate tab
Colors tab
Fonts tab
Options tab
Protection tab
Statistics tab
Summary tab
Properties (object)
for charts
for checkboxes
for drawings
for dropdown lists
for groupboxes
for labels
for listboxes
for OLE objects
for pictures
for pushbuttons
for radio buttons
for scrollbars
for spinners
for text frames
Properties (objects in general)
change default settings
general properties
Properties (worksheet)
Protect
cell protection
documents
sheet protection
workbooks
Protect outline
Protection indicator
Pushbuttons (form object)
PV (present value)
Pyramid chart
- Q -
QUARTILE (quartiles of a data set)
QUARTILE.EXC (quartiles of a data set)
QUARTILE.INC (quartiles of a data set)
Quick access toolbar
change position
customize icons
Quick paths
QUOTIENT (quotient of a division)
- R -
Radar chart
RADIANS (convert degrees to radians)
Radians to degrees (DEGREES)
Radio buttons (form object)
RAND (random value)
RANDBETWEEN (random value)
Rank
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
RANK
RANK.AVG
RANK.EQ
RANK (rank in a data set)
RANK.AVG (rank in a data set)
RANK.EQ (rank in a data set)
RATE (interest rate per period)
Rate of return
IRR
MIRR
Recalc automatically
Recalc only before ...
Recalculate (sheet)
Redo
Redo (changes)
Reflection effect (for objects)
Refresh data for pivot table
Regression, exponential
statistics (LOGEST)
values (GROWTH)
Regression, linear
statistics (LINEST)
values (TREND)
Relative cell references
Remainder of a division
MOD (Excel method)
MODP (PlanMaker method)
Remove
duplicate rows
empty rows
Remove duplicate rows
Remove non-printable characters (CLEAN)
Remove spaces (TRIM)
Repeat (commands)
Repeated columns
Repeated rows
REPLACE (replace text in a text string)
Replace (ribbon command Home | Search)
Replace again (ribbon command Home | Search)
Replace text in a text string
REPLACE
SUBSTITUTE
REPT (repeat text string n times)
Research via the Internet
Reset
character formatting
PDF export options
picture settings
ribbon
SoftMaker Office settings
toolbars
Revert to previous version (file)
Ribbon
create user-defined icons
customize
customize groups
customize icons
list of all ribbon commands and menu commands
manage
reset
show/hide
user interface
Ribbon or menus with toolbars?
RIGHT (right part of a text string)
Right align
ROMAN (Roman numeral)
Root
n-th root (ROOTN)
square root (SQRT)
square root of x*Pi (SQRTPI)
ROOTN (n-th root)
Rotate
axis labels
cell contents
objects
text in AutoShapes
text in text frames
Rotate or flip (objects)
Round
CEILING
EVEN
FIXED
FLOOR
INT
MROUND
ODD
ROUND
ROUNDDOWN
ROUNDUP
TRUNC
ROUND (round to n digits)
ROUNDDOWN (round down to n digits)
Rounding
display numbers rounded
final result
intermediate results
precision as displayed
ROUNDUP (round up to n digits)
Row
change height
delete
hide/show
insert
optimum height
select
Row & column headers
ROW (function: row number of cells)
Row header
change row height
print
show/hide
use for selection
Row number of cells (ROW)
ROWS (function: number of rows in a range)
RRI (interest rate)
RSQ (square of Pearson)
- S -
Save (File)
Save all (File)
Save as (File)
Scale document
Scaling (of printed pages)
Scan pictures
Scenarios
Scientific (number format)
Scribble mode on iOS
Scripts
Scrollbars (form object)
Scrollbars, show/hide
Search (file manager)
Search (function)
FIND (search for text)
FIND (search text in string)
HLOOKUP
LOOKUP
SEARCH (search text in string)
VLOOKUP
Search (ribbon command Home | Search)
cell contents
search again
Search again
Search files (file manager)
SECOND (second)
Secondary axes (in charts)
Select
cells
objects
Select all
Select chart elements
Select source (file)
Send a document by e-mail
Send backward one level (object)
Send to back (object)
Series axis (in charts)
SERIESSUM (sum of a power series)
Set as default
document template
object properties
Settings (PlanMaker)
Appearance tab
Backup tab
Edit tab
Files tab
Fonts tab
General tab
Language tab
System tab
View tab
Settings (SoftMaker Office)
export/import
reset
Shading (of cells)
Shadow (for objects)
Share a document (via Android/iOS)
Sheet
change properties
copy
delete
hide sheet
insert
move
rename
show sheet
visibility
SHEET (index of a worksheet)
Sheet direction
Sheet grid (gridlines), show
Sheet protection
SHEETNAME (name of a worksheet)
SHEETNUMBER (compatibility function)
SHEETS (number of worksheets)
Shortcut keys
customize
for cell styles
for character styles
for special characters
predefined: Mac
predefined: Windows/Linux
Show cells
Show fonts in font list
Show formulas
Show hidden files and folders
Show hidden objects
Show indicators (for comments)
Show tooltips
for commands
for formulas
Show warning when loading OLE objects
Show watch list
Show/hide chart elements
axes (X, Y, Z)
axis title
chart title
data labels
error bars
gridlines
legend
lines
trendline
up/down bars
Show/hide keyboard automatically
Sidebar for the pivot table
Sign (operator)
SIGN (sign of a number)
SIN (sine)
Sine (SIN)
SINH (hyperbolic sine)
Size
of cells
of objects
SKEW (skewness of a distribution)
SLN (straight-line depreciation)
SLOPE (slope of a linear trend)
SMALL (k-th smallest number)
Small caps
SmartText
SmartText entries
create
edit
expand
insert
replace automatically
Smooth edges of pictures
Smooth edges of screen fonts
Snapshots (backup copies)
Soft edges effect (for objects)
Soft hyphen
SoftMaker
SoftMaker Basic
SoftMaker Equation Editor
Sort and filter
SORTM (sort function)
SORTV (sort function)
Spaces, different widths
Special filter
Spell check
as you type
edit user dictionaries
install additional dictionaries
manual
set language
Spinners (form object)
SQRT (square root)
SQRTPI (square root of x*Pi)
Standard deviation
entire population (STDEV.P)
entire population (STDEVP)
entire population (STDEVPA)
sample (STDEV)
sample (STDEV.S)
sample (STDEVA)
Standard error of a linear regression (STEYX)
Standard normal distribution
GAUSS
NORM.S.DIST
NORM.S.INV
NORMSDIST
NORMSINV
PHI
Standard toolbar
STANDARDIZE (standardized value)
Start script
Statistics (of document)
Statistics of a regression
LINEST (linear)
LOGEST (exponential)
Status bar
show/hide
STDEV (standard deviation of a sample)
STDEV.P (standard deviation of entire population)
STDEV.S (standard deviation of a sample)
STDEVA (standard deviation of a sample)
STDEVP (standard deviation of entire population)
STDEVPA (standard deviation of entire population)
STEYX (standard error of a linear regression)
Stock chart
Strikethrough
Student’s t-distribution
T.DIST
T.DIST.2T (two-tailed)
T.DIST.RT (right-tailed)
T.INV (left-tailed)
T.INV.2T (two-tailed)
TDIST
TINV
Student’s t-test (T.TEST)
Student’s t-test (TTEST)
Subscripts
SUBSTITUTE (replace text in a text string)
SUBTOTAL (calculations without hidden cells)
Subtraction (operator)
SUM (Sum)
SUMIF (sum if condition is true)
SUMIFS (sum if conditions are true)
SUMPRODUCT (sum of products)
SUMSQ (sum of squares)
SUMX2MY2 (sum of x^2 - y^2)
SUMX2PY2 (sum of x^2 + y^2)
SUMXMY2 (sum of (x - y)^2)
Superscripts
Support
Surface chart
SWITCH (categorize initial value)
SYD (sum-of-years’ digits depreciation)
Syntax highlighting
System requirements
- T -
T (convert value into text string)
T.DIST (t-distribution)
T.DIST.2T (t-distribution two-tailed)
T.DIST.RT (t-distribution right-tailed)
T.INV (percentiles of the t-distribution left-tailed)
T.INV.2T (percentiles of the t-distribution two-tailed)
T.TEST (t-test)
Tab width (in text frames)
Table (ribbon tab)
Tables in worksheets
banded rows and columns
cell references
convert to range
create
delete rows/columns
delete table
emphasize first column
emphasize last column
expand automatically
insert rows/columns
name of table
select rows/columns
select table
summarize as pivot table
table name
table properties
table range
table styles
totals row
using names and specifiers
Tablet mode (Android/iOS)
Tabs for documents
TAN (tangent)
Tangent (TAN)
TANH (hyperbolic tangent)
TDIST (t-distribution)
t-distribution
T.DIST
T.DIST.2T (two-tailed)
T.DIST.RT (right-tailed)
T.INV (left-tailed)
T.INV.2T (two-tailed)
TDIST
TINV
Technical support
Template folder
Text
copy
cut
delete
enter
paste
TEXT (convert number into text string)
Text (number format)
Text (Object properties tab)
Text alignment (text frame)
Text direction
Text filters (AutoFilter)
Text frame
paragraph format
Text frames
add/edit text
change properties
change text area
hyphenation
insert
Text input mode
Text strings
compare (EXACT)
concatenate (CONCAT)
concatenate (CONCATENATE)
concatenate (TEXTJOIN)
convert into a number (VALUE)
convert to a number (NUMBERVALUE)
cut a part (LEFT)
cut out part (RIGHT)
cut part (MID)
repeat n times (REPT)
Text styles
Text to columns, split
TextArt objects
change properties
drawing
transformation
TEXTJOIN (concatenate strings with separators)
TextMaker file format
Thousands separator
Three dimensional calculations
Threshold value (GESTEP)
TIME (create time)
Time, enter
TIMEDIFF (time difference)
TIMEVALUE (convert text into time)
TINV (percentiles of the t-distribution)
Title (of charts)
Title bar
TODAY (current date)
Toolbar
Toolbars for Android/iOS
customize
user interface
Toolbars for classic menus
create user-defined icons
customize
delete
locked
manage
position
rename
reset
show/hide
user interface
visible in mode
Top row, freeze
Touch mode
Trace to error
Transformation (of TextArt objects)
Transparency (of pictures)
Transpose
matrix (MTRANS)
ribbon command Data | Edit
TRANSPOSE (transpose matrix)
TREND (values of a linear regression)
Trendline (in charts)
TRIM (remove spaces from text)
TRIMMEAN (mean without marginal values)
TRUE (logical value TRUE)
TRUNC (truncate a number)
TTEST (t-test)
TYPE (type of a value)
- U -
Underline (font)
Undo (changes)
Ungroup
cells (outliner)
objects
Unit conversion (CONVERT)
Unit of measure
Unpinned files
Unpinned templates
Up/down bars (in charts)
Update
charts
external references
pivot tables
worksheet (calculations)
Updates
Upper
option for the charcater format
PROPER (function)
UPPER (function)
UPPER (convert text to upper case)
Use left Alt as shortcut key
Use OpenGL engine
Use SHM extensions
Use system file dialogs
Use system menus
Use XIM
User dictionaries
User info
User info (USERFIELD)
User interface (ribbon or menus?)
User interface on Android/iOS
User interface size
User-defined number formats
USERFIELD (output user info)
- V -
VALUE (convert text into a number)
Value axis (in charts)
VAR (variance of a sample)
VAR.P (variance of entire population)
VAR.S (variance of a sample)
VARA (variance of a sample)
Variance
of a sample (VAR)
of a sample (VAR.S)
of a sample (VARA)
of entire population (VAR.P)
of entire population (VARP)
of entire population (VARPA)
VARP (variance of entire population)
VARPA (variance of entire population)
VBA scripts
Version management
Vertical alignment
of cell contents
of text frames
of text in AutoShapes
Vertical text
View
edit mode
full screen
object mode
touch mode
windows
zoom level
View side by side (windows)
Visibility
columns
rows
worksheet
Visual Basic
VLOOKUP (look up column-wise)
- W -
Walls (in charts)
Warning if a formula contains errors
Watch window
Weber function (BESSELY)
Week number
ISOWEEK
ISOWEEKNUM
WEEKNUM
WEEKDAY (weekday)
WEEKNUM (week number)
WEIBULL (Weibull distribution)
WEIBULL.DIST (Weibull distribution)
Width of a column
Window
close all
view side by side
Workbook
Workbook properties
Workbook protection
disable
enable
WORKDAY (date after x workdays)
Workdays
count (NETWORKDAYS)
date after x workdays (WORKDAY)
Worksheet
alternating shade
change properties
change sheet direction
copy
delete
hide sheet
insert
move
rename
select multiple
show sheet
visibility
Worksheet register
change color
display
font size
Worksheets
edit
format
protect
select
update calculations
Workspace color
Wrap text
- X -
X axis (in charts)
XLS file format
XLSX file format
XNPV (net present value)
XOR (logical XOR function)
XY scatter chart
- Y -
Y axis (in charts)
YEAR (year of a date)
- Z -
Z axis (in charts)
Z.TEST (z-test)
Zeros, show/hide
for number formats of cells
worksheet properties
Zoom level (view)
z-test
Z.TEST
ZTEST
ZTEST (z-test)