Excel Magic Tricks # 1: Formulas & Cell References

Download Excel workbook: http://people.highline.edu/mgirvin/excelisfun.htm See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references!


  1. Why CONTROL-enter?
  2. Mr. Master, I see your all videos on Excel and thankful to you for give us good knowledge, but sir I have problem that I made one file such database file saved on server, i.e. \\server\databasefile.xlsx and other file containing vlookup formula to lookup value from database file saved on server (network), i.e. vlookup (d5,'\\server\[databasefile.xlsx]Active'!$C$3:$O$200,4,0) and problem is when I opened both file at a time then problem is occur the vlookup (d5,'\\server\[databasefile.xlsx]#REF'!$C$3:$O$200,4,0) and also #REF in sheet also. Sir, I hope you understand my matter and sir mail me on my email: karamullahtunio@gmail.com, I am waiting for your reply sir and thanks a lot
  3. thank you sooooo much for posting these excel tutorial here. Without these tricks, I wouldn't be able to understand how this thing works. Excel skill is a must have with the kind of work I have now and your videos here are my life saver. thank you very much :)
  4. Now, is time to learn excel tricks!!! It would be hard without your videos, thanks Mike :)
  5. Thanks Mike.
  6. your channel is amazing. thank you so much for the class.
  7. This is great. Thank you. Not having a stab at you but I can't for the life of me see an angry Rabbit.
  8. we are very thnx
  9. Sir i request you ....
    please upload all excel magics tricks in hindi language...........
  10. are these tricks applicable only on excel 10?
  11. hi I can find where to download this particular excel tricks #1 as i am new in excel
  12. Hi Mike same as Quynh, I would like to share some tips I have about Excel, to the Latin American Community. Currently, I am developing a blog about it. I was wondering what hardware you use for recording your audio?
  13. 4:15 so funny sound ! LOL
  14. what is your college link I am looking to copy the senario example? michaelcazabon@gmail.com please can you email me?
  15. you are the best bro
  16. Lessons 23 to 89 are missing from this playlist! Can you tell me where to find them please?
  17. I really love your videos. I've learnt a lot from them. I got a certificate from Microsoft office as an expert in Excel with your help :). Thanks.
    I intend to make some videos to upload here. And I am wondering that what tool do you use to make these amazing videos?
  18. Start from here.
    Today I am a excel trainer.Without “Excel Magic Trick” It was not possible.
  19. Why you press control + Enter? Any reason?
  20. and this is trick? you are great. :D does that's done by macros? :D I need real tricks. where could I find them?

Additional Information:

Visibility: 267332

Duration: 4m 49s

Rating: 511