Excel for Intermediate Users - The Complete Course
ฝัง
- เผยแพร่เมื่อ 28 พ.ค. 2024
- 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 - แนวปฏิบัติและการใช้ชีวิต
![เปิดบ้าน เปิด Supercar อั๋นโอกิ เคยเอา rolls Royce เเลกพระ องค์ละ 100 ล้าน l [Nickynachat]](http://i.ytimg.com/vi/FeGwJwXauZ0/mqdefault.jpg)
Gather here if you are watching this video for an interview 😂
Got an excel interview tomorrow let’s gooooo
I'm here😂😂
Same 😂
Yuuuup 😂😂😂😂😂
I was and I got the job!
You are doing a great service. No joke, thanks for helping so many people.
I literally just finished watching the full beginner course yesterday and now you drop this banger, I’m ready! And thank you, really helpful
I did the first course also, I know people who paid for this knowledge. I'm so happy they are doing this for free.
Linking two workbooks is crazy. Amazed by that feature alone.
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.)
Thanks so much for your kind words and gift. I really appreciate it! And Visicalc, wow!
@@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.
I am brushing my excel for a new job, and thank you! Everything is coming back.
something u made in 2022 is helping me in 2024, thanks alot and gbu, love from india
I can't thank you enough for creating these videos and your precise, clear step-by-step instructions. You do a great service!
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.
Two Amazing Tutorials. Thanks alot.
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!
You are good in describe how to use each MS
Excellent video!
Great learning!
I currently have a Business Analytics course and I'm so grateful for this. This makes my life easier
This one is a MUST SAVE for me. Thanks! 🙂
Excellent! Thank you.
Fantastic lessons, I have never and ever seen such as you like your teaching from any TH-cam channel
Thanks very much.
This tutorial was even more amazing that the one for beginers . I am amazed !!!!!!!
Very informative and helpful, thank you !
I really appreciate your thoroughly amazing tutorial.
Thanks a lot, very helpful!
Excellentvideo! Thank you!
Excellent! Thank you
I really appreciate the way you taught. Very nice... Thank you.
Great Video!
Now Im looking forward for an advanced tutorial. 😊
Great teacher I salute him
This video was excellent. Thanks for your time.
Thank you so much 😊😊😊😊😊😊 awaiting for the advance excel complete course. ❤ You're such a great help😊
This is great! Thanks a ton.
Thank you so much for this valuable lesson. Subscribed!
PERFECT LESSON
Thank you very much!
This was a very hepful presentation. Thanks so much
I was really helpful and I am waiting to watch the advance course
Very useful videos, it changed the way I use Excel. Thanks a lot
If you want job interview and watching , watch it over and over again.
Wonderful job ✅
Absolute legend!!! Thank you
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?
Great work done. Very elaborately explained yet being concise. A must watch for people wanting to seriously learn MS Excel.
Thank you for your kind words. Please share the video with others you think might benefit from it.
Thank You , that was realy helpful
Thank you very much and you don't leave any stone unturned when you explain👌 and when are posting Advanced Excel?
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.
Thank you very much its very helpful.
You're indeed a life saver🙏🙏I can not thank you enough for this
Glad it was helpful!
THANK YOU SO MUCH FOR HELPINNG ME TO GET SUCCEED IN
I cannot regret why I followed you
Thanks a lot!
Thank you ❤
thank you bro
A great teacher 🍎
Many thanks for sharing your knowledge. But the constant MWF only show "Monday".
Thanks!
Thank you for your kind gift. I really appreciate it!
Thanks soo much for this 😢❤i really knew nothing about computers ,now am a G 😂
thanks
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?
Thanks
You're very welcome. Thanks so much for your kind gift, and for being a channel member!
Thanks so much for your kind donation.
Very much appreciate these videos. It's how I'm learning for free.
How can I activate quickinfos on the menu bar on the MacBook version of excel? When I hover over a feature nothing is shown. 😭
Can please give us tutorial on formatting election results using excel? Thanks
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.
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
Brilliant, thank you very much
This coach he make me help because he tech me more think I don't
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
Here's the link for the PowerPoint course: th-cam.com/video/KqgyvGxISxk/w-d-xo.html
And the link for the Word course: th-cam.com/video/2MCmnr2L50o/w-d-xo.html
Here's the PowerPoint course: th-cam.com/video/KqgyvGxISxk/w-d-xo.html
Here's the Microsoft Word complete course: th-cam.com/video/2MCmnr2L50o/w-d-xo.html
Got an interview on 16th so I am watching it now 😂
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?
okey we will help please wait.
Do you have Excel advanced full course video ? If yes link it in here please 🙏
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.
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.
Are the functions of Excel fairly similar to those of Google Sheets? That's to say, are the skills transferrable?
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.
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... 😉
💕 from here
I don’t have “Form” in my list of All Commands. Could it be called something else in another version of Excel?
Yes, that's possible. In this video I'm using the Microsoft 365 version of Excel. It's a little different than some of the other versions.
can't open the given practice file
🔥🔥🔥
Please do smart sheet
The define name formula is showing the first word only, I cant find a solution
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 🥰
did u get the answer?
If I am correct and there is no other criteria, just use formula = cell+75 , where the cell contain 6/6/23.
Okk
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?
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 Worked tonight! Don’t know what I was doing wrong
👍👍👍
i want to study advanced Excel also
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
Did you find the solution??
add ', i mean '= instead of =
@@axelladjouzi958i tried that still shows up only Monday
😍😍
Too many to absorb & retain in a short session!
Have a test in 2hrs😅
Intermediate course. "this is how you zoom" 😴
He heheh
u bad
I am watching your program❤️it is very helpful, my second language is English,
Please if you speak little bit slow i can understand better. Thank you very much 👌🙏
Thank you. Also, there is a setting in TH-cam where you can slow down or speed up the speakers voice.