• Welcome!
  • Technical support
  • About this manual
  • System requirements
• Installation and program startup
  • Installing on Windows
  • Installing on macOS
  • Installing on Linux
  • Installing on Android devices
  • Installing on iOS devices
• Application window
  • Title bar
  • User interface: Ribbon
  • User interface: Classic menus
  • User interface on Android/iOS
  • Context menu
  • Edit toolbar
  • Document tabs
  • Worksheet register
  • Status bar
• Basics
  • The structure of a worksheet
  • Moving within a worksheet
  • Entering data
  • Deleting data
  • Undoing changes
  • Starting a new document
  • Opening a document
  • Printing a document
  • Saving a document
  • Exiting the application
• The PlanMaker tour
  • Some theory to begin with
  • First steps with PlanMaker
  • Entering values and formulas
  • Going three-dimensional
  • Changing the appearance of worksheets
  • Charts
  • Outlook
• Editing worksheets
  • Entering data in cells
  • Undoing changes
  • Repeating commands
  • Selecting cells and cell content
    • Selecting in the Windows, Mac or Linux version
    • Selecting in the Android/iOS version
  • Deleting cells and cell content
    • Deleting the content of cells
    • Deleting whole cells
    • Deleting empty rows
    • Deleting duplicate rows
  • Inserting new cells
  • Inserting copied cells
  • Moving and copying
  • Paste (special)
  • Filling cells automatically
  • Working with multiple worksheets
    • Creating new worksheets
    • Working with the worksheet register
    • Managing worksheets
    • Calculating in three dimensions
  • Naming cell ranges
    • Assigning and editing names for cell ranges
    • Defining names automatically from the selection
    • Creating a list of all named ranges
    • Using named ranges
    • Applying names to existing formulas
  • Transposing cells
  • Splitting text into multiple columns
  • Sorting cells
  • Filtering cells by their content
    • AutoFilter
    • Special filter
  • Analyzing sheets
    • Showing formulas instead of results
    • Syntax highlighting
    • Watch window for cell content
    • Formula auditing
      • Displaying the relationships between cells
      • Detecting errors in calculations
      • Detecting invalid data in cells
  • Updating sheets
  • Using comments
  • Goal seek
  • Scenarios
    • Creating scenarios
    • Showing scenarios
    • Managing scenarios
    • Merging scenarios
    • Creating a scenario summary
  • Consolidating data
    • Consolidating data by position
    • Consolidating data by labels
    • Editing and updating consolidations
  • Tables in worksheets
    • Creating tables in worksheets
    • Ribbon tab "Table"
    • Removing tables from worksheets
    • Editing tables in worksheets
    • Formatting tables in worksheets
    • Using the total row of tables in worksheets
    • Tables in worksheets and cell references
  • Pivot tables
    • Creating a new pivot table
      • Creating a pivot table with existing data
      • Creating a pivot table with imported data
    • Starting with the pivot table field list
      • Exercises for structuring the field list
      • Working with the field list: Fields section
      • Working with the field list: Areas section
      • Further options in the field list
    • Configuring pivot tables with the field list
      • Field settings (Row/Column labels area)
      • Value settings (Values area) 
      • Pivot table settings
      • Defer layout update
    • Sorting and filtering pivot tables
    • Grouping pivot tables
    • Updating pivot tables and changing data area
    • Deleting, copying, moving pivot tables
  • Freezing rows and columns
  • Inserting special characters
