TECHANDGROW Institute

Advanced Excel

Basic to Advance Excel

Course Content 

    • Unit 1: Basic and new excel features in different versions of Excel, Types of
      references to perform complex calculations
    • Unit 2: Custom Number Format, GOTO Special, Hyperlink, Remove
      Duplicates and Data Validation
    • Unit 3: Name Manager, COUNT Functions, COUNTIF with wild card,
      Running Count and Arrange Data with Function
    • Unit 4: SUMPRODUCT Function, logical Functions and Grouping and
      ungrouping in Excel
    • Unit 5: Text functions in Excel to solve complex text problems, text to column
      functionality.

To Know more about the course , download the below Course Content Pdf.

X