Added: 3 years ago
From: ExcelIsFun
Views: 343,620
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (215)

Sign In or Sign Up now to post a comment!
  • Great job - Thanks!

  • @jcs1122 , you are welcome!

  • how to down load your worksheets

  • @thebrazzers11 , this video shows how to download and search for video topics:

    youtube [dot] com/excelisfun

    this is the location of the workbook downlaods:

    people.highline [dot] edu/mgirvin

  • thansk for the help

  • @brnorwood , you are welcome!

  • nice..thanx dude

  • @agentdoobz , u r welcome!

  • love to learn more

  • @babycarterist1 , you can then move on to Excel Basics #2, Excel Basics #3, ...

  • how different is this from excel 2010? 

  • @GmonyZB , This series is for 2007. I have re-madeall these videos for 2010. You can find all the Excel Basic Videos for 2007 (#1-23) and 2010 (#20 - 40) here:

    youtube [dot] com/user/ExcelIsFun#grid/user/­3FBEE51974F03CCF

  • I have a questiong about when you customize the quick access toolbar. I have customized mine but the next day when I get into excel again I have to re-customize it again. Is there anyway to make the customized quick acces toolbar stay the same each day.

  • @trucker3853 , I would ask the network administrator, becasue if it is on your own computer it should stay. If that does not work post to THE best Excel question site:

    mrexcel [dot] com/forum

  • @ExcelIsFun Thanks for your reply..It is a computer at work & I will try & find out an answer from our IT dept. Thanks for your videos. I first came across them when I was trying to figure out how to do a VLookup, it really help me complete a project I was working on. Now I going to watch a video or two a day so I can become more efficient in Excel. Thanks again for posting them.

  • Hello, I have just discovered this site. Awesome! I will be continuing the rest of your series as I am totally new to excel. I am using excel 2008 on a Mac.

    Do you think I will have a problem using your course seeing as I am using a newer version?

    thanks for this site!

  • Yes, you will have trouble. This series shows PC - Mac Excel is different.

  • @ExcelIsFun Thanks for the feedback. I will try continuing with your videos though your approach is nice and easy...and encouraging. Would you be aware of a similar website as yours for excel 2008 for a Mac?

    thanks again. take care Andy

  • I do not. But try searching google video. If you find a site, let me know!

  • thanks

  • You are welcome!

  • I can't thank you enough, im so excel illiterate thank you for giving me hope!!!!!

  • I am glad that the videos help!

  • Mate this first video is beyond AWESOME! Great Work...and gooooood Karma!

  • ~I just wanted to tell you how awesome this information was!  I got more out of your video than I could have received in in classroom. Thanks so much for your hard work......

  • You are welcome!

  • 2:35 i'm not that dumb =/

  • You are quite mean - because most of us are not as smart as you.

  • What is next I should learn after Excel Basic?

  • Highline Excel Class series

  • Hi there, is there a way to plot a graph and then move the points of the graph to update the spreadsheet?

  • In Excel 2010 it no longer works, but in Excel 2003, if you had a column chart you could click on the top of the column and drag it up and it would change the number in the cell. That is all I know. You might try THE best Excel question site:

    mrexcel[dot]com/forum

  • i dont even know how to do anything in this

  • How do I sort all these videos in numerical order??- This is an issue since I want to see lesson 1 (one) through ### ?

  • Go to this video and watch:

    youtube[dot]com/user/excelisfu­n

    This video shows how to find the playlists that have the videos in sorted order.

  • Just excellent! thanks

  • You are welcome!

  • this is awesome

  • I am glad that you like it!

  • can some one tell me how to change the topic of column A,B or C to something else?????

  • Options, Formula tab, you can change to to 1, 2, 3

  • You are just Outstanding!!, I learned so much from you. You're teaching method is just superb!!!

    Thank you so much!!!

    Vicky Daley

  • You are welcome!

  • Is there anyway that I can download these videos (Excel Basics series and other series) so I can practice along with your worksheets? couldn't find them on the other suggested website. I only found excel worksheets. Thank you very much for all your great work!

  • I do not know how, but try a Google search - that will help.

  • Thank you very much for your videos onl!!! You helped me tremendously with your generous tutorials on Excel!!! Being a Youtube junkie for four years now, I never thought I would find Youtube to be educational as well. Your tutorials have helped to simplify Excel substantially for me! Today was my first day using Excel, and I had been hesistant to begin until your videos enabled me to learn using it in a way that I could easily understand! Suddenly, everything just "clicked!" Thank You again!

  • You are welcome!

  • Thank you so much for all your work...

  • You are welcome!

  • i am avery beginner,, can u plz tell y when i put like 1-3 in a cell and enter it shows as a date 1 march??how can i change this to normal numbers????????????

  • type a lead apostophe like:

    '1-3

  • Hi Mike,

    Today I rec'd word on the release date of your book, from Amazon. I know it will be worth the wait. Looking forward to see if it might be suitable as a text book for my Parks & Rec Excel course that I teach. We love your videos and your lighthearted teaching style. Thanks for making this so much fun to learn.

  • I am not sure that the date is correct. The publishing process is in big delay. But when it does come out, it will be good for teaching becasue it will have videos and more...

  • You're a savior!

  • we're learning excel in comp class too, thanks for the vids

  • You are welcome!

  • I just started learning about Microsoft Excel today in computer class.

  • Hi, I have a basic question. I am trying to comapre two columns of numbers to see if they are equal or less than or greater than. Is there a formula that does it?

  • Search for:

    IF function

    Then watch the videso on the IF function.

  • I have followed this series to number 8 now. I have also downloaded the sheets and books from the website.

    I must bow down and say Im totally in awe, that some wants to spend their time to help newbies like me.

    Im forever gratefull. Now Im beginnig to know what to do with Excel.

    I got 2003 and its in Danish so something is a little hard to figure out, but thats only a + bonus in learning imo.

  • I am glad that they help! That is why I put them out there!

  • Thanks :D. I like your voice you sound like a cool fun person ^.^

  • You are welcome!

  • Thank you so much for these tutorials, I was about endure caughing up $780 plus waste months of my life at a community collge taking the prereq's just for this one topic! Thanks pal your a life saver.

  • I am glad that they help!

  • Mr. Girvin, my name is Richard aka "Richuack" from Puerto Rico. I just took a look at your library of Excel videos and I'm amazed at all the content you are sharing at no cost to whoever is interested in learning and pay attention. (read the next comment)

  • In my case, with many jobs opportunities missed because of my lack of strong Excel skills, I wonder if I just stumbled upon the right place, the place to learn, sharpen my excel skills and develop strong Excel proficiency and advance skills for data analysis and financial modeling. (read the next comment)

  • This what I'm going to do, I'm going to go thru all of your videos (chapters) one by one, patiently and I will see and attest on how proficient or advanced my excel skills become, provided that I'm going to put the necessary time and effort on this endeavor. (read the next comment)

  • The best thing to do is to search for "excelisfun", then click on the Channel link, then watch the video that automatically plays. This video will show you how best to use the excelsifun channel to learn Excel. For example, the video will point out which videos to watch and in which order.

  • Comment removed

  • I will comment on each video to chart my progress. Mark my words, when I'm done, and the intended goal is achieved (I feel I do have superior and advance excel skills), I'm going to write you a check for you to continue to fund this noble effort of bringing this knowledge for free to those who are interested or need it such as me. Regards, Richuack !!!

  • I am glad that the videos will help!

  • Wicket awsome super helpful video's, and a very friendly helpful dude!

  • I am glad that they helped!!

  • man these videos are really helpful. but i need to make lists for people affected by the floods in pakistan. as i dont know how to use excel i am having problems in making lists for people.

    i need to make lists that mention the name of the village, the number of people living in that village, the sirname of a family, the name of the person that heads the family and the number of family members.

    sir could plese help me out by advising me of what should i be doing regarding this matter.

  • Try this site for posting Excel questions:

    mrexcel[dot]com/forum

    This is THE best place to get help with Excel.

  • would excel be a proper place to make these lists? or is there another software which isnt that complicated and difficult ? as i also need to make printouts for those lists afterwards as that data would be really helpful in relief work.

  • Hello guy in charge of these videos. IMy friend and I just wanted to say THANK YOU!!! We were taking the tests for the Microsoft Office Specialist (MOS) and I needed Excel to be considered MOS Masters, thanks to all of your 23 videos and the ebook on your website, we became one!! They really helped sharpen our skills, your videos are very well explained...props to you GOD BLESS YOU!!!

  • You are welcome - I am glad that they helped!

  • Hello guy in charge of these videos. IMy friend and I just wanted to say THANK YOU!!! We were taking the tests for the Microsoft Office Specialist (MOS) and I needed Excel to be considered MOS Masters, thanks to all of your 23 videos and the ebook on your website, we became one!! They really helped sharpen our skills, your videos are very well explained...props to you GOD BLESS YOU!!!

  • I am glad that they helped!!!

  • thank you

  • You are welcome!

  • These videos are very good and one more thing is there any way to down load these videos.

    If any one of you guys knows please do not hesitate to tell me.

  • I would like to personally thank you so much on posting these training sessions. I'm currently taking all your lessons as I want to brush up on my excel skills. Again, i'm one of your biggest fans!

  • You are welcome!

  • :-D.. . .

  • Rad!

  • thank you very much.. you are helping me a lot.. :)

  • You are welcome!

  • Hi, pls explain how to download your videos...

  • Search for and watch this video title:

    excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

  • its a excellent video and i know a lot from dis. Now i need is tutorial for MCSE plz.................

  • I am glad that the videos helps! Sorry, but I do not have a video for MCSE.

  • ¿ when you say '' control'' what do you actually mean? I have lived abroad many yrs n have learnt every thing i know in spanish,

  • I mean the "Ctrl" key.

  • this is so cool & ur an excellent communicator, only got excel yesterday so i know nuttin yet,but i feel really confident im gonna find that new job im lookin 4 and all with ur help thank you so much

  • You are welcome!

    If you download the workbooks, it will be even better!

  • You are excellent. I have big excel books but got nowhere until I watched your vid, now charts, pivot tables and vlookups are everywhere. Thanks

  • You are welcome!

  • you are great buddy this is exceptional service, keep it up, and god bless

  • I am glad that it is helpful!

  • ok how do I download this???

  • Search for and watch this video title:

    excelisfun Search for Excel Videos, Playlists & Download Workbooks

  • I love how your videos start with the most basic functions, and then progress to intermediate and advanced at an acceptable rate. I was talking to someone who does data analysis work, and I want to get into that field. She told me that the best thing I can do for myself right now is to learn as much as I can about Excel. I already watched all the basics, now I'm preparing myself for the intermediate level. These videos are absolute gold!

  • I hope the gold can get you into your desired field!!

  • @ExcelIsFun

    Thanks, me too! The one thing that bugs me is that I have a Mac, so I have to learn completely different keyboard shortcuts.  Why did they have to make the Mac and PC versions so different?

  • The only reason is that there is HATE in the world.

    Since I grew up a MAC user and was forced to switch because I existed in the busienss world, I can only think that it was not a good thought that made them differenet.

  • This is service to humanity... Keep up the good work man!

  • I am glad that the videos are helpful!

  • I gta learn this is a week for a gcse hahaa. Really good, thanks.

  • You are welcome!

  • You remind me of Michael in The Office. Very enthusiastic and talented. =]

  • Cool! I hope the videos help!

  • Your video clips are very clear and useful!!!

    I started to watch your clips as part of my self-development routine!

    Thank you for the clips. I have learned so much from this basic video!

  • I am glad that they help!

  • Comment removed

  • Powiesz mi jaki jest kod na obliczenie średniej??

  • EXCELlent!!!

  • very good! i know a lot more!

  • I am glad that it helped!

  • can you tell me how to put the picture begind the text??? thank you :D

  • Search for and wacth this video title:

    WIIW: Printable Background - 1023 - Learn Excel from MrExcel

  • hey, i love your tutorials. I have to do an assignment for my course, and I was wondering if you would be keen to have a look at what I have done so far. I am missing vlookups, but I dont know how to use them in my example.

  • No - I just make the videos for fun and I do not do consulting work.

  • Thanks for this lesson! It was very educational. I have a test tomorrow for a job on Excel proficiency.... this helped alot!!!!

  • I am gld that they help.

  • Thanks for this lesson! It was very educational. I have a test tomorrow for a job on Excel proficiency.... this helped alot!!!!

  • أقول بس ياليتك ترجمته : )

  • can you tell me how you made trhis video i am trying to make one to teach people powerpoint how do i get screenshots of the computer...

  • The program is:

    Camtasia

  • i am trying to create a schedule with 15 minute intervals over five days. what would be the easiest way to put the those intervals on a spread sheet?

  • Type 8:00 AM into cell A1

    Type 8:15 AM into cell A2

    Highlight A1:A2 and with the fill handle (tiny black boz in lower right corner) and your cross hair cursor click and drag to right as far as you need.

    I'll make a video later in the week for you.

  • I just found your lessons...I love it!!! many people say that they know Excel but few actually really knows it. Thanks you for the videos.

  • You are welcome!

  • avayanse a la mierda

  • how to convert formula in to value without (paste special) which formula have different row and column please guide me?

  • I do not understand your question. Can you re-state your question?

  • Just wanted to thanked you again, your videos helped me pass a graduate class I'm taking. I honestly kew nothing about Excel and I got all the info I needed from your videos. I also downoaded the workbook and the book.

    Your efforts will not go unnoticed, I'd say.

    Cheers!

  • Congratulations on passing the graduate class! Knowing Excel will pay great dividends!

  • Thanks for uploading these type of videos man, keep 'em coming.

    Take care.

  • You are welcome!

  • cheers for this gonna use this as revision for me ict test

  • EXCELlent!!!!

  • Hey i was told that my Job interview would have an "Excel Test" I was so worried!. I watched 1-6 of your videos and it seriously helped me do well on it. I got an e-mail today I GOT THE JOB!!!!!!!!!!!!! I love you, you are god.

  • I am totally happy that the videos helped you get the job! That is why I post the videos!

    Excel is fun and it gets you the job!

  • Not a god - just a guy having fun with Excel!

  • i was just looking a simple lessons on excel and boy what a insight. i appreciate your videos. they really helped me in improving my excel knowledge. the Magic Tricks are amazing. Did you also make other basics like Word Basics, Access Basics... If not please guide me as to where i can find usefull videos like yours.

    Thank you Mr Excelsfun. Really you made Excel be fun.

  • I have none posted on Word and Access! Sorry.

    --excelisfun (not Mr Excel)

  • OMG I can record a macro, work with an income statement, protect worksheets, use all formulas, convert worksheets to web pages, and more! But I can not shift cells up? l0l teach me please

  • What does the data look like in the sheet that you want to shift cells up? What is the setup and situation?

  • The link given at the end of the video will bring you nowhere :(

  • Try:

    excelisfun

    instead of:

    ExcelIsFun

    I will add a annotation so that others will see what you discovered!

    Thanks!

  • how i down load this ,,

  • Search for and watch this video title:

    Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

  • Great! Many thanks!

  • thanx you, you'are awsome!!!

  • You are welcome!

  • You are an outstanding speaker. Clear, articulate and you proceed at a speed that holds my attention but doesn't necessitate my rewinding the video. :)

  • Thanks! i am glad that the videso are helpful. There are 22 more in this series if you like learning Excel!

  • thanks, this was what I was looking for, the forumla

  • Keep watching the series for more about how to make formulas.

  • Hey ExcellsFun,

    Do you give advise on projects? I have a project I'm working on but I'm stuck how to go about solving it. If you do give advice, can I get your email address?

  • I do not do consulting.

    THE best place in the world to get free Excl advice is the Mr Excel Message Board (THE smartest Excelers in the world hang out at this site). If you ask your question so that others can understand, you will get an amazing solution for any question that you ask. Here is a video I made about this site (search for this video title and watch it):

    How To Post Questions At The Mr Excel Message Board

  • excellent

  • Thanks! But did you mean:

    EXCELlent!!

  • thank you for taking the time to make this tutorials, i am an excel beginner(for now), but i am looking forward to finishing the first 23 tutorials and then see:))))))

    again thank you very much:)

  • You are welcome!

  • GR8 work and thanks a lott

  • You are welcome a lot!!!!

  • How long will it take me to learn how to work in Excel? Never used it before and the works I have seen seem complicated =\

  • It is like anything else, if you want to know it well, it takes study and practice. If you watch this Basics Series (23 videos) and download the workbooks that go along, you could get through them in a day. But until you take the new knowledge and apply it to solve some of your own problem over a time period, you will not know it.

    If you are trying to get a job that requires it, it is a great investment to learn Excel.

  • You are right, I got a job at a nursery and the job description includes being able to use Excel so I was wondering what formulas etc I need to know.. I will take them slowly, have around 10 days to go..

  • Many people have used this video series (and the Highline Excel Basic series for advanced Excel) to get past there job interviews. First you should search for and watch this video to see how to find all the right videos and downloads quickly:

    Search For Excel Videos Download Excel Files excelisfun

  • Brilliant, fantastic and awesome I just can't thank you enough.

    Thank you, thank you, thank you....thank you......

  • You are welcome! There are many more to watch too!

  • OMG u r awesome. THANKS a million

  • Not so much awesome, just a guy having fun with Excel!

    You are welcome a million!