Best Online Learning Platform and Collect Information

How to link a cell to a different sheet in Google Sheets?

Google sheet linking ms excel
For this, you can Use IMPORTRANGE
Imports a range of cells from a specified spreadsheet.
Sample Usage
IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")
IMPORTRANGE(A2,"B2")
Syntax
IMPORTRANGE(spreadsheet_url, range_string)
  • spreadsheet_url - The URL of the spreadsheet from where data will be imported. The value for spreadsheet_url must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.
  • range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import. The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet. The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
Notes
  • Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.
  • If the data you are trying to import is too large, you may get an error.
Share:

[How to use Vlookup in excel] Complete guide about Vlookup formula

Hi, this is Vikash Kumar of The Independent Learning. Today we're going to talk about using the vlookup function in Microsoft Excel. Before we start, we need to understand the Vlookup Formula. Read carefully to understand,

Vlookup Function in MS Excel Definition:

"VLOOKUP is a Microsoft Excel function that is used to look for specified data in the mentioned column of a data table." Once it is found it will return a result on the same row. It is generally used in a workbook, where you have a data table that stores information about your work.

Understanding the vlookup function's technical details:

Uses of VLOOKUP: Vlookup commonly used in to find information from large datasets against the provided value or values. It comes under Microsoft Excel's Lookup functions category and Vlookup is very popular with MIS professionals, Finance professionals, Data analysts etc.

Syntax of Vlookup Function: Vlookup function have four arguments.

  1. lookup_value    (required)
  2. table_array    (required)
  3. col_index_num    (required)
  4. range_lookup   (optional)
The complete Syntax of formula is VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

See the table below For detail understanding about the syntax of vlookup formula.

      Now you able to understand what is vlookup? and how vlookup works? And you also know about its syntax and requirements. Going forward we will do some practical exercises with real data to understand VLookup. We already know that vlookup is used for is to find a value and see whether it exists in another range of values. So I have a list of people here that Works For a company ABC, See below. So all the people that works are here in the Main data. Main data Table has three Columns. We have filled Unique Employee codes of Employees are In Column B, In Column C there is Name of Employees and in Column D Salary.


     There are two another tables (Table 2 and Table 3) are in the above-mentioned sheet. First is to find salary against of mentioned Employee Codes and second is to find Salary against the Employee name. To find the values we will use Vlookup here. According to syntax, we need to define all four arguments of Vlookup Function first. Let's start the procedure of vlookup for Table 2. 

  1. lookup_value   - Lookup value will be Emp codes for Table 2 (F4, F5, F6........).
  2. table_array    - Table array will be whole Table 1 (B2:D22).
  3. col_index_num - Column index number for this will be 3 Because when we start counting from the First column of Table 1, salary comes on the third number. See below-attached sheet.
  4. range_lookup - We will fill 0 or False here to get the exact match.

Execution of Vlookup Function :

      Now we are all set and we want to use the vlookup formula. So I'm going to click in the cell next to this first Employee Id (G4). I want to see if 89750 (F4) is part of this group. Now obviously I can see it here cuz it's a small list but when you have potentially thousands of items in your list it gets a lot more tricky to figure that out. So I'll click the insert function button and I need to use a lookup function. I can search so I'll type me look up and there's vlookup, there's lookup, H lookup. H lookup does the same thing instead of going up and down columns it goes left to right across rows. So select vlookup, and what it does the first thing it says is it explains what the function does so it  "looks for a value in the leftmost column of a table over here and then returns a  value in the same row for a column you specify". And then you notice as you click in each of these fields here to build this function it gives you an explanation, what each of them does.

