Top 10 Excel and Chart Templates

Sales Dashboards – 32 Examples, Vote for your option now [Visualization Challenge #2]

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in…

2010 Calendar – Excel Template [Downloads]

Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010…

Master Excel 2007 Ribbon with this Free Learning Guide

Over the last few years, there has been much debate about the merits and perils of Microsoft Ribbon UI in Excel 2007. Personally I think ribbon is a good way…

Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]

Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities…

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you…

Project Management: Show Milestones in a Timeline [Part 3 of 6]

Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team…

Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving…

Gantt Charts – Project Management Using Excel [Part 1 of 6]

This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over…

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List View in The…

73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman

add to del.icio.us | add to Stumble

How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore?
Well, I…

Project Management Dashboards (recommended product)

Project Management Templates for Excel
  • Using My Excel Project Management Templates you can make dynamic project status dashboards from your data in few minutes.
  • These templates make you better at project management and reporting.

Click here to try Excel Project Management Templates

Free Excel Templates & Downloads

A New Year Resolutions Template that Kicks Ass

Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared…

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]

This is second part of 2 part series on conditionally formatting dates in excel.

Highlighting Repeat Customers using Conditional FormattingIn yesterday’s post we have learned how to conditionally format dates using…

Sales Dashboards – 32 Examples, Vote for your option now [Visualization Challenge #2]

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in…

Track Your Mutual Fund Portfolio using Excel [India Only]

Excel is very good for keeping track of your investments. Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the…

How to Find Dates of Public Holidays using Excel

Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the popular public holidays like – labor…

Make a Quick Thermometer Chart to Compare Targets and Actuals

Comparing values is one of the reasons why we make charts. So today I am going to teach you a handy little trick to make a thermometer like chart to…

2010 Calendar – Excel Template [Downloads]

Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010…

Christmas Gift List – Set your budget and track gifts using Excel

Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor changes to it and sharing it with…

Personal Budget Spreadsheet [Downloads]

At PHD household, we believe in using money wisely. Both Mrs. PHD and I come from very modest backgrounds. Our upbringing has taught us value of money in the most…

Top X chart – Show Top X values of a chart Interactively

Two charting principles we hear all the time are,

  • Sort your data in a meaningful order before plotting it.
  • Show only relevant information, not everything – because un-necessary information clutters the chart.

Today…

Lets Pimp a Gauge Chart [Chart Porn Friday]

Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail…

Making Interaction Plots using Excel

Yesterday I read about interaction plots on junk charts where he points out the merits of an interaction plot. Interaction plots show interaction effects between 2 factors. For eg. you…

Project Dashboard + Tweetboard = pure awesomeness!!!

Check out an implementation of project dashboard along with tweetboard by our reader Fernando. He says, it “turned out to be a great success”. I am so happy for him….

Prevent Duplicate Data Entry using Cell Validations

We all know that data validation is a very useful feature in Excel. You can use data validation to create a drop-down list in a cell and limit the values…

Solve Sudoku Puzzles using Excel [because it is weekend]

Sanjay, my colleague is an avid programmer and excel enthusiast. In his spare time he wrote a small VBA macro to solve Sudoku. Sudoku is a very famous number based…

Making a chart with dynamic range of values

We all know that to make a chart we must specify a range of values as input.

But what if our range is dynamic and keeps on growing or shrinking. You…

Baby Feeding Chart using Excel

While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby’s feeding and sleeping activities on day…

Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Project management dashboards, project status reports help stakeholders, project sponsors and team-members can understand project status very quickly. In the last installment of project management using excel, learn how to…

Recipe for a Donut Bar Chart

We all know that bar charts can be used to display values spread across various categories or times and pie charts / donut charts can be used to display percentage…

Master Excel 2007 Ribbon with this Free Learning Guide

Over the last few years, there has been much debate about the merits and perils of Microsoft Ribbon UI in Excel 2007. Personally I think ribbon is a good way…

Excel Check Boxes, Even Simpler Way

In how to get tickmarks in excel, Jon commented,
“[...] Better yet, use real checkboxes, so the user can change them with the mouse.”

That got me thinking,

In excel, you can add…

Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]

Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities…

Pareto Charts – How to do pareto analysis using Excel?

