Download Excel File: https://ift.tt/30DK5uV
In this video learn how to do a Two Way Lookup from a Rectangular Lookup Table using the INDEX and MATCH functions. In our example we need to lookup a product name in the row and a month name in the column and return the intersecting value.
Reference Videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567
Excel Two Way Lookup with INDEX & MATCH Functions – Excel Magic Trick 1568
Tag: Productivity
Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567
Download Excel File: https://ift.tt/30DK5uV
In this video learn how to do a Two Way Lookup from a Rectangular Lookup Table using the VLOOKUP and MATCH functions. In our example we need to lookup a product name in the row and a month name in the column and return the intersecting value.
Reference Videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567
Excel Two Way Lookup with INDEX & MATCH Functions – Excel Magic Trick 1568
Advanced RANKX – How To Understand This Function More Deeply
In this particular tutorial I’ll be diving into the RANKX function and how complex it can be at times.
By working through an example I hope that you can understand the many nuances to working with this particular function.
You first need a solid understanding of context and then also how to use RANKX within that context.
Enjoy!
Sam
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn
FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv
FREE – Power BI Resources – https://ift.tt/2LiAVQj
FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95
Learn more about Enterprise DNA – https://ift.tt/2LiAWDR
Enterprise DNA Membership – https://ift.tt/2IJLxWD
Excel Keyboard Shortcut to Jump To Formula Bar. Excel Magic Trick 1566.
Download Excel File: https://ift.tt/2JBlq4q
Learn multiple ways to jump your cursor to the Excel Formula Bar. Change Options or with a Keyboard: F2, Ctrl + A.
Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet)
Download Excel File: https://ift.tt/2JBlq4q
This video shows how to insert an Excel Sheet (also known as Sheet Tab or Worksheet) with the Excel Keyboard: Shift + F11. Also see keyboard to Rename a Sheet: Alt, H, O, R.
Excel for Statistical Analysis Course Trailer. Free YouTube Learning Playlist Class from excelisfun.
Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj
Learn University Business & Economics Statistics Class from the world renowned Excel Educator, Mike Girvin, Microsoft Excel MVP and Highline College Professor. 73 videos, free notes, Excel files make this THE best free online class for learning how to use Excel to do all of your University Statistical Tasks. This class uses the amazing new YouTube Learning Playlist structure. This is the Highline College Busn 210 class taught by Michael Girvin.
Data Talks #2: How to hire your next Power BI Analyst
Here you can download all the pbix files: https://ift.tt/2yGx9Ih
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://ift.tt/2NrgChB
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
https://ift.tt/2I8nl09
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
Logistics Insights For Power BI – DAX And Data Modeling Overview
In this particular example we will cover how you can solve for logistics insights in Power BI.
This has a lot to do with dealing with multiple dates in your fact table, then using the events in progress pattern with DAX.
This is a really good real-world application of a variety of Power BI techniques.
Enjoy working through this one.
Sam
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn
FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv
FREE – Power BI Resources – https://ift.tt/2LiAVQj
FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95
Learn more about Enterprise DNA – https://ift.tt/2LiAWDR
Enterprise DNA Membership – https://ift.tt/2IJLxWD
4 Types of Criteria for SUMIFS & COUNTIFS – Excel Magic Trick 1564, SUMIF & COUNTIF too
SUMIFS & COUNTIFS: 4 Types of Criteria: Cell Reference, Hard Code, Operator Joined, Array
Download Excel File: https://ift.tt/2jXe8yh
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video
Topics:
1. (00:01) Intro
2. (00:32) Cell Reference as Criteria for SUMIFS
3. (01:22) Hard Coded Value as Criteria for COUNTIFS
4. (01:43) Excel’s Golden Rule
5. (02:28) Cell Reference Joined To Comparative Operator as Criteria in COUNTIFS, See an AND Logical Test
6. (04:29) Array Criteria (Function Argument Array Operation) as Criteria for SUMIFS, see and OR Logical Test and the SUMPRODUCT Function
7. (06:16) Conclusion
Cluster Analysis Visualization Techniques For Power BI – Power BI Review
In this break out session from a recent Enterprise DNA Learning Summit workshop, we are diving into how you can showcase data clusters in Power BI.
Not only this we are also showing how these data clusters change through time.
There are many DAX concepts and also visualization techniques discussed during this tutorial.
Enjoy.
Sam
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn
FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv
FREE – Power BI Resources – https://ift.tt/2LiAVQj
FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95
Learn more about Enterprise DNA – https://ift.tt/2LiAWDR
Enterprise DNA Membership – https://ift.tt/2IJLxWD
Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563
Download Excel File: https://ift.tt/2jXe8yh
In this video see how to create an Excel Formula that can calculate the Last Working Day In The Month using EOMONTH Function and the WORKDAY.INTL function.
Advanced Excel Course Trailer. Free Advanced Excel Training from excelisfun YouTube Learning
Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
Learn Advanced Excel from the world renowned Excel Educator, Mike Girvin, Microsoft Excel MVP and Highline College Professor. 27 videos, free notes, Excel files and homework problems make this the #1 Free Online Advanced Excel Class in the world. This class uses the amazing new YouTube Learning Playlist structure.