Advanced Excel Full Course 2024 | Excel Tutorial For Beginners | Excel Training | Simplilearn

Подписаться 4,2 млн

Просмотров 3,5 млн

50% 1

🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-...
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-prof...
🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-anal...
🔥Data Analyst Masters Program (Discount Code - YTBE15): l.linklyhq.com/l/1yhwh
Advanced Excel Full Course 2024 by Simplilearn is complete Excel tutorial that helps aspiring data analysts with excel data analytics fundamentals. This Microsoft Excel Tutorial For Beginners will cover basic topics of excel like data validation, conditional formatting, spreadsheet fundamentals to advanced excel topics like time series analysis, filters, slicers, excel dashboarding, data visualization, and much more.
This Excel Full Course will cover the following topics:
00:00:00 introduction to Microsoft Excel Full Course
00:01:52 Excel Basic Knowledge
00:18:45 How To Change Lower Case To Upper Case In Excel?
00:19:58 How To Add Rows In Excel?
00:21:32 How To Add Columns In Excel?
00:24:29 How To Select Entire Column In Excel?
00:27:16 How to Compare Two Columns In Excel?
00:34:36 How To Convert Rows To Columns In Excel?
00:36:13 How to Group Rows in Excel?
00:37:55 How To Remove Blank Rows In Excel?
00:41:44 How To Freeze Row In Excel Tutorial
00:44:12 How to Convert Numbers to Words in Excel?
00:46:59 Combining Data From Multiple Cells In Excel
00:49:27 How To Merge Cells In Excel
00:54:12 How to Add Date in Excel?
00:55:48 How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy)
00:59:55 How To Calculate Age In Excel From A Date Of Birth?
01:01:37 How To Calculate Time Difference in Excel?
01:03:15 DAX In Excel Explained
01:08:20 Checkboxes In Excel
01:12:31 How to Insert Excel in PPT?
01:14:40 How To Insert Image In Excel?
01:18:05 How To Insert PDF in Excel Sheet?
01:21:40 How To Convert PDF To Excel
01:26:05 How to Insert Tick Mark in Excel?
01:29:05 How to add Watermark in Excel?
01:32:00 How to Increase Cell Size in Excel?
01:34:50 How to create Barcode In Excel
01:38:08 Excel Flash Fill
01:43:00 How to Add Hyperlink In Excel
01:55:44 Excel Round-Off Formula
01:58:18 How To Calculate Standard Deviation In Excel?
02:04:50 Index Match In Excel
02:09:10 How to Sort by Date in Excel?
02:10:40 How to Use AutoSum In Excel
02:13:47 How To Sort Data In Excel?
02:23:56 Slicer and Filter in Excel
02:27:49 How to Add Filters in Excel
02:29:20 Goal Seek In Excel
How to Create Drop-Down List In Excel?
02:44:46 Data Validation In Excel
02:44:50 How To Lock(Protect) Cells In Excel
03:17:55 How To Calculate Average In Excel?
03:18:43 Excel Print Page Setup
03:36:47 Page Break In Excel For Beginners
03:08:53 Conditional Formatting In Excel
03:41:56 How to Count Colored Cells in Excel?
03:47:54 DateDif In Excel Explained
03:51:08 Remove Duplicates In Excel
03:55:05 SUMIFS Formula in Excel
04:02:40 How To Create Pivot Tables In Excel
04:07:00 Autofill In Excel Explained
04:10:22 How to Calculate Percentage In Excel
04:12:08 How To Highlight Duplicates In Excel?
04:16:04 Charts In Excel
04:21:56 Progress Tracker In Excel
04:25:50 Excel Gantt Chart Tutorial
04:28:48 Pivot Tables In Excel
04:57 Pivot Charts in Excel and How to Create a Pivot Table Using Multiple Sheets in Excel
06:45:02 Time Series Analysis in Excel
07:37:00 Excel Dashboard Design
08:47:00 Excel Power Query Tutorial For Beginners
09:44:44 Excel Budget Template
09:51:37 Excel Interview Questions And Answers
⏩ Check out the Excel tutorial videos: • Microsoft Excel Tutori...
#HowtoGroupRowsinExcel #ExcelTutorial #ExcelGrouping #ExcelTips #MSExcel #Excel #ExcelTraining #LearnMSExcel #ExcelBasics #ExcelTutorialForBeginners #simplilearn
➡️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
👉 Learn More at: www.simplilearn.com/pgp-data-...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

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

