Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
      Popular categories

       Automate

       Charts

       Compare

       Conditional formatting

       Count values

       Dates

       Drop down lists

       Misc

       Pivot tables

       Search/Lookup

       Sort values

       Tables

       Templates

       UDF

       VBA

       Vlookup

      • Advertise Here

      Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


      Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    Get Digital Help > Excel > Finance

    Archive for the ‘Finance’ Category

    Sum security holdings monthly and yearly in a pivot table
    Compare your stock portfolio with S&P500 in excel
    Adjust stock chart axis automatically
    Add buy and sell points to a stock chart
    Excel udf: Import historical stock prices from yahoo – added features
    Excel udf: Import historical stock prices from yahoo
    Sum unique distinct invoices in excel 2007
    Bill reminder in excel
    Cash drawer bill extractor template in excel
    Excel udf: Find positive and negative amounts that net to zero
    Excel udf: Find numbers in sum
    Tracking a stock portfolio #2 in excel
    Tracking a stock portfolio in excel (auto update)
    Schedule recurring expenses in a calendar in excel (Personal Finance)
    Calculate your stock portfolio performance with Net Asset Value based on units in excel
    Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
    Calculate your stock portfolio performance in excel
    Dynamic stock chart in excel – Add date ranges
    Create a dynamic stock chart using a web query and a drop down list in excel
    Scan stock markets in excel
    Stock alerts in excel
    Learn how to create a stock chart in excel
    « previous entries
    Next Page »
    • Subscribe subscribe  
    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.
    • Recent Comments

      • William on Create a unique distinct list of a long list without sacrificing performance using vba in excel
      • Jan on Formula for matching a date within a date range in excel
      • Durgesh on Calculate your stock portfolio performance in excel
      • Durgesh on Calculate your stock portfolio performance in excel
      • Alaa Abdullnabi on Merge two columns with possible blank cells in excel (formula)
      • Glenda on Populate a list box with visible unique values from an excel table (vba)
      • Anil R. on Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
      • Oscar on Auto refresh a pivot table in excel
      • Beth on Sum values in a range where adjacent cell value equals a criterion in excel
      • Oscar on Use multiple conditions in Vlookup
    • Recent Posts

      • Count students
      • Use a map in an excel chart
      • SEARCH and FIND functions
      • Yet another excel calendar
      • MMULT function – Matrix multiplication
      • SMALL function and LARGE function
      • Copy/Rename a file (excel vba)
      • Assign each person with randomly unique objects as a daily activity
      • ROW function explained
      • Highlight duplicates in a filtered excel defined table
    Oscar Cronquist