Excel for Intermediate Users - The Complete Course
Вставка
- Опубліковано 6 чер 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 - Навчання та стиль
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.
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.
I am brushing my excel for a new job, and thank you! Everything is coming back.
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.
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 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
This tutorial was even more amazing that the one for beginers . I am amazed !!!!!!!
I currently have a Business Analytics course and I'm so grateful for this. This makes my life easier
Two Amazing Tutorials. Thanks alot.
This one is a MUST SAVE for me. Thanks! 🙂
Fantastic lessons, I have never and ever seen such as you like your teaching from any UA-cam channel
Thanks very much.
Excellent video!
Great learning!
Excellent! Thank you.
Great Video!
Now Im looking forward for an advanced tutorial. 😊
I really appreciate your thoroughly amazing tutorial.
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 really appreciate the way you taught. Very nice... Thank you.
Very informative and helpful, thank you !
Linking two workbooks is crazy. Amazed by that feature alone.
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?
Thanks a lot, very helpful!
I was really helpful and I am waiting to watch the advance course
something u made in 2022 is helping me in 2024, thanks alot and gbu, love from india
Great teacher I salute him
You're indeed a life saver🙏🙏I can not thank you enough for this
Glad it was helpful!
Thank you so much 😊😊😊😊😊😊 awaiting for the advance excel complete course. ❤ You're such a great help😊
Excellent! Thank you
This video was excellent. Thanks for your time.
This is great! Thanks a ton.
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.
Excellentvideo! Thank you!
Very useful videos, it changed the way I use Excel. Thanks a lot
PERFECT LESSON
Absolute legend!!! Thank you
This was a very hepful presentation. Thanks so much
Very much appreciate these videos. It's how I'm learning for free.
Thank you very much and you don't leave any stone unturned when you explain👌 and when are posting Advanced Excel?
Thank you so much for this valuable lesson. Subscribed!
Wonderful job ✅
Thank you very much!
I cannot regret why I followed you
THANK YOU SO MUCH FOR HELPINNG ME TO GET SUCCEED IN
Thank You , that was realy helpful
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.
Is there an "Excel for Advanced users course" ?
Thanks a lot!
Thank you ❤
A great teacher 🍎
thank you bro
Do you have Excel advanced full course video ? If yes link it in here please 🙏
Thanks soo much for this 😢❤i really knew nothing about computers ,now am a G 😂
Many thanks for sharing your knowledge. But the constant MWF only show "Monday".
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: ua-cam.com/video/KqgyvGxISxk/v-deo.html
And the link for the Word course: ua-cam.com/video/2MCmnr2L50o/v-deo.html
Here's the PowerPoint course: ua-cam.com/video/KqgyvGxISxk/v-deo.html
Here's the Microsoft Word complete course: ua-cam.com/video/2MCmnr2L50o/v-deo.html
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.
Thanks!
Thank you for your kind gift. I really appreciate it!
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.
thanks
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?
If you want job interview and watching , watch it over and over again.
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
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?
How can I activate quickinfos on the menu bar on the MacBook version of excel? When I hover over a feature nothing is shown. 😭
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.
This coach he make me help because he tech me more think I don't
Can please give us tutorial on formatting election results using excel? Thanks
💕 from here
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... 😉
🔥🔥🔥
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.
The define name formula is showing the first word only, I cant find a solution
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
Got an interview on 16th so I am watching it now 😂
Please do smart sheet
👍👍👍
Okk
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
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
😍😍
Too many to absorb & retain in a short session!
Have a test in 2hrs😅
He heheh
Intermediate course. "this is how you zoom" 😴
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 UA-cam where you can slow down or speed up the speakers voice.