Spreadsheet Power
Spreadsheet Power
  • 272
  • 1 447 113
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.
Переглядів: 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
Excel VBA Tutorial: Chapter 2
Переглядів 25528 днів тому
Excel VBA Tutorial: Chapter 2
Excel VBA Tutorial - Chapter 1
Переглядів 1,1 тис.Місяць тому
Excel VBA Tutorial - Chapter 1
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)
DSUM Function in Excel
Переглядів 4952 місяці тому
DSUM Function in Excel
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
TRIMMEAN Function in Excel
Переглядів 1813 місяці тому
TRIMMEAN Function in Excel
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

КОМЕНТАРІ

  • @adamaugenblick9594
    @adamaugenblick9594 5 годин тому

    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.

  • @lojada
    @lojada 22 години тому

    اشكرك ارجو الترجمه الي اللغه العربيه يمكن استخدام الترجمة الصوتيه العربيه

  • @juhanikolehmainen6324
    @juhanikolehmainen6324 День тому

    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.

    • @spreadsheet_power
      @spreadsheet_power День тому

      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.

  • @Jhon-it3ps
    @Jhon-it3ps 2 дні тому

    Thank you so much dude, hope you live a long life ❤❤❤

  • @engineerraufkhanwazir8253
    @engineerraufkhanwazir8253 2 дні тому

    Thanks dear its working

  • @BBML-SE-NP-HasibulHasan
    @BBML-SE-NP-HasibulHasan 4 дні тому

    how it lock formula i cant find which button you press keyboard

  • @Doug-sb9gz
    @Doug-sb9gz 6 днів тому

    Thank you.

  • @MariamAliaga
    @MariamAliaga 6 днів тому

    Thank you so much! I couldn't find any help online, but this video explains it clearly and easily!

  • @МихаелаПенева-с6р

    Hi! How to insert a hiperlink in a cell that consists of several sentences. Thank you!

  • @LouiseChu-l1n
    @LouiseChu-l1n 6 днів тому

    Thank you for sharing!

  • @raghavendratr3415
    @raghavendratr3415 7 днів тому

    Sir, for sale/purchase how to add invoice no

  • @marusyalirene5095
    @marusyalirene5095 8 днів тому

    Thank you a million!

  • @shridharchannannavar2856
    @shridharchannannavar2856 8 днів тому

    I'm facing problem,,once done it's showing #SPILL! In the cell

    • @spreadsheet_power
      @spreadsheet_power 7 днів тому

      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.

  • @jakezapanta517
    @jakezapanta517 8 днів тому

    ty bro

  • @kwamekyei-brefo1501
    @kwamekyei-brefo1501 11 днів тому

    Please sir, is there any way where you can search for date without converting it to number format?

  • @ThePowerPlace
    @ThePowerPlace 11 днів тому

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

  • @ThePowerPlace
    @ThePowerPlace 12 днів тому

    My man, thank you so much! I watched 4 tutorials and this is the best and the fastest one! Thank you again!

  • @mpcomputer1937
    @mpcomputer1937 12 днів тому

    templet not able to download pls enable to download

  • @SerenitySmallBusinessSolutions
    @SerenitySmallBusinessSolutions 13 днів тому

    You are amazing!! Thank you for making my life sooooo much easier :)

  • @vijaykumarp2405
    @vijaykumarp2405 14 днів тому

    Hello sir, Happy New Year thank you very neatly explained vba basics...

    • @spreadsheet_power
      @spreadsheet_power 13 днів тому

      Happy New Year to you too! Thank you for appreciating

  • @jeanpavan6816
    @jeanpavan6816 14 днів тому

    Hi. Happy New Year. I do not see the link to downlaod the file

  • @USEquitiesGoogleAlerts
    @USEquitiesGoogleAlerts 14 днів тому

    Unable to access practice workbook file

  • @USEquitiesGoogleAlerts
    @USEquitiesGoogleAlerts 14 днів тому

    Unable to access practice workbook file

  • @wenurapriyashantha6112
    @wenurapriyashantha6112 14 днів тому

    Thanks for the clear explanation

  • @vinodhkumar9017
    @vinodhkumar9017 16 днів тому

    thks bro.

  • @mohammadyounas5495
    @mohammadyounas5495 19 днів тому

    how to contact with you e mail or contact number please

  • @mohammadyounas5495
    @mohammadyounas5495 20 днів тому

    Hi Dear Sir. i downloaded but now showing Spreadsheet Power stamp is it possible to remove ?

    • @spreadsheet_power
      @spreadsheet_power 17 днів тому

      Please write a mail to spreadsheetforu@gmail.com for template with no stamp

    • @mohammadyounas5495
      @mohammadyounas5495 2 дні тому

      @@spreadsheet_power Hi Good day i already send e mail to you twice and waiting your replay please

    • @spreadsheet_power
      @spreadsheet_power День тому

      @@mohammadyounas5495 I have sent you the file in Email just now. Please check and confirm.

  • @KingsleyHibajene
    @KingsleyHibajene 20 днів тому

    Help with the formula its not clear

  • @juhanikolehmainen6324
    @juhanikolehmainen6324 21 день тому

    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.

    • @spreadsheet_power
      @spreadsheet_power 18 днів тому

      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.

  • @cezarantoin3559
    @cezarantoin3559 23 дні тому

    What IS your excel version ? I have excel 365 but i cannt find the fonction filter ?!

    • @spreadsheet_power
      @spreadsheet_power 22 дні тому

      Filter function should be in Excel 365, is your software updated?

  • @Hari_Bhajan666
    @Hari_Bhajan666 23 дні тому

    PLEASE PROVIDE SHEET

  • @mohdjavedsolanki3653
    @mohdjavedsolanki3653 23 дні тому

    This formula not showing in my excel 2024

  • @100salman1
    @100salman1 23 дні тому

    Thank you very much for this tutorial. Makes things very easy.

  • @latiffesa
    @latiffesa 26 днів тому

    There is no download link for the data

  • @teshanbandara216
    @teshanbandara216 26 днів тому

    Thank you so much ..❤❤ its really working ..💐🙏🙏

  • @Aditifoodvlog24
    @Aditifoodvlog24 26 днів тому

    Can we add unit coloum then final bal. Quantity is right show

  • @_-wv4ez
    @_-wv4ez 27 днів тому

    The link is not working, please update. Thank you.

    • @spreadsheet_power
      @spreadsheet_power 24 дні тому

      The link should be working fine. What error did you get?

  • @kobbyg6487
    @kobbyg6487 27 днів тому

    worked for me, i have a question, what if I don’t want the table to appear unless I search for something

  • @Storeincharge-r5t
    @Storeincharge-r5t 28 днів тому

    good

  • @himanshusharma-life
    @himanshusharma-life 28 днів тому

    AFTER PRESSING "SAVE WB" BUTTON ? HOW CAN I DELETE ALL THE ITEMS IN "SHOW DETAILS" SECTION ?????

  • @ishantverma7805
    @ishantverma7805 28 днів тому

    SIR PLZ SEND ME PASSWORD

    • @spreadsheet_power
      @spreadsheet_power 28 днів тому

      To use this template, no password is required. Password is for vba project. It is protected to avoid unwanted change in code.

    • @ishantverma7805
      @ishantverma7805 28 днів тому

      @spreadsheet_power change for out product price

  • @aaryo4365
    @aaryo4365 29 днів тому

    WAW

  • @pradeepsg771
    @pradeepsg771 Місяць тому

    Where is this file

  • @joshuamumba9736
    @joshuamumba9736 Місяць тому

  • @CandraAguero
    @CandraAguero Місяць тому

    thaaankkkk u broooo, new subscriber from Indonesia

  • @BullionSmash
    @BullionSmash Місяць тому

    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!

  • @HassenAman-y1x
    @HassenAman-y1x Місяць тому

    please prepare in amharic language 1:56

  • @HassenAman-y1x
    @HassenAman-y1x Місяць тому

    እባክዎ ከቻሉ በአማርኛ ያርጉልን

  • @mdbilla4219
    @mdbilla4219 Місяць тому

    It's really helpful video Thank you very much 👏

  • @linthushein291
    @linthushein291 Місяць тому

    VBA password plz unlock_im is not working