Subscribe100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers
Hurray, PHD blog crossed 2000 RSS Subscriber base.
This is a very significant milestone for me.
To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.
These 100 tips & resources are organized in to the areas,
- Keyboard Shortcuts
- Formulas
- Using Excel to do more
- Charting
- Excel Books for everyone
- Excel Blogs & Resources
All these tips are bite sized and easy to read, digest and implement. The focus is on improving your productivity and making your day better. Wherever possible, I have included links to relevant articles on this site so that you can read and learn more.
If you like this post, I encourage you to signup for e-mail updates or RSS Feeds.
Please spread this blog by submitting to delicious or stumbleupon, that makes me *really* happy
Bookmark this on Delicious | Stumble this page
Ok, on to the tips now…
25 Very Useful Keyboard Shortcuts
1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up
20 Situations and How to Solve them using Excel Formulas
26. To get the first name of a person, use =left(name,find(” “,name)-1)
27. To calculate mortgage payments, use =PMT(interest-rate,number-of-payments,how-much-loan)
28. To get nth largest number in a range, use =large(range,n)… Get Full Tip
29. To get nth smallest number in a range, use = small(range,n)… Get Full Tip
30. To generate a random phone number, use =randbetween(1000000000,9999999999), needs analysis toolpak if you are using excel 2003 or earlier… Get Full Tip
31. To count number of words in a cell, use =len(trim(text))-len(SUBSTITUTE(trim(text),” “,”"))… Get Full Tip
32. To count positive values in a range, use =countif(range,”>0″)… Get Full Tip
33. To calculate weighted average, use SUMPRODUCT() function
34. To remove unnecessary spaces, use =trim(text)
35. To format a number as SSN using formulas, use =text(ssn-text,”000-00-0000″)… Get Full Tip
36. To find age of a person based on DOB, use =TEXT((NOW()-birth_date)&”",”yy “”years”" m “”months”" dd “”days”"”), output will be like 27 years 7 months 29 days
37. To get name from initials from a name, use IF(), FIND(), LEN() and SUBSTITUTE() formulas… Get Full Tip
38. To get proper fraction from a number (for eg 1/3 from 6/18), use =text(fraction, “?/?”)
39. To get partial matches in vlookup, use * operator like this: =vlookup(“abc*”,lookup_range,return_column)
40. To simulate averageif() in earlier versions of excel, use =sumif(range, criteria)/countif(range, criteria)
41. To debug your formulas, select the portions of formula and press F9 to see the result of that portion… Get Full Tip
42. To get the file extension from a file name, use =right(filename,3) (doesn’t work for files that have weird extensions like .docx, .htaccess etc.)
43. To quickly insert an in cell micro-chart, use REPT() function… Get Full Tip
44. COUNT() only counts number of cells with numbers in them, if you want to count number of cells with anything in them, use COUNTA()
45. Using named ranges in formulas saves you a lot of time. To define one, just select some cells, and go to menu > insert > named ranges > define
15 Excel Tips on Improving Productivity Using Excel
46. To format a number as SSN, use the custom format code “000-00-0000″… Get Full Tip
47. To format a phone number, use the custom format code “000-000-0000″… Get Full Tip
48. To show values after decimal point only when number is less than one, use [<1]_($#,##0.00_);_($#,##0_) as formatting code… Get Full Tip
49. To remove grid lines from excel worksheet, go to menu > tools > options > and un-check grid lines option. (Excel 2007: office button > excel option > advanced)… Get Full Tip
50. To hide a worksheet, go to menu > format > sheet > hide… Get Full Tip
51. To align multiple objects, like charts, drawings, pictures use drawing toolbar > align and select alignment option… Get Full Tip
52. To freeze rows on top, select the a row and use menu > window > freeze panes… Get Full Tip
53. To disable annoying formula errors, go to menu > tools > options > error checking tab and disable errors you don’t want to see… Get Full Tip
54. To change the shape of cell comments from rectangle to some other symbol, select the comment, go to drawing tool bar and change the shape from there… Get Full Tip
55. To transpose a range of cells, copy the cells, go to empty area, and press alt+e+s+e… Get Full Tip
56. To save data filter settings so that you can reuse them again, use custom views… Get Full Tip
57. To select all formulas, press CTRL+G, select “special” and check “formulas”
58. To select all constants, press CTRL+G, select “special” and check “constants”
59. To clear formats from a range, select menu > edit > clear > “formats”
60. To move a chart and align it with cells, hold down ALT key while moving the chart
9 Charting Tips for Everyone
61. To create an instant micro-chart from your normal chart, use camera tool… Get Full Tip
62. Understand data to ink ratio to reduce chart junk, using even a pixel more of ink than what is needed can reduce your chart’s effectiveness
63. Combine two different types of charts when one is not enough, to use, add another series of data to your sheet and then right click on it and change the chart type… Get Full Tip
64. To reverse the order of items in a bar / column chart, just click on y-axis, press ctrl+1, and check “categories in reverse order” and “x-axis crosses at maximum category” options
65. To change the marker symbol or bubble in a chart to your own favorite shape, just draw any shape in worksheet using drawing toolbar, then copy it by pressing ctrl+c, now go to the chart and select markers (or bubbles) and press ctrl+v
66. To create partially overlapped column / bar charts, just use overlap and gap settings in the format data series area. A overlap of 100 will completely overlap one series on another, while 0 separates them completely.… Get Full Tip
67. To increase the contrast of your chart, just remove grayish background color that excel adds to the chart (in versions excel 2003 and prior)
68. To save yourself some trouble, always try to avoid charts like – 3D area charts (unstacked), radar charts, 3D Lines, 3D Columns with multiple series of data, Donut charts with more than 2 series of data… Get Full Tip
69. To improve comparison, replace your radar charts with tables… Get Full Tip
6 simple steps for better chart formats
70. Remove any vertical grid-lines
71. Change horizontal grid-line color from black to a very light shade of gray
72. Adjust chart series colors to get better contrast
73. Adjust font scaling (for versions excel 2003 and prior)
74. Add data labels and remove any axis (axis labels) if needed
75. Remove chart background colors
5 Excel books for everyone
76. Excel 2007 Bible by John Walkenbach
77. Excel 2007 Formulas by John Walkenbach
78. Excel 2007 Charts by John Walkenbach
79. Excel 2007 Power Programming with VBA
80. Teach Yourself VISUALLY Excel 2007
PS: Links to Amazon, affiliate code used
20 Excellent Resources and Blogs for getting latest Excel Tips & Charting Ideas
81. PTS Blog
82. Andrew’s Excel Tips
83. Microsoft Excel 2007 Team Blog
84. Contextures
85. Junk Charts
86. Daily Dose of Excel
87. Digital Inspiration
88. Life Hacker
89. Jorge’s Charts Blog
90. DSA Inisights
91. Excel Blog @ TVM Calcs
92. Juice Analytics
93. More information per pixel
94. Newton Excel Bach
95. Presentation Zen
96. Visual Business Intelligence by Stephen Few
97. Cell Matrix
98. Allen Wyatt’s Excel Tips
99. Code for Excel and Outlook
100. All the Popular Excel Bookmarks in Delicious
Join the celebrations, share your tips & ideas
I encourage you to share your Excel Tips & Charting Suggestions through comments section. We have a vibrant reader community here and we love to learn from each other.
If you like this post, I encourage you to signup for e-mail updates or RSS Feeds.
Please spread this blog by submitting to delicious or stumbleupon, that makes me *really* happy
Bookmark this on Delicious | Stumble this page
| ||
|
Spread some love,
Posts & Navigation
Tags: books, charting, Charts and Graphs, excel 2007, excel blogs, Excel Tips, howto, keyboard shortcuts, lists, microsoft, Microsoft Excel Formulas, MS, spreadsheets, tips |
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 450+ articles and tutorials on using excel, making better charts. 
88 Responses to “100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers”
Your book list has all Excel 2007 books, do you actually use Excel 2007? Your last post with screenshots was Excel 2003 (I think).
Great post. I learnt a few great little tips in here, despite using Excel for 15 years!
@JP: I use both 2003 and 2007 (about 50% of time each). Even though excel 2003 is used for screencaps etc., I think learning excel 2007 is better than 2003 if you are buying books.
@Andy: welcome to PHD and thanks
Congratulations!!! I enjoy your posts on excel tips…
@Joel, thanks.
@all.. doh! I missed the spreadsheetpage blog…
http://spreadsheetpage.com/
Chandoo, great stuff on your site! I am a keen Excel enthusiast and I do visit quite a lot of website that puts out Excel material, but I must say the info contained on your site is top class and most importantly you offer this stuff free! Thanks Chandoo, appreciate what you to do, to help guys like us.
@Rozario. Welcome and thanks for the wonderful words. Learning and sharing is a very enriching experience and I am thoroughly enjoying it through this medium. I encourage you to go around the site and see what we have got here. If possible, invite your friends and colleagues to the site and help them get productive.
Great compilation …. nice work
[...] 100 Excel Tips & Resources for Everyone | Pointy Haired Dilbert – Chandoo.org (tags: tips personal tutorials reference howto Microsoft Excel office) [...]
Nice shortcuts. One from me
Alt+Ctrl+Tab to move text/content any where in the cell toward right
Alt+Ctrl+Shift+Tab to move text/content any where in the cell toward left
Hi Chandu ! this is the site which i am looking since long today i got it while surfing. I wish to develope some stock mkt utility in excell for self use and ready to offer it free to all if it works fine.
I dont under stand how create data base sort of thing in excell through EOD or fetch data from NSE and put formula into it. If u have made any utility plz mail me.
regard
anand
@Prasanta: Thank you so much for sharing your tips.
@Anand: Welcome to PHD and thank you so much for commenting.
Unfortunately I havent made any utility to automate stock quote download. There are several ways in which you can do this in excel though. Check out: http://chandoo.org/wp/2008/06/24/get-stock-quotes-in-excel/ and see the comments there.
I will let you know if we create something to automate this.
Hi,
Great list. I don´t know why these shortcuts are always kind of hidden when they are so usefull. I think Excell should have an easy way to see them in the help or something.
and here is another one:
to fill down a group of selected cells (with the value of the upper selected one)
Also you may find that if you use Excel in another language you may need to adapt a bit this shortcuts (which I find really anoying) for example:
To insert current date, To insert current time. Worked really well in my English excel, but now I am using excel in German and they don´t work at all. I´ve discovered that in this case I only need to replace the semicolon for the period and everything is fine.
And in the case of to fill down the sellected cells, I need to use
Sorry, used some characters that prevented some text to be displayed, here is the corrected post…
Hi,
Great list. I don´t know why these shortcuts are always kind of hidden when they are so usefull. I think Excell should have an easy way to see them in the help or something.
and here is another one:
ctrl+d to fill down a group of selected cells (with the value of the upper selected one)
Also you may find that if you use Excel in another language you may need to adapt a bit this shortcuts (which I find really anoying) for example:
ctrl+; To insert current date, ctrl+shift+ To insert current time. Worked really well in my English excel, but now I am using excel in German and they don´t work at all. I´ve discovered that in this case I only need to replace the semicolon for the period and everything is fine.
And in the case of ctrl+d to fill down the sellected cells, I need to use ctrl+u
Hello,
In tip 36 To find age of a person based on DOB :
It is not correct to use the date format “yy mm dd” to dysplay an age !!!!
Assume an age of 60 years 0 month and 24 days
how to display the month 0 ?
on the other hand:
an age of 60 years 12 months 31 days is inconsistent!
you better use DATDIF function
Cheers !!!
@Modeste: thanks for your tip on datedif(), it is an undocumented function.
Can you explain how to count only the number of red cells using the VBA code. I’m missing something when I copy and paste in the module.
Thanks
@Glenn… can you help me understand your question? What is the module you are referring to?
I’m using 2007 excel-I want to count just the red cells from a selected column. I’m very versed with key stroke macro’s, but I dont understand how to set VBA when copying and pasting a code for this function. Maybe I’m not explaning myself due to lingo barrier…
[...] To clone value from above cell: press ctrl+’ This will make a twin from the above cell. (99 more tips) [...]
[...] we have crossed the milestone of 2000 RSS subscribers in the Jan 2009. To celebrate that I posted one hundred excel tips. That was fun (plus Jo hated me for sitting in front of computer that [...]
I have no words to explain how much your tips are useful for me
Nice Shortcut, it’s really perfect.
Nice tips!
//
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up
//
To skip between worksheets ctrl + pg keys are sufficient.
Holding shift key will group the worksheets.
hai chandoo u r excellent ya i am so hppy with join ur team best of luck
How do I print my excel spreadsheet on one page?
@ Donna
Select your data
On the Page Layout Tab, Click the Print Area Button and select Set Print Area
At the Bottom Right Corner of the Page Layout Tab seelct the Page Setup pullout arrow
Adjust the Page Orientation
and set Scaling to Print 1 Page Wide by 1 Page Tall
Great tips. I especially like tip # 39 partial matches in vlookup.
hi chandoo,
really nice work, thanks.
i would like to save patient’s personal info like name, class etc as i work in an hospital to his/her file number, so that when i enter the medical file number in one cell all the saved data should fill in the adjacent cell automatically, pls help.
regards,
raaj.
I am just wondering if this question was answered, as I also would like to know how to do this for a smilar application.
Thank you.
Hello,
thanks for post.. can u please post some think about PPT…
warm Regard’s
Karan Variava
i am glad. i have attended excel seminars but i find this thriling. please keep up the good work and making it free it is quite rewarding. please keep up the good work
Hi,
I JUST WANTED TO KNOW THE INSTITUTE WHICH PROVIDES TRAINING FOR ADVANCE EXCEL.
Hi,
do u have any idea of how to use activex in excel, if u know please revert back on my mail.
Thanks and regards,
Jayanth.M
Happy Birthday Chandu
I am new to your group and found the list just awesome! Thanks!
I was able to hide and unhide the rows using the tips your provided, but was unable to unhide the column..I pressed ctrl+shift+0. It did not work. What could I be doing wrong? I was able to hide the column. Kindly help
Keyboard shortcuts part – thats what i was looking for, thanks!
IN EVERY BUSINESS ORGANIZATION BANK RECONCILATION IS TEDIOUS JOB. IT IS A EASIEST JOB BY USING EXCEL DATA SORT COMMAND.
STEP-1 DOWNLOD BANK STATEMENT IN EXCEL FORMAT.
STEP-2 SORT THE DATA ON AMOUNT COLOUMN
NOW YOUR JOB BECOMES EASY TO DO RECONCILATION WORK FASTEST
I am planning to develop small application for fund/finance management, which module of your site/training will help me, please suggest
manish
Dear Chandoo, I tried to hide the current row & current column in excel 2003 as described in 11 and 12 but I couldnt do it….
Dear Chandoo,
When we are working with MS Office Excell, we have a provision for protect the file by putting password. If we create a excell file with password, others cannot open without knowing password. But the same file opens with Star Office, no need of password only just untick the password option. What is the use of putting password. Please clarify my doubt. Ramesh M
sir, when we substract from a date/month/year , to date/month/year how to get days/months/years please give a formula i am trying lot of days
pleaseeeeeeeeeeeeeeeee……
Kindly give me some tips on macros.
@Tapan
Have a read of http://chandoo.org/forums/topic/im-teaching-myself-some-vba-wanna-help
and then start to look at small examples here or at home
Use the Search Function at the top of the Chandoo.org web site and Google has links to nearly every imaginable problem.
@Tapan,
Here are some Excel VBA tutorials that might help you out…
http://www.anthony-vba.kefra.com/
http://www.jlathamsite.com/Teach/VBA/ProgrammingInExcelVBA_AnIntroduction.pdf
http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm
The second one is quite lengthy and complete, but maybe you should start with the first one to “get oriented”. The third one is a nice follow up.
very nice man.please send alerts
Wonderful easy to understand information. I haven’t seen any other site with such excellent information. Many thanks
Hi Chandoo, wonderful site to excel in excel
1. Would like tips on payroll stuffs like there are about 200 employees and need to know how many extra hours worked and on which dates should be the end result.
2. Tips on roster and forecasting of call center.
3. Macros for beginners and advanced users
Many thnx
Please advice some excel macro tips to compare two sheets
Hi Sir,
please help me. how to open hidden Game in excel 2007
@Mayank… I am not aware of any hidden game in Excel.
@Ravindra: Visit http://chandoo.org/wp/2010/02/19/excel-consolidate-data/
@Mayank & @Chandoo …
Yes, there are hidden games in Excel , usually called as Estern Eggs in Excel.
Please see these links for more details
http://eeggs.com/items/29841.html ( for Excel 2007 )
http://www.askstudent.com/gaming/how-to-find-the-hidden-game-in-microsoft-excel-2000/
( for Excel 2000)
Hello,
I am facing a problem with Outlook email while sending and reeving emails but while with the same settings i am able to use with a data card this problem only comes when i am connecting it to lan connection i have tried reinstalling settings and Outlook but it doesn’t work if you can help for the same would be waiting for your replay.
Regards,
Mohammad Mal
dear chandoo, tell me how to protect a particular cell or rows or column in ms-excel 2003.
@Sunjay… follow this process:
1) select cells, rows or columns you want to protect. Go to format cells
2) make sure the option “Locked” is checked from protection tab.
3) right click on worksheet name and choose protection
4) give a password and repeat it
5) Now, your worksheet is protected and all the locked cells are not editable.
You can do a lot more with worksheet protection. Just play with the options.
Hi chadoo Great work with this. I am looking for Finacial Modelling using Excel. How to work with Ratio Analysis. Work out Marginal cost of debt and equity etc would be done good with excel. Do you have such a course. If so Please let me know.
hi chandu, i am from vizag, i heard so much of u, and visited ur blog, its grt & amazing, keep it up and thanks a lot for sharing ur knowledge to others, catch u soon
Thanks for the post.Your site is like bible for people who want to learn XL.
how to put trial period to an excel file/project. say like 30 days.
I will really appreciate your help
i need your help, in my excel workbook i have several work sheets with various names. how can i count the number sheets are there in my work book?
Add a UDF
`Function NoSheets() As Integer
NoSheets = Sheets.Count
End Function`
To use just enter =NoSheets
in any cell
Hi,
I have data in many columns. I need to compare any of the two columns and so while comparison I require only the two columns to be displayed with the others hidden. Could you please suggest me any macro for this. Is this possible without using the feature of hiding columns? Please suggest.. Thanks in advance
Im Shoaib From Pakistan please email any body… I need All Formulas of Excel and how to use it….
Thanking you in anticipation.
hey chandoo,
i m still waiting for my 25 page e-book, can u help
Hi Chandoo,
Please help me to learn whole excel in and out including VBA.
Thank you
Kumar Krishna
Could you please tell me how to insert a check mark in excel and also how to create a short cut for the degree symbol many thanks
@Unnatti
Goto the Insert, Symbol Tab
Change Font to suit and Find your Symbols, Insert
You can use Keyboard Shortcuts, using the Numeric Keypad
Deg – Alt 0176
Check – Change Font To Wing Dings 2 and insert a Capital P
oh sir thanks 4 providing me such a valuable information about excel
I have opend your website first day with help of my friend, it’s really very nice way to learn excel, solve the all type of formula with help of your above mention example and formulas.
You are doing a great job to make every one aware in excel without any charges.
Iam unable to understand how to select the items in pivot tables. I mean to say, i have a data in front of me, but not able to understand what to drag where to get output. Basically i want to know whole concept of Pivot tables.
Please Advise.
Regards,
Kalyan Chakravarthy
@Kalyan
Have a look at : http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
Thnx Chandoo! I will work once on this and let you know if i have any questions.
Hello Chandoo!
Iam very much interested to learn excel, Usually i use excel but iam not 100% perfect.
actually i have read your profile and keen to know about MVP.
Can you please let me know what is the eligibilty criteria, how to approach and how to get train on MVP.
Please Advise
Very nice stuff..
Tip 16: To select data in current region, press ctrl+shift+8
In fact, it is Ctrl+* to select data in current region.. here shift+8 is nothing but *. Dont try Crl+shift+8 (from nums key pad..which is right side of your keyboard). If you want to use ctrl+shift+8 then you have to press 8 above the alphabet keys.
Regards,
Saran
lostinexcel.blogspot.com
@ Kalyan,
First of all, MVP is not certification course at all. MVP (Microsoft Valuable Professional) is the award which is given by Microsoft. MS will give this award based on the individual last one year contribution towards any MS Domain. Means you have to participate into different forums to answer the readers questions, or you can maintain your own blog to give guidance to the people on that particular domain. Before all these you have some skills and ready to learn new things everyday.
Chandoo, did lot of work and gave very gud guidance to the readers through his posts. That is the reason chandoo got MVP prestigious award from MS.
All the best Kalyan..if you want even you can…follow learn and share techniQue
Regards,
Saran
lostinexcel.blogspot.com
@ Sudita @ Hui
Your is fantastic code.
There is one more alternative and you can try it.
First define name by refering to =GET.WORKBOOK(1)&T(NOW())
Then use this below formula to get the number of worksheets in the current work book
=counta(index(defined name,0))
Hope it works..
Regards,
Saran
lostinexcel.blogspot.com
HI CHANDOO !
I WANT PREPARE A PROJECT REPORT FOR BANK LOAN IN EXCEL FORMATE. I AM NOT UNDERSTANDING THE METHOD AND PROCEDURE OF EXCEL WHICH TO BE CODE USED IN. CAN YOU GIVE A COMPLETE CODE FOR SETUP A PROJECT FORMATE . SO THAT MY ACCOUNTANCY PROBLEMS WILL NOT COME. I AM DOING IN WORD FORMATE. BECAUSE I DON’T KNOW WHICH CODE TO BE USED IN .PLEASE GOVE SOME BASIC IDEA WITH A EXAMPLE , SO THAT I CAN DO IT.
Need help, how to use vlookup with if condition, My query
Country number VOLUME OUTPUT
USA 1 12
UK 2 24
my query,
if USA = 1 and volume 12 =100
if uk =1 and volume 12 = 150
hi
Can u send VB notes.
hi guys,
can anyone help or provide some ideas about a simple database or spreadsheet ive got to create for my work
regarding headcout or employees in each department or area split over grades?
thanks
hi … nice posts , very useful
I am using formula a cell and after 5 Line I want to repeat subsequently, ie, If I am using =f10 after 5 cell I want to use =f11 after 5 cell I want to use formula =f12 ,is there is anything way to use in excel if yes please help me
Hi chandoo….its a gr8 job by u sir…
Im learning excel as i recently working on excel in making reports…
i am desperate to learn more shortcuts as we have lots n lots of work as we have to know short cuts other wise ill be back in work …..so please help me more on short cuts
chandoo can i have your phone number, I have so many doubts in excel plz help me out.
Hi P.Surebdat09
Why don’t you post some questions at the chandoo.org forums
they are generally answered within hours 24 hours a day!
Goto the bottom of the following page:
http://chandoo.org/forums/forum/ask-excel-questions
[...] excel tips Share this:TwitterFacebookLike this:LikeBe the first to like this post. Categories Uncategorized [...]
[...] article called 100 Excel Tips and Resources makes me want to sing [...]