Excel for Intermediate Users - The Complete Course

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

[@cynthiaamara8760]

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

[@mickb5854]

Got an excel interview tomorrow let’s gooooo

[@victoriagboro8446]

I'm here😂😂

[@ouafaezellat5596]

Same 😂

[@clcamila]

Yuuuup 😂😂😂😂😂

[@GothamsAssassin]

I was and I got the job!

[@eugeniamaurajames1907]

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

[@humingbird2187]

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

[@michaelvaudin9108]

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.

[@vickishaff5433]

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

[@user-zy6ih3sg9w]

Two Amazing Tutorials. Thanks alot.

[@kimjohnson3193]

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

[@nataliameyer4947]

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

[@cheesedaddy4207]

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

[@jesse9543]

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

[@Thegirlwithevilface2004]

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

[@dineshnagwekar3173]

Excellent video! Great learning!

[@macegroup-automaticdoors-ksa]

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

[@chendayom4107]

I really appreciate your thoroughly amazing tutorial.

[@user-zt7nv4fh1f]

Very informative and helpful, thank you !

[@ak-ux8pr]

Great teacher I salute him

[@yanlinglei2503]

Thanks a lot, very helpful!

[@luisfernandoaguilar3388]

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

[@tyssys9559]

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

[@lorimodico7960]

Excellent! Thank you.

[@user-bo2je7no3u]

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

[@kiddindomitable]

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

[@user-wy2kj5vb3j]

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

[@HINDOOSTANI]

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

[@MarcosVinicius-zc2cm]

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!

[@cinkoking]

You are good in describe how to use each MS

[@mochehrzad9077]

This video was excellent. Thanks for your time.

[@user-uy1tb9sh4q]

PERFECT LESSON

[@Metal_seer]

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.)

[@techteachersandstudents]

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

[@LiamGardner-kl9dx]

Absolute legend!!! Thank you

[@lorimodico7960]

Excellent! Thank you

[@RVandergeld]

Thank you so much for this valuable lesson. Subscribed!

[@ankash123]

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

[@funlife7863]

THANK YOU SO MUCH FOR HELPINNG ME TO GET SUCCEED IN

[@Cris-hk4cn]

This was a very hepful presentation. Thanks so much

[@lainabeads]

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

[@techteachersandstudents]

Glad it was helpful!

[@Luciano_mp]

Thank you very much!

[@RamiHammoud-qy2kz]

Thank You , that was realy helpful

[@jesse9543]

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

[@sharminakhan4130]

Thank you very much its very helpful.

[@Stitchlady56]

Excellentvideo! Thank you!

[@singh28057]

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

[@techteachersandstudents]

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

[@user-um4tj7ll9j]

Thank you ❤

[@UgandaAtHeart256]

I cannot regret why I followed you

[@azamshah1112]

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?

[@thembadlamini3461]

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

[@user-ch4nk2kw7i]

Wonderful job ✅

[@gulmirayeltayeva2512]

Thanks a lot!

[@sharondavis3535]

A great teacher 🍎

[@boramalivecable]

thank you bro

[@axelladjouzi958]

thanks

[@isaacadelugba7444]

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

[@trstreet61]

Thanks!

[@techteachersandstudents]

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

[@wambuinderitu2461]

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

[@kerrygreaves8625]

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

[@techteachersandstudents]

Here's the link for the PowerPoint course: kzbin.info/www/bejne/gaLKqql9ra6Grs0 And the link for the Word course: kzbin.info/www/bejne/aH6mnqGoZ7FoZtE

[@techteachersandstudents]

Here's the PowerPoint course: kzbin.info/www/bejne/gaLKqql9ra6Grs0

[@techteachersandstudents]

Here's the Microsoft Word complete course: kzbin.info/www/bejne/aH6mnqGoZ7FoZtE

[@tinaw6881]

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.

[@ChinweOge]

💕 from here

[@annalisamongio4208]

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.

[@techteachersandstudents]

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.

[@annalisamongio4208]

@@techteachersandstudents Brilliant, thank you very much

[@RUAGoodNurse]

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.

[@annemariejonker7982]

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?

[@KELVINSTEPHEN-oo4lq]

okey we will help please wait.

[@foibealbin961]

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

[@alejandrareyna3364]

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.

[@munibeats4493]

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

[@harishakumarmb6813]

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 🥰

[@_op_ryder]

did u get the answer?

[@xianxiong3440]

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

[@jarretcoyle7869]

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

[@user-yf8fb5ft6r]

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

[@kerrygreaves8625]

Thanks

[@techteachersandstudents]

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

[@techteachersandstudents]

Thanks so much for your kind donation.

[@user-uu6jt2mm3b]

👍👍👍

[@naturalenglish330]

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

[@sonicboombeatbox5715]

🔥🔥🔥

[@ismailfaruk6676]

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

[@rickbhattacharya2334]

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

[@ranaefox]

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... 😉

[@footfiles]

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.

[@nanadokuaobuobi9823]

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?

[@naziaashraf8287]

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

[@Dorcasenehoshaba]

Okk

[@iamnusrat2]

can't open the given practice file

[@trevajones8283]

Please do smart sheet

[@nikto618]

i want to study advanced Excel also

[@halfazmi]

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

[@naziaashraf3876]

Did you find the solution??

[@axelladjouzi958]

add ', i mean '= instead of =

[@yoanavega560]

@@axelladjouzi958i tried that still shows up only Monday

[@BanAvtai]

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?

[@techteachersandstudents]

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?

[@Mga-quotes]

😍😍

[@chikaodiliubabunike3048]

He heheh

[@browncm3507]

Intermediate course. "this is how you zoom" 😴

[@liyaliu7710]

u bad