• Formatting worksheets
  • Cell size
    • Changing cell sizes via the mouse
    • Changing cell sizes via commands
    • Showing and hiding rows/columns
  • Number format
    • List of all number formats
    • Working with custom number formats
    • Structure of a custom number format
  • Borders
  • Shading
  • Alignment
  • Protection
  • Character format
    • Font and font size
    • Text styles
    • Font color
    • Superscripts and subscripts
    • Letter spacing and character pitch
    • Kerning
    • Resetting the character formatting
  • Paragraph format (text frames only)
    • Paragraph indents (text frames only)
    • Line spacing (text frames only)
    • Paragraph alignment (text frames only)
    • Spacing above/below a paragraph (text frames only)
  • Character styles
    • Creating character styles
    • Applying character styles
    • Changing character styles
    • Scope of character styles
    • "Normal" character style
    • "Based on" character styles
  • Cell styles
    • Applying cell styles
    • Creating cell styles
    • Editing cell styles
    • "Normal" cell style
  • Document templates
    • Creating document templates
    • Using document templates
    • Editing document templates
    • "Normal.pmvx" document template
  • AutoFormat
  • Conditional formatting
    • Creating new formatting rules
    • Types of conditional formatting
    • Managing formatting rules
    • Removing conditional formatting
  • Input validation
    • Settings for input validation
    • Detect invalid data
  • Format painter
  • Page setup
    • Setting page format
    • Setting page format options
    • Setting up header and footer
    • Adjusting page breaks manually
• Searching and replacing
  • Search
  • Replace
  • Repeating a search/replace
  • Advanced search options
  • Jumping to specific cell addresses
  • Jumping to specific elements of a table
• Objects
  • Objects – basic procedures
    • Inserting objects
    • Selecting objects
    • Object mode
    • Changing position and size of objects
    • Rotating and flipping objects
    • Changing the order of objects
    • Duplicating objects
    • Changing the names of objects
    • Aligning and distributing objects
    • Grouping objects
    • Hiding objects
    • Changing the AutoShape of objects
    • Combining shapes
    • Editing shapes retroactively
    • Rotation of the inner text
    • Vertical alignment of the inner text
    • Changing text area for the inner text
    • Showing the contents of a cell in objects
    • Changing object properties via the dialog box
      • Object properties, Format tab
      • Object properties, Fill tab
      • Object properties, Lines tab
      • Object properties, Shadow tab
      • Object properties, 3D tab
      • Object properties, Effects tab
      • Object properties, Properties tab
      • Object properties, AutoShapes tab
      • Additional tabs
      • Changing the default settings for objects
  • Text frames
    • Inserting text frames
    • Changing text frame properties via the ribbon tab
    • Changing text frame properties via the dialog box
  • Pictures
    • Inserting pictures
    • Scanning pictures
    • Inserting pictures from the gallery/camera (Android and iOS)
    • Compressing pictures
    • Changing picture properties via the ribbon tab
    • Changing picture properties via the dialog box
  • OLE objects
    • Inserting OLE objects
    • Editing OLE objects
    • Editing links to OLE objects
    • Changing OLE object properties via the ribbon tab
    • Changing OLE object properties via the dialog box
    • Using the SoftMaker Equation Editor
  • Drawings
    • Inserting drawings
    • Adding text to AutoShapes
    • Changing drawing properties via the ribbon tab
    • Changing drawing properties via the dialog box
      • AutoShapes tab (available only for AutoShapes)
      • Inner text tab (available only for AutoShapes with text)
      • Text tab (available only for TextArt objects)
      • Transformation tab (available only for TextArt objects)
  • QR codes/Barcodes
• Charts
  • Inserting charts
  • Editing charts
    • Changing the chart type
    • Changing the arrangement of data series
    • Showing/hiding chart elements
      • Showing/hiding axes and axis titles
      • Showing/hiding chart titles
      • Showing/hiding data labels
      • Showing/hiding error bars
      • Showing/hiding gridlines
      • Showing/hiding the legend
      • Showing/hiding lines
      • Showing/hiding the trendline
      • Showing/hiding up/down bars
    • Editing chart elements
      • Chart area
      • Plot area
      • Walls (three-dimensional charts only)
      • Floor (three-dimensional charts only)
      • Corners (three-dimensional charts only)
      • Data series and data points
      • Trendlines
      • Category axis (X axis)
      • Value axis (Y axis)
      • Series axis (Z axis)
      • Axis title
      • Chart title
      • Gridlines
      • Legend
    • Changing chart properties via the dialog box
      • Chart properties, Format tab
      • Chart properties, Properties tab
      • Chart properties, Chart type tab
      • Chart properties, Data source tab
      • Chart properties, Series tab
      • Chart properties, Elements tab
      • Chart properties, 3D view tab
      • Chart properties, Radar tab
  • Updating charts
  • Moving charts to another worksheet
  • Saving charts as pictures
