Excel Templates - Free Excel Templates, Excel Downloads, Excel Charts, VBA Macros and More | Chandoo.org - Learn Microsoft Excel Online« Back to blogAboutArchivesAsk an Excel Question TrainingProducts
Chandoo.org - Learn Excel and Charting Online
Kickass Stuff!
Excel Tips
Excel Charting
Excel Dashboards
Project Mgmt.
Formulas
Downloads
Subscribe
Top 10 Excel and Chart Templates
Sales Dashboards – 32 Examples, Vote for your option now [Visualization Challenge #2]
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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]
Download now
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]
Download now
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]
Download now
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]
Download now
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
Download now
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
Download now
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]
Download now
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]
Download now
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]
Download now
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
Download now
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
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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!!!
Download now
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
Download now
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]
Download now
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
Download now
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
Download now
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]
Download now
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
Download now
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
Download now
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
Download now
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]
Download now
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?
Download now
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]
Download now
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]
Download now
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]
Download now
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
Download now
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
Download now
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]
Download now
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)
Download now
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]
Download now
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]
Download now
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]
Download now
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]
Download now
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]
Download now
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]
Download now
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]
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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]
Download now
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]
Download now
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
Download now
Here is a fun, simple and different alternative to traditional dashboards. Introducing…. …
Visualization Challenge – Budget vs. Actual Performance
Download now
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
Download now
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
Download now
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
Download now
RSS Icon using Donut Charts – Because it is…
Japanese Candlestick Chart – Excel Tutorial
Download now
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
Download now
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
Download now
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
Download now
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search…
Sales Funnel Charts in Excel – Tutorial
Download now
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?
Download now
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]
Download now
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
Download now
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
Download now
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)
Download now
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]
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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]
Download now
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
Download now
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
Download now
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?
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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]
Download now
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
Download now
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]
Download now
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]
Download now
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
Download 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
Download now
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
Download now
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
Download now
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
Download now
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]
Download now
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
Download now
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
Download now
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()
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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
Download now
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…
Trackbacks & Pingbacks
Pingback by Excel Links of the Week - All Downloads at One Place Edition | Pointy Haired Dilbert - Chandoo.org on November 10, 2008 @ 7:58 pm
Pingback by PHD Welcomes Readers from Lifehacker | Pointy Haired Dilbert - Chandoo.org on November 12, 2008 @ 8:44 pm
Pingback by Weekly Links - Even More Downloads Edition | Pointy Haired Dilbert - Chandoo.org on February 12, 2009 @ 12:11 am
Pingback by How to use Excel Chart Templates | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on March 10, 2009 @ 11:56 am
Pingback by How to use Excel Chart Templates | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on March 10, 2009 @ 11:56 am
Pingback by Free Excel Chart Templates - Make your Bar, Pie Charts Beautiful | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on May 14, 2009 @ 4:13 am
Pingback by Pointy Haired Dilbert becomes Excel @ Work | blogging | Excel @ Work: Charting & Excel Tips - Chandoo.org on May 18, 2009 @ 10:01 am
Pingback by Pointy Haired Dilbert: amazing MS Excel blog offers free downloadable templates | freewaregenius.com on July 23, 2009 @ 2:35 am
Pingback by Awesome Free Excel Templates | Olinda Services on July 24, 2009 @ 1:03 pm
Pingback by 5 Things you probably dont know about this site | Pointy Haired Dilbert: Charting & Excel Tips - Chandoo.org on September 28, 2009 @ 1:07 pm
Pingback by Free download various Excel Templates on October 3, 2009 @ 9:11 pm
Pingback by ?????Excel?? | ??? on October 8, 2009 @ 10:01 pm
Pingback by Free Birthday Reminder Template - Download today | Chandoo.org - Learn Microsoft Excel Online on October 26, 2010 @ 8:28 am
Pingback by Modelos grátis de planilhas Excel para download | TECNOFAGIA on March 21, 2011 @ 12:01 pm
Comments
1) Chandoo November 10, 2008
test comment…. just to see if page level comments work
2) Waseem Nawaz November 17, 2008
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
3) Chandoo November 17, 2008
@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.
4) Senthil January 11, 2009
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
5) Deepak Krishnan January 29, 2009
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. :)
6) Chandoo January 29, 2009
@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) Raj Kiran February 26, 2009
“Executive Dashboards – Excel Training” – when downloaded is not opening. Please help.
8) Chandoo February 26, 2009
@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.
9) amit joshi March 28, 2009
Hello,
I want to know how to use the vlook up in the excel sheet
10) Raj Kiran March 30, 2009
Hi Chandoo,
Now am able to open the Executive Dashboard.
Thank you.
11) JIGNESH MODI April 29, 2009
want to make equity stock portfolio tracker in excel like mutual fund portfolio tracker.
please help me
12) Chandoo May 2, 2009
@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.
13) stan July 23, 2009
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
14) PESfan July 23, 2009
Love your site! It has helped me a lot!
15) sunita July 23, 2009
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.
16) Durga July 26, 2009
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……
17) Chandoo July 26, 2009
@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… :)
18) stephen July 29, 2009
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
19) Jason August 3, 2009
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
20) Savio August 10, 2009
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.
21) Revv August 17, 2009
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
22) Shweta August 23, 2009
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.
23) Sonu September 9, 2009
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
24) SUNIL October 4, 2009
how to get the updated NAV in MF Portfolio Tracker. its not getting update automatically while opening the excel sheet.
25) BxCapricorn October 11, 2009
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.
26) Lav October 16, 2009
Excellent templates.
Who so ever has prepared it , Thanks a lot!
27) Ulrich Seidl November 26, 2009
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
28) Robert November 30, 2009
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.
29) Hui... December 1, 2009
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
30) atul December 6, 2009
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
31) Antonio January 3, 2010
Hi Chandoo,
Can I download these excel templates for use on a mac?
apb
32) Russ January 6, 2010
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.
33) Rick Rothstein (MVP - Excel) January 6, 2010
@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.
34) Chandoo January 7, 2010
@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.
35) DavidBrown January 13, 2010
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
36) Chandoo January 15, 2010
@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
37) Kshatrapati January 26, 2010
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.
38) Chandoo January 26, 2010
@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.
39) Amit Cohen February 13, 2010
Hi
I have learned a lot today, thanks for all posts and samples
I now have lots of home work to do :)
Thanks,
Amit.
40) Dawn February 18, 2010
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?
41) Chandoo February 18, 2010
@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?
42) Tyler February 22, 2010
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
43) ChrisL March 22, 2010
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.
44) Chandoo March 23, 2010
@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.
45) Chris March 23, 2010
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!
46) Shahid Ansari March 26, 2010
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
47) ADNAN ASHRAF May 3, 2010
Its Greate.
48) Dil May 15, 2010
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
49) Hui... May 16, 2010
Dil
What about the Task Manager in Outlook?
50) Dil May 16, 2010
Tnx 4 your sup Hui, But we do not use Task Manager at office.
Thnx….
51) iyyer June 5, 2010
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.
52) Isha Bawa June 22, 2010
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
53) pekay June 26, 2010
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
54) MK July 1, 2010
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.
55) Brian July 10, 2010
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
56) Hui... July 31, 2010
@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
57) vamsi krishna August 19, 2010
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.
58) Chandoo August 24, 2010
@Vamsi: See http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/
59) Trance September 6, 2010
hi Chandoo,
I am looking for India stock chart quote sheet, which gets updated from google finance.
It will be great help.
Thanks
60) Nitin September 21, 2010
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
61) Chandoo September 21, 2010
@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.
62) Lottomaniac649 September 23, 2010
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
63) Chandoo September 23, 2010
@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.
64) Lottomaniac649 September 23, 2010
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!
65) Jai September 24, 2010
these are great to make your understanding much better and grab the knowledge boost.
Good Luck!!!
66) Brian October 18, 2010
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
67) Chandoo October 19, 2010
@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.
68) Adel Abdulnoor Mohammed Faqihi October 19, 2010
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
69) Hui... October 19, 2010
@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
70) Toyese October 27, 2010
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
71) Hui... October 27, 2010
@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.
72) Dunzohar November 8, 2010
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.
73) sahayaraj November 16, 2010
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
74) Chandoo November 16, 2010
@Sahayaraj.. welcome to chandoo.org. Please visit http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html to find a technique to convert numbers to words
75) Sankar M November 16, 2010
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.
76) anand November 17, 2010
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.
77) manisha November 17, 2010
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.
78) ashish Kolarkar November 18, 2010
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
79) Rodel November 20, 2010
Your site rocks…and that makes you a rock star!!! Thanks man :)
80) lakshminarayana November 21, 2010
i saw article in newpaper i.e.21-11-2010 andhra jyothi daily paper, your idea is excellent
thank you very much
81) Pabbathi Nareshkumar November 21, 2010
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.
82) Aas Mohammad November 23, 2010
Hi Chandoo,
I need some awesome formulas list from where i can get
83) SUDHAKAR PAMU November 25, 2010
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.
84) Ahmad November 26, 2010
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
85) JRK PRASAD November 26, 2010
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
86) Zein December 10, 2010
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.
87) varath December 18, 2010
Hi,
Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.
88) baran December 25, 2010
hi
very THANKFUuuuuuuuuuuuuuuuuuuuuuuuuL
89) Shailesh December 26, 2010
I have around 250 emails ids in one cell in excel , how can i sort the same in different rows and columns
90) Hui... December 26, 2010
@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
91) Rajdeep December 27, 2010
“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.
92) amrit January 18, 2011
hi,
thax to provide us easy to find anything in excel
93) charu January 19, 2011
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.
94) SELVAM NAM January 25, 2011
I WANT TO LEARN V.LOOKUP AND OTHER IMPORTANT SUBJECTS IN EXCEL
BUT I AM NOT WELL TODO IS THERE ANY FREE CLASSES
95) Hui... January 25, 2011
@ 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/
96) San February 2, 2011
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
97) Ghida February 16, 2011
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
98) Ghida February 16, 2011
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
99) Hui... February 16, 2011
@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
100) vickeyvishal February 16, 2011
Hi,
Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.
101) Nita February 20, 2011
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
102) Nita February 20, 2011
Hi chado,
can you please tell me how can I download excel for my computer?
103) Nita February 20, 2011
I realy need it now:S
104) Hui... February 20, 2011
@Nita
You can download Excel from the Microsoft web site here:
http://office.microsoft.com/en-gb/excel-help/getting-started-with-excel-2010-HA010370218.aspx
105) christian February 21, 2011
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
106) Hui... February 22, 2011
@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 ?
107) christian February 22, 2011
Hi! in B5 there is a name (ex: Carlos). if you wish, i can send you the file, always more visual:) thanks!
108) Sudhir March 4, 2011
Hi Chandoo
I’m looking for dashboards which presents actual vs budget /forecast comparison. Do you have anything on this for download?
109) Imran March 8, 2011
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
110) gangadhar March 9, 2011
hai sir,i’m fan of you.i’m inspired by seeing your website in enet.i’m also from vizag.
111) Harish March 17, 2011
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
112) Chandoo March 18, 2011
@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?
113) Ghida March 18, 2011
Great webiste thank you chandoo ! :)
Keep Excelling :) !!
114) Imran March 18, 2011
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
115) Ghida March 18, 2011
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
116) Ghida March 18, 2011
same goes for other dates in Feb , march etc,….
thx
117) Hui... March 18, 2011
@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!
118) Ron March 20, 2011
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?
119) Ricard April 12, 2011
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.
120) subodh sharma April 16, 2011
Hi Sir,
Your website is very useful for students & professionals. Could I add your website in my blog?
Please give me permission.
-Subodh Sharma
121) balu April 20, 2011
NBNBB
122) Ghida April 20, 2011
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 !
123) Ghida April 20, 2011
Excellent Site ! :) that gives hope :P
124) Hui... April 20, 2011
@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
125) Ghida April 20, 2011
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
126) deepak April 21, 2011
Ghida,
u can also enter the formulate =month(A1), and u will get the desired result.
deepak
127) Ghida April 21, 2011
Thx Deepak
128) pinakin April 22, 2011
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
RSS feed for comments on this post. TrackBack URI
Leave a comment
Name (required)
E-mail (required, never displayed)
URL
Notify me of when new comments are posted via e-mail
Bookmark and Share
FREE E-mail Updates
Add to your RSS reader
Subscribe to Feed [Pointy Haired Dilbert - Learn Excel Online - RSS] Add to Google Reader or Homepage Add to Yahoo more
Meet Chandoo
Chandoo - AvatarAt Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 350+ articles and tutorials on using excel, making better charts. Read more.
Connect
Chandoo.org Products
New to Excel?
1. 100 Excel Tips & Tricks
2. Excel Pivot Tables - Tutorial
3. 51 Excel Formulas in Plain English
4. VLOOKUP Formula for Dummies
5. Free Excel Chart Templates
Advanced Excel Tricks
1. Excel Dynamic Charts
2. Learn Conditional Formatting
3. Making Dashboards using Excel
4. Project Management with Excel
5. Working with Excel Tables
Topics & Archives
1. Free Excel Templates
2. Charting Tips, Tricks and Tutorials
3. Ask an Excel Question
4. Most Popular Excel and Charting Posts
5. Excel Tips, Tricks and Tutorials
6. Excel & Charting Quick Tips
[Project Management Templates - for Excel]
Recent Comments
Murugaraj: Hi, Chandoo, I’m excited that the vba school is open. Glad...
Finnur: Excellent post! Thank you. Especially for Random Numbers Based on a...
Andy Cotgreave: Great post, Chandoo – I often need to create...
Chandoo: @DV… Our objective is to teach VBA to beginners and...
Svetlana: Thank you so much for putting on web these easy to follow and clear...
Felicia: My attempt: =SUMPRODUCT((Sheet!B57:Shee...
Cameron: I use PUP quite a bit. It’s just a wealth of fantastic little...
Brent: I have used PUP (multiple versions) for many years and have 6 or 7 of...
RSS Recently Popular
Show Zebra Lines when Value Changes [Excel Conditional Formatting Homework]
How to cook a delicious dynamic chart that will have your boss drool
How do you make charts when you have lots of small values but few extremely large values? [Debate]
What is the most unusual thing you have used Excel for? [Quick Poll]
How Francis Landed on Chandoo.org, Become Awesome and Made a Superb Dashboard, all in ONE Weekend
RSS @ Chandoo.org Forums
Pieter on "Error 400"
ashish navale on "conditional formatting for dates"
fred on "I need idea on a simpler formula"
nagovind on "Toggle button with a picture"
dhartikumar on "disable keyboard & Mouse"
Time saving tools from Mr Excel, Bill Jelen - Find out more about Easy-XL.
Disclaimer
This is a personal blog, don't take it too personally. I post whatever I want, you read whatever you like. Oh yeah, Chandoo.org tastes better with a latte, caramel if you please. So read, repeat and enjoy. Our Policies | Contact Details
« Home About Online Excel Classes Project Management Dashboards Excel Templates Join our Free News-letter Special Holiday Gift for our readers
Copyright © 2011 Chandoo.org Theme by PremiumThemes
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… project management invoice
ReplyDeleteGreat and impressive blog. Keep me more updating.
ReplyDeleteReal Estate Financial Modeling