Excel Magic Tricks # 1: Formulas & Cell References

Video 1 – 10 Download Excel Files: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks01-10.xls Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks01-10Finished.xls Full Page With All File Links: 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. mostly my excel videos are inspired by your videos, most of the time i watch your videos and copies your trick in my videos, but my videos is in hindi, please help me to improve my audio quality
  2. respected sir your are my mentor, teacher, i have learn a lot from you , i am planning to upload video of excel in hindi (Indian language), i have prepared some video but is audio quality is not as good as your, can you please help me how to improve audio quality, thanks sandip gupta from india (sngup89@gmail.com)
  3. Why CONTROL-enter?
  4. 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
  5. 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 :)
  6. Now, is time to learn excel tricks!!! It would be hard without your videos, thanks Mike :)
  7. Thanks Mike.
  8. your channel is amazing. thank you so much for the class.
  9. This is great. Thank you. Not having a stab at you but I can't for the life of me see an angry Rabbit.
  10. we are very thnx
  11. Sir i request you ....
    please upload all excel magics tricks in hindi language...........
  12. are these tricks applicable only on excel 10?
  13. hi I can find where to download this particular excel tricks #1 as i am new in excel
  14. 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?
  15. 4:15 so funny sound ! LOL
  16. what is your college link I am looking to copy the senario example? michaelcazabon@gmail.com please can you email me?
  17. you are the best bro
  18. Lessons 23 to 89 are missing from this playlist! Can you tell me where to find them please?
  19. 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?
  20. Start from here.
    Today I am a excel trainer.Without “Excel Magic Trick” It was not possible.

Additional Information:

Visibility: 269374

Duration: 4m 49s

Rating: 522