Seth Roberts Jersey  Ahsan Mahmood – Apisylux
I-8 Markaz, Islamabad, Pakistan +92-313-1523538
Excel Tutorials, Tutorials
In this tutorial. We’re going to set the Excel Range name for the cells in worksheet. Let’s have a look on the worksheet i’ll be using. Name a cell with an excel Range name In this worksheet, we’ll change the price of wines from US Dollars to British Pounds, Euros and Japanese Yen. I’ll be using currency conversion rates in a table so the values will be used in this worksheet. Let’s see the exchange rate table. Name a cell with an excel Range name Step#1: Let’s calculate the currency amount in British Pounds for the “Chateau Lafite”. So, we’ll use the following way: Name a cell with an excel Range name Where C4 is the reference to price in US Dollars and “ExchangeRates!B3” is the reference to conversion rate of USD to GBP. “ExchangeRates” is the name of the worksheet containing table of currency conversion rates. We’ll get the following value in box. Name a cell with an excel Range name Step#2: Wouldn’t it be nice if instead of “ExchangeRates!B3”, it is something “=C4/USD_GBP”. So it’d be completely clear that what formula is representing. This can be done by using Range Names. Range Names point to the value in a cell that can be used in formulas, constants and tables. LINK EXCEL WORKSHEET TO WORD DOCUMENT We’re going to rewrite the formula. So i’ll delete the existing formula. Step#3: First of all, we’ll create the names of the currency conversion rates. For that we’ll select both columns in “ExchangeRates” worksheet. And we’ll move to “Formulas” in Ribbon Tab and Select “Create from Selection”. Name a cell with an excel Range name Step#4: A pop-up box will appear on the screen.Name a cell with an excel Range name Select the “Left Column” and Click OK. So, it’ll create the range names point to the values in Column B. Step#5: You can check the defined range names by clicking box in left up corner of worksheet table. Name a cell with an excel Range name HOW TO DO DATA VALIDATION IN EXCEL Step#6: Now moving to the main Worksheet to apply the formula again. Again selecting box under “British Pounds”, and applying formula: Name a cell with an excel Range name It’ll give same value but with different Formula Description that is clearly understandable. Name a cell with an excel Range name In the same way, we’ll do for the Euros and Japanese Yen. Name a cell with an excel Range name Step#7: There is another way to get a list of range names to be used in formula or constants. For that you need to select box, write formula structure and go to “Formulas” in Ribbon Tab” and select “Use in Formula”. It’ll give a list of range names, so you can select one to use. Name a cell with an excel Range name Step#8: Select the three boxes, and drag them down to get the values of all the prices in currencies. Name a cell with an excel Range name In this way, we can define and use the range names in formulas. That makes it easier for user to understand the formula. Share your reviews in the comment section.
0