• Forms
  • Working with form objects
    • Inserting form objects
    • Editing form objects
    • Using and evaluating form objects
    • Form objects and Excel macros and scripts
  • Form objects in detail
    • Checkboxes
      • Changing the properties of checkboxes
    • Radio buttons
      • Changing the properties of radio buttons
    • Dropdown lists
      • Changing the properties of dropdown lists
    • Listboxes
      • Changing the properties of listboxes
    • Pushbuttons
      • Changing the properties of pushbuttons
    • Spinners
      • Changing the properties of spinners
    • Scrollbars
      • Changing the properties of scrollbars
    • Labels and groupboxes
      • Changing the properties of labels and groupboxes
  • Options of the contextual ribbon tab "Object"
• Language tools
  • Setting the language
  • Spell check
    • Manual spell check
    • Checking the spelling as you type
    • Editing user dictionaries
  • Hyphenation
    • Hyphenation in text frames
    • Hyphenation in table cells
  • Auto correction
    • Options tab
    • Auto correction tab
    • First letter tab
    • Initial Caps tab
  • SmartText
    • Creating SmartText entries
    • Inserting SmartText entries
    • Editing SmartText entries
  • Research
  • Read aloud
• Document management
  • Quick paths
  • Document summary
  • File manager
  • Searching with the file manager
  • Backup copies (file versions)
• Outlines
  • Grouping cells
  • Showing/hiding grouped cells
  • Changing outline settings
• Using hyperlinks
• Outputting documents
  • Print preview
  • Printing a document
  • Exporting a document as a PDF file
  • Sending a document by e-mail
• Protecting cells and documents
  • Sheet protection
    • Step 1: Setting up protection settings for cells
    • Step 2: Enabling sheet protection
    • Disabling sheet protection
  • Workbook protection
    • Enabling workbook protection
    • Disabling workbook protection
  • Document protection
    • Enabling document protection
    • Disabling document protection
• Working with other file formats
  • Saving and opening files in other file formats
  • Notes on the text format
  • Notes on the Excel format
    • Opening and saving Excel files
    • Differences between PlanMaker and Excel
  • Notes on the HTML format
• Working with Arabic text
  • Enabling extended support for Arabic text
  • Changing the text direction in table cells
  • Changing the text direction in text frames
  • Changing the direction of worksheets
• Scripts (BasicMaker)
• Working with multiple documents
  • Creating or opening a document
  • Switching between open documents
  • Arranging documents on the screen
  • Closing a document
• Customizing PlanMaker
  • Changing PlanMaker settings
    • Settings, View tab
    • Settings, General tab
    • Settings, Edit tab
    • Settings, Appearance tab
    • Settings, Language tab
    • Settings, Files tab
    • Settings, Backup tab
    • Settings, System tab
    • Settings, Fonts tab
    • "Manage" button
  • Exporting/importing settings
  • Changing document properties
    • Document properties, Summary tab
    • Document properties, Colors tab
    • Document properties, Statistics tab
    • Document properties, Options tab
    • Document properties, Calculate tab
    • Document properties, Protection tab
    • Document properties, Fonts tab
  • Changing worksheet properties
  • Customizing the document display
    • Zoom level
    • Full screen view
    • Dark document mode
  • Customizing the ribbon
    • Showing and hiding the ribbon
    • Customizing icons and groups in the ribbon
    • Changing the position of the Quick access toolbar
    • Customizing icons on the Quick access toolbar
  • Customizing toolbars
    • Showing and hiding toolbars
    • Positioning toolbars on the screen
    • Managing toolbars
    • Customizing toolbar icons
    • Using the toolbar menu
  • Creating user-defined icons
  • Customizing shortcut keys
  • Editing lists for automatic filling
  • Installing dictionaries
    • Installing additional dictionaries
    • Choosing a different dictionary for a language
