Excel Templates, Excel Chart Templates, Excel Downloads – Free

Welcome to Free Excel Templates page. Thanks for visiting. We have 100s of free templates, tutorials and examples on Chandoo.org. In this page, I have shared our top 20 templates. Please feel free download them and use them as you see fit.

Invoice template

Make invoices and quotations for your business from this beautiful and simple template. Save them as PDF to email.

Invoice template

Invoice template

Sales funnel chart template

Track sales progress thru this interactive and dynamic funnel chart. Use it alone or as part of a report. Make charts and copy paste them to Power Point / Word / Email easily.

Sales funnel chart template

Funnel template

Employee Training Tracker

Keep track of various training programs in your business using this template. Understand which ones are over-subscribed, which programs are on, how they are rated etc.

Employee Training Tracker

Employee Training Tracker

Monthly planner template

Plan a month with clean and simple layout and reusable template.

Monthly planner template

Monthly planner template

To-do list template

Set up a to-do list, assign priorities to items and keep track of them with this template.

To-do list template

To-do list template

Conference / meeting agenda template

Plan a conference or one-day event with this template. Enter event details, durations etc. and see everything in one page.

Conference / meeting agenda template

Agenda template

Monthly shift / roster template

Maintain a monthly roster / shift register with this elegantly designed template. See when you (or your team) will be in, when they are away etc.

Monthly shift / roster template

Shift template

Overdue items tracker

Keep missing invoices or items? Use this tracker to see which items are overdue (beyond due date) and which items are on time.

Overdue items tracker

Overdue tracker

2018 calendar & daily planner template

A dynamic calendar and daily planner for all your needs. Set up events, anniversaries, important dates and view them in beautiful, printable template.

2018 calendar & daily planner template

2018 calendar & daily planner

Gantt chart template

Make a stunning and useful gantt chart to keep track of project activities using this project planning template. If you want more, check out my project management template bundle too (link in page).

Gantt chart template

Gantt chart template

Simple Gantt chart template

Set up an elegant and easy to use Gantt chart with this template.

Simple Gantt chart template

Simple Gantt chart template

Project Status Dashboard

Got a big project on hand. Use this clean and powerful layout to see where everything is and keep track of the project.

Project Status Dashboard

Project Status Dashboard

Project Portfolio Dashboard

Manage several projects? Then use my project portfolio dashboard to see where everything is and how you can improve things or where you should focus your energies.

Project Portfolio Dashboard

Project Portfolio Dashboard

Project Issue Tracker

Working on a project with lots of issues or risks? Use this template to understand the issues, track them and assign them to team members for best results.

Project Issue Tracker

Project Issue Tracker

Business Dashboard Templates

Create stunning business dashboards using this paid template and wow your clients and bosses. You can make 16 different layouts from single file.

Business Dashboard Templates

Business Dashboard Templates

Simple KPI Dashboard template

Make a simple KPI dashboard to showcase various metrics and how they tracked over time.

Simple KPI Dashboard template

Simple KPI Dashboard template

Budget vs. Actual Chart

Create an awesome budget vs. actual chart to see which items / departments / teams / products are over budget and by what amount.

Budget vs. Actual Chart

Budget vs. Actual Chart

Simple monthly budget template

Simple template to keep track of your personal finances and view how many you can save. Stay on top of money with this.

Simple monthly budget template

Budget template

Christmas gift shopping tracker

Got a lot of gifts to buy and people to please. Use this tracker to stay on top of your holiday gifting budget and see whether you have been a good Santa.

Christmas gift shopping tracker

Christmas gift tracker

FIFA World cup 2018 tracker and points table

Live points table, bracket view and schedule of matches in your time zone using Excel and Power Query.

FIFA World cup 2018 tracker and points table

FIFA World cup tracker

Do you need something else?

Looking for other templates? Please use below links as well or post a comment.

Like this article? Please sign-up for our free email news letter or add our RSS Feeds to your reading list to receive excel tips, charting ideas every weekday.