Using VLOOKUP with the first Column

        So there are four fields that you need to use here. The first one is the lookup value. So what are you looking for?  You want to look up 89750 (F4) in Table 1, So cell (F4) is the lookup_value. For table_array I could drag a range of cells. So we select whole Table 1 (B2:D22). So this is where I'm going to look. I'm going to check for 89750 (F4) value and see if it's in the range (B2:D22). Then we come to column_index_number this is the column number in Table 1 that I want to return. So I have a Table that is three columns wide, if I want to find a match for this 89750 (F4) which is here do I want to return, the value in column one which is the Employee ID or in column two which is the Employee Name or in column three which in the Salary. And for this activity, I want to do an employee id, and then range_lookup, range lookup there's two options true or false. false means it has to be an exact match, true means the closest match. Most of the time you will not want to use true. You'll want an exact match. Though we use false and we're ready to go so I'll hit OK.


     So it looked for F4 value in Table 1. It found the value right there and then it returned the data. That was in the first column of the range which is the name. Now I can just drag it all the way down my range and it will look up everybody. While dragging an error appears. To avoid this error we can use two methods. First is to create a Name Range for Table 1 or second method is to freeze cells. We will learn about Naming Ranges later. We will use the second method here. For freezing cells, you can just select the table array (B2:D22) and press F4 key. After pressing F4 your selection turns like this ($B$2:$D$22), you can press F4 or you can manually put dollor $ sigh before row and column numbers. Now again drag the formula. Now it's flawless. and you are able to find all the values against the Employee Codes.

Using VLOOKUP with 2nd Column

We have just used vlookup formula with the first column in the table array. In the previous case Lookup value was in the first column. But sometimes lookup value is in the different column instead of the first column of range lookup. As shown in the below image we are going to find Salary against the employee names which in the second column of the range lookup.



In this case, Vlookup function's arguments would be as below:
  1. lookup_value   - Lookup value will be Emp codes for Table 2 (F14, F15, F16........).
  2. table_array    - Table array will be not the whole Table 1 this time. Table array for this case will be  (C2:C22).
  3. col_index_num - Column index number for this will be 2 Because when we start counting from the second column of Table 1, salary comes on the second number. 
  4. range_lookup - We will fill 0 or False here to get the exact match.
Now execute the formula according to this and follow the same procedure as we have done earlier. You will get the answer.


So we have learned using vlookup in excel. You can use vlookup function in excel 2013, and all other versions of Excel. I hope your problem has solved. Please ask me if you have any doubts or any queries via comments. Please share this article on Facebook and with your friends, this will encourage me to write more relevant tutorials for you. happy learning and thanks for reading.

Share:

How to combine multiple cells data in one cell in Excel | Concatenate Function Examples

To combine texts of two or more cells in one cell we can use concatenate function. There are two of concatenate function. One is by using =Concatenate and second is using & symbol. We will learn both methods one by one.

Concatenate function by using =Concatenate

Syntex of Concatenate Function in Excel

=CONCATENATE(text1, [text2], ...)   OR =CONCATENATE(Cell1, [Cell2], ...)

Example Concatenate Function in Excel

Let's assume we have dataset similar to the below-mentioned picture. In this dataset we have few English person names as typed into columns as First name and Last name. In the third column, we need the combined name.

Concatenate function in excel

In Above picture, you are able to see that First and Last names are typed separately, and in third column names are combined but there is no space between first name and last name. In the fourth column, First name and Last name is Combined and separated by a space in a single cell. We need all the rows like this.

let's Put the formula in the Cell D1 and see the results. In the below-mentioned picture, we have combined the first name and last name but there is not any space between them. Now we will try to put space among them. We have simply used =CONCATENATE(Cell1, [Cell2], ...).

Concatenate function example in excel

To put space between first name and the last name we will use =CONCATENATE(text1, Quotation mark_space_ Quotation mark,[text2], ...). See the picture below.

Concatenate formula example in excel

And here we got the final solution

Concatenate formula example in excel


Concatenate function by using & Symbol.

We have learned Concatenate function by using =Concatenate. Now we are going forward to learn Concatenate function by using & Sign.

There is nothing so hard in using & symbol for concatenate function. Just you need to start function using = and no need to write concatenate and start selecting cells followed by & instead of comma ( ,  ) symbol. See example below.

