The Excel Girl
The Excel Girl
  • 7
  • 7 914
IF Conditions, AND, OR, COUNTIFS - Excel Tutorial
Combining all the mini videos I have uploaded to my Instagram stories, learn about IF conditions, OR, AND, COUNTIFS.
มุมมอง: 32

วีดีโอ

Excel Tutorial - IF conditions, NESTED IFs, AND, OR funtions
มุมมอง 175 ปีที่แล้ว
Today we go into a bit more depth on IF conditions, NESTED IFs, AND, OR functions. I give you some practical examples to illustrate how to make the most of these functions.
How to do a VLOOKUP, drag formulas and lock cells
มุมมอง 8K5 ปีที่แล้ว
Last week I uploaded a quick VLOOKUP video where I explain the basics of the formula. Today I thought I would expand a bit more on the subject, also addressing how you can drag formulas and lock cells to save time. I hope you find this useful.
Learning COUNTIFS and SUMIFS - the basics
มุมมอง 65 ปีที่แล้ว
Hey everyone. Today I am coming at you with a quick tutorial where I compare SUMIFS and COUNTIFS. These formulas are built in a fairly similar way however they are used for different ends. Here I explain why you would use them and how, explaining also how they differ. I hope you enjoy and get to use them in your life!
Sumifs - the basics
มุมมอง 75 ปีที่แล้ว
Hi everybody! Today I am taking you through the SUMIFS function, which you can use to sum a range of values based on one or more criteria. Hope you enjoy and let me know if you have any questions!
How to do a basic IF condition in Excel
มุมมอง 65 ปีที่แล้ว
IF conditions are something you will find in most programs or programming languages. Today I am taking you through what it means and how/ why to use it.
Vlookup and Hlookup - the basics
มุมมอง 285 ปีที่แล้ว
Today I am explaining the basics of VLOOKUP and HLOOKUP functions in Excel. These functions are not difficult to learn and can be used in many different ways, just hear me out!

ความคิดเห็น

  • @gurjotkaur6186
    @gurjotkaur6186 หลายเดือนก่อน

    Thanku mam❤

  • @allthings4235
    @allthings4235 3 หลายเดือนก่อน

    thank you for uploading video this so easy to understand love it

  • @kumar14372
    @kumar14372 8 หลายเดือนก่อน

    Thank you.. I was facing the same row change issue in table u helped me

  • @onkarbhaskar4440
    @onkarbhaskar4440 11 หลายเดือนก่อน

    I love you... Last night i wasted more than 2 hours on this

  • @Lone_wolf_31
    @Lone_wolf_31 ปีที่แล้ว

    Not efficient, you are manually typing the column number what’s the use. I wasted my time

  • @VipinnSingh
    @VipinnSingh ปีที่แล้ว

    Thanks

  • @ruth7er
    @ruth7er ปีที่แล้ว

    This is the formula: =vlookup(a51&"*",EXP!$101:$101,87,0) EXP = 2nd sheet My goal is to automatically move to cell column 88 while dragging down the formula in the 1st sheet

  • @ruth7er
    @ruth7er ปีที่แล้ว

    Can u help with my predicament in this drag down formula in group cells and copy a cell from another sheet?

  • @funflytv2985
    @funflytv2985 3 ปีที่แล้ว

    Thank u so much dear its really helps me lot