26 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@SimplilearnOfficial Год назад

🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-analytics-certification-training-course?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-course-data-analytics?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥Data Analyst Masters Program (Discount Code - YTBE15): www.simplilearn.com/data-analyst-masters-certification-training-course?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments&

@cadream823 Год назад

Can we take a minute just to appreciate this brother for this selfless efforts Thanku bro.. But bro u can use Hindi a little bit so it understand and help many users

@SimplilearnOfficial Год назад

We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

@mr.savageryt2613 10 месяцев назад

Guys am just 7minutes into this video , but am already here to say THANK YOU! for the time taken to explain so deeply and separately.

@user-mu7ic2ol2y 10 месяцев назад

This video was recommended in China, so I came here, I think this video deserves to be seen by more people, thank you very much!❤

@chukwumanwakpa3330 Год назад

Can we get all the datasets that were used in this video please. This is so that we can practice alongside with similar data from the video. Meanwhile, you guys are just the best. Kudos! In anticipation.

@markin_mask5592 Год назад

I'm joining a b-school next month thank you so much for this course i really was looking for this !💗

@Naeem2460 Год назад

I can't believe, its free, i would recommend to my every fellow learner to see and appreciate this masterpiece❤

@amritamaheshwari9221 Год назад

Thankyou for explaining this course in such a easy manner. It would be a great help if you could please provide all the database that you have used in explaining so that I can practice alongside. Thanks again!

@deepakrana7949 Год назад

simply awesome, and I appreciate all your team's efforts to provide the valuable training free of cost, for which I can't express my gratitude. I owe it to you. I am aware that some course providers do not provide such knowledge despite charging exorbitant fees. Salute to you guys.

@SimplilearnOfficial Год назад

Our pleasure!

@salikmirza9941 Год назад

i am starting this course today from your video hope i will get succeed in completing with the same interest

@4signup452 Год назад

Every tutorial like this one is really something that every beginner is dreaming of . God bless you.❤❤❤

@SimplilearnOfficial Год назад

Thank you so much 😀

@jayeshkumbhani1531 Год назад

I have bought course for Excel from one site, and I can say that this free video contains more valuable content than my course. Also, very easy language and great explanation. Thanks ❤

@SimplilearnOfficial Год назад

@kanchanroy3570 Год назад

Thank you for making this video just started to watch it's helpful n can't wait to complete😊

@andiidoode Год назад

I love the enthusiasm, I'll be back as soon as I have some time over the next few weeks.

@SimplilearnOfficial Год назад

Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

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

this complete course is more worth then any course on the internet on free basis thank you so much

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

19:15 lower case upper case formula 21:23 Add rows 1 or more 24:35 select entire row/column 26:13 select column having data only 27:00 disadvantage of selecting whole column

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

Thank you!

@honeybee2919 Год назад

This is great, looking forward to working through this!

@SimplilearnOfficial Год назад

Hope you enjoy it!

@shrinivas1086 Год назад

Hi, in DAX Date & Time function (01:07:35) u calculated 'Retirement age' . U simply multiplied 65 y to the DOJ but in reality u should "multiply 65 y to dob" and u need to take "year" from that calculation & then "date & month" should be taken from DOJ. (if i am wrong, correct me.)

@twstruzik Год назад

Super helpful! I appreciate the indexing, especially. I've used super basic excel, but my new job needs advanced skills. This helped me so much!

@SimplilearnOfficial Год назад

We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

@samarrathore6220 Год назад

a great headstart for any MBA aspirant a must watch video

@SimplilearnOfficial Год назад

We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.

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

Only Indians on Excel video tutorials💀

@mmetpe Год назад

This is a wonderful tutorial, I’m grateful for the resource. Is there a set of learning files to work from, or is the intent to have the student recreate the files before taking the lessons? I’m a little confused on this, as I don’t need practice building spreadsheet data. Help, please!

@zeetahwrites1640 9 месяцев назад

It's very nice and help ful thanks for sharing

