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): https://youtu.be/Uy3LK0aJGP4
2) Complete MS Excel Tutorial for Beginners (Video 2): https://youtu.be/4Mft-zhm3PQ
3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3): https://youtu.be/rmJvLSUS4s0

Our Interview Preparation Course (12+ Videos): https://youtu.be/mu7T6PYUcBE
*********************************************************
OUR OTHER VIDEOS YOU MIGHT LIKE:
1) Stock Market for Beginners: https://youtu.be/x0G4WtO0LCQ
2) Zerodha Trading Tutorial for Beginners: https://youtu.be/QaKbnXndWUY

*********************************************************
#MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel