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

Sr No Language Level Section no Name Topic Name Duration 01 Hindi 1 Section 1: Excel Essentials 01 AutoSum function in Excel 1:38 02 Hindi 1

[PDF] Advanced Excel

These are features of Excel that intermediate and advanced spreadsheet modelers use to make their work more efficient, to make their spreadsheets easier to use,

[PDF] Microsoft Excel Tips & Tricks

Hide worksheet tabs > Windows Button > Excel Options > Advanced > Display Options > uncheck 'Show sheet tabs' 50 Hide row and column headers > Windows

[PDF] Excel Advanced

Excel's traditional formulas do not work on filtered data since the function will be performed on both the hidden and visible cells To perform functions on filtered

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

quotesdbs_dbs7.pdfusesText_5

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