MrExcel Excel Videos

Microsoft Excel Tutorial - Creating Cluster Stack Chart in Excel. Jeff from Akron asks how to create a column chart where two series are stacked, but a third series is clustered. Episode 2595 shows you how. To download the workbook: Excel Stacked And Clustered Chart in Excel - Epsiode 2595 Sample Files - MrExcel Publishing This video requires Excel 2013 or newer. There is an older video for Excel 2007 or Excel 2010: For other variations: Leila has a video where each column has a Total (say 2000) and a second column showing a subset (say 500). That video is here: Jon Peltier sells a charting utility where there are quarterly clusters and every column contains a stack: bit.ly/41QxYdM Every demo of this chart has four quarters. Any...

Microsoft Excel Tutorial. When you go to File, Open, there is a Search box at the top. This search box often surprises me by offering files that are years old. I always wondered how it is working. My friends on the Excel team pointed me to Theo Lorrain-Hale, a Project Manager who worked on the search box. In this episode, I share tips for where the search box is actually searching.

In Excel... How does one create a character+number THAT ONLY UPDATES WHEN ENTERED and DOES NOT change with F9 or reloading the spreadsheet? I want to create sort of an inventory number that I can put on my 3D printer filament boxes to identify them quickly. But I don't want the inventory number to ever change after the first creation of the numbers/characters. This video answers these questions: Excel random not change? Excel random keeps changing? why does random number change in Excel? Excel random number without changing? how to stop Excel random number changing? can i generate random numbers in Excel? Excel and random number generator? Excel rand example? Excel random alphanumeric generator? Excel random character? Excel random...

Microsoft Excel tutorial on pivot tables. Todd wants to calculate (12/52)*Sales on each subtotal row in a pivot table. Bill shows how to add a calculated field to a pivot table and then uses some formatting to show the field only on the subtotal rows. To download the data: Excel Add A Calculation To Each Pivot Table Subtotal Row Epsiode 2591 Sample Files - MrExcel Publishing Table of Contents (0:00) Formula outside of pivot table (0:28) Calculated Field in Pivot Table (1:11) Verify the calculation (1:30) White Font trick (1:55) When pivot table changes (2:35) Wrap-up

Microsoft Excel how-to video about Running Totals in Excel. In one of my Bing Shorts, I showed two different ways to do Running Totals in Excel. And then, an interesting comment from Carlo in Italy with a running total formula that I've never seen before. To download the data from today, go here: Excel - Best Way For Running Totals - Episode 2590 Sample Files - MrExcel Publishing I had to bring that formula to Excel to visualize how it was working. It was cool that it used a colon next to INDEX. But is there a simpler way? In the video, I then compare four different Running Total Formulas. Which are easiest to enter? Which are easiest to explain? Which run the fastest? Thanks to Zack Barresse for teaching me how =SUM(Number,Text)...

Microsoft Excel tutorial on how to count records by week. This video includes three methods: Using Group Field in a pivot table to roll up to weeks. Using a formula of Data minus WEEKNUM(,3) to back the date to Monday. Using ISOWEEKNUM plus the year along with SORT, UNIQUE, and COUNTIF. To download the data, visit: Excel Count By Week - Episode 2589 Sample Files - MrExcel Publishing Table of Contents (0:00) Count by Week in Excel pivot table (0:43) Pivot convert dates to weeks (1:33) Using date minus WEEKDAY(,3) (2:19) Sort, Unique, COUNTIF (2:53) Using ISOWEEKNUM in Excel (3:30) Excel formula for Year and Week Number

Microsoft Excel Tutorial Can someone please help me??? I have an Excel file that has the cost column in cents so if something is 1.25 it is showing as 125 . When I change it to currency the numbers change to 125.00.... Anyone knows how to fix the issue faster than one by one. I have over 5,000 items to go through! In this short video, learn how to multiply an entire column by 0.01 to quickly convert 125 cents to 1 dollar and twenty five cents.

C. R. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Luckily, it is still there, but you have to know the arguments because Excel won't provide any guidance. This video answers these questions: is datedif still in excel is datedif in excel 2016 why does datedif not work in excel does datedif still work can't find datedif in excel does datedif still work datedif how to use how excel datedif works how to add datedif function in excel how to get datedif in excel how to enable datedif function in excel what replaced datedif in excel how to use datedif

Microsoft Excel Tutorial. Mary Ellen asks: It is easy to print one page of an Excel print range. But how do you send just one page to a PDF? The answer is there, but hidden.