[PDF] Advanced Excel Course in Hindi - Excel Superstar PDF MS-Excel-in-Hindi-Table-of-Content.pdf

Pivot Table, Sheet Referencing, HLOOKUP, Vlookup and INDEX MATCH are the Powerful Formulas that you need to learn to be an expert at work We have the

[PDF] Advanced Excel

Among the Excel Options, for example, the window for Formula options uses a button to select a Workbook Calculation mode (only one of the three available

[PDF] Microsoft EXCEL

workbook in another format, such as PDF/XPS or Excel 1997-2003 Close the current workbook From the Account pane, you can access your Microsoft account

[PDF] Exal Use Guide Hindi - theqtransformationcom

Recognizing the showing off ways to get this book exal use guide hindi is additionally useful Tag - Learn Excel in Hindi, Learn Microsoft Excel 2007 In Hindi, ms excel excel formulas pdf , microsoft excel formulas in hindi list, Basic Excel

[PDF] Excel Advanced

When doing so, a new sheet will automatically be added to your workbook • It is good to use a new worksheet for the pivot table so that your source data doesn't

[PDF] Microsoft Excel Tips & Tricks

outside the data area, in a blank area with no directly adjacent cells containing data, CTRL+A selects the entire sheet f If you have one or more objects e g

01Hindi1Section 1: Excel Essentials01 AutoSum function in Excel1:38

02Hindi1Section 1: Excel Essentials02 Max function in Excel2:10

03Hindi1Section 1: Excel Essentials03 Average function in Excel2:28

04Hindi1Section 1: Excel Essentials04 CountBlank function in Excel2:44

05Hindi1Section 1: Excel Essentials05 Count and Counta function in Excel1:59

06Hindi1Section 1: Excel Essentials06 Status bar in Excel1:43

07Hindi1Section 1: Excel Essentials07 Data Formatting in Excel3:24

08Hindi1Section 1: Excel Essentials08 Autofill dates in Excel3:11

09Hindi1Section 1: Excel Essentials09 Autofill numbers in Excel4:31

10Hindi1Section 1: Excel Essentials10 Format Painter in Excel2:37

11Hindi1Section 1: Excel Essentials11 Table Formatting in Excel2:39

12Hindi1Section 1: Excel Essentials12 How to store numbers as text in 1 minute in Excel3:06

13Hindi1Section 1: Excel Essentials13 Sumproduct function in Excel3:48

14Hindi1Section 1: Excel Essentials14 Calculate Year on Year percentage Growth3:14

15Hindi1Section 1: Excel Essentials15 Add serial numbers column before sorting in Excel2:17

16Hindi1Section 1: Excel Essentials16 Format Painter Continuously in Excel3:00

17Hindi1Section 1: Excel Essentials17 Color multiple sheet tab in Excel1:37

18English1Section 1: Excel Essentials18 Warm-up I: Key Shortcuts10:06

19English1Section 1: Excel Essentials19 Warm-up II͗ Essential formulas Θ application tricks - Part 113:45

20English1Section 1: Excel Essentials20 Warm-up II͗ Essential formulas Θ application tricks - Part 212:22

21English1Section 1: Excel Essentials21 Warm-up II͗ Essential formulas Θ application tricks - Part 31:52

22English1Section 1: Excel Essentials22 Formatting Tricks - Part 111:26

23English1Section 1: Excel Essentials23 Formatting Tricks - Part 27:45

24English1Section 1: Excel Essentials24 Formatting Tricks - Part 36:51

25English1Section 1: Excel Essentials25 Formatting Tricks - Part 4 11:09

26English1Section 1: Excel Essentials26 Cell Referencing ($)3:23

27English1Section 1: Excel Essentials27 Cell Referencing ($)5:39

28English1Section 1: Excel Essentials28 Cell Referencing ($)4:22

29English1Section 1: Excel Essentials29 Cell Referencing ($)4:34

30English1Section 1: Excel Essentials30 Cell Referencing ($)2:48

31Hindi1Section 1: Excel Essentials31 Adding leading Zeroes in cheque number in Excel3:22

32Hindi1Section 2: Dashbaord Tricks32 Create Drop-down in Excel in 30 seconds3:29

33Hindi1Section 2: Dashbaord Tricks33 Remove Drop-down in Excel1:59

34Hindi1Section 2: Dashbaord Tricks34 Freeze Panes in Excel4:43

35Hindi1Section 2: Dashbaord Tricks35 Activate Developer Tab in 2007-2016 in Excel3:10

36Hindi1Section 2: Dashbaord Tricks36 Dashboard Trick - Create a spin Button in Eǆcel4:28

37Hindi1Section 2: Dashbaord Tricks37 Dashboard Trick - Create a scroll Bar in Eǆcel3:37

38Hindi1Section 2: Dashbaord Tricks38 Hyperlinked Shortcuts in Excel2:40

39Hindi1Section 3: Business Calculations39 Calculate Fixed Deposit in Excel | Part 12:20

40Hindi1Section 3: Business Calculations40 Calculate Fixed Deposit in Excel | Part 23:08

41Hindi1Section 3: Business Calculations41 Roundup and Rounddown function in Excel2:30

42Hindi1Section 3: Business Calculations42 Round function in Excel | Practical Applications2:03

43Hindi1Section 3: Business Calculations43 Round Tricks from Excel Superstar in Excel5:26

44Hindi1Section 3: Business Calculations44 Round function in Excel3:29

45Hindi1Section 3: Business Calculations45 MRound function in Excel4:05

46Hindi1Section 3: Business Calculations46 Formatting Tricks to write x3 in Excel1:27

47English1Section 4: Dates47 Dates - Concepts, Issues Θ Related Formulas - Part 110:15

48English1Section 4: Dates48 Dates - Concepts, Issues Θ Related Formulas - Part 217:43

49English1Section 4: Dates49 Dates - Concepts, Issues Θ Related Formulas - Part 310:09

50Hindi1Section 5: Sort & Filter50 Sort Data in Excel | Descending order3:05

51Hindi1Section 5: Sort & Filter51 Sort Data in Excel | Alphabetically1:51

52Hindi1Section 5: Sort & Filter52 Sort by Dates in Excel2:04

53Hindi1Section 5: Sort & Filter53 Sort by Color in Excel1:49

54Hindi1Section 5: Sort & Filter54 Filter Data and then Calculate Sum in Excel3:13

55Hindi1Section 5: Sort & Filter55 Filter in Excel1:54

56Hindi1Section 5: Sort & Filter56 Working with filtered Data in Excel4:48

57Hindi1Section 5: Sort & Filter57 Number filter in Excel3:26

58Hindi1Section 5: Sort & Filter58 2 level sorting in Excel2:25

59Hindi1Section 5: Sort & Filter59 Subtotal function in Excel4:47

60English1Section 5: Sort & Filter60 Filter & SUBTOTAL formula17:05Advanced Excel Course in Hindi

Beginner Mode - Excel Course in Hindi06 hrs. 45 minutes and 86 Tutorial Sr.NoLanguageLevelSection no. & NameTopic NameDurationAdvanced Excel Course in Hindi Beginner Mode - Excel Course in Hindi06 hrs. 45 minutes and 86 Tutorial

61Hindi1Section 6: Data Cleaning & Text functions61 Remove Duplicates values in Excel3:39

62Hindi1Section 6: Data Cleaning & Text functions62 UPPER, LOWER, PROPER to change text case in Excel2:55

63Hindi1Section 6: Data Cleaning & Text functions63 Trim function in Excel1:58

64Hindi1Section 6: Data Cleaning & Text functions64 Value function in Excel3:09

65Hindi1Section 6: Data Cleaning & Text functions65 Len function in Excel1:42

66Hindi1Section 6: Data Cleaning & Text functions66 Left - Right - Mid function in Eǆcel4:09

67Hindi1Section 6: Data Cleaning & Text functions67 Delete Error cells by using Go To Special in Excel2:38

68Hindi1Section 6: Data Cleaning & Text functions68 Excel Shortcut: Ctrl + Enter2:02

69Hindi1Section 6: Data Cleaning & Text functions69 Fill Intermittent Blank cells in Excel5:07

70Hindi1Section 6: Data Cleaning & Text functions70 Substitute function in Excel2:59

71English1Section 6: Data Cleaning & Text functions71 Teǆt Formulas I - UPPER, PROPER, LOWER, TRIM, T, N, REPT13:03

72English1Section 6: Data Cleaning & Text functions72 Teǆt Formulas II - SEARCH ǀs. FIND, LEFT-RIGHT-MID, LEN10:41

73English1Section 6: Data Cleaning & Text functions73 Teǆt Formulas II - SEARCH ǀs. FIND, LEFT-RIGHT-MID, LEN5:49

74English1Section 6: Data Cleaning & Text functions74 Teǆt Formulas III - REPLACE, SUBSTITUTE7:14

75Hindi1Section 7: Logical Formulas75 Master logical statements: True or False in Excel3:38

76Hindi1Section 7: Logical Formulas76 Simple logical statement: True or False in Excel5:14

77Hindi1Section 7: Logical Formulas77 Eǆcel Logical function - AND, OR4:26

78Hindi1Section 8: Lookups & Aggregation78 Vlookup function in Excel | Part 16:53

79Hindi1Section 8: Lookups & Aggregation79 Vlookup function in Excel | Part 25:41

80Hindi1Section 8: Lookups & Aggregation80 Countif function in Excel | Cell Counting4:01

81Hindi1Section 8: Lookups & Aggregation81 Sumif function in Excel | Adding numbers4:36

82Hindi1Section 8: Lookups & Aggregation82 Averageif function in Excel3:45

83Hindi1Section 9: Conditional Formatting83 Color cells based on cell value in Excel4:19

84Hindi1Section 9: Conditional Formatting84 Color cells based on cell error or blanks in Excel3:07

85English1Section 10: Charts85 Charts - Basic Concepts of chart8:11

86English1Section 10: Charts86 Basic Charts - Bar, Column, Pie5:43

https://www.excelsuperstar.org/ https://www.facebook.com/Excelsuperstar/ https://www.youtube.com/c/Excelsuperstar https://in.pinterest.com/ExcelSuperstar17/Watch more videos

Like us on Facebook

Subscribe to the Channel

Excel Superstar on PinterestThere are Excel Formulas that you must know. Most of the jobs these days require advanced Excel Skills. Pivot Table, Sheet Referencing, HLOOKUP, Vlookup and

INDEX MATCH are the Powerful Formulas that you need to learn to be an expert at work. We have the Advanced Excel Course especially designed to make you an

expert at Excel. Sr.NoLanguageLevelSection no. & NameTopic NameDuration

01English2Section 1: Excel Essentials01 Dashboard: Grouping, Data Validation Part - 119:33

02English2Section 1: Excel Essentials02 Dashboard: Grouping, Data Validation Part - 27:13

03English2Section 1: Excel Essentials03 Dashboard: Grouping, Data Validation Part - 35:25

04English2Section 1: Excel Essentials04 Data Validation II (Numbers, Dates, Text length)10:24

05Hindi2Credit Default Swaps05 Credit Default Swaps (Out of the box Excel)3:21

06Hindi2Section 3: Sort & Filter06 Horizontal Sort in Excel4:35

07Hindi2Section 3: Sort & Filter07 Add a blank row in Excel3:18

08Hindi2Section 3: Sort & Filter08 Sort Data by Custom list in Excel4:02

09English2Section 3: Sort & Filter09 Multi-level Sort & Custom Sort; Color Sorting10:52

10Hindi2Section 4: Data Cleaning & Text Functions10 Text to Columns - Part 14:57

11Hindi2Section 4: Data Cleaning & Text Functions11 Text to Columns - Part 24:15

12Hindi2Section 4: Data Cleaning & Text Functions12 Text to Columns - Part 35:20

13Hindi2Section 4: Data Cleaning & Text Functions13 Text to Columns - Part 44:46

14Hindi2Section 4: Data Cleaning & Text Functions14 Text to Columns - Part 54:55

15English2Section 4: Data Cleaning & Text Functions15 Joining data strings using CONCATENATE, &11:29

16English2Section 4: Data Cleaning & Text Functions16 Teǆt to Columns - Applications, Tricks - Part 16:02

17English2Section 4: Data Cleaning & Text Functions17 Teǆt to Columns - Applications, Tricks - Part 26:34

18English2Section 4: Data Cleaning & Text Functions18 Teǆt to Columns - Applications, Tricks - Part 34:09

19English2Section 4: Data Cleaning & Text Functions19 Find Θ Replace - Adǀanced10:16

20Hindi2Section 5: Logical Formulas20 IF function and Nested IF function in Excel6:45

21English2Section 5: Logical Formulas21 Logical formulas I: IF, AND, OR, Nested IF - Part 16:45

22English2Section 5: Logical Formulas22 Logical formulas I: IF, AND, OR, Nested IF - Part 28:56

23English2Section 5: Logical Formulas23 Logical formulas I: IF, AND, OR, Nested IF - Part 39:28

24English2Section 5: Logical Formulas24 Logical formulas II: ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR8:53

25Hindi2Section 6: Lookups & Aggregation25 Vlookup function in Excel | Part 37:25

26Hindi2Section 6: Lookups & Aggregation26 Vlookup function in Excel | Part 45:39

27Hindi2Section 6: Lookups & Aggregation27 Vlookup function in Excel | Part 55:52

28Hindi2Section 6: Lookups & Aggregation28 Use Vlookup to find the Debtors Ageing analysis in Excel6:31

29Hindi2Section 6: Lookups & Aggregation29 I bet you wouldnt know this Vlookup trick in Eǆcel ͮ Score Grading5:14

30Hindi2Section 6: Lookups & Aggregation30 I bet you wouldnt know this Vlookup trick in Eǆcel ͮFood Grading4:00

31Hindi2Section 6: Lookups & Aggregation31 Using Vlookup find Service tax in Excel5:32

32Hindi2Section 6: Lookups & Aggregation32 Excel vlookup in Multiple sheets8:31

33Hindi2Section 6: Lookups & Aggregation33 Vlookup vs. Hlookup in Excel4:16

34Hindi2Section 6: Lookups & Aggregation34 Match function in Excel | Part 15:07

35Hindi2Section 6: Lookups & Aggregation35 Match function in Excel | Part 24:25

36Hindi2Section 6: Lookups & Aggregation36 2D Lookup | Vlookup and Match in Excel | Part 16:32

37Hindi2Section 6: Lookups & Aggregation37 2D Lookup | Vlookup and Match in Excel | Part 25:25

38Hindi2Section 6: Lookups & Aggregation38 2D Lookup | Vlookup and Match in Excel | Part 37:50

39Hindi2Section 6: Lookups & Aggregation39 2D Lookup | Vlookup and Match in Excel | Part 46:47

40English2Section 6: Lookups & Aggregation40 VLookup & HLookup - Concepts, Issues & Applications - Part 15:49

41English2Section 6: Lookups & Aggregation41 VLookup & HLookup - Concepts, Issues & Applications - Part 26:45

42English2Section 6: Lookups & Aggregation42 VLookup & HLookup - Concepts, Issues & Applications - Part 310:37

43English2Section 6: Lookups & Aggregation43 VLookup & HLookup - Concepts, Issues & Applications - Part 410:41

44English2Section 6: Lookups & Aggregation44 VLookup & HLookup - Concepts, Issues & Applications - Part 53:29

45English2Section 6: Lookups & Aggregation45 2-way Lookup - VLOOKUP with MATCH - Part 112:43

46English2Section 6: Lookups & Aggregation46 2-way Lookup - VLOOKUP with MATCH - Part 25:31

47English2Section 6: Lookups & Aggregation47 2-way Lookup - VLOOKUP with MATCH - Part 35:58

48English2Section 6: Lookups & Aggregation48 2-way Lookup - HLOOKUP with MATCH - Part 47:42

49English2Section 6: Lookups & Aggregation49 SUMIFS, COUNTIFS, Remove Duplicates - Part 15:34

50English2Section 6: Lookups & Aggregation50 SUMIFS, COUNTIFS, Remove Duplicates - Part 215:12

51English2Section 6: Lookups & Aggregation51 SUMIFS, COUNTIFS, Remove Duplicates - Part 36:42

52Hindi2Section 7: Pivot Table52 Pivot Table in Excel10:11

53English2Section 7: Pivot Table53 Piǀot Table - Applications with й Computation, Grouping - Part 111:57

54English2Section 7: Pivot Table54 Piǀot Table - Applications with й Computation, Grouping - Part 213:25

55English2Section 7: Pivot Table55 Piǀot Table - Applications with й Computation, Grouping - Part 36:45

56English2Section 7: Pivot Table56 Piǀot Table - Applications with й Computation, Grouping - Part 413:37

57English2Section 7: Pivot Table57 Tables5:10Advanced Excel Course in Hindi

Intermediate Mode - Excel Course in Hindi08 hrs. 18 minutes and 67 Tutorial Sr.NoLanguageLevelSection no. & NameTopic NameDurationAdvanced Excel Course in Hindi Intermediate Mode - Excel Course in Hindi08 hrs. 18 minutes and 67 Tutorial

58English2Section 8: Conditional Formatting58 Conditional Formatting I (Blanks, Errors, Values, Duplicates)10:46

59English2Section 8: Conditional Formatting59 Conditional Formatting III (Data Bars, Color Scales, Icon Sets)6:52

60Hindi2Section 9: Password, Printing & Others60 Hyperlinks in Excel2:15

61English2Section 9: Password, Printing & Others61 Formula Auditing techniques7:29

62English2Section 9: Password, Printing & Others62 File Security & password Protection6:58

63English2Section 9: Password, Printing & Others63 File Security & password Protection7:48

64English2Section 9: Password, Printing & Others64 Printing17:16

65English2Section 9: Password, Printing & Others65 Comments8:34

66English2Section 9: Password, Printing & Others66 Split Windows, Viewing multiple Windows5:04

67English2Section 9: Password, Printing & Others67 Hyperlinking5:55

Watch more videoshttps://www.excelsuperstar.org/

Like us on Facebookhttps://www.facebook.com/Excelsuperstar/ Subscribe to the Channelhttps://www.youtube.com/c/Excelsuperstar

Excel Superstar on Pinteresthttps://in.pinterest.com/ExcelSuperstar17/There are Excel Formulas that you must know. Most of the jobs these days require advanced Excel Skills. Pivot Table, Sheet Referencing, HLOOKUP, Vlookup and INDEX MATCH are

the Powerful Formulas that you need to learn to be an expert at work. We have the Advanced Excel Course especially designed to make you an expert at Excel.

quotesdbs_dbs14.pdfusesText_20

[PDF] [PDF] Advanced Excel Course in Hindi - Excel Superstar