MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Learn Excel - MrExcel Review of Excel for iPad - Podcast 1874
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...
Learn Excel - GetPivotData to Solve Impossible Pivot Table - Podcast #1873
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...
Learn Excel - Self-Maintaing Lookup Table - Podcast #1868
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.
Dueling Excel - Category and Settings in Same Cell - Duel 154
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.

Forum statistics

Threads
1,226,694
Messages
6,192,473
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top