How to do

Search This Blog

Home

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to know EPF balance?

In this post we will go in detail to know how to know EPF balance Before accessing EPF account, we need to get our UAN from our employer. Generally UAN number will be given in salary slips. The UAN is a 12-digit unique number that has been given to every PF member. To activate and to check your PF balance, follow below steps: 1: Open any browser and go to below link: https://www.epfindia.gov.in/site_en/index.php 2: Click ‘ Our Services ’ tab from top left corner of the web page and click on For Employees option. 3: ‘For Employees’ page will be displayed. Click on ‘ Member UAN/Online Service (OS/OTCP) option’ under Services Tab show at left bottom of web page 4: Click on UAN radio button and fill your UAN number, Name (as registered), Date of Birth & Registered Mobile number. Enter captcha and click ‘ Get Authorization Pin’ button . You will receive an OTP on your mobile. In the next page click on ‘ I Agree ’ under ' Disclaimer' checkb...

Compact CSV editor for routine works....

Compact CSV editor for routine works.... CSV Ninja is an compact CSVediting tool,using which one can merge,split transpose any large CSV files. Many of us come across an file type called CSV. Here is the explanation from Wikipedia for CSV :"In computing, a comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. A CSV file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format." (credits: Wikipedia). We can use normal text editor to view or edit an CSV file.But for doing some advance operations we have to depend upon the paid applications like MS -Excel etc.So for doing some routine works like Merging,splitting,changing delimeters & transpose ,I have created an appl...

How To Use Pivot Table in MS Excel ?

How To Use Pivot Table in MS Excel Microsoft Excel has many options, which are so useful that they make our work easy. In this blog we are going to check one such option Pivot Table . What is Pivot Table? "A Pivot table is a table of statistics that summarises the data of more extensive table.This summary might include sum,averages or other statistics.which the pivot table groups together in meaning full way." Let's discus a real time scenario. Imagine if we have a data containing 3 Columns for Country,Product and Unit sold for each product. For example: Country Product Units Sold Canada Paseo 292 Canada Montana 345 Germany Paseo 367 United States of America Montana 615 Germany Carretera 888 Germany Montana 921 Mexico Montana 958 Mexico Paseo...

Powered by Blogger

Home

Comments

Post a Comment