KZhead
Тәжірибелік нұсқаулар және стиль

Excel for Intermediate Users - The Complete Course

Technology for Teachers and Students
2024 ж. 21 Мам.
250 715 Рет қаралды
Жүктеу

Are you ready to go beyond the Excel basics that you already know? This video is for you! You learn how to manage a large spreadsheet, how to work with multiple worksheets, how to work with data (including grouping and importing data, and more), advanced chart skills, how to work with data lists, how to document and audit a spreadsheet, and advanced printing options. This sequel to the best, most comprehensive Excel for Beginners course will help you take your Excel learning to the next level!
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: bit.ly/excelforintermediate #excel #exceltutorials #microsoft365 #microsoftexcel
Table of Contents:
00:00 - Intro
00:33 - MANAGING A LARGE SPREADSHEET
01:06 - Zoom Options
04:07 - Using Split
08:57 - Freeze Panes
11:50 - Adding, Reordering, and Naming Worksheet
14:36 - Naming Cells, Formulas, and Constants
19:31 - How to Quickly Enter Date and Time
20:40 - WORKING WITH MULTIPLE WORKSHEETS
21:23 - Editing the Same Cell in Multiple Sheets
23:26 - Opening Multiple Excel Windows
25:29 - Moving or Copying a Worksheet
27:54 - Linking Two Workbooks
30:59 - Creating a Summary Worksheet
33:22 - WORKING WITH DATA
33:38 - Grouping Data
37:24 - Importing Data into Excel
39:48 - Hyperlinking to Another File
41:44 - ADVANCED CHART SKILLS
41:59 - Creating a New Chart
45:32 - Customizing a Chart
47:36 - Adding or Editing Chart Titles
50:49 - Adding Graphics and Textboxes to Charts
54:16 - Adding WordArt to a Sheet
54:47 - Adding SmartArt Objects
56:33 - WORKING WITH DATA LISTS
57:20 - Using Data Forms to Add and Edit Records
01:03:47 - Sorting Data
01:07:30 - Filtering Data
01:10:24 - Creating a Custom Filter
01:12:29 - DOCUMENTING AND AUDITING A WORKSHEET
01:13:07 - Adding Comments and Notes
01:16:44 - Setting Up a Watch Window
01:20:27 - Other Auditing Features
01:22:21 - Error Checking
01:23:35 - ADDITIONAL PRINTING OPTIONS
01:24:13 - Changing Margins and Orientation
01:26:12 - Page Breaks and Page Break Preview
01:27:25 - Print Formulas

