Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles Products
  • Contact
    About me Blogs I read

    Stock portfolio

    Calculating NAV-units

    Compare the performance of your stock portfolio to S&P 500 using Excel

    Tracking a stock portfolio in excel (auto update)

    Calculate your stock portfolio performance with Net Asset Value based on units in excel

    Automate net asset value (NAV) calculation on your stock portfolio

    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


'Stock portfolio' category



test
Compare the performance of your stock portfolio to S&P 500 using Excel
Table of Contents Compare the performance of your stock portfolio to S&P 500 Tracking a stock portfolio in Excel (auto […]
test
Automate net asset value (NAV) calculation on your stock portfolio
Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories


Home page
Excel Functions
Excel Formulas
Excel Tables
Advanced Filter
Data Validation
Drop Down List
Named Ranges
Excel Solver
Charts
Conditonal Formatting
Pivot Tables
VBA
Macros
UDFs
Archive

      • Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup

  • Search website

Privacy PolicyNo AI