Previous formula were =CONCATENATE(Cell1, [Cell2], ...). And current formula will be  =(Cell1&Cell2&Cell3......). To insert any other text or space you can use &Quotation mark_space ot text you want_ Quotation mark&.


Most commonly used Excel formulas.

How to use Vlookup in Excel.
How to import data from the web into Excel.
How To Make Shared Excel File And Allow To Edit By Multiple Users at one time.

Thanks For reading, I hope you got your problem. Please like and share this article on facebook if you found this useful. You can also comment your queries for fast response. 



Share:

How to use date Function in Excel | Date Function Examples

Description Of Date Function in Excel

Excel's Date function is built to create a DATE for three separate values. (Day, month, Year). If you have three separate values as 5 for the day, 4 for the month and 2017 for the year, you can easily create a date from these using DATE function.

Technical Details Of DATE Function In Excel.

Syntex:- =DATE(year,month,day)

The DATE function syntax has the following arguments:- 

  1. Year:- Argument type Required. The value of the year argument can include one to four digits. But Use four digits for the year argument to get flawless results. For example, "09" could mean "1909" or "2009."
  2. Month:- Argument type Required. The month is a positive or negative integer representing the month of the year from 1 to 12. Use 1 for January 2 for February and 12 for December. If the value of month is greater the 12, month adds that the number of months to the first month in the year specified. For example, DATE(2010,15,2) returns the serial number representing March 2, 2011. And if the month is less than 1 (negative), month subtracts the magnitude of that number of months, plus 1, from the first month in the year specified. For example, DATE(2010,-3,2) returns the serial number representing September 2, 2009.
  3. Day:-Argument type Required. The Day is a positive or negative integer representing the Days of the months from 1 to 31.
Note: Excel stores dates as sequential serial numbers so that they can be used in calculations. Its starts from January 1, 1900 and its serial number is 1, and serial number for January 1, 1901  will be 366 because it is 365 days after January 1, 1900.


DATE Function Example

Syntex:- =DATE(year,month,day)
Let's Assume the values for the arguments are as following.
Year:- 2013; Month- February; Day:- 23
Then the Date will be = Date(2013,2,23)
                      Answer =23/02/2013
See the image below for better understanding
Date Function in excel


Most commonly used Excel formulas.

How to import data from the web into Excel.
How To Make Shared Excel File And Allow To Edit By Multiple Users at one time.

Thanks For reading, I hope you got your problem. Please like and share this article on facebook if you found this useful. You can also comment your queries for fast response.

Share:

How to count cells between dates COUNTIFS Function example

To count cells between dates we can use CountIfs formula. Please read below for detailed examples and explanation. For better understanding, we have created a case over here. Let's assume that you have a purchase sheet of office inventory, and you need to count that how many products have been purchased in a year. See the image below.

For the flawless results, you must know these excel functions or methods. If you are not aware any of these take a quick look by clicking on.

  1. Date Function.
  2. Concatenate Function.
  3. Freeze cells Method. 


Count cells between dates CountIfs function example

Here is the Generic formula syntax for CountIfs:

=COUNTIFS(range,">=" &date1,range,"<=" &date2)

Formula Explanation:- To count the number of cells between two dates, we can use the COUNTIFS function.  In the example shown, G5 contains the formula.
According to the formula, the formula for the current data will be as mentioned below.

=COUNTIFS($D$5:$D$20,">="&DATE(F6,1,1),$D$5:$D$20,"<="&DATE(F6,12,31))

This Formula Counts Product purchased in the period of one year. We have used freeze cells ($$) method for flawless results.

Step by step formula explanation:

The Countif Function is used to count the number of cells that meet multiple criteria. In this case, we need to provide two criteria. (1. One criteria for the earlier date and 2. One for the later date). We have used Purchase Dates columns as a Criteria for both. And for both criteria ranges, we have chosen the first date of a year and the last date of the same year.

