Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel ROW Function
  • How to get address of named range in Excel
  • How to get first row number in range in Excel
  • Extract all partial matches in Excel
  • How to get address of first cell in range in Excel

Data Analysis Examples

  • How to Create Gantt Chart in Excel
  • How to create Gauge Chart in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Filter Data Based on Date in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells
  • Excel Data validation whole percentage only

Tag: AMORLINC function

AMORLINC function: Description, Usage, Syntax, Examples and Explanation

by

What is AMORLINC function in Excel? AMORLINC function is one of the Financial functions in Microsoft Excel that returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. Syntax of AMORLINC …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Split dimensions into three parts in Excel
  • Extract most frequently occurring text in Excel
  • How to check cell contains which things in Excel
  • MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Count birthdays by month in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Next working/business day in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • How to calculate present value of annuity in excel
  • How to calculate principal for given period in Excel
  • Calculate payment periods for loan in Excel
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles