What is your favorite font in Excel? Anna and Lisa showed me the Consolas font. It is great because you can tell zero from O and one from lower case L.
Table of Contents
(0:00) Axel font for Excel
(0:19) Typewriters without a 1 key
(0:54) People who type L instead of 1
(2:04) How I met ExcelisFun
(2:37) Make a custom Office Theme with Consolas font
(3:32) Applying a custom office theme
(3:45) Making a theme be default
(4:09) Default Font in Excel Options
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (March 4, 2023) (Member Chat 2nd Half)”
Diane has a fairly complex pivot table. She is using GETPIVOTDATA to pull data from the pivot tables to a summary report in another workbook. In another section of the report, she needs to pull YTD. But this complicates the formula, because she has to add an expanding range as the months continue.
I mentioned that she could create a second pivot table that shows the sales numbers as YTD numbers. This video shows how to copy the first pivot table and how to use Running Total In to convert from monthly sales to YTD Sales.
Thanks for this tip from Paul A who was in my Akron seminar.
Paul uses a function like SUM(XLOOKUP:XLOOKUP) to return the total of all numbers from a start date through an end date.
Are you using Power BI within Microsoft Teams? Daniel joins us to show the possibility of leveraging Microsoft Teams and the different ways to use Power BI.
Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
https://powerbi.microsoft.com/en-us/blog/announcing-embed-your-power-bi-organizational-apps-in-microsoft-teams-channels-and-meetings/
Daniel Glenn:
https://twitter.com/DanielGlenn
https://www.linkedin.com/in/danielglenn/
https://365mcs.com/
https://www.youtube.com/365mcs
📢 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!
*******************
— http://twitter.com/guyinacube
— <a Continue reading “The MAGIC of Microsoft Teams + Power BI”
Using Merge statements? Alex shows you how that can break the fold in Power Query! He’s got you covered though and shows you a different way to approach it to make folding work! Using the UI!
Alex Powers:
https://twitter.com/notaboutthecell
https://www.linkedin.com/in/alexmpowers/
https://itsnotaboutthecell.com/
📢 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!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube
subtotal a column in excel
how to add subtotal function in excel
how to formulate subtotal in excel
how to subtotal sum in excel
how to use subtotal in excel for sum
using subtotals in excel to sum
how do you do a subtotal in excel
how to automatically subtotal data in excel
how to automatically subtotal rows in excel
how to calculate subtotals in excel
how to insert subtotals into excel
excel how to make subtotals
excel how to subtotal
excel how to use subtotals
how create subtotals in excel
how do i add subtotals in excel
how do i do a subtotal in excel
how do i do subtotal in excel
how do i use the Continue reading “Adding Subtotals In Excel”
excel how to get rid of subtotals
how do i remove subtotals in excel
how remove subtotals in excel
how to do subtotal remove all in excel
how to remove a subtotal in excel
how to remove all subtotals in excel
how to remove excel subtotals
how to remove subtotal excel
how to remove subtotal in excel
how to remove subtotals in excel
how to remove the subtotal in excel
how to undo subtotals in excel
remove subtotal in excel
how to take out a subtotal in excel
how to eliminate subtotals in excel
how to remove – from excel to show subtotal
There was a scary post online today… the Excel Status Bar sum was WRONG! But it is not wrong… it is a great trick that will win you bar bets from your Excel guru friends!
The Status Bar sum is CORRECT when you select from bottom to top!
But it is INCORRECT when you select from top to bottom!
Down in the YouTube comments, tell me how I managed to do this.
It required no VBA. You can easily do it yourself and freak out your Excel guru friends!
Don’t feel bad… when I first saw it, I could not figure it out Continue reading “Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts”
how do i copy only subtotals in excel
how to copy excel subtotals only
how to copy just subtotals in excel
how to only copy subtotals from excel
how to extract excel subtotals
how to extract subtotal from excel
how to collapse subtotals in excel
how to see only subtotals excel
excel subtotal how to sort
how do i sort subtotals in excel
how to data sort subtotal in excel
how to sort a subtotals list in excel
how to sort and subtotal in excel
how to sort by subtotal in excel
how to sort subtotal data in excel
how to sort subtotals in excel