test
  • Home
  • Templates
  • 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

      Most Popular Blog Posts

      How to extract a unique distinct list from a column

      How to return multiple values using vlookup

      Create a date range using excel formula

      Count unique distinct values in a column

      Sorting text cells using array formula

      How to create a dynamic chart

      Match two criteria and return multiple rows

      Merge two columns into one list

      Lookup with multiple criteria and display multiple search results using excel formula

      Find latest date in a list

    • 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.
    • Random Data Generator 250x250 ad 3
    • 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.


    You are here: Home >> Excel >> Finance

    Archive for the ‘Finance’ Category

    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 »
    • Add RSS 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

      • Dale Basnett on Advanced Gantt Chart Template
      • mei on Highlight overlapping date ranges using conditional formatting in excel
      • JG743 on Merge two columns into one list in excel
      • Oscar on Dynamic Gantt charts in excel 2007
      • Mohamed Ismail on Dynamic Gantt charts in excel 2007
      • Cyril on Auto resize columns as you type
      • Oscar on Auto resize columns as you type
      • Harry on Create a unique distinct sorted list containing both numbers text removing blanks in excel
      • Harry on Create a unique distinct sorted list containing both numbers text removing blanks in excel
      • Noa on Vlookup across multiple sheets in excel
    • Recent Posts

      • Advanced Gantt Chart Template
      • Auto resize columns as you type
      • Search with conditional formatting
      • Tracking calls in excel
      • Free School Schedule Template
      • Copy a cell range whose size is likely to change from time to time (vba)
      • Easily identify groups of duplicate rows
      • List all open workbooks and corresponding sheets (vba)
      • Basic data entry (vba)
      • List all tables and corresponding headers in a workbook (vba)