Most commonly used Excel formulas.

How to use Vlookup in Excel.
How to import data from the web into Excel.
How To Make Shared Excel File And Allow To Edit By Multiple Users at one time.

Thanks For reading, I hope you got your problem. Please like and share this article on facebook if you found this useful. You can also comment your queries for fast response. 
Share:

Everything about Big Data Analytics Courses and Certifications

Big Data Analytics Courses providers in Delhi-NCR, Big Data Analytics Courses fee, Big Data Analytics Courses providers in india, best Big Data Analytics Courses providers in Delhi-NCR, Prerequisite Skills For this certifications, Top platforms and Softwares for Big Data Analytics
Everything about Big Data Analytics Courses and Certifications

Data Analytics is a standout amongst the most useful and in demand parts of the modern era business module. On the off chance that you haven't known about the energy about Big Data analytics, you are not following the cutting edge patterns.

Since few years Big Data Analytics Certifications are in demand because modern era business module is nothing without data. Almost organizations are using data to research, analyse and marketing purpose. Management of data in organizations such as processing, storing and removing from data of all types and sizes has led to the need to identify the right skills to manage bulk data sets.

Big Data certification is a fastest way to get elevated salary and enlarged opportunities. You must have these features to be a Big Data Analytics Expert. You must have basic knowledge about these, include but not limited to
  • Analytics. 
  • Data Management. 
  • Mathematics. 
  • Data Statistics. 
  • Business Intelligence

"Big Data" What does it means?


Big Data as the named a huge data sets. These data sets are hard to capture, manage, analyse and process with basics database softwares (Excel, Access, SQL) within timeline. These data sets are so huge and complex that basic data processing softwares are faces challenges while analysis, processing, managing, storage and transfer.

What is Big Data Analysis?
Big data analytics is the method of processing and managing large and diverse data sets to find hidden patterns, unknown correlations, market trends, customer requirements and other key information that can help organizations or individuals to make more-informed business strategies to assure success.

"On other notes Big Data Analytics provides result oriented key informations from huge data sets to prepare strategies."

What are Big Data Platforms?
Big data platforms are the enterprise class Information technology platform, That provides the features and functionalities to manage, deploy, operate Big Data.

What are Big Data Analytics softwares?
Big data analytics softwares helps to processing and managing large and diverse data sets to find hidden patterns, unknown correlations, market trends, customer requirements and other deeper insights. There are plenty of such platforms and softwares.

To work on big data sets and analysing we must need the platforms and software to perform the work. Big data platforms and Big data analytics software's main focus to provide efficient analytics solutions for huges data sets. These platforms and softwares helps the organisation or individual to find hidden patterns, unknown correlations, market trends, customer requirements and other key information.



A list Top platforms and Softwares for Big Data Analytics:-


SN       Name SN      Name
1    MapR Coverage Data Platform 26    SGI Bigdata
2    IBM Big Data 27    MongoDB
3    Amazon Web Service 28    Guavus
4    Cloudera Enterprise Bigdata 29    Dell Bigdata Analytics
5    Hortonworks Data Platform 30    HPCC Systems Big data
6    Microsoft Azure 31    Palantir Bigdata
7    HP Bigdata 32    Pivotal Bigdata
8    Intel Bigdata 33    Google BigQuery
9    DataStax Bigdata 34    Pentaho Big Data Analytics
10    Informatica PowerCenter Big Data Edition 35    Cisco Bigdata
11    Datameer 36    Splunk Bigdata Analytics
12    GoodData 37    Mu Sigma Bigdata
13    Kognitio Analytical Platform 38    MicroStrategy Bigdata
14    Syncsort 39    Opera Solutions Bigdata
15    Actian Analytics Platform 40    Next Pathway
16    1010data 41    GE Industrial Internet
17    SAP Bigdata Analytics 42    Amdocs Insight
18    Oracle Bigdata Analytics 43    Google Bigdata
19    Teradata Bigdata Analytics 44    CSC Big Data Platform
20    Opera Solutions Signal Hubs 45    Celebrus Technologies
21    Attivio Active Intelligence Engine 46    Talend Open Studio
22    FICO Big Data Analyzer 47    Pachyderm
23    Arcadia Data 48    DataTorrent
24    VMware 49    Wavefront
25    Flytxt 50    BlueTalon