A Pareto chart or pareto graph displays the importance of various factors in decreasing order in columns along with cumulative importance in a line. Pareto charts are often used in…

Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]

Yesterday we have posted how to use excel combo charts to group related time events. Today we will learn how to change the event grouping dynamically using form controls.

This effect…

Using Combo Charts to Group Related Time Events [Charting Goodness]

In his latest book, Now You See It, on pages 165 and 166 of the book, Stephen Few discusses how grouping related time intervals can facilitate analysis of data. As…

50 Best Cities for Finding a Job [Incell Dashboard using Excel]

We all know that incell charts are a very cool way to explore and visualize data. Personally I like them so much that I have written several tutorials on it…

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you…

Waterfall Charts using Excel

Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially…

Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]

Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working…

Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)

In this installment of spreadcheats, we will learn how to use goal seek feature of excel. We will build a retirement savings calculator using excel. We will learn to use…

We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]

In this installment of Chartbusters, we take a look at a poorly constructed choropleth of medicare reimbursements in US and suggest cure for it. The post is from our Guest…

Use burn down Charts in your project management reports [bonus post]

A burn down chart is a good way to understand the progress of a project. It is like a run chart that describes work left to do versus time. In…

Generating invoice numbers using excel [reader questions]

Learn how to generate invoice numbers, tax codes etc. using Microsoft Excel. In this example we will take a real life example shared by Michelle and findout how we can…

Make an Impressive Product Catalog [spreadsheets for small business]

It is the customer on the phone again, she wants to know what products we have.
How cool would it be if we can send her a spreadsheet with all the…

Project Management: Show Milestones in a Timeline [Part 3 of 6]

Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team…

Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving…

Gantt Charts – Project Management Using Excel [Part 1 of 6]

This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over…

Incell Dot Plots in Microsoft Excel

Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data…

Networkingdays() an improved version of networkdays formula

We all know that networkdays() an extremely powerful and simple excel formula can help you calculate no. of working days between 2 given dates.

But there is one problem with it….

Venn Diagrams in Excel

This post is a testament that readers of this blog are way cooler and enterprising than I am. Justin, who I must say, has some really amazing excel skills, contacted…

Tweetboard Implementations – Download and make your twitter style dashboard today

Check out two fabulous implementations of tweetboards in excel. Download the workbooks and play with them yourself. Thanks Fernando and Lee for sharing these workbooks with us….

Statistical Distributions in Excel [spreadcheats]

Excel has very powerful formulas and add-ins for performing almost any kind of statistical analysis. Today we will learn how you can make a statistical distribution of test scores using…

Excel Tips Submitted by You [Part 2]

In today’s installment of “your week @ PHD” we will learn how to use array formulas to refine text search, a bunch of very useful keyboard shortcuts, and a very…

Tweetboards – Alternative to traditional management dashboards

Here is a fun, simple and different alternative to traditional dashboards. Introducing….

Visualization Challenge – Budget vs. Actual Performance

Here is your chance to win a copy of The Visual Display of Quantitative Information by Edward Tufte, all you need to do is visualize budget vs. actual performance of…

Excel Conditional Formatting Basics

Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of…

Us vs. Them – Compare Sales Performance using Charts & Form Controls

Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a…

RSS Icon using Donut Charts – Because it is Weekend

RSS Icon using Donut Charts – Because it is…

Japanese Candlestick Chart – Excel Tutorial

Japanese Candlestick Chart or Candlestick Chart as they are popularly known are one of the most commonly used stock charts.Today we will learn how to make a candlestick chart in…

Market Segmentation Charts using Conditional Formatting

Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So…

Write Your Own Twitter Client using Microsoft Excel

Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare…

Visualizing Search Terms on Travel Sites – Excel Dashboard

Microsoft excel bubble chart based Visualization to understand how various travel sites compete search…

Sales Funnel Charts in Excel – Tutorial

Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that…

Excel Basics – What are Combination Charts and How to Make One?

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph…

Creating Excel Art from Images [spreadsheet fun]

Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and…

2009 Calendar Template in Excel – Now with week starting on Monday

Stružák, one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on…

Brick Charts in Excel – an Alternative to Gridlines

Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up.

Here is how…

Free Excel Calendar Template for year 2009 (and all years up to 9999)

Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)

