MS Excel Training
MS Excel Training
  • 113
  • 69 093
How to Protect Excel Workbook With Password
Learn how to protect Excel workbook with password.
This quick tutorial covers everything you need to know to keep your data safe, from setting a password to removing or changing it. Perfect for protecting sensitive information in just a few simple steps.
👍 Don't forget to LIKE, SHARE, and SUBSCRIBE for more quick Excel tips!
zhlédnutí: 18

Video

IF Statement in VBA | Simple IF and IF with Do While Loop4:19IF Statement in VBA | Simple IF and IF with Do While Loop
IF Statement in VBA | Simple IF and IF with Do While Loop
zhlédnutí 33Před 9 hodinami
Welcome to this chapter 21 tutorial on learning VBA for excel. In this chapter, you will learn how to use the IF statement in Excel. You will learn simple IF statement and IF statement combined with do while loop.
Do Until LOOP in VBA | VBA and Macro Chapter 201:28Do Until LOOP in VBA | VBA and Macro Chapter 20
Do Until LOOP in VBA | VBA and Macro Chapter 20
zhlédnutí 13Před 12 hodinami
In this chapter, you will learn how to use the Do Until loop in VBA. Do until loop is used for iterating a block of code until the condition is true. In other words, it keeps on repeating the code, when the condition returns false. Do while loop tutorial: czcams.com/video/efV6k4bqCtw/video.html
Do While Loop in VBA | Macro and VBA Chapter 193:39Do While Loop in VBA | Macro and VBA Chapter 19
Do While Loop in VBA | Macro and VBA Chapter 19
zhlédnutí 13Před 14 hodinami
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.
For Each Next Loop in VBA | VBA and Macro Chapter 183:03For Each Next Loop in VBA | VBA and Macro Chapter 18
For Each Next Loop in VBA | VBA and Macro Chapter 18
zhlédnutí 23Před 16 hodinami
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 Data3:47Data Analysis in Excel | Find Insights from Business Data
Data Analysis in Excel | Find Insights from Business Data
zhlédnutí 212Před 19 hodinami
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 174:03Loop in VBA | For Next Loop | VBA and Macro Chapter 17
Loop in VBA | For Next Loop | VBA and Macro Chapter 17
zhlédnutí 30Před 21 hodinou
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 Excel1:45Use Copilot for Learning Excel
Use Copilot for Learning Excel
zhlédnutí 185Před dnem
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 168:04Variables in VBA | Variable Data Types | Macro and VBA Chapter 16
Variables in VBA | Variable Data Types | Macro and VBA Chapter 16
zhlédnutí 43Před dnem
Variables in VBA | Variable Data Types | Macro and VBA Chapter 16
Copy and Move Sheet using VBA Code | Macro and VBA Chapter 153:35Copy and Move Sheet using VBA Code | Macro and VBA Chapter 15
Copy and Move Sheet using VBA Code | Macro and VBA Chapter 15
zhlédnutí 26Před dnem
Copy and Move Sheet using VBA Code | Macro and VBA Chapter 15
EOQ Calculation in Excel | Economic Order Quantity2:18EOQ Calculation in Excel | Economic Order Quantity
EOQ Calculation in Excel | Economic Order Quantity
zhlédnutí 47Před dnem
EOQ Calculation in Excel | Economic Order Quantity
How to Make Employee Attendance Sheet in Excel | Step by Step Guide10:35How to Make Employee Attendance Sheet in Excel | Step by Step Guide
How to Make Employee Attendance Sheet in Excel | Step by Step Guide
zhlédnutí 245Před 14 dny
How to Make Employee Attendance Sheet in Excel | Step by Step Guide
Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 146:26Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 14
Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 14
zhlédnutí 27Před 14 dny
Create, Rename, Delete, Hide and Unhide Sheet Using VBA Code | Chapter 14
Hide Unhide Row Column Using VBA Code2:12Hide Unhide Row Column Using VBA Code
Hide Unhide Row Column Using VBA Code
zhlédnutí 21Před 14 dny
Hide Unhide Row Column Using VBA Code
Insert and Delete Row Column in VBA | Macro and VBA Chapter 120:59Insert and Delete Row Column in VBA | Macro and VBA Chapter 12
Insert and Delete Row Column in VBA | Macro and VBA Chapter 12
zhlédnutí 18Před 14 dny
Insert and Delete Row Column in VBA | Macro and VBA Chapter 12
Change Text Orientation Using Macro | Macro and VBA Chapter 110:48Change Text Orientation Using Macro | Macro and VBA Chapter 11
Change Text Orientation Using Macro | Macro and VBA Chapter 11
zhlédnutí 34Před 14 dny
Change Text Orientation Using Macro | Macro and VBA Chapter 11
Use Paste Special in VBA | Macro and VBA Chapter 101:05Use Paste Special in VBA | Macro and VBA Chapter 10
Use Paste Special in VBA | Macro and VBA Chapter 10
zhlédnutí 16Před 14 dny
Use Paste Special in VBA | Macro and VBA Chapter 10
How to Calculate Seasonal Index in Excel1:53How to Calculate Seasonal Index in Excel
How to Calculate Seasonal Index in Excel
zhlédnutí 92Před 21 dnem
How to Calculate Seasonal Index in Excel
Auto Highlight Active Cell's Column in Excel2:02Auto Highlight Active Cell's Column in Excel
Auto Highlight Active Cell's Column in Excel
zhlédnutí 186Před 21 dnem
Auto Highlight Active Cell's Column in Excel
How to Auto Highlight Selected Row and Column in Excel1:54How to Auto Highlight Selected Row and Column in Excel
How to Auto Highlight Selected Row and Column in Excel
zhlédnutí 131Před 28 dny
How to Auto Highlight Selected Row and Column in Excel
Auto Highlight Active Cell's Row in Excel1:50Auto Highlight Active Cell's Row in Excel
Auto Highlight Active Cell's Row in Excel
zhlédnutí 328Před měsícem
Auto Highlight Active Cell's Row in Excel
XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period3:04XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period
XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period
zhlédnutí 87Před měsícem
XIRR Function in Excel | Internal Rate of Return for Uneven Cash Flow Period
Insert Blank Columns After Every Column in Excel1:44Insert Blank Columns After Every Column in Excel
Insert Blank Columns After Every Column in Excel
zhlédnutí 347Před měsícem
Insert Blank Columns After Every Column in Excel
Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 81:37Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 8
Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 8
zhlédnutí 57Před měsícem
Border and Alignment in VBA | Macro and VBA Tutorials - Chapter 8
Using With Block in VBA | Macro and VBA Tutorial - Chapter 72:30Using With Block in VBA | Macro and VBA Tutorial - Chapter 7
Using With Block in VBA | Macro and VBA Tutorial - Chapter 7
zhlédnutí 74Před měsícem
Using With Block in VBA | Macro and VBA Tutorial - Chapter 7
Macro and VBA Chapter 9 | Methods of Sheet Referencing3:50Macro and VBA Chapter 9 | Methods of Sheet Referencing
Macro and VBA Chapter 9 | Methods of Sheet Referencing
zhlédnutí 29Před měsícem
Macro and VBA Chapter 9 | Methods of Sheet Referencing
Change Font Property Using Macro Codes | Macro and VBA Tutorial Chapter 73:09Change Font Property Using Macro Codes | Macro and VBA Tutorial Chapter 7
Change Font Property Using Macro Codes | Macro and VBA Tutorial Chapter 7
zhlédnutí 48Před měsícem
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 53:11VBA Code for Copy and Paste Data in Excel | Macro and VBA Tutorial - Chapter 5
VBA Code for Copy and Paste Data in Excel | Macro and VBA Tutorial - Chapter 5
zhlédnutí 104Před měsícem
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 46:47VBA User Interface & How to Write and Run Macros in VBA | Macro and VBA - Chapter 4
VBA User Interface & How to Write and Run Macros in VBA | Macro and VBA - Chapter 4
zhlédnutí 127Před měsícem
VBA User Interface & How to Write and Run Macros in VBA | Macro and VBA - Chapter 4
SUM and XLOOKUP Function Combination in Excel1:41SUM and XLOOKUP Function Combination in Excel
SUM and XLOOKUP Function Combination in Excel
zhlédnutí 442Před měsícem
SUM and XLOOKUP Function Combination in Excel