Excel Tutorials, Tutorials
In this tutorial, you will learn, how to make a group box and add option button for excel form controls. Below is the sheet, i’ll be using for interest calculator.Group Box and option button excel form controls Step 1: We will use form controls. Form controls are advanced level features in excel that are hidden from normal users. So, we need to show developer tab in Ribbon. For that, we’ll right click in the blank area. Group Box and option button excel form controls And select “Customize the Ribbon…” You’ll see the following window dialog. Group Box and option button excel form controls You’ll find everything ticked except “Developer” option. Tick this option and Click “OK” to add Developer features to Ribbon. Group Box and option button excel form controls Step 2: Under Developer Tab, you’ll find insert option, that’ll be holding two types of controls. Group Box and option button excel form controls Form Controls are used in excel forms, while ActiveX Controls are used with Visual Basic. I’ll use Form Controls here. HOW TO USE COMBO BOX FROM EXCEL FORM CONTROL I’ll use Group options for “Rate” and “Amount of Periods”. So, i’ll remove the row holding “Rate”. And insert two rows for Group Box.Group Box and option button excel form controls Select Group box, and Move cursor to Row 6. Press Alt and Click & Hold mouse button and drag it to row 6 and 7 under Column A & B. Group Box and option button excel form controls Change “Group box 4” Caption of group box by double tap on it and Write text to “Rate”. Step 3: Now we need to add Option button from Form Controls again. So i’ll select and insert them into Group box. Group Box and option button excel form controls After Selecting Option Button from Form Control, Move mouse Cursor into Group Box, Press Ctrl and Draw with mouse button. It is the best practice and more professional to start from left side aligned. Group Box and option button excel form controls Step 4: To change the caption of Option box, Press Ctrl and Click on option to get focus and Click on Text to edit. Group Box and option button excel form controls After changing caption of Option boxes, you need to check that clicking on one option box should diminish the other selection of option box. It means one option box should be selected at one time.   Step 5: Now, you see the option boxes are not of same size. We can resize them equally by focusing and moving there edges with Mouse. But that is not so professional way to do as there will be some difference left. So we need to resize it using Format tool. Move cursor to any option button and get focus. Right click on it and select “Format Control”. You’ll get a window Dialog in front. Group Box and option button excel form controls Note Height and Width of one Option button.   Step 6: Now, Get focus of one option button and Press Ctrl and click on all Option buttons to select. Group Box and option button excel form controls And Right click on “Format Object” option. Group Box and option button excel form controls Enter those values you found in Step 5, in Height and Width. And you’ll see all option buttons in same size. Step 7: We need to align all the option buttons. So, again i’ll select all by selecting them by pressing Ctrl and Mouse click. And then Move to “Format” tab. And select “Aling Middle” in “Align” Option. Group Box and option button excel form controls And then we’ll relocate them with equal gaps in between them by selecting “Distribute Horizontally” in “Align” Option. Group Box and option button excel form controls You’ll get this group like Group Box and option button excel form controls Step 8: Same Steps to follow for “Amount for Periods”. You’ll get it like: Group Box and option button excel form controls Share your reviews in the comment section and let me know
0

Excel Tutorials, Tutorials, Word Tutorials
In this tutorial, you’ll learn to link Excel Worksheet to Word Document instead of embedding Worksheet in the document. Below are some steps to make it work:

Excel worksheet to Work document

Step#1:

Open new Word Document. Define your template and Write whatever the text you want before the Worksheet. Link Excel Sheet to word Document

Step#2:

Next step is to link Excel Worksheet into the Word document. For that, we’ll move to “Insert” from the ribbon tab and Select “Object” in “Text” Section. You can use shortcut key for that as “alt+n+j+j”. Link Excel Sheet to Word Document

Step#3:

Object Popup box will open. Select “Create from file” tab and Press “Browse”. You’ll see file selection box to Select file. Link Excel Sheet to Word Document After selecting file, don’t forget to check “Link to file”. It’ll create a shortcut display on your word document file. HOW TO USE COMBO BOX FROM EXCEL FORM CONTROL

Step#4:

You’ll see the Excel worksheet in Word document in the form of object. Link Excel Sheet to Word Document Here is the view of Excel worksheet linked to Word Document. Link Excel Sheet to Word Document You’ll see if the value in worksheet is changed, Word document will not detect it suddenly. To update the link in document file, right click on Worksheet Object and select “Update Link”. It’ll update all the values.

Precautions:

Whenever you link the Excel file to Word Document, you need to keep the link breakage in mind. There are following reasons that will break the link in your word and Excel file.
  • If you’ll rename the Excel file linked in the word document, you’ll break the link.
  • If you’ll rename the folder that contains the excel file linked to document, you’ll break the link.
  • If you’ll email the document file and doesn’t attach linked excel worksheet, you’ll break the link.
Please Share your review with me in the comment section to help improvements and make things better. I’d love to hear from you.
0

Excel Tutorials, Tutorials
In this tutorial, you’ll learn how to use Combo Box form control in your excel sheet. We’ll be using Interest Calculator for this purpose, as shown below: ComboBox from Excel Form Control

Step #1:

We’ll replace “Rate group box” with Combo Box. So, we’ll select Group box and press ‘Del’ button. Then, press ctrl and click on Radio Buttons to select them and press ‘del’. we’ll remove the rows 6 & 7 and Add one new row. ComboBox from Excel Form Control

