The Excel Superstar Academy

1 The Excel Superstar AcademyBecome an Excel Superstar12 Why you can t miss this out?Because: You ll get 1200+ Office Productivity Tips It will help you gain Career Advancement which is the Key to Employees Morale To gain love and Respect at your Workplace which I believe is the most important element for employee satisfaction and retention at a company It will help you to Communicate, Negotiate and stand out with Better Networking in the Job MarketWhat do you think about this?I m sure it is impossible. This is your biggest Win-win chance tomake it your Boss, Colleagues and everyone around youAdvanced Excel in Hindi 200+ Video lessons Lifetime Access LinkedIn-verifiable CertificateBuy Now Copyright 2018 Excel ModeCourse Curriculum Copyright 2018 Excel 1: Excel NameDuration01H01 AutoSum function in Excel1:3802H02 Max function in Excel2:1003H03 Average function in Excel2:2804H04 CountBlankfunction in Excel2:4405H05 Count andCountafunction in Excel1:5906H06 Status bar in Excel1.

2 4307H07 Data Formatting in Excel3:2408H08 Autofilldates in Excel3:1109H09 Autofillnumbers in Excel4:3110H10 Format Painter in Excel2:3711H11 Table Formatting in Excel2:3912H12 How to store numbers as text in 1 minute in Excel3:0613H13 Sumproductfunction in Excel3:4814H14 Calculate Year on Year percentage Growth3:1415H15 Add serial numbers column before sorting in Excel2:1716H16 Format Painter Continuously in Excel3:0017H17 Color multiple sheet tab in Excel1:3718E18 Warm-up I: Key Shortcuts10:0619E19 Warm-up II: Essential formulas & application tricks Part 113:4520E20 Warm-up II: Essential formulas & application tricks Part 212:2221E21 Warm-up II: Essential formulas & application tricks Part 31:5222E22 Formatting Tricks -Part 111:2623E23 Formatting Tricks -Part 27:4524E24 Formatting Tricks -Part 36:51 Copyright 2018 Excel Formatting Tricks -Part 4 11:0926E26 Cell Referencing ($)3:2327E27 Cell Referencing ($)5:3928E28 Cell Referencing ($)4:2229E29 Cell Referencing ($)4:3430E30 Cell Referencing ($)2.

3 4831H31 Adding leading Zeroes in cheque number in Excel3:22 Section 2: Dashboard NameDuration32H32 Create Drop-down in Excel in 30 seconds3:2933H33 Remove Drop-down in Excel1:5934H34 Freeze Panes in Excel4:4335H35 Activate Developer Tab in 2007-2016 in Excel3:1036H36 Dashboard Trick Create a spin Button in Excel4:2837H37 Dashboard Trick Create a scroll Bar in Excel3:3738H38 Hyperlinked Shortcuts in Excel2:40 Copyright 2018 Excel 3: Business NameDuration39H39 Calculate Fixed Deposit in Excel | Part 12:2040H40 Calculate Fixed Deposit in Excel | Part 23:0841H41 Roundup and Round down function in Excel2:3042H42 Round function in Excel | Practical Applications2:0343H43 Round Tricks from Excel Superstar in Excel5:2644H44 Round function in Excel3:2945H45 MRound function in Excel4:0546H46 Formatting Tricks to write x3 in Excel1:27 Section 4: NameDuration47E47 Dates Concepts, Issues & Related Formulas -Part 110:1548E48 Dates Concepts, Issues & Related Formulas -Part 217.

4 4349E49 Dates Concepts, Issues & Related Formulas -Part 310:09 Copyright 2018 Excel 5: Sort & NameDuration50H50 Sort Data in Excel | Descending order3:0551H51 Sort Data in Excel | Alphabetically1:5152H52 Sort by Dates in Excel2:0453H53 Sortby Color in Excel1:4954H54 Filter Data and then Calculate Sum in Excel3:1355H55 Filter in Excel1:5456H56 Working with filtered Data in Excel4:4857H57 Number filter in Excel3:2658H58 2 level sorting in Excel2:2559H59 Subtotal function in Excel4:4760E60 Filter & SUBTOTAL formula17:05 Section 6: Data Cleaning & Text NameDuration61H61 Remove Duplicates values in Excel3:3962H62 UPPER, LOWER, PROPER to change text case in Excel2:5563H63 Trim function in Excel1:5864H64 Value function in Excel3:0965H65 Len function in Excel1:4266H66 Left Right Mid function in Excel4:0967H67 Delete Error cells by using Go To Special in Excel2:3868H68 Excel Shortcut: Ctrl + Enter2:0269H69 Fill Intermittent Blank cells in Excel5:0770H70 Substitute function in Excel2.

