Syntax:
CLOSINGBALANCEMONTH(<expression>,<dates>,[<filter>])
Parameters:
expression: An expression that returns a scalar value.
dates: A column that contains dates.
filter: (optional) An expresion that specifies a filter to apply to the current context
Action:
Evaluates the expression at the lat date of the month in the current context.
Creates a new, blank workbook
there are 1,048,576 rows and 16,384 columns in one worksheet
 |
| using VLOOKUP function |
Displays the Go To dialog box.
F5 also displays this dialog box.
Display the Find and Replace dialog box, with the Find tab selected.
You can find the data or text using the Ctrl+F
Unhide Columns
Unhide any didden columns within the selection.
Adds more value to the active column by using data surrounding that column.
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Copies the selected cells.
Syntax:
EDATE(<start_date>, <month>)
Parameters:
start_date: A date in datetime or text format that represents the start date.
month: An integer that represents the number of months before or after start_date.
Action:
Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Syntax:
DATEVALUE(<date_text>)
Parameters:
date_text: Text that represents a date.
Action:
Converts a date in the form of text to a date in datetime format.
Syntax:
DATEDIFF(<start_date>, <end_date>), <interval>)
Parameters:
start_date: Any DAX expression that returns a datetime value.
end_date: Any DAX expression that returns a datetime value.
interval: The interval to use when comparing dates. The value can be one of the following:
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
Action:
Returns the count of interval boundaries crossed between two dates.
Hold the Ctrl key and press Enter
Action:
Fills the selected cell range with the current entry.
Hold the Ctrl key and press Spacebar
Action:
Selects an entire column in a worksheet.
Hold the Ctrl key and press Arrow Key
Action:
Moves to the edge of the cuttent data region in a worksheet.
Hold the Ctrl key and press 9 (eight numaric key)
Action:
Hides the selected rows.
Hold the Ctrl key and press 8 (eight numaric key)
Action:
Display or hides the outline symbols.
Hold the Ctrl key and press 6 (six numaric key)
Action:
Alternates between hiding and displaying objects.
Hold the Ctrl key and press 5 (five numaric key)
Action:
Applies or removes strikethrough.