464 Responses to “Excel Templates, Excel Chart Templates, Excel Downloads – Free”

    • harish says:

      Dear Chandoo,

      i just got introduced to your site by accident. but wonderful stuff.

      do you have an excel to keep track of dates like passport expiry, visa date, credit card expiry and other crucial dates tracker in excel format.

      kindly assist.

      best regards

      harish bhatia

    • udaya says:

      Awesome and very informative site!

    • Sachin Agrawal says:

      Hi Guys,

      I'm here to share a game application created by me in excel-VBA.

      Try this exciting e-Housie application at -


      -Sachin Agrawal

      • Ajay Sharma says:


        My self ajay sharma from HARIDWAR uttarakhand

        I want to track Dairy division sales officer field working


        Plz help me out

    • E. Tauber says:

      I downloaded one of your template work books (project-status-dashboard-xl2007{1}. I am very grateful and appreciate the template. However, I found that it is locked and I have not found a way to open it for editing. Is there a way that I can unlock it to make edits? (example, "project budapest", I am trying to help a couple of nurses how to use excel to track a small project and report on it. I thought of myself (in healthcare) as pretty ok with Excel, but you are the Master! and I just a padawan. I stumbled on you site and have been blown away! Thank you in advance for sharing so much and showing me so many things I did not even know was possible.

      • sudheer says:

        Dear Tauber,

        I am looking for a similar kind dashboard to track our insurance claims applied by our employees and give access to the management and the vendor with TAT compliance. pl. share me the sheet if you have prepared a dashboard. I would be thankful to you and it will be a great help for me.

    • Sandeep Singh says:

      how to convert numeric values into Text.

      Example :
      Suppose I type 4500 it should display FOUR THOUSAND FIVE HUNDRED..
      is it possible in Excel. if you have any formula please reply.

      • Guru says:

        You have to add an extra module for this in excel using VB Code, which you can get by searching on the internet Or try using ASAP Utilities free home edition or Try out 60 day Trial of KuTools.

    • Cami says:

      Hi Chandoo,

      Great site!!!

      Where can I find the Excel Template for the Holiday Request Form. I have just came across it on youtube and it's exactly what I need.

      Please help.


    • Victoria says:

      What a wonderful site! I jst wish I could maximize the potential of it all. I'm jst a beginner in excel & I think its an awesome progrm!! I knw enough to knw thr is a way to get the result tht I need but not a clue of how to get thr. In the past I've utilized some amazingly orchestrated sprdshts tht were jst well thought out and produced some sort of end result. The cmpany I'm at now does not use many sprdshts. If thy do, thy are just lists of some sort with no end result. I'm in HR and I use about 7 diffrnt staffng agencies for open positions we have. I get the ok to open an existing position or details on typing up and posting as a new position. I thn email open job to agency(s) who are more inclined to particular job. They, in turn, fwd me resumes (lots and lots) of candidates. I fwd them to mgr of dept & thy tell me yes or no to set up an interview. We go through quite a few applicants before we find the right one. First, I think it would be best if evry resume recvd was put in spreadsheet, because theres quite a few times i'm having to go back and look through all these resumes that a manager remembers seeing with a certain skill set they are looking for. So I have stacks and stacks of resumes in my office and Im getting frustrated. Thinking if I input all the pertinent info of applicant, like date applied, which position, agency they came from, whether they interviewed or not, outcome of interview etc.etc. I could then have an applicant database and at the same time get a clearer picture on which agency is sending us the right kind of candidates with skill sets were looking for and which agency is working best. Like I said I know what I want it to do, but no clue how to get there. Any ideas or help would be greatly appreciated.

    • Vishal Mathur says:

      I have two columns with 16 digit numbers. I want to find which numbers in column 2 matches with the numbers of column 1.
      What formula should I use for this? Countif or vlookup?

    • Jason Lago says:

      I've been trying to make two different calculators and can't seem to get them right. One is a domestic shipping rate calculator.. Plug in a zipcode, and package details then it will show best rates for the main shipping avenues.

      The other one is an options trading calculator.. that will keep track of previous trades and performance.

      Hope you can help! or have some of your own. Thanks

    • Sangram Jawalekar says:

      I want to make a robust NPS dashboard.

  1. Chandoo says:

    test comment.... just to see if page level comments work

  2. [...] Rockstar with these 5 tips 2. Excel can be Exciting - 15 fun things you can do in MS Excel 3. 25 Free excel downloadable templates and workbooks 4. 73 high quality excel chart templates, download and make awesome charts 5. 15 Excel formulas you [...]

  3. Waseem Nawaz says:

    Hi Chandoo,
    I am trying to locate one of your posts re how to prepare a market share chart. (preferably Bars). Can you please help me locate this.

  4. Chandoo says:

    @Waseem: You can find the entire discussion related to mkt share displays here: http://chandoo.org/wp/2008/11/14/excel-charting-alternatives-market-share-data/

    We haven't posted any tutorials or download books for this.

  5. Senthil says:

    in excel i have sales quandity and sales value, if i use pivot chart the sales qty& value is coming parallely. But i need the value should come below the total quandity
    as follows
    product Sales qty
    paste 50
    Brush 100
    Blade 500
    total Qty 650
    Value 1900
    pl kindly guide me

  6. Deepak Krishnan says:

    Hi Chandoo,
    This is first time, I am visiting you blog site and very impressive. I have been working with excel for last 7 years...still a first time learner. Anyways, I am currently using Office 2007, and it is good with some features compared to 2003, and I also remember you mentioned about the Classic menu, and I found a link from where you can download to get a classic Menu.


    Hope this helps. 🙂

    • Chandoo says:

      @Deepak: Welcome and thanks for the nice words you say. and thank you so much for sharing the classic menu link. While I enjoy the excel 2003 menu structure and familiarity, I am trying very hard (and enjoying it equally) to learn the ribbon UI and where everything went in 2007. So far the experience is good 🙂

      Keep visiting the blog and I am sure you will like many more ideas and content featured here.

      • Meggaable says:

        Hello Chandoo, I am very pleased and glad about your great work on the net. In fact I must tell confess...YOUR "GENIUS". Please Chandoo, I need Excel Report Card Template that can handle both High School and Primary. I already have one with me that is also Ok but it is limited to number of Subject, and has some feature to be tune to my need I don't know if you can help with it so it will not need building a fresh one from scratch. I have already mailed you through your Gmail and have also attached the excel template. I will really appreciate this. Thanks and God bless.

  7. [...] the weekend I could get sometime to cleanup few of the pages on the blog. Checkout the free excel spreadsheets page, we now have almost 30 excel spreadsheet files for download neatly arranged in to areas like [...]

  8. Raj Kiran says:

    "Executive Dashboards - Excel Training" - when downloaded is not opening. Please help.

  9. Chandoo says:

    @Raj Kiran : I dont see any issues while downloading the file. Can you try again , may be from a different net connection and let us know.

  10. [...] And here is a huge list of beautiful excel chart templates, around 73 of them. Download and use them free. Get even more in our excel downloads page. [...]

  11. [...] And here is a huge list of beautiful excel chart templates, around 73 of them. Download and use them free. Get even more in our excel downloads page. [...]

  12. amit joshi says:

    I want to know how to use the vlook up in the excel sheet

  13. Raj Kiran says:

    Hi Chandoo,

    Now am able to open the Executive Dashboard.

    Thank you.

  14. JIGNESH MODI says:

    want to make equity stock portfolio tracker in excel like mutual fund portfolio tracker.
    please help me

    • Chandoo says:

      @Jignesh: The ideas are similar to the ones presented in mf portfolio tracker tool. Often the challenge is to get the information in a tabular format.

  15. stan says:

    hi Chandoo,
    your work is impressive! im just wondering if you could create similar chart in access for the report? or any advice on how to use excel charts in access?


  16. [...] to the Pointy Haired Dilbert or straight to the downloads page. google_ad_client = "pub-3795862859156495"; /* Lightbreaker Related Content */ google_ad_slot = [...]

  17. PESfan says:

    Love your site! It has helped me a lot!

  18. sunita says:

    I have been using your MF Portfolio Tracker for the last one month and am extremely surprised for your SUPER invention. Thanks.
    1. Is it possible for you to incorporate an additional coloumn in "Latest NAV Data" Sheet about Launch Dates for the respective schemes ?

    2. Do you have similar Portfolio Tracker for Equity Shares liseted on NSE and BSE ? If yes please mail me its link.

  19. [...] There are tons of resources including an Excel Twitter client.  So if you are the Excel guru or want to be check out this resource.  For a complete list of downloads click here. [...]

  20. Durga says:

    Good Morning Chandoo,

    Thanks for every tips and tricks that are on this site;
    I have been working in excel for past 3 years and was struggling to make good looking Dashboard which finally I found in here.
    It would be nice enough if you could provide more examples on dashboards.........

    Good Day......

  21. Chandoo says:

    @Stan... Thank you.. 🙂 I am sure there are ways to create similar charts in Access (atleast by calling the excel application and creating the charts). But I am not really an access expert. But I think you can use VBA to do this...

    @PESFan... you are welcome


    (1) Launch dates.. hmm, I dont think the URL http://www.amfiindia.com/spages/NAV1.txt provides launch dates. But since these dates are static, you can have them in another table (or named range) and then refer to them in your vlookup. Do you know any good data source for getting the launch dates?

    (2) I have built one using google spreadsheets (you can find it here: http://chandoo.org/wp/2008/09/12/track-stock-mf-portfolio-google-docs/ ) May be you can extend the ideas and use it in Excel (you can get stock quotes by polling yahoo finance or google finance apis..)

    @Durga: Thanks for your comments and Welcome to PHD. We have quite a good number of dashboard related resources here: http://chandoo.org/wp/management-dashboards-excel/
    I write about dashboards or visualizations every now and then. Subscribe to the blog and keep watching... 🙂

  22. stephen says:

    Hi Chandoo,

    Great Website. Am looking for an excel template to store information related to Helpdesk, where information can be stored and can be retrieved at a click of a button when required or asked by any of the customer. A knowledge database kinda stuff but excl based.


  23. Jason says:

    Hello CEO,

    I viewed excel-sorting-text-alphabetically-wth-formulas worksheet, and it was very very nice. You are a very clever guy. Keep up the good work.


  24. Savio says:

    Thank you so much Chandoo. Your website is so impressive. It has really helped me in various projects I have. I wish you all the best and I hope your website becomes a world-wide success.

  25. Revv says:

    Hi Chandoo

    Replicon, a timesheet software provider, has a set of free excel templates for timesheet at http://www.replicon.com/excel-timesheet.aspx. I thought you may find it useful and list it for visitors who are looking for excel timesheets.


  26. Shweta says:

    I have started using MF Portfolio Tracker which is good and useful.

    In Latest NAV Data, I have edited the file as "NAV0" which updates NAVs for Open Ended as well as Close Ended Schemes

    The Problem is :

    1. In the "Portfolio Sheet" if I choose any Scheme which pertains to LESS THAN CELL No. 6518 from the "Latest NAV Data" Sheet , it works fine and the NOW NAV displays the correct Value.

    If we choose a Scheme which belongs to the CELL GREATER than CELL 6518 from the "Latest NAV DATA", then the NOW NAV in the "Portfolio Sheet" shows the words "not found".

    Please help how to get Values of Now NAV if the Scheme is from the Cell Greater than 6518.

  27. Sonu says:

    Hi Chandoo.
    The website and contents are very much useful.
    I highly appreciate your efforts for the work done.
    Please keep this going on forever.


  28. [...] Download Excel Templates at Pointy Haired Dilbert Tagged with: chart-excel • chart-excel-template • excel templates | Need more help ? Ask your Questions at our Support Center | Follow us on Twitter @TSNW or Facebook [...]

  29. SUNIL says:

    how to get the updated NAV in MF Portfolio Tracker. its not getting update automatically while opening the excel sheet.

  30. [...] Free Excel Templates – Download [...]

  31. BxCapricorn says:

    Your candlestick template helped me visualize a way in which to test and then combine my knowledge of Excel Candlestick formulas, with a testing layout for candlestick efficiency. I talk about that here:


    Just wanted you to know that one idea leads to another. Thanks.

  32. Lav says:

    Excellent templates.

    Who so ever has prepared it , Thanks a lot!

  33. Ulrich Seidl says:

    if you are interested in templates for some really tricky Excel-Charts without any programming, have a look at


  34. Robert says:

    Is there an easy [cheap] way to hide several rows based on a value. I have a contact list that is 6 rows by 9 cols for each contact. For some contact lists there are 3 contacts and for some there can be 20. I need to hide the rows that are not populated in the report or be able to expand the preformatted rows based on a value that determines the number of contacts.

  35. Hui... says:

    Try Grouping
    Select Rows or Columns and Alt Shift Right Arrow
    That will leave a small + on the side / top which allows you to hide / unhide the rows/cols
    To ungroup select Rows/Cols and Alt Shift Left Arrow

  36. atul says:

    i am looking after as a public infromation officer under RTI act in a govt organization.as per the act all of the application recieved must be supplied with required information within 30 days.i wish to register every application in MS EXCEL and would like to appply such a formula which can notify me as the 30 th day is close to come.
    for me the problem is how to write a formula which can count the perrticular days for each month as jan is 31,april is 30 like this.
    pls think over and give me yr valuable suggestions

  37. Antonio says:

    Hi Chandoo,

    Can I download these excel templates for use on a mac?


  38. Russ says:

    You can claculate the number of days in each month using the following formula assuming the date is in cell B2:
    Essentially, this just goes to first day of the next month then subtracts a day.

  39. Rick Rothstein (MVP - Excel) says:


    You can combine the "first day minus one" part of your formula directly in the Date function call like this...


    Basically, the zeroeth day of a month is the last day of the previous month.

  40. Chandoo says:

    @Antonio.. I am not sure if the VBA based templates work on mac. Rest of them should work just fine. Let me know if you face any problem.

  41. DavidBrown says:

    can anybody tell me that can excel be used as a database with php ? actually i am developing a site and i have a excel file which contain the data and this data i want to have on the web page , anybody please ,

    David Brown

  42. Chandoo says:

    @David... Interesting question. There are some frameworks based on PHP (or even java, ASP) that can read / write to excel files. You can use one of these to process the excel data. But if all you need is to read the data, you can as well write a VBA macro that will convert excel to access or mysql table and then read that in PHP. Whenever the file changes, just re-run your macro.

    All the best

  43. Kshatrapati says:


    I am looking for a soft copy of 7. Quarter-wise Snapshot of Budget Performance which is a part of "Budget vs. Actual Charts – 14 Charting Ideas You can Use". Kindly help me in locating the excel file of this so that I can understand the concept in entirety.

    Thank you in advance.

  44. Chandoo says:

    @Kshatrapati... These are entries for a contest, I dont have source files. You can try commenting on the post or asking the maker (if URL is available). But a better approach would be to make something like that on your own.

    • Nipendra Dhiman says:

      Hi chandoo,

      It is all awesome really I want to ask one thing only do you have any idea ,
      can we make some longer project to show our business flow by excel vba.
      actually I have worked with vb.Net and ms access database before 3 years there we have lots of tools to prepare a fantastic application and report ,I made some project for school and hotels.
      but now  I want make these types of application with excel vba and ms access database I know how to connect access with vba and I know how use events and classes.  do you have some another sample also in vba where ms access connection used with excel vba on vba user form.
      you must have seen some project like "library management, fee management ,hotel management etc..." somewhere ,i have made these all but in vb.net no enough idea in vba so may you please illuminate something possible or not.


  45. Amit Cohen says:

    I have learned a lot today, thanks for all posts and samples
    I now have lots of home work to do 🙂

  46. Dawn says:

    I am going crazy!!! I need to do a comparison between employees and time ranges to see the common time that they were employed. For instance, Emp 1 worked from 04/04/09 until 07/09/09, Emp 2 worked from 11/15/08 until 06/25/09, etc. I would like to see all of the employees and who was employed at certain time periods. I know that I can do this in a table but I really need to be able to do it in Excel so that I can have the charts for display. Do you have any suggestions?

  47. Chandoo says:

    @Dawn... Welcome to PHD and thanks for the comments.

    You can make a simple scatter plot with lines to show how long each employee has been employed. It is a good representation if you have less than 25 items. If you have large data set, I would probably setup a table with range of dates (starting from say 1/1/2008 to 2/1/2010) one cell for each week or month.

    Then for each employee, I would shade all the cells during which he is employed as gray and rest of the cells with no color. Now, when you reduce the row heights, you can fit a few hundred rows in one view and this can give a picture of how long the employees are usually in the company. You can sort the table by joining date or duration of employment for some interesting insights.

    That said, it all depends on what you want the chart for. What are the questions you are trying to answer?

  48. Tyler says:

    Hi Chandoo,

    Thank you very much for the knowledges you and the others have shared on this web site.

    Is there an easy way to print all the formulas in a worksheet with their cell references on a page? Thank you.


  49. ChrisL says:

    Hi Chandoo,

    I tried creating a sideways barchart using data in rows and stripping out all the unwanted chart features so that just the bars were left, rather like your cricket scores sheet. It looked great, but then I realised that the bars are in reverse order of the data. Where did I go wrong? It must be something really easy, but I can't think what it is.

    I found another way of fixing it - using an array function to reverse the data rows into a different column, then making it the data source, then hiding the reversed data rows under the chart.

  50. Chandoo says:

    @Chris: You need not reverse the values using array formulas. Just go to axis settings, select the option "Reverse categories" to have the values in reverse order in your bar chart.

  51. Chris says:

    Chandoo, Many thanks for your advice on my "sideways" chart. Problem solved. Your site has become my primary source for ideas and techniques. Keep up the good work!

  52. Shahid Ansari says:

    Hi Chandoo, Got your reference from my brother and your friend Shamim.First of all, i am glad to see this website and the content , help and support available. I always had some "Kida" of excel and i am always keen to learn as much as possible

    I have one question for you, do you have any template to make a Fish-bone diagram on Excel, i feel it is possible and i was able to create one automated version of Fish-bone on excel but could not get the formatting right.

    please do share your thoughts on this,

  53. ADNAN ASHRAF says:

    Its Greate.

  54. Dil says:

    Hi Chandoo,

    I work with so many deadlines and i am wondering if there is a Macro or something can remind me at a specific (given) time, so I can enter the times n the name of the deadline and have it reminded well ahead.

    It would be great if you can help me.

    Thank You,

  55. Hui... says:

    What about the Task Manager in Outlook?

  56. Dil says:

    Tnx 4 your sup Hui, But we do not use Task Manager at office.


  57. iyyer says:

    how to make a spreadsheet of ledger cum inward register ?. Only one entry in inward register i will do with ledger folio number. Then automatically the value should get posted in ledger .

    please help me.

  58. Isha Bawa says:

    i am looking for excel sheet where i can put all my policies investment which should give detail of amount we can withdraw in 1st year 2nd year 3rd year etc.
    bond invested details

  59. pekay says:


    I am the first timer on your blog. Found a quite a lot of useful info. I have started using the MF tracker. I want to explore and see if we can add additional capabilities,like consolidation of multiple purchases in same fund, annualized returns apart from absolute returns


  60. MK says:

    I look forward to your articles everyday. Learn something new from each one. Fantastic!

    Just wondering if we can check a string if it contains a certain set of characters with and without macros e.g. if "Water" contains "ate" (True), Bear contains "ate" (False) etc. Can someone help? Thanks.

  61. Brian says:

    Hi Chandoo,

    I heard that excel can be used as a database to track competitors and the competitive history (archive). Is this true and were can I find guidelines to doing this.

    Using excel2007



    • Natalie says:

      Hello Brian,

      Hope that you are well.
      I was just wondering if you managed to obtain the database template, if yes,would you mind sharin it?
      i would appreciate it.

      thank you,

  62. Hui... says:


    This will return the location of the first word in the second or False if not found

  63. vamsi krishna says:

    Hi Chandu,

    your concepts & ideais are very usefull. I have a dout in Excel sheet. i need apply one condition in excel sheet. i will explain you Now i have entered data in one cell when i came out from the cell in secound cell Date & time should be appear and it should not be modify if i edit the DATA in that row or cell. can you plz guide me the condition how to apply. My contact no. 09902366999. it is little bit urgent. plz give me sms. using excel 2003.

  64. Trance says:

    hi Chandoo,

    I am looking for India stock chart quote sheet, which gets updated from google finance.
    It will be great help.


  65. Nitin says:

    Hi Chandoo,

    I am looking for an excel template for INVENTORY system on FIFO and LIFO base. Would appreciate if you could please let me know if you have one....

    Thanks in Advances

    • Chandoo says:

      @Nitin... Welcome to chandoo.org and thanks for comments.

      However, I do not yet have any inventory tracking templates. I would be glad to build one for you on consulting basis. Let me know if you would like to hire me.

  66. Dear Chandoo...the Excel guru!.
    I feel proud to join in your blog. I've been using spreadsheet for more than 25 years...lotus-123...supercalc.....excel....excel2010..... To quench my everlasting lotto thirst, I've developed some sort of dashbard which will help turning an ordinary lotto buyer into smart lotto player! Now, I want it to distribute among various lotto users and I thought it here at chandoo.org the right place to get maximum coverage. I'll be delighted to have your word in affirmative to post the file,
    With regards.

  67. Chandoo says:

    @Lottomaniac... Welcome and thanks for comments.

    While I would love to know how excel is used for understanding lotto better, I would not be willing to feature your link on any gambling related material. I am sorry, but I hope you understand why I am saying this.

  68. Thanks Chandoo! for your swift reply! I'm sorry...overwhelmingly I totally forgot about the legal aspect of gambling ! My spreadsheet will only demonstrate how the excel functions better be used even to predict a game's result with the highest odds! In that I used the just refresh key "F9" to do the wonder! Ok. no problem! I understood your sentiments and the value of your blog!

  69. Jai says:

    these are great to make your understanding much better and grab the knowledge boost.
    Good Luck!!!

  70. Brian says:

    Hi Chandoo ... awsome site ... I found this via a Google search looking for the formula to reverse the order of rows where I have data. I would like the last value to become the 1st value for chart platting purposes. Google re-directed me here and yet I couldnt find it anywhere on your site but I certainly saw a lot of other awsome stuff that I will be downloading. In the meantime ... is there a specific area on your site that can help me with this issue (reversing row orders - and they are NOT linear - the values could be any number but I need them in the exact order but in reverse - bottom to top NOT top to bottom as they are now. One final question ... what was Microsoft think by NOT adding this as a built in feature ... when googling this problem I have seen HUNDREDS of similar answers to this obvioulsy very common poblem ..

    Thanks again for any help or direction adn for the awsome site

  71. Chandoo says:

    @Brian: Welcome to chandoo.org. I am so happy you like my site. 🙂

    Please visit http://chandoo.org/wp/2009/11/19/reverse-a-list-in-excel/ to learn how to reverse a list in excel.

  72. Dear Chandoo

    I have a problem with my Excel it dose not open, when i click on the icon it drops in the lower toolbar when i right click on it and click maximize it opens just 1 second and gose back to toolbar some one told me to remove the office from my laptop and re instule it again, i did that and still i have the same problem.
    please advise how can i get my Excel back again

    My best regards and good weshis

    Adel Faqihi

  73. Hui... says:

    Restart your computer and try again

    When your computer is running Right Click on the Windows Toolbar and select Start Task Manager, on the Processes Tab make sure there isn't any Image Names EXCEL.EXE if there is select them and click the End Process button, remove them all

    Have you loaded any add-ins recently, if so temporarily remove them and try to restart Excel

    Try and restart Excel in Safe Mode, this is a mode that doesn't load any addin's
    There is a great article on this and lots of other ideas that may help at:

    • azarakhsh says:

      Dear Chandoo,
      i see your Birthday Reminder Template , it's very good.
      if is possible for you please answer my question : when open the excel automatic send email and no need to click on the link(sendemail).

      • Aditya says:

        Hi Chandoo,
        I am also trying this scenario : automatic email is sent to the person if date of birth occurs and no need to click on the link(sendemail).
        Please help me with this or send an email to me regarding this.

  74. Toyese says:

    Hi chandoo, i like you to help me out..........By giving me some examples of real life problems that is solved by excel.Kindly mail it to my email........thanks

  75. Hui... says:

    This question is like "How many grains of sand are on a beach?" - pretty much unanswerable ?
    Have a browse through the Forums and Look through the Topics and Archives on the main Chandoo.org page.
    Use the Search function at the top of the page and look for words that fit your interest.
    I will be starting a series of posts shortly on Chandoo.org, which will be solving real world problems with Excel. Each will include worked examples, keep an eye out for those.

  76. Dunzohar says:

    Hi Chandoo, I need to run Excel education to my stuff, do you have a basic Excel prz. ?
    Thank you so much for this website.

  77. sahayaraj says:

    I am using excel for the last 10 years. I do not know the ways to bring the numeric values to alpha - words. for eg 1000 in figures to be displayed as one thousand. Pl tell me options and formulae to bring out a result in alpha

  78. Sankar M says:

    Hi Chandoo, I'm a VBA Developer. Generating Exce baesd repoprts dashboard,trackers & etc, Recently got your blog and its really contains Awesome stuff's...I request to share Excel and VBA white papers documents for reference if you have any.

    Thanks in advance.

  79. anand says:

    I am a project manager and was wondering if like a gantt chart u can develop one for C PM or critical path method for a project using PERT (project evaluation and review technique) and do something creative. It would need to take into account all the constraints and interdependencies of all the tasks. This would be really useful for project managers.

  80. manisha says:

    hi Chandroo. your work is amazing and i'm sure its going to help in future . i 'm working for a music school and classes are happening once in week for one hour. the fee is charged for 12 weeks session. bought a school management software but still EXEL is working for the master fee schedule and master darily schedule. i think generating report from fee schedule is what i wud like to learn! what to do.

  81. Dear Chandoo,

    I'm first time visitor to your site a link provided to me by my friend Dev Kumar Vasudevan. I found the site very interesting and educative. Everybody fancies himself as Excel expert. I wonder if you come out with similar type efforts for other tools like Asp.net, VC++ etc.


    Ashish Kolarkar

  82. Rodel says:

    Your site rocks...and that makes you a rock star!!! Thanks man 🙂

  83. lakshminarayana says:

    i saw article in newpaper i.e.21-11-2010 andhra jyothi daily paper, your idea is excellent
    thank you very much

  84. Pabbathi Nareshkumar says:

    Good morning sir, today is very good day that just i read your article in today telugu paper. I also very much intrested in excel. I am very much intrested to join in Excel 2011 online school. Today is GURU POORNIMA. God shown a good route to drive my life in excel. My guru is also a master in Excel and other programming languages. He is a retired Statistical Officer from Kakatiya Medical College, Warangal. He belongs to Kakinada but he is staying at Hyderabad. He is giving guidance to so many voluntary organisations to reach their targets. I am also belongs to Warangal native but working at NGO, Hyderabad. Thankyou sir once again.

  85. Aas Mohammad says:

    Hi Chandoo,

    I need some awesome formulas list from where i can get

  86. SUDHAKAR PAMU says:

    dear sir,
    i want to learn excel. is it free if i register at your site.please clarify my doubt.
    thanks in advance for your reply.

  87. Ahmad says:

    Hey Chandoo,
    This Website give me a lot of help! I'm looking Some Excel Templates For Inventory Reporting If u have like that Can u please email me or can u upload on this? Some Anylsis & Costing Reports

  88. JRK PRASAD says:

    Hi Chandoo,

    This website I have seen in Eenaadu, Initially when I read in News paper it made me interesting later when I have visited your site. Really made me enthusiastic to learn. Excel is my Favorite Subject / Language. I am eager to learn code language in excel. I can you mail me some formats of Payroll Management

  89. Zein says:

    I just want to tell you that your website is great..I learned everything I know in Excel through here..Not Microsoft Books or anything Can you combine theory with practice & practical applications.

  90. varath says:

    Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.

  91. baran says:

    very THANKFUuuuuuuuuuuuuuuuuuuuuuuuuL

  92. Shailesh says:

    I have around 250 emails ids in one cell in excel , how can i sort the same in different rows and columns

  93. Hui... says:

    Use Data, Text to Columns and use a space or ; seperator to break the emails to seperate columns
    Now do a Copy, Paste Special transpose to get them to a Column

  94. Rajdeep says:

    "I will be starting a series of posts shortly on Chandoo.org"

    That's great Hui. Here is an example where an 'add-on' is as valuable as the programme. Many thanks.

  95. amrit says:

    thax to provide us easy to find anything in excel

  96. charu says:

    Chadoo !!
    It was great experience. when i browsed through your blog. I liked it so much. Your ideas helped me to ease my work.
    many many Thanx.

  97. SELVAM NAM says:


  98. Hui... says:

    @ Selvam
    Chandoo.org is a great spot to learn the basics and then some more about Excel
    For VLookup specifically try:

    Next have a look at the New to Excel box on the right hand side of the home page.

    Chandoo also runs an Excel School which you can read about here:

  99. San says:

    Hi Chandoo

    Yours is a great site for Excel learners. I normally used to frequent the Google Groups especially for programming and worksheet functions, but the content in your site is mind boggling and very helpful.

    I am in search of a point & figure excel charting sheet - used for stock technical analysis.. you know which draws the crosses and o's depending upon high/low or close value where you can give the box size in units or in log scale, box reversals and finally can draw 45 deg trend lines up or down. The source data (OHLC) may be web queried or pasted.

    Thanks for your help

  100. Ghida says:

    I am working on an excel formula that I copied it from a file but I done know how it was done. The formula is below.

    I tried to copy paste the formula and it worked except the { signs on the first left and right. I don’t know how to do them or what to press in order to get them.

    The case where I am the formula is :
    I have many names under column A, and next to them under column B, I have their duration taken in doing certain action. So next to each name I have his/her action duration.
    I put the names without duplication under column (name) and made the formula average if under (Avg). As there is no formula like Minif and Maxif I had to make above mentioned one to get minimum if for each person from column (A), but faced with the issues above.

    Kindly asking for your help

    The figures showing under Min & max are copied from formula in previous file but I didn’t know how to do them.

    name Avg MinIf MaxIf
    A 0.59 0.000000 0.000000
    B 0.78 0.000000 0.000000
    C 0.20 0.001921 2.004201
    D 1.00 0.005058 7.000058
    E 0.31 0.002801 0.435938
    F 0.36 0.002917 2.830278
    G 1.74 0.000000 235.655590

  101. Ghida says:

    sorry pasted in a bad format

    name Avg MinIf MaxIf
    A 0.59 0.00 0.00
    B 0.78 0.00 0.00
    C 0.20 0.00 2.00
    D 1.00 0.01 7.00
    E 0.31 0.00 0.44
    F 0.36 0.00 2.83
    G 1.74 0.00 235.66

  102. Hui... says:

    This is an Array Formula
    Enter the formula as
    Then press Ctrl Shift Enter, Not Enter by itself

  103. vickeyvishal says:

    Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.

  104. Nita says:

    Hi chado,

    can you please tell me how can I download excel for my computer cause I've been trying for a long time now and nothing:S

  105. Nita says:

    Hi chado,

    can you please tell me how can I download excel for my computer?

  106. Nita says:

    I realy need it now:S

  107. christian says:

    Hi Chandoo!,

    i'm trying to create an IF statement formulas with Vlookup. =IF(T2="January";VLOOKUP($B5&COLUMNS(H$4:$H$4);data;15;FALSE));IF(T2="february";VLOOKUP($B5&COLUMNS(H$4:$I$4);data;15;FALSE));IF(T2="March";VLOOKUP($B5&COLUMNS(H$4:$J$4);data;15;FALSE)). Depending on the month, i use the vlookup to retrieve a different number. But i keep getting a #VALUE!. Any ideas what im doing wrong? Thanks a lot Christian

  108. Hui... says:

    I assume your formula is looking up the contents of B5 and the number of columns between Column H and I,J,K etc then appending them together
    as the lookup value

    What value is in B5 ?
    Is the value in B5 and 1 ie Cat1 if B5 has Cat, in the first column of your data table ?

  109. christian says:

    Hi! in B5 there is a name (ex: Carlos). if you wish, i can send you the file, always more visual:) thanks!

  110. Sudhir says:

    Hi Chandoo

    I'm looking for dashboards which presents actual vs budget /forecast comparison. Do you have anything on this for download?

  111. Imran says:

    Hi, please can you help me i am looking for a awesome excell document to manage aspects of recruitment from recieving the vacancy to sourcing a potential candidate to eventually placing the individual. does anyone have anything that i could use for this?

    Thanks guys

    Much appreciated

  112. gangadhar says:

    hai sir,i'm fan of you.i'm inspired by seeing your website in enet.i'm also from vizag.

  113. Harish says:

    I haven't seen any thing special in you side. I have seen lots of webside better than you and provide knowledge free of coast with easy step then you. I thing, if you want to share free of cost knowledge, provide it free of cost and esay steps. I am saying you becose i am better than you. whole office knowledge function to macro. If you need any help mail me.
    I'll provide you free of cost with template example


    • Chandoo says:

      @Harish.. I generally do not reply to negative comments. I do not think it is right to focus my energies there. But you made 4 such comments with lots of negative energy. I wonder why you are so hurt..? Why is it bad to make money while teaching. Why is it bad to teach online? Who said we have to learn only from a book and help menu?

      I am not ashamed of what I am doing for a living. I am really proud instead. so are many of my customers and readers. So what is the problem for you?

    • Mohsin says:

      You are not right here Mr.If you don't like blog of chandoo,leave it!Why your dad paid to school?.....It seems you are jealous of chandoo.I am big fan of him--He is awesome

  114. Ghida says:

    Great webiste thank you chandoo ! 🙂

    Keep Excelling 🙂 !!

  115. Imran says:

    Thats rude @ Harish, i can honestly say that if it was not for Chandoo's site i would not have passed my Six Sigma Black Belt examination, do something fun, like jump of a bridge or something. Chandoo you rock, keep excelling

  116. Ghida says:

    i would like to know how can i do below case:
    i have under column A the date of a certain action anf they vary through a certain year let`s say 2010. i want to write under column b in excel, and next to each date the month only means is cell A1 shows (22-Jan-2010), then i want B1 to show (Jan) only.

    i tried the If formula and IF AND, as well nested IF but didnt work
    pls help Thx !

  117. Ghida says:

    same goes for other dates in Feb , march etc,....


  118. Hui... says:

    If Excel is so easy to learn and you are so good,
    Why do you come here with these comments, why not just stay away, or better still
    Why not contribute your experience, you will feel better by helping others!

  119. Ron says:

    We are looking for a manpower loading chart that will mirror the electrical industry standard. Basiclly would invole (2) inputs. 1. Project duration in weeks. 2.Total estimated manhours. Do you have a template sililiar to this?

  120. [...] e guarde nos favoritos: http://chandoo.org/wp AKPC_IDS += "5745,"; Talvez você também se interesse por alguns destes artigos [...]

  121. Ricard says:

    Hi Chandoo,

    Many thanks for your web page. I've found it really useful.
    I've done a small Gantt template for Excel. Please, feel free to use it at your convenience.
    You'll find it at http://xlstemplate.blogspot.com
    This is my contribution for your page.
    Enjoy it.

  122. Hi Sir,
    Your website is very useful for students & professionals. Could I add your website in my blog?
    Please give me permission.

    -Subodh Sharma

  123. Ghida says:

    i would like to know how can i do below case:
    i have under column (A) many dates related to certain action I want a formula that writes under column (B) next to each mentioned date the month only.

    example: if cell A1 shows (22-Jan-2010), then B1 must show (Jan) only.

    i tried the If formula and IF AND, as well nested IF but didnt work...pls help
    Thx !

  124. Ghida says:

    Excellent Site ! 🙂 that gives hope 😛

  125. Hui... says:

    In B1 put =A1
    Now change the cells display format
    While on B1 press Ctrl 1
    Format Cells
    On the Number Tab, select the Custom category
    In the Type: box enter mmm
    save and apply
    Copy B1 down to suit

  126. Ghida says:

    Hui !! merci beaucoup 🙂 good to have you in this site
    hihih i donno why i had to go into these if formula and bla bla bla

    Lebanon, Beirut

  127. deepak says:


    u can also enter the formulate =month(A1), and u will get the desired result.


  128. Ghida says:

    Thx Deepak

  129. pinakin says:

    hi chandoo

    i am searching of portfolio management excel sheet for different age persons
    model portfolios so pls help me i am searching for equity not for MF

    regards pinakin

  130. Mohan says:


    I have prepared a countdown timer. I have used the following formula:

    =IF(NOW()<TargetDate, TEXT(TargetDate-NOW(),"hh:mm:ss"),"Done!")

    where TargetDate is a Cell Name which I have mentioned.
    In this once the timer gets, 00:00:00, I receive "Done!" in the cell.
    (I have named the cell where I have kept this formula as TimeToGo)

    I have used a macro to run this:

    Dim NextTime As Date
    Public Running As Boolean

    Sub StartIt()
    Running = True
    End Sub

    Sub Update()
    NextTime = Time + TimeValue("00:00:01")
    If Range("TimeToGo").Value "Done!" Then
    Application.OnTime NextTime, "Update"
    End If
    End Sub

    Sub StopIt()
    If Not Running Then Exit Sub
    On Error Resume Next
    Application.OnTime NextTime, "Update", schedule:=False
    Running = False
    End Sub

    Now I need is a Message Box Popup, where once the timer in the cell gets 00:00:00 or "Done!", I get the popup reminder which I want to keep as "Update MIS Tool"

    Can someone please help?

  131. Roshan Matooreah says:

    Hi boss ,

    I am trying to learn excel with Visual basic , just tell me which site to visit and get some templates example of some works.


  132. ahhhmed says:

    how can I insert this lline
    Application.OnTime Now + TimeValue("0:0:1"), Me.CodeName & "." & "doThis"
    into the VB for the doughnut clock spreadsheet? I downloaded it but it did not work!

  133. Sara says:

    Thanks alot for those very helpful information

  134. Prasad says:

    Hi Chandoo,

    I need a spreadsheet for material planning and inventory control. Ours is a very big company and there is a huge list of materials and products. Would you help me with any template so that i can extend it to my need.


    Cheers, Prasad

  135. Ghida says:

    there are lots of excel sites but never one founded user friendly, entertaining and non boring as Chandoo
    Go on !

  136. Ghida says:

    Hey !
    there are lots of excel sites but never one founded as user friendly, entertaining and not boring as Chandoo
    Go on !

  137. Ghida - Lebanon says:

    I have a drop down list that i made which is too long. it is about suppliers name.
    i made it in order to avoid human error and typo mistakes in data entry.

    Issue is that when i start typing in a cell that has this validation, excel doesnt automatically continue supplier name. for example, i write F so excel doesnt show me what is available as supplier names starting with F such as (Fabrics Ltd, Freddy Co,....)

    how can i solve this pls ?


  138. MK says:

    Click on this site. Your best source for this any, and I mean any questions is Google. Cheers!


  139. Ghida - Lebanon says:

    thx MK

  140. Devang says:

    Hi Chandoo..
    How to create real time charts in excel (Lets take an eg. of share priceor index value)

    Thnx in advance

  141. Isma says:

    Hi Chandoo, I'm new to this website. I've been trying to create some option buttons in my excel spread sheet that does two things. I was advised that the two things I needed required macros that are not referenced to each other so that is this button I need to click when I write the macro then there is no reference link. But try as I might, when I create the option buttons, they are all linked to each other. The first set of two buttons will become unchecked when I check the second set of option buttons. Besides, I have a problem after I save the file because when I open it a message appears that the macro cannot be found. I give up. Do you have a template excel sheet with option buttons that control more than one formula? Thank you.

  142. Hui... says:

    Put a Group Box (Form Control) around the option buttons you want to group and leave out the others.

  143. Isma says:

    Thanks for the advice, very quick. But where do I find the command for Group Box (Form Control). Appreciate your help.

  144. Himanshu says:

    Hi Chandoo,

    Regularly visit your site to explore finer aspects of excel. Just needed to consult on one aspect related to ActiveX based advanced Charting and Instrumentation tools. What are the ways of embedding an activeX based instrumentation control in excel while maintaining a condition that the end user does not require any special installation on his system be it activeX component or I do want to avoid even self registration of activeX.

  145. Ghida - Lebanon country says:

    may i know what are the instruments control pls?

    Ghida - Lebanon country

  146. Himanshu says:

    These are all ActiveX controls for making Guages, Knobs, LED,s and so many various things which enhance the visual appeal of excel based reports or rather say Dashboards. I was going through Perpetuumsoft and IOCOMP's activeX instrumentation controls and just thought can those be embedded in excel and still end user does not require any self registering activeX on his sytem. Everything must be embedded in excel itself.

  147. Mohan says:

    Hi Chandoo,

    May be you can help with my problem. It will be much appreciated.

    I have a Workbook in which I have to run a report on a daily basis and send it to my manager and cc it to my team leaders via Lotus Notes.

    The report that I run should be saved as follows:

    "Comparison Report dd-mm-yyyy hh-mm", where dd-mm-yyyy is the current date and hh-mm is the current time

    I have done a macro to make this happen:

    ActiveWorkbook.SaveAs "J:\DATA\BPO\OPERATIONS\BP\BP UK\BP UK EDM, Exits and Leaves\COMMON\Eform creation\Daily comparison records\Comparison Report " & Format(Now, "dd-mm-yyyy hh-mm")

    However, I need help to automate further:

    1. I need to put the email Id in to and cc field of the email
    2. I want to put the subject line as "Comparison Report dd-mm-yyyy hh-mm"
    3. I want to put the body of the email as "Please see the comparison report below."
    4. I want to attach the file automatically to the email and lastly
    5. To send the email automatically

    I tried so many macros, but some or the other things get missed. Sometimes I get the attachment in my email, but not the body and the email id in cc field, sometimes I get the body of the email without the email Id in cc field and the attachment. As my file is based on current time ("Comparison Report dd-mm-yyyy hh-mm.xls", sometimes it may not pickup the file as the time gets changed.

    Could you please help me with this? Please its very important. I am a novice and its very much challenging as well as enjoyment for me to get into the world of macro and see the magic. I am crazy about excel. Please, I would be very thankful to you if you could help me with this.

    Will be waiting for your reply.

    Thank you so much in advance.

  148. Balakrishna Gopinath says:

    Dear Mr.Chandoo

    This place is simply awsome
    I give you the credit for all my excel learning
    I should call you CHANDOO GURUJI !!!!!!!


  149. Pankaj says:

    Dear Chandoo ,

    A thought that was occupying my mind on something in Retail Space .IT Company develop softwares that are used by big R like Big Bazar ,Star Bazar and many .Developing an application using excel and VBA not only as GUI but also to track either as inventory management , stock outs etc .Is this really feasible ??I do understand how robust or large this application needs to be ?? How about having MS access as data bases and storing entered data in excel .Not only this creating Buisness Intelligence reports or doing Analytics based on excel data anaylsis of the entire retail data how much this would be feasible in reality ??? I might sound silly but the main idea that i am trying to bring about is that the power of excel ,VBA, MS acess can this really create a break through if not in Big Reatil Space then in Small retail format stores like localized stores of 2000 to 3000 square feet space.This question came in understandin the IT spending of adopting such software with many liscensed software costs would be good $$ dollars .Then why not having such integrated software build based on readily available excel(using Data Analysis ,Solver etc features ),MS acess(data storage and retrieval) and VBA( creating logics for warnings in case of less inventory etc ) .Is this idea sustianable ??

    Would be great if you share your thought on this


    • Siddharth says:

      hi Pankaj,

      were you able to find a solution for your inventory management and control issue ?

      I am seeking one now !


  150. john says:


    i am about as new to excel as can get.
    however, i am using it to track inventory at my local legion hall.
    we have breakfast every sunday morning, so i have been for the last ten weeks putting in the information of how much we have bought and used and how many patrons and what overall cost has been each week off a template that i made.
    now i thought there should be a way to put all them files i have saved into one spreadsheet to find a total /average. i don't know how to combine all these spreadsheets.

  151. nagesh says:

    dear sir,
    your site is very useful .
    thank you sir

  152. Raghuram BHat says:

    Heyya Chandoo..

    Thanq soo much. I was searching for a site/blog where I get some useful tips and worksheets to work on. Today I come across your site. It's just awesome. this one site has the answer for most of questions regarding Excel. Hat's off to your great contribution to excel learners. Thanks again and again.

    Thanks & Regards,
    Raghuram Bhat G

  153. Jinks says:

    Just wanted say this website is better then many I've come across, it has tons of things to refer to and a blog to seek additional help if needed, hats off to you Chandoo and thank you for sharing this with us "keep up the great work".

  154. Ram says:

    Hi Chandoo,

    i need testing related templates i.e. Test Reports, test Coverage report and Planning and Execution status etc...could you please send me the link if u have prepared earlier.


  155. Alexander says:

    Hello Chandoo:
    I am looking for an excel template that will track resource hours for an operations work group. We need to be able to track 8 to 12 hours per day and performing multipe different tasks during the work period. For example 3 hours tramming, 2 hours bolting, 2 hours drilling etc.
    Do you know of any spreadsheet template that can do this?

  156. Rajesh Vyas says:

    Hi there,

    I am a Police Officer. Although I use Excel regularly in my crime and criminal analysis. But I am not satisfying with it. I would like to develop a system something like Dashboard where I can get all things at a glance. How can I do it?


  157. Imtiyaz Shaikh says:


    i love this website i learn lots of things from this websit.

  158. CHAN KHNA says:

    HI CHANDU GARU, thanks a lot for u r contribution to new learners of financial modelling students.from u r site i got good knowledge.thanks a lot.good work.

  159. Ata Betero says:


    I have been trying to download the above templates but has not yet been successful. Please assist in any way possible.


    Ata Betero

  160. Hui... says:

    Use the Download Now links on the right hand side of the screen
    The links take you to the original web site where the Charts are hosted

  161. Edward Rivera says:

    looking for a product catalog template , or instruction on how to make one. any help would be great. thank you

  162. Srinivau says:

    Hi Chandu,
    I am working as Graphics specialist in a reputed organisation. My daily routine consists with tracing of charts working with financial data etc. My question is how to trace the charts in 2007 and 2010. Currently I am working with 2003, it is user friendly to trace the charts. I found 2007 and 2010 are not allowing me to trace the charts. Could you suggest me how to crack it.


    I was trying to down load Mutual Fund Tracker but It shows file is empty

  164. Jayant says:

    hi chandoo
    first of all thanks a ton for helping me. ur tutorials had helped me to keep me things simple. i would highly appreciate if u can help me inventory management template
    awaiting ur reply
    thank u again

  165. JEVE says:

    hi chandoo,
    please can i still enrol in your online vba classes, the registration period was last sept 5 to 16? I am 15 days late... 🙁

  166. persol says:

    Hi Chandoo,
    I am curious if it would be possible to create a chart that would display a picture, symbols, or numbers instead of the numbers? I was trying to figure a way to display numbers rather than the usual bars on a graph as is shown on the following site: http://www.nobosti.com/spip.php?article28

    The graph is titled "ANALISIS DEL PRIMER DIGITO"

    If you have any suggestions I will greatly appreciate it.


  167. Arshad Ahmad says:

    Your Site are best

  168. Jay says:

    Hi, Chandoo your work is great thanks. I was wondering if you have any work for cost based analysis for stocks. Like FIFO, LIFO and HIFO method. I am looking for it as there are new law implications in the USA from 2011-2013. It would be a great help.


  169. JEVE says:

    hi chandoo, sorry ive been busy. i sent an email to your gmail account.. hope u will still consider my request. I want to learn from the best, thanks

  170. sadanand says:

    hai chandoo garu,

    i am using os windows 7 in this excel 2007 support for this special character code like alt hold and press character code.if the os support for special character code tell me process.
    i am trying the process hold alt and press special character code in xp os, but it will work on os windows 7. please give me suggestion and help me.

    i have learnt some many tips, what you developed sheets. it is very much helping me. thank q for ur's helping...

  171. Srinivasu says:

    161) Srinivau September 29, 2011
    Hi Chandoo, I am still waiting for your suggestion.
    Please guide me how to crack it.

  172. Hui... says:

    What do you mean by Trace the Chart ?
    Can you please elaborate ?

  173. naeem says:

    thanks for the sharing....

  174. Zar Ni Win says:

    Thanks a million

  175. vishnu prasad Mora says:

    Chandoo Garu,

    How Can I open a autocad file through Excell macro, Pl. suggest

  176. Bhushan says:

    Boss !
    Hats off to your work!

  177. LV Chiranjeevi says:

    As per my daily activities, i utilizing excel VBA macro linked sheet for Sales Comparison of products containing with different taxation slabs with discount, transport, insurance and other links containing in the sheet. After en-trying the total values of the products along with necessary taxes & duties on the sheet, that calculate automatically the values and gives the supplier position on ranking basis.

    So in this context i would request you to develop a good tool for (Procurement Comparision Tool) infra sector employees to optimize the work pressures.

    So if your interested to develop a new tool for sales comparison as per indian market concern

  178. Roger Carver says:

    Your site is fantastic.
    Im looking for a basic excel 2003 inventry spread sheet for a small company which I run from home.
    Anybody got anything I can use.
    Roger Carver

  179. RAM says:

    i have need timing wise bank charges calculation
    RTGS LACS LACS Bank charges
    9:00 AM 12:00 PM 2 5 25.00
    ABOVE 5 ABOVE 50.00

    12:00 PM 3:30 PM 2 5 26.00
    5 ABOVE 51.00

    3:30 PM 4:30 PM 2 5 30.00
    5 ABOVE 55.00

  180. Michelle says:

    Hey Chandoo!!
    Love your work... always awesome!!

    I was wondering if you have some sort of customer calls follow up template where I could input the customers company information, contact person, different dates when I contacted him and comments regarding each conversation... stuff like that. Any templates o suggestions?

    Thanks in advance!!

  181. Joe says:

    Just stumbled upon your site from searching MS excel for randomizing a data set.

    Thank you for the tip.

    I am usually the one who answers others questions and you taught me. I will pass your site on to others. Great job, and Thank you.

  182. philip says:

    Please can you help. I don't how where to look first without opening every template :-).

    You have just help me loads with the formating but my next job is to create a seperate list from a large excel document. I have a list of offers for airlines but I only want to see Europe ones on a seperate tab. I have tried vlookup by Europe but it will only bring the first row with europe on, out of about a 1000 Europe rows.

    I have never created a list from one large excel before. I need to first find all the Europe rows and then place them into a seperate tab so its easy to see the offers I am looking for. But this list needs to be live with the large excel sheet so any changes to any cells on the rows with auto update list.

    Can this be done and if so can you guide me to the right place to look, I am begging.

  183. kishore kumar says:

    I need Digital Dashboard in Excel

  184. Hui... says:

    @Kishore Kumar
    Chandoo has a lot of resources that could help you.
    Dashboard Tutorials: http://chandoo.org/wp/management-dashboards-excel/
    Dashboard Classes: http://chandoo.org/wp/excel-school/
    Consulting: http://chandoo.org/wp/excel-consulting/
    Ask Questions: http://chandoo.org/forums/

  185. vasu says:


    I feel alwasy great to be in front of system when i open your website...Mind blowing content in your website...I wonder how this database are stored in your brain..

    Thank you very much, making most of our excel work very simple.


  186. Sohel Ahmed says:


    Thanks, it was very good to visiting your site & getting much more which is need

    Sohel Ahmed

  187. Dear Mr Chandoo says:

    Dear Mr Chandoo,

    I am bad at excel, and was visiting various websites to find some solution to my problems. Can you help me with it?

    I have two One Brand, Two Product, Product Discription and prices which fluctuates every day. I need to capture this info by EXCEL as a trend to know how the pricies are moving for each Product by Product wise.

    Can you help me with a Chart dipicting price fluctuations and a place to enter that days prices to appear on a Dash Board please?


  188. alecto says:

    good morning to all.

    i have 2 columns and both are filled with employee names . . . what formula or formatting should i use to check if the names in column A are also in column B?

    thanks much in advance for your help ?

  189. juzar para says:

    Respected Sir,

    Please provide me Text box which i can hyperlink and it will not disappear from screen, whereever i move on the screen, but it should be visible means floating on screen


    juzar para

  190. Deanna says:

    I am looking for a comparison matrix excel spreadhseet. I am trying to compare many companies across many attributes.

  191. Mohit says:

    Thanks for the awesome tutorials. Have helped me out a lot. Appreciate all the hard work you have put in. Thanks a ton!

  192. umang says:

    hello chandu
    i want a excel application for SBI which convert excel sheet into txt file if u give me ur mail id then i may send you pnb software used to upload bulk entries.

  193. Don Sublett says:

    I have columns "C, D, E, F, I, K,
    M, R, W, Y, Z, AB, AE, AK, AN, AP, AQ, AY
    and AZ". How can I copy them all at one time to a new worksheet
    in the same workbook?

    • Chandoo says:

      The easiest way is to copy the entire sheet and remove all other columns. For this right click on original sheet name and choose copy.

  194. veeresh says:

    how to compare two or more columns numbers in excel 2007 pls suggest

  195. cherie says:

    anyone who has fishbone chart xcell template?

  196. Heya i am for the first time here. I came across this board and I find It really useful & it helped me out a lot.
    I hope to give something back and aid others like you helped me.

  197. WFernandezJr says:

    Wow! I consider myself a beginner Excel user and all you have here could take me YEARS! God bless you for sharing so much. I do have a question. Is there a link to a previous post where I can get ideas on how to create employee work schedules? I work in the aviation industry and employees may be scheduled to work in different departments and/or different clients (airline). Currently, employees much search themselves on different work schedules for the particular task/airline and this not only creates a problem for them for those of us unfortunate souls trying to acomodate their needs and the needs of the clients. Ideally, this would be in one place so that each employee is scheduled to be between certain hours at a particular task with a particular department or client. This way, it is done in one place and avoids time overlaps and confusion for everyone. In advance...THNX! 🙂

    • gigglz says:

      I am looking for where you put the ranges at? I did it once in class and can not remmber how? HELP!!!

  198. WFernandezJr says:

    forgot to add...though it might have been obvious that, the same person may work different shifts performing different tasks each day, plus some may have an identical or similar schedule each week and yet some may have a very different schedule each day/week. 🙂 THNX

  199. Tony says:

    I am working on analyzing final evaluation forms submitted by our different projects that briefly describe the benefits of each projects. I need some help in getting an excel templet that can be used to capture all benefits and analysis those.. Latter i want to analysis which project create which benefits..

  200. vishnu prasad mora says:

    How can I open autocad drawing from excell button, vb code required

  201. vishnu prasad mora says:

    excell vba macro needed to open a file in autocad

  202. Fleur du Mal says:

    Hey Chandoo!  Nice site, great work.  I'm having trouble downloading the sample data for the Pivot Table lesson however.  Seems like the Windows Live linkage is broken.  Is ther another place to get it ?

    Thx, Mal

  203. Shyam says:

    I had imported a CSV file from Data and did a text to columns using comma delimited method , table has A to F columns and i  inserted a column before column A and concatenated the columns E1 and D1 up to end of columns , after that copied and paste special in column A , now i selected the entire table using cntrl+A and defined it as book1 in name manager .all the actions are recorded using macro , and i when i add control and rerun that the name manager is selecting from column B ..i doono why its ignoring column A .

    Please help

  204. J MARTIN says:

    Hi there,
    I'm traying to do the same format table (function in excel 2007), but with Excel 2003... I think is not an option, or Should I activate some kind of plug in?
    Thanks a lot in advance for any information about it.
    Cheers, Martin.

  205. edilyn says:


    Where can I download a GAP analysis advance template for free like in this link: http://www.demandmetric.com/content/gap-analysis-tool-advanced

  206. vilaskar says:

    can you send me free excel sheet for caliculating cash discounts on sales of different products with diffrerent due dates  like for 7 days payment on sale  discount will be 10 % for 15 days it may be 5% for 30 days payment  2%cash disccounts allowed for diffrent products sale, and tournover discount at the year ending is also in slab systems. i.e, 2 % 5 % and 10%  cash discounts allowed. can you suggest and send me the excel sheet  for easly caliculation for cash discounts.VILASKAR.SIGMA

  207. Bala says:

    hi Chandoo....

    i need a best macro coding book to learn

  208. Get info says:

    Thіs web ѕite truly has all οf the infoгmatіon
    I wanted conсernіng thіs ѕubject and didn't know who to ask.

  209. Dave Borges says:

    am looking for simple attendence register for my small office of 12 staff where we can track public holidays, weekends, annual vacations, sick leave or leave without pay and half day leaves.


  210. D'Nice says:

    Just want to say what a great user friendly site. Nice to see free tutorial downloads. What I relief to know there are still good ppl in this world.
    I am looking for a way to complete the task of adding panning hand to my excel 2010. I always had it & now its gone. Nobody has been able to help me. I created workbookBokk1.xml in VBA Editor & I made the ribbon with the hand but I am stuck. Not sure if you or any of your mates here on your site can assist me in accomplishing this? My husband has the hand in a ribbon in excel but we are stuck how to add the 4 way scrolling to the mouse. WE have tried the keyboard shortcuts & even call ed MS level 2 teach, only installed Excel over my primary excel, & the new installed software picked up the same.I called again & MS said that uninstall & reinstall...but was told that  will not help. any suggestions?

  211. D'Nice says:

     not sure what this is but I am not a spammer.

  212. D'Nice says:

    what is this?mmm'?

  213. Pankaj says:

    I am a new comer to this site. It was highly recommended by a friend. I am a product manager and am wondering if there are any free templates, which will convert to graphic charts, that I can download for stuff like competitor analysis charts, bubble diagrams (plotting various competitors) etc.
    My knowledge of excel is very basic so any help even pointing me to the right stuff will be greatly appreciated. I am using Excel 2010 right now.

  214. selvam says:

    Dear Chandoo,

    I want to want  to follow up  and collect payment
    (out standing) with in 25 days against the respective invoice , please tell me how to make a format in excel with formula

  215. Fardeen says:

    HI Chandoo,
    how are you i did really liked your website.

    i faced to a problem in ms excel i don't know is it possible but i think should be it's same to your birthday template i need to make an reminder or e-mail sender before date of expire of something if it's possible please let me have your e-mail to send you the template for adding formula if you have time.



  216. I want to help someone:
    I need the following problem help. Please help anyone.



    /* Style Definitions */
    {mso-style-name:"Table Normal";
    mso-padding-alt:0in 5.4pt 0in 5.4pt;
    font-family:"Times New Roman";}

    Main File
    Category          |   Prod. ID       |     Prod. Code                        |      Result_ Product Name
    A1                   |         B1         |           C1                    |                   D1
    01                    |        08           |           1052                |  A- Cal 250 Tablet
    01                    |        08           |           1053                |  A- Cal 500 Tablet
    02                    |        09           |           1052                |  A- Cal 750 Tablet
    02                    |        09           |           1053                |  A- Cal 1000 Tablet
    01                    |        01           |           1052                |  A- Cal 1200 Tablet
    01                    |        02           |           1053                |  A- Cal 1500 Tablet
    I want to be VLOOKUP formula in another sheet and I can Entire Data in
    First                 : A1 = 02
    Second             : B1 = 09
    Third                : C1 = 1052
    Output              = A- Cal 750 Tablet
    Output is calculated by V LOOKUP Formula

  217. Hemanth Kumar M says:

    Hi chandoo,
    Please help in excel formula, I had problem with format.
    Ex: I have taken multiple spread sheet. In sheet 1 order sheet to supply the items & bills xyz ... etc company to supply the item which given order that I are enter sheet 1.
    sheet 1 (order sheet)
    slno.     items       xyz    abc     prt         Total
    1          Pen           2               5              7
    2          Pencil         10     5                      15
    3         Eraser         6        2      20            28
    xyz, abc, prt are the company names which as a payment bill
    The text items which is column 2 should be enter in format of formulas to bill like xyz, abc, prt with quantity.
    Please help on this how to solve using formulas, I am not familiar in excel formula. write the formula on this & email to me.
    My email Id: mhk_mysore@yahoo.co.in
    Hemanth Kumar M

  218. LOVE the calender template. Really easy to use, and I could have never figured it out myself.

  219. Sonia says:

    Hi Chandoo,
    You have a very impressive and very educational website. I really appriciate your excel facts and tips. Pls help me with my one of many problems in excel. can we merge two pivot tables in one view. if not than kindly help me with Multiple Consolidation Topic.

  220. Suraj Nair says:

    Hi Chandoo,
    Could you please provide the steps on how to use the new rupee symbol in Excel 2007 and 2010.

  221. Tirumala says:

    Hi Chandoo,

    I looking for a dashboard for a recruitement consultancy.
    the dashboard should show the performance of the recruiters.
    could you please......... help me for this.


  222. B. says:

    I have a spreadsheet that contains multiple spelling lists on one sheet.  The remaining sheets have activities that use these lists.  The problem is that I don't want to have to continue to copy/paste the list into the activity.  Is there a way to specify a list, say Lesson 1, and have the words automatically show up in the activity.
    I'm sure this is possible in Excel, but I'm blocked.
    What do you think?

  223. Dipak Chudasama says:

    Dear Sir,

    two multipal sheet data diffident type & one sheet convert related formula use 

  224. [...] are many tools available to create dashboards, including Gecko Board and Cyfe. Many spreadsheet experts and template creators are also able to bend and display data as a [...]

  225. John says:

    Is it possible to get a To Do list that will send an E-Mail when the target date expires ?



  226. Eceramics says:

    I enjoy, cause I discovered just what I was taking a look for. You have ended my four day lengthy hunt! God Bless you man. Have a great day. Bye

  227. gene says:

    I want to export data (name) from a cell to another cell within in the same sheet by just clicking a particular cell (maybe with an "X"

  228. gurusivukmaran says:

    pls provide vba functions & syntax with in example file with in pdf format file 

  229. Nil K says:

    Thank u ! Good Site ! Organized data at one place & well maintained !
    Good work Chandoo ! my best Wishes !

  230. Nipendra says:

    Hi Chandoo,
    first of all welldone work over here,
    i want to ask something if i have only excel 2003 in my system and have lots of data amount (2003 excel have only 65536 number of rows), how will we use above 65536 number of rows data in excel 2003  ? any idea please share

  231. Amr says:

    is there a ready excel tabel for meetings schadules , same like office weekly calenders
    please reply ASAP

  232. Sunny says:

    Hi Chandoo
    i need a solution where an excel sheet can be appended to a database on website.
    do u know if it can be done by excel app in 2010 office and its a simple thing to do..,

  233. Adeel says:

    Do you have any Training Budget Calculation Dashboard?

  234. Satish says:

    Hi Chandoo
    It's really help full site.

  235. Ahmed says:

    After deep appreciation for the work that you give, I need some help, I'm working "work force" in the field "call center" I need help me for making template by excel. When distributing breaks for the agents i want to send a message to all Agent in his break time through outlok exchange by entering Agent user. Is it possible assistance in this work? be very thankful to you

  236. Nitin says:

    How do i transfer data from USER FORM in diffrent tabs by usinf VB coding..???

  237. Arul says:

    Dear Chandoo,
    Thanks for sharing your valuable datas with us...God Bless you. Just wanted to know do you have anything for small store invenntory sheet...to know the stock sold or not monthwise.

  238. Shamaeil says:


  239. Pramod says:

    Hi Chandoo, 
    I am looking for a template in which if I select the value from the drop down the value related (to the drop down value) should be displayed.  

  240. Shyam DL says:

    Hi Chandoo,I need ur help i want to enter numerical or alphabetical both in a cell , but condition is that.. data not more than or less than 10 digit .. 
    e.g :- PAN no. 

  241. Carlos TS says:

    Hi Chandoo,  It very usefull this site.  I was looking for a HR Staffing Template that I ca use, in order to determinted the time to hire etc....
    Do you have something related to this available?

  242. Nipendra Dhiman says:

    Hi chandoo,
    It is all awesome really I want to ask one thing only do you have any idea ,
    can we make some longer project to show our business flow by excel vba.
    actually I have worked with vb.Net and ms access database before 3 years there we have lots of tools to prepare a fantastic application and report ,I made some project for school and hotels.
    but now  I want make these types of application with excel vba and ms access database I know how to connect access with vba and I know how use events and classes.  do you have some another sample also in vba where ms access connection used with excel vba on vba user form.
    you must have seen some project like “library management, fee management ,hotel management etc…” somewhere ,i have made these all but in vb.net no enough idea in vba so may you please illuminate something possible or not.

  243. Qadeer Nazir says:

    Dear Sir,

    If anyone can can help me sending a chart to present 100+employees individual achievement details. Thanks.  

  244. preechasu says:

    thank alot for you

  245. Mohan says:

    hey mate

    Y isnt the wedding planner on sale ???

  246. Santosh says:

    hi,i am working for a dashboard for my top management, where all the data from each team should blot (as HR, IT, infra, Transport, Finance, Sales & marketing , software development and operations.

    pls help me which template to use.


  247. Angel says:

    I need a excel general ledger template to track expenses

  248. Nishant Mehta says:

    MF Portfolio Tracker- India v3.0. is tooo cool.... Can we have Indian Stocks/Shares Portfolio Tracker ???

  249. Rajesh says:

    Hi Chandoo,
    I've a hyperion data....based on 2 combination, I have to create a standard template. Please help

  250. muhammad munaf says:

    you are the best.......

  251. Baskar G says:

    Hi Chandoo,
    Good Evening, i need ur help how to connect excel to access database, can u pls provide for link......


  252. Niket G says:

    Hi Chandoo,

    Your website is really great. I've learned a lot and am glad that it is helping me get things done faster.

    I do have a question. In Excel, I have a userform where the user can input filter criteria. However each customer has different requirements so that means different filter criteria for each customer. I am looking for a way where I can save a specific customer filter and after it is saved, i should be able to retrieve it from a dropdown combo box and the filters for that customers will appear and I should be able to filter the data.

    Any ideas?


  253. Joe Briggs says:

    Thanks for the templates!

  254. Islahuddin says:

    Hi Chandoo, I want to know more about PowerPivot Function which is becoming very powerfull tool these days . i have found only one VDO in which you have shared how to use Vlookup function in a very simple Way ,Also if i am using MS2010 and i am unable to find Data View from which i can link some Rows .Please help.

  255. shankar says:


    I want to know can i change the color at time when cell value change
    and data link to other sheet.
    for example.
    A1 =1 ,A2=2,A3=4
    link =a1,=b2,=a3

    i want to sheet2 highlight value ,when sheet1 value changes

  256. Prabhu says:

    Hi Chandoo,

    I am Prabhu from Mumbai, working in co-op

  257. Prabhu says:

    Hi Chandoo,
    My Name is Prabhu from Mumbai and working in corporate industry.
    Basically my job is to analysis of sales people in various parameter and Head Office level to update the business peroformance. i am good in excel but the size of data is getting high so I am unable to deliver the job in time after adding so many formulas like sumifs, countifs, pivort, etc,
    Also I am trying to learn a VBA in excel 2007 but In that also I am very poor, because I can’t do everything ij just recording a micros and I am not aware of write a program in VBA.

    My daily Job is-
    Deliver the report on daily basis for sales level as per the top to bottom (Sales hierarchy)
    Report of sales Head leavel
    Report for Growth or de-growth – Last year v/s current year
    Report for Company level for our Top level – for each and every parameter for review purpose.
    Report of third party performance
    Key Performance Indicator (KPI) for all level.
    Somehow I managing to do manually and some are on formulas, but it takes so much time.
    Thus, plz give me a suggestion what is best way to make easy of my Job and also how to learn VBA in excel 2007, sorry to say but is there any way to learn VBA in free of cost.

    Thanks & Regards
    Prabhu - 9867506425

  258. Ganesh says:

    I wanted to know how to change number format to percentage format by using conditional formatting in excel 2007.

    Example : If value in Cell A1 is 1, then table format should be in percentage or will remain number format.

    Please help me on this issue.

  259. kamal says:

    816636.87 x 1.35 x 12%(-) x 1.50 = 1455246.90
    2133592 x 1.35 x 12%(-) x1.50 x 2500 = 9505152360
    How Can I Putup The Formula

    • Hui... says:

      Simply type them in as below
      =816636.87 x 1.35 x -12% x 1.50
      Excel returns 1455246.90

      =2133592 x 1.35 x -12% x1.50 x 2500
      Excel returns 9505152360

      Excel converts -12% to -0.12 internally

  260. Bugs says:

    I am bowled on this website Chandoo....rocking...didnt know that people actually share so much of knowledge.......
    I am looking for help in creating a Knowledge base using MS Excel...simple piece
    you add information..i.e.., sentences, words, phrases, pragraqphs etc in 1 sheet...
    have a search field in second sheet
    you type in search field
    and it searches the information in sheet 2 with information
    should display the same in sheet 1
    just like google...
    trust you would be able to help me!!

  261. Srividhyayuvaraj says:

    hi chandoo

    Can you please guide me how to create a table which has to highlight due dates after given credit period.

    For eg: one invoice is of 13.05.2013 having a credit of 30days, in another column it has to automatically show in todays date it is 120days overdue

    Can you please guide me on the formula

    Thanks in Advance

    • Mohan says:

      @ Srividhyayuvaraj

      I assume your date format never change and its always in DD.MM.YYYY in text format.

      Invoice date in Column C2
      Credit days in Column D2

      Formula which I have prepared, you can put this in any cell:
      =IF(DATE(RIGHT(C2,4),MID(C2,4,2),LEFT(C2,2))+D2<TODAY(),CONCATENATE(TODAY()-(DATE(RIGHT(C2,4),MID(C2,4,2),LEFT(C2,2))+D2), " days overdue!!"),"")

      No Idea if this resolves your issue

      Just let me know if this helps you 🙂

  262. Mohan says:

    In one column, I have random dates (it can be repeated).
    Next Column have products - Mobile Phone and Tablets
    Third column has sales/counts

    How can I rank the sales/counts for a particular date and for Mobile Phone and Tablets separately?

    1. 10/01/2012 - Mobile Phone - 10
    2. 10/01/2012 - Mobile Phone - 20
    3. 10/01/2012 - Tablets - 40
    4. 10/01/2012 - Tablets - 30
    5. 11/01/2012 - Mobile Phone - 50
    6. 11/01/2012 - Tablets - 60

    Now I need to get the rank before date column as :

    • Mohan says:

      never mind!

      I tried myself and got the formula.



  263. Jasmin says:

    Can anyone suggest any format of Quotations?. Thank you.

  264. Jasmin says:

    Help me or any suggestion of Quotations format in excel.. thank you...

  265. umang says:

    please tell me farmula so that number is converted into words automatically.
    for example we write 15 and system converts fifteen

  266. Kuldeep says:

    Hi Chandoo,

    Awesome site..I get almost everything I need. need another help. I use Lotus notes in my office. do you have any macro using which I can send copy the content from excel paste into Lotus notes & send it automatically over a button of click.

  267. Venkat Mutya says:

    Hi chandoo do you conduct workshops in India

  268. sakthi says:

    Hi Chandoo
    How to write numbers in words
    like 12316 as twelve thousand three hundred and sixteen.
    This will be useful for bill preparations etc.,

  269. abbey says:

    Love collection of excel stuff... chandoo kudos for sharing

  270. juzar says:

    Dear all

    if i have below pattern of data

    a b c d e
    1 1 5 3 4 8

    2 8 4 5 1 5

    if i want to find f1 = 1 and G1 = c result 3
    F1=2 and g2 = d result 1

    please help

  271. evi says:

    Hi Chandoo
    It seems that 5 minutes ago my professional life was saved. I am an Elementary teacher and I was asked to start planning for my students on a hourly and monthly basis. This means of course I should plan for all the in- betweens, days and weeks. I have a long list of lessons (more than 500) which I will need to give to the children and follow through from now till the end of the year, being able to redistribute of course. Each student has an individual plan.This list is on a sheet of paper for the moment. I need to type it in.I haven't seriously used excel before. Can you please give me a starting point? I understand I need to create a kind of data base and then allocate the lessons to the students as I move on.Any "automation" tips welcome.Thanks a million!

  272. Munaf says:

    Accounting software with excel
    How will be accounting with excel?????????????

  273. RAM CHOUHAN says:


  274. Renata says:

    Thank you for this article and links - I absolutely adore Excel.



  275. Cathy says:

    Hi Chandoo

    Have any sample input forms trying to create one in excel

  276. Syed Mudasir says:

    I want to do 10 years data analysis of sales


    So please suggest which is the best way to do the forecasting on the said data

  277. Nike Air Max 1 Animal says:

    I every time spent my half an hour to read this blog's articles daily along with
    a cup of coffee.

  278. Nike Air Max 87 says:

    Hello! I've been reading your weblog for a while now and finally got
    the courage to go ahead and give you a shout out from Kingwood Texas!
    Just wanted to tell you keep up the good work!

  279. shekhar badgujar says:

    data vallidation first row type alphabet character and show list only data validation list pls help me sir

  280. Anil says:

    Hi Chandu, Your site really awesome. can u share sumifs function through vba. Its very big help for me

  281. PeterNYC says:

    Your spreadsheets got me great compliments on my project thanks!!!!

  282. Manish says:

    Hi Team,

    I have been a regular surfer of your website and this is one of the most helpful sites ever.

    Would need a little help here as i am trying to get a report / dashboard for calculating calibration variance automatically just by putting the audit data provided by QA's.

    This will be for call and email calibration and the number of participants can go to a maximum of 10.

  283. Suresh Narayanan says:

    Hi Chandoo,

    Thank you very much for sharing your knowledge.

    Speaking from the bottom of my heart, I learnt a lot from your website. You and your team are doing a really Awesome job.

    Recently I got promoted to Managerial cadre and I would like to implement few of my suggestions with the help of Excel and VBA macros.

    My question for you is, Do you any plan to conduct live classes on Chennai. If so, I kindly request you to drop a email along with the cost of the course.

    I prefer to attend only physical classes instead of online courses

  284. Durvesh says:

    Hi Chandoo,

    I made a Mailing tracker for my team.

    Our team Receive around 150-200 mails in each persons outlook and after that they have to reply for that
    , So i made tracker with the help of VBA to track unreplied mails but somewhere it is skiping 2 or 3 mails count
    I searched on google when a mail heat to inbox its generate a Entry ID or Message ID.

    My Questiion is that
    1. I want a VBA code to get either Entry ID ot Message ID from outlook?
    2. Is entry ID is same for inbox mail and sent mail?

  285. Johnb638 says:

    I really enjoy the blog article.Really looking forward to read more. Fantastic. deeffdafeffk

  286. zabi says:

    i want to learn VBA from begginer level.

    Please guide me.

    Awaiting for your quick respoce

  287. Rameshchandra says:

    Do we have any means of creating Whisker and Box plots for geochemical data. Geochemical data is data generated out of chemicla analysis of earth materials.

  288. Irida says:


    I am working on Career Management Interviews for each employee of a department.
    I would like to create smth interactive in excel because I would not like to create a separate sheet per employee including ( 100 sheets would be to much) :
    Name Surname
    Employee Data- Position, Department, Commencemet Date
    Salary History
    Position History
    Training received
    Other Benefits
    a space for coment

    Can smb help me with such an excel file or similar?


  289. […] Chandoo.org è uno dei siti dedicati a Excel più conosciuti. Sul sito sono disponibili numerose guide per imparare a utilizzare Excel e risulta essere presente anche una sezione dedicata ai modelli. Sono disponibili meno file rispetto ai siti segnalati in precedenza, troviamo però alcuni modelli interessanti da scaricare. Il download è gratis e non richiede la registrazione. […]

  290. Rajat Kumar says:

    HI Sir,

    I already subscribed your mails for latest excel tricks, But I just want to know, Can we break the password of a protected excel sheet using Macro ?

  291. Girish says:

    Hi Chadoo,
    I have created excel bounch of excel worksheet to manage my shop daily activity. I am running cake shop where daily purchase/sale activities are going on and it is really hard to calculate stock against cash on daily basis.

    Do you have any idea of can you help to automate the worksheet which i have created.

    Please let me know your email id so i can share my excel sheet with you.


  292. Geetha says:

    HI ,

    Column A i have Sales person name & in B Product ,each sales person will sale different product multiple times , i am looking for unique product count for each sales person.

    Help me on this

  293. Ashfaq Ahmad Syed says:

    Dear Sir,

    This is amazing site.I need to download Financial Modelling but that is not available now.Kindly either send me the same at my email address.
    Thanks a lot

  294. Dhamodharan says:

    Hi Chandoo,

    i need two macros:

    1. need reminder in excel "pop up" reminder should in the desktop with non-editable data in the excel.

    2. macro should to take a screenshot of the PDF Document.

    Can u please help me .....

  295. Hein says:

    Good Day,

    I need to display in a graph the alarm signals received. Signal to acknowledge; Signal to dispatch; Signal to completion. My challenge is to choose the right manner (graph type) to display and then how to display the time that it makes sense. This is to manage long alarm responses.

    For example: Signal to acknowledge:

    Operator A: 200 Signals in time (ave) 00:00:23
    Operator B: 450 Signals in time (ave) 00:01:23

    Many thanks in advance,

  296. Hein says:

    Good Day,

    I need to display in a graph the alarm signals received. Signal to acknowledge; Signal to dispatch; Signal to completion. My challenge is to choose the right manner (graph type) to display and then how to display the time that it makes sense. This is to manage long alarm responses. Underneath the data for signal to acknowledge:

    Operator Normal Total Signals Normal Average
    Operator A 7 00:00:22
    Operator B 37 00:00:24
    Operator C 15 00:00:05
    Operator D 5 00:00:09
    Operator E 12 00:00:27
    Operator F 12 00:00:13
    Operator G 2 00:00:08
    Operator H 14 00:05:02
    Operator I 25 00:00:39
    Operator J 13 00:00:04
    Operator K 14 00:00:02
    Operator L 9 00:00:12
    Total:165 00:07:42

    Many thanks,


  297. nagaraj says:

    sir how to change me name 'r nagaraj' into 'nagaraj r'

  298. Hema Rohith says:

    Hello Chandoo,

    very nice and informative site.
    I am working on Attendance and Shift tracker for our org.
    do you have anything supportive to this and anything to download and use?
    Please do let me know abt the same. thank you!

  299. Shamsu says:

    HI there tks for the very useful information about excel I want to know how to prepare a rental income and expense worksheet which will include an anversery increase in rental income expense . The spread should include yerly income exp over a period of 15 to 20 years
    Pls let me know if there is such aspread sheet

  300. Frank says:

    Hello Chandoo,

    I have been using your tips for years. Do you have a vacation planner spreadsheet. I am just feeling lazy creating one. Thanks.


  301. Mohammad says:

    my friend,
    i need ur help in macros. i have created an application for equipment details but the thing is when i clic on run 438 error is displayed. can you please give me ur email id so that i can attach dat app n send to u.
    appreciate ur early response.

    Thank You

  302. muhammad zeeshan says:

    i want to make excel data base in HR department. how to make plz help step by step method and formulas,

  303. […] als auch Fortgeschrittenenkurse bieten. Ihr könnt hier also auch was lernen! Die Navigation durch die Excel-Templates ist hingegen etwas unsortiert, was Suchenden nicht gerade in die Hände spielt. Von einem […]

  304. Marjan says:

    Dear Chandoo,

    I was trying to use your excel template " Birthday reminder" but when i enter more charactor in body (C5), formula showing value error.

    Appreciate if you could provide any suggession for this, also i would like to know if any formula available to attach pdf file from excel to email without VBA

  305. Kevin Streete says:

    I would like a dashboard to run my enterprise. Is there one that you'd recommend or have for sale. I need to do financials, sales, org charts, gantt charts, business enterprising....all in one! Thank you

  306. MUSTAFA says:

    how can i assign 10% tax from each male staff from WD which in their salaries are greater than 550$ per month?

  307. kousar says:

    hi Chondu,

    i need help on generating member shift allowance trend

  308. Kantesh says:

    Hi Chandoo,

    i want to create one dash board report. and that report should be show all data's in one chart with multiple options selection wise. for example four branches data available on month wise (jan to aug). data's like electricity cost, consumption and utilized materials. i want show these all data in one chart on selection basis like facility, month and description.

  309. Saiki says:

    Like the blog , Good stuff , Chandoo

  310. Manpreeet says:

    Hi every one,

    How to data validate in negative value.

    We need negative value error in during the file saving..

    With Regards

  311. Depack says:

    Hi chandoo,

    Do you have a template for a small business where we can track assets, stock in hand, profit and loss, etc. So that we can track the profitability of the business

  312. Preeti says:

    Dear Sir,
    It is very nice that you have utilized your mind to the almost optimum to create different variations of Excel.
    Can you help me with a template or system which will help me to track the quotes sent to various customers? It is becoming extremely difficult for me to track and I take a long time to update the sheet and report further.
    I searched everywhere but could not get it.
    I hope you understand.
    Can you help?


  313. Haris says:

    Hi Chandoo

    Do You have any good dash board template using project management like progress and only status of ongoing project is showing i am also having some difficulties to create sum if formula can you also send me all sum if logic so i can see which logic is fit my calculation sheet

    Haris Niaz

  314. khilan.shah says:

    hi Chandoo

    I am trying to do a spreadsheet for resource allocation - I want the names on the Left hand row and wc xxxx 7 hr booking, and & allocation and also total

    how would I go about setting this up - Please help

    and then a running total

  315. Quan ly kho tren excel says:

    Your sale dashboard is so great, i like the most the interactive ones.

    Thanks for showing me and other these exist 🙂

  316. Neeraj says:

    Can I get an evaluation copy for PPM dashboard before I purchase it? Pls let me know.

  317. parshuram more says:


    Is any way in excel send mail along with cc option to multiple users.
    i tried to mail merge but only one receipt it will add in mail merge option. if i want send same mail to user along with cc it is possible

  318. BIlguun says:

    Dear Chandoo,

    Firist of all, thank you very much for sharing us with your HUGE experience of EXCEL. I'm one of the your FAN from Mongolia. After i found your website, i learned many things of excel. GOOD JOB

  319. angel says:

    Hi Chandoo,
    I was wondering if you have one excel template for basic accounting with ledgers, journal and trial balance.

    Would be greatful

  320. Sean says:

    Hi Chandoo

    We spoke some time agi !Need some urgent help

    I need a VBA script in excel that will help me generate an IBAN number when a user enters his Account number into a field in Excel

    Could you assist me with the same.

    Note : for help , I can share withyou the Java script code logic. Just need it converted to excel macros format .

    Request your help on this one

    Thank YOu


  321. Mahesh says:

    Good stuff to learn for beginners like me.... I am truly thankful to Chandoo

  322. Raja says:

    hi chandoo
    Great site sir,
    Is there any code for HOUSING co operative society billl and receipt generation FROM DATABASE

    • Hui... says:


      Apart from using specific industry samples from time to time as examples, most of the content is generic and it is the techniques that are being taught here.
      If you search for Invoice using the search box at the upper right of this page you may find examples that could be modified to suit your needs

  323. Rajesh says:

    Hi All,

    I am looking for a VISA tracker template , which can track type of VISA (B1,L1)country, Visa start date and End date, Zone (North America, APAC) can you please share some file where can we modify and use accordingly.

    Rajesh Iyer

  324. angel says:

    Hi Chandoo, or anyone out there,
    I am seeking your help in setup up an excel spreadsheet to do record accounting transactions and do automatic trial balance.

  325. Jeetesh says:

    Hi Chandoo,

    I would like to link NSE and BSE website in a Excel Workbook for getting the corporate action details for the day based on Ex date , Record date and Announcement date for all the listed securities in both the websites.

    Would request you to kindly advise me on this

    Best Regards,
    Jeetesh Jain

  326. James Laker says:

    Wish to buy 'Project status Dashboard, with the following considerations and little extra development please.
    Tab 'Data' Cell C3, something like =IF(AND(C4%>0,C435%,C468%,C4""")
    Also, Very much need the following added;
    • Degree of achievement (or otherwise) of financial targets.
    • Degree of achievement (or otherwise) of date targets.
    • Scope creep – (how many requirements added to the project after initiation)
    • Phase encapsulation achievement (how many defects identified at a certain stage)
    • How much “dead time” did project members experience due to major code revisions, downtime etc

  327. Indrajit Goswami says:

    Hi chandoo sir,
    I am a small contractor, I have a very little knowledge about excel. I am facing a problem. Because of my job I have to generate invoice and measurement sheet through excel. The problem is, we write measurement in ft & in (eg 1' 6" i.e. one foot and six inch) but in the formula area we have to write 1.5.
    Is there any easy way that I will type just 1.6 and excel automatically writes 1' 6" and calculates as 1.5.
    Eg - 1' 6" as length X 1' 6" as Width = 1.5 X 1.5 = 2.25 SqFt

    And another thing how to convert SqFt to SqM and CuFt to CuM

    Please Help

  328. shaikh imran says:

    Hello Sir,


    I Have A Two Issues In This Worksheet Can You Please Help Me To Complete This Workbook.

    This Workbook Is Actually Our Timesheet

    1) I Have A Drop Down List Contain Month And Group For Each Month I Put Input's For Each Employee I.E 3 ,3,3,3 Ep, Lp...Etc But When I Change To Next Month Or Other Group The Inputs Cell Does'nt Change I Want This Also To Be Change Along With Month And Group's

    2) I Want To Highlight Each Snr. Engr. In My Drop List

    Please Help Me With This Query

    Thank You

  329. Santosh Shrestha says:

    I ve folowing problem, it doesn't filter while double click the cell which i want to see

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

    Dim dccolumn As Integer
    Dim dcvalue As String

    dccloumn = ActiveCell.Column
    dcvalue = ActiveCell.Value

    If Application.Intersect(ActiveCell, [headers]) Is Nothing Then

    If ActiveCell.Value "" Then

    ActiveSheet.Range("A:o").AutoFilter Field:=dccolumn, Criterial:=dcvalue

    End If

    End If

    End Sub

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Dim rownumber As Integer

    rownumber = ActiveCell.Row

    If Application.Intersect(ActiveCell, [headers]) Is Nothing Then

    If ActiveCell.Value "" Then

    Range("a6:O105").Interior.ColorIndex = x1None

    Range("a" & rownumber & ":o" & rownumber).Interior.Color = RGB(255, 255, 9)

    End If

    End If

    End Sub

  330. Result says:

    What's up, I would like to subscribe for
    this weblog to take latest updates, thus where can i do it please help.

  331. sivaramakrishnan says:

    Based on the Location, Party name and category I want to Calculate the Sales Tax portion and the Ex factory price.

    for Eg: Knits is 1% and Wovens is 2%
    Location : Tamil Nadu : LST is 4%
    Other states : :CST :5%

    If Tamil Nadu is clicked in location against the Party Other states should not come.

    The formula should be in such a way that, based on the category (Knits or Wovens) and Location and Party the Sales Tax and other price be picked up automatically.

    Please keep the MRP be Rs.100

    Please help me out.


  332. shailesh says:


    i am having different vendors with different price quots and capacities. once i receive the plan for the month, i need the formula for allocating the plan between those vendors based on the 1st vendor with lowest price with his full capacity and then followed with 2nd best vendor
    Plan of 100 Nos
    Vendor 1 - price of $1 with capacity of 50 Nos
    Vendor 2 - price of $1.5 with capacity of 40 Nos
    Vendor 3 - price of $2 with capacity of 60 Nos

    then i need the solution as, 1st to allocate the plan of 100 to Vendor 1 with lowest rate with his full capacity of 50, then best to Vendor 2 with price of 1.5 with 40 Nos and then remaining plan to Vendor 3 with price of 2

  333. Kundanlal says:

    Require help in constructing condition in formula..


    It is giving me 0 answer.. I wanted to have a output where condition is valid for ">=&($G$5/ROUND((($E$5/12)*$E$2),2)) > 100%, name in range c to c35 = BM..

    If required, I can upload/forward sample file..


  334. arun says:


    i want to convert my excel calulator to HTML

    kindly help me with the necessary language that is required or any process..

    so many softwares are available but do not want to use.

    Arun Pillai

  335. Asit says:

    Any idea how to overcome the problem of multiple matches when using vlookup

  336. […] Templates (Hichert Excel Beispiele, Chandoo Templates) und Tools (Zebra BI, chart-me, […]

  337. Suresh Babu R says:

    Dear sirs,

    I want to know how to calculate the age as on today when I enter a date of birth.

    Please let me know the formula.

    You had published it once but I somehow lost it.

  338. alprofy says:

    i need steps to follow on how to draw a vertical average line across a bar chart.

  339. hie sir , i appreciate the good opportunity you have given to many excel enthusiast like me i just managed to create a football match predictor using excel however am just a learner in excel not an expert yet... do have an example of a soccer match preditor

  340. Juan says:

    Hi Chandoo,

    Where can I find some information about interactive calendar with several events per day to display?

  341. Nicole says:

    Hi Chandoo
    I am keeping records for a two Badminton competitions. I've set up a spreadsheet which takes records the scoresheets easily (turning them into tables) and summarises them with formulas. My problem is that I need to get individual player statistics out of this for each game (ie games played against each opponent and games won with percentages and totals). Most of the games are doubles (so four players) - there are 4 player columns to sort through. 36-48 players in each comp, 10 weeks of games. This takes about 20 hours each competition to do.
    At the moment I'm filtering by player and reducing it down to individual player manually then turning that into a pivot table.
    Everything is working on tables and name text values.
    Do you know of any visual basic macro I can use to extract the results across four columns and analyse and summarise it by player?
    eg look for player1, if player 1 is in column 1, then opponent is in column 3, if player1 is in column2 then opponent is in column4, if player1 is in column3 then opponent is in column1 if player1 is in column4 then opponent is in column2. get opponent (eg player5) and get score and winner. (at the moment I'm using concatenate functions to filter).
    I know this would be more easily handled by a database, but even the specifically designed badminton software they have can't deal with this.
    Do you have any macro examples that would suit this function?

  342. Qamar says:


    can you please give me excel calculator to calculate resistance and support level of stock trading.

  343. saleem says:

    I need help with attendance fact report a dashboard of attendance were we can reflect total number of lates, then lates above 8:30, lates = or above 9:00 and lates = or above 9:30
    and lates after 17:00 hours
    separate block of administration and domestic staff
    top 3 people with highest lates
    and can search statistic of individual person by name of id
    i have less time pleasee please please HELP
    my chando id is D3c3nt-m3n

  344. anyone know or have a template on how to do the following.
    need multiple boxes with key words for example:
    Customer called
    You click on customer called box and it inserts that text in a text box at the bottom.
    I then select a different box which may continue that sentence.
    for example - to buy some eggs.
    I select to buy some eggs so the text box at the bottom now says
    "Customer called to buy some eggs" and then I keep building a note or message to be then able to copy and paste?

  345. Deepak says:


    Do you have any excel formats to maintain cricket stats for 20 teams
    where in once feed should give us all the stats for the game

    Please let me know

  346. Aswani says:

    Great site. Valuable resources. I have been trying to master excel from long time but it never looks enough. There is so much to know and learn. Your tips are extremely useful. Thanks for sharing this excel templates.

  347. sacchidanand says:

    Hiie EveryOne,
    please suggest me if it is possible to convert language in excel form.
    if it possible then mail me suppose i have excel file in Marathi language so i want to convert it into English format

  348. Aleena shiekh says:


    it ll be very thank full to your reply of my one query about which i still did not get proper answer or sample

    i wanna know how to move data & values from summery sheet to multiple destination sheets by their name and data separately and respectively to each sheet automatically.

    i got sample file to move data to another but that is not
    working and effecting on other sheets which is 1, 2 & 3 etc please give proper any sample and explain whether it is by VBA & by else formula.


  349. Anil says:


    My team were using around 12 types of overhead expense reports. So i want to standardize all into one best overhead report.

    Any suggestions or template you already having?


  350. Sumeet Pokharna says:

    Dear Chandoo,

    I am looking for customize Inventory management system in excel for my organisation, please let me know how I can avail your services in this regards.

    Let us know details required from my end and your fees for the same.

    Thank you

  351. Gnaneshwar Gaddam says:

    thank u very much! Nice information..

  352. Princeloo says:

    Hi Guys,

    Could you please reactivate the link for me to redownload these files?

    Thank you and regards,


  353. Fredrick says:

    I want to create a database to track Food Vouchers that will track Vouchers that we:
    1) Print
    2) Submit to be signed/approved
    3) issued to our distribution agents
    4) number distributed to beneficieries
    5) number redeemed at the selected retailer.

    Can any one assist me to come up with a template please

  354. Vamshi says:

    Can you kindly tell me how much time it takes for you to send the login details after receiving the payment? I made the payment about 10 hours back and yet to receive any details except the payment receipt mail which I already forwarded to you. Tried to reach you on 91 814 262 1090 but not able to connect.

  355. Mark Clerigo says:

    The discount code is not working

  356. wan says:

    these template are amazing!!impressive..

  357. kanu bhatia says:

    Hi chandoo,
    Beautiful house & surroundings Love it if possible share some interior will be nice.
    Looking for template for " Mutual Funds Portfolio Tracker- USA"
    I did see for India.
    Also looking for spread sheet for "UBER" daily records keeping for each Date/ride/miles/tolls/bridge tolls/ gas/repair /car loan payment/repairs /car wash/ few extra blanks columns future add on/remarks or any think u think of, to keep my annual record for USA tax purpose.
    If have any ready template will do.

  358. Lourival says:

    very show this site, I spend hours and hours browsing and every moment I find new contents about Excel. Congratulations

  359. Amit Soni says:

    Hi Can you please help me to provide macro or vba code to login into website using username and password.

  360. sandeep says:

    Hi Chandoo.

    Your Mutual Fund tracker is awesome. I was using moneycontrol but now using your template. Can you make option for SIP investment in that template.
    Then it will be 100% complete.


  361. Ravi says:

    Hi Chandoo
    awesome templates. am looking for if any template is available for IFRS9 expected credit loss calculation.
    appreciate if anything is there to share.

  362. sepid says:

    hello chandoo
    your website is very good
    im Industrial Engineer.
    Our factory make glass cleaner and other wax.
    we have 8 machine and 21 product.
    please help me to project program.
    best regards

  363. Ateeq ur Rahman says:

    Hi chando ,

    Need dashboard for oil & Gas Turnaround , My requirement is how to index with different graphs within Developer for Block A , Block B , Block C and Block D.
    Suppose Block A consists of several unit like U-91 , U-92 , U-93 , U-94 and its overall progress by combining all the units Plan Vs actual progress % . Need to show in Bar Charts using developer.

    Please help in this regard to develop.

  364. chiruu k says:

    it is a good blog.

  365. kingsley s.. says:

    grate site....please i want a predictive model for virtual soccer trading, similar to forex trading.....the model i created is not very good for my trading but it gave me a clear picture of the market...please reply..

  366. I Das says:

    Dear Chandoo,

    This is a beautiful website. I have used loads of ideas and help from here. However, i need some more help. how do i get in touch with you?

    Thank you.

  367. Madhu Ramji says:

    How to resize checkbox not it's frame

  368. Herbert Mueller says:

    Dear Sirs,
    is there a valid download link available vor the issue tracker template?

    Please advise.


    Herbert Mueller

  369. KAMALESH menaria says:

    Sir i have a table like this
    A b c d e
    1 12 ww1/2,xx1/2 0.3 0.5
    2 12 ww1/2,xx1/2 0.6 0.4
    3 15 Q 1 0.66 0.11
    Now I want vba code for create new table from this
    A. B. C. D. E
    1 12 ww1/2 1/2of col D. Sum col
    =0.015. E 0.9
    2 12 xx1/2. 0.15. 0.9
    3 15 Q 1 1 0f col
    D = 0.66 0.11

    Please sir vba code this

  370. SC says:

    I am a Supply Chain professional. I would like to start Sales and Operations Planning in my company. Need help to start this by guiding me any excel file.

  371. Krishna Kumar says:

    I am looking for Recruiting dashboard.

  372. Brian Nagele says:

    Alright so it's not really a question about the topic at hand here but... how long does it take you to put together these kind of posts? Is it easy? Like did you have to research all this stuff? I've been wanting to start a blog myself, so just curious. Sorry not totally relevant but figured I'd ask. Thanks in advance

  373. Yasir says:

    Good Day,
    i have 2 branches and have 8 to items in every store. i want to keep track for each shops inventory in 1 sheet so that if 1 item is getting low in 1 shop can transfer it from other. do you have any sheet that can do this

  374. angel says:

    i need below:-
    1- visa for employees tracking sheet
    2- employeement info. table
    3- attendance table


  375. Sadiya sultana says:

    Hi Chandoo
    I saw your excel template its really very good
    if is possible for you please answer my question:
    I want a template where when user enters the value in one cell the result should be autopoulated based on the rule applied to the cell i.e(entered value say 48)the output should be 6 like entered number should be divided by 8 and display me 6 in corresponding cell....i want this for entrire cell shert with macris can you help me with this...

    Thanks in advance

  376. Jitender Kumar says:

    Hi Chandoo,

    I hope you & your family are safe and healthy!

    is there a way to get the number series against the duplicate data?
    Like we have some duplicate data set in coulmn A (123,111, 102, 123,122,111,123)
    and the answer should be like in another column B (only double code answer) ( 123 "1",111 "1", 102 "1", 123 "2" , 122 , "1", 111 "2" , 123 "3")..

    I know about the countif function but the problem is when I apply over there it gets hang my excel file due to a huge data set.

    So please help me provide the simple approach to get the duplicate count series.

    Many Thanks!

  377. Roni Hussain says:

    Dear Chandoo,

    i just got introduced to your site by accident. I wonderful if
    you have an excel data similar to crm base to keep track of registration of new employee, register them in the excel format, passport expiry, visa date, and other crucial like shift tracking and excel format.

    kindly assist.

    best regards

    Roni Hussain

  378. Kisorio says:

    Kindly assist me with a School Management System in Ms Excel. Thank you!

  379. Sudarsan says:

    Dear Mr.Chandoo

    We are doing business Gas distributor stockists in multiple locations, Request you please arrange the excel format for, monthly each location sale and Purchases, and closing stock of cylinders at each location

    Thanks and Regards

  380. Kiran says:

    Hi Chandoo,

    i require a basic excel template where the Rows indicate serial number, Truck Registration, Permit No (4 - 5 rows) only to enter serial number, factory, Tonnage (that would accept three decimals after .) and transporter company.

    daily there should be a side table where we could have rows for Company ( where we could change in future) then in the next row we need to have tonnage ( where it would calculate the tonnage for that particular company) then a row for Transporter Company ( where we could update in the future i.e. add more companies) and finally No of Trips ( where it would calculate the no of trips by trucks assigned to that transporter company)

    this needs to be saved in a pdf format... and emailed to an address


  381. Sharif sk says:


    I need a program for my magazine to store my subscribers database.
    I need the following in the program
    # Add subscriber
    # Subscribers code search
    # Search option country wise
    # Search option state wise
    # Search option District wise
    # Search option village wise
    # Search date of expire
    # Search date of subscribe
    # Receipt entry
    # SMS reminder to subscriber on expire/renewal
    # Email newsletter optional
    # Print or export or download options

    Plz anyone can help for this

  382. Ian says:

    HI, i am trying to make a monthly timesheet, mon to thu, 20th to 19th, start time, finish time, 30mins taken off as break, total hours, overtime, but when clocking in, you get paid on 15 minute intervals, so if clocking in at 4.55, you get paid from 4.45, and if you clock out at 5 25, you get paid to 5.15.

    Any chance of making one for me?


  383. Cory Hendrix says:


    I am looking for a template that uses the Bing Maps MIO API. I have your distance and duration template, which is awesome, but I am trying to get something that uses MIO to perform route optimization.

    Please help if you can.

    Thanks in advance.

  384. Shashi Kumar says:

    Hi sir you are providing really awesome things. Can you provide a sheet for payment outstanding amount alert of customer with days or credit days allowed to the customer so that we can follow up on time for the payment. Thanks

  385. Diamond Dragnov says:

    I would like to ask the community that can I use above templates for Microsoft Excel Viewer that I only used to view and print spreadsheets. I downloaded it from https://filesmint.com/microsoft-excel-viewer/.

    Thanks for help

  386. USMAN says:


    I want excel spread sheet for easy cricket betting

  387. ravi ak says:

    Hello sir,
    This website is really awesome.

    I am a maintenance engg in reputed company managing spares their.
    So i need a sheet where I can manage the spares acuretly.

    I need
    Item code
    In stock
    and reminder when the spare goes below the MOQ value and generate the alarm thru mail/message/popup notification.

  388. RICHARD TOM says:


    I have an Xls file the due date needs to be animated or pop-up reminder
    should show whenever I open the file. Can you help me in this regard.



  389. Cappa says:

    how to using excel to calculate fast moving item , slow moving and non moving item in inventory ,

  390. Ryan says:

    Thanks, It's a great thing that this article suggested the importance of Excel Templates.

  391. Exactly what I was looking for to help me with my new job. Great templates thank you for sharing!

  392. SIVA says:

    I am actually working on work progress timer for customer information.
    whenever i enter customer details on each column in excel the count down timer has to start and it has to be removed from the list once the count down timer stops. please guide me on this.
    i can able to create in single column i want atleast 15-20 column's at a time.

Leave a Reply