MrExcel Excel Videos

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...

Rekha viewed episode 655 where I used Group Field in a pivot table to create a year-over-year report. But Rekha needs current month from last year, current month from this year, variance, then YTD through current month from last year, YTD this year, variance. Urgently. In Excel 2010. While this would be a perfect report for Power Pivot, Rekha hasn't come up the Power Pivot learning curve yet. And we need the report urgently. I am calling this an impossible pivot table because once you group daily dates to months and years, you are not allowed to add a calculated item inside the pivot table to show a variance. Many ideas flashed through my mind: Run the data through PowerPivot and used Named Sets. Make two pivot tables side by side...

You have a list of debuts and credits. For each amount, match it with the next matching negative amount. After doing all of the matches, find the items without a match. Bill uses VBA and Mike uses some clever math.

Catherine is building a risk assessment tool in Excel. She needs to add 200 checkboxes to a worksheet, but this is a daunting task to do manually. Today, episode 1871 shows a way to do checkboxes without using Controls. A little Wingdings and 8 lines of VBA are all you need.

Sunnee asks if there is a formula for identifying people who were tardy more than three times within an eight week period. Provided the data is sorted from earliest to latest, the formula in today's episode will solve the problem.

Trying to write an insane formula to solve another poorly formatted spreadsheet.

Enter a product on Sheet 1. You want a VLOOKUP formula to grab the description from a lookup table on Sheet 2. However, if the product is missing from Sheet 2, you want Excel to stop, ask for the correct description, and then add that to the Lookup table so future entries for this product will get the proper description. Today's episode uses a VBA Macro to achieve this result. The video is based on the question originally posted here: How to Create a dynamic Unique list that updates automatically You can copy the VBA code from that link so you do not have to type the code.

Every once in a while, you run into ugly data sets and this qualifies. Someone decided it would be brilliant to put the text category and the sales amount in a single cell such as "WXYZ123". Today's duel is how to get the total sales for each category. Mike and Bill go back and forth 4 times today, offering a solution with Text to Columns, a Pivot Table, Array Formulas, and a VBA UDF.