Excel Order Form Template Free Download

Vertex42's free Work Order Form Template is an Excel file that contains two separate work order forms (as separate worksheet tabs). View the sample work order form screenshots above and to the right. T-Shirt Order Form Examples – PDF, Word, Excel Free Download. Now there are so many players in the garment industry and with t-shirts gaining acceptance even in workplaces the number of clientele has increased.

Excel Order Form Template Free Download Pdf
Free Sales Order Form Template Excel Download
Excel Order Form Template free download. software
Blank Order Form Template Free

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

Invoice template

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

Sales funnel chart template

We prepared more than 30 Purchase Order Templates & Forms which is available FREE in Word and Excel format. Download NOW! Business Templates (191) Personal Templates (147). And authorized by the responsible party, such as the business owner or the procurement office. A purchase order form template will help keep things. Download Free Accounting Templates in Excel. Want to manage financial records of your company or clients? Now you can use MS Excel to manage complete financial records such as invoice, profit and loss statements, generate salary slips, prepare balance sheet, track accounts payable and receivable etc. Excel template order form Tier.brianhenry.co. By: tier.brianhenry.co When handling the navigation structure, do not forget that simplicity is the way to do things. 8 Sales order form Template Excel ExcelTemplates ExcelTemplates. 6 order form Templates Free Downloadvjt5c - Through the thousands of photos online regarding order form templates free downloadteaet, we choices the best series with best quality simply for you all, and now this images is one among photos selections inside our best images gallery regarding 6 order form Templates Free Download.

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

Employee Training Tracker

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

Monthly planner template

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

To-do list template

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

Conference / meeting agenda template

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

Monthly shift / roster template

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

Overdue items tracker

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

2018 calendar & daily planner template

Excel Order Form Template Free Download Pdf

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

Gantt chart template

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

Simple Gantt chart template

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

Project Status Dashboard

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

Project Portfolio Dashboard

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

Project Issue Tracker

Free Sales Order Form Template Excel Download

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

Business Dashboard Templates

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

Simple KPI Dashboard template

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

Budget vs. Actual Chart

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

Simple monthly budget template

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

Christmas gift shopping tracker

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

FIFA World cup 2018 tracker and points table

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

Do you need something else?

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

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

[...] 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
  - Hi Harsh , Im working on that sort of excel sheet can you please share with me your version and i can share with you mine. I would like it if macro function is used in this . so please reply . Thank U
- Awesome and very informative site!
- Hi Guys,
  I'm here to share a game application created by me in excel-VBA.
  Try this exciting e-Housie application at -
  -Sachin Agrawal
