- Видео 107
- Просмотров 63 749
MS Excel Training
Непал
Добавлен 7 мар 2024
Welcome to MS Excel Training channel. Our goal is to make you master in Excel. Stay connected and enjoy learning.
Do While Loop in VBA | Macro and VBA Chapter 19
Welcome to this chapter 19 video on Macro and VBA tutorial. In this video, you will learn how to use do while loop in VBA. Do while loop will execute a block of code while the condition is true.
Просмотров: 6
Видео
For Each Next Loop in VBA | VBA and Macro Chapter 18
Просмотров 163 часа назад
Learn how to use the for each next loop in VBA. For each next loop is used to iterate a code over a collection of objects.
Data Analysis in Excel | Find Insights from Business Data
Просмотров 1505 часов назад
In this tutorial, you will learn data analysis in Excel. By using the built in tool of Microsoft Excel, you can quickly and easily find various insights from your data. This helps you on better understanding on what exactly is happening and make action plan for future. Download sample data for practice from below link. 1drv.ms/x/s!AohAxi9JX1lu3kV8grZQ7bDtvG9q?e=S4phsa
Loop in VBA | For Next Loop | VBA and Macro Chapter 17
Просмотров 208 часов назад
In this chapter 17 tutorial on VBA and Macro video series, you will learn what is loop, types of loop and how to use the for next loop in VBA. Looping is used for iterating a block of code multiple times.
Use Copilot for Learning Excel
Просмотров 15410 часов назад
In this tutorial, you will learn how you can use Microsoft Copilot for learning Excel.
Variables in VBA | Variable Data Types | Macro and VBA Chapter 16
Просмотров 3712 часов назад
In this chapter 16 video tutorial, you will learn what is variables in VBA. How to Declare variable. The types of variable data. And, how to use the variables in the coding.
Copy and Move Sheet using VBA Code | Macro and VBA Chapter 15
Просмотров 2115 часов назад
Welcome to this chapter 15 video tutorial on learning Macro and VBA basic to advanced. In this chapter, we will learn how to copy and move sheet by using the VBA code.
EOQ Calculation in Excel | Economic Order Quantity
Просмотров 4017 часов назад
Learn how to calculate the economic order quantity in Microsoft Excel. This is one of the very useful concept in inventory management.
How to Make Employee Attendance Sheet in Excel | Step by Step Guide
Просмотров 20720 часов назад
How to Make Employee Attendance Sheet in Excel | Step by Step Guide
Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 14
Просмотров 2320 часов назад
Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 14
Hide Unhide Row Column Using VBA Code
Просмотров 1522 часа назад
Hide Unhide Row Column Using VBA Code
Insert and Delete Row Column in VBA | Macro and VBA Chapter 12
Просмотров 14День назад
Insert and Delete Row Column in VBA | Macro and VBA Chapter 12
Change Text Orientation Using Macro | Macro and VBA Chapter 11
Просмотров 31День назад
Change Text Orientation Using Macro | Macro and VBA Chapter 11
Use Paste Special in VBA | Macro and VBA Chapter 10
Просмотров 14День назад
Use Paste Special in VBA | Macro and VBA Chapter 10
How to Calculate Seasonal Index in Excel
Просмотров 8014 дней назад
How to Calculate Seasonal Index in Excel
Auto Highlight Active Cell's Column in Excel
Просмотров 15114 дней назад
Auto Highlight Active Cell's Column in Excel
How to Auto Highlight Selected Row and Column in Excel
Просмотров 12121 день назад
How to Auto Highlight Selected Row and Column in Excel
Auto Highlight Active Cell's Row in Excel
Просмотров 31221 день назад
Auto Highlight Active Cell's Row in Excel
XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period
Просмотров 7721 день назад
XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period
Insert Blank Columns After Every Column in Excel
Просмотров 31628 дней назад
Insert Blank Columns After Every Column in Excel
Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 8
Просмотров 5628 дней назад
Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 8
Using With Block in VBA | Macro and VBA Tutorial - Chapter 7
Просмотров 74Месяц назад
Using With Block in VBA | Macro and VBA Tutorial - Chapter 7
Macro and VBA Chapter 9 | Methods of Sheet Referencing
Просмотров 29Месяц назад
Macro and VBA Chapter 9 | Methods of Sheet Referencing
Change Font Property Using Macro Codes | Macro and VBA Tutorial Chapter 7
Просмотров 48Месяц назад
Change Font Property Using Macro Codes | Macro and VBA Tutorial Chapter 7
VBA Code for Copy and Paste Data in Excel | Macro and VBA Tutorial - Chapter 5
Просмотров 99Месяц назад
VBA Code for Copy and Paste Data in Excel | Macro and VBA Tutorial - Chapter 5
VBA User Interface & How to Write and Run Macros in VBA | Macro and VBA - Chapter 4
Просмотров 126Месяц назад
VBA User Interface & How to Write and Run Macros in VBA | Macro and VBA - Chapter 4
SUM and XLOOKUP Function Combination in Excel
Просмотров 430Месяц назад
SUM and XLOOKUP Function Combination in Excel
How to Make Live Digital Clock in Microsoft Excel
Просмотров 191Месяц назад
How to Make Live Digital Clock in Microsoft Excel
How to Set Up Background Image in Excel
Просмотров 213Месяц назад
How to Set Up Background Image in Excel
Record and Re Use Macro | Save Macro Enabled Workbooks | Macro and VBA Chapter 3
Просмотров 132Месяц назад
Record and Re Use Macro | Save Macro Enabled Workbooks | Macro and VBA Chapter 3
My stock balance is not automatically updating and I followed the steps correctly Pls I need help here
If possible, share your working file to msexceltraining24@gmail.com, We will check for the issue and reply.
@@ms-excel-training Thanks i have sent a mail.
How i can enter same item, if the item price is changed in future ??
This template has focused on quantity part only, price is not considered. Tracking with price becomes more complicated since price changes frequently.
@@ms-excel-training well, if you can do a video for same item with different price it will be appreciated, thank you for your help
Thank you for this insighful
Glad to hear, welcome 🙏
What's the deal with this function?
The SUBSTITUTE function in Excel is used to replace occurrences of a specific substring within a text string with another substring. It is particularly useful for text manipulation tasks.
why i can not download this files guy.? thanks you
Click on file tab , then download a copy. If this still doesn't work, write a mail to msexceltraining24@gmail.com, will share the file there
@@ms-excel-training Yes, Thank you so much guy 🌻🙏
Well explained, thank you
Welcome and many thanks 🙏
Please make it also attendance sheet link with salary sheet. , thanks in advance.
Noted. Thank you for the suggestion.🙏
Thanks
Welcome
Need delete option please
Will upload soon, with the delete button.
What will happen if a new item is added in the future?
Any new item should be entered in stock balance section first, before entering any in out transaction. After new item is added, it will reflect in item selection drop down.
Thank you very much.
You are welcome!
The formula is too lengthy just to minus 4 into 20
In stock IN and Out range, items will repeat multiple times, so the straightforward method of 20-4 does not work as soon as you enter repeat item transaction.
@@ms-excel-training Got it 👍
This nice and easy to understand i will use it
Thank you 🙏
simple and easy to follow steps.
Thank you 🙏
thank you, really useful!
Welcome 🙏
Very Good
Thank you 🙏
Hello, i have downloaded the application , i extracted it, but when i try to open the application by clicking on buttom template there is an error message '' execution error 2147352571 (80020005) '' . PLease would you like to help me to solve the problem. Thank you .
This was very good and informative!!
🙏🙏
,,
If possible send me a table with Stock In and stock out (purchased price, Sold price ) for the same items in the table to find out the benefit. Tnx
Pls see if this fulfills your requirement: ruclips.net/video/OWhIbfHn1qc/видео.html
Thank you for the very direct teaching, was easy to follow and apply.
Great to hear!
Thank you, It is easy to understand and complete.
Welcome
I need the picture you're using where can i find it please
Images can be downloaded from internet or you can create your own by using image designer software.
@@ms-excel-training i want this 😂🤣 send me as a link
Can you please provide practice excel sheets for this.
get the practice workbook file from below onedrive link. 1drv.ms/x/s!AohAxi9JX1lu3DGcZEFf2yQsq3kq?e=edwgZY
Mine showing type mismatch why ??
This happened because of code mismatch. Please recheck if the code is exactly same as shown in video.
tnx a lot
Welcome 🙏
download is not working (File)
It has been fixed now. Please retry.
Thank you boss. Very useful. 🙏
You're welcome!
Very good, thanks.
Thank you
Employee Shift change calendar Shift change 15 days a month two time Change shift one person, highlights night shift work to colour and night shift days highlights to another colour.😊 How it works
Please make the requirement more clear You can write mail to: msexceltraining24@gmail.com Please attach your practice workbook if possible
Hello ma'am we can highlight day number 15 day line color and 15 day line color in a month and yearly calendar color Make one calendar for the year One person
Could you please make it more clear? What is the requirement
Please can I get your email id@@ms-excel-training
Thanks teacher
Welcome 🙏
Simple and easy to follow, thank you for this tutorial
Thank you
Thanks for this Video from Germany
Welcome 🙏, thank you for the comment
Very useful, it will help me in my work, keep uploading great tutorials
Glad to hear that
Good tutorial
Thank you 🙏
Remarkable
Thank you 😊
Data validation pls
Thank for suggestion, will upload soon