MrExcel Excel Videos

I love doing Power Excel seminars. I was in Fort Wayne, doing a seminar at a baseball stadium, when a question popped up: If I double click on Sunday, it automatically fills down with Monday, Tuesday, Wednesday. Will your Ctrl key trick work to make it Copy? I don't want to have to use the pop-up menu to change back to Copy instead of Fill. Why was this a great question? Because I had no idea that double-clicking a cell would cause the AutoFill to work! In episode 1881, you will see how to AutoFill by Double Click, how to set up a custom list, a workaround to prevent the AutoFill and make it a copy, plus, in the outtake, a formula using INDEX ROW and MOD together.

Michael has data in column A. He needs to extract everything after the dash to column B. This podcast shows four different methods. If you ever wondered how to create fake data for your own Excel podcast, watch the outtake at the end. For information on the May 9 Tampa Power Excel seminar, visit: ow.ly/w9xMG

If you change your zoom to 39% or lower, Excel 2013 will show you the name and shape of your named ranges. Thanks to Excel MVP Bob Umlas for showing me this great trick!

Darvaish asks how to keep leading zeroes during data entry. If you type 0523 in Excel, it changes to 523. Today's episode offers three solutions.

Thanks to #NASASocial and SpaceX, I was invited to watch the Falcon 9 rocket launch on April 18, 2014. SpaceX gave us great swag bags that included a Dragon Docking Simulator. Check out the simulator in action. NASASocial offers opportunities to get an inside look at the science happening at NASA. Apply at NASA Socials

If any record for the project is marked Finished, highlight all records for that product in green. Bill and Mike try different methods, such as COUNTIFS, LOOKUP, and Conditional Formatting.

You want to use some VBA to save a file to the desktop. But what is the real path to the desktop? It is not C:\Desktop\. In this episode, an arcane function = INFO to return the path of the current workbook.

NASA's Steven Cox explains how he used Excel's shapes and hyperlinks to prototype a rocket launch system in Excel. For information on NASA Social: NASA Socials Pictures from the event: NASASocial SpaceX3 and Jared

A look at the feature on the new Excel for iPad. A complete list of what works and does not work is here: http://www.mrexcel.com/learnexcel/2014/03/28/excel_for_ipad/ Table of Contents 0:01 History 0:40 First look 0:50 Summary of what is supported 1:20 Office 365 needed to edit 1:44 Building a worksheet from scratch 2:40 Alignment of Text 2:55 Entering a formula 3:21 Copy and Paste 3:45 Fill from 2 cells 4:00 Format as Table 4:37 16 Million colors 5:15 Shapes with Text 6:15 Pictures 7:00 Toggle Formula Bar, Headings, Freeze Panes 7:12 Merged Cells 7:30 Selecting a Range 7:40 Inserting Charts 8:42 Number Formats 9:00 Inserting/Deleting Rows 9:18 Sorting 9:30 Saving 10:00 New Template 10:22 Big File 10:48 Find, no Go To 11:00 AutoSum...