Step #2:

We’ll insert the Combo Box in B6 box. For that we need to insert Combo Box from Insert in Developers Option. ComboBox from Excel Form Control

Step #3:

Press alt and, Click and drag in B6 to draw Combo Box. ComboBox from Excel Form Control LEARN HOW TO APPLY DATA VALIDATION IN EXCEL

Step #4:

To add list of values, we need to list all the value on other sheet. And use that range in Combo Box. So, we’ll create new Sheet with the name “Data” and list all the values of interest rates. ComboBox from Excel Form Control We’ll enter two values with the difference of 5%. Select these two values and drag down to 5 cells. Excel will detect the difference and fill the values with the difference of 5% in each cell increasingly. ComboBox from Excel Form Control

Step #5:

It’s best practice to define name for ranges to select them. So, We’ll select the cell ranges with values and go to “FORMULAS” ribbon tab. And select “Create from Selection”. ComboBox from Excel Form Control It’ll pop out a dialog box to give you options to select naming box for the range. ComboBox from Excel Form Control We have name to define range in the top row. So we’ll select “Top row” and select Press OK.

Step #6:

Now we have a defined name for the values of interest Rate. We’ll go to “Interest Calculator” Sheet. Select Combo Box and go to Format Control. ComboBox from Excel Form Control   It’ll give you dialog box to insert range of cells for the values. We’ll insert the name defined for values. I.e.: Interest_Rates ComboBox from Excel Form Control Press OK. Click on some other cell to remove selection focus of Combo Box. And then Check the Drop Down List, you’ll see all the values of range entered on “Data” Sheet. ComboBox from Excel Form Control   Share reviews in comments.
0

Excel Tutorials
Data Validation helps us to make our Excel sheet error free. With data validation, we can define which data type cell can accept. We can also provide a list of values, in which we can select. Entering wrong value will prompt with an error. In this tutorial, we’ll learn how to do data validation in Excel 2016.

Data Validation:-

We have a sheet with a table of data. Excel Data Validation In the table above, These are just five entries. Suppose we have 1000 of entries like this in one table. And we are using that data for some calculations. A little mistake may give us wrong results. Suppose we have room numbers. We need it error free. We’ll add data validation on room numbers column. For that, You need a pre-occupied list of data. Verify that list is perfect and error free, all the values are right. Select the range of the cell on which you want to apply validation. And in the menu ribbon, Go to “DATA” and select “DATA VALIDATION”. You can use shortcut key for that. Select the range of cells, and Press “Alt+A+V+V”. These shortcuts are hard to remember but practice makes everything perfect. You will see a dialogue box as below in the picture. Excel Data Validation You’ll see Validation criteria dropdown list. *These are all those options you can apply for validation.” Select “List” among those options. And select the source data. Source data is the list of pre-occupied data that is verified as error free. Select the source range on the sheet. In the upper portion of dialogue box, You will see two more tabs. Input Message Excel Data Validation You can enter information about the cell in this tab. When cell is selected, information pops out for user ease. Error Alert Excel Data Validation It facilitates with restriction about the wrong value. It will prompt if user will enter any wrong value and restricting to update the data in the cell. After finishing, You will see that the cells in column of Room number is showing a dropdown arrow. Clicking on that one, you’ll see verified list values. You have successfully applied data validation on Room number Column.
0

Android, Linux
whatsappTechnology needs are increased so much, that we always need more of it to perform our daily life tasks. Now-a-days, mostly phones are dual sim. And most of the apps are also based on phone number. When it comes to use same application with two different numbers, Play store doesn’t allow to install same application twice. Whatsapp is the most common communication application in mobile phone that needs mobile number to sign up. I’ll describe on how to install multiple Whatsapp on Android phone. A lot of applications are developed on Daily bases and get posted on playstore. So the mods also, to make that applications more customized and giving more abilities to perform for the end-user. There are a lot of mods available for different applications that are customized and giving users ease to surf internet and social media. There are many mods available for the playstore apps. I’ll describe few of them as follow. Different WhatsApp mods are available that are not on PlayStore but exists. Mods need manual installation and upgradations. Following are few whatsapp mods: Learn how to decrypt WhatsApp Database on Non-rooted Phone.

