Become SecurityTube Wireless Security Expert and/or Metasploit Framework Expert with Certification by Watching Videos and Practising Online Labs

Hi friends,

From my M.Tech university Cyber Security group, I got an e-mail to learn more about wireless networks and doing penetration testing on it.

I would like to share the links to download the video tutorials.

Please find the links become
http://securitytube-training.com/certifications/

You can enroll to the courses of your choice.

They are providing free video tutorials also.

Wireless Security Expert Course Videos link

All videos in single ISO
http://securitytube.aircrack-ng.org/Wi-Fi-Security-Megaprimer/WLAN-Security-Megaprimer-v1.iso

Individual Videos link
http://securitytube.net/groups?operation=view&groupId=9

Hope some of you can use this facility to learn more.

Please send your feedback and queries to psrdotcom@gmail.com

Excel Macro to Split Cell Data with Delimiter and Copy in other Columns

Hi all,
Today I have written one more small macro in Excel to split the data with the delimiter and copy to the columns which are beside to the data.


Sub splitdata()

Dim data As String
Dim values As Variant
Dim i As Long

    Set DataRange = Range("A1").CurrentRegion
    Range("A1").Select
    For Each cell In Range("A1").CurrentRegion
       
        'Getting text from the cell
        data = cell.Text
       
        'MsgBox ("Data :" & data)
       
        'Gettings Values
        values = split(data, ",")
       
        For i = 0 To UBound(values)
            'MsgBox ("Value is: " & values(i))
            'Splitting to other columns
            cell.Offset(0, i + 1).Value = values(i)
        Next i

    Next cell  
 
'Autofit the content to the column
    Cells.EntireColumn.AutoFit
   
End Sub

Please send your feedback and comments to psrdotcom@gmail.com

Pay AP (Andhra Pradesh) Electricity Bill Online

Hi all,

Due to increase in the service tax the e-seva people are consuming service tax for the electricity bill depending on the electricity slab.

If you are paying the bills online then there won't be service tax on the electricity bill.

APSPDCL (Andhra Pradesh Southern Power Distribution Company Limited) is providing an option to pay the bills online for Krishna, Guntur, Prakasam, Nellore, Kadapa, Chittor, Anantapur and Kurnool districts.

Please follow the procedure to pay the bills online.

• Please click on this link https://www.billdesk.com/pgidsk/pgmerc/spdcl/SPDCLDetails.jsp
• Enter your Service Number
• Select your type of payment (Current/Advanced)
• Click on "Submit" button
  It will go to next page if all the details are correct.
• Verify the "Name" and "Address"
• Enter the "Amount" which you want to pay
• You have different payment options like (Credit Card, Debit Card, Internet Banking)
• Select any one them and proceed to payment
• Like all those online payments, you have to give your card/netbanking details to finish the payment.

Register and Pay Online

• If you register with your "Service Numer" then you can pay online and verify your payment history also. To register with APCPDCL, click on the below link
• SignUp/Login
• Click on the "New User?Sign Up"
• Enter your details
• Click on "Register" to complete the registration.
• By now onwards you can login to your account and pay the bills online.

Pay through ATP (Any Time Payment) Machine

Machine address/location

Other Payment Options

You can pay your bill by any one of these options from Pay Bill section
http://www.apspdcl.in/SPDCL_Home.portal?_nfpb=true&_pageLabel=Login_portal_page_163


You can create an account in APOnline and pay your bills online.
https://secure.aponline.gov.in/CitizenPortal/userinterface/citizen/loginform.aspx?ReturnUrl=/CitizenPortal/UserInterface/Citizen/SPDCLDispatcher.aspx

References:
Southern Power Distribution Company of Andhra Pradesh Limited (APSPDCL)