Go ahead and download it, change the year number in the first…

Advanced Data Validation Techniques in Excel [spreadcheats]

Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series,…

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates,…

Select & Show One Chart from Many

Yesterday I have learned this cool excel charting trick and I cant wait to share it with you all.
The problem: I have too many charts & want to show one…

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

This is a Guest Post by Robert on Visualization Techniques for Excel Dashboards.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List View in The Dashboard
Part…

Sorting Text in Excel using Formulas

Sorting text is such a day to day activity that it always surprises me why Excel hasn’t provided a simple spreadsheet formula for doing it. Of course you can use…

Sports Dashboards in Excel – A Tutorial

One of my favorite cricket player, the GOD – Sachin Tendulkar has become highest test run scorer.
What do I get if Sachin becomes highest scorer, you may ask.
In order…

The New Poor – Internet Penetration Rates by Country

Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a…

More than 3 Conditional Formats in Excel

One of the most popular posts on this blog is how to become excel conditional formatting rock star. Quite a few commenters there asked me if there is a way…

Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

This is a Guest Post by Robert on Visualization Techniques for Management Dashboards using Excel.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List View in…

Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Ever since we moved to Seattle we have been watching TV game show – Deal or No Deal (for lack of better things to do in the hotel) The game…

Simple Todo List application using Excel – Download and become productive

After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel.
Since most of us use Excel on day to day…

You are NOT spider man, so why do you use radar charts?

There are few charts in excel that are as revolting as a radar chart. The purpose of a radar chart is to compare m options across n parameters so that…

Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]

This is 4th part of Creating Management Dashboards in Microsoft Excel 6 post series by Robert.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List View…

Hack together a Gauge Chart in Excel without sweat

Gauges are a familiar metaphor, everyone can understand them, you can see them everywhere – near your stove, ac, car, gaming console, pc – you name it. So, when…

Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List…

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List…

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert.
This 6 Part Tutorial on Management Dashboards Teaches YOU:
Part 1: Creating a Scrollable List View in The…

It is show time baby! – better designer clocks to display time in your spreadsheets

My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even…

Polar clock using donut chart [Excel Visualization fun]

Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to…

Plot your data around the clock [Excel charting idea]

If your reports include hourly distribution of data like,

Customer footfalls in your store
Page views of your site
Customer service calls to your toll free numbers

here is an interesting charting idea…

The Olympic Medals by Country Chart – Improved now

My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it.
Robert from Germany shares an interesting approach at doing this,…

Doing the NY times Olympic medals by country year visualization in excel

When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you…

Excel Bullet Graphs

Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics.
Howmuchever effective they are, the sad truth is there is…

Bingo / Housie Ticket Generator in Excel

I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why…

Incell Bar charts – Revisited

I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without…

Partition Charts in Excel – alternative to pie charts [visualization hack]

Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What…

Hot Thermometer Charts in Excel – here is a cool way to do them

Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent…

Learn Excel IF Formula – 5 Tricks you Didnt know

Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just…

How to add a range of cells in excel – concat()

Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of…

Gantt in 60 seconds – churn out an excel project plan in no time

One of the most frequent tasks for any manager is “planning”, be it putting together a hiring schedule or designing a jumbo jet, it all starts with a simple project…

Creating in-cell bar charts / histograms in excel

Ever since writing the create in-cell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs. An in-cell bar would probably…

Create in-cell pie charts in Excel

Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard.

Download free pie chart font…

Create Cool Tag Clouds in Excel using VBA

I was toying with the idea of creating a tag cloud in excel – as a form of new visualization, this could be useful when you have medium amounts of…

Mutual Fund Portfolio Tracker using MS Excel

Would you like to spend next 5 minutes learning how to create an excel sheet to track your mutual fund portfolio?
click here to download mutual fund portfolio tracker excel…

73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman

add to del.icio.us | add to Stumble

How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore?
Well, I…

Conditional Formatting in Excel – 5 Tips to make you a Rockstar

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs…

How to: sharing trip expenses using excel

Yesterday we were calculating our Washington trip expenses and it occurred to me that if there is an excel template where I could enter the trip expenses and who paid…

The Art of Excel Charting

