Back in episode 2444, I had Tommy Tutone singing a crazy formula to reverse text in Excel. Today, a less musical way, but a much easier way.
Using the DOSE for Excel add-in, you can easily reverse text, making “ABCDEF” change to “FEDCBA”. However, Dose does even better, offering an option to take “Jenny Jenny I’ve Got Your Number” and changing it to “Number Your Got I’ve Jenny Jenny”.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Your manager asked you to double-space your data in Excel. In other words, he wants you to add a blank row between each row.
In a past video, I showed a Bob Umlas trick for double-spacing data.
Using the DOSE for Excel Add-In, you can double-space or triple space your data.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Excel sorely needs a date picker. In a previous video, I showed you the add-in from Sam Rad that has a date picker. In this video, take a look at the Date Picker included with the DOSE for Excel add-in.
I also take a look at their reading view, which essentially draws crosshairs to help you find the active cell.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you convert a number to words spelled out?
Microsoft has a SpellNumber function in an ancient knowledge base article.
Rather than copying that code to your Personal Macro Workbook, the DOSE for Excel Add-In will allow you to quickly convert numbers to words.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you select every other row in Excel? This video shows how to use the DOSE for Excel add-in to solve the problem quickly.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
You have a list of cells. You want to add a sequential number before the text in each cell.
This video shows how the DOSE for Excel add-in solves the problem. They actually add the sequential number into the cell. You can specify that the number should be separated from the existing text with a space hyphen space.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Do you regularly need to sort Excel worksheet tabs by sheet name?
The DOSE for Excel add-in makes this very easy, without any VBA.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Back in the days of COBOL, we called it Greenbar paper. There would be four rows of green and four rows of white. It helps your eye to follow the data across the page.
Today, Microsoft calls this banded rows.
Previously, we did this with conditional formatting and the MOD function.
Today, I am showing you a faster way using the DOSE for Excel add-in.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Danny from Stuart Florida noticed that when you group all worksheets in an Excel workbook, you can not protect or unprotect the worksheets. This episode offers two very short VBA macros that you can use to unprotect all sheets and then re-protect them with a password.
You are excited about Field Parameters in Power BI, but then realize you can’t use conditional formatting with them. What the french toast! Don’t despair! Patrick and Adam have some ways to get this working.
Matthias K. Question
https://youtu.be/ksmNfa_K8GQ?t=1011
Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Apply conditional formatting in tables and matrixes
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— Continue reading “Conditional Formatting with Field Parameters in Power BI???”
Holly from Vero Beach gets a report each week with Member ID. She needs to pull in the Member Name from last week’s report. This involves doing a VLOOKUP from one workbook to the other – Holly’s employers is on Excel 2016 instead of 365.
Amy from the St. Louis IIA asks: Is there a way to number the visible rows in a filtered list? This video shows how a formula of =SUBTOTAL(3,B$1:B2)-1 in cell A2 solves the problem.