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
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.
Download Zipped Folder with All Files: https://excelisfun.net/files/13-M365ExcelClassVideoFiles.zip
This video is a comprehensive lesson in Power Query Importing & Transformation Data in Excel & Power BI. This video shows extensive M Code to create formulas to convert bad data into proper data sets that can be used for analysis.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (02:24) On-Premise Folder and File Path
3. (03:11) Importing TXT and CSV files
4. (08:08) Create Dynamic File Continue reading “Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13”
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
how to add a second level subtotal feature excel
how to subtotal by two levels in excel
how to subtotal multiple columns in excel
excel how to make multiple subtotals
how to add multiple subtotals in excel
how to create multiple subtotals in excel
how to create multiple subtotals in excel?
can you filter by subtotal on excel?
how to keep subtotal in excel when filtered?
how do i get a subtotal with filters in excel?
how do i subtotal filtered data in excel?
how to get subtotal in excel after filter?
how to subtotal data in excel with filters?
how to subtotal in excel with filters?
how to use subtotal in excel with filters?