5 59 Copyright 2018 Excel NameDuration71E71 Text Formulas I UPPER, PROPER, LOWER, TRIM, T, N,REPT13:0372E72 Text Formulas II SEARCH vs. FIND, LEFT-RIGHT-MID, LEN10:4173E73 Text Formulas II SEARCH vs. FIND, LEFT-RIGHT-MID, LEN5:4974E74 Text Formulas III REPLACE, SUBSTITUTE7:14 Section 7: Logical NameDuration75H75 Master logical statements: True or False in Excel3:3876H76 Simple logical statement: True or False in Excel5:1477H77 Excel Logical function AND, OR4:26 Section 8: Lookups & NameDuration78H78 Vlookup function in Excel | Part 16:5379H79 Vlookup function in Excel | Part 25:4180H80 Countif function in Excel | Cell Counting4:0181H81 Sumif function in Excel | Adding numbers4.

6 3682H82 Averageif function in Excel3:45 Section 9: Conditional NameDuration83H83 Color cells based on cell value in Excel4:1984H84 Color cells based on cell error or blanks in Excel3:07 Copyright 2018 Excel 10: NameDuration85E85 Charts Basic Concepts of chart8:1186E86 Basic Charts Bar, Column, Pie5 ,SheetReferencing,HLOOKUP, Copyright 2018 Excel ModeCourse Curriculum Copyright 2018 Excel 1: Excel NameDuration1E01 Dashboard: Grouping, Data Validation Part -119:332E02 Dashboard: Grouping, Data Validation Part -27:133E03 Dashboard: Grouping, Data Validation Part -35:254E04 Data Validation II (Numbers, Dates, Text length)10:24 Section 2: Credit Default NameDuration5H05 Credit Default Swaps (Out of the box Excel )3:21 Section 3: Sort & NameDuration6H06 Horizontal Sort in Excel4:357H07 Add a blank row in Excel3:188H08 Sort Data by Custom list in Excel4:029E09 Multi-level Sort & Custom Sort.

7 Color Sorting10:52 Copyright 2018 Excel 4: Data Cleaning & Text NameDuration10H10 Text to Columns -Part 14:5711H11 Text to Columns -Part 24:1512H12 Text to Columns -Part 35:2013H13 Text to Columns -Part 44:4614H14 Text to Columns -Part 54:5515E15 Joining data strings using CONCATENATE, &11:2916E16 Text to Columns Applications, Tricks -Part 16:0217E17 Text to Columns Applications, Tricks -Part 26:3418E18 Text to Columns Applications, Tricks -Part 34:0919E19 Find & Replace Advanced10:16 Section 5: Logical NameDuration20H20 IF function and Nested IF function in Excel6:4521E21 Logical formulas I: IF, AND, OR, Nested IF -Part 16:4522E22 Logical formulas I: IF, AND, OR, Nested IF -Part 28:5623E23 Logical formulas I: IF, AND, OR, Nested IF -Part 39:2824E24 Logical formulas II: ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR8:53 Copyright 2018 Excel 6: Lookups & NameDuration25H25 Vlookupfunction in Excel | Part 37:2526H26 Vlookup function in Excel | Part 45:3927H27 Vlookup function in Excel | Part 55.

8 5228H28 Use Vlookupto find the Debtors Ageing analysis in Excel6:3129H29 I bet you wouldn t know this Vlookuptrick in Excel | Score Grading5:1430H30 I bet you wouldn t know this Vlookuptrick in Excel |Food Grading4:0031H31 Using Vlookupfind Service tax in Excel5:3232H32 Excel vlookupin Multiple sheets8:3133H33 Vlookupvs. Hlookupin Excel4:1634H34 Match function in Excel | Part 15:0735H35 Match function in Excel | Part 24:2536H36 2D Lookup | Vlookupand Match in Excel | Part 16:3237H37 2D Lookup | Vlookupand Match in Excel | Part 25:2538H38 2D Lookup | Vlookup and Match in Excel | Part 37:5039H39 2D Lookup | Vlookupand Match in Excel | Part 46:4740E40 VLookup& HLookup-Concepts, Issues & Applications -Part 15:4941E41 VLookup& HLookup-Concepts, Issues & Applications -Part 26.

9 4542E42 VLookup& HLookup-Concepts, Issues & Applications -Part 310:3743E43 VLookup& HLookup-Concepts, Issues & Applications -Part 410:4144E44 VLookup& HLookup-Concepts, Issues & Applications -Part 53:29 Copyright 2018 Excel NameDuration45E45 2-way Lookup VLOOKUP with MATCH -Part 112:4346E46 2-way Looku