![YouExcel Tutorials](/img/default-banner.jpg)
- Видео 122
- Просмотров 204 070
YouExcel Tutorials
Канада
Добавлен 4 июн 2020
Hello! My name is Bunmi Sanusi, your Excel tutor! Are you looking to improve your Excel skills? Then, I'm excited to share my knowledge of Microsoft Excel and related tools with you! I will also share useful Excel tips to make YouExcel😁. So, if you use Excel for storing and analyzing data or forecasting and modelling, then, you're in the right place ✔
Please subscribe and click the bell icon so you'll be the first to see my videos. If you have any questions, please leave a comment or reach out to me via email and I would respond to you asap. Thanks!
Connect with me on:
👉Instagram youexceltutorials
👉Facebook youexceltutorials
👉Twitter youexceltutor
👉 TikTok www.tiktok.com/@youexceltutorials
👉LinkedIn www.linkedin.com/in/bunmi-sanusi/
📢“Each of you should use whatever gift you have received to serve others, as faithful stewards of God’s grace in its various forms.” (1 Peter 4:10) NIV
Please subscribe and click the bell icon so you'll be the first to see my videos. If you have any questions, please leave a comment or reach out to me via email and I would respond to you asap. Thanks!
Connect with me on:
👉Instagram youexceltutorials
👉Facebook youexceltutorials
👉Twitter youexceltutor
👉 TikTok www.tiktok.com/@youexceltutorials
👉LinkedIn www.linkedin.com/in/bunmi-sanusi/
📢“Each of you should use whatever gift you have received to serve others, as faithful stewards of God’s grace in its various forms.” (1 Peter 4:10) NIV
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...
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
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
Definitely a mind bender. -Thanks!
Thanks a lot you saved like hours for me!
Very informative. Please make more such videos on subscription based metrics.
Many Thanks!!!
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
thank you so much
Hello. Can we get the excel file?
You explained it very good. Thanks so much.
Nice one mam
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?
if you edit the ExchangeRate naming to include the whole of exchange rate row, it works.
Hello Bunmi. Thank you. It is possible provided both parameters are null, Power Query returns 0 rows?
Explain three types of cell refrences
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
wonderfull
Great
Cell reference explain
Many thanks for sharing your knowledge, it’s very useful 😊
Easy to understand
Hi 🎉. Your presentation is fantastic 😘.
your videos are excellent can you cover more topics on dax please
Awesome explanation! Thank you
With this formulas we can create so many programs in Excel
Thank you very much ❤❤❤❤
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.
can you show me how to do YTD growth% on Rev
Another great video, cohort reports well explained, thank you
Thank you for making this video
Hi. why age by month devide by 30? 30 is what ya? sorry 😢
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!!
what if the lookvalue isnt a number?
P R O M O S M 👀
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.
I used to mix them up. Thanks for making it very clear
Very good job! Appreciate you
Nice trick with an IF statement =) I just implemented it in my Excel issue!
Thank you!!
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
The countif variant of this formulae is sheer simplicity! Prefer that.
What an explanation, super mam
Wonderfully explained! Thank you so much!
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.
My pleasure! I'm glad you found it useful! Thanks for your kind feedback Joe.
Well explained. PLEASE give the files
useful knowledge. please put excel files in the description ----, where is it?
Why did you not add in the active in retention rate table?
Watch closely... only active customers were retained by the end of month 10.
Thanks sir
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 ?
Welldone? Why did you turn off, structured referencing, I thought is a more better way of writing a formula in a table.
Thanks, Ridoh Concepts. You're right... I turned it off to make the formulas shorter for ease of understanding the concept.
Im VietNamese, Thanks you so much
I'm glad you found it useful! Thanks Tri!
this is amazing, when the next video will come out?
Thanks! Here you go ruclips.net/video/EevV0x-ifjQ/видео.html
Tutorial so useful. I have a lot learning to do.