MrExcel Excel Videos

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.

Excel randomly choose Yes or No. Use CHOOSE and RANDBETWEEN for a roughly 50/50 split. Or use IF and RAND to generate an approximate percentage of one or the other.

Microsoft Excel tutorial on randomly sorting a list. Sort a list into random sequence. Can Excel Randomly Sort Data? Excel Create Random Order? Excel Random Sort? Can Excel Randomly Sort Data? Excel How To Random Sort? Excel Random Order? Excel Random Order List? Excel Random Row Order? Excel Create Random Order?