GBWhatsApp

It is a 3-copy, a copy of the official attribution allowance and a copy to run a second account and a copy to run a third account based on the latest version of the WTSP 2.17.427 application and supports all the android devices as well as other features. You can download GBWhatsapp HERE. GBWhatsApp Features:
  • Ability to hide appearances
  • Privacy options
  • You can send group messages to groups
  • Hide any conversation
  • You can now stop the Internet from the WhatsApp and keep the Internet working in other programs
  • You can upload video in the case of 7 minutes instead 30 seconds
  • Ability to send scheduled messages
  • You can retrieve any messages after sending them and will be deleted from all the devices sent to them
  • You can disable the automatic loading of the media for each conversation separately
  • You can send a message or call a number not saved in your device such as the application Viper
  • Possibility to know who visited your profile or come online
  • the possibility of setting lock password
  • Ability to send a video size of 30 MB instead of 16 MB
  • Ability to send a clip size of up to 100 megabytes instead of 16 megabytes
  • Ability to send 90 photos of a single batch instead of 10
  • Possibility to put the increase the number of characters to 250 instead of 139
  • Counter statistics for groups
  • Preview media without downloading
  • Possibility to hide the name and the date when copying letters or more
  • Ability to copy the case
  • Possibility of changing the program format, and change the icon of the program and notifications
  • Ability to send images with high accuracy
  • Ability to stop receiving calls for anyone you want or for everyone
  • Possible Displays the messages of any person in the group separately from the messages of the rest of the members
  • The program will send you an alert if your friend changed his personal picture

YOWhatsApp

This is another mod for Whatsapp. It comes with two variants. One is as same as Whatsapp from the Playstore but customized. And one with the same abilities but different name. You can download and install both at the same time. You can download one variant (com.whatsapp) HERE and other variant (com.yowhatsapp) HERE. YOWhatsApp Features
  • Media Privacy! Hide WhatsApp Media (Images/Videos/GIFs) from phone gallery
  • Switch between old and new emojis
  • 90% fixed delay in Custom Hide second tick for CONTACTS.
  • Lock Design
  • New Emojis
  • Option to remove custom privacy for a contact (YoMods > Privacy > Custom privacy)
  • Recent/Viewed bar background color in Status (Option 2.1.9)
  • Recent/Viewed bar text color in Status (Option 2.1.10)
  • Change colour of message counter text colour (Option 2.1.2)
  • Option to disable vibration in pattern (Option 6.0.6)
  • Search in Storage usage
  • Group members search (when members > 10)
  • Group admin settings, waiting server activation
  • Custom Privacy changing randomly (Please check YoMods > Privacy > Custom privacy)
  • Swipe to exit
  • Speed entering the conversation
  • Fixed choosing lock wallpaper for some phones (Option 6.0.4)
  • Opening Verified contacts info
  • com.yowhatsapp2 to run 3rd YoWA number
   
0

Linux, Ubuntu
Ubuntu is giving version updates regularly. It’s latest stable and Long term Support Version is 16.04. New versions of Ubuntu carries a lot of different new features that helps and ease the use of Operating system making it more efficiently. This guide will tell you how to upgrade distribution version of Ubuntu. Let’s get started with upgrading Ubuntu version from 16.04 to 16.10. Go to settings > Software & Updates > Updates tab > Set Notify me of a new ubuntu version to For any new version. It will update for any new version regardless of Stability. Ubuntu 16.04 Open Terminal > Type “sudo do-release-upgrade” Ubuntu 16.04 Terminal will start updating to up version. Follow the screen instructions. Ubuntu 16.04 Ubuntu will start downloading data packages for updated Versions. It’ll take around 1 to 2 hours for complete setup of version 16.10. See Also: Install Wine 1.8 on ubuntu.
0

Android, Linux