Komentáře

  • @MusicTherapyForallNations
    @MusicTherapyForallNations Před 30 minutami

    Fantastic...Yeah wonderful amazing software... But I have tried to use it... Unfortunately Transaction Page is not working... Even though you fill up al required Information... Stock or out are not displayed on the page can You help me?

  • @dcreations462
    @dcreations462 Před 2 dny

    How to insert quantity Symbol??

  • @secretgamer1234
    @secretgamer1234 Před 2 dny

    Analyze data funtion is not show please help me

    • @ms-excel-training
      @ms-excel-training Před dnem

      Which version of Excel are you using? Thia functionality is available in latest Excel version, that is office 365.

  • @kotikalapudivenkatasomasun3864
    @kotikalapudivenkatasomasun3864 Před 2 dny

    🤗👌👌😄😄😃👍🤗

  • @saifbashar4835
    @saifbashar4835 Před 3 dny

    I need more explanation like this. Im doing bookkeeping course. So i barely need to see that my entries are well and perfect.

    • @ms-excel-training
      @ms-excel-training Před 3 dny

      Please check whether copilot supports analyzing uploaded files. Otherwise you can try chat GPT if it works.

  • @bryanuche8870
    @bryanuche8870 Před 6 dny

    Literally the best chanel you can find on excel, they helped fix my problem

  • @bryanuche8870
    @bryanuche8870 Před 7 dny

    My stock balance is not automatically updating and I followed the steps correctly Pls I need help here

    • @ms-excel-training
      @ms-excel-training Před 7 dny

      If possible, share your working file to msexceltraining24@gmail.com, We will check for the issue and reply.

    • @bryanuche8870
      @bryanuche8870 Před 6 dny

      @@ms-excel-training Thanks i have sent a mail.

    • @bryanuche8870
      @bryanuche8870 Před 6 dny

      @@ms-excel-training thank you so much

  • @ibrahimmouein7730
    @ibrahimmouein7730 Před 7 dny

    How i can enter same item, if the item price is changed in future ??

    • @ms-excel-training
      @ms-excel-training Před 7 dny

      This template has focused on quantity part only, price is not considered. Tracking with price becomes more complicated since price changes frequently.

    • @ibrahimmouein7730
      @ibrahimmouein7730 Před 7 dny

      @@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

  • @bhutan_rideexplore_vlog_2023
    @bhutan_rideexplore_vlog_2023 Před 8 dny

    Thank you for this insighful

  • @Jack_KsKn
    @Jack_KsKn Před 9 dny

    What's the deal with this function?

    • @ms-excel-training
      @ms-excel-training Před 9 dny

      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.

  • @prakveasna010
    @prakveasna010 Před 11 dny

    why i can not download this files guy.? thanks you

    • @ms-excel-training
      @ms-excel-training Před 11 dny

      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

    • @prakveasna010
      @prakveasna010 Před 9 dny

      @@ms-excel-training Yes, Thank you so much guy 🌻🙏

  • @gabrielgwirai
    @gabrielgwirai Před 13 dny

    Well explained, thank you

  • @goodman-it2qy
    @goodman-it2qy Před 14 dny

    Please make it also attendance sheet link with salary sheet. , thanks in advance.

  • @goodman-it2qy
    @goodman-it2qy Před 14 dny

    Thanks

  • @dipongkardas9827
    @dipongkardas9827 Před 15 dny

    Need delete option please

  • @meseretteklu4746
    @meseretteklu4746 Před 17 dny

    What will happen if a new item is added in the future?

    • @ms-excel-training
      @ms-excel-training Před 17 dny

      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.

  • @aggranilroy8329
    @aggranilroy8329 Před 19 dny

    Thank you very much.

  • @faizanpirzada5131
    @faizanpirzada5131 Před 20 dny

    The formula is too lengthy just to minus 4 into 20

    • @ms-excel-training
      @ms-excel-training Před 20 dny

      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.

    • @faizanpirzada5131
      @faizanpirzada5131 Před 20 dny

      @@ms-excel-training Got it 👍

  • @tonimagana7989
    @tonimagana7989 Před 20 dny

    This nice and easy to understand i will use it

  • @AnnetNamutebi-qb7xo
    @AnnetNamutebi-qb7xo Před 21 dnem

    simple and easy to follow steps.

  • @reooo22
    @reooo22 Před 28 dny

    thank you, really useful!

  • @riyasas_adi6054
    @riyasas_adi6054 Před měsícem

    Very Good

  • @HAKIMABOUDISSA-c2k
    @HAKIMABOUDISSA-c2k Před měsícem

    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 .

  • @robertparks2933
    @robertparks2933 Před měsícem

    This was very good and informative!!

  • @ericssontest2332
    @ericssontest2332 Před měsícem

    ,,

  • @abdulahadsamadi9457
    @abdulahadsamadi9457 Před měsícem

    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

    • @ms-excel-training
      @ms-excel-training Před 7 dny

      Pls see if this fulfills your requirement: czcams.com/video/OWhIbfHn1qc/video.html

  • @edeighodaro4240
    @edeighodaro4240 Před měsícem

    Thank you for the very direct teaching, was easy to follow and apply.

  • @abdulahadsamadi9457
    @abdulahadsamadi9457 Před měsícem

    Thank you, It is easy to understand and complete.

  • @AxmadB89
    @AxmadB89 Před měsícem

    I need the picture you're using where can i find it please

    • @ms-excel-training
      @ms-excel-training Před měsícem

      Images can be downloaded from internet or you can create your own by using image designer software.

    • @AxmadB89
      @AxmadB89 Před měsícem

      @@ms-excel-training i want this 😂🤣 send me as a link

  • @ganeshkisnamurthi708
    @ganeshkisnamurthi708 Před měsícem

    Can you please provide practice excel sheets for this.

    • @ms-excel-training
      @ms-excel-training Před měsícem

      get the practice workbook file from below onedrive link. 1drv.ms/x/s!AohAxi9JX1lu3DGcZEFf2yQsq3kq?e=edwgZY

  • @dereksylar1416
    @dereksylar1416 Před měsícem

    Mine showing type mismatch why ??

    • @ms-excel-training
      @ms-excel-training Před měsícem

      This happened because of code mismatch. Please recheck if the code is exactly same as shown in video.

  • @shahabjavidfard7699
    @shahabjavidfard7699 Před měsícem

    tnx a lot

  • @benosborne413
    @benosborne413 Před měsícem

    download is not working (File)

  • @gadrush
    @gadrush Před měsícem

    Thank you boss. Very useful. 🙏

  • @Luciano_mp
    @Luciano_mp Před měsícem

    Very good, thanks.

  • @omprakashthakur4515
    @omprakashthakur4515 Před měsícem

    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

    • @ms-excel-training
      @ms-excel-training Před měsícem

      Please make the requirement more clear You can write mail to: msexceltraining24@gmail.com Please attach your practice workbook if possible

  • @omprakashthakur4515
    @omprakashthakur4515 Před měsícem

    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

  • @raageaxmad5437
    @raageaxmad5437 Před měsícem

    Thanks teacher

  • @user-xs4on4be5l
    @user-xs4on4be5l Před měsícem

    Simple and easy to follow, thank you for this tutorial

  • @mustafaali7907
    @mustafaali7907 Před 2 měsíci

    Thanks for this Video from Germany

  • @user-xs4on4be5l
    @user-xs4on4be5l Před 2 měsíci

    Very useful, it will help me in my work, keep uploading great tutorials

  • @arifuzzamansumon6865
    @arifuzzamansumon6865 Před 2 měsíci

    Good tutorial

  • @wahajnaseer279
    @wahajnaseer279 Před 2 měsíci

    Remarkable

  • @shinojmknr8041
    @shinojmknr8041 Před 2 měsíci

    Data validation pls