Best Big Data Analytics certifications and providers
The ascent in big data interest and in organizations storing, processing, find hidden facts, extracting value from data of all forms and sizes has led to a surge in the number of certifications, which seek to recognize the skills needed to work with huge and complex data sets. The target audience is IT professionals with a background in analytics, data mining, business intelligence or data management, along with a knack for and interest in mathematics and statistics. Individuals with big data or related certifications are in reasonably high demand and usually command salaries of $95,000 or more. Senior data scientists can expect a salary in the $130,000 to $175,000 range.

A List of Top and best Big Data certifications in 2018:-
1. Microsoft’s MCSE: Data Management and Analytics
The Microsoft slant is the utilization of its own tools such as Azure, SQL Server, as well as its BI and analytics platforms. Its courses educate users on how to build and deploy enterprise databases, run SQL Server systems in cloud environments, operate big data in the Microsoft Azure cloud, and harness these tools to analyze big data effectively.

2. EMC Data Science and Big Data Analytics Certifications
Through EMC certifications you can learn Hadoop (including Pig, Hive, and HBase), natural language processing, social network analysis, simulation, random forests, multinomial logistic regression, and data visualization.

3. SAS Certified Data Scientist

SAS Certified Data Scientist is the most challenging. It is comprised of five exams and four complete credentials. The data scientist credential requires SAS Big Data Professional and the SAS Advanced Analytics Professional certifications.


4. Data Science Council of America
DASCA provide certifications such as Associate Big Data Analyst, Senior Big Data Analyst, Associate Big Data Engineer and Senior Big Data Engineer. They are not product specific though, but a good source to start or advance your career in Big Data. It is a very organized certification body, providing certifications at different levels as per the learning needs of an individual.

5. Cloudera Certified Professional
Cloudera Certified Professional Data Engineers deals with how to develop reliable, autonomous, scalable data pipelines that result in optimized data sets for a variety of workloads. A graduate is armed with the skills required to ingest, store and analyze data in Cloudera's CDH environment.

6. Oracle Business Intelligence
Oracle has a massive certification operation and offers a wealth of alternatives. Many different Oracle Business Intelligence (BI) certifications are available based on Java and Oracle Middleware. This includes Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist, BI Enterprise Edition, BI Applications, Endeca Information Discovery, and Essbase.

7. Mining Massive Data Sets Graduate Certificate
The Mining Massive Data Sets Graduation Certification is offered through the Stanford Center for Professional Development is primarily for those who are already software engineers, statisticians, predictive modelers, data miners or analytics professionals.

8. Hortonworks
Hortonworks is a major Apache Hadoop certification provider. To become a Hortonworks Certified Professional, you need to earn at least one of the following: Hadoop Certified Developer, Hadoop Certified Apache Spark, Hadoop Certified Java Developer, Hadoop Certified Administrator and Hortonworks Certified Associate. On completion of these courses you become skilled in the design.

Prerequisite Skills For this certifications:
To enroll in these programs, you need at least few months of programming experience and hands on expertees in SAS, Core JAVA, SQL, Hadoop or another programming languages. You should also be confident enough on scripting languages like PERL or RUBY, and should have good, practical understanding of and exposure to working in the Linux and Unix environments. We also recommend that you have at least six months of experience using mathematics and/or statistics in a business environment. 

If you're just getting started or need to brush up on your skills, we recommend that first you get some knowledge about above programs.

If you are ready and willing to join any Big Data Analytics courses, Here is few recommended certifications and training providers.