@user-jl3ck7ox7c Год назад

can you please provide me with the sample data used in excel dashboards tutorial, it would be a great help.

@JK-ws1el Год назад

You have done a great work but a small thing is we need those data to practice

@ARJUNKUMAR-LtoE 11 месяцев назад

Great!

@clever4u Год назад

2:02:58 Sir can you please explain how the sum of deviation answer came 5.6843E-14 ?

@rajnishranjan_centralunive7604 Год назад

at 36:00, transpose function is working only for one cell not as in video

@RahulSharma-fz3mq Год назад

Thanks !

@islam-co3re 6 дней назад

Hats off to you. This video has a lot to share. It's really appreciating that it's free to access.

@tahirjaved619 11 дней назад

Thank you for your assistance to learn Excel from Basic to Advance this is very amazing course to do. I'll recommend this course to beigners, I also request please also share the sheets for practices So this will be easy for students to practice and learn fast

@MindBlownTidbits Год назад

At 04:46:57 , how did we get the right results while selecting the bottom 3 entries for the lowest female graduates, when the list had been sorted in ascending order? Also at 04:50:45, according to my calculations, sum of sales for fruits is:16510, and for the vegetables it's:12350, and sales of both sumsup to 28,860(16510+12350).Then why it's displaying different results or did I get it wrong?

@sumankumardas8409 11 месяцев назад

Could you please provide the sample sheets so that we can practice at the same time.

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

Thank You so much for this...❤🎉

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

Very good! Thanks!

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

Outstanding sir super and excellent teaching i really inspired...

@SantanuSinhaRoy Год назад

Why don't you share the Excel Exercise Files here which can save us time to create new files with so many data for every small video tuto ??

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

Excellent content!

@user-xm7vv7xt5m 9 месяцев назад

Thankyou

@Arbraxius Год назад

4:15:50 Wouldn't you not only delete the duplicates, but also relevant data with this method?

@AsimKhan-vi6zy 8 месяцев назад

Looks awesome

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

Thank you so much Simplilearn Good Job

@markdavies-ei8sf 6 месяцев назад

Aye big man, I appreciate your time and effort you put into this tutorial. Quick question, can you create more courses in excel that a newbie like me, can just learn everything in one place? Like a beginner cource, since this is an advance course? Thanks.

@tarunbrahmabhatt2711 Год назад

How can plot a dynamic line between two strike price acording spot price

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

Thanks man

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

very helpful and very simple to understand thank you .

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

How can I remember everything that I've learnt? Should I note these down? It will be helpful? 🙁

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

Taking notes is definitely a great strategy to retain what you've learned! It can help reinforce the material and give you a quick reference for future review. Also, consider revisiting the notes regularly and practicing what you've learned through practical applications or quizzes.

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

Thank you so much sir for providing such quality content for free!! I'm currently in high school learning all this as it would help me in b-school in future.

@ankitapriyadarshanibiswal6970 Год назад

Very very very nice 😊 finally i got this video ❤

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

Thank you so much

@RishabKumar-dr6gp Год назад

Thank u so much for your efforts,, really greatfull ,, may you guys reach hights of success

@saurabhgupta484 Год назад

Thank you only this channel provide all Content for free

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

Thank you sir very useful

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

Great sir...🔥🔥

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

A big thanks to you bro

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

Good tutorial.

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

Great Video ❤

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

Respect and love for your invaluable education ❤❤❤

@ShahbazKhan-hw4co Год назад

can you please provide the sheets so that we can practice 🙂

@user-xw5jq4xz2z 11 месяцев назад

Time series analysis was not clearly understandable . Rest of the video was Great . Thanks alot to Simplilearn for such a teaching !

@hamzafirdausi4356 Год назад

Do we need Excel in digital marketing to make reports or we can use digital marketing reporting tool to make report..

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

whatever u are writing in the database , make sure it's visible to viewers also and provide some practice worksheets to practice excel if possible it will be implemented whatever you taught. Thanks 👍

@Rods_From_God 10 месяцев назад

That's a good session

@KARTIKVASTRI 4 дня назад

Thank you ❤

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

Nice information 👍

@tikshi Год назад

Hi @SimplilearnOfficial. You have shows three methods of comparing the two columns. But in each method the result is different. Don't you think this is wrong. Time around 30 minutes to 33 minutes section

@aqsaliaqat8817 9 месяцев назад

Tussi great o, thanx bro 😊❤

@ajaybhalekar4622 Год назад

Dear [ Simplilearn team ], I hope this message finds you well. Firstly, I would like to express my appreciation for your informative video on the topic of standard deviation. I found it to be quite insightful and helpful. However, I did notice something that I believe could potentially improve the viewing experience for your audience. While you were providing information of standard deviation on the right side of the screen, there was an animated video of graphs on the left side. Although it looked cool, I found it to be somewhat distracting from the main content. As a viewer, I am more interested in the information being presented rather than the animation. Therefore, I would like to suggest using a single image instead of the animated videos. I believe this would enhance the clarity and focus of your video, allowing your audience to better comprehend the material being presented. Thank you for your time and consideration. Best regards, Ajay Bhalekar

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

Thank you so much sir.

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

Thank you bro

@anjalishukla8980 Год назад

As your new subscriber ,I hope you don't delete this, i have found you change today and i am going to learning day by day because it very long video. Such information for free thank you so much you don't know how much it's means to students like me who don't have money.

@SimplilearnOfficial Год назад

Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.

@Tahirarai-w5b 22 дня назад

thank you amazing

@Yu-hc8dd Год назад

Thank you so much for this full course🙏

@SimplilearnOfficial Год назад

We are glad that you have enjoyed your learning experience with us : )

@nainu96 Год назад

Thank you Sir for this valuable Video 🙂

@SimplilearnOfficial Год назад

Most welcome

@OttersHeaven Год назад

I will type the data from the image into excel such as name, address, email, zip code etc. Is there any software or any way to check spelling mistakes in Excel from these images?

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

Thank you so much sir

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

Sir great video but if you put the pdfs and other materials which you are using in this class it will be really helpful.

@monabansal4147 Год назад

hie! my convert number to text formula is not getting saved? could you help me with that?

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

Thanks

@stickyndstick Год назад

i did the same process for activating SPELLNUMBER formula but when I do apply. It says syntas error and takes me to the module sheet where a line { Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) } this is in red color. please reply what should I do.

@FunFingersWer Год назад

Thanks a bunch 🎉🎉🎉

@SimplilearnOfficial Год назад

We are glad that you have enjoyed your learning experience with us : )

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

thank you 😇

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

Session was informative welldone (Y)

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

You saved me brother. I got a 26000sr( Saudi riyal) job because of you

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

Thank you very much for such a awesome tutorial ❤️ watching from ktm, Nepal 🇳🇵

@sameernaik7353 Год назад

Dhanyawad Bhai. Jai hind

@161daveveer5 2 месяца назад

Very nice 👌

@chintamankadam3077 Год назад

Best vedio ever

@srinivasboppana3274 10 месяцев назад

Nice brother

@ramakrishnajayanth301 Год назад

Can I directly watch adavaned excelr course video or should I watch excel for beginners video first

@abhishekyadav2041 Год назад

I salute your effort, but it seems without datasets not helpful as expectations without datasets, could you provide datasets please

@SmithAnderson-083 11 месяцев назад

Thanks for this content free of cost❤

@SimplilearnOfficial 11 месяцев назад

@-Sunshines-girl_ 18 дней назад

It would be helpful if you could do this detaild on SQL also... The time and topic mentioned in description is highly appreciated.

@wasimmadikhel9378 11 месяцев назад

THIS EFFORT IS APPRICIABLE

@SimplilearnOfficial 11 месяцев назад

@GOAT3ditz Год назад

Hello, in the video 46.32 - to convert number to text, you copied the macro from google where the function name was "Spell Number". However when you pasted macro in VBA Module, and you scrolled up to the first line- it read "NumbertoText". How was it?

@SimplilearnOfficial Год назад

The Macro was from Microsoft's official website. Please have your email address shared with us. We will have it sent out to you at the earliest

@RightViewAlakh Год назад

35:50 this is not Working in My PC its Showing Error when we Write =DUPLICATE(Sheet1!A1,B5) it is not working in my PC do You have any Solution

@ajay-I23 Год назад

I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no. Could you help me regarding this.