- 282
- 1 518 174
Spreadsheet Power
Nepal
เข้าร่วมเมื่อ 19 ส.ค. 2020
Spreadsheet Power - Master Excel & Google Sheets Like a Pro!
Welcome to Spreadsheet Power, your ultimate destination for mastering Microsoft Excel and Google Sheets! Whether you're a beginner or an advanced user, our easy-to-follow tutorial videos will help you unlock the full potential of spreadsheets.
What You’ll Learn:
✅ Excel formulas & functions explained simply
✅ Google Sheets formulas & functions explained
✅ Data analysis and visualization
✅ Automation and Application Development using VBA
✅ Spreadsheet Templates and tips on leveraging spreadsheets in Business
Join us and take your spreadsheet skills to the next level! Don’t forget to subscribe and hit the 🔔 bell icon to stay updated with our latest tutorials.
Empower your spreadsheets, boost your productivity! Happy Learning!!!
Welcome to Spreadsheet Power, your ultimate destination for mastering Microsoft Excel and Google Sheets! Whether you're a beginner or an advanced user, our easy-to-follow tutorial videos will help you unlock the full potential of spreadsheets.
What You’ll Learn:
✅ Excel formulas & functions explained simply
✅ Google Sheets formulas & functions explained
✅ Data analysis and visualization
✅ Automation and Application Development using VBA
✅ Spreadsheet Templates and tips on leveraging spreadsheets in Business
Join us and take your spreadsheet skills to the next level! Don’t forget to subscribe and hit the 🔔 bell icon to stay updated with our latest tutorials.
Empower your spreadsheets, boost your productivity! Happy Learning!!!
Types Error and Methods of Error Handling in VBA | VBA Chapter 18
Learn the types of error and methods of error handling in VBA. There are basically two types of error;
1. Compile Error
2. Run Time Error
Methods of handling error;
1. On error resume next
2. On error goto (label)
Download the practice workbook file from the link below.
1. Compile Error
2. Run Time Error
Methods of handling error;
1. On error resume next
2. On error goto (label)
Download the practice workbook file from the link below.
มุมมอง: 57
วีดีโอ
Excel VBA Chapter 17 | Input Box in VBA
มุมมอง 8814 วันที่ผ่านมา
Welcome to chapter 17 tutorial on Excel VBA. In this chapter you will what is input box and how to use it in VBA. Download the sample workbook file to practice this from the link below.
Interacting With VBA Message Box Button Clicks | Excel VBA Chapter 16
มุมมอง 4814 วันที่ผ่านมา
Welcome to chapter 16 tutorial on Excel VBA basic to advanced. In this chapter you will learn how to interact with the user response or button clicks of VBA message box. Download the sample workbook to practice this from the link below.
Excel VBA Tutorial Chapter 15 | Message Box in VBA
มุมมอง 3421 วันที่ผ่านมา
Welcome to Excel VBA tutorial chapter 15. In this chapter you will learn what is message box and how to display message box in VBA.
Learn Excel with Google AI Studio | STOP🛑 Watching Tutorials🫢
มุมมอง 62321 วันที่ผ่านมา
Learn Excel with Google AI Studio. In this tutorial you will learn how to learn Excel with Google AI studio. If you face a problem while working in Excel, you can directly share your Excel screen to Google AI studio and it will provide you the instructions to solve the problem.
Excel VBA Tutorial | Types of IF Statement in VBA | Chapter 14
มุมมอง 8821 วันที่ผ่านมา
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.
Excel VBA Chapter 13 | Do Until Loop
มุมมอง 13521 วันที่ผ่านมา
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
มุมมอง 11928 วันที่ผ่านมา
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
Excel VBA Tutorial Chapter 11 | For Each Next Loop
มุมมอง 186หลายเดือนก่อน
Excel VBA Tutorial Chapter 11 | For Each Next Loop
Excel VBA Tutorial Chapter 10 | Loop in VBA | For Next Loop
มุมมอง 171หลายเดือนก่อน
Excel VBA Tutorial Chapter 10 | Loop in VBA | For Next Loop
Excel VBA Tutorial Chapter 9 | Variable in VBA and Data Types
มุมมอง 157หลายเดือนก่อน
Excel VBA Tutorial Chapter 9 | Variable in VBA and Data Types
Excel VBA Tutorial Chapter 8 | Row, Column & Sheet Manipulation
มุมมอง 127หลายเดือนก่อน
Excel VBA Tutorial Chapter 8 | Row, Column & Sheet Manipulation
Excel VBA Tutorial Chapter 7 | With Block in VBA
มุมมอง 158หลายเดือนก่อน
Excel VBA Tutorial Chapter 7 | With Block in VBA
Excel VBA Tutorial Chapter 6 | Changing Font Property, Borders and Text Alignment
มุมมอง 140หลายเดือนก่อน
Excel VBA Tutorial Chapter 6 | Changing Font Property, Borders and Text Alignment
Excel VBA Tutorial Chapter 5 | Methods of Data Copy Paste
มุมมอง 108หลายเดือนก่อน
Excel VBA Tutorial Chapter 5 | Methods of Data Copy Paste
Excel VBA Tutorial Chapter 4 | Writing VBA Code | Step Into | Sheet Referencing
มุมมอง 290หลายเดือนก่อน
Excel VBA Tutorial Chapter 4 | Writing VBA Code | Step Into | Sheet Referencing
Excel VBA Tutorial | Chapter 3 | User Interface
มุมมอง 191หลายเดือนก่อน
Excel VBA Tutorial | Chapter 3 | User Interface
How to Auto Generate Invoice Number and Date in Excel
มุมมอง 1.3K2 หลายเดือนก่อน
How to Auto Generate Invoice Number and Date in Excel
Google Sheets Table Tool | Convert Data to Structured Table
มุมมอง 822 หลายเดือนก่อน
Google Sheets Table Tool | Convert Data to Structured Table
Pull Data From One Sheet to Another Based on Condition in Google Sheets
มุมมอง 1942 หลายเดือนก่อน
Pull Data From One Sheet to Another Based on Condition in Google Sheets
How to Calculate CAGR in Google Sheets
มุมมอง 1742 หลายเดือนก่อน
How to Calculate CAGR in Google Sheets
Basic Use of IF Function in Google Sheets
มุมมอง 992 หลายเดือนก่อน
Basic Use of IF Function in Google Sheets
IF Function in Excel (4 Basic to Advanced Examples)
มุมมอง 2043 หลายเดือนก่อน
IF Function in Excel (4 Basic to Advanced Examples)
Moneytext Function in Google Sheets | Convert Currency Numbers to Text
มุมมอง 3333 หลายเดือนก่อน
Moneytext Function in Google Sheets | Convert Currency Numbers to Text
How to Make Sheets From a Name List in Excel
มุมมอง 1653 หลายเดือนก่อน
How to Make Sheets From a Name List in Excel
Hyperlink in Excel | Create Link to Cell, Sheet, File and URL
มุมมอง 3413 หลายเดือนก่อน
Hyperlink in Excel | Create Link to Cell, Sheet, File and URL
Thank u
Great Help !!! Many thanks !!!!!, it works. I tried various other suggested solution on TH-cam but nothing worked except this .....
Welcome 🙏
This page doesn't seem to exist.
Very usefull tool. Thank You very much.
Thanks for idea ❤
Can i have your contacts plz
spreadsheetforu@gmail.com
Can we connect because it’s not working
Please write a mail to spreadsheetforu@gmail.com along with the attachment of your working file. We will check and reply
Very helpful. Thank you! Is it possible to download the template to Google Sheets, or Excel the only option?
It works in G sheet as well. First download Excel and import in Google sheets. Minor modification may require if something not supported
Can you do document tracking, where for example the agency have multiple departments for example they have 4. Documents are manually handed to the secretary and they logbooked it using a record book. now how about if this is to be developed as document tracking for different department of the agency. Features would be: Sender Name, Receiver Name, Date&TimeToday, Remarks(if it was sent or received) Update, Delete, Refresh. Search in data base list. Where the search is red and automatic display while typing the character or it is like smart searching. then can click the data and can update and save.
Yes, it can be done. I will try to upload video tutorial on this soon.
@spreadsheet_power would greatly appreciate it,
send me the template to just download and start using
Great stuff since day one!!. I cannot find how to download the files. I see no links. Thank you
How can I automatically sent email reminder when date is about to expire in three days?
I think that is possible by using VBA code.
Excuse me, what the exact function of those valuation, what sample decision by the using of valuation thanks
I am not clear on what is the requirement, could you please explain more?
Formula tell me
Thank you this was so helpful
Glad it was helpful!
how about if i have only one customer
but if we delete the sheet online it will also delete the local file here?
Yes, deleting the sheet online will also delete the local file.
th-cam.com/video/Tk8tWA_yYZk/w-d-xo.htmlsi=hbZJg8S4-vi0uAGb
Very useful
Thanks! 🙏
Thanks sir for guiding me, i was so helpful
Welcome 🙏
👌👌👌👌👌👌👌👌👌👌👌👌👌👌
👍👍
Excellent video! I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box. I'll be grateful for any help.
please check the fore color property of text box, it may be set as white. Try changing the color and see if it works.
NOT WORKING HIGHLIGHTER AFTER SAVING MACRO FILE
there must be something wrong in the steps applied. Please check the VBA code. Another reason might be the macros are disabled in your Excel. Check in the macro security settings of Excel.
I m impressed....ah..what made excel think that this is not an important function to add by default
I also have the same question, why Excel is not adding this important function in the list. It might be because the need of number to word function is for dealing with the currency values. And, the currency name is different for every country. But, Excel should somehow include this much needed function in the list. Let's hope!!
@@spreadsheet_power such format can be applied later..but converting number to words is basic need
THANK YOU!!!❤❤❤
Welcome 🙏
Great tutorial love this man
Thank you
Thank you for sharing your knowledge, you are very kind. 👍
My pleasure!
can you please send the workbook
Dear this not work in excel on mac Could you please tell us how to do it on mac
In which part this didn't work? Any function not available or the same formula didn't work? Could you explain?
@spreadsheet_power developer part not complete in Ios excel
Thank you 🙏
Welcome!
Thank you! This solved my problem!!
Welcome 🤗
❤
❤️
Hii thank you so much for your tutoria 🙏🏻 it very helpful. But isn't the stock in and out will be longer than the balance, so every time we want to see the balance, we have to scroll up? Do you have any recommendations for this issue?
For this, you can keep stock in , out and balance in 3 different sheets. You can also try this different template for tracking stock in out and balance. th-cam.com/video/55ZzTpKhO_o/w-d-xo.htmlsi=MTw383R2r9IvUUWR
@spreadsheet_power Thank you for your suggestions, surely will check it out
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.
I think your requirement will fulfill by SUMIF function Please watch this tutorial: th-cam.com/video/LtldGspLGQ0/w-d-xo.html
اشكرك ارجو الترجمه الي اللغه العربيه يمكن استخدام الترجمة الصوتيه العربيه
Thank you for the suggestion
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 ❤❤❤
Thank you too
Thanks dear its working
Welcome
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 🙏