How to choose best Certification and course providers:
If its complicated for you to decide to choose the best data analytics course or providers. Then first of all prioritize your essential list of requirement before joining the course. Few important guidelines to prepare a checklist while choosing this courses or providers are:

Know your Trainers
The most preferred checklist is to know about your trainer. You must be aware of this. You need to check expertise of your future trainer. And must be do some research about the training provider institution and figure out their authenticity. You can check their date of establishment, allumnies, infrastructure, goodwill etc. Your future trainer must have 8 to 10 years of experience in Big data analytics operations and minimum 3 to 5 years of experience in training.

Accedeations
You can also check about Big data Analytics Training providers accedeations. You can also check accedeations authenticity.

Check their goodwill
To check their goodwill, read their reviews and you can also contact any alumni of that institution if it possible. You may find few alumnis on linked and figure it out that where they are working. You can check their clients also.

Does that institution provides practical training or assignments?
As you know already the Data Analytics is all about doing practically, you must need to figure out that the training provider provides practical training session with projects and assignments or not. `

Fee Structure
If you have followed above mentioned checklist, you must have few shortlisted Name of Big data Analytics Training providers. Try to compare theirs dues & fees along with theirs claim.

Big Data Analytics with classroom training in Delhi NCR:
  • AnalytixLabs
AnalytixLabs Institute based at Delhi NCR and Established in 2011. The AnalytixLabs operates globally with online mode and with classroom option in Delhi-NCR and bangalore. Their fee for the Business Analytics 360 is INR 42000 + Taxes and 40,000 + taxes for Advance Big Data Science. Duration for both courses are 6 Months with live classes in weekends. For more information Visit website www.analytixlabs.co.in

Delhi-NCR Office Address:- 
GF 382, Sector 29,
Adjoining IFFCO Chowk Metro Station (Gate 2),
Next to Vasan Eye Care Hospital,
Gurgaon, Haryana 122001
Tel:- +91 95-55-219007
Email:-info@analytixlabs.co.in
  • Imarticus Learning
Imarticus Learning Institute based at Mumbai, Maharashtra and Established in 2013. Imarticus Learning Institute operates globally with online mode and with classroom option in Delhi-NCR and other cities also. Their fee for the Classroom is INR 72500 + Taxes and 55,000 + taxes for Online. Duration for both courses are 4 Months with live classes in weekends. For more information Visit website www.imarticus.org

Delhi Office Address:- 
Plot No.10, Dakshin Marg,
Near Samrat Sweets, DLF Phase-II,
Gurgaon – 122008
Tel: +91 124 4874033/40
Email:- info_delhi@imarticus.com
  • IMS Pro School
IMS Pro School based at Mumbai, Maharashtra and Established in 2014. IMS Pro School operates in Mumbai, Navi Mumbai, Thane, New Delhi, Bangalore, Chennai, Hyderabad, Pune, Gurgaon, Kochi with classroom option. Their fee for the Classroom is INR 90,000+ Taxes . Duration for courses are 6 Months (140 hours) with live classes in weekends. For more information Visit website www.proschoolonline.com.

Delhi Office Address:-
Lajpat Nagar 
99, National Park
Lajpat Nagar IV, New Delhi - 24,
Near Moolchand Metro Station.
Email ID : amitj@proschoolonline.com
Tel: 011-43658144 / 011- 40516955
Mob: +91 9871878870 / 7838572227
Preet Vihar 
2nd floor, Plot no.2
Hargobind Enclave, Delhi - 110092,
Near Preet Vihar Metro Station.
Email ID: akhila@proschoolonline.com
Contact: Tel: +91 1140395003
Mob: 9773987640 / 9773987641 / 9773987642
Gurgaon
K7/5, DLF Phase II, Gurgaon,
Haryana 122002.
Email ID: mamtap@proschoolonline.com
Mob: +91 9971414355
  • Ivy Professional School
Ivy Professional School based at Kolkata, West Bengal and Established in 2007. Ivy Professional School operates in Bangalore, New Delhi, Kolkata and Pune with classroom option. Their fee for the Classroom is INR 38,746/- . Duration for courses are 250 hours with live classes in weekends. For more Visit http://ivyproschool.com/.

Delhi Office Address:-
22 A, Near Max Hospital, Lajpat Nagar -4
New Delhi 1100024
Mob. +919599707420
Email:- info@ivyproschool.com
  • Edupristine
Edupristine Institute based at Mumbai, Maharashtra and Established in 2008. Edupristine operates in Mumbai, Delhi, Bangalore, Pune with classroom option. Their fee for the Classroom is INR 25,000 /- . Duration for courses are 10 weekends. For more Visit http://www.edupristine.com

Delhi Office Address:-
#44,2nd Floor, Regal Complex,
Outer Circle, Connaught Place,
New Delhi 110001
Phone:- 1800 200 5835




Big Data Analytics Courses providers in Delhi-NCR, Big Data Analytics Courses fee, Big Data Analytics Courses providers in india, best Big Data Analytics Courses providers in Delhi-NCR, Prerequisite Skills For this certifications, Top platforms and Softwares for Big Data Analytics

Here Is the comparison of best Big Data Analytics Courses providers in Delhi-NCR


Institutions
In industry
Fees INR
Duration
In NCR
Accredited
Faculty Experience
AnalytixLabs
7 Yrs
82000
6 month
Gurgaon
Yes
Ave 15 yrs
Imarticus Learning
7 Yrs
72500
4 Months
Gurgaon 
Yes
Ave 15 yrs
IMS Pro School
7 Yrs
90,000
140 hours
Delhi/Gurgaon
Yes
Ave 15 yrs
Ivy Professional School
7 Yrs
38,746
250 hours
Delhi
Yes
Ave 15 yrs
Edupristine
7 Yrs
37,600
10 weekends
Delhi
Yes
Ave 15 yrs

Thanks for reading.
You May also interested in:- 
Share:

How to book Tatkal Ticket on Indian railway with 100% guarantee and fast


fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,


Know How To Book Tatkal Ticket In 20 Second On IRCTC By Smart Phone.
1. Go to your Play store .
fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,

2. Search App "Fast Book-Tatkal IRCTC"


fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,


3. Install app in your mobile .
fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,

 
4. Open Application and go to ticket setting before booking tatkal ticket

fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,


5.  Open login Details

fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,
 
6. Fill your IRCTC login id & password and save detail.
fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,

7. Now go to Journey Settings  and fill your source or destination along with all details as required     
    in  application and save details.

fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,   fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,



 8. Add passenger details and save.

fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,


9. Add payments details and save . for exp :- login id & password both.
fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,
 fast tatkal ticket booking on mobile, free, best railway ticket booking app, fast book tatkal irctc free,



After fill all details now book ticket in very fats with in 20 seconds 

Note: your internet speed not slow when book your ticket. 

fast tatkal ticket booking on mobile, free, best railway ticket booking app,
fast book tatkal irctc free,  
















Share:

Import from web into excel; easy data capturing tips

Follow these simple steps to get this done.


Hello Friends By using this method you can simplify your data fetching work.and impress your colleagues and boss. Import from web into excel, easy data capturing tips, scrape data from web to excel for free, data scraper, how to copy website data without macro

Please follow below mention instruction step by step .

Import from web into excel, easy data capturing tips, scrape data from web to excel for free, data scraper, how to copy website data with out macro

  • Copy URL of website which data you want fetch.
  • Open Excel and go-to Data Tab.
  • Click From Web tab.
  • Automatic open Browser Box.
  • Paste URL in open browser and click Go button.
  • Select cell in excel where are you fetch data . 
  • click yellow tick box 
  • Go to import data.
  • Now data ready to fetch.
Import from web into excel, easy data capturing tips, scrape data from web to excel for free, data scraper, how to copy website data without macro
Share:

Follow by Email

Popular Posts