This video introduces matriculating Highline College students to Busn 218, Spreadsheet Construction.
Tag: learn
DAX Fridays! #141: How to find all DAX functions and videos quickly!
In today’s video, I will show you how you can find all DAX functions and tutorials quickly and also how to embed them in teams to get access to them quickly!
#curbal #powerbi
Link to mentioned resources:
MS ref guide; https://ift.tt/1rRy2co › en-us › dax › dax-function-reference
DAX Fridays glossary: https://curbal.com › blogglossary
https://ift.tt/2ZUN866
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
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
☼☼☼☼☼☼☼☼☼☼
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!Here you can download all the pbix files: https://ift.tt/2yGx9Ih
▲▲▲▲▲▲▲▲▲▲
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
************
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
#daxfridays #curbal #dax #powerbi #mvp
Discovering Advanced Insights w-Power BI – Enterprise DNA Webinar Series
TO DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2I5zFxw
Workshop Session Topics:
– Advanced DAX formula techniques
– Measure Branching
– Time Intelligence calculations
– Moving Average formulas
– Cumulative Total formulas
– Visualization techniques
– and others
When is it?
Wednesday, September 11th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT) – Thursday, September 12th , 8am Sydney (AEDT), 10am Auckland (NZST)
Where is it?
Join in from your laptop/desktop
How long is it?
Session will run for between 45 – 60 mins
Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!
Why should I be there?
To learn how to harness the real analytical power behind Power BI.
Review of the Power BI desktop update September 2019 – Power Week!
It is #powerweek so we are going to review #powerbi desktop updates for September 2019.
Which ones are your favourites? Or least favourites? Let me know 🙂 #curbal #powerbi
This is the list of the features I review:
1. New default theme on power bi
2. New capabilities on JSON theme (a more indepth video coming soon.
3. Conditional formatting available for more visuals. Learn how to conditional format here: https://www.youtube.com/watch?v=CPN2LgVRla0
4. Unpin power bi default visuals
5. Custom field types available like in excel
6. Drilldown discoverability
7. Download column profiler data from power query
8. Performance improvements
9. Install power bi desktop on remote computers.
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
▲▲▲▲▲▲▲▲▲▲
************
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
#POWERWEEK #CURBAL #SUBSCRIBE
3 Easy Ways to UNHIDE ALL SHEETS in Excel (with & without VBA)
In this video, I will show you how to unhide worksheets in Excel (with or without VBA).
In Excel, you can hide multiple worksheets at one go but you can not unhide multiple sheets at one go. If you use the inbuilt functionality to unhide sheets, it will only unhide one sheet at a time.
However, there are a couple of methods you can use to unhide all sheets at one go in Excel.
This video covers the following methods to unhide sheets:
— Manually Unhide one sheet at a time
— Unhide all sheets using VBA code in the immediate window
— Unhide all sheets by using a VBA macro code and adding it to the quick access toolbar
— Unhide sheets using custom view option.
With VBA immediate window, you can quickly run a line of code by simply adding it in the immediate window and hitting the enter key.
Below is the line of code to use in the immediate window in the VB Editor:
For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet
As soon as you hit the enter key (after placing the cursor at the end of the line), it will instantly unhide all the hidden sheets.
The good thing about this is that you don’t need to save the Excel workbook as a macro-enabled workbook.
Another method is by saving a VBA macro code to unhide sheets in the personal macro workbook and then adding that code to the Quick Access Toolbar (QAT)
Doing this would allow you to work on any workbook and instantly unhide sheets with a click of a button.
Below is the VBA code to save in the personal macro workbook:
Sub UnhideAllSheets()
For Each Sheet In Sheets
Sheet.Visible = True
Next Sheet
End Sub
The third method to unhide sheets is by using custom views. You can save a custom view when all the sheets are visible and then when you have to unhide all the worksheets, you can go back to that view.
This method to unhide sheets is not suited in all situations but can be useful if you’re using custom views anyway.
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial
Automate your work from the couch with Microsoft Flow | Couch flowing
I have spent my weekend couch flowing, that is making microsoft flows from my couch 😉
I asked you if you wanted to see some of the flows, so here is the first one. Hope you enjoy it! #curbal #msflow #flow
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
#CURBAL #SUBSCRIBE
DAX Fridays! #140:Flat tables or models in Power BI? Which one should I choose and why?
Should you work with flat wide tables or create models in Power BI? In this video, I walk you through the advantages of creating models instead of flattening your tables.
#curbal #daxfridays #powerbi
Link to resources mentioned in the video:
About Vertipaq: https://www.youtube.com/playlist?list=PLDz00l_jz6zyfWLZIu8psvTESmKuVDUoG
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
☼☼☼☼☼☼☼☼☼☼
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!Here you can download all the pbix files: https://ift.tt/2yGx9Ih
▲▲▲▲▲▲▲▲▲▲
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
************
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
#daxfridays #curbal #dax #powerbi #mvp
The Ultimate Budget Allocation Methodology For Power BI Analysis
When working on budget data inside Power BI you need to solve and manage data at different granularities.
In this video I work through the ultimate formula for allocating budgets to daily results.
I also work through all individual steps in the formula so you can see how it all works in together.
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
Steps To Mastering Power BI & DAX
TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2LINHHM
When is it?
September 4th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
September 5th, 8am Sydney (AEDT), 10am Auckland (NZST)
Where is it? Join in from your laptop, desktop or connected device
Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!
During This Free Training, You Will Learn:
– The 4 Key Pillars To Any Power BI Development
– My Top, Best Practice Tips For Building Power BI Reports
– Showcase The Power Of The DAX Formula Language
– How To Combine Analytical Techniques To Solve Problems
If you have questions regarding this training, please send it at https://ift.tt/2xDKj94
Extract Customer Names, Not in Master Lists with Power Query – Excel Magic Trick 1599
Download Excel File: https://ift.tt/2ZxRsIb
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1using Power Query. See how to use the Merge feature, and the join operation; Left-Anti Join. Also see how to extract items in both lists using a Inner Join.
Related Video:
MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
#D52 Easy and fast infographics in Power BI 📈
In a previous video I showed you how to create infographics using the infographic designer, in today’s video I am going to show you how to do it without using the custom visual. #powerbi #curbal #infographics
Sources mentioned in the video:
Infographic designer tutorial: https://www.youtube.com/watch?v=XwOIIuRg-EI
Laura’s post: https://ift.tt/2PL3DNm
Here you can download the pbix files: https://ift.tt/2yGx9Ih choose community downloads and then #52
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
#POWERBITIPS #CURBAL #POWERBI #MVP
Extract Customer Names, Not in Master Lists with Advanced Filter – Excel Magic Trick 1598
Download Excel File: https://ift.tt/2ZNsHaA
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1, The Master List. See the Excel Worksheet Functions: MATCH, ISNA, ISNUMBER and COUNTIFS.