Thanks. I don't think I am going to use any of the features of Excel that you taught in this video but as you said, it is important to know everything even if we don't use every feature or find every feature useful.
@excelisfun
Ай бұрын
Good for you in studying it all : )
@P1X1E56
6 жыл бұрын
I am totally blown away by your delivery. I'm retired now, but still dabble in Excel for a friend who runs a small business. I thought I was fairly proficient at Excel, and while working thought I didn't have the time to spend on out of hours study; I wish I had. In just 18 lessons I have learned many things which save time. I am hooked until the end of this series. Cannot get enough. Thank you so much. keep it coming.
@excelisfun
6 жыл бұрын
You are welcome so much! I am glad that the videos help : ) Now you can help: be sure to click that thumbs up and leave a comment on each video because it helps the excelisfun channel : )
@markkennedy9767
Ай бұрын
Thanks for this. When we name columns in tables (not just ranges), is the dynamic nature of tables preserved.
@excelisfun
Ай бұрын
Yes it is : )
@markkennedy9767
Ай бұрын
@@excelisfun Thanks
@rrrprogram8667
7 жыл бұрын
Believe me... One learns more than excel in this channel.... Which is amaaaazingg
@excelisfun
7 жыл бұрын
Thanks for watching and for your support!!!
@sardorabdurahimov4569
5 жыл бұрын
Thank you so much for all your effort and good work! I am using everything you have thaught at my work at the Bank! God Bless You! Sardor from Uzbekistan!
@excelisfun
5 жыл бұрын
You are welcome, Sardor!!! I am very happy to hear that you can use all these efficiencies at work! Thanks for your support on every video that you watch : )
@rrrprogram8667
7 жыл бұрын
Mike one sincere request, can you please make a video on developing effective CV or Resume in word......Please you have got amazing sense of selection and hugeeee experience
@excelisfun
6 жыл бұрын
I have one video but it only shows how to create a resume with Word features: kzitem.info/news/bejne/x7CO0GaohpOaq2U
@pashayakub9
4 ай бұрын
Another great video. Thank you so much Mike ✋
@excelisfun
4 ай бұрын
You are welcome!!!
@MonirulIslam-zj3ve
6 жыл бұрын
Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. You are the best. Thanks a lot to keep love and patience in your teaching field.
@excelisfun
6 жыл бұрын
Glad that the videos and teaching helps! Thanks for the support !!!!!
@nghiepcrypto7034
4 жыл бұрын
I not only learn excel from you but also learn other skills from you. You're amazing!
@excelisfun
4 жыл бұрын
Glad to help, Nguyen!!! What other skills did you learn in this one?
@nghiepcrypto7034
4 жыл бұрын
@@excelisfun your presentation, pay attention to details... skills. I also admire at your enthusiasm and your consistency ;)) really, you're my idol
@excelisfun
4 жыл бұрын
@@nghiepcrypto7034 Cool! Keep watching and having fun : ) Because I am having fun too!!!
@masterjack9505
Жыл бұрын
Thank You Teacher.
@excelisfun
Жыл бұрын
You are welcome!!!!!
@paddy8937
3 жыл бұрын
I think these are the best videos on Excel, thank you very much.
@excelisfun
3 жыл бұрын
You are welcome very much!!!
@Nyuklehead
4 жыл бұрын
Thank you for the video! This seems like a great way to keep track of complex workbooks and data sets.
@excelisfun
4 жыл бұрын
: )
@deveshdangi7209
4 жыл бұрын
This video was okay. I learned a lot but I believed this was not something which blows my mind like your other videos. Btw all your previous videos were awesome!!!
@excelisfun
4 жыл бұрын
Yes, Defined Names were the best way to do this sort of thing from 1990s till 2010s. But now the Excel Table feature and Table Formula Nomenclature is used more often. I still have to teach Defined Names, because a lot of legacy Excel Solutions use them and there are still a few cases where they are good.
@excelisfun
4 жыл бұрын
Of course, the BIG downside to Table Formula Nomenclature is when you have to make the references, absolute.
@MsNoeynono
7 жыл бұрын
Thank you for these videos. I very much enjoy watching this channel!
@excelisfun
7 жыл бұрын
You are welcome! Thanks for the support with your comment,m Thumbs Up and Sub : )
@ezgikocak7457
Жыл бұрын
Amazing! So helpful! Thanks!
@joramirez159357
6 жыл бұрын
There is always something new to learn on Excel
@excelisfun
6 жыл бұрын
Yes there is! That is what makes it so much fun : ) Thanks for the support with your comments, Thumbs Up and Sub : )
@dorissweanapo9860
6 жыл бұрын
Another great video. Thank you Mike :)
@excelisfun
6 жыл бұрын
You are welcome, Doris! Thanks for your support : )
@Kizo_55
4 ай бұрын
Thank you!
@excelisfun
4 ай бұрын
You are define names welcome!!!!
@SyedMuzammilMahasanShahi
7 жыл бұрын
Another amazing video. Thanks Mike.
@excelisfun
7 жыл бұрын
You are welcome! Thanks for your continual support : )
@shubhampawar8506
3 жыл бұрын
Great vedio as usual 👌👍
@excelisfun
3 жыл бұрын
: ) : ) : )
@emile8147
3 ай бұрын
while writing the formula you can hit F3 to paste a name too
@excelisfun
3 ай бұрын
Niice!!
@tvts5157
Ай бұрын
Thanks for sharing this trick :)
@mohamedchakroun4973
7 жыл бұрын
Always fun to watch your videos
@excelisfun
7 жыл бұрын
I am glad that they are fun! They are fun to make!!!
@mohamedchakroun4973
7 жыл бұрын
If they aren't you might not make them perfectly and doing a great job ....but they requires a lot of time..thanks for sharing your khnowledge with us
@excelisfun
7 жыл бұрын
You are welcome! Thank you, Mohamed for always taking the time to support the excelisfun channel : )
@abdulwahabnajeeb8337
7 жыл бұрын
Awesome channel. Thanks for the detail demos...
@excelisfun
6 жыл бұрын
You are welcome for the detailed videos! Glad that the videos and teaching helps! Thanks for the support with your comments, Thumbs Up and Sub : )
@pmsocho
7 жыл бұрын
Great as always!
@excelisfun
7 жыл бұрын
Thank you, Teammate : )
@lewisyaworski8962
6 жыл бұрын
7 more videos to complete. Almost ready to do Data Analytics Videos.
@excelisfun
6 жыл бұрын
Great work!!!! I hope the free education is good : ) Thank you for the support, Lewis : )
@febrianto984
4 жыл бұрын
thank you for today's lesson
@excelisfun
4 жыл бұрын
You are welcome, Febri : )
@pumpkinpie1557
5 жыл бұрын
Great timesaver. Thanks Mike
@excelisfun
5 жыл бұрын
You are welcome, Pumpkin Pie!!!!
@a3amatikys
4 жыл бұрын
Hi Mike! Thank you for another gr8 video about Excel. Btw. Excel Basic Video №18 is going earlier on KZitem, than video №17. Just FYI.
@excelisfun
4 жыл бұрын
No, Excel Basics 17 is there. If you serahc for it it is there. In the classroom playlist it comes after video #18. Are you using the KZitem Learning Playlist that I have set up for this class: kzitem.info/door/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
@anderson40th60
5 жыл бұрын
Another rad video! Thanks!
@excelisfun
5 жыл бұрын
Defined Names are THE original Rad in Excel - going way back : )
@hasannaomir.3037
7 жыл бұрын
Thank you soooooooooo much!!!! You so rock, Professor!!!
@excelisfun
7 жыл бұрын
You are soooooooo welcome! Thank you for the support with your comment, Thumbs Up and Sub : )
@bavajikj3267
3 жыл бұрын
great job sir. thank you
@excelisfun
3 жыл бұрын
You are welcome, bavaji : ) : )
@ismailismaili0071
7 жыл бұрын
Thank u so much Mr. Mike this us really useful for me
@excelisfun
7 жыл бұрын
You are welcome! I am glad that it is fun!!!
@KWChamonix
7 жыл бұрын
Thank you, and I thought I knew everything there was to know about ranges.
@excelisfun
7 жыл бұрын
You are welcome! Thank you for your support!
@josephmegalaa602
5 жыл бұрын
wow it is absolutely outstanding
@excelisfun
5 жыл бұрын
Glad it is outstanding for you, Joseph!!!! Thanks for your support : )
@josephmegalaa602
5 жыл бұрын
ExcelIsFun I have a question I want to get certificate at excel it will help me with job career how may I obtain it ?
@sorenzollamas
7 жыл бұрын
Brilliant as usual. Question: If you create a table and are going to use the data from its columns in other formulas, should you name the columns or is that redundant in some way?
@excelisfun
7 жыл бұрын
It depends... on multiple facts... The topic is for a different class, not this basic class. But... If you are just copying the formula across the rows and you want the reference locked, then you use Table Formula Nomenclature. If you want the default Mixed Cell References behavior of Table Formula Nomenclature when you copy the formula across the columns, then use Table Formula Nomenclature. If you want to avoid the the default Mixed Cell References behavior of Table Formula Nomenclature when you copy the formula across the columns, then you use Defined Names.
@stephanieclancy254
5 жыл бұрын
Great video!
@excelisfun
5 жыл бұрын
Thanks, stephanie!!!
@lucatoml
10 ай бұрын
Hi there great explanation, but I have a doubt it it is possible to achieve. I have set a name to go to a certain column. But I need when I call this column, that the cursor goes to the selected cell column, but keep in the line it was, in other words, when I call this "column" I want to go to the line where the cursor was at (selected cell) but positioned on the called column? Any idea how to manage it or if is there some formula? Thanks.
@kisslaci36
6 жыл бұрын
THumbs up. Continuos learning.
@excelisfun
6 жыл бұрын
Thanks for the Thumbs Up! Continuous learning is a LOT of fun : ) Thanks for the support with your comments, Thumbs Up and Sub : )
@Nikol0zi
4 жыл бұрын
Hey Mike, the download excel in this link is a little different, it does not have homework and Defined Names (an). thanks for everything again.
@excelisfun
4 жыл бұрын
Yes, becasue I did not want to confuse people with Defined names already there.
@chandu7spark
4 жыл бұрын
Good Info Tanq once again.
@excelisfun
4 жыл бұрын
Glad you like it, Bharat!!!
@idanbenruby8741
5 жыл бұрын
very effective mike! makes saves alot of clicks (:
@johnborg5419
7 жыл бұрын
Very Interesting and thanks. :)
@excelisfun
7 жыл бұрын
You are welcome, John Borg!!!!!
@Whyvardhann
6 жыл бұрын
super useful
@excelisfun
6 жыл бұрын
Glad the video helps!!! Thank you for your support : )
@socheatnhoeb1239
2 жыл бұрын
very good
@meniporat3527
7 жыл бұрын
Excellent, as usual. However, the file cannot be downloaded. Please correct the link. Best regards, teammate :-)
@excelisfun
7 жыл бұрын
Okay : ) I fixed it : )
@mostafaahmedzein450
5 жыл бұрын
Great Lesson as expected !! :D But why I would name a cell for moving between tabs instead of using the tab at the bottom of screen? 😅
@excelisfun
5 жыл бұрын
Glad it was good for you!!! You asked: "why I would name a cell for moving between tabs instead of using the tab at the bottom of screen?" The reason is because some workbooks have 100s of sheets and it can make it easy to jump to just the sheet you want, and just the section of the sheet that you want.
@mostafaahmedzein450
5 жыл бұрын
@@excelisfun Aha! Thanks again.
@masterof
8 ай бұрын
If I have an Excel sheet, many of the cells has been named with similar style (e.g. the same pre-fix or the same suffix), is it possible to add these cells together? For example, in a sheet that has cells named as "StockLocationA1", "StockLocationA2", "StockLocationA3"...etc, and these cells are located randomly in thet sheet but all clearly defined in the Name Manager. How to add these cells named "StockLocation"&"*" together? I tried =SUM(INDIRECT("StockLocation"&"*")) but that has a reference error. Many thanks for your help...
@ahmed007Jaber
4 жыл бұрын
how to cancel the cell names and use the reference instead?? go to the manager and delete those names? or is there a way to deactivate? insofar I don't have use for them as the data I get to work with isn't perfectly designed and arranged
@AhmedAli-ep2wz
Күн бұрын
❤❤❤❤❤❤❤❤❤
@excelisfun
Күн бұрын
: ) : ) : )
@FlossinBBQ
7 жыл бұрын
You mentioned that named ranges are not dynamic. They can be by using the offset and counta formulas in the Name Manager Refers to: window.
@excelisfun
7 жыл бұрын
Yes, indeed : ) I wrote a book with a whole chapter on those cool OFFSET & INDEX Dynamic Range formulas : ) But they are less relevant now because of the Excel Table feature.
@hiteshjoshi3148
3 жыл бұрын
My monthly pmt came as ####### in red color why need help sales also came as ##### though I applied according to the instructions as you stated
@excelisfun
3 жыл бұрын
The column is not wide enough ; )
@Parseval16
6 жыл бұрын
Thanks!!
@excelisfun
6 жыл бұрын
You are welcome!
@kareemkoka1747
2 жыл бұрын
can I make drop list from many of define_name range i.e fill the range by another range from drop list
@excelisfun
2 жыл бұрын
Yes. Here is one of a few videos I have made on this topic: kzitem.info/news/bejne/jm1uyHxmi4xogHY
@kareemkoka1747
2 жыл бұрын
@ExcelIsFun Thank you a lot ,I appreciate it but the sended video not the requested . if I make more thane one define-name each on refers to some of horizontal range that contains fixed number of cells had numerical values . I want to replacing all the horizontal range by another one to fill all the horizontal range cells with values by another define-name range until Ican use the new values in each range can I email you ? but your video make me go to brilliant ideas
@excelisfun
2 жыл бұрын
@@kareemkoka1747 I am not able to currently do consulting. Too much work in my real job at Highline : (
@hazemali382
5 жыл бұрын
Wow
@ashishsinha8671
2 жыл бұрын
Sir this video is no 17 or 18...which one watch first 18?
@clarklynn2313
7 жыл бұрын
Hi, looking for some help!! The question is as follows: If one cell is greater than another by a specific amount then a third cell returns a value. How do I do that? Example: Mission is 6 ( 6 goes in A5) Attained 7 ( 7 goes in B5) Because B5 is greater than A5 by 1, C5 needs to say 25 ( as if I get one over prescribed mission I receive 25 points) Any hep would be great, Thank you, Clark
@AdiCristea
7 жыл бұрын
In cell C5 type the formula =IF(B5-A5=1,25,0)
@clarklynn2313
7 жыл бұрын
Adi Cristea I must be doing something wrong that did not work!
@AdiCristea
7 жыл бұрын
Unless you have some number formatting in place, the formula definitely works. Check to see if values are actually integers (i.e. not 5.1 showing rounded to 5).
@clarklynn2313
7 жыл бұрын
Adi Cristea I really appreciate your help! Is it possible to contact you by email? I am still having a bit of trouble with this problem.
@clarklynn2313
7 жыл бұрын
Adi Cristea all it is doing is returning 0
@chuckhamdan1283
6 жыл бұрын
The link to Download Full Written Note is wrong. It is not pointing to the right address and get an error: "The page you requested is not available"
@excelisfun
6 жыл бұрын
Fixed! Thank you for helping me to edit. It is so hard to create all the content, film videos, edit videos, make the web site... - I just don't have enough time - so it really helps when you help me to edit : )
Пікірлер: 129