entre of Power
Повышайте свои навыки работы в Excel
MS Excel: Grouping Financial Data by Date Range with SUMIFS (advanced)
MS Excel: Using Sheet Names from Cells in Formulas for automation
MS Excel: Symbolic Operators, Complete Guide to Special Characters in Formulas
MS Excel: AND function (examples, syntax and combination with IF)
MS Excel: AVERAGE function ( AVERAGEIF and AVERAGEIFS)
MS Excel: COUNT function (comparison with COUNT, COUNTA, and COUNTBLANK)
MS Excel: COUNTA function (sintax, COUNTA and COUNTBLANK)
MS Excel: COUNTBLANK function (Usage and Mistakes)
MS Excel: COUNTIF function (how to use and common mistakes)
MS Excel: DATEIF function (errors and troubleshooting)
MS Excel: IF function (with error handling and VLOOKUP)
MS Excel: IFERROR function (syntax and arguments)
MS Excel: IFS function (from basic to advanced usage)
MS Excel: INDEX function, from Basic to Advanced
MS Excel: LEFT function, beginner to advanced explanation
MS Excel: MAX function, full understanding
MS Excel: MID Function, extracting Text from the Middle Like a Pro
MS Excel: OR Function, syntax and advanced explanation
MS Excel: RIGHT, from Basics to Advanced Use
MS Excel: ACCRINT function for security interest calculation
MS Excel: ACCRINTM for accrued interest
MS Excel: AMORDEGRC function for depreciation
MS Excel: AMORLINC function for depreciation
MS Excel: COUPDAYBS function for bond settlement date
MS Excel: COUPDAYS function for coupon period
MS Excel: COUPDAYSNC function for bond pricing
MS Excel: COUPNCD function for coupon date
MS Excel: COUPNUM function for interest payment
MS Excel: COUPPCD function for accrued interest
MS Excel: CUMIPMT function for cumulative interest
MS Excel: CUMPRINC function for loan payment
MS Excel: DB function for depreciation
MS Excel: DDB function for depreciation
MS Excel: DISC function for discounted price calculation
MS Excel: DURATION function for Macaulay duration
MS Excel: EFFECT function for EAR and AER
MS Excel: FV function for future value calculation
MS Excel: FVSCHEDULE function to calculate future value
MS Excel: INTRATE function for interest rate calculation
MS Excel: IRR function to calculate rate of return
MS Excel: ISPMT function to calculate interest paid
MS Excel: MDURATION function for modified Macaulay
MS Excel: MIRR function to assume realistic rate
MS Excel: NOMINAL function to calculate annual rate
MS Excel: NPER function to pay off a loan
MS Excel: NPV function to calculate Net Present Value
MS Excel: ODDFPRICE to calculate the bond price
MS Excel: ODDFYIELD function to calculate annual yield
MS Excel: ODDLYIELD function the annual yield
MS Excel: ODDLPRICE function when the last period is irregular
MS Excel: PDURATION function for number of periods calculation
MS Excel: PMT function to calculate the fixed payment
MS Excel: PPMT function to calculate loans / mortgages / installment
MS Excel: PRICE function to calculate the bond price
MS Excel: PRICEDISC function to determine price with discount rate
MS Excel: PRICEMAT function calculate the price per $100 face value
MS Excel: PV function to calculate present value
MS Excel: RATE function to calculate periodic interest rate
MS Excel: RECEIVED function to calculate maturity amount
MS Excel: RRI function for equivalent compound interest rate
MS Excel: SLN function for annual depreciation expense
MS Excel: SYD function to calculate accelerated depreciation
MS Excel: TBILLEQ function for treasury bills
MS Excel: TBILLPRICE function for treasury bill
MS Excel: TBILLYIELD function for yield of a treasury bill
MS Excel: VDB function to calculate depreciation of an asset
MS Excel: XIRR for annualized rate of return
MS Excel: XNPV to calculate net present value
MS Excel: YIELD function to calculate annual yield
MS Excel: YIELDDISC function for annual yield on discount securities
MS Excel: YIELDMAT function for interest at maturity
MS Excel: FALSE function for logical operations
MS Excel: IFNA function to handle N/A output
MS Excel: NOT function to return opposite of a value / expression
MS Excel: SWITCH function to compare expression
MS Excel: TRUE function to return true value
MS Excel: XOR function to evaluate logical conditions
MS Excel: ARRAYTOTEXT function for single text string
MS Excel: BAHTTEXT function to convert Thai number to text
MS Excel: CHAR function to convert numeric values into characters
MS Excel: CLEAN function to remove non-printable characters
MS Excel: CODE function to return numeric code for the first character
MS Excel: CONCAT function to combine text
MS Excel: DOLLAR function convert number to currency format
MS Excel: EXACT function to compare two text strings
MS Excel: FIND function to locate the position of a substring
MS Excel: FIXED function to round and format a number as text
MS Excel: LEN function for calculating number of characters
MS Excel: LET function assigns results names to calculation results
MS Excel: LOWER function for converting uppercase text to lowercase
MS Excel: NUMBERVALUE function for conversion to actual numeric values
MS Excel: PROPER function to capitalize first letter of each word
MS Excel: REPLACE function to replace with new text string
MS Excel: REPT function to repeat text string number of times
MS Excel: SEARCH function to find position of a text
MS Excel: SUBSTITUTE function to replace text string
MS Excel: T function to handle texts
MS Excel: TEXT function for text formatting
MS Excel: TEXTJOIN function to combine text
MS Excel: TRIM function to remove extra spaces from text string
MS Excel: UNICHAR function to return unicode character
MS Excel: UNICODE function to get unicode of any character
MS Excel: UPPER function to convert text to uppercase
MS Excel: VALUE function to convert text to numbers
MS Excel: VALUETOTEXT function to convert into text string
MS Excel: DATE function to create valid dates from year, month, and day
MS Excel: DATEVALUE function to convert date value
MS Excel: DAY function to extract day numbers from dates
MS Excel: DAYS function to calculate days between two dates
MS Excel: DAYS360 function for day count calculations of financial modelling
MS Excel: EDATE function to add or subtract months from a date
MS Excel: HOUR function to extract the hour from time hour
MS Excel: ISOWEEKNUM function to return the ISO week number from a date
MS Excel: MINUTE function for extracting minute portion from value
MS Excel: MONTH function to extract minute from date - time value
MS Excel: NETWORKDAYS function to calculate the number of working days
MS Excel: NETWORKDAYS.INTL function for # of workdays between workdays
MS Excel: NOW function to return the current date and time
MS Excel: SECOND function to extract second component
MS Excel: TIME function to create time values from hour, minute and second
MS Excel: TIMEVALUE function for converting text to recognized time format
MS Excel: TODAY function to return the current date automatically
MS Excel: WEEKDAY function determine the day of the week from any date
MS Excel: WEEKNUM function to get the week number from any date
MS Excel: WORKDAY function calculate working days
MS Excel: WORKDAY.INTL function for advanced workday calculation with custom weekends
MS Excel: YEAR function for extracting the year from a date
MS Excel: YEARFRAC function calculate fraction of a year between two dates
