MrExcel Excel Videos

Microsoft Excel Tutorial: Fast way to fill blank cells with value from above in Excel. In Podcast 2367, Bill Jelen demonstrates a quick method to fill down blank cells in Excel with the value from the cell above in just 11 keystrokes. Deepak's data consists of 50 rows and four columns with numerous blank cells that need to be populated with values from the cells above. Here are the 11 keystrokes to accomplish this: 1. Select the data. 2. Press Ctrl+G or F5 to open the Go To dialog. 3. In the Go To dialog, press Alt+S to select "Special." 4. Inside "Go To Special," press Alt+K to select "Blanks." 5. Press Enter to confirm the selection. This will highlight all the blank cells in the selected range. 6. Type an equals sign (=) to...

Microsoft Excel Tutorial: Copy and paste this VBA code: Sub ChangeSheetNameAllWorkbooks() Dim WB As Workbook For Each cell In Selection Set WB = Workbooks.Open(cell.Value) WB.Worksheets(1).Name = Left(WB.Name, Len(WB.Name) - 5) WB.Close SaveChanges:=True Next End Sub Today's question from Lakshmi. She wants to bulk change all workbooks in a folder so that the Sheet name is the name of the workbook. In this special case, there is only one worksheet per workbook. I talked to Lakshmi and asked if the workbook name is C:\Customers\Apple.xlsm then the sheet name would be Apple. This workbook shows off three skills Table of Contents (0:00) Welcome and Question (0:33) Use Power Query to bring a list of files into Excel (1:36) Launch Excel...

A strange question today: What is the "correct" way to select consecutive worksheets in Excel? Along the way, you will also see: How to select non-consecutive worksheets in Excel How to have the page number for Sheet2 continue after the last page number for Sheet1. Link to the original question on Quora: Bill Jelen's answer to Which is the correct process for selecting consecutive worksheets? - Quora Table of Contents (0:00) Introducing the question (0:19) Using Ctrl+PageDown or Page Up to move between sheets (0:34) Using Ctrl+Shift+PageDown to select consecutive sheets (0:44) Using the mouse to select consecutive sheets (1:01) How to select non-consecutive sheets in Excel (1:10) Changing data or formatting on several Excel worksheets...

25kasa1 has numbers with the decimal points missing. How can you quickly change 5000 to 50.00 in an entire column. In less than 2 minutes and 40 seconds, this video shows 6 methods PLUS a way to prevent the problem in the first place. Includes Formulas, Power Query, VBA, and Paste Special.

Microsoft Excel Tutorial: Using Excel to randomly draw a winner. In this episode of the MrExcel netcast, Bill Jelen announces a giveaway of three pairs of Excel-themed socks and shares some insights about his YouTube subscribers. Bill initially encountered difficulty in obtaining subscriber data from YouTube due to privacy settings. However, he managed to gather data from 37,000 subscribers who had set their subscriptions to public. Bill explores this subscriber data, revealing fascinating trends. He analyzes when his current subscribers first subscribed, noticing some who joined even before he began posting videos on YouTube in 2009. Bill also looks into how many subscribers his subscribers have, discovering that a significant...

Today's Excel question from Rico: How to combine columns that have the same header? I first use Consolidate and then a formula solution using UNIQUE and SUMIFS. Although - I discover a new bug in Consolidate.

Another episode of the Dueling Excel podcast. This time, we tackle Siva's problem of how to add 500 to a cell that contains many numbers: 123,234,345,456. Last week, in Duel 192, Bill used VBA and Mike used LET. Today, we both use Power Query, but in completely different ways. Bill seeks out the Power Query equivalent of the DAX CONCATENATEX function and finds a formula bar hack with Text.Combine. Mike seeks a single-formula solution in Power Query but runs into a problem using "each" with two iterators. Table of Contents (0:00) Introduction of the problem (0:37) Bill's Power Query solution (2:31) Concatenating text in Power Query with Text.Combine (3:39) Mike's Solution (6:09) Mike explains "each" keyword (6:55) Difficulty due to...

A look at a free add-in from Sam Radakovitz on the Excel team. This tool lets you create fake data or sample data. If you need Excel data for your next book, blog post, YouTube video, or just to make it look like you've been hard at work, the Fake Data tool makes it easy to create the data. Download from Fake Data — Sam Radakovitz Table of Contents (0:00) Introduction (0:32) Generating tables of fake data (1:19) Adding columns to existing data (2:50) Changing case in Excel data (3:21) Cleaning web characters from data (4:20) Wrap up

Download the add-in from Fake Data — Sam Radakovitz Today, a review of a free Excel add-in from Sam Radakovitz. This add-in will help you to change you data before sending it to someone. You can mask names, change numbers, and so on. Table of Contents (0:00) Introduction (0:34) URL to download add-in (1:00) Alter data in Excel (1:13) Remove last name from names (1:25) Change cities to other city names (1:43) Change all numbers to randomize them (2:36) Change first names to other names (2:52) Wrap up