YouExcel Tutorials
YouExcel Tutorials
  • Видео 122
  • Просмотров 204 070
TAKE || DROP || Dynamic Range || Alternatives to OFFSET function
In this tutorial, you will learn how to use the TAKE and DROP functions as alternatives to the offset function for creating dynamic ranges. Additionally, this tutorial shows how to use these functions for Year-to-Date analysis.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Note: Take and Drop functions are available in Microsoft 365 and the latest versions of Excel
📢”… give thanks to Him and praise His name, for the Lord is good and His Love endures forever…” (Psalm 100:4-5) NIV
Content
00:02 Intro
00:41 Take - Top N
02:21 Take - Bottom N
03:04 Drop - To...
Просмотров: 462

Видео

10 Common Accounting & Finance Terms You Should Know #1
Просмотров 14810 месяцев назад
This video highlights 10 common terms used in accounting and finance. Do you know them all? Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! Content 00:03 Assets 00:11 Liabilities 00:19 Cash Flow 00:27 Working Capital 00:35 GL 00:49 Account Reconciliation ...
Calculate Retention & Churn || Cohort Analysis || Data Analysis
Просмотров 3,9 тыс.Год назад
In this tutorial, you will learn how to calculate retention rate and churn rate for a subscription-based business. Please check out other videos on my channel and don't forget to comment, like, share, subscribe, and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! Content 00:02 Intro 00:08 What is a cohort analysis? 00:30 Definition of retention and chur...
What is Cohort Analysis? || Retention Rate || Data Analysis || Dynamic Array Formulas
Просмотров 6 тыс.Год назад
In this tutorial, you will learn the meaning of cohort analysis and how to calculate retention rate to understand patterns in customer behavior for better decision-making. Please check out other videos on my channel and don't forget to comment, like, share, subscribe, and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! Content 00:02 Intro 00:16 What is ...
LTM Analysis || Financial and Data Analysis || Excel || DAX || Power Pivot
Просмотров 1,1 тыс.Год назад
Last Twelve Months (LTM) analysis is a useful tool in financial analysis. In this tutorial, you will learn the meaning and how to calculate LTM using Excel and DAX formulas. Please check out other videos on my channel @YouExcelTutorials and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! Content 00:02 ...
Filter Function || Multiple Criteria || Same Column || Different Columns
Просмотров 9 тыс.Год назад
This tutorial highlights two approaches to extract data with the filter function based on multiple criteria. Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! 👉 @Chandoo’s blog - chandoo.org/wp/filter-one-table-if-the-value-is-in-another-table-formula-trick...
Variance Analysis || DAX || VSTACK || Data Analysis || Financial Analysis
Просмотров 1,2 тыс.Год назад
Variance Analysis || DAX || VSTACK || Data Analysis || Financial Analysis
UNIQUE vs DISTINCT values in Excel
Просмотров 2,7 тыс.Год назад
UNIQUE vs DISTINCT values in Excel
DAX vs EXCEL FUNCTIONS | RELATED | LOOKUPVALUE | RELATEDTABLE
Просмотров 9092 года назад
DAX vs EXCEL FUNCTIONS | RELATED | LOOKUPVALUE | RELATEDTABLE
Remove PivotTable Grand Totals #shorts #msexcel
Просмотров 1092 года назад
Remove PivotTable Grand Totals #shorts #msexcel
GETPIVOTDATA || Dynamic Financial Reporting || PivotTable || Data Model || Cube Functions
Просмотров 1,4 тыс.2 года назад
GETPIVOTDATA || Dynamic Financial Reporting || PivotTable || Data Model || Cube Functions
SUM Vs SUMIF(S) - Multiple Criteria || Same Column || Different Columns
Просмотров 1,4 тыс.2 года назад
SUM Vs SUMIF(S) - Multiple Criteria || Same Column || Different Columns
What is an array in Excel || Array Constants || Array Formulas
Просмотров 1,1 тыс.2 года назад
What is an array in Excel || Array Constants || Array Formulas
Excel Super Users || 10 questions you should answer
Просмотров 2302 года назад
Excel Super Users || 10 questions you should answer
Fix Time Format || Split time values with no delimiter || Excel Formulas || Power Query
Просмотров 5092 года назад
Fix Time Format || Split time values with no delimiter || Excel Formulas || Power Query
Scrollable Excel Table and Chart || IndexMatch/ XLookup || Scroll Bar (Form Control)
Просмотров 8502 года назад
Scrollable Excel Table and Chart || IndexMatch/ XLookup || Scroll Bar (Form Control)
What is CAGR? || LAMBDA Function || RRI function in Excel || Financial Analysis
Просмотров 6862 года назад
What is CAGR? || LAMBDA Function || RRI function in Excel || Financial Analysis
Create Index Number for Grouped Data || Excel Formula vs Power Query
Просмотров 1,4 тыс.2 года назад
Create Index Number for Grouped Data || Excel Formula vs Power Query
Parameter Query || Filter Power Query data from Excel
Просмотров 9 тыс.2 года назад
Parameter Query || Filter Power Query data from Excel
Multi-Currency Income Statement || Financial Modeling || Radio/ Option button in Excel
Просмотров 3,5 тыс.2 года назад
Multi-Currency Income Statement || Financial Modeling || Radio/ Option button in Excel
Scenario Analysis in Financial Modeling || What-if Analysis in Excel
Просмотров 3,6 тыс.2 года назад
Scenario Analysis in Financial Modeling || What-if Analysis in Excel
Append and Reconcile tables easily in Excel with Power Query
Просмотров 7302 года назад
Append and Reconcile tables easily in Excel with Power Query
Extract Texts in Excel || Fix Date Format || Power Query || Formulas || Column from Examples
Просмотров 3872 года назад
Extract Texts in Excel || Fix Date Format || Power Query || Formulas || Column from Examples
Combine Texts in Excel || Power Query || Text.Combine || Textjoin Function
Просмотров 2,9 тыс.2 года назад
Combine Texts in Excel || Power Query || Text.Combine || Textjoin Function
TEXTJOIN Function || Combine Texts in Excel
Просмотров 2352 года назад
TEXTJOIN Function || Combine Texts in Excel
Alternatives to Nested IF Formulas || IFS || SWITCH || CHOOSE Functions
Просмотров 7852 года назад
Alternatives to Nested IF Formulas || IFS || SWITCH || CHOOSE Functions
WORKDAY || NETWORKDAYS || WORKDAY.INTL || NETWORKDAYS.INTL || Important Date Functions
Просмотров 3422 года назад
WORKDAY || NETWORKDAYS || WORKDAY.INTL || NETWORKDAYS.INTL || Important Date Functions
Excel Skills Test for Financial Analysts || Accountants || Excel Users || Employment Test
Просмотров 4,1 тыс.2 года назад
Excel Skills Test for Financial Analysts || Accountants || Excel Users || Employment Test
Protect Worksheet || Allow Edit Ranges #shorts #excel
Просмотров 6 тыс.2 года назад
Protect Worksheet || Allow Edit Ranges #shorts #excel
Import a table from PDF to Excel with Power Query || Microsoft 365, Excel 2019 & Others
Просмотров 3,6 тыс.2 года назад
Import a table from PDF to Excel with Power Query || Microsoft 365, Excel 2019 & Others

