Behaviour-Driven Development(BDD)

1. BDD Introduction 
2. What is Cucumber? When to Use ? Cucumber vs Selenium ?
3. JDK Download & Install
4. Create Maven Project & Cucumber Repositories - dependencies
5. Eclipse, Cucumber , TestNG Installations & Dependencies 
6. JUnit vs TestNG / Feature File Creation
7. What is Gherkin? Keywords ? Examples ?
8. AND & BUT Keywords 
9.  Create Step definition folder / Step definition file
10. Explanation of Cucumber Framework Setup & TestNGRunner without stepDefinition
11. Junit TestRunner Install & Run Program with JUNIT / TestNG
12. JUNIT  Runner v/s TestNG runner
13. Cucumber Options(Feature, Glue, Plugin)
14. Feature File
15. FEATURE Keyword
16. Cucumber Report Generation(Plugin)
17. Cucumber Report Generation - Example
18. DryRun
19. MonoChrome(Output will show in Better Format)
20. TAGS
21. TAGS(Single)
22. TAGS(Multiple)
23. TAGS(Feature Level)
24. TAGS (No Priority)
25. Name Option
26. Integrated with Selenum Driver
27. Integrated with Selenum Driver(Example2)
28. Hooks
29. Hooks(Example)
30. Hooks(Tagged)
31. Hooks(Tagged-Example)
32. Hooks(Ordering/Priority)
33. Hooks(Ordering/Priority)(Example)
34. Parameterization
35. Parameterization (Example)
36. Parameterization (Using Data Tables)
37. Parameterization (Using Data Tables)(Example-One Row)
38. Parameterization (Using Data Tables)(Example-Multiple Rows)
39. Parameterization (Using Scenario Outline)
40. Parameterization (Using Scenario Outline)(Example)
41. multiple stepDefinitions files But Only map to a particular step definition file (TAGS)
42. Parameterization (regular expressions (regex))(.+)
43. Page Factory (WebElement Repository)
44. Page Factory (WebElement Repository)(Example)
45. Common Page Actions
46. Adding Master through out report Plugin
47. Examples
48. Reusability
49. Reusability Example
50. Explanation of feature, StepIdentifier, TestNGRunner file 
51. Data-driven test design
52. Background
53. Configure Selenium Project
54. Example : Validate search Results based on search 
55. 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"