- 114
- 120 330
Structural Design Only.
India
Приєднався 2 вер 2016
Learn INDEX, MATCH, VLOOKUP & HLOOKUP in Excel Like a Pro!
Unlock the full potential of Excel with our comprehensive guide to INDEX, MATCH, VLOOKUP, and HLOOKUP functions! 🚀 Whether you're a beginner or an intermediate user, this tutorial will help you master:
1️⃣ How to use the INDEX function for advanced lookups.
2️⃣ Combining INDEX and MATCH for dynamic data retrieval.
3️⃣ The versatility of VLOOKUP for vertical searches.
4️⃣ The power of HLOOKUP for horizontal searches.
Learn practical examples and tips to save time and enhance your efficiency in Excel. Perfect for professionals, students, and anyone aiming to elevate their spreadsheet skills. Don't miss out-watch now and become an Excel pro! 💼📊
🔔 Subscribe to my channel for more Excel tips and tricks, and hit the like button if this video helped you!
02. Similar Channels:
ExcelIsFun
Leila Gharani
MyOnlineTrainingHub
Excel Campus - Jon
TeachExcel
03. Other Search Terms:
How to use INDEX function in Excel
VLOOKUP vs INDEX MATCH
Excel lookup functions tutorial
Horizontal and vertical lookups in Excel
Learn Excel functions for beginners and intermediates
Excel tips and tricks
04. Tags:
Excel lookup functions, INDEX function tutorial, MATCH function guide, VLOOKUP in Excel, HLOOKUP explained, Excel tips, Excel advanced functions, dynamic lookups in Excel, Excel for beginners, Excel for intermediate users, Excel tutorial 2024
05. Hashtags:
#ExcelTips #ExcelFunctions #INDEXFunction #MATCHFunction #VLOOKUP #HLOOKUP #ExcelTutorial #LearnExcel #ExcelPro #SpreadsheetSkills
06. Hashtags with Comma:
#ExcelTips, #ExcelFunctions, #INDEXFunction, #MATCHFunction, #VLOOKUP, #HLOOKUP, #ExcelTutorial, #LearnExcel, #ExcelPro, #SpreadsheetSkills
1️⃣ How to use the INDEX function for advanced lookups.
2️⃣ Combining INDEX and MATCH for dynamic data retrieval.
3️⃣ The versatility of VLOOKUP for vertical searches.
4️⃣ The power of HLOOKUP for horizontal searches.
Learn practical examples and tips to save time and enhance your efficiency in Excel. Perfect for professionals, students, and anyone aiming to elevate their spreadsheet skills. Don't miss out-watch now and become an Excel pro! 💼📊
🔔 Subscribe to my channel for more Excel tips and tricks, and hit the like button if this video helped you!
02. Similar Channels:
ExcelIsFun
Leila Gharani
MyOnlineTrainingHub
Excel Campus - Jon
TeachExcel
03. Other Search Terms:
How to use INDEX function in Excel
VLOOKUP vs INDEX MATCH
Excel lookup functions tutorial
Horizontal and vertical lookups in Excel
Learn Excel functions for beginners and intermediates
Excel tips and tricks
04. Tags:
Excel lookup functions, INDEX function tutorial, MATCH function guide, VLOOKUP in Excel, HLOOKUP explained, Excel tips, Excel advanced functions, dynamic lookups in Excel, Excel for beginners, Excel for intermediate users, Excel tutorial 2024
05. Hashtags:
#ExcelTips #ExcelFunctions #INDEXFunction #MATCHFunction #VLOOKUP #HLOOKUP #ExcelTutorial #LearnExcel #ExcelPro #SpreadsheetSkills
06. Hashtags with Comma:
#ExcelTips, #ExcelFunctions, #INDEXFunction, #MATCHFunction, #VLOOKUP, #HLOOKUP, #ExcelTutorial, #LearnExcel, #ExcelPro, #SpreadsheetSkills
Переглядів: 0
Відео
Unravelling Data with STDEV & CORREL Excel Intermediate Part 4
Переглядів 687 годин тому
In this intermediate-level Excel tutorial, we delve into the powerful functions STDEV, STDEVP, STDEV.S, STDEV.P, STDEVA, STDEVPA, and CORREL. Learn how to calculate standard deviation and correlation efficiently, analyze data dispersion and relationships, and make informed decisions. We'll cover practical examples and best practices for using these functions in your Excel projects. Similar Chan...
Create Simple & Dynamic Drop Down Menus in Excel of your Own
01. Description Unlock the full potential of Excel with this step-by-step tutorial on creating simple and dynamic drop-down menus! Whether you’re a beginner or intermediate user, this video walks you through: 1️⃣ Building a basic drop-down menu by typing. 2️⃣ Linking a drop-down menu to a cell reference. 3️⃣ Adding logic using IF statements to enhance interactivity. 4️⃣ Combining IF, MID, and V...
Supercharge Your Excel Skills with Advanced Logic #iffunction #andfunction #orfunction #notfunction
In this video, we will learn how to use the advanced logic functions IF, AND, OR, and NOT in Excel. These functions can be used to create powerful formulas that can automate tasks and make your work more efficient. We will start by learning about the IF function. The IF function is used to test a condition and return one value if the condition is true and another value if the condition is false...
Mystery of Excel Statistical Function VAR: #varfunction
Переглядів 128День тому
Mystery of Excel Function VAR: Dive Deeper into Statistical Functions, Intermediate Part-03 Uncover the secrets behind Excel's VAR function and its variants in this intermediate-level tutorial. Learn how to calculate variance, a crucial statistical measure, using VAR, VAR.S, VARPA, VARP, VAR.P, and VARA. Discover their specific applications and understand the nuances between each function. This...
The Wonderful Excel Feature "Define Name"!
01. Description Unlock the Power of Excel's "Define Name" Feature! Tired of typing long cell references? Learn how to simplify your formulas and make your Excel work more efficient with the "Define Name" feature. In this video, we'll explore: What is the "Define Name" feature? How to create a defined name. Practical examples of using defined names. Tips and tricks for effective use of defined n...
Mastering Financial Modelling with Excel PMT, FV, PV, and RATE
Master the art of financial modeling with Excel's powerful functions: PMT, FV, PV, and RATE. In this comprehensive tutorial, you'll learn how to leverage these functions to calculate loan payments, future values, present values, and interest rates. Whether you're a financial analyst, student, or simply curious about personal finance, this video will equip you with the skills to make informed fi...
Advance Excel Functions, PRODUCT MEDIAN & MODE
Переглядів 12714 днів тому
Dive deeper into the world of Excel with this intermediate-level tutorial. Learn how to master advanced functions like PRODUCT, MEDIAN, and MODE. Discover how to use these functions to perform complex calculations, analyze data effectively, and enhance your Excel skills. Similar Channels: Excel Easy Excel Tips Learn Excel MrExcel Leila Gharani Other Search Terms: Excel advanced functions tutori...
Secret Weapons of Excel: Intermediate Skill: Part - 07 #Istext #Isnumbe r#Mid #Value #TEXT(C3,"@")
In this video, we'll delve into some intermediate-level Excel techniques that can significantly boost your productivity. We'll explore functions like MID, VALUE, ISTEXT, and ISNUMBER, and learn how to use them to manipulate and analyze data effectively. Whether you're a data analyst, a financial professional, or simply someone who wants to master Excel, this video will provide valuable insights...
Format Cells Like a Pro in Excel Intermediate Skills Part 06 #excelintermediate #cellformat
This video covers 12 essential Excel formatting tips that will help you create professional and visually appealing spreadsheets. We will discuss how to format cells based on their data type, such as numbers, currency, dates, and text. We will also cover how to use custom formatting to create unique formats for your cells. 02. Similar Channels: ExcelIsFun Exceldemy Leila Gharani Accounting for N...
Beyond the Basics: Excel Formulas:
Переглядів 13621 день тому
Master Excel's Intermediate Functions: A Comprehensive Guide Elevate your Excel skills with this in-depth tutorial on essential intermediate functions. Learn how to perform complex calculations, manipulate text, and analyze data effectively. This video covers: Statistical Functions: SUM, AVERAGE, COUNT, COUNTA, MAX, MAXA, MIN, MINA Text Functions: CONCATENATE, LEN, LEFT, RIGHT, MID, UPPER, LOWE...
Excel TIME SAVING Hacks You Never Knew Existed #dateandtimefunctions #intermediateexcel
In this video, we dive into essential date and time functions in Excel that every intermediate user should know! Learn how to use TODAY and NOW to get the current date and time, extract specific parts of dates with YEAR, MONTH, and DAY, and calculate differences between dates with the DATEDIF function. Perfect for anyone looking to master date and time manipulations in Excel. Whether you're tra...
Clean Up Your Excel Data Learn CLEAN,TRIM, and TEXT
Переглядів 135Місяць тому
Want to make your Excel data cleaner and easier to work with? In this tutorial, we'll cover three essential Excel functions: TRIM, CLEAN, and TEXT. Perfect for beginners, Part 09 of our Excel for Beginners series walks you through real-life examples to remove unnecessary spaces, get rid of unwanted characters, and format your data like a pro. Whether you're cleaning up messy data or preparing i...
Data Entry Made Easy: Validation Techniques, Excel for Beginners Part-08
Переглядів 163Місяць тому
Data Entry Made Easy: Validation Techniques, Excel for Beginners Part-08 Learn essential data entry methods and powerful validation techniques in Excel. This video tutorial covers various methods like typing, pasting, and importing data, along with step-by-step demonstrations of creating data validation rules. Discover how to prevent errors and ensure data accuracy in your spreadsheets. Similar...
Amazing Advanced Statistical Functions! Forecasting and Trend Analysis: Excel Intermediate Part 5
Learn how to leverage powerful statistical functions in Excel to forecast future values and analyze trends. This intermediate-level tutorial covers SKEW and KURT for understanding data distribution, FORECAST and TREND for forecasting, and SMALL and LARGE for identifying extreme values. Master these functions and enhance your data analysis skills. Similar Channels: • ExcelIsFun • MrExcel • Learn...
Create a Combination Chart by Few Clicks:
Переглядів 202Місяць тому
Create a Combination Chart by Few Clicks:
Mastering Charts and Graphs: Excel for Beginners Part 06
Переглядів 484Місяць тому
Mastering Charts and Graphs: Excel for Beginners Part 06
Speed Up Your Workflows Excel for Beginners Part 05
Переглядів 171Місяць тому
Speed Up Your Workflows Excel for Beginners Part 05
Mastering Formulas and Function: Excel for Beginners Part 04 #ExcelTutorial #ExcelTipsForBeginners
Переглядів 2642 місяці тому
Mastering Formulas and Function: Excel for Beginners Part 04 #ExcelTutorial #ExcelTipsForBeginners
Essential Tools and Techniques: Excel for Beginners Part-03 #ExcelBasics #ExcelTutorial #ExcelTips
Переглядів 1352 місяці тому
Essential Tools and Techniques: Excel for Beginners Part-03 #ExcelBasics #ExcelTutorial #ExcelTips
Make your Spreadsheets Shine: Excel for Beginners Part 02
Переглядів 2032 місяці тому
Make your Spreadsheets Shine: Excel for Beginners Part 02
Unvelling The Spread Sheet: Excel for Beginners Part 01 #excel #exceltutorial #excelcalculations
Переглядів 1842 місяці тому
Unvelling The Spread Sheet: Excel for Beginners Part 01 #excel #exceltutorial #excelcalculations
The Power of Shapes Part 04 Modulus of Section
Переглядів 1523 місяці тому
The Power of Shapes Part 04 Modulus of Section
The Power of Shapes: Part - 03 Moment of Inertia of Circular, Trapezoidal & Compound Trapezoidal
Переглядів 633 місяці тому
The Power of Shapes: Part - 03 Moment of Inertia of Circular, Trapezoidal & Compound Trapezoidal
Mass Center Established? Now Let's Talk Moment of Inertia (The Power of Shapes Part -2)
Переглядів 1124 місяці тому
Mass Center Established? Now Let's Talk Moment of Inertia (The Power of Shapes Part -2)
The Power of Shapes: Understanding Mass Centre - Part 1
Переглядів 1104 місяці тому
The Power of Shapes: Understanding Mass Centre - Part 1
The Secret Life of Concrete: How It Handles Pressure #education #longvideo
Переглядів 394 місяці тому
The Secret Life of Concrete: How It Handles Pressure #education #longvideo
Don't Be Stressed! Mastering Material Stress & Strain #education #long
Переглядів 1315 місяців тому
Don't Be Stressed! Mastering Material Stress & Strain #education #long
Understanding EUDL (Equivalent Uniformly Distributed Load) for Structural Analysis
Переглядів 5005 місяців тому
Understanding EUDL (Equivalent Uniformly Distributed Load) for Structural Analysis
Clause 12 Breakdown: Building with Steel - Commentary on IS-456-2000 (Part 18)
Переглядів 825 місяців тому
Clause 12 Breakdown: Building with Steel - Commentary on IS-456-2000 (Part 18)
Great job sir. 1. Name : Şammas Mutlu 2. Country: Türkiye 3. Professional: Student 4. Name of the spread sheet: B.B.S by Excel
Now please check your mail box. Thank you❤🌹.
@@SD_Only thankyou
@sammasmutlu1764 Welcome.
Very nice
Thank you.
This video is very helpful and informative
Thank you❤🌹.
Sir thanks a lot for uploading this video
You are most welcome.
this combined column footing design is very useful as it connects to staad design. I request you to please share this excel sheet to me.🙂
Thanks for your keen interest. Now Please send me an e-mail with your requisition.
Thank you sir for sharing the knowledge…Appreciate all your effort
You are most welcome. I have found your mail where you have written you need pile design. Is it a pile or pile cap? Please write the name of the video.
Sir i needed all sheets from your playlist RCC Pile and Pile Cap (Cast in Situ). Is it possible sir?
Please read the instructions given in the description carefully.
Waiting
Thank you❤🌹.
Can you please share this excel sheet PART 2 (3 PILE CAP DESIGN)
Now please check your mail box. Thank you.
I have received the file. Man of words. Thank you so much Sir.
@manojpandian2158 You are most welcome. Don't forget to watch the whole Episode of Pile cap design. It will be very much helpful for my channel. If I become successful regarding the threshold of 4000 watching hours, I will start StaadProV8I.
kindly request you to share your excel sheet
Now please check your mail box. Thank you.
@SD_Only thank you so much . I really appreciate your hard work . Very useful vedio and excel. Thanks again
@PraveenSinghce Thanks❤🌹.
Very much informative and knowledgeable..... Sir thanks a lot for uploading this video
Thank you.
@SD_Only sir kindly make a video on office attendance sheet ( time duration on week or month)
@avikchatterjee9317 During the DIY Project I must try to do that. Thanks for your suggestions.
@@SD_Only sir thanks a lot
This is very quick and speed up in making ra bill quantity for construction bill... Name :- Jagdish Country:- india Professional:- civil engineer Required sheet:- exle sheet of bbs of footing,beam,column,slab
Now Please Check your mail box And Thanks for your comments.
Hi brother. Need this sheet ASAP. please help
Now Please read the description and send me an e-mail along with your requisition. ASAP.
@@SD_Onlyi have done that.
Sir I have mailed the required information. Please share the file if possible. I require it urgently.
@993akash Now please check your mail box. Thank you.
SIR KINDLY MAKE A VIDEO ON CONDITIONAL FORMATTING.
O. K.
Sir I worship your hard work. Thanks for making this video
Thank you.
Waiting
Thank you.
Waiting
@imrankhanworldd Thanks for your keen interest.
Sir this video is very much informative and knowledgeable. Sir thanks a lot for uploading
Thank you.
@SD_Only happy Kali Puja And happy deepawali
@avikchatterjee9317 Thanks and same to you.
Very nice
Thank you.
ua-cam.com/video/YPX-JIy0n08/v-deo.html
Amazing sir
Thank you.
Thanks for making and uploading
Thank you.
Great video. Paste special is very interesting
Thank you.
Very useful video
Thank you.
sir please send excel.
Now please check your mail box. Thank you.
@@SD_Only Thank you sir.Its very useful.Please make a video on mat foundation.
Learn lot of things . Thank you sir.
You are most welcome.
Sir you have made amazing excel sheet for slab design. thank you so much.may god give you health and wealth.
Thank you.
Two way slab design excel sheet
Very useful.sir I have sent mail for excel sheet
In the mail you have written, "Sir plz send two slab design excel sheet." I can't understand which sheet you are talking about. Please mention the title of that video in the comments of UA-cam. Thank you. Thank you.
RCC slab design excel sheet
Please go to that video on UA-cam and in the comment section of that video just write "This sheet", then it will be easier to understand. Thank you.
@@SD_Only thank you sir
Now please check your mailbox. Thank you.
Sir it is very helpful and informative. Thanks a lot
Thank you❤🌹.
Name akash chakraborty From India 4th year student Need 4 column combine footing
Now please check your mail box. Thank you.
@@SD_Only Thank you sir
@akashchakraborty8254 you are most welcome.
Very Rate vedeo for combined footing of multiple columns. Thanks.
Now please check your mail box. Thank you❤🌹.
Sir is it possible to create stress vs strain curve in excel
Yes.
Yes sir we are feeling confidence
Thank you.
D. Both (b) & (c)
Right.
Vishal India Student Excel sheet:02S for wind load
Please check your mail box. Thank you.
Thank you sir for sharing it
@vishalkumawat792 if you find any discrepancy didn't forget to intimate me. Thank you.
Good Work Sir
Thank you so much❤😊.
Sir thanks a lot for making this video
You are most welcome.
Sir kindly send the excel sheet for eccentric footing
Now please check your mail box and don't forget to acknowledge that you have received the file through UA-cam comments. Not through E-mail. Thank you.
@@SD_Only thank you sir received the email
very much informative........................... sir thanks a lot
Thank you.
Practical and very good 1. Name:Saeed soleimani 2. Country :Iran 3. Profession - Civil Engineer 4. Spreadsheet B.B.S by Excel
Please Send me an e-mail with your requisition. Thank you.
Now please check your mail box. After receiving the file don't forget to send an acknowledgement through UA-cam comments, not through E-mail.
Thanks sir I received excel sheet. Thanks God bless you.
@saeedsoleimani8207 Thank you for acknowledgement.
@@SD_OnlyCan T14 size rebar be added to the sheet? This size of rebar is used in our country, thank you
Sir kindly share the Ultimate solution for BBS excel sheet
Now please send me an e-mail with your requisition. Thank you.
How can i get the excel sheet
Now send me an e-mail with your requisition. Thank you.
BBS EXCEL SHEET NAME MOHAMMAD MOHSIN PROFESSION CIVIL ENGINEER NATIONALITY INDIAN PRACTICAL KNOWLEDGE THE WAY YOU EXPLAIN IS EASY TO UNDERSTAND SIR
@scitcivil7623 Now read the description below the video and you will find my mailing address and send me an E-mail along with your requisition. Thank you.
EXCEL OLPO SOLPO JANTAM. KINTU ETA JANTAM NA. VIDEO TA AMAR UPOKARE LOGLO. THANKS A LOT SIR.........
Thanks for the compliment.
@@SD_Only 🙏🙏🙏🙏
Waiting
Fariz France Professional Sheet N° 1 Tank you very match I send you my email
Thank you sir
Very much helpful
Waiting
Sir thanks a lot and waiting for the video
You are most welcome.
Please
Now please send me an E-mail, with your requisition. Thank you.
Super
Thanks.
Channel Name Suggestions: Excel Mastery
Thanks for your Mastery. 🙏🙏😇🙂🙃
sir I am also waiting for your response
Please wait a few more days.