Behaviour-Driven Development(BDD)

1. BDD Introduction 
2. What is Cucumber? When to Use ? Cucumber vs Selenium ?
3. What is Gherkin? Keywords ? Examples ?
4. AND & BUT Keywords 
5. FEATURE Keyword
6. Feature File
7. JDK Download & Install
8. Eclipse, Cucumber , TestNG Installations & Dependencies 
9. Create Maven Project & Cucumber Repositories - dependencies
10. JUnit vs TestNG / Feature File Creation
11. Explanation of Cucumber Framework Setup & TestNGRunner without stepDefinition
12. Reusability
13. Reusability Example
14. Explanation of feature, StepIdentifier, TestNGRunner file 
15. Interview Questions

EXCEL Formulas

Extract characters from positions 10 to 15 in a range from C2 to C101. Follow these steps:

1. In D2 (or any empty column), enter the formula: = MID(C2, 10, 6)

C2 is the source cell.
10 is the starting position.
6 is the number of characters to extract (from position 10 to 15).

====≠==========≠==========≠==========≠======

Alt+h+o+i -- column width adjust

Alt+h+o+a  --- row width adjust

Alt+h+o+c  --- centre

Alt+h+b+a  -- border

Alt+h+h  -->> header color

Alt+f+w+r   --- freeze (View-- Freeze panes)

Alt+d+o _   records filling

====≠==========≠==========≠==========≠======

Auto Border 

1. Select columns

2. Conditional Formatting

3. New rule

4. Use a formula to determine which cells to format.

5. Select starting column, =$A1, Format, Sleect border, Okay

====≠==========≠==========≠==========≠======

Number with round shape

=UNICHAR(ROW()+9311)

=UNICHAR(COLUMN()+9311)

====≠==========≠==========≠==========≠======

Eliminate numbers in empty rows

=IF(B2="","", COUNTA($B$2:B2))

====≠==========≠==========≠==========≠======

VB Code autofit all the columns

Autofit

Viewcode

Select worksheet

CELLS.EntireColumn.AutoFit click Tab

====≠==========≠==========≠==========≠======

VB Code autofit all the columns & Rows

   Sub AutoFitAllSheets()

    Dim ws As Worksheet

    

    ' Loop through all worksheets in the workbook

    For Each ws In ThisWorkbook.Worksheets

        ws.Cells.EntireColumn.AutoFit ' Autofit all columns

        ws.Cells.EntireRow.AutoFit ' Autofit all rows

    Next ws

    

    MsgBox "Autofit applied to all sheets!", vbInformation, "Done"

End Sub

Open your Excel workbook.

2. Press ALT + F11 to open the VBA Editor.

3. Go to Insert > Module

4. Paste the above VBA code into the module.

5. Press F5 or run the macro from the Macros window (ALT + F8).

====≠==========≠==========≠==========≠======

Extract First 3 Characters from a Name:

=LEFT("Michael", 3)    --->> Result: "Mic"