Download Excel File: https://ift.tt/2LKocWo
See an unusual randomizing formula for the Excel Worksheet and the Conditional Formatting dialog box to make Excel randomize conditional formatting, se to 80s music. This is an excelisfun YouTube Channel Flashback Friday back to a video that I made in 2008.
Tag: How to
How to FILL BLANK CELLS in Excel (with 0 or Text or Formula)
In this video, I will show you a super-fast way to select all the blank cells in a data range and fill these blank cells with any value/formula you want.
To select all the blank cells in a data range, you can use the Go To Special dialog box. In the Go To Special dialog box, there is an option called Blank – which instantly selects all the blank cells at one go.
Once you have all the blank cells selected, you can fill all these at one go by first typing the content that you want in these blank cells and then using Control + Enter (hold the control key and press the Enter key).
Doing this would fill the content in the active cell in all the blank cells, that were already selected.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
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 #Excelin2Minutes
Dynamically generate tips in Power BI for your audience
I have recently released my first template app which is free to download here: http://bit.ly/2othNWm and in that app I created a tip section on each page that regenarates each time someone refreshes the app or it gets automatically refreshed.
If you want to know how I did that, check this video out! #curbal
Here is a blog post detailing everything you need to know about the app: http://bit.ly/2omjzZ8
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
Multiply an Entire Column by a Number in Excel (without using a formula)
Are you looking to multiply an entire column or range by a number?
You could always use another column and have the formula to do this, but this way is quick and easy if you do not plan on changing the values.
- All you need to do is have the number that you want to multiply in a cell (any cell).
- Now copy this cell and paste as special in the cells/range/column where you want to multiply it.
- In the Paste Special dialog box, choose the multiply option (in the Operation section) and click OK. Your column/cells/range should be multiplied!
- If desired, can delete the cell that has the value which you multiplied by.
The resulting data is static/fixed so there’s no need to change any formula to value after multiplying using the paste special function.
As always, I hope this helped you! Simple solutions are the best!
If I helped you, please consider buying me a coffee via PayPal! Thanks!!
Subscribe for more great content!
Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)
When you filter data, getting the SUM of only the visible part of the data can be a challenge. If you use SUM function for it, it will show you the SUM of the entire range (visible as well as hidden).
In such cases, when you want to get the sum of filtered data only (i.e., the cells that are visible), you can use the SUBTOTAL function. SUBTOTAL function can ignore hidden rows (either through filters or done manually) and can give you the following values:
— SUM
— AVERAGE
— COUNT
— COUNTA
— MAX
— MIN
— PRODUCT
— STDEV.P
— STDEV.S
— VAR.S
— VAR.P
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
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 #Excelin2Minutes
Guide to the Acquisition Page in the Google Analytics Template App
I have released my first template app and is Free to download here: http://bit.ly/2othNWm
In this video, I will guide through the main functionality of the Acquisition’s Page. How to interact with the visuals and what insights you can gain from it.
Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8
and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk
Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U
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
Guide to the User’s Page on Google Analytics Template App by Curbal
I have released my first template app and is Free to download here: http://bit.ly/2othNWm
In this video, I will guide through the main functionality of the User’s Page. How to interact with the visuals and what insights you can gain from it.
Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8
and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk
Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U
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
Guide to the Site Search Page in the Google Analytics Template App
I have released my first template app and is Free to download here: http://bit.ly/2othNWm
In this video, I will guide through the main functionality of the Site Search Page. How to interact with the visuals and what insights you can gain from it.
Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8
and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk
Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U
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
Actuals vs Budgets – Comparison Insights w/Power BI
In this tutorial, I run through how you can compare actuals to budgets in Power BI.
This is an extension of a prior tutorial that covers how to create the ultimate budget calculation with DAX.
***** 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 Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609
Download Excel File: https://ift.tt/2omI7l3
Learn how to sum the digits of a number. See 4 examples. See Method 1 that will work in all versions of Excel. See a method that works in Office 365. And See two methods that will work if you have decimals.
DAX Fridays! #143: ADDCOLUMNS and SUMMARIZE | Create virtual tables
In todays video I will show you how to create virtual tables to make more advanced calculations using ADDCOLUMNS and SUMMARIZE. #
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
Dynamic Array & Old Array Formulas to Create Student Classes Report – Excel Magic Trick 1608
Download Excel File: https://ift.tt/2lWBWDr
Learn how to create a report that shows each student by quarter with a list of classes in a single cell. See many of the new Excel 365 Functions like: SORTBY, UNIQUE, FILTER, TEXTJOIN and the ROWS Function. See how we can combine Spilled Arrays formulas and Old School Arrays Formulas together to make a report that automatically updates when new data arrives.