Комментарии

  • @fliptop157
    @fliptop157 4 дня назад

    Definitely a mind bender. -Thanks!

  • @rustamge
    @rustamge 4 дня назад

    Thanks a lot you saved like hours for me!

  • @ForNonwork
    @ForNonwork 7 дней назад

    Very informative. Please make more such videos on subscription based metrics.

  • @betizazzuabera5296
    @betizazzuabera5296 8 дней назад

    Many Thanks!!!

  • @bolumekenejoan6360
    @bolumekenejoan6360 Месяц назад

    Thank you for being simplified with your tutorials. It's my first time on your channel but stocked with it already. Thank you so much. I would appreciate you also create more tutorials on life scenarios or real business questions for those looking to go into Data analytics. Thank you so much

  • @isabelaalvarenga514
    @isabelaalvarenga514 Месяц назад

    thank you so much

  • @RajputRaaj786
    @RajputRaaj786 Месяц назад

    Hello. Can we get the excel file?

  • @TheUnknowns90637
    @TheUnknowns90637 2 месяца назад

    You explained it very good. Thanks so much.

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 3 месяца назад

    Nice one mam

  • @ezekielnkum1781
    @ezekielnkum1781 3 месяца назад

    Thank you. Very helpful. I would like to know how will you apply variable exchange rates with currency switch across different time series or time points?

    • @sindhuns4
      @sindhuns4 Месяц назад

      if you edit the ExchangeRate naming to include the whole of exchange rate row, it works.

  • @ovidiuandronache6935
    @ovidiuandronache6935 4 месяца назад

    Hello Bunmi. Thank you. It is possible provided both parameters are null, Power Query returns 0 rows?

  • @JacktonOuma
    @JacktonOuma 4 месяца назад

    Explain three types of cell refrences

  • @hafidhfarhan9518
    @hafidhfarhan9518 4 месяца назад

    very nice job, but first date purchase use G2 as false value in formula, which is lead to copy of head column for value> 1

  • @svenulmcika2237
    @svenulmcika2237 5 месяцев назад

    wonderfull

  • @user-ps7cx7un5u
    @user-ps7cx7un5u 5 месяцев назад

    Great

  • @ArvindYaduvanshi16
    @ArvindYaduvanshi16 5 месяцев назад

    Cell reference explain

  • @TokyRAKOTONIRINA
    @TokyRAKOTONIRINA 5 месяцев назад

    Many thanks for sharing your knowledge, it’s very useful 😊

  • @johndurran614
    @johndurran614 5 месяцев назад

    Easy to understand

  • @edwindeo
    @edwindeo 6 месяцев назад

    Hi 🎉. Your presentation is fantastic 😘.

  • @JayantShettigar-pt6uo
    @JayantShettigar-pt6uo 6 месяцев назад

    your videos are excellent can you cover more topics on dax please

  • @kaushikmallareddy7511
    @kaushikmallareddy7511 6 месяцев назад

    Awesome explanation! Thank you

  • @eighttech
    @eighttech 7 месяцев назад

    With this formulas we can create so many programs in Excel

  • @eighttech
    @eighttech 7 месяцев назад

    Thank you very much ❤❤❤❤

  • @Sunny-jj6tp
    @Sunny-jj6tp 7 месяцев назад

    I was trying to recreate a waterfall chart for work and there way was so complex. You video made it so easy I just restarted the whole thing and it was done in minutes.

  • @saichandu5965
    @saichandu5965 7 месяцев назад

    can you show me how to do YTD growth% on Rev

  • @GermanRodriguezqndq
    @GermanRodriguezqndq 7 месяцев назад

    Another great video, cohort reports well explained, thank you

  • @GermanRodriguezqndq
    @GermanRodriguezqndq 7 месяцев назад

    Thank you for making this video

  • @radeonmbps
    @radeonmbps 7 месяцев назад

    Hi. why age by month devide by 30? 30 is what ya? sorry 😢

  • @ecemzeynepiscanl8839
    @ecemzeynepiscanl8839 8 месяцев назад

    I used pivot table and index match to find first purchase(it was easier to me) but the cohort table part is invaluable thank you very much!!

  • @prod2one
    @prod2one 8 месяцев назад

    what if the lookvalue isnt a number?

  • @wadewessels498
    @wadewessels498 9 месяцев назад

    P R O M O S M 👀

  • @zeinabcole6808
    @zeinabcole6808 10 месяцев назад

    Thank you for this video. it was helpful. May i ask if you have a version for mac users because some of the steps are different. What is the manual instruction for f4.

  • @nonoobott8602
    @nonoobott8602 10 месяцев назад

    I used to mix them up. Thanks for making it very clear

  • @joshpeters813
    @joshpeters813 10 месяцев назад

    Very good job! Appreciate you

  • @mirrrvelll5164
    @mirrrvelll5164 11 месяцев назад

    Nice trick with an IF statement =) I just implemented it in my Excel issue!

  • @lholhofox
    @lholhofox 11 месяцев назад

    Thank you!!

  • @umebosichigozie2248
    @umebosichigozie2248 11 месяцев назад

    Please how were you able to remove the month in the front of the total value when summed up with "ALT+=" because mine is showing the month in front of it and i don't have an idea how to remove it

  • @sonyse2t5
    @sonyse2t5 Год назад

    The countif variant of this formulae is sheer simplicity! Prefer that.

  • @user-vu6vy1vf9h
    @user-vu6vy1vf9h Год назад

    What an explanation, super mam

  • @betho269
    @betho269 Год назад

    Wonderfully explained! Thank you so much!

  • @joelabacherli1310
    @joelabacherli1310 Год назад

    Thank you so much for this video. This is perfect for the presentation I am giving for my colleagues next week. I want to teach them the magic of parameters and this is better than I could have hoped for. Perfect way to show how they work. Thank you very much.

    • @YouExcelTutorials
      @YouExcelTutorials Год назад

      My pleasure! I'm glad you found it useful! Thanks for your kind feedback Joe.

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 Год назад

    Well explained. PLEASE give the files

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 Год назад

    useful knowledge. please put excel files in the description ----, where is it?

  • @josephwang129
    @josephwang129 Год назад

    Why did you not add in the active in retention rate table?

    • @YouExcelTutorials
      @YouExcelTutorials Год назад

      Watch closely... only active customers were retained by the end of month 10.

  • @Abhinavprakashbittu
    @Abhinavprakashbittu Год назад

    Thanks sir

  • @sunnysun6567
    @sunnysun6567 Год назад

    The total all rows , it does not seems Right , like late column. Is 127 , but on your work , is was 134 ? Can you check for it ?

  • @ridohconcepts8868
    @ridohconcepts8868 Год назад

    Welldone? Why did you turn off, structured referencing, I thought is a more better way of writing a formula in a table.

    • @YouExcelTutorials
      @YouExcelTutorials Год назад

      Thanks, Ridoh Concepts. You're right... I turned it off to make the formulas shorter for ease of understanding the concept.

  • @powerquery_online
    @powerquery_online Год назад

    Im VietNamese, Thanks you so much

  • @mohamed.montaser
    @mohamed.montaser Год назад

    this is amazing, when the next video will come out?

    • @YouExcelTutorials
      @YouExcelTutorials Год назад

      Thanks! Here you go ruclips.net/video/EevV0x-ifjQ/видео.html

  • @olajumokelawal2478
    @olajumokelawal2478 Год назад

    Tutorial so useful. I have a lot learning to do.