- Видео 36
- Просмотров 102 379
Myexcelacademy
Объединенные Арабские Эмираты
Добавлен 18 дек 2011
Excel Advanced Skills
Видео
Vlookup Vs Filter Function
Просмотров 6943 месяца назад
How do you extract duplicate records using either Vlookup or Filter Function Join my course on Power BI: www.udemy.com/course/power-bi-dax-simplified/?couponCode=8356BCBFA35E534DADED Join my course on Advanced Excel: www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?couponCode=093EC298888D136F7A6D Join my course on Excel Macros - Excel Automation: www.udemy.com/course/micros...
Database Functions Part 1 (Urdu Version)
Просмотров 695 месяцев назад
Learn how to use Database functions in Excel.
Power BI Dashboard
Просмотров 127Год назад
Starting to learn Power BI. If you are an Excel user, then watch the video to start learning Power BI. Click the link below to get the full course: www.udemy.com/course/power-bi-dax-simplified/?referralCode=CFB0D392BC09662FCE6A
Power BI & DAX Simplified
Просмотров 116Год назад
If you are an Excel user and would like to learn Power BI, then this course is for you. Learn DAX techniques, how to create a full functional Power BI report, Data Modeling and much more in this course. Get the link below and use the CODE: 28F322764AA76E87EC3E www.udemy.com/course/power-bi-dax-simplified/?referralCode=CFB0D392BC09662FCE6A
Sum, Count with criteria on Filtered Data
Просмотров 4922 года назад
How to sum or count with criteria on filtered data using nested formulas. Use the coupon below to get the Advanced all in one Excel course: www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?couponCode=74496F844D9A10250C59
Microsoft Excel Macros - Excel VBA
Просмотров 7 тыс.3 года назад
Learn to automate your Excel tasks....create animated charts, userforms, automate pivot table creation, multiple charts and much more...Excel Macros and VBA course. Join the link below www.udemy.com/course/microsoft-excel-macros-magician-excel-and-vba/?referralCode=DF64DCEF6EB4F17F2C71 Advanced Excel www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22A...
Excel Financial Dashboard using Excel Formulas
Просмотров 8503 года назад
Build a Dynamic P&L Finance Dashboard in Excel using Dynamic formulas. Use the Filter Function - Office 365 , Index Function, Sumproduct. Apply Excel Table feature to dynamically update your data Use Conditional Formatting to graph your positive and negatives Use the below link for a complete Excel Course www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C568467...
Excel Hack # 2 Artificial Intelligence in Excel - Analyze Data
Просмотров 2333 года назад
Tip 1 - Using conditional formatting to find repeats, Tip 2 - how to use the Analyze Data feature in Excel 365. Click on the link below to learn Advanced Excel Formulas, Data Analysis, Pivot tables, Power BI, Power Query and much more. www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Excel Hack #1 Sorting by Row
Просмотров 1533 года назад
How to sort your columns or re-arrange your columns from highest to lowest, using Sort by Row. Click below to learn Advanced Excel www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Can't Find your Files - Try Excel and Power Query
Просмотров 2313 года назад
How to locate your files through one file only. Click the link below for the course www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Power BI - Small Multiple Charts
Просмотров 2823 года назад
This video is part of my "MBA in Excel" course on Udemy, in which I have completed videos on modules for Data Analysis using Formulas, Pivot tables, Dashboarding in Excel, Macros and VBA, Power Query and Power BI. The link below directs you to my course live on Udemy. www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Burn That Belly Fat using Excel
Просмотров 1273 года назад
Using the Convert function in Excel and how to embed a video in an Excel file. Click on the link below to learn Advanced Excel Formulas, Data Analysis, Pivot tables, Power BI, Power Query and much more. www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Power Query Solution
Просмотров 1343 года назад
My Power Query Solution to the Excel Challenge. Try the Advanced Excel course on the link below: www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Solve this Excel Challenge
Просмотров 1163 года назад
Click on the link below to get the Advanced Excel course. www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/ Try and solve the challenge, and see if you can do it. If not see the video. There are a number of ways to solve this, let me know in the comments if you come up with different ways.
MBA in Excel - Master Business Analytics in Excel
Просмотров 4,6 тыс.3 года назад
MBA in Excel - Master Business Analytics in Excel
Multiplication tables for kids in Excel
Просмотров 1174 года назад
Multiplication tables for kids in Excel
How to Calculate Weighted Averages in Excel Dynamically
Просмотров 4324 года назад
How to Calculate Weighted Averages in Excel Dynamically
Thanks for sharing, Always shining
So nice of you
Instead of this formulas we apply filters in excel 😮
Why didn't i watch this before my interview 😢
Бале екенсің, қара бет😂
Super
I changed it a bit to adjust to my query but worked perfectly nice job.
filter function can easily do same thing
Yes, but not everybody has office 365
I've been looking for this solution! Thank You!
Glad I could help😊
Hy i have a question
It was very informative but i need to know how can i get all the sales value of chris summed up in 1 row?
Just add one row on top and use the SUM function
Hello sir. It was an excellent video. I have one doubt. What if I need vloopup on two separate sheet? I mean I need vlookup three values to an another sheet which has same values. The data is almost 70000 entries. Thanks!
I will try to make a video on that
Hello sir I am waiting for the new video@@myexcelacademy69
excellent, thank you so much
👍
You're a life saver
Very useful! Thank you
Glad to hear that!
How do we use ROW if the table is on another sheet?
Thank you for this help... How did you added drop down function at 06:05
Life saver dude.. Thanks a lot
Can you teach online excel formulas please
www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?couponCode=85D50BE60F145DFBFB12
jazakaallah
how can i solve colum A colum B Colum C Colum D 3. 1 9 3 4. .5. 5. 1 3. 1. 9. 4 Colum D represent Pcs(QTY) Colum A,B,C are Size of Timber(With),(Thickness),(Length).... I want to sum result if row are same how could be formula for sum pcs?Please
How pick at put down
Subscribe for more videos like this
VERY GOOD FORMULA CREATED BY YOU, SOLVED MY HEADACHE
Without drop down list ke formula kese aply kre
Short list ki beena bhi is formula nhi lg skta hai kyaa
𝐩𝐫𝐨𝐦𝐨𝐬𝐦
Thank you very much sir.You really helped me but unfortunately I still have a small problem . ,Why you wrote () row minus 1 ? you also higlithed "row' clicked F9. ,Ii couldn't see how it returned to row..... hank you very much
Hi Charles, we use row () to get us the row number, and since the formula is in Row 2 , when using the row function it will give us 2 , but we need 1 for the first Vlookup entry, so we minus 1 to get 1. Hope this is clear. Enjoy...Join my course on Udemy to learn more Advanced stuff..
@@myexcelacademy69 hello sir, please can you explain on this why you minus 1 when the row you've used is in row 3?
Subscribe for more videos !!
Great Video, you have helped me solved what seemed to be impossible at first
Glad I could help!
Subscribe for more videos 🌚
This Is the Video What I Was Looking For 👍
Wow
Hi teacher, could you please share us vba code.
307 subs now
Hi New Sub 😎
Don't Forget To Like And Subscribe
Nice brother
You can buy my course at a discounted price on Udemy www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Excellent Sir
Thank you
Could you please prepare tutorial this video
Hi, I have a course on Udemy, you can learn Animation in this course. You can click on the link below www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?referralCode=C5684677A22AFD9CAAF5
Nice Video 👍👍💖💖🔥🔥
Cool 😃😍
Congrats on 250! Keep it up!
Nice video 👍👍
New Subscriber
MUSLIMS ❤️❤️❤️❤️❤️✨✨✨
Nice 👌👌✅✅✅✅😊😊😊🔥👌
Many many thanks
New subscriber
Welcome
@@myexcelacademy69 ❤️ I hope your channel grows fast ❤️❤️❤️❤️ lots of love 👌👌❤️🔥🔥💖💖
@@poliftiactionl7335 Many thanks..God bless
Thank you Emaan
:) ✨❤️❤️✨✨❤️👍👑