Android is most commonly used operating system in mobile devices and tablets and rarely in PC Computers. Android development has been on top since long. That gave it a power to do nearly as many of task as a computer can do. Where development was never ended for Android OS, large variety of tools are available. Following are some of Android Penetration Testing Tools.

Android Penetration Testing Tools:

Most of the tools need rooted device to be fully functional.

1. AndroRAT

By successfully running the tool one can get the following details of the victim.

  • Get contacts (and all theirs informations)

  • Do vibrate the phone

  • Get call logs

  • Open an URL in the default browser

  • Get all messages

  • Send a text message

  • Location by GPS/Network

  • Do a toast

  • Monitoring received messages in live

  • Streaming video (for activity based client only)

  • Monitoring phone state in live (call received, call sent, call missed..)

  • Stream sound from microphone (or other sources..)

  • Take a picture from the camera

2. Hackode

Hackode is the hacker’s Toolbox that is used for penetration testing, Ethical hacking, IT administration and Cyber security professional to perform different tasks like reconnaissance, scanning performing exploits etc.

This Application contains different tools like:

  • Reconnaissance

  • Google Hacking

  • Google Dorks

  • Whois

  • Scanning

  • Ping

  • Traceroute

  • DNS lookup

  • IP

  • MX Records

  • DNS Dig

  • Exploits

  • Security Rss Feed

This Application is still in beta version. Full version will be releasing soon with some more better tools and utilities.

3. APKInspector

APKinspector is a powerful GUI tool for analysts to analyze the Android applications. The goal of this project is to aide analysts and reverse engineers to visualize compiled Android packages and their corresponding DEX code. APKInspector provides both analysis functions and graphic features for the users to gain deep insight into the malicious apps:

  • CFG
  • Call Graph
  • Static Instrumentation
  • Permission Analysis
  • Dalvik codes
  • Smali codes
  • Java codes
  • APK Information

4. zANTI

zANTI is a mobile penetration testing toolkit and Ultimate hackers tool that lets security managers assess the risk level of a network with the push of a button. This easy to use mobile toolkit enables IT Security Administrators to simulate an advanced attacker to identify the malicious techniques they use in the wild to compromise the corporate network. Uncover authentication, backdoor, and brute-force attacks, DNS and protocol-specific attacks and rogue access points using a comprehensive range of full customizable network reconnaissance scans. 

zANTI enables Security Officers to easily evaluate an organization’s network and automatically diagnose vulnerabilities within mobile devices or web sites using a host of penetration tests including, man-in-the-Middle (MITM), password cracking and metasploit.

It highlights security gaps in your existing network and mobile defenses and report the results with advanced cloud-based reporting through zConsole. zANTI mirrors the methods a cyber-attacker can use to identify security holes within your network. Dash-board reporting enables businesses to see the risks and take appropriate corrective actions to fix critical security issues.

5. Droid Sheep

DroidSheep is an Android app for Security analysis in wireless networks and capturing facebook, twitter, linkedin and other accounts. It Requires root.

6. Dsploit

dSploit is an Android network analysis and penetration suite which aims to offer to IT security experts/geeks the most complete and advanced professional toolkit to perform network security assessments on a mobile device.

Once dSploit is started, you will be able to easily map your network, fingerprint alive hosts operating systems and running services, search for known vulnerabilities, crack log on procedures of many tcp protocols, perform man in the middle attacks such as password sniffing ( with common protocols dissection ), real time traffic manipulation, etc, etc . It’s still in beta stage, so unexpected behavior could happen.

7. AppUse

AppUse is a VM (Virtual Machine) developed by AppSec Labs. It is a unique platform for mobile application security testing in the Android environment, and includes exclusive custom-made tools created by AppSec Labs. As pentesters, we all know that there are a lot of commands, scripts, and tools that we use during Android penetration testing. It can be tedious to navigate from the OS to the Android shell, pull and push files, and perform our tests via CLI. This is exactly why built the AppUse dashboard! It will allow you work faster, be more effective, get higher quality results and save precious time!

0

Cameron Jordan Authentic Jersey