MrExcel Excel Videos

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

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.