- 272
- 1 447 113
Spreadsheet Power
Nepal
Приєднався 19 сер 2020
Welcome to Spreadsheet Power UA-cam channel!🙏
In this channel, we will provide you the video tutorials and learning materials related with Microsoft Excel, Google Sheets and other spreadsheet applications. Our goal is to enhance your knowledge and skills for using spreadsheets.
The content provided on this channel is for educational and informational purposes only, based on the creator's knowledge and experience with spreadsheet tools like Microsoft Excel and Google Sheets. While every effort has been made to ensure the accuracy of the information shared, the creator cannot guarantee error-free results and is not responsible for any issues, data loss, or damages that may occur from following the tutorials. Viewers are advised to test any formulas, scripts, or techniques in a safe environment and apply them at their own discretion. For specific professional advice, consult a qualified expert.
In this channel, we will provide you the video tutorials and learning materials related with Microsoft Excel, Google Sheets and other spreadsheet applications. Our goal is to enhance your knowledge and skills for using spreadsheets.
The content provided on this channel is for educational and informational purposes only, based on the creator's knowledge and experience with spreadsheet tools like Microsoft Excel and Google Sheets. While every effort has been made to ensure the accuracy of the information shared, the creator cannot guarantee error-free results and is not responsible for any issues, data loss, or damages that may occur from following the tutorials. Viewers are advised to test any formulas, scripts, or techniques in a safe environment and apply them at their own discretion. For specific professional advice, consult a qualified expert.
Excel VBA Tutorial | Types of IF Statement in VBA | Chapter 14
Welcome to chapter 14 tutorial on Excel VBA tutorial. In this chapter you will learn the different types of IF statements in VBA. IF statements are used for logical calculations in VBA.
Download the sample workbook to practice IF function form below link.
Download the sample workbook to practice IF function form below link.
Переглядів: 21
Відео
Excel VBA Chapter 13 | Do Until Loop
Переглядів 1064 години тому
Welcome to chapter 13 tutorial on learning Excel VBA basic to advanced. In this tutorial you will learn how to use do until loop in VBA. Download the practice workbook file from below link. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C13.zip
Excel VBA Chapter 12 | Do While Loop
Переглядів 929 годин тому
Welcome to Excel VBA Chapter 12 tutorial. Here you will learn how to use do while loop in VBA. Download the Excel workbook to practice this from below link. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C12.zip
SUMPRODUCT Function in Google Sheets
Переглядів 6514 годин тому
Learn how to use SUMPRODUCT function in Google Sheets. Practice SUMPRODUCT function in Google Sheets by opening Google sheets from below given link.
Excel VBA Tutorial Chapter 11 | For Each Next Loop
Переглядів 16619 годин тому
Welcome to Excel VBA tutorial chapter 11. Here you will learn how to use the for each next loop in VBA with multiple examples. Download the sample Excel workbook file from below. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C11.zip
Excel VBA Tutorial Chapter 10 | Loop in VBA | For Next Loop
Переглядів 158День тому
Welcome to Excel VBA tutorial chapter 10 tutorial. In this tutorial, you will learn what is Loop in VBA. Out of different types of loop, here we will discuss about for next loop. Download the sample workbook to practice it from below link. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C10.zip
Excel VBA Tutorial Chapter 9 | Variable in VBA and Data Types
Переглядів 137День тому
Welcome to Excel VBA tutorial chapter 9 video. Here you will learn what is variable in VBA, Variable data types and how to define the variable and use them in coding. Download the sample workbook file to practice this from the link below. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C9.zip
Excel VBA Tutorial Chapter 8 | Row, Column & Sheet Manipulation
Переглядів 10014 днів тому
Welcome to this Excel VBA Tutorial Chapter 8 video. In this video you will learn how to do Row, Column & Sheet manipulation using the VBA code. Download the workbook file to practice from below link. learnexcelandsheets.com/wp-content/uploads/2025/01/Excel-VBA-C8.zip
Excel VBA Tutorial Chapter 7 | With Block in VBA
Переглядів 15214 днів тому
Welcome to this Excel VBA Tutorial chapter 7 video. Here you will learn how to simplify VBA code by using the with block. Download the sample workbook file to practice it from below link. learnexcelandsheets.com/wp-content/uploads/2024/12/Excel-VBA-C7.zip
Excel VBA Tutorial Chapter 6 | Changing Font Property, Borders and Text Alignment
Переглядів 12514 днів тому
Welcome to Excel VBA tutorial video series chapter 6. This video has described the VBA codes to change the font property, apply borers and change the text alignment and orientation. Download the sample workbook file from the link below. learnexcelandsheets.com/wp-content/uploads/2024/12/Excel-VBA-C6.zip Learn how to set up macro enabled excel file for first use: learnexcelandsheets.com/guidelin...
Excel VBA Tutorial Chapter 5 | Methods of Data Copy Paste
Переглядів 9914 днів тому
Welcome to Excel VBA Tutorial chapter 5 video. Here you will learn the methods of data copy and paste using VBA code. Download practice workbook from below link. learnexcelandsheets.com/wp-content/uploads/2024/12/Excel-VBA-C5.zip Learn how to set up macro enabled workbook for first use: learnexcelandsheets.com/guideline-to-download-and-use-excel-vba-templates/
Excel VBA Tutorial Chapter 4 | Writing VBA Code | Step Into | Sheet Referencing
Переглядів 27321 день тому
Welcome to Excel VBA Tutorial Chapter 4. In this tutorial, you will learn how to write code in VBA, how to execute code step by step using step into tool and how to reference the sheets in VBA.
Excel VBA Tutorial | Chapter 3 | User Interface
Переглядів 17921 день тому
Excel VBA Tutorial | Chapter 3 | User Interface
How to Auto Generate Invoice Number and Date in Excel
Переглядів 560Місяць тому
How to Auto Generate Invoice Number and Date in Excel
Google Sheets Table Tool | Convert Data to Structured Table
Переглядів 67Місяць тому
Google Sheets Table Tool | Convert Data to Structured Table
Pull Data From One Sheet to Another Based on Condition in Google Sheets
Переглядів 179Місяць тому
Pull Data From One Sheet to Another Based on Condition in Google Sheets
How to Calculate CAGR in Google Sheets
Переглядів 1532 місяці тому
How to Calculate CAGR in Google Sheets
Basic Use of IF Function in Google Sheets
Переглядів 822 місяці тому
Basic Use of IF Function in Google Sheets
IF Function in Excel (4 Basic to Advanced Examples)
Переглядів 2002 місяці тому
IF Function in Excel (4 Basic to Advanced Examples)
Moneytext Function in Google Sheets | Convert Currency Numbers to Text
Переглядів 2682 місяці тому
Moneytext Function in Google Sheets | Convert Currency Numbers to Text
How to Make Sheets From a Name List in Excel
Переглядів 1592 місяці тому
How to Make Sheets From a Name List in Excel
Hyperlink in Excel | Create Link to Cell, Sheet, File and URL
Переглядів 3192 місяці тому
Hyperlink in Excel | Create Link to Cell, Sheet, File and URL
Combine Multiple Sheets Data to One Using VSTACK Function
Переглядів 7103 місяці тому
Combine Multiple Sheets Data to One Using VSTACK Function
Formula to Display Sheet Name in a Cell in Excel
Переглядів 1273 місяці тому
Formula to Display Sheet Name in a Cell in Excel
TOCOL and TOROW Function in Excel | Useful New Excel Functions
Переглядів 1253 місяці тому
TOCOL and TOROW Function in Excel | Useful New Excel Functions
Import Data From Website | Edit Using Power Query Editor in Excel | Super Useful for Data Analyst
Переглядів 6093 місяці тому
Import Data From Website | Edit Using Power Query Editor in Excel | Super Useful for Data Analyst
I have a spreadsheet that lists the number of bedrooms in a given apartment and then next to it the type of apartment. It is similar to your example if "Department A" = "Apartment A", Target = "Number of Bedrooms" and Archiv = "Type of Apartment". For instance i want to count the number of 1 Bedrooms in a given Row if the type = Affordable. I am having difficulties setting up the function.
اشكرك ارجو الترجمه الي اللغه العربيه يمكن استخدام الترجمة الصوتيه العربيه
Why is it worth learning how to make VBA code when an artificial intelligence program can do it for you? I think you should focus on learning how to use artificial intelligence, what end result it should produce, and testing the code. I have made a very versatile investment program using artificial intelligence to automate it. I have done this in my native language, Finnish.
Its better to understand the basics before using AI. For the beginners its important to understand how vba works. Once understanding the basics terms and coding technique, we can use AI. Hope this makes sense.
Thank you so much dude, hope you live a long life ❤❤❤
Thanks dear its working
how it lock formula i cant find which button you press keyboard
Its the F4 key
Thank you.
Welcome 🙏
Thank you so much! I couldn't find any help online, but this video explains it clearly and easily!
You're welcome! Glad to help.
Hi! How to insert a hiperlink in a cell that consists of several sentences. Thank you!
You mean to create hyperlink in only one word among multiple words in a cell?
@spreadsheet_power I meant a hiperlink in the middle of a sentence in a cell!
Thank you for sharing!
Welcome!
Sir, for sale/purchase how to add invoice no
It can be added by modifying the Userform and VBA codes.
@spreadsheet_power thanks
Thank you a million!
Welcome 🤗
I'm facing problem,,once done it's showing #SPILL! In the cell
Spill error happens due to blockage in the range where the result is trying to populate. Make sure all cells are blank (right and down) from the first formula cell.
ty bro
Welcome 🙏
Please sir, is there any way where you can search for date without converting it to number format?
And if you have to do several countries? How does this work? Right now it only works for one row. And OI have thousands of rows...
My man, thank you so much! I watched 4 tutorials and this is the best and the fastest one! Thank you again!
Welcome and thank you 🙏
templet not able to download pls enable to download
You are amazing!! Thank you for making my life sooooo much easier :)
Welcome 🙏
Hello sir, Happy New Year thank you very neatly explained vba basics...
Happy New Year to you too! Thank you for appreciating
Hi. Happy New Year. I do not see the link to downlaod the file
Will upload soon, thank you for noticing 🙏
Unable to access practice workbook file
Unable to access practice workbook file
Thanks for the clear explanation
Welcome 🙏
thks bro.
Welcome
how to contact with you e mail or contact number please
Hi Dear Sir. i downloaded but now showing Spreadsheet Power stamp is it possible to remove ?
Please write a mail to spreadsheetforu@gmail.com for template with no stamp
@@spreadsheet_power Hi Good day i already send e mail to you twice and waiting your replay please
@@mohammadyounas5495 I have sent you the file in Email just now. Please check and confirm.
Help with the formula its not clear
Which part of the formula you are having problem?
Now the question is? Why learn to code, when you can do everything with artificial intelligence? I have thought of myself as an application developer and artificial intelligence as a coder. I have made very complex excel applications myself. An ordinary user can use artificial intelligence to make their own cell tests.
Before using AI for generating codes, it better to have basic knowledge of VBA and how it works. Thease early chapters are for the learners who are new to VBA. After learning basics, we can get help from AI to write codes for our projects. Hope this makes sense.
What IS your excel version ? I have excel 365 but i cannt find the fonction filter ?!
Filter function should be in Excel 365, is your software updated?
PLEASE PROVIDE SHEET
This formula not showing in my excel 2024
Only available in ms office 365
Thank you very much for this tutorial. Makes things very easy.
Welcome! Glad it helped!
There is no download link for the data
Thank you so much ..❤❤ its really working ..💐🙏🙏
Welcome 🙏
Can we add unit coloum then final bal. Quantity is right show
Yes, it can be done
The link is not working, please update. Thank you.
The link should be working fine. What error did you get?
worked for me, i have a question, what if I don’t want the table to appear unless I search for something
good
AFTER PRESSING "SAVE WB" BUTTON ? HOW CAN I DELETE ALL THE ITEMS IN "SHOW DETAILS" SECTION ?????
SIR PLZ SEND ME PASSWORD
To use this template, no password is required. Password is for vba project. It is protected to avoid unwanted change in code.
@spreadsheet_power change for out product price
WAW
Where is this file
❤
thaaankkkk u broooo, new subscriber from Indonesia
Excellent video! I've been looking for the min across multiple rows formula. Thanks for the three versions in one video! it was the $ on row name only I was missing! Thank you!
Thanks and welcome
please prepare in amharic language 1:56
እባክዎ ከቻሉ በአማርኛ ያርጉልን
It's really helpful video Thank you very much 👏
Welcome
VBA password plz unlock_im is not working