Enter your query, example: how not cry when slicing onion or how to enter an Free Italian Sex Webcams?
Home » Video » ...

How to hard code in excel Videos

How to Play Music in Excel

Learn how to start and stop a music (MIDI) file in Microsoft Excel.

Excel VBA - Arrays - Hard Coded - Tutorial With Code Available - Macro static values array

MS Excel VBA Tutorial 05 - demonstrates using Arrays with static values, and displays the results of the array in a series of message boxes.

Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References

Download Excel workbook //people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics about formulas and functions for the beginning Finance class.

User Comments

https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 09 Feb 2011
I work about 80 hours a week and I do not do consulting, but if you post a clear question and I have an answer in my mind within 10 seconds (if the question is clear I can usually do that), then I can usually point you to a helpful video. If you wnat to learn excel from beginning to end, watch my Excel Basics playlist and then the Highline Excel Class Playlist.
https://gp6.googleusercontent.com/-d8Kp1IUNQ1k/AAAAAAAAAAI/AAAAAAAAAAA/DxY62rXRIW8/s48-c-k-no/photo.jpg?sz=64
J Huang commented on 08 Dec 2012
thank you so much for sharing your knowledge, and dedicated your precious time to help all of us. I am planning to go over all your videos. I would like to improve my financial modeling skills as well, do you have any good books to recommend and anywhere i could have some free couses like yours?
https://gp4.googleusercontent.com/-q0uXlmTuGkM/AAAAAAAAAAI/AAAAAAAAAAA/jvI_OkjbPxs/s48-c-k-no/photo.jpg?sz=64
Tutul Khan commented on 09 Feb 2011
@ExcelIsFun Hello , I am just wondering if I need some help in specific section in excel, would you please help me? Because , in this semester I am doing a course and its all about spreadsheet. have a great day. Thank you.
https://gp5.googleusercontent.com/-M3e4QSd5F0g/AAAAAAAAAAI/AAAAAAAAAAA/3q79xXz04qw/s48-c-k-no/photo.jpg?sz=64
Kristian Morey commented on 14 May 2012
I'm looking on how to multiply my entire column by one factor is that possible? Is there a video for that? Essentially (A1:A21000)*1.14 is all I wish to do.
https://lh6.googleusercontent.com/-sEehl9PPy-o/AAAAAAAAAAI/AAAAAAAAAMk/KL6KIBP6FrI/photo.jpg?sz=64
SK kaz commented on 19 Aug 2015
Im 13 years old and my dad is an engineer and im going to teach him CATIA v5 and excel and this is very useful for me thanks!
https://gp6.googleusercontent.com/-Ap2c6rBgL_I/AAAAAAAAAAI/AAAAAAAAAAA/-G2uSieFmeg/s48-c-k-no/photo.jpg?sz=64
2ManyDaftMau5tice commented on 27 Nov 2012
Around the 18:18 to 18:20 mark, after you're done typing it auto formats to match the other label cells (blue fill, white font)
https://gp3.googleusercontent.com/-WuyI1hUb-TA/AAAAAAAAAAI/AAAAAAAAAAA/4TrC-gNOv1s/s48-c-k-no/photo.jpg?sz=64
Jihad Tawfiq commented on 31 Jan 2013
Thank you man for the good work. Solid excel background before hitting VBA programming. Thanks once again
https://lh3.googleusercontent.com/-XdUIqdMkCWA/AAAAAAAAAAI/AAAAAAAAAAA/4252rscbv5M/photo.jpg?sz=64
ngoc11aquarius commented on 22 Apr 2015
thank you for clear explantion. Pls help me find the excel files for the video in your link
https://gp4.googleusercontent.com/-jW9iBzM_PAQ/AAAAAAAAAAI/AAAAAAAAAAA/E18M9ZCpQXg/s48-c-k-no/photo.jpg?sz=64
Benedikt Kornek commented on 18 Mar 2011
perfect, it helps me a lot. Keep on teaching like this, it is great. Greetings from Germany
https://gp6.googleusercontent.com/-d8Kp1IUNQ1k/AAAAAAAAAAI/AAAAAAAAAAA/DxY62rXRIW8/s48-c-k-no/photo.jpg?sz=64
J Huang commented on 07 Dec 2012
thank you so much!! your video is lifesaver! having a interview regarding tons excel
https://lh4.googleusercontent.com/-HY9g9rBBCVo/AAAAAAAAAAI/AAAAAAAAAiA/ocrdmXPHYi4/photo.jpg?sz=64
Zeeshan Hamza commented on 16 Apr 2015
sir please help me i could not find this exercise file in your given link
https://gp4.googleusercontent.com/-2P-Nl4HaSZw/AAAAAAAAAAI/AAAAAAAAAAA/xmg0KfYmE1A/s48-c-k-no/photo.jpg?sz=64
Aditya Khunteta commented on 03 Aug 2013
i really love you!! excel fun .......i am sure you are god`s messenger !!!
https://gp4.googleusercontent.com/-S4yw5cV7ik0/AAAAAAAAAAI/AAAAAAAAAAA/SO8BZ79skOU/s48-c-k-no/photo.jpg?sz=64
shannon Ye commented on 24 Sep 2012
very useful!! thank you so much! you makes me want to study excel! ;D
https://gp6.googleusercontent.com/-lyd8hSeUMfE/AAAAAAAAAAI/AAAAAAAAAAA/1VxL6kRc2Hg/s48-c-k-no/photo.jpg?sz=64
SteveHovland commented on 12 Mar 2012
have you considered naming the cells that have the variables?
https://gp5.googleusercontent.com/-M3e4QSd5F0g/AAAAAAAAAAI/AAAAAAAAAAA/3q79xXz04qw/s48-c-k-no/photo.jpg?sz=64
Kristian Morey commented on 14 May 2012
Basically where each is multiplied individually by 1.14.
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 15 Apr 2012
At what minute mark in the video are you referring to?
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 08 Dec 2012
I do not know of any free financial modeling classes.
https://gp3.googleusercontent.com/-mEBktTrwwF4/AAAAAAAAAAI/AAAAAAAAAAA/Lim-cvncuvk/s48-c-k-no/photo.jpg?sz=64
Jeff campton commented on 18 Dec 2012
this video helped me in my assignment. subscribed!
https://lh4.googleusercontent.com/-ICV4pK8q6FQ/AAAAAAAAAAI/AAAAAAAAAvo/4B-O7B7QKcU/photo.jpg?sz=64
preet khattar commented on 04 Nov 2015
thank you so much for a wonderful class
https://gp4.googleusercontent.com/-tzUYHcljo6A/AAAAAAAAAAI/AAAAAAAAAAA/n7dMTfbXHW4/s48-c-k-no/photo.jpg?sz=64
hfc0518 commented on 10 Jun 2013
you are awesomely awesome :D god bless
https://lh3.googleusercontent.com/-XdUIqdMkCWA/AAAAAAAAAAI/AAAAAAAAAAA/4252rscbv5M/photo.jpg?sz=64
Matthew Keegan commented on 16 Mar 2015
This guy is an amazing teacher
https://gp4.googleusercontent.com/-6WgKluZNSmQ/AAAAAAAAAAI/AAAAAAAAAAA/Ca_kjt_YQRY/s48-c-k-no/photo.jpg?sz=64
Sabins Palakkal commented on 27 Jan 2013
Great Work....Keep Posting !!
https://gp4.googleusercontent.com/-q0uXlmTuGkM/AAAAAAAAAAI/AAAAAAAAAAA/jvI_OkjbPxs/s48-c-k-no/photo.jpg?sz=64
Tutul Khan commented on 07 Feb 2011
good one. thnx for video !!!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 23 Feb 2011
I am glad that you like it!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 08 Dec 2012
I am glad the videos help!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 18 Dec 2012
I am glad that it helped!!

Highline Excel Class 26: Fixing Other Peoples Spreadsheets

Download Excel file: //people.highline.edu/mgirvin/excelisfun.htm See a spreadsheet with 16 problems. See how to use Spreadsheet Construction ...

User Comments

https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 07 May 2009
Dear chippendails, To show formulas: Ctrl + ~ (Ctrl + tilda) also Ctrl + ` (Ctrl + grave accent key) or Excel 2007, Office Button, Excel Options, Advanced, "Display Options for this worksheet:", "Show formulas in cells instead of their calculated results" Excel 2003, "Tools" - "Formula Auditing" - "Formula Auditing Mode", or, Tools menu, select Options, then View tab, In "Windows Options" click checkbox next to Formulas, then click OK --excelisfun
https://gp5.googleusercontent.com/-273_HbsSKBA/AAAAAAAAAAI/AAAAAAAAAAA/78oq2-lB4WM/s48-c-k-no/photo.jpg?sz=64
google2com commented on 10 Apr 2010
Hi, So I don't know if you can help me with this but I was wondering if you know an easier way like importing of copy/paste financial statement from SEC website to excel. I heard there's like an interactive data thing but doesn't even know how to find it. You would be a life saver if you could help me find an easier way of inputting balance sheet and income statement into excel without manually type them in.
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 10 Apr 2010
You might be able to do a Web Query. But some web sites don't allow that. However, I just looked at the SEC site, and if you sign up, they offer free Excel downloads!! They even have a free trial on the page I looked at. This video title shows how to do a web query: Excel Magic Trick #104: National Debt Web Query
https://gp6.googleusercontent.com/-JkNJ2VMfZcQ/AAAAAAAAAAI/AAAAAAAAAAA/clIkwcSzHHo/s48-c-k-no/photo.jpg?sz=64
Aman Sachdeva commented on 20 Aug 2010
Thanks for the wonderful video again, God bless you sir. I have a query - is there any shortcut for going to the name box, what is it(if it's there), if not - then is there any other alternative then going to the name box manually?
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 21 Aug 2010
Instead of the name box, use Go To. The keyboard shortcut for that is: F5 Then just type your cell reference. Keyboard for Name Manager (Defined Name) dialog box = Ctrl + F3 Keyboard for pasting Name = F3
https://i1.ytimg.com/i/U2xGC0h3avCw6hca9NUtsw/1.jpg?sz=64
chippendails commented on 07 May 2009
Hey, on the left of "key 1" of my german keyboard is ^and °. but when I push this in combination with ctrl, Excel does not show me the formulas.
https://gp5.googleusercontent.com/-rbgsu-xVNMw/AAAAAAAAAAI/AAAAAAAAAAA/OTM6mAl0g2M/s48-c-k-no/photo.jpg?sz=64
Sandeep Sharma commented on 18 Jul 2012
Thanks for such wonderful Videos , which has made me what I am today :) U r just awesome !!!!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 07 Dec 2012
Thanks! I am glad that you like the videos! Sal Khan is a awesome human for what he does!
https://gp5.googleusercontent.com/-z8LksxKij8w/AAAAAAAAAAI/AAAAAAAAAAA/rZWvkcKqi-4/s48-c-k-no/photo.jpg?sz=64
naabrams commented on 07 Dec 2012
Your videos are awesome! Sal Khan needs to integrate these videos into the Khan Academy
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 07 May 2009
Dear chippendails, To highlight the whole table: Ctrl + * (Ctrl + Astrix) --excelisfun
https://i1.ytimg.com/i/U2xGC0h3avCw6hca9NUtsw/1.jpg?sz=64
chippendails commented on 07 May 2009
how do I highline the whole table? ctrl+ astrix???
https://gp5.googleusercontent.com/-273_HbsSKBA/AAAAAAAAAAI/AAAAAAAAAAA/78oq2-lB4WM/s48-c-k-no/photo.jpg?sz=64
google2com commented on 11 Apr 2010
@ExcelIsFun Thank you so much!!!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 18 Jul 2012
I am glad to help!
https://gp6.googleusercontent.com/-tDHO0qThc5I/AAAAAAAAAAI/AAAAAAAAAAA/s_fvhNoceuo/s48-c-k-no/photo.jpg?sz=64
ExcelIsFun commented on 11 Apr 2010
You are welcome!
Sign up for free to join this conversation on fsaved.com.
Already have an account? Sign in to comment