• Formulas and functions
  • Formula basics
    • Operators in formulas
  • Entering formulas
  • Relative versus absolute cell references
  • External cell references
    • Entering external cell references
    • Updating and managing external cell references
  • Error values
  • Working with arrays
  • Working with database functions
  • Functions from A to Z
    • ABS (absolute value)
    • ACOS (arccosine)
    • ACOSH (inverse hyperbolic cosine)
    • ACOT (arccotangent)
    • ACOTH (inverse hyperbolic cotangent)
    • ADDRESS (cell address as text)
    • AND (logical AND function)
    • AREAS (number of areas)
    • ASIN (arcsine)
    • ASINH (inverse hyperbolic sine)
    • ATAN (arctangent)
    • ATAN2 (arctangent 2)
    • ATANH (inverse hyperbolic tangent)
    • AVEDEV (average deviation)
    • AVERAGE (arithmetic mean)
    • AVERAGEA (arithmetic mean)
    • AVERAGEIF (average if condition is true)
    • AVERAGEIFS (average if conditions are true)
    • B (compatibility function)
    • BASE (convert decimal number into another base)
    • BESSELI (modified Bessel function In(x))
    • BESSELJ (Bessel function Jn(x))
    • BESSELK (modified Bessel function Kn(x))
    • BESSELY (Bessel function Yn(x))
    • BETADIST (beta distribution)
    • BETA.DIST (beta distribution)
    • BETAINV (percentiles of the beta distribution)
    • BETA.INV (percentiles of the beta distribution)
    • BIN2DEC (binary number to decimal number)
    • BIN2HEX (binary number to hexadecimal number)
    • BIN2OCT (binary number to octal number)
    • BINOMDIST (binomial distribution)
    • BINOM.DIST (binomial distribution)
    • BINOM.DIST.RANGE (binomial distribution)
    • BINOM.INV (binomial distribution)
    • CEILING (round up to a multiple of base)
    • CELL (information about a cell)
    • CHAR (character from ANSI code)
    • 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 for independence)
    • CHITEST (chi-square test for independence)
    • CHOICE (x>0, x=0, x<0?)
    • CHOOSE (choose value from list)
    • CLEAN (remove non-printable characters)
    • CODE (ANSI code of a character)
    • COLUMN (column number of cells)
    • COLUMNS (number of columns in a range)
    • COMBIN (combinations)
    • COMPLEX (create complex number)
    • CONCAT (concatenate strings from list)
    • CONCATENATE (concatenate text strings)
    • CONFIDENCE (confidence interval)
    • CONFIDENCE.NORM (confidence interval)
    • CONVERT (unit conversion)
    • CORREL (correlation coefficient)
    • COS (cosine)
    • COSH (hyperbolic cosine)
    • COT (cotangent)
    • COTH (hyperbolic cotangent)
    • COUNT (number of cells filled with numbers)
    • COUNTA (number of cells filled)
    • COUNTBLANK (number of empty cells)
    • COUNTIF (count if condition is true)
    • COUNTIFS (count if conditions are true)
    • COUNTP (PlanMaker 97 compatibility function)
    • COVAR (population covariance)
    • COVARIANCE.P (population covariance)
    • COVARIANCE.S (sample covariance)
    • CREATEDATE (date the document was created)
    • CRITBINOM (binomial distribution)
    • CUMIPMT (cumulative interest)
    • CUMPRINC (cumulative principal)
    • CURRENCY (format number as currency)
    • DATE (create a date value)
    • 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)
    • DCOUNT (database function)
    • DCOUNTA (database function)
    • DDB (double-declining balance depreciation)
    • DEC2BIN (decimal number to binary number)
    • DEC2HEX (decimal number to hexadecimal number)
    • DEC2OCT (decimal number to octal number)
    • DECIBEL (decibel value of two quantities)
    • DECIMAL (convert number from any base into decimal)
    • DECIMALS (fractional part of a number)
    • DEGREES (convert radians to degrees)
    • DELTA (test for equality)
    • DEVSQ (average square deviation)
    • DGET (database function)
    • DMAX (database function)
    • DMIN (database function)
    • DOLLARDE (convert to dollar price decimal)
    • DOLLARFR (convert to dollar price fraction)
    • DPRODUCT (database function)
    • DSTDEV (database function)
    • DSTDEVP (database function)
    • DSUM (database function)
    • DVAR (database function)
    • DVARP (database function)
    • EDATE (date before/after n months)
    • EFFECT (effective interest rate)
    • EOMONTH (end of month in n months)
    • ERF (Gaussian error function)
    • ERFC (complement to Gaussian error function)
    • ERROR.TYPE (error type)
    • EUROCONVERT (convert EU currencies)
    • EVEN (round up to next even number)
    • EXACT (compare texts)
    • EXP (power of e)
    • EXPONDIST (exponential distribution)
    • EXPON.DIST (exponential distribution)
    • FACT (factorial)
    • FACTDOUBLE (double factorial)
    • FALSE (logical value FALSE)
    • FDIST (F distribution)
    • F.DIST.RT (F distribution)
    • FILENAME (file name of the document)
    • FIND (search for text in a text string)
    • FINV (percentiles of the F distribution)
    • F.INV.RT (percentiles of the F distribution)
    • FISHER (Fisher transformation)
    • FISHERINV (inverse of the Fisher transformation)
    • FIXED (format number as text with fixed decimals)
    • FLOOR (round down to a multiple of base)
    • FORECAST (forecast using linear regression)
    • FORMULATEXT (display formula contained in cell)
    • FREQUENCY (frequency)
    • FTEST (F-test)
    • F.TEST (F-test)
    • FV (future value)
    • FVSCHEDULE (future value)
    • GAMMA (gamma function)
    • GAMMADIST (gamma distribution)
    • GAMMA.DIST (gamma distribution)
    • GAMMAINV (percentiles of the gamma distribution)
    • GAMMA.INV (percentiles of the gamma distribution)
    • GAMMALN (logarithm of the gamma function)
    • GAUSS (standard normal distribution)
    • GCD (greatest common divisor)
    • GEOMEAN (geometric mean)
    • GESTEP (number greater or equal to threshold value?)
    • GETPIVOTDATA
    • GROWTH (values of an exponential regression)
    • HARMEAN (harmonic mean)
    • HEX2BIN (hexadecimal number to binary number)
    • HEX2DEC (hexadecimal number to decimal number)
    • HEX2OCT (hexadecimal number to octal number)
    • HLOOKUP (look up row-wise)
    • HOLIDAY (dates of movable Christian holidays)
    • HOUR (hour)
    • HYPERLINK (hyperlink)
    • HYPGEOMDIST (hypergeometric distribution)
    • HYPGEOM.DIST (hypergeometric distribution)
    • IF (if-then-else condition)
    • IFEMPTY (return a value if cell is empty)
    • IFERROR (return a value if error)
    • IFNA (return defined value for #N/A)
    • IFS (first condition met)
    • 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)
    • 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 a complex number)
    • IMSUB (difference of complex numbers)
    • IMSUM (sum of complex numbers)
    • INDEX (cell in a particular row/column of a range)
    • INDIRECT (create reference from text)
    • INT (round down to nearest integer)
    • INTERCEPT (intercept point of a regression line)
    • INTERSECTION (intersection of two ranges)
    • IPMT (interest payment)
    • IRR (internal rate of return)
    • ISBLANK (is empty?)
    • 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?)
    • KURT (kurtosis)
    • LARGE (k-th largest number)
    • LASTPRINTED (date last printed)
    • LASTSAVED (date last saved)
    • LCM (least common multiple)
    • LEFT (left part of a text string)
    • LEN (length)
    • LINEST (statistics of a linear regression)
    • LN (natural logarithm)
    • LOG (logarithm)
    • LOG10 (base-10 logarithm)
    • LOGEST (statistics of an exponential regression)
    • LOGINV (percentiles of the log-normal distribution)
    • LOGNORMDIST (log-normal distribution)
    • LOGNORM.DIST (log-normal distribution)
    • LOGNORM.INV (percentiles of the log-normal distribution)
    • LOOKUP (search cell range)
    • LOWER (convert text to lowercase)
    • MATCH (relative position in a range)
    • MAX (maximum)
    • MAXA (maximum)
    • MAXIFS (conditional maximum)
    • MDETERM (matrix determinant)
    • MEDIAN (Median)
    • MID (part of a text string)
    • MILLISECONDS (milliseconds)
    • MIN (minimum)
    • MINA (minimum)
    • MINIFS (conditional minimum)
    • MINUTE (minute)
    • MINVERSE (inverse matrix)
    • MIRR (modified internal rate of return)
    • MMULT (product of matrices)
    • MOD (remainder of a division, Excel method)
    • MODE (most frequently occurring value)
    • MODE.SNGL (most frequently occurring value)
    • MODP (remainder of a division, PlanMaker method)
    • MONTH (month of a date)
    • MROUND (round to a multiple of base)
    • MSOLVE (solution of matrix equation Ax=B)
    • MULTINOMIAL (multinomial coefficient)
    • N (convert value into number)
    • NA (error value #N/A)
    • NEG (negative value)
    • NEGBINOM.DIST (negative binomial distribution)
    • NEGBINOMDIST (negative binomial distribution)
    • NETWORKDAYS (number of workdays)
    • NOMINAL (nominal interest rate)
    • NORMDIST (normal distribution)
    • NORM.DIST (normal distribution)
    • NORMINV (percentiles of the normal distribution)
    • NORM.INV (percentiles of the normal distribution)
    • NORMSDIST (standard normal distribution)
    • NORM.S.DIST (standard normal distribution)
    • NORMSINV (percentiles of the standard distribution)
    • NORM.S.INV (percentiles of the standard distribution)
    • NOT (logical NOT function)
    • NOW (current date and time)
    • NPER (number of periods)
    • NPV (net present value)
    • NUMBERVALUE (convert text into a number, locale)
    • OCT2BIN (octal number to binary number)
    • OCT2DEC (octal number to decimal number)
    • OCT2HEX (octal number to hexadecimal number)
    • ODD (round up to next odd number)
    • OFFSET (shifted reference)
    • OR (logical OR function)
    • PEARSON (Pearson correlation coefficient)
    • 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 (permutations)
    • PHI (standard normal distribution)
    • PI (constant value of pi)
    • PMT (payment)
    • POISSON (Poisson distribution)
    • POISSON.DIST (Poisson distribution)
    • POLYNOMIAL (polynomial coefficient)
    • POWER (power)
    • PPMT (payment on the principal)
    • PROB (probability)
    • PRODUCT (product)
    • PROPER (convert text to upper/lower case)
    • PV (present value)
    • QUARTILE (quartiles of a data set)
    • QUARTILE.EXC (quartiles of a data set)
    • QUARTILE.INC (quartiles of a data set)
    • QUOTIENT (quotient of a division)
    • RADIANS (convert degrees to radians)
    • RAND (random value)
    • RANDBETWEEN (random value)
    • 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)
    • REPLACE (replace text in a text string)
    • REPT (repeat text string)
    • RIGHT (right part of a text string)
    • ROMAN (Roman numeral)
    • ROOTN (n-th root)
    • ROUND (round to n digits)
    • ROUNDDOWN (round down to n digits)
    • ROUNDUP (round up to n digits)
    • ROW (row number of cells)
    • ROWS (number of rows in a range)
    • RRI (interest for fixed-interest investments)
    • RSQ (square of Pearson)
    • SEARCH (search for text in a text string)
    • SECOND (second)
    • SERIESSUM (sum of a power series)
    • SHEET (index of a worksheet)
    • SHEETNAME (name of a worksheet)
    • SHEETNUMBER (compatibility function)
    • SHEETS (number of worksheets)
    • SIGN (sign of a number)
    • SIN (sine)
    • SINH (hyperbolic sine)
    • SKEW (skewness of a distribution)
    • SLN (straight-line depreciation)
    • SLOPE (slope of a linear trend)
    • SMALL (k-th smallest number)
    • SORTM (sort)
    • SORTV (sort)
    • SQRT (square root)
    • SQRTPI (square root of x*Pi)
    • STANDARDIZE (standardized value)
    • STDEV (standard deviation of a sample)
    • STDEVA (standard deviation of a sample)
    • STDEVP (standard deviation of entire population)
    • STDEV.P (standard deviation of entire population)
    • STDEVPA (standard deviation of entire population)
    • STDEV.S (standard deviation of a sample)
    • STEYX (standard error of a linear regression)
    • SUBSTITUTE (replace text in a text string)
    • SUBTOTAL (calculations without hidden cells)
    • 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)
    • SWITCH (categorize initial value)
    • SYD (sum-of-years’ digits depreciation)
    • T (convert value into text string)
    • TAN (tangent)
    • TANH (hyperbolic tangent)
    • TDIST (t-distribution)
    • T.DIST (t-distribution)
    • T.DIST.2T (t-distribution two-tailed)
    • T.DIST.RT (t-distribution right-tailed)
    • TEXT (convert number into text string)
    • TEXTJOIN (concatenate strings with separators)
    • TIME (create time)
    • TIMEDIFF (time difference)
    • TIMEVALUE (convert text into time)
    • TINV (percentiles of the t-distribution)
    • T.INV (percentiles of the t-distribution left-tailed)
    • T.INV.2T (percentiles of the t-distribution two-tailed)
    • TODAY (current date)
    • TRANSPOSE (transpose matrix)
    • TREND (values of a linear regression)
    • TRIM (remove spaces from text)
    • TRIMMEAN (mean without marginal values)
    • TRUE (logical value TRUE)
    • TRUNC (truncate a number)
    • TTEST (t-test)
    • T.TEST (t-test)
    • TYPE (type of a value)
    • UPPER (convert text to uppercase)
    • USERFIELD (output user info)
    • VALUE (convert text into a number)
    • VAR (variance of a sample)
    • VARA (variance of a sample)
    • VARP (variance of entire population)
    • VAR.P (variance of entire population)
    • VARPA (variance of entire population)
    • VAR.S (variance of a sample)
    • VLOOKUP (look up column-wise)
    • WEEKDAY (weekday)
    • WEEKNUM (week number)
    • WEIBULL (Weibull distribution)
    • WEIBULL.DIST (Weibull distribution)
    • WORKDAY (date after x workdays)
    • XIRR (internal rate of return)
    • XNPV (net present value)
    • XOR (logical XOR function)
    • YEAR (year of a date)
    • ZTEST (z-test)
    • Z.TEST (z-test)
• Appendix
  • Ribbon commands and corresponding menu commands
  • Shortcut keys
    • Shortcut keys in Windows and Linux versions
    • Shortcut keys in Mac version
  • Command-line parameters