- 15
- 2 447
Raghav Sharma
Приєднався 27 лип 2020
Combine Multiple Excel Sheets in one using Power Query
How to consolidate different sheets in excel
Переглядів: 200
Відео
Conditional Formatting in Excel - Part II.
Переглядів 8919 днів тому
The video entails about highlighting the cell which are greater or less than a specified value. Following this, we shall also be covering the ways to find duplicates and filtering out the values. Please find the link below for Part - 1 Conditional Formatting:- ua-cam.com/video/Sy4v5uVBphE/v-deo.htmlsi=aTm9hDXi1YNneLYD
Conditional Formatting in Excel using multiple conditions - Part -I
Переглядів 5020 днів тому
The video entails about the use of conditional formatting using multiple conditions.
What is Data Validation and How to use it
Переглядів 10922 дні тому
How data validation works and it's practical implications. To have a glimpse of Advanced V-LookUp Using Match Function in Excel :- ua-cam.com/video/Tig4drW4Dqg/v-deo.htmlsi=698SBU1PTQkqnpD2 To have a glimpse of Index Match in Excel :- ua-cam.com/video/5ofMOFFfrY0/v-deo.htmlsi=XB1-pTMOwS8cEpDK To have a glimpse of Countifs and Sumifs in Excel :- ua-cam.com/video/RJ9AJFCgw2A/v-deo.htmlsi=aLU-B8WO...
How to find the First Name, Middle Name and Last Name in Excel
Переглядів 16524 дні тому
The video entails how to find the first name, middle name and last name in excel using Left, Mid, Right, Find, Len and Trim functions
Index Match in Excel
Переглядів 39825 днів тому
The video entails about the use of Index Match in Excel. Below is the link for Advanced Vlookup with Match and IfError:- ua-cam.com/video/Tig4drW4Dqg/v-deo.htmlsi=wzHxX24qQMDap9Tt Below is the link for Countifs and Sumifs in excel:- ua-cam.com/video/RJ9AJFCgw2A/v-deo.html
Count v/s CountA v/s CountBlank
Переглядів 4126 днів тому
The video entails about the difference between count,counta and countblank. Check out the video for vlookup and match with iferror:- ua-cam.com/video/Tig4drW4Dqg/v-deo.html Check out the video for countifs and sumifs :- ua-cam.com/video/RJ9AJFCgw2A/v-deo.html
Advanced V Look-Up, Match and If-Error
Переглядів 12627 днів тому
This video entails how to use Vlookup with match and if there is an error, how to eliminate the same. Check my video on countifs and sumifs by clicking on the link below:- ua-cam.com/video/RJ9AJFCgw2A/v-deo.html
Countifs and Sumifs in Excel
Переглядів 22128 днів тому
The video entails about how to use countifs and sumifs in excel to get the analysis of the data.
Handling business days in SQL
Переглядів 8932 роки тому
The video entails about how to deal with business days in SQL. As an analyst, it becomes important task in the data cleaning and finding insights in the data. The business days could help us in finding the efficiency of our task.
Exploratory Data Analysis on Super Store Part-2
Переглядів 142 роки тому
The video entails about the Superstore which has three outlets. Our job as an Analyst is to figure out the areas which have done significantly well and the areas which need improvement. In addition to this, we also need to predict the future sales.
Exploratory Data Analysis on Super Store - Part-1
Переглядів 172 роки тому
The video entails about the Superstore which has three outlets. Our job as an Analyst is to figure out the areas which have done significantly well and the areas which need improvement. In addition to this, we also need to predict the future sales.
COVID-19 Analysis
Переглядів 302 роки тому
The video entails about the COVID-19 cases across all the nations. The analysis has been done via Tableau.
Linear Regression (Supervised Learning)
Переглядів 622 роки тому
The video discusses about how to perform predictions on supervised learning using machine learning algorithm
Finding the right clusters for unsupervised learning
Переглядів 512 роки тому
The video contains the process of segregating flowers into groups based on their attributes
👍👍👍
✅✅🔥🔥
🔥🔥🔥
Index Match is far better than Vlookup. It really helps us to fetch the answers quiet quickly
Great and useful content
Great content @Raghav sir Keep up the good work
👍👍👍👍👍🔥🔥🔥🔥🔥🔥
Wonderful Initiative, Keep up the great work 👍
Bhaiya Very useful for beginners
Raghav ji excelent content
👌👌🔥🔥🔥🔥🔥🔥🔥
👍👍
Hi @Raghav This will miss or better to say to calculate wrongly if start or end date is Saturday or Sunday
Thank you
what could be the query if i want the date which is 5 business days before current_date
Were you able to get a solution to this problem ?
Great 👏👏
Good. Keep it up 👏🏼👏🏼👏🏼👏🏼👏🏼
Thank u so much sir
It's explained very nicely.Simple language and effective presentation👍 gud luck for this initiative