- I downloaded one of your template work books (project-status-dashboard-xl2007{1}. I am very grateful and appreciate the template. However, I found that it is locked and I have not found a way to open it for editing. Is there a way that I can unlock it to make edits? (example, 'project budapest', I am trying to help a couple of nurses how to use excel to track a small project and report on it. I thought of myself (in healthcare) as pretty ok with Excel, but you are the Master! and I just a padawan. I stumbled on you site and have been blown away! Thank you in advance for sharing so much and showing me so many things I did not even know was possible.
- how to convert numeric values into Text.
  Example :
  Suppose I type 4500 it should display FOUR THOUSAND FIVE HUNDRED..
  is it possible in Excel. if you have any formula please reply.
  - You have to add an extra module for this in excel using VB Code, which you can get by searching on the internet Or try using ASAP Utilities free home edition or Try out 60 day Trial of KuTools.
- Hi Chandoo,
  Great site!!!
  Where can I find the Excel Template for the Holiday Request Form. I have just came across it on youtube and it's exactly what I need.
  Please help.
  Thanks,
  Cami
- What a wonderful site! I jst wish I could maximize the potential of it all. I'm jst a beginner in excel & I think its an awesome progrm!! I knw enough to knw thr is a way to get the result tht I need but not a clue of how to get thr. In the past I've utilized some amazingly orchestrated sprdshts tht were jst well thought out and produced some sort of end result. The cmpany I'm at now does not use many sprdshts. If thy do, thy are just lists of some sort with no end result. I'm in HR and I use about 7 diffrnt staffng agencies for open positions we have. I get the ok to open an existing position or details on typing up and posting as a new position. I thn email open job to agency(s) who are more inclined to particular job. They, in turn, fwd me resumes (lots and lots) of candidates. I fwd them to mgr of dept & thy tell me yes or no to set up an interview. We go through quite a few applicants before we find the right one. First, I think it would be best if evry resume recvd was put in spreadsheet, because theres quite a few times i'm having to go back and look through all these resumes that a manager remembers seeing with a certain skill set they are looking for. So I have stacks and stacks of resumes in my office and Im getting frustrated. Thinking if I input all the pertinent info of applicant, like date applied, which position, agency they came from, whether they interviewed or not, outcome of interview etc.etc. I could then have an applicant database and at the same time get a clearer picture on which agency is sending us the right kind of candidates with skill sets were looking for and which agency is working best. Like I said I know what I want it to do, but no clue how to get there. Any ideas or help would be greatly appreciated.
  Regards,
  Victoria
- Hi,
  I have two columns with 16 digit numbers. I want to find which numbers in column 2 matches with the numbers of column 1.
  What formula should I use for this? Countif or vlookup?
  Thanks
- I've been trying to make two different calculators and can't seem to get them right. One is a domestic shipping rate calculator.. Plug in a zipcode, and package details then it will show best rates for the main shipping avenues.
  The other one is an options trading calculator.. that will keep track of previous trades and performance.
  Hope you can help! or have some of your own. Thanks
[...] 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
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.
Hope this helps. 🙂
[...] 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.
[...] 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
[...] 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 = 'pub-3795862859156495'; /* 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......
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 excel-sorting-text-alphabetically-wth-formulas worksheet, and it was very very nice. You are a very clever guy. Keep up the good work.
Jason
Thank you so much Chandoo. Your website is so impressive. It has really helped me in various projects I have. I wish you all the best and I hope your website becomes a world-wide success.
Hi Chandoo
Replicon, a timesheet software provider, has a set of free excel templates for timesheet at http://www.replicon.com/excel-timesheet.aspx. I thought you may find it useful and list it for visitors who are looking for excel timesheets.
Cheers
Revv
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: chart-excel • chart-excel-template • 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:
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 Excel-Charts without any programming, have a look at
http://www.hichert.com/de/consulting/schaubilder/65
and
http://www.hichert.com/de/software/exceldiagramme/55
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.
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
Hello:
I am looking for a soft copy of 7. Quarter-wise Snapshot of Budget Performance which is a part of 'Budget vs. Actual Charts – 14 Charting Ideas You can Use'. Kindly help me in locating the excel file of this so that I can understand the concept in entirety.
Thank you in advance.
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?
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.
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 Fish-bone diagram on Excel, i feel it is possible and i was able to create one automated version of Fish-bone on excel but could not get the formatting right.
please do share your thoughts on this,
Shahid
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
- Hello Brian,
  Hope that you are well.
  I was just wondering if you managed to obtain the database template, if yes,would you mind sharin it?
  i would appreciate it.
  thank you,
  Natalie
@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.
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
Dear Chandoo...the Excel guru!.
I feel proud to join in your blog. I've been using spreadsheet for more than 25 years...lotus-123...supercalc.....excel....excel2010..... To quench my everlasting lotto thirst, I've developed some sort of dashbard which will help turning an ordinary lotto buyer into smart lotto player! Now, I want it to distribute among various lotto users and I thought it here at chandoo.org the right place to get maximum coverage. I'll be delighted to have your word in affirmative to post the file,
With regards.
Lottomaniac649
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 re-directed me here and yet I couldnt find it anywhere on your site but I certainly saw a lot of other awsome stuff that I will be downloading. In the meantime ... is there a specific area on your site that can help me with this issue (reversing row orders - and they are NOT linear - the values could be any number but I need them in the exact order but in reverse - bottom to top NOT top to bottom as they are now. One final question ... what was Microsoft think by NOT adding this as a built in feature ... when googling this problem I have seen HUNDREDS of similar answers to this obvioulsy very common poblem ..
Thanks again for any help or direction adn for the awsome site
Brian
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 add-ins recently, if so temporarily remove them and try to restart Excel
Try and restart Excel in Safe Mode, this is a mode that doesn't load any addin's
There is a great article on this and lots of other ideas that may help at:
http://www.cpearson.com/excel/StartupErrors.aspx
[...] 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 am also trying this scenario : automatic email is sent to the person if date of birth occurs and no need to click on the link(sendemail).
    Please help me with this or send an email to me regarding this.
    Thanks
    Aditya
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
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
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.21-11-2010 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 'add-on' 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
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
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
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
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
- 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 (22-Jan-2010), then i want B1 to show (Jan) only.
i tried the If formula and IF AND, as well nested IF but didnt work
pls help Thx !
Ghida
same goes for other dates in Feb , march etc,....
thx
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 (22-Jan-2010), then B1 must show (Jan) only.
i tried the If formula and IF AND, as well nested IF but didnt work...pls help
Thx !
Excellent Site ! 🙂 that gives hope 😛
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(TargetDate-NOW(),'hh:mm:ss'),'Done!')
where TargetDate is a Cell Name which I have mentioned.
In this once the timer gets, 00:00:00, I receive 'Done!' in the cell.
(I have named the cell where I have kept this formula as TimeToGo)
I have used a macro to run this:
Dim NextTime As Date
Public Running As Boolean
Sub StartIt()
Running = True
Update
End Sub
Sub Update()
NextTime = Time + TimeValue('00:00:01')
If Range('TimeToGo').Value 'Done!' Then
Range('TimeToGo').Calculate
Application.OnTime NextTime, 'Update'
End If
End Sub
Sub StopIt()
If Not Running Then Exit Sub
On Error Resume Next
Application.OnTime NextTime, 'Update', schedule:=False
Running = False
End Sub
Now I need is a Message Box Popup, where once the timer in the cell gets 00:00:00 or 'Done!', I get the popup reminder which I want to keep as 'Update MIS Tool'
Can someone please help?
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!
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.
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 dd-mm-yyyy hh-mm', where dd-mm-yyyy is the current date and hh-mm is the current time
I have done a macro to make this happen:
ActiveWorkbook.SaveAs 'J:DATABPOOPERATIONSBPBP UKBP UK EDM, Exits and LeavesCOMMONEform creationDaily comparison recordsComparison Report ' & Format(Now, 'dd-mm-yyyy hh-mm')
However, I need help to automate further:
1. I need to put the email Id in to and cc field of the email
2. I want to put the subject line as 'Comparison Report dd-mm-yyyy hh-mm'
3. I want to put the body of the email as 'Please see the comparison report below.'
4. I want to attach the file automatically to the email and lastly
5. To send the email automatically
I tried so many macros, but some or the other things get missed. Sometimes I get the attachment in my email, but not the body and the email id in cc field, sometimes I get the body of the email without the email Id in cc field and the attachment. As my file is based on current time ('Comparison Report dd-mm-yyyy hh-mm.xls', sometimes it may not pickup the file as the time gets changed.
Could you please help me with this? Please its very important. I am a novice and its very much challenging as well as enjoyment for me to get into the world of macro and see the magic. I am crazy about excel. Please, I would be very thankful to you if you could help me with this.
Will be waiting for your reply.
Thank you so much in advance.
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
- hi Pankaj,
  were you able to find a solution for your inventory management and control issue ?
  I am seeking one now !
  Siddharth
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
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
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 2011-2013. 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.
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 en-trying the total values of the products along with necessary taxes & duties on the sheet, that calculate automatically the values and gives the supplier position on ranking basis.
So in this context i would request you to develop a good tool for (Procurement Comparision Tool) infra sector employees to optimize the work pressures.
So if your interested to develop a new tool for sales comparison as per indian market concern
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
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?
how to compare two or more columns numbers in excel 2007 pls suggest
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
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/gap-analysis-tool-advanced
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'?
- 3 letter of month (Jan,Feb)
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 e-mail sender before date of expire of something if it's possible please let me have your e-mail to send you the template for adding formula if you have time.
Appreciated
Fardeen
I want to help someone:
I need the following problem help. Please help anyone.
Normal
0
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:'Table Normal';
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:';
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:'Times New Roman';}

Main File
Category | Prod. ID | Prod. Code | Result_ Product Name
A1 | B1 | C1 | D1
01 | 08 | 1052 | A- Cal 250 Tablet
01 | 08 | 1053 | A- Cal 500 Tablet
02 | 09 | 1052 | A- Cal 750 Tablet
02 | 09 | 1053 | A- Cal 1000 Tablet
01 | 01 | 1052 | A- Cal 1200 Tablet
01 | 02 | 1053 | A- Cal 1500 Tablet
--------------------------------------------------------------------------------------------------------------
I want to be VLOOKUP formula in another sheet and I can Entire Data in
First : A1 = 02
Second : B1 = 09
Third : C1 = 1052
Output = A- Cal 750 Tablet
Output is calculated by V LOOKUP Formula
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 E-Mail 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 (SPINNING-WEAVING-PROCESSING-STITCHING) 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 co-op
Hi Chandoo,
My Name is Prabhu from Mumbai and working in corporate industry.
Basically my job is to analysis of sales people in various parameter and Head Office level to update the business peroformance. i am good in excel but the size of data is getting high so I am unable to deliver the job in time after adding so many formulas like sumifs, countifs, pivort, etc,
Also I am trying to learn a VBA in excel 2007 but In that also I am very poor, because I can’t do everything ij just recording a micros and I am not aware of write a program in VBA.
My daily Job is-
Deliver the report on daily basis for sales level as per the top to bottom (Sales hierarchy)
Report of sales Head leavel
Report for Growth or de-growth – Last year v/s current year
Report for Company level for our Top level – for each and every parameter for review purpose.
Report of third party performance
Key Performance Indicator (KPI) for all level.
Somehow I managing to do manually and some are on formulas, but it takes so much time.
Thus, plz give me a suggestion what is best way to make easy of my Job and also how to learn VBA in excel 2007, sorry to say but is there any way to learn VBA in free of cost.
Thanks & Regards
Prabhu - 9867506425
- 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
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
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!
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
Hi Chandu, Your site really awesome. can u share sumifs function through vba. Its very big help for me
Your spreadsheets got me great compliments on my project thanks!!!!
Hi Team,
I have been a regular surfer of your website and this is one of the most helpful sites ever.
Would need a little help here as i am trying to get a report / dashboard for calculating calibration variance automatically just by putting the audit data provided by QA's.
This will be for call and email calibration and the number of participants can go to a maximum of 10.
Hi Chandoo,
Thank you very much for sharing your knowledge.
Speaking from the bottom of my heart, I learnt a lot from your website. You and your team are doing a really Awesome job.
Recently I got promoted to Managerial cadre and I would like to implement few of my suggestions with the help of Excel and VBA macros.
My question for you is, Do you any plan to conduct live classes on Chennai. If so, I kindly request you to drop a email along with the cost of the course.
I prefer to attend only physical classes instead of online courses
Hi Chandoo,
I made a Mailing tracker for my team.
Our team Receive around 150-200 mails in each persons outlook and after that they have to reply for that
, So i made tracker with the help of VBA to track unreplied mails but somewhere it is skiping 2 or 3 mails count
I searched on google when a mail heat to inbox its generate a Entry ID or Message ID.
My Questiion is that
1. I want a VBA code to get either Entry ID ot Message ID from outlook?
2. Is entry ID is same for inbox mail and sent mail?
I really enjoy the blog article.Really looking forward to read more. Fantastic. deeffdafeffk
i want to learn VBA from begginer level.
Please guide me.
Awaiting for your quick respoce
Do we have any means of creating Whisker and Box plots for geochemical data. Geochemical data is data generated out of chemicla analysis of earth materials.
Hello,
I am working on Career Management Interviews for each employee of a department.
I would like to create smth interactive in excel because I would not like to create a separate sheet per employee including ( 100 sheets would be to much) :
Photo
Name Surname
Employee Data- Position, Department, Commencemet Date
Salary History
Position History
Training received
Other Benefits
a space for coment
Can smb help me with such an excel file or similar?
Thanks,
Irida
[…] Chandoo.org è uno dei siti dedicati a Excel più conosciuti. Sul sito sono disponibili numerose guide per imparare a utilizzare Excel e risulta essere presente anche una sezione dedicata ai modelli. Sono disponibili meno file rispetto ai siti segnalati in precedenza, troviamo però alcuni modelli interessanti da scaricare. Il download è gratis e non richiede la registrazione. […]
HI Sir,
I already subscribed your mails for latest excel tricks, But I just want to know, Can we break the password of a protected excel sheet using Macro ?
Hi Chadoo,
I have created excel bounch of excel worksheet to manage my shop daily activity. I am running cake shop where daily purchase/sale activities are going on and it is really hard to calculate stock against cash on daily basis.
Do you have any idea of can you help to automate the worksheet which i have created.
Please let me know your email id so i can share my excel sheet with you.
Thanks
Girish
HI ,
Column A i have Sales person name & in B Product ,each sales person will sale different product multiple times , i am looking for unique product count for each sales person.
Help me on this
Dear Sir,
This is amazing site.I need to download Financial Modelling but that is not available now.Kindly either send me the same at my email address.
Thanks a lot
Hi Chandoo,
i need two macros:
1. need reminder in excel 'pop up' reminder should in the desktop with non-editable data in the excel.
2. macro should to take a screenshot of the PDF Document.
Can u please help me .....
Good Day,
I need to display in a graph the alarm signals received. Signal to acknowledge; Signal to dispatch; Signal to completion. My challenge is to choose the right manner (graph type) to display and then how to display the time that it makes sense. This is to manage long alarm responses.
For example: Signal to acknowledge:
Operator A: 200 Signals in time (ave) 00:00:23
Operator B: 450 Signals in time (ave) 00:01:23
Etc
Many thanks in advance,
Good Day,
I need to display in a graph the alarm signals received. Signal to acknowledge; Signal to dispatch; Signal to completion. My challenge is to choose the right manner (graph type) to display and then how to display the time that it makes sense. This is to manage long alarm responses. Underneath the data for signal to acknowledge:
Operator Normal Total Signals Normal Average
Operator A 7 00:00:22
Operator B 37 00:00:24
Operator C 15 00:00:05
Operator D 5 00:00:09
Operator E 12 00:00:27
Operator F 12 00:00:13
Operator G 2 00:00:08
Operator H 14 00:05:02
Operator I 25 00:00:39
Operator J 13 00:00:04
Operator K 14 00:00:02
Operator L 9 00:00:12
Total:165 00:07:42
Many thanks,
Hein
sir how to change me name 'r nagaraj' into 'nagaraj r'
Hello Chandoo,
very nice and informative site.
I am working on Attendance and Shift tracker for our org.
do you have anything supportive to this and anything to download and use?
Please do let me know abt the same. thank you!
HI there tks for the very useful information about excel I want to know how to prepare a rental income and expense worksheet which will include an anversery increase in rental income expense . The spread should include yerly income exp over a period of 15 to 20 years
Pls let me know if there is such aspread sheet
tks
shamsu
Hello Chandoo,
I have been using your tips for years. Do you have a vacation planner spreadsheet. I am just feeling lazy creating one. Thanks.
frank
my friend,
i need ur help in macros. i have created an application for equipment details but the thing is when i clic on run 438 error is displayed. can you please give me ur email id so that i can attach dat app n send to u.
appreciate ur early response.
Thank You
i want to make excel data base in HR department. how to make plz help step by step method and formulas,
[…] als auch Fortgeschrittenenkurse bieten. Ihr könnt hier also auch was lernen! Die Navigation durch die Excel-Templates ist hingegen etwas unsortiert, was Suchenden nicht gerade in die Hände spielt. Von einem […]
[…] Chandoo […]
Dear Chandoo,
I was trying to use your excel template ' Birthday reminder' but when i enter more charactor in body (C5), formula showing value error.
Appreciate if you could provide any suggession for this, also i would like to know if any formula available to attach pdf file from excel to email without VBA
Chandoo,
I would like a dashboard to run my enterprise. Is there one that you'd recommend or have for sale. I need to do financials, sales, org charts, gantt charts, business enterprising....all in one! Thank you
how can i assign 10% tax from each male staff from WD which in their salaries are greater than 550$ per month?
hi Chondu,
i need help on generating member shift allowance trend
[…] Chandoo […]
Hi Chandoo,
i want to create one dash board report. and that report should be show all data's in one chart with multiple options selection wise. for example four branches data available on month wise (jan to aug). data's like electricity cost, consumption and utilized materials. i want show these all data in one chart on selection basis like facility, month and description.
Like the blog , Good stuff , Chandoo
Hi every one,
How to data validate in negative value.
We need negative value error in during the file saving..
With Regards
Hi chandoo,
Do you have a template for a small business where we can track assets, stock in hand, profit and loss, etc. So that we can track the profitability of the business
Regards
Dear Sir,
It is very nice that you have utilized your mind to the almost optimum to create different variations of Excel.
Can you help me with a template or system which will help me to track the quotes sent to various customers? It is becoming extremely difficult for me to track and I take a long time to update the sheet and report further.
I searched everywhere but could not get it.
I hope you understand.
Can you help?
Regards,
Preeti.
Hi Chandoo
Do You have any good dash board template using project management like progress and only status of ongoing project is showing i am also having some difficulties to create sum if formula can you also send me all sum if logic so i can see which logic is fit my calculation sheet
Cheers
Haris Niaz
hi Chandoo
I am trying to do a spreadsheet for resource allocation - I want the names on the Left hand row and wc xxxx 7 hr booking, and & allocation and also total
how would I go about setting this up - Please help
and then a running total
Your sale dashboard is so great, i like the most the interactive ones.
Thanks for showing me and other these exist 🙂
Can I get an evaluation copy for PPM dashboard before I purchase it? Pls let me know.
Hi,
Is any way in excel send mail along with cc option to multiple users.
i tried to mail merge but only one receipt it will add in mail merge option. if i want send same mail to user along with cc it is possible
Dear Chandoo,
Firist of all, thank you very much for sharing us with your HUGE experience of EXCEL. I'm one of the your FAN from Mongolia. After i found your website, i learned many things of excel. GOOD JOB
Hi Chandoo,
I was wondering if you have one excel template for basic accounting with ledgers, journal and trial balance.
Would be greatful
Hi Chandoo
We spoke some time agi !Need some urgent help
I need a VBA script in excel that will help me generate an IBAN number when a user enters his Account number into a field in Excel
Could you assist me with the same.
Note : for help , I can share withyou the Java script code logic. Just need it converted to excel macros format .
Request your help on this one
Thank YOu
Sean
Good stuff to learn for beginners like me.... I am truly thankful to Chandoo
hi chandoo
Great site sir,
Is there any code for HOUSING co operative society billl and receipt generation FROM DATABASE
Hi All,
I am looking for a VISA tracker template , which can track type of VISA (B1,L1)country, Visa start date and End date, Zone (North America, APAC) can you please share some file where can we modify and use accordingly.
Regards,
Rajesh Iyer
Hi Chandoo, or anyone out there,
I am seeking your help in setup up an excel spreadsheet to do record accounting transactions and do automatic trial balance.
Hi Chandoo,
I would like to link NSE and BSE website in a Excel Workbook for getting the corporate action details for the day based on Ex date , Record date and Announcement date for all the listed securities in both the websites.
Would request you to kindly advise me on this
Best Regards,
Jeetesh Jain
Wish to buy 'Project status Dashboard, with the following considerations and little extra development please.
Tab 'Data' Cell C3, something like =IF(AND(C4%>0,C435%,C468%,C4'')
Also, Very much need the following added;
• Degree of achievement (or otherwise) of financial targets.
• Degree of achievement (or otherwise) of date targets.
• Scope creep – (how many requirements added to the project after initiation)
• Phase encapsulation achievement (how many defects identified at a certain stage)
• How much “dead time” did project members experience due to major code revisions, downtime etc
Hi chandoo sir,
I am a small contractor, I have a very little knowledge about excel. I am facing a problem. Because of my job I have to generate invoice and measurement sheet through excel. The problem is, we write measurement in ft & in (eg 1' 6' i.e. one foot and six inch) but in the formula area we have to write 1.5.
Is there any easy way that I will type just 1.6 and excel automatically writes 1' 6' and calculates as 1.5.
Eg - 1' 6' as length X 1' 6' as Width = 1.5 X 1.5 = 2.25 SqFt
And another thing how to convert SqFt to SqM and CuFt to CuM
Please Help
Thanks
Indrajit
Hello Sir,
Greetings
I Have A Two Issues In This Worksheet Can You Please Help Me To Complete This Workbook.
This Workbook Is Actually Our Timesheet
1) I Have A Drop Down List Contain Month And Group For Each Month I Put Input's For Each Employee I.E 3 ,3,3,3 Ep, Lp...Etc But When I Change To Next Month Or Other Group The Inputs Cell Does'nt Change I Want This Also To Be Change Along With Month And Group's
2) I Want To Highlight Each Snr. Engr. In My Drop List
Please Help Me With This Query
Thank You
I ve folowing problem, it doesn't filter while double click the cell which i want to see
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim dccolumn As Integer
Dim dcvalue As String
dccloumn = ActiveCell.Column
dcvalue = ActiveCell.Value
If Application.Intersect(ActiveCell, [headers]) Is Nothing Then
If ActiveCell.Value ' Then
ActiveSheet.Range('A:o').AutoFilter Field:=dccolumn, Criterial:=dcvalue
End If
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rownumber As Integer
rownumber = ActiveCell.Row
If Application.Intersect(ActiveCell, [headers]) Is Nothing Then
If ActiveCell.Value ' Then
Range('a6:O105').Interior.ColorIndex = x1None
Range('a' & rownumber & ':o' & rownumber).Interior.Color = RGB(255, 255, 9)
End If
End If
End Sub
What's up, I would like to subscribe for
this weblog to take latest updates, thus where can i do it please help.
Hi,
Based on the Location, Party name and category I want to Calculate the Sales Tax portion and the Ex factory price.
for Eg: Knits is 1% and Wovens is 2%
Location : Tamil Nadu : LST is 4%
Other states : :CST :5%
If Tamil Nadu is clicked in location against the Party Other states should not come.
The formula should be in such a way that, based on the category (Knits or Wovens) and Location and Party the Sales Tax and other price be picked up automatically.
Please keep the MRP be Rs.100
Please help me out.
Thanks
R.Sivaramakrishnan
hi,
i am having different vendors with different price quots and capacities. once i receive the plan for the month, i need the formula for allocating the plan between those vendors based on the 1st vendor with lowest price with his full capacity and then followed with 2nd best vendor
e.g.
Plan of 100 Nos
Vendor 1 - price of $1 with capacity of 50 Nos
Vendor 2 - price of $1.5 with capacity of 40 Nos
Vendor 3 - price of $2 with capacity of 60 Nos
then i need the solution as, 1st to allocate the plan of 100 to Vendor 1 with lowest rate with his full capacity of 50, then best to Vendor 2 with price of 1.5 with 40 Nos and then remaining plan to Vendor 3 with price of 2
Require help in constructing condition in formula..
=COUNTIFS($D$5:$D$35,$J5,$I$5:$I$35,'>=&($G$5/ROUND((($E$5/12)*$E$2),2))100%',$C$5:$C$35,'BM')
It is giving me 0 answer.. I wanted to have a output where condition is valid for '>=&($G$5/ROUND((($E$5/12)*$E$2),2)) > 100%, name in range c to c35 = BM..
If required, I can upload/forward sample file..
Thanks..
hi,
i want to convert my excel calulator to HTML
kindly help me with the necessary language that is required or any process..
so many softwares are available but do not want to use.
Regards
Arun Pillai
Any idea how to overcome the problem of multiple matches when using vlookup
[…] Templates (Hichert Excel Beispiele, Chandoo Templates) und Tools (Zebra BI, chart-me, […]
Dear sirs,
I want to know how to calculate the age as on today when I enter a date of birth.
Please let me know the formula.
You had published it once but I somehow lost it.
i need steps to follow on how to draw a vertical average line across a bar chart.
hie sir , i appreciate the good opportunity you have given to many excel enthusiast like me i just managed to create a football match predictor using excel however am just a learner in excel not an expert yet... do have an example of a soccer match preditor
Hi Chandoo,
Where can I find some information about interactive calendar with several events per day to display?
Hi Chandoo
I am keeping records for a two Badminton competitions. I've set up a spreadsheet which takes records the scoresheets easily (turning them into tables) and summarises them with formulas. My problem is that I need to get individual player statistics out of this for each game (ie games played against each opponent and games won with percentages and totals). Most of the games are doubles (so four players) - there are 4 player columns to sort through. 36-48 players in each comp, 10 weeks of games. This takes about 20 hours each competition to do.
At the moment I'm filtering by player and reducing it down to individual player manually then turning that into a pivot table.
Everything is working on tables and name text values.
Do you know of any visual basic macro I can use to extract the results across four columns and analyse and summarise it by player?
eg look for player1, if player 1 is in column 1, then opponent is in column 3, if player1 is in column2 then opponent is in column4, if player1 is in column3 then opponent is in column1 if player1 is in column4 then opponent is in column2. get opponent (eg player5) and get score and winner. (at the moment I'm using concatenate functions to filter).
I know this would be more easily handled by a database, but even the specifically designed badminton software they have can't deal with this.
Do you have any macro examples that would suit this function?
Thanks
Nicole
Sir,
can you please give me excel calculator to calculate resistance and support level of stock trading.
I need help with attendance fact report a dashboard of attendance were we can reflect total number of lates, then lates above 8:30, lates = or above 9:00 and lates = or above 9:30
and lates after 17:00 hours
separate block of administration and domestic staff
top 3 people with highest lates
and can search statistic of individual person by name of id
i have less time pleasee please please HELP
my chando id is D3c3nt-m3n
anyone know or have a template on how to do the following.
need multiple boxes with key words for example:
Customer called
You click on customer called box and it inserts that text in a text box at the bottom.
I then select a different box which may continue that sentence.
for example - to buy some eggs.
I select to buy some eggs so the text box at the bottom now says
'Customer called to buy some eggs' and then I keep building a note or message to be then able to copy and paste?
L
Hi,
Do you have any excel formats to maintain cricket stats for 20 teams
where in once feed should give us all the stats for the game
Please let me know
Thanks
Great site. Valuable resources. I have been trying to master excel from long time but it never looks enough. There is so much to know and learn. Your tips are extremely useful. Thanks for sharing this excel templates.
Hiie EveryOne,
please suggest me if it is possible to convert language in excel form.
if it possible then mail me suppose i have excel file in Marathi language so i want to convert it into English format
Hello,
it ll be very thank full to your reply of my one query about which i still did not get proper answer or sample
i wanna know how to move data & values from summery sheet to multiple destination sheets by their name and data separately and respectively to each sheet automatically.
i got sample file to move data to another but that is not
working and effecting on other sheets which is 1, 2 & 3 etc please give proper any sample and explain whether it is by VBA & by else formula.
Thanks
Hi,
My team were using around 12 types of overhead expense reports. So i want to standardize all into one best overhead report.
Any suggestions or template you already having?
Regards,
Anil
Dear Chandoo,
I am looking for customize Inventory management system in excel for my organisation, please let me know how I can avail your services in this regards.
Let us know details required from my end and your fees for the same.
Thank you
thank u very much! Nice information..
Hi Guys,
Could you please reactivate the link for me to redownload these files?
Thank you and regards,
Princeloo
I want to create a database to track Food Vouchers that will track Vouchers that we:
1) Print
2) Submit to be signed/approved
3) issued to our distribution agents
4) number distributed to beneficieries
5) number redeemed at the selected retailer.
Can any one assist me to come up with a template please
Can you kindly tell me how much time it takes for you to send the login details after receiving the payment? I made the payment about 10 hours back and yet to receive any details except the payment receipt mail which I already forwarded to you. Tried to reach you on 91 814 262 1090 but not able to connect.
The discount code is not working
these template are amazing!!impressive..
Hi chandoo,
Beautiful house & surroundings Love it if possible share some interior will be nice.
Looking for template for ' Mutual Funds Portfolio Tracker- USA'
I did see for India.
Also looking for spread sheet for 'UBER' daily records keeping for each Date/ride/miles/tolls/bridge tolls/ gas/repair /car loan payment/repairs /car wash/ few extra blanks columns future add on/remarks or any think u think of, to keep my annual record for USA tax purpose.
If have any ready template will do.
kanu
very show this site, I spend hours and hours browsing and every moment I find new contents about Excel. Congratulations
Hi Can you please help me to provide macro or vba code to login into website using username and password.
Hi Chandoo.
Greetings
Your Mutual Fund tracker is awesome. I was using moneycontrol but now using your template. Can you make option for SIP investment in that template.
Then it will be 100% complete.
Thanks,
Hi Chandoo
awesome templates. am looking for if any template is available for IFRS9 expected credit loss calculation.
appreciate if anything is there to share.
thanks
Ravi
hello chandoo
your website is very good
im Industrial Engineer.
Our factory make glass cleaner and other wax.
we have 8 machine and 21 product.
please help me to project program.
best regards
sepid
Hi chando ,
Need dashboard for oil & Gas Turnaround , My requirement is how to index with different graphs within Developer for Block A , Block B , Block C and Block D.
Suppose Block A consists of several unit like U-91 , U-92 , U-93 , U-94 and its overall progress by combining all the units Plan Vs actual progress % . Need to show in Bar Charts using developer.
Please help in this regard to develop.
it is a good blog.
grate site....please i want a predictive model for virtual soccer trading, similar to forex trading.....the model i created is not very good for my trading but it gave me a clear picture of the market...please reply..
Dear Chandoo,
This is a beautiful website. I have used loads of ideas and help from here. However, i need some more help. how do i get in touch with you?
Thank you.
How to resize checkbox not it's frame

Excel Order Form Template free download. software

Blank Order Form Template Free

8 Sales order form Template Excel ExcelTemplates ExcelTemplates

6 order form Templates Free Downloadvjt5c - Through the thousands of photos online regarding order form templates free downloadteaet, we choices the best series with best quality simply for you all, and now this images is one among photos selections inside our best images gallery regarding 6 order form Templates Free Download. I hope you will like it. This image (8 Sales order form Template Excel Exceltemplates Exceltemplates Excel order form Templates Free Download Bwufl) preceding is usually branded using: bakery order form template free,excel order form template free,food order form template free,form templates free with css,login form template free with source code,online order form template free,order form templates free,product order form template free,registration form template free in,registration form template free in asp net,supply order form template free,work order forms template free, placed through admin from 2017-12-14 18:20:24. To see just about all graphics throughout 6 order form Templates Free Download photographs gallery make sure you adhere to that hyperlink. The Most Brilliant and also Attractive order form templates free download stkdfintended for Inspire Your property Current Residence Comfortable AspirationResidence

N1Cea111Ance557