Пікірлер

  • Gather here if you are watching this video for an interview 😂

    @cynthiaamara8760@cynthiaamara87607 ай бұрын

    • Got an excel interview tomorrow let’s gooooo

      @mickb5854@mickb58547 ай бұрын

    • I'm here😂😂

      @victoriagboro8446@victoriagboro84466 ай бұрын

    • Same 😂

      @ouafaezellat5596@ouafaezellat55965 ай бұрын

    • Yuuuup 😂😂😂😂😂

      @clcamila@clcamila4 ай бұрын

    • I was and I got the job!

      @GothamsAssassin@GothamsAssassin4 ай бұрын

  • You are doing a great service. No joke, thanks for helping so many people.

    @eugeniamaurajames1907@eugeniamaurajames19073 ай бұрын

  • I literally just finished watching the full beginner course yesterday and now you drop this banger, I’m ready! And thank you, really helpful

    @cheesedaddy4207@cheesedaddy42078 ай бұрын

    • I did the first course also, I know people who paid for this knowledge. I'm so happy they are doing this for free.

      @jesse9543@jesse95432 ай бұрын

  • I can't thank you enough for creating these videos and your precise, clear step-by-step instructions. You do a great service!

    @vickishaff5433@vickishaff5433Ай бұрын

  • Thank you very much today I started watching Excel for Beginners. It's made me understand the basics of excel. I intend doing all the courses offered.

    @michaelvaudin9108@michaelvaudin91086 ай бұрын

  • I am brushing my excel for a new job, and thank you! Everything is coming back.

    @humingbird2187@humingbird21877 ай бұрын

  • something u made in 2022 is helping me in 2024, thanks alot and gbu, love from india

    @tyssys9559@tyssys955922 күн бұрын

  • I currently have a Business Analytics course and I'm so grateful for this. This makes my life easier

    @Thegirlwithevilface2004@Thegirlwithevilface2004Ай бұрын

  • I was a decent Excel user 25 years ago, but haven't used it since, and I'm 78 now. Guess I'll learn how much its changed as I refresh my skills. I use mostly my snartphone and tablet these days, but I'm dragging out my laptop for this, as I'm finding using Excel on a phone or tablet is challenging. Thanks for your clear and pleasant teaching style. (Incidentally, I used Visicalc, the grandaddy of spreadsheet software, in the 70s. Wonder what happened to it.)

    @Metal_seer@Metal_seer2 ай бұрын

    • Thanks so much for your kind words and gift. I really appreciate it! And Visicalc, wow!

      @techteachersandstudents@techteachersandstudents2 ай бұрын

    • @@techteachersandstudents Thanks Man! Have no clue how to reach out to you. But wanted to say your videos on Excel are amazing. There are many courses online, but your course really teaches us like kids. I didn't expect the course to be excellent. I liked the way you teach. Wish my teachers in computer classes were even half as good as you. I wouldn't need to be here. Thanks.

      @coolguy298@coolguy2982 күн бұрын

  • Two Amazing Tutorials. Thanks alot.

    @user-zy6ih3sg9w@user-zy6ih3sg9w8 ай бұрын

  • Fantastic lessons, I have never and ever seen such as you like your teaching from any KZhead channel Thanks very much.

    @macegroup-automaticdoors-ksa@macegroup-automaticdoors-ksa4 ай бұрын

  • This tutorial was even more amazing that the one for beginers . I am amazed !!!!!!!

    @nataliameyer4947@nataliameyer49476 ай бұрын

  • This one is a MUST SAVE for me. Thanks! 🙂

    @kimjohnson3193@kimjohnson31938 ай бұрын

  • I really appreciate your thoroughly amazing tutorial.

    @chendayom4107@chendayom41076 ай бұрын

  • Excellent video! Great learning!

    @dineshnagwekar3173@dineshnagwekar31738 ай бұрын

  • Linking two workbooks is crazy. Amazed by that feature alone.

    @kiddindomitable@kiddindomitable16 күн бұрын

  • Very informative and helpful, thank you !

    @user-zt7nv4fh1f@user-zt7nv4fh1f5 ай бұрын

  • Great teacher I salute him

    @ak-ux8pr@ak-ux8pr6 ай бұрын

  • Excellent! Thank you.

    @lorimodico7960@lorimodico79607 ай бұрын

  • I really appreciate the way you taught. Very nice... Thank you.

    @HINDOOSTANI@HINDOOSTANI20 күн бұрын

  • Great Video! Now Im looking forward for an advanced tutorial. 😊

    @luisfernandoaguilar3388@luisfernandoaguilar33884 ай бұрын

  • Thanks a lot, very helpful!

    @yanlinglei2503@yanlinglei25036 ай бұрын

  • Thank you very much for uploading this marvelous video. I am currently working for an international company, and your classes have been so useful for me. Once more, thank you very much. God bless you!

    @MarcosVinicius-zc2cm@MarcosVinicius-zc2cm6 ай бұрын

    • You are good in describe how to use each MS

      @cinkoking@cinkoking3 ай бұрын

  • PERFECT LESSON

    @user-uy1tb9sh4q@user-uy1tb9sh4q6 ай бұрын

  • Excellent! Thank you

    @lorimodico7960@lorimodico79607 ай бұрын

  • I was really helpful and I am waiting to watch the advance course

    @user-bo2je7no3u@user-bo2je7no3u7 ай бұрын

  • This video was excellent. Thanks for your time.

    @mochehrzad9077@mochehrzad9077Ай бұрын

  • Thank you so much 😊😊😊😊😊😊 awaiting for the advance excel complete course. ❤ You're such a great help😊

    @user-wy2kj5vb3j@user-wy2kj5vb3jАй бұрын

  • The MWF constant naming isn’t working for me. It’s only writing out Monday. Do you know why? Thanks. And thank you for these videos. Very helpful.

    @tinaw6881@tinaw6881Ай бұрын

  • Thank you so much for this valuable lesson. Subscribed!

    @RVandergeld@RVandergeld3 ай бұрын

  • Very useful videos, it changed the way I use Excel. Thanks a lot

    @ankash123@ankash12315 күн бұрын

  • Great work done. Very elaborately explained yet being concise. A must watch for people wanting to seriously learn MS Excel.

    @singh28057@singh2805727 күн бұрын

    • Thank you for your kind words. Please share the video with others you think might benefit from it.

      @techteachersandstudents@techteachersandstudents27 күн бұрын

  • Excellentvideo! Thank you!

    @Stitchlady56@Stitchlady566 күн бұрын

  • Thankyou very much for these two videos, the beginner level and the intermediate level ones. Though i am looking for the advanced level video but cant seem to find it, its probably not made yet, if so, when is it expected to come out?

    @azamshah1112@azamshah11122 ай бұрын

  • This was a very hepful presentation. Thanks so much

    @Cris-hk4cn@Cris-hk4cnАй бұрын

  • You're indeed a life saver🙏🙏I can not thank you enough for this

    @lainabeads@lainabeads7 ай бұрын

    • Glad it was helpful!

      @techteachersandstudents@techteachersandstudents7 ай бұрын

  • This is great! Thanks a ton.

    @deepzs3271@deepzs327123 сағат бұрын

  • Thank you very much!

    @Luciano_mp@Luciano_mp8 ай бұрын

  • Thank you very much and you don't leave any stone unturned when you explain👌 and when are posting Advanced Excel?

    @thembadlamini3461@thembadlamini346126 күн бұрын

  • THANK YOU SO MUCH FOR HELPINNG ME TO GET SUCCEED IN

    @funlife7863@funlife786329 күн бұрын

  • Absolute legend!!! Thank you

    @LiamGardner-kl9dx@LiamGardner-kl9dxАй бұрын

  • Very much appreciate these videos. It's how I'm learning for free.

    @jesse9543@jesse95432 ай бұрын

  • Thank You , that was realy helpful

    @RamiHammoud-qy2kz@RamiHammoud-qy2kz14 күн бұрын

  • Wonderful job ✅

    @user-ch4nk2kw7i@user-ch4nk2kw7i22 күн бұрын

  • Thank you very much its very helpful.

    @sharminakhan4130@sharminakhan413028 күн бұрын

  • I cannot regret why I followed you

    @UgandaAtHeart256@UgandaAtHeart2567 ай бұрын

  • Thank you ❤

    @user-um4tj7ll9j@user-um4tj7ll9j5 ай бұрын

  • Thanks a lot!

    @gulmirayeltayeva2512@gulmirayeltayeva25122 ай бұрын

  • thank you bro

    @boramalivecable@boramalivecable2 ай бұрын

  • A great teacher 🍎

    @sharondavis3535@sharondavis3535Ай бұрын

  • Many thanks for sharing your knowledge. But the constant MWF only show "Monday".

    @naturalenglish330@naturalenglish3302 ай бұрын

  • Thanks!

    @trstreet61@trstreet618 ай бұрын

    • Thank you for your kind gift. I really appreciate it!

      @techteachersandstudents@techteachersandstudents8 ай бұрын

  • If you want job interview and watching , watch it over and over again.

    @isaacadelugba7444@isaacadelugba74442 ай бұрын

  • thanks

    @axelladjouzi958@axelladjouzi9584 ай бұрын

  • Please Please do a video explaining the following and I hope you will understand what I am asking: I downloaded from the internet a free budget spreadsheet. However, I noticed something so very interesting. Though when looking at the spreadsheet it looked like one single sheet it turned out that when I looked at the "name" section the spreadsheet was actually made up of multiple tables and on top of that some formulas created used the @ sign. I am going to try to paste an image here. I am hoping so much you can do a tutorial on how to make a budget spreadsheet out of individual tables and connect them for calculations I can't upload an image to explain it as I just tried to paste in here but can't. I hope to hear from you.

    @RUAGoodNurse@RUAGoodNurse3 ай бұрын

  • Do you have Excel advanced full course video ? If yes link it in here please 🙏

    @user-yf8fb5ft6r@user-yf8fb5ft6r3 ай бұрын

  • Thanks

    @kerrygreaves8625@kerrygreaves86255 ай бұрын

    • You're very welcome. Thanks so much for your kind gift, and for being a channel member!

      @techteachersandstudents@techteachersandstudents5 ай бұрын

    • Thanks so much for your kind donation.

      @techteachersandstudents@techteachersandstudents5 ай бұрын

  • Thanks soo much for this 😢❤i really knew nothing about computers ,now am a G 😂

    @wambuinderitu2461@wambuinderitu24616 ай бұрын

  • About to start a new job I haven't used Excel much at all this is very helpful I don't seem to be able to get full screen so a bit hard to see it all on my tablet. Also how do I access the word and PowerPoint courses please ? You explain everything ery well. I would like to watch these a few times and do some practice. Thankyou

    @kerrygreaves8625@kerrygreaves86255 ай бұрын

    • Here's the link for the PowerPoint course: kzhead.info/sun/ftWgqdp_r3uJq6M/bejne.html And the link for the Word course: kzhead.info/sun/ZbF8ndKqaX5rY6c/bejne.html

      @techteachersandstudents@techteachersandstudents5 ай бұрын

    • Here's the PowerPoint course: kzhead.info/sun/ftWgqdp_r3uJq6M/bejne.html

      @techteachersandstudents@techteachersandstudents5 ай бұрын

    • Here's the Microsoft Word complete course: kzhead.info/sun/ZbF8ndKqaX5rY6c/bejne.html

      @techteachersandstudents@techteachersandstudents5 ай бұрын

  • I don't know if this is only me. Everytime I put ( Monday, Wednesday, Friday) for mwf and click enter, only Monday appears. Am I doing sth wrong?

    @nanadokuaobuobi9823@nanadokuaobuobi98233 ай бұрын

  • This coach he make me help because he tech me more think I don't

    @foibealbin961@foibealbin9618 ай бұрын

  • Hi! Thank you for your video's. They are very helpful. I would like to create simple templates in Excel en sell them as templates on a website or Etsy for my customers. Can you explain how you can publish / share a template so that it can be used over and over again by multiple people? Or do you have a video about that?

    @annemariejonker7982@annemariejonker7982Ай бұрын

    • okey we will help please wait.

      @KELVINSTEPHEN-oo4lq@KELVINSTEPHEN-oo4lqАй бұрын

  • I found these video so entertaining and educational. Thank you so much, you have made my life so much easier. I have a couple of questions if I may. When I type a number and I want to drag that number all the way down to repet in the tabs below, the number changes in the succession.For example: if I want to type the same number ie. 5 in the 4 tabs below, it shows as 6;7;8 etc. How do I make it stay at 5? I am not sure if I haven't been clear.

    @annalisamongio4208@annalisamongio4208Ай бұрын

    • Thanks for your kind words. What you could do I type 5 in one cell and 5 in the cell immediately below it. Then click and drag to select both cells that have a 5 in them. Then click on the little fill handle in the lower right corner of the selected area and drag down.

      @techteachersandstudents@techteachersandstudentsАй бұрын

    • @@techteachersandstudents Brilliant, thank you very much

      @annalisamongio4208@annalisamongio4208Ай бұрын

  • Can please give us tutorial on formatting election results using excel? Thanks

    @ismailfaruk6676@ismailfaruk6676Ай бұрын

  • 💕 from here

    @ChinweOge@ChinweOge8 ай бұрын

  • How can I activate quickinfos on the menu bar on the MacBook version of excel? When I hover over a feature nothing is shown. 😭

    @munibeats4493@munibeats449310 күн бұрын

  • I downloaded Microsoft for MAC and I'm practicing using your Excel but I'm not being able to find the "form" to add to the quick access toolbar, any solution? thanks in advance.

    @alejandrareyna3364@alejandrareyna3364Ай бұрын

  • Are the functions of Excel fairly similar to those of Google Sheets? That's to say, are the skills transferrable?

    @jarretcoyle7869@jarretcoyle7869Ай бұрын

  • FYI, the part about adding comments. In the video he shows the "Comments" section on the ribbon under the "Insert" menu. Mine was not there, it was under the "Review" menu.

    @footfiles@footfilesАй бұрын

  • Excellent video but I would like to make a request/suggestion. When I started watching, I stopped almost immediately because I didn't watch the beginner's course and don't have the file you will be working on in this video. My suggestion is to upload the file from the beginner's course to your website and link to it in the description. Since it's not for school or graded, I don't see any problem with that. If people copy it for the beginner's video, that's their loss because most people know that practice is what makes a person "excel" at what they are learning... 😉

    @ranaefox@ranaefox5 ай бұрын

  • Got an interview on 16th so I am watching it now 😂

    @rickbhattacharya2334@rickbhattacharya23348 күн бұрын

  • Thank you so much for made this video sir 😍 Sir I have one question I don't know how to calculate the date after 75 days I mean 6/6/23 after 75 days which date will it be I don't know hot do it please tell if possible Thanks sir 🥰

    @harishakumarmb6813@harishakumarmb68138 ай бұрын

    • did u get the answer?

      @_op_ryder@_op_ryder6 ай бұрын

    • If I am correct and there is no other criteria, just use formula = cell+75 , where the cell contain 6/6/23.

      @xianxiong3440@xianxiong34404 ай бұрын

  • The define name formula is showing the first word only, I cant find a solution

    @naziaashraf8287@naziaashraf82875 ай бұрын

  • 🔥🔥🔥

    @sonicboombeatbox5715@sonicboombeatbox57153 ай бұрын

  • Please do smart sheet

    @trevajones8283@trevajones828322 күн бұрын

  • 👍👍👍

    @user-uu6jt2mm3b@user-uu6jt2mm3b8 ай бұрын

  • Changing multiple sheets doesn’t work for me. I get "Cannot make changes to a table or XML mapping when multiple sheets are selected.” What am I doing wrong?

    @BanAvtai@BanAvtai6 күн бұрын

    • I don't know for sure. Could you please reply to my comment with the relevant time stamp from my video that talks about this?

      @techteachersandstudents@techteachersandstudents5 күн бұрын

  • can't open the given practice file

    @iamnusrat2@iamnusrat2Ай бұрын

  • i want to study advanced Excel also

    @nikto618@nikto6184 ай бұрын

  • The ={"Monday","Wednesday","Friday"} is not working. Why? Excel keeps telling me it is broken and I need to put an apostrophe (') before the equal (=). But the result is absolutely different

    @halfazmi@halfazmi6 ай бұрын

    • Did you find the solution??

      @naziaashraf3876@naziaashraf38765 ай бұрын

    • add ', i mean '= instead of =

      @axelladjouzi958@axelladjouzi9584 ай бұрын

    • @@axelladjouzi958i tried that still shows up only Monday

      @yoanavega560@yoanavega560Ай бұрын

  • Okk

    @Dorcasenehoshaba@Dorcasenehoshaba8 ай бұрын

  • 😍😍

    @Mga-quotes@Mga-quotes6 ай бұрын

  • Too many to absorb & retain in a short session!

    @kkartha@kkartha4 күн бұрын

  • Have a test in 2hrs😅

    @VusimuziKhumalo-so3gt@VusimuziKhumalo-so3gt4 күн бұрын

  • He heheh

    @chikaodiliubabunike3048@chikaodiliubabunike30482 ай бұрын

  • Intermediate course. "this is how you zoom" 😴

    @browncm3507@browncm35077 күн бұрын

  • u bad

    @liyaliu7710@liyaliu77104 ай бұрын
KZhead