Yesterday while going through my feeds, I have landed on this post about the demographics and use-figures of various social networking (2.0) tools, et al (by businessweek) on think:lab blog….

Start Early

Financial freedom, or not having to work for someone is the ultimate dream for anyone wearing an access card and refreshing his/her mailbox every five minutes. Just incase you are…

Find out whether you need a house or not in 60 seconds

Most of my classmates and friends have started purchasing houses. This coupled with the fact that I am in coveted DINK (double income no kids) group now have prompted me…

317 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
      muscat

    • 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 –

      http://www.excelapps.webs.com/downloads

      -Sachin Agrawal

    • 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.

  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.
    Regards
    Waseem

  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.

    http://www.download.com/Classic-Menu-for-Excel-2007/3000-18483_4-10637173.html

    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.

  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:

    Hello,
    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?

    thanks

  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

    @Sunita:

    (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.

    Thanks
    Stephen

  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.

    Jason

  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.

    Cheers
    Revv

  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.

    Thanks

  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:

    http://bxcapricorn.blogspot.com/2009/10/one-more-jab-at-candlesticks.html

    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

    http://www.hichert.com/de/consulting/schaubilder/65
    and
    http://www.hichert.com/de/software/exceldiagramme/55

  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?

    apb

  38. Russ says:

    Atul,
    You can claculate the number of days in each month using the following formula assuming the date is in cell B2:
    =DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1)
    Essentially, this just goes to first day of the next month then subtracts a day.

  39. Rick Rothstein (MVP - Excel) says:

    @Russ

    You can combine the “first day minus one” part of your formula directly in the Date function call like this…

    =DAY(DATE(YEAR(B2),MONTH(B2)+1,0))

    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:

    Hello:

    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.

      Regards
      Nipendra
       

  45. Amit Cohen says:

    Hi
    I have learned a lot today, thanks for all posts and samples
    I now have lots of home work to do :)
    Thanks,
    Amit.

  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.

    Tyler

  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,
    Shahid

  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,
    Dilan

  55. Hui... says:

    Dil
    What about the Task Manager in Outlook?

  56. Dil says:

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

    Thnx….

  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:

    Chandoo,

    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

    Pekay

  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

    Regards

    B

  62. Hui... says:

    @MK
    Try:
    =IFERROR(FIND(“ate”,”water”),”False”)
    or
    =IFERROR(FIND(A1,A2),”False”)

    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.

    Thanks

  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.
    Lottomaniac649

  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!
    Bye!

  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
    Brian

  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:

    @Adel
    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:
    http://www.cpearson.com/excel/StartupErrors.aspx

    • 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).

  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:

    @Toyese
    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:

    Hello,
    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.

    Regards

    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:

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

  91. baran says:

    hi
    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:

    @Shailesh
    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:

    hi,
    thax to provide us easy to find anything in excel

  96. charu says:

    Hi,
    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:

    I WANT TO LEARN V.LOOKUP AND OTHER IMPORTANT SUBJECTS IN EXCEL
    BUT I AM NOT WELL TODO IS THERE ANY FREE CLASSES

  98. Hui... says:

    @ Selvam
    Chandoo.org is a great spot to learn the basics and then some more about Excel
    For VLookup specifically try:
    http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
    or
    http://chandoo.org/wp/tag/vlookup-week/

    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:
    http://chandoo.org/wp/excel-school/

  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:

    Hello
    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.
    {=MIN(IF($A$11:$A$808=F2,$B$11:$B$808))}

    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:

    @Ghida
    This is an Array Formula
    Enter the formula as
    =MIN(IF($A$11:$A$808=F2,$B$11:$B$808))
    Then press Ctrl Shift Enter, Not Enter by itself

  103. vickeyvishal says:

    Hi,
    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:

    @Christian
    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

    Thanks

    • 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:

    hi
    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 !
    Ghida

  117. Ghida says:

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

    thx

  118. Hui... says:

    @Harish
    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:

    Hi
    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 :P

  125. Hui... says:

    @Ghida
    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

    Ghida
    Lebanon, Beirut

  127. deepak says:

    Ghida,

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

    deepak

  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:

    Hi,

    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
    Update
    End Sub

    Sub Update()
    NextTime = Time + TimeValue("00:00:01")
    If Range("TimeToGo").Value “Done!” Then
    Range(“TimeToGo”).Calculate
    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.

    Cheers
    Roshan

  132. ahhhmed says:

    hi,
    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.

    Thanks

    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:

    Hello
    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 ?

    thx
    Ghida

  138. MK says:

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

    http://www.ozgrid.com/Excel/autocomplete-validation.htm

  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:

    @Isma
    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:

    Hello
    may i know what are the instruments control pls?

    thx
    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 !!!!!!!

    Regards
    BG

  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

    Thanks
    Pankaj

  150. john says:

    hello,

    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.

    Ram.

  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?

    Rajesh

  157. Imtiyaz Shaikh says:

    Hi,Chandoo

    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:

    Greetings

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

    Thank

    Ata Betero

  160. Hui... says:

    @Ata
    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.

  163. KAILAS DABHOLKAR says:

    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… :(
    thanks

  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.

    Persol

  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.

    Thanks

  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:

    @Srinivasu
    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:

    Hi.
    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.
    Regards
    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:

    Chandoo..

    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.

    Regards,
    Murugan

  186. Sohel Ahmed says:

    Chandoo

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

    Regards
    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?

    Vikram

  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

    regards

    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?

  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:

    Hi,
    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:

    Hi, 

    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:

    Hi,
    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.

    regards
    Dave

  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?
    Thanks

  211. D'Nice says:

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

  212. D'Nice says:

    what is this?mmm’?

  213. Pankaj says:

    Hi,
     
    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.

    Appreciated

    Fardeen   

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

    Normal
    0

    MicrosoftInternetExplorer4

    /* Style Definitions */
    table.MsoNormalTable
    {mso-style-name:”Table Normal”;
    mso-tstyle-rowband-size:0;
    mso-tstyle-colband-size:0;
    mso-style-noshow:yes;
    mso-style-parent:”";
    mso-padding-alt:0in 5.4pt 0in 5.4pt;
    mso-para-margin:0in;
    mso-para-margin-bottom:.0001pt;
    mso-pagination:widow-orphan;
    font-size:10.0pt;
    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
     
    Regards,
    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 ?

    Cheers,

    John

  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
     
    Regards
    Nipendra

  231. Amr says:

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

  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:

    Hi,
    Do you have any Training Budget Calculation Dashboard?
     
     

  234. Satish says:

    Hi Chandoo
    It’s really help full site.
    Thanks
    Satish
     

  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.
    thanks
    Arul

  238. Shamaeil says:

    HI CHANDOO,
    I NEED UR HELP. I WANT A KPI TEMPLATE / FORMAT FOR A TEXTILE VERTICAL UNIT COVERING ALL THE PRODUCTION SECTIONS (SPINNING-WEAVING-PROCESSING-STITCHING) OR OF EACH INDIVIDUAL SECTION. ALSO HOW TO CALCULATE THEM.

  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?
    Regards,
    Carlos

  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.
    Regards
    Nipendra

  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.

    Best,
    Santosh

  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……

    Thanks

  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?

    Thanks!

  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.
    Regards,
    IsKh

  255. shankar says:

    Hi
    Chandoo

    I want to know can i change the color at time when cell value change
    and data link to other sheet.
    for example.
    sheet1
    A1 =1 ,A2=2,A3=4
    sheet2
    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:

      @Kamal
      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?

    Eg.
    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 :
    2
    1
    1
    2
    1
    1

    • Mohan says:

      never mind!

      I tried myself and got the formula.

      {=RANK(I1,OFFSET(INDIRECT(CELL(“address”,INDEX($G$1:$I$22,MATCH(1,($G$1:$G$22=G1)*($H$1:$H$22=H1),0),3))),0,0,COUNTIFS($G$1:$G$22,G1,$H$1:$H$22,H1)))}

      :)

  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.
    Thanks
    Kuldeep

  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:

    DEAR I WILL BE WANT LINKS FOR ALL EXCEL FORMULAS LANGUGE HINDE AND VIDEO DOWNLODE
    O KEEP SEND TO ME

  274. Renata says:

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

    Warmly,

    Renata

  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

    Quantity
    Value
    Freight
    Commission

    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

Leave a Reply