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 – todo 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. 
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 eyesore? 
Project Management Dashboards (recommended product)

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,
Today… 
Lets Pimp a Gauge Chart [Chart Porn Friday]
Egil, one of our alert readers from Norway sent this to me in email, which I swear, I am not making up – A Fancy Gauge Chart. See the email… 
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 dropdown 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 teammembers 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, 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. 
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 – todo 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 addins 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. 
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. 
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. 
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. 
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 checklist I got this idea of preparing a simple ToDo list application using excel. 
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. 
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. 
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. 
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. 
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 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. 
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. 
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 incell 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 thermometer 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 incell bar charts / histograms in excel
Ever since writing the create incell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs. An incell bar would probably… 
Create incell 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? 
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 eyesore? 
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 usefigures 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”
[...] 25+ Excel Templates – Download and Use [plug] [...]
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
Dear Harish,
Did you get what you need? or not yet
Baher.
Do you have a tracker as Harish wanted?. Can you share this.
Ian
Awesome and very informative site!
Hi Guys,
I’m here to share a game application created by me in excelVBA.
Try this exciting eHousie application at –
http://www.excelapps.webs.com/downloads
Sachin Agrawal
I downloaded one of your template work books (projectstatusdashboardxl2007{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.
test comment…. just to see if page level comments work
[...] 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 [...]
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
@Waseem: You can find the entire discussion related to mkt share displays here: http://chandoo.org/wp/2008/11/14/excelchartingalternativesmarketsharedata/
We haven’t posted any tutorials or download books for this.
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
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/ClassicMenuforExcel2007/300018483_410637173.html
Hope this helps.
@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.
[...] 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 [...]
“Executive Dashboards – Excel Training” – when downloaded is not opening. Please help.
@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.
[...] 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. [...]
[...] 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. [...]
Hello,
I want to know how to use the vlook up in the excel sheet
Hi Chandoo,
Now am able to open the Executive Dashboard.
Thank you.
want to make equity stock portfolio tracker in excel like mutual fund portfolio tracker.
please help me
@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.
[...] Free Downloads [...]
[...] Free Downloads [...]
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
[...] to the Pointy Haired Dilbert or straight to the downloads page. google_ad_client = “pub3795862859156495″; /* Lightbreaker Related Content */ google_ad_slot = [...]
Love your site! It has helped me a lot!
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.
[...] 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. [...]
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……
@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/trackstockmfportfoliogoogledocs/ ) 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/managementdashboardsexcel/
I write about dashboards or visualizations every now and then. Subscribe to the blog and keep watching…
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
Hello CEO,
I viewed excelsortingtextalphabeticallywthformulas worksheet, and it was very very nice. You are a very clever guy. Keep up the good work.
Jason
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 worldwide success.
Hi Chandoo
Replicon, a timesheet software provider, has a set of free excel templates for timesheet at http://www.replicon.com/exceltimesheet.aspx. I thought you may find it useful and list it for visitors who are looking for excel timesheets.
Cheers
Revv
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.
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
[...] Free Downloads [...]
[...] Download Excel Templates at Pointy Haired Dilbert Tagged with: chartexcel • chartexceltemplate • excel templates  Need more help ? Ask your Questions at our Support Center  Follow us on Twitter @TSNW or Facebook [...]
how to get the updated NAV in MF Portfolio Tracker. its not getting update automatically while opening the excel sheet.
[...] Free Excel Templates – Download [...]
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/onemorejabatcandlesticks.html
Just wanted you to know that one idea leads to another. Thanks.
Excellent templates.
Who so ever has prepared it , Thanks a lot!
if you are interested in templates for some really tricky ExcelCharts without any programming, have a look at
http://www.hichert.com/de/consulting/schaubilder/65
and
http://www.hichert.com/de/software/exceldiagramme/55
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.
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
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
Hi Chandoo,
Can I download these excel templates for use on a mac?
apb
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.
@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.
@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.
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
@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 rerun your macro.
All the best
Hello:
I am looking for a soft copy of 7. Quarterwise 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.
@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.
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
Hi
I have learned a lot today, thanks for all posts and samples
I now have lots of home work to do
Thanks,
Amit.
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?
@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?
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
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.
@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.
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!
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 Fishbone diagram on Excel, i feel it is possible and i was able to create one automated version of Fishbone on excel but could not get the formatting right.
please do share your thoughts on this,
Shahid
Its Greate.
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
Dil
What about the Task Manager in Outlook?
Tnx 4 your sup Hui, But we do not use Task Manager at office.
Thnx….
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.
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
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
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.
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
@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
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.
@Vamsi: See http://chandoo.org/wp/2009/01/08/timestampsexcelformulahelp/
hi Chandoo,
I am looking for India stock chart quote sheet, which gets updated from google finance.
It will be great help.
Thanks
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
@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.
Dear Chandoo…the Excel guru!.
I feel proud to join in your blog. I’ve been using spreadsheet for more than 25 years…lotus123…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
@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.
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!
these are great to make your understanding much better and grab the knowledge boost.
Good Luck!!!
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 redirected 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
@Brian: Welcome to chandoo.org. I am so happy you like my site.
Please visit http://chandoo.org/wp/2009/11/19/reversealistinexcel/ to learn how to reverse a list in excel.
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
@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 addins 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
[...] Downloads [...]
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).
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
@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.
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.
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
@Sahayaraj.. welcome to chandoo.org. Please visit http://www.yogeshguptaonline.com/2009/07/excelfunctionsconvertnumbersinto.html to find a technique to convert numbers to words
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.
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.
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.
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
Your site rocks…and that makes you a rock star!!! Thanks man
i saw article in newpaper i.e.21112010 andhra jyothi daily paper, your idea is excellent
thank you very much
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.
Hi Chandoo,
I need some awesome formulas list from where i can get
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.
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
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
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.
Hi,
Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.
hi
very THANKFUuuuuuuuuuuuuuuuuuuuuuuuuL
I have around 250 emails ids in one cell in excel , how can i sort the same in different rows and columns
@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
“I will be starting a series of posts shortly on Chandoo.org”
That’s great Hui. Here is an example where an ‘addon’ is as valuable as the programme. Many thanks.
hi,
thax to provide us easy to find anything in excel
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.
I WANT TO LEARN V.LOOKUP AND OTHER IMPORTANT SUBJECTS IN EXCEL
BUT I AM NOT WELL TODO IS THERE ANY FREE CLASSES
@ 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/vlookupmatchandoffsetexplainedinplainenglishspreadcheats/
or
http://chandoo.org/wp/tag/vlookupweek/
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/excelschool/
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
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
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
@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
Hi,
Really great, visiting your website I learnt lot of stuff in excel and implemented in my business. Thanks.
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
Hi chado,
can you please tell me how can I download excel for my computer?
I realy need it now:S
@Nita
You can download Excel from the Microsoft web site here:
http://office.microsoft.com/engb/excelhelp/gettingstartedwithexcel2010HA010370218.aspx
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
@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 ?
Hi! in B5 there is a name (ex: Carlos). if you wish, i can send you the file, always more visual:) thanks!
Hi Chandoo
I’m looking for dashboards which presents actual vs budget /forecast comparison. Do you have anything on this for download?
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
hai sir,i’m fan of you.i’m inspired by seeing your website in enet.i’m also from vizag.
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
@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?
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
Great webiste thank you chandoo !
Keep Excelling !!
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
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 (22Jan2010), 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
same goes for other dates in Feb , march etc,….
thx
@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!
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?
[...] e guarde nos favoritos: http://chandoo.org/wp AKPC_IDS += "5745,"; Talvez você também se interesse por alguns destes artigos [...]
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.
Hi Sir,
Your website is very useful for students & professionals. Could I add your website in my blog?
Please give me permission.
Subodh Sharma
NBNBB
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 (22Jan2010), then B1 must show (Jan) only.
i tried the If formula and IF AND, as well nested IF but didnt work…pls help
Thx !
Excellent Site ! that gives hope
@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
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
Ghida,
u can also enter the formulate =month(A1), and u will get the desired result.
deepak
Thx Deepak
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
Hi,
I have prepared a countdown timer. I have used the following formula:
=IF(NOW()<TargetDate, TEXT(TargetDateNOW(),"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?
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
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!
Thanks alot for those very helpful information
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
there are lots of excel sites but never one founded user friendly, entertaining and non boring as Chandoo
Go on !
Hey !
there are lots of excel sites but never one founded as user friendly, entertaining and not boring as Chandoo
Go on !
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
Click on this site. Your best source for this any, and I mean any questions is Google. Cheers!
http://www.ozgrid.com/Excel/autocompletevalidation.htm
thx MK
Hi Chandoo..
How to create real time charts in excel (Lets take an eg. of share priceor index value)
Thnx in advance
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.
@Isma
Put a Group Box (Form Control) around the option buttons you want to group and leave out the others.
Thanks for the advice, very quick. But where do I find the command for Group Box (Form Control). Appreciate your help.
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.
Hello
may i know what are the instruments control pls?
thx
Ghida – Lebanon country
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.
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 ddmmyyyy hhmm”, where ddmmyyyy is the current date and hhmm 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, “ddmmyyyy hhmm”)
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 ddmmyyyy hhmm”
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 ddmmyyyy hhmm.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.
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
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
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.
dear sir,
your site is very useful .
thank you sir
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
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”.
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.
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?
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
Hi,Chandoo
i love this website i learn lots of things from this websit.
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.
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
@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
looking for a product catalog template , or instruction on how to make one. any help would be great. thank you
Hi Chandu,
I am working as Graphics specialist in a reputed organisation. My daily routine consists with tracing of charts working with financial data etc. My question is how to trace the charts in 2007 and 2010. Currently I am working with 2003, it is user friendly to trace the charts. I found 2007 and 2010 are not allowing me to trace the charts. Could you suggest me how to crack it.
I was trying to down load Mutual Fund Tracker but It shows file is empty
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
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
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
@Persol
No need to double post.
Refer: http://chandoo.org/forums/topic/fancygraphwithnumbersratherthanbars
Your Site are best
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 20112013. It would be a great help.
Thanks
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
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…
161) Srinivau September 29, 2011
Hi Chandoo, I am still waiting for your suggestion.
Please guide me how to crack it.
@Srinivasu
What do you mean by Trace the Chart ?
Can you please elaborate ?
thanks for the sharing….
Thanks a million
Chandoo Garu,
How Can I open a autocad file through Excell macro, Pl. suggest
Boss !
Hats off to your work!
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 entrying 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
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
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
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!!
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.
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.
I need Digital Dashboard in Excel
@Kishore Kumar
Chandoo has a lot of resources that could help you.
Dashboard Tutorials: http://chandoo.org/wp/managementdashboardsexcel/
Dashboard Classes: http://chandoo.org/wp/excelschool/
Consulting: http://chandoo.org/wp/excelconsulting/
Ask Questions: http://chandoo.org/forums/
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
Chandoo
Thanks, it was very good to visiting your site & getting much more which is need
Regards
Sohel Ahmed
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
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 ?
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
I am looking for a comparison matrix excel spreadhseet. I am trying to compare many companies across many attributes.
Thanks for the awesome tutorials. Have helped me out a lot. Appreciate all the hard work you have put in. Thanks a ton!
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.
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?
The easiest way is to copy the entire sheet and remove all other columns. For this right click on original sheet name and choose copy.
how to compare two or more columns numbers in excel 2007 pls suggest
Please take a look at http://chandoo.org/wp/2010/06/17/compare2listsinexcel/
anyone who has fishbone chart xcell template?
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.
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!
I am looking for where you put the ranges at? I did it once in class and can not remmber how? HELP!!!
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
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..
How can I open autocad drawing from excell button, vb code required
excell vba macro needed to open a file in autocad
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
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
@Shyam
Can you post your code for us to see?
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.
Hi,
Where can I download a GAP analysis advance template for free like in this link: http://www.demandmetric.com/content/gapanalysistooladvanced
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
hi Chandoo….
i need a best macro coding book to learn
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.
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
Did you find something?
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
Hello
not sure what this is but I am not a spammer.
what is this?mmm’?
@D’Nice
Not sure which mmm your referring to?
Typically mmm is used to indicate either a Minute or Month custom number format
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.
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
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 email sender before date of expire of something if it’s possible please let me have your email to send you the template for adding formula if you have time.
Appreciated
Fardeen
I want to help someone:
I need the following problem help. Please help anyone.
Normal
0
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{msostylename:”Table Normal”;
msotstylerowbandsize:0;
msotstylecolbandsize:0;
msostylenoshow:yes;
msostyleparent:”";
msopaddingalt:0in 5.4pt 0in 5.4pt;
msoparamargin:0in;
msoparamarginbottom:.0001pt;
msopagination:widoworphan;
fontsize:10.0pt;
fontfamily:”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
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
LOVE the calender template. Really easy to use, and I could have never figured it out myself.
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.
Hi Chandoo,
Could you please provide the steps on how to use the new rupee symbol in Excel 2007 and 2010.
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.
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?
Dear Sir,
two multipal sheet data diffident type & one sheet convert related formula use
[...] 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 [...]
Is it possible to get a To Do list that will send an EMail when the target date expires ?
Cheers,
John
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
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”
pls provide vba functions & syntax with in example file with in pdf format file
Thank u ! Good Site ! Organized data at one place & well maintained !
Good work Chandoo ! my best Wishes !
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
Dear
is there a ready excel tabel for meetings schadules , same like office weekly calenders
please reply ASAP
thanks
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..,
Hi,
Do you have any Training Budget Calculation Dashboard?
Hi Chandoo
It’s really help full site.
Thanks
Satish
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
How do i transfer data from USER FORM in diffrent tabs by usinf VB coding..???
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
HI CHANDOO,
I NEED UR HELP. I WANT A KPI TEMPLATE / FORMAT FOR A TEXTILE VERTICAL UNIT COVERING ALL THE PRODUCTION SECTIONS (SPINNINGWEAVINGPROCESSINGSTITCHING) OR OF EACH INDIVIDUAL SECTION. ALSO HOW TO CALCULATE THEM.
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.
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.
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
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
Dear Sir,
If anyone can can help me sending a chart to present 100+employees individual achievement details. Thanks.
thank alot for you
hey mate
Y isnt the wedding planner on sale ???
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
I need a excel general ledger template to track expenses
MF Portfolio Tracker India v3.0. is tooo cool…. Can we have Indian Stocks/Shares Portfolio Tracker ???
Hi Chandoo,
I’ve a hyperion data….based on 2 combination, I have to create a standard template. Please help
you are the best…….
Hi Chandoo,
Good Evening, i need ur help how to connect excel to access database, can u pls provide for link……
Thanks
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!
Thanks for the templates!
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
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
Hi Chandoo,
I am Prabhu from Mumbai, working in coop
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 degrowth – 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
My Dear friend
There is nothing free in this world.
Thanks
Ganesh
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.
@Ganesh
You don’t need to use Conditional Formatting at all
Instead use a Custom Number format like:
[LTE_1]0.0%;[GT_1]0.0
Swap:
GT_ with a >
LTE_ with the <= signs
Dear Hui
Thank you so much. it is working.
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
@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
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!!
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
@ 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
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
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)))}
Can anyone suggest any format of Quotations?. Thank you.
Help me or any suggestion of Quotations format in excel.. thank you…
please tell me farmula so that number is converted into words automatically.
for example we write 15 and system converts fifteen
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
Hi chandoo do you conduct workshops in India
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.,
Love collection of excel stuff… chandoo kudos for sharing
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
@Juzar
Try =INDIRECT(G1&F1)
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!
Hi Evi… Welcome to Chandoo.org and thanks for your comment.
I suggest visiting our Excel Basics page to get started.
I encourage you to use a table for this type of data. Visit Excel Tables article for a good introduction or watch this video.
Thank you Chandoo, tables and pivot tables are really cool.
Accounting software with excel
How will be accounting with excel?????????????
DEAR I WILL BE WANT LINKS FOR ALL EXCEL FORMULAS LANGUGE HINDE AND VIDEO DOWNLODE
O KEEP SEND TO ME
Thank you for this article and links – I absolutely adore Excel.
Warmly,
Renata
Hi Chandoo
Have any sample input forms trying to create one in excel
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
I every time spent my half an hour to read this blog’s articles daily along with
a cup of coffee.
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!
data vallidation first row type alphabet character and show list only data validation list pls help me sir