Learn how you can build Big Data Projects
How to Lock Down a cell ?
In VLookUp Example when we use that formula in a cell and when we drag formula to other cells, we need to lock down the copied cell...how to perform that lock
Oct 20 2013 11:48 AM
Suppose you want to lock down D4. Place the curosor between "D" and "4" and press F4 key. 2 $ signs will appear and it will look like $d$4 - this will lock down the cell.
Oct 21 2013 03:25 PM
This will lock down both the row and column.
In some scenarios you might have to lock down only the row or only the column. In that case, keep pressing F4 until the $ sign changes places.
Oct 21 2013 03:26 PM
Mercari Price Suggestion Challenge Data Science Project
Data Science Project in Python- Build a machine learning algorithm that automatically suggests the right product prices.
Data Science Project-All State Insurance Claims Severity Prediction
Data science project in R to develop automated methods for predicting the cost and severity of insurance claims.
Yelp Data Processing using Spark and Hive Part 2
In this spark project, we will continue building the data warehouse from the previous project Yelp Data Processing Using Spark And Hive Part 1 and will do further data processing to develop diverse data products.
Human Activity Recognition Using Smartphones Data Set
In this deep learning project, you will build a classification system where to precisely identify human fitness activities.
Analysing Big Data with Twitter Sentiments using Spark Streaming
In this big data spark project, we will do Twitter sentiment analysis using spark streaming on the incoming streaming data.
Data Science Project - Instacart Market Basket Analysis
Data Science Project - Build a recommendation engine which will predict the products to be purchased by an Instacart consumer again.
Web Server Log Processing using Hadoop
In this hadoop project, you will be using a sample application log file from an application server to a demonstrated scaled-down server log processing pipeline.
Data Warehouse Design for E-commerce Environments
In this hive project, you will design a data warehouse for e-commerce environments.
Tough engineering choices with large datasets in Hive Part - 2
This is in continuation of the previous Hive project "Tough engineering choices with large datasets in Hive Part - 1", where we will work on processing big data sets using Hive.
Deep Learning with Keras in R to Predict Customer Churn
In this deep learning project, we will predict customer churn using Artificial Neural Networks and learn how to model an ANN in R with the keras deep learning package.
in vlookup, how do you lock the formula?
How do i lock down the values when using VLOOKUP Function?
How to use VLOOKUP?
Can we use VLOOKUP for geting data from two different excel?
for Vloop up function how to lock value in table_array parameter using keyboard shortcut?
You have not activated your email address. We have emailed you an activation code - please enter it below