New Objects in 2010

AboveAverage 
FormatRow (Property)(Removed in 2010)
AddIn 
IsOpen (Property)Returns True if the add-in is currently open. Boolean Read-only
AddIns2 (new)A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.
Application 
SaveISO8601Dates (Property)This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications.
FileValidation (Property)Returns or sets how Excel will validate files before opening them. Read/write
ProtectedViewWindows (Property)Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only
FileExportConverters (Property)Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
HinstancePtr (Property)Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Read-only Variant.
FileValidationPivot (Property)Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
SmartArtLayouts (Property)Returns the set of SmartArt layouts that are currently loaded in the application. Read-only
AddIns2 (Property)Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only
HighQualityModeForGraphics (Property)Returns or sets whether Excel uses high quality mode to print graphics. Read/write
ActiveProtectedViewWindow (Property)Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Read-only. Returns Nothing if there are no Protected View windows open. Read-only
PrintCommunication (Property)Specifies whether communication with the printer is turned on. Boolean Read/write
SmartArtColors (Property)Returns the set of color styles that are currently loaded in the application. Read-only
IsSandboxed (Property)Returns True if the specified workbook is open in a Protected View window. Read-only
SmartArtQuickStyles (Property)Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only
UseClusterConnector (Property)Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write
ClusterConnector (Property)Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins. Read/write
AnswerWizard (Property)(Hidden in 2010)
Assistant (Property)(Hidden in 2010)
SmartTagRecognizers (Property)(Hidden in 2010)
MacroOptions (Method)(Changes in 2010)
AxisTitle 
Formula (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1Local (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaLocal (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height (Property)Returns the height, in points, of the object. Read-only.
FormulaR1C1 (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Width (Property)Returns the width, in points, of the object. Read-only.
CalculatedMember 
Dynamic (Property)Returns whether the specified named set is recalculated with every update. Read-only
FlattenHierarchies (Property)Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write
HierarchizeDistinct (Property)Returns or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube. Read/write
DisplayFolder (Property)Returns the display folder name for a named set. Read-only
CalculatedMembers 
Add (Method)(Changed in 2010)
Chart 
PrintedCommentPages (Property)Returns the number of comment pages that will be printed for the current chart. Read-only
ShowLegendFieldButtons (Property)Returns or sets whether to display legend field buttons on a PivotChart. Read/write
ShowValueFieldButtons (Property)Returns or sets whether to display the value field buttons on a PivotChart. Read/write
ShowReportFilterFieldButtons (Property)Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write
ShowAllFieldButtons (Property)Returns or sets whether to display all field buttons on a PivotChart. Read/write
ShowAxisFieldButtons (Property)Returns or sets whether to display axis field buttons on a PivotChart. Read/write
ChartArea 
RoundedCorners (Property)True if the chart area of the chart has rounded corners. Read/write Boolean.
ChartTitle 
Formula (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaLocal (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
FormulaR1C1Local (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaR1C1 (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Height (Property)Returns the height, in points, of the object. Read-only.
Width (Property)Returns the width, in points, of the object. Read-only.
ColorFormat 
Brightness (Property)Returns or sets the luminosity of the specified object. Read/write
ColorScale 
FormatRow (Property)(Removed in 2010)
CubeField 
HierarchizeDistinct (Property)Returns or sets whether to order and remove duplicates when displaying the specified hierarchy field in a PivotTable report based on an OLAP cube. Read/write
FlattenHierarchies (Property)Returns or sets whether items from all levels of the specified hierarchy field are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write
Databar 
BarFillType (Property)Returns or sets how a data bar is filled with color. Read/write
AxisPosition (Property)Returns or sets the position of the axis of the data bars specified by a conditional formatting rule. Read/write
AxisColor (Property)Returns the color of the axis for cells with conditional formatting as data bars. Read-only
Direction (Property)Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write.
NegativeBarFormat (Property)Returns the NegativeBarFormat object associated with a data bar conditional formatting rule. Read-only
BarBorder (Property)Returns an object that specifies the border of a data bar. Read-only
DataBarBorder (new)Represents the border of the data bars specified by a conditional formatting rule.
  
DataLabel 
FormulaR1C1 (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height (Property)Returns the height, in points, of the object. Read-only.
FormulaR1C1Local (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width (Property)Returns the width, in points, of the object. Read-only.
Formula (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
DisplayFormat (new)Represents the display settings for an associated Range object. Read only.
  
DisplayUnitLabel 
Formula (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1 (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal (Property)Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height (Property)Returns the height, in points, of the object. Read-only.
FormulaR1C1Local (Property)Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width (Property)Returns the width, in points, of the object. Read-only.
FileExportConverter (new)Represents a file converter that is used to save files.
  
FileExportConverters (new)A collection of FileExportConverter objects that represent all the file converters available for saving files.
  
FillFormat 
PictureEffects (Property)Returns an object that represents the picture or texture fill for the specified fill format. Read-only
GradientAngle (Property)Returns or sets the angle of the gradient fill for the specified fill format. Read/write
FormatCondition 
FormatRow (Property)(Removed in 2010)
IconCriterion 
Icon (Property)Returns or specifies the icon for a criterion in an icon set conditional formatting rule. Read/write
IconSetCondition 
FormatRow (Property)(Removed in 2010)
LineFormat 
InsetPen (Property)Returns or sets whether lines are drawn inside the specified shape's boundaries. Read/write
ListObject 
AlternativeText (Property)Returns or sets the descriptive (alternative) text string for the specified table. Read/write
Summary (Property)Returns or sets the description associated with the alternative text string for the specified table. Read/write
NegativeBarFormat (new)Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
  
OLEDBConnection 
LocaleID (Property)Returns or sets the locale identifier for the specified connection. Read/write
CalculatedMembers (Property)Returns the CalculatedMembers collection for the specified connection. Read-only
Reconnect (Method)Drops and then reconnects the specified connection.
PictureFormat 
Crop (Property)Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Read-only
PivotCell 
MDX (Property)Returns a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source. Read-only
CellChanged (Property)Returns whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. Read-only
DataSourceValue (Property)Returns the value last retrieved from the data source for edited cells in a PivotTable report. Read-only
DiscardChange (Method)Discards changes to the specified cell in a PivotTable report.
AllocateChange (Property)Performs a writeback operation on the specified cell in a PivotTable report based on an OLAP data source.
PivotField 
RepeatLabels (Property)Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write
PivotTable 
ShowValuesRow (Property)Returns or sets whether the values row is displayed. Read/write
AllocationMethod (Property)Returns or sets what method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
EnableWriteback (Property)Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write.
AlternativeText (Property)Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write
Slicers (Property)Returns the Slicers collection for the specified PivotTable. Read-only
VisualTotalsForSets (Property)Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write
AllocationValue (Property)Returns or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
ChangeList (Property)Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Read-only
AllocationWeightExpression (Property)Returns or sets the MDX weight expression to use when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
Summary (Property)Returns or sets the description associated with the alternative text string for the specified table. Read/write
Allocation (Property)Returns or sets whether to run an UPDATE CUBE statement for each cell is edited, or only when the user chooses to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. Read/write
CalculatedMembersInFilters (Property)Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write
CommitChanges (Method)Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.
RepeatAllLabels (Method)Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.
RefreshDataSourceValues (Method)Retrieves the current values from the data source for all edited cells in a PivotTable report that is in writeback mode.
DiscardChanges (Method)Discards all changes in the edited cells of a PivotTable report.
AllocateChanges (Method)Performs a writeback operation for all edited cells in a PivotTable report based on an OLAP data source.
PivotTableChangeList (new)Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.
  
Point 
Width (Property)Returns the width, in points, of the object. Read-only.
Name (Property)Returns the object name. Read-only.
Top (Property)Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Read-only.
Height (Property)Returns the height, in points, of the object. Read-only.
Left (Property)Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only.
PieSliceLocation (Property)Returns the vertical or horizontal position of a point on a chart item, in points, from the top or left edge of the object to the top or left edge of the chart area.
ProtectedViewWindow (new)Represents a Protected View window.
  
ProtectedViewWindows (new)A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.
  
Range 
SparklineGroups (Property)Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Read-only
DisplayFormat (Property)Returns a DisplayFormat object that represents the display settings for the specified range. Read-only
SmartTags (Property)(Hidden in 2010)
BorderAround (Method)(Changed in 2010)
DiscardChanges (Method)Discards all changes in the edited cells of the range.
ClearHyperlinks (Method)Removes all hyperlinks from the specified range.
AllocateChanges (Method)Performs a writeback operation for all edited cells in a range based on an OLAP data source.
Series 
InvertColorIndex (Property)Returns or sets the fill color for negative data points in a series. Read/write
InvertColor (Property)Returns or sets the fill color for negative data points in a series. Read/write
PlotColorIndex (Property)Returns an index value that is used internally to associate series formatting with chart elements. Read-only
SeriesCollection 
Add (Method)(Changed in 2010)
Paste (Method)(Changed in 2010)
Shape 
SmartArt (Property)Returns an object that represents the SmartArt associated with the shape. Read-only
Title (Property)Returns or sets the title of the alternative text associated with the specified shape. Read/write
HasSmartArt (Property)Returns whether there is a SmartArt diagram present on the specified shape. Read-only
ShapeRange 
Title (Property)Returns or sets the title of the alternative text associated with the specified shape range. Read/write
Shapes 
AddSmartArt (Method)Creates a new SmartArt graphic with the specified layout.
Slicer (new)Represents a slicer in a workbook.
  
SlicerCache (new)Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.
  
SlicerCacheLevel (new)Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.
  
SlicerCacheLevels (new)Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.
  
SlicerCaches (new)Represents the collection of slicer caches associated with the specified workbook.
  
SlicerItem (new)Represents an item in a slicer.
  
SlicerItems (new)Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.
  
SlicerPivotTables (new)Represents information about the collection of PivotTables associated with the specified SlicerCache. object
  
Slicers (new)A collection of Slicer objects.
  
SmartTag 
Application (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
DownloadURL (Property)(Hidden in 2010)
Name (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
Properties (Property)(Hidden in 2010)
Range (Property)(Hidden in 2010)
SmartTagActions (Property)(Hidden in 2010)
XML (Property)(Hidden in 2010)
Delete (Property)(Hidden in 2010)
SmartTagAction 
ActiveXControl (Property)(Hidden in 2010)
Application (Property)(Hidden in 2010)
CheckboxState (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
ExpandHelp (Property)(Hidden in 2010)
ListSelection (Property)(Hidden in 2010)
Name (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
PresentInPane (Property)(Hidden in 2010)
RadioGroupSelection (Property)(Hidden in 2010)
TextboxText (Property)(Hidden in 2010)
Type (Property)(Hidden in 2010)
Execute (Method)(Hidden in 2010)
SmartTagActions 
Application (Property)(Hidden in 2010)
Count (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
Item (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
SmartTagOptions 
Application (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
DisplaySmartTags (Property)(Hidden in 2010)
EmbedSmartTags (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
SmartTagRecognizer 
Application (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
Enabled (Property)(Hidden in 2010)
FullName (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
progID (Property)(Hidden in 2010)
SmartTagRecognizers 
Application (Property)(Hidden in 2010)
Count (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
Item (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
Recognize (Property)(Hidden in 2010)
SmartTags 
Application (Property)(Hidden in 2010)
Count (Property)(Hidden in 2010)
Creator (Property)(Hidden in 2010)
Parent (Property)(Hidden in 2010)
Add (Method)(Hidden in 2010)
SparkAxes (new)Represents the settings for the horizontal and vertical axes of a group of sparklines.
  
SparkColor (new)Represents the color of the markers for points in a sparkline.
  
SparkHorizontalAxis (new)Represents the settings for the horizontal axes of a group of sparklines.
  
Sparkline (new)Represents a single sparkline.
  
SparklineGroup (new)Represents a group of sparklines.
  
SparklineGroups (new)Represents a collection of sparkline groups.
  
SparkPoints (new)Represents the settings of the markers for points of data on a sparkline.
  
SparkVerticalAxis (new)Represents the settings for the vertical axes of a group of sparklines.
  
SpellingOptions 
ArabicStrictAlefHamza (Property)Returns or sets whether the spelling checker uses rules regarding Arabic words beginning with an alef hamza. Read/write
ArabicStrictTaaMarboota (Property)Returns or sets whether the spelling checker uses rules to flag Arabic words ending with haa instead of taa marboota. Read/write
BrazilReform (Property)Returns or sets the mode for checking the spelling of Brazilian Portuguese. Read/write
ArabicStrictFinalYaa (Property)Returns or sets whether the spelling checker uses rules regarding Arabic words ending with the letter yaa. Read/write
RussianStrictE (Property)Returns or sets whether the spelling checker uses rules regarding Russian words containing special characters. Read/write
PortugalReform (Property)Returns or sets the mode for checking the spelling of European Portuguese. Read/write
SpanishModes (Property)Returns or sets the mode for checking the spelling of Spanish. Read/write
TableStyle 
ShowAsAvailableSlicerStyle (Property)Returns or sets if the specified table style is shown as available in the slicer styles gallery. Read/write
TextFrame 
HorizontalOverflow (Property)Returns or sets the horizontal overflow setting for the specified object. Read/write
VerticalOverflow (Property)Returns or sets the vertical overflow setting for the specified object. Read/write
TextFrame2 
NoTextRotation (Property)Returns or sets whether text remains flat when the specified object is rotated. Read/write
Top10 
FormatRow (Property)(Removed in 2010)
UniqueValues 
FormatRow (Property)(Removed in 2010)
ValueChange (new)Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.
  
Workbook 
ActiveSlicer (Property)Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. Read-only.
SlicerCaches (Property)Returns the SlicerCaches object associated with the workbook. Read-only.
AccuracyVersion (Property)Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. Read/write
DefaultSlicerStyle (Property)Specifies the style from the TableStyles object that is used as the default style for slicers. Read/write.
SmartTagOptions (Property)(Hidden in 2010)
CheckIn (Method)(Changed in 2010)
RecheckSmartTags (Method)(Hidden in 2010)
CheckInWithVersion (Method)Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally.
Worksheet 
PrintedCommentPages (Property)Returns the number of comment pages that will be printed for the current worksheet. Read-only
SmartTags (Property)(Hidden in 2010)
WorksheetFunction 
Aggregate (Method)Returns an aggregate in a list or database.
Beta_Dist (Method)Returns the beta cumulative distribution function.
Beta_Inv (Method)Returns the inverse of the cumulative distribution function for a specified beta distribution. That is, if probability = Beta_Dist(x,...), then Beta_Inv(probability,...) = x.
Binom_Dist (Method)Returns the individual term binomial distribution probability.
Binom_Inv (Method)Returns the inverse of the individual term binomial distribution probability.
Ceiling_Precise (Method)Returns the specified number rounded to the nearest multiple of significance.
ChiSq_Dist (Method)Returns the chi-squared distribution.
ChiSq_Dist_RT (Method)Returns the right-tailed probability of the chi-squared distribution.
ChiSq_Inv (Method)Returns the inverse of the left-tailed probability of the chi-squared distribution.
ChiSq_Inv_RT (Method)Returns the inverse of the right-tailed probability of the chi-squared distribution.
ChiSq_Test (Method)Returns the test for independence.
Confidence_Norm (Method)Returns a value that you can use to construct a confidence interval for a population mean.
Confidence_T (Method)Returns the confidence interval for a population mean, using a Student's t distribution.
Covariance_P (Method)Returns population covariance, the average of the products of deviations for each data point pair.
Covariance_S (Method)Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
Erf_Precise (Method)Returns the error function integrated between zero and lower_limit.
ErfC_Precise (Method)Returns the complementary error function integrated between the specified value and infinity.
Expon_Dist (Method)Returns the exponential distribution. Use EXPON_DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON_DIST to determine the probability that the process takes at most 1 minute.
F_Dist (Method)Returns the F probability distribution.
F_Dist_RT (Method)Returns the right-tailed F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school and determine if the variability in the females is different from that found in the males.
F_Inv (Method)Returns the inverse of the F probability distribution.
F_Inv_RT (Method)Returns the inverse of the right-tailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x.
F_Test (Method)Returns the result of an F-test. An F-test returns the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public and private schools, you can test whether these schools have different levels of test score diversity.
Floor_Precise (Method)Rounds the specified number to the nearest multiple of significance.
Gamma_Dist (Method)Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.
Gamma_Inv (Method)Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x.
GammaLn_Precise (Method)Returns the natural logarithm of the gamma function, G(x).
HypGeom_Dist (Method)Returns the hypergeometric distribution. HYPGEOM_DIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOM_DIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.
ISO_Ceiling (Method)Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
LogNorm_Dist (Method)Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.
LogNorm_Inv (Method)Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.
Mode_Mult (Method)Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.
Mode_Sngl (Method)Returns the most frequently occurring, or repetitive, value in an array or range of data.
NegBinom_Dist (Method)Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.
NetworkDays_Intl (Method)Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
Norm_Dist (Method)Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.
Norm_Inv (Method)Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Norm_S_Dist (Method)Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Norm_S_Inv (Method)Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.
Percentile_Exc (Method)Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Percentile_Inc (Method)Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile.
PercentRank_Exc (Method)Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PercentRank_Inc (Method)Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK_INC to evaluate the standing of an aptitude test score among all scores for the test.
Poisson_Dist (Method)Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in one minute.
Quartile_Exc (Method)Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Quartile_Inc (Method)Returns the quartile of a data set based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE_INC to find the top 25 percent of incomes in a population.
Rank_Avg (Method)Returns the rank of a number in a list of numbers; that is its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.
Rank_Eq (Method)Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)
StDev_P (Method)Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
StDev_S (Method)Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
T_Dist (Method)Returns a Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed.
T_Dist_2T (Method)Returns the two-tailed Student t-distribution.
T_Dist_RT (Method)Returns the right-tailed Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.
T_Inv (Method)Returns the left-tailed inverse of the Student t-distribution.
T_Inv_2T (Method)Returns the t-value of the Student t-distribution as a function of the probability and the degrees of freedom.
T_Test (Method)Returns the probability associated with a Student t-Test. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.
Var_P (Method)Calculates variance based on the entire population.
Var_S (Method)Estimates variance based on a sample.
Weibull_Dist (Method)Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.
WorkDay_Intl (Method)Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
Z_Test (Method)Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, Z_TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) that is, the observed sample mean.

Events

To see a list of all the events, please refer to the Events page.

ProtectedViewWindowActivateApplicationOccurs when a Protected View window is activated.
SheetPivotTableBeforeCommitChangesApplicationOccurs before changes are committed against the OLAP data source for a pivot table.
ProtectedViewWindowBeforeCloseApplicationOccurs immediately before a Protected View window or a workbook in a Protected View window closes.
SheetPivotTableBeforeDiscardChangesApplicationOccurs before changes to a pivot table are discarded.
SheetPivotTableAfterValueChangeApplicationOccurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeAllocateChangesApplicationOccurs before changes are applied to a pivot table.
WorkbookNewChartApplicationOccurs when a new chart is created in any open workbook.
ProtectedViewWindowOpenApplicationOccurs when a workbook is opened in a Protected View window.
ProtectedViewWindowBeforeEditApplicationOccurs immediately before editing is enabled on the workbook in the specified Protected View window.
ProtectedViewWindowResizeApplicationOccurs when any Protected View window is resized.
ProtectedViewWindowDeactivateApplicationOccurs when a Protected View window is deactivated.
WorkbookAfterSaveApplicationOccurs after the workbook is saved.
   
NewChartWorkbookOccurs when a new chart is created in the workbook.
SheetPivotTableChangeSyncWorkbookOccurs after changes to a pivot table.
SheetPivotTableAfterValueChangeWorkbookOccurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeDiscardChangesWorkbookOccurs before changes to a pivot table are discarded.
SheetPivotTableBeforeAllocateChangesWorkbookOccurs before changes are applied to a pivot table.
SheetPivotTableBeforeCommitChangesWorkbookOccurs before changes are committed against the OLAP data source for a pivot table.
AfterSaveWorkbookOccurs after the workbook is saved.
   
PivotTableChangeSyncWorksheetOccurs after changes to a pivot table.
PivotTableBeforeAllocateChangesWorksheetOccurs before changes are applied to a pivot table.
PivotTableBeforeDiscardChangesWorksheetOccurs before changes to a pivot table are discarded.
PivotTableBeforeCommitChangesWorksheetOccurs before changes are committed against the OLAP data source for a pivot table.
PivotTableAfterValueChangeWorksheetOccurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas).

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext