Скачать с ютуб Complete MS Excel Tutorial for Beginners | Part 2 of 3 | (with Download link) в хорошем качестве

Complete MS Excel Tutorial for Beginners | Part 2 of 3 | (with Download link)

Looking for a Career Switch? Check out: https://www.chikat.in/ Book a free 15 minute Career Counselling session with us: https://forms.gle/gfUcetraXDu3XXyp9 *********************************************************************** Download this Practice Workbook HERE: https://forms.gle/MLtkd5gBmWhkNkLE6 ******************************************************** Welcome to the second video of the Complete MS Excel Course for Beginners! 1. In the first video, we have learnt about the various job opportunities that require MS Excel as a skill, along with how you can access MS Excel for free. 2. The second video (which is this one!) is a Complete MS Excel Tutorial for Beginners. I have also created a practice excel workbook for you, that you can download and practise those features along with me while watching the video. (Scroll down for link!) 3. And in the third video, we are going to cover 10 most commonly asked MS Excel Interview Questions along with their answers. (Link to download this Interview practice sheet is in the description of Video 3) Today’s Agenda: 1. Basics of a Workbook  2. What are Flash-Fill and Auto-Fill 3. What is an MS Excel Ribbon? 4. The Home tab features .. including find, search and replace. 5. View tab features… Split and Freeze Pane  6. What are Functions and Formulas? What is the difference between Function and Formulas? 7. What is Absolute and Relative Referencing 8. Logical Functions 9. Text Functions 10. LookUp function 11. Tables and Charts 12. Pivot Tables 13. And last but not the least, how to handle the most commonly encountered errors in MS Excel.  So it doesn’t matter if you are a beginner or someone looking to brush up their basics right before an interview, I promise, by the end of these 3 videos you’ll excel at your excel skills. Don’t forget to comment and tell me what job role you are learning Excel for. It will help me decide what career videos to make next for you. Let’s start learning! :) ********************************************************* TIMESTAMPS: 0:00 - Introduction 2:18 - Workbook Basics 2:58 - Cell Name/Cell Address and Cell Range 5:09 - Insert/Delete and Hide Rows/Columns 7:06 - Introduction to the MS Excel Ribbon 8:21 - Autofill and Flashfill 14:22 - Home Tab Features 14:44 - Formatting Options 15:52 - Wrap Text 16:15 - Merge and Centre 16:50 - Number Formats 17:33 - Conditional Formatting (Highlight Cell Rules, Data Bars, Icon Sets, Colour Scales, Clear Rules..) 19:50 - Auto-fit Column Width 20:11 - Find, Select and Replace 22:22 - Sort & Filter 25:50 - Split and Freeze Pane (View Tab Features) 28:59 - Difference Between Split and Freeze Pane 29:38 - Functions and Formulas 29:49 - Sum, Average, Max, Min 31:50 - Count, CountA, CountBlank 32:45 - Difference between Formula and Function 33:54 - Relative and Absolute References 38:38 - Mixed References 42:12 - Logical Functions 42:29 - IF Function 44:14 - Nested IF 45:09 - AND Function 46:22 - OR Function 47:40 - SumIF Function 49:44 - CountIF Function 50:30 - Text Functions 50:52 - Left, Right, Mid 51:40 - Upper, Lower, Proper 52:05 - Len and Trim 52:55 - Concat and TextJoin 54:15 - VLOOKUP 57:42 - VLOOKUP Limitation 59:57 - MS Excel Tables (Creation and Features) 1:04:14 - Slicers 1:06:30 - Charts 1:10:20 - Different Chart Types 1:12:04 - Pivot Tables (Cleaning Data, Create Pivot Table and Analyse Data Option) 1:21:27 - MS Excel Errors 1:25:25 - IFError Function ********************************************************* LINKS TO OUR MS EXCEL COURSE: 1) Get MS Excel for FREE (Video 1):    • How to get MS Excel for FREE? | Part ...   2) Complete MS Excel Tutorial for Beginners (Video 2):    • Complete MS Excel Tutorial for Beginn...   3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3):    • Top 10 MS Excel Interview Q&A | Part ...   Our Interview Preparation Course (12+ Videos):    • Interview Preparation Course: MOST-AS...   ********************************************************* OUR OTHER VIDEOS YOU MIGHT LIKE: 1) Stock Market for Beginners:    • Stock Market Basics for Beginners | H...   2) Zerodha Trading Tutorial for Beginners:    • Zerodha Trading Tutorial for BEGINNER...   ********************************************************* #MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel