Excel for Intermediate Users - The Complete Course

Подписаться 1,5 млн

Просмотров 248 тыс.

50% 1

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

Хобби

Опубликовано:

19 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 122

@cynthiaamara8760 7 месяцев назад

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

@mickb5854 7 месяцев назад

Got an excel interview tomorrow let’s gooooo

@victoriagboro8446 6 месяцев назад

I'm here😂😂

@ouafaezellat5596 4 месяца назад

Same 😂

@clcamila 4 месяца назад

Yuuuup 😂😂😂😂😂

@GothamsAssassin 4 месяца назад

I was and I got the job!

@eugeniamaurajames1907 3 месяца назад

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

@cheesedaddy4207 8 месяцев назад

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 2 месяца назад

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

@michaelvaudin9108 6 месяцев назад

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.

@humingbird2187 7 месяцев назад

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

@vickishaff5433 Месяц назад

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

@tyssys9559 20 дней назад

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

@kimjohnson3193 8 месяцев назад

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

@user-zy6ih3sg9w 7 месяцев назад

Two Amazing Tutorials. Thanks alot.

@Thegirlwithevilface2004 Месяц назад

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

@kiddindomitable 14 дней назад

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

@macegroup-automaticdoors-ksa 4 месяца назад

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

@nataliameyer4947 5 месяцев назад

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

@Metal_seer 2 месяца назад

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 2 месяца назад

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

@coolguy298 6 часов назад

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

@MarcosVinicius-zc2cm 6 месяцев назад

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 3 месяца назад

You are good in describe how to use each MS

@user-bo2je7no3u 7 месяцев назад

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

@dineshnagwekar3173 7 месяцев назад

Excellent video! Great learning!

@chendayom4107 6 месяцев назад

I really appreciate your thoroughly amazing tutorial.

@UgandaAtHeart256 7 месяцев назад

I cannot regret why I followed you

@luisfernandoaguilar3388 4 месяца назад

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

@ak-ux8pr 6 месяцев назад

Great teacher I salute him

@HINDOOSTANI 19 дней назад

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

@user-zt7nv4fh1f 5 месяцев назад

Very informative and helpful, thank you !

@lorimodico7960 7 месяцев назад

Excellent! Thank you.

@user-wy2kj5vb3j Месяц назад

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

@yanlinglei2503 6 месяцев назад

Thanks a lot, very helpful!

@ankash123 13 дней назад

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

@mochehrzad9077 Месяц назад

This video was excellent. Thanks for your time.

@funlife7863 27 дней назад

THANK YOU SO MUCH FOR HELPINNG ME TO GET SUCCEED IN

@user-uy1tb9sh4q 6 месяцев назад

PERFECT LESSON

@singh28057 25 дней назад

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

@techteachersandstudents 25 дней назад

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

@azamshah1112 2 месяца назад

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 24 дня назад

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

@lorimodico7960 7 месяцев назад

Excellent! Thank you

@Cris-hk4cn Месяц назад

This was a very hepful presentation. Thanks so much

@lainabeads 6 месяцев назад

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

@techteachersandstudents 6 месяцев назад

Glad it was helpful!

@Luciano_mp 7 месяцев назад

Thank you very much!

@RamiHammoud-qy2kz 12 дней назад

Thank You , that was realy helpful

@LiamGardner-kl9dx Месяц назад

Absolute legend!!! Thank you

@RVandergeld 3 месяца назад

Thank you so much for this valuable lesson. Subscribed!

@Stitchlady56 5 дней назад

Excellentvideo! Thank you!

@isaacadelugba7444 2 месяца назад

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

@sharminakhan4130 26 дней назад

Thank you very much its very helpful.

@user-um4tj7ll9j 5 месяцев назад

Thank you ❤

@user-ch4nk2kw7i 20 дней назад

Wonderful job ✅

@gulmirayeltayeva2512 2 месяца назад

Thanks a lot!

@sharondavis3535 Месяц назад

A great teacher 🍎

@jesse9543 2 месяца назад

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

@boramalivecable 2 месяца назад

thank you bro

@rickbhattacharya2334 7 дней назад

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

@trstreet61 8 месяцев назад

Thanks!

@techteachersandstudents 8 месяцев назад

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

@axelladjouzi958 4 месяца назад

thanks

@wambuinderitu2461 6 месяцев назад

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

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

@kerrygreaves8625 5 месяцев назад

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 5 месяцев назад

Here's the link for the PowerPoint course: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KqgyvGxISxk.html And the link for the Word course: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2MCmnr2L50o.html

@techteachersandstudents 5 месяцев назад

Here's the PowerPoint course: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KqgyvGxISxk.html

@techteachersandstudents 5 месяцев назад

Here's the Microsoft Word complete course: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2MCmnr2L50o.html

@naturalenglish330 2 месяца назад

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

@RUAGoodNurse 3 месяца назад

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.

@foibealbin961 8 месяцев назад

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

@ChinweOge 7 месяцев назад

💕 from here

@ranaefox 5 месяцев назад

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

@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

@kerrygreaves8625 5 месяцев назад

Thanks

@techteachersandstudents 5 месяцев назад

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

@techteachersandstudents 5 месяцев назад

Thanks so much for your kind donation.

@user-yf8fb5ft6r 3 месяца назад

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

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

@ismailfaruk6676 Месяц назад

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

@harishakumarmb6813 8 месяцев назад

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 6 месяцев назад

did u get the answer?

@xianxiong3440 4 месяца назад

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?

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

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

@user-uu6jt2mm3b 8 месяцев назад

👍👍👍

@sonicboombeatbox5715 3 месяца назад

🔥🔥🔥

@munibeats4493 8 дней назад

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

@trevajones8283 21 день назад

Please do smart sheet

@nanadokuaobuobi9823 3 месяца назад

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?

@nikto618 4 месяца назад

i want to study advanced Excel also

@Dorcasenehoshaba 8 месяцев назад

Okk

@naziaashraf8287 5 месяцев назад

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

@iamnusrat2 Месяц назад

can't open the given practice file

@BanAvtai 4 дня назад

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 3 дня назад

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?

@halfazmi 6 месяцев назад

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