MrExcel Excel Videos

Abhijeet asks if it is possible to add a label to the midpoint of a line chart with some descriptive text. In the process, you will see some nice charting improvements in Excel 2013, including the all-important Values from Cells option for chart labels.

Tracy from Texas asks about how to filter a pivot table to only show the rows where the calculated item is not zero. With a data set of invoices and payments, I will show you how to create a pivot table, add a calculated item for Balance, hide the grand total column, then a hack to filter the pivot table to show items with a non-zero balance.

Can you draw a line in Excel Power Map? Well, it is not built-in, but you can use some interpolation in Excel to simulate a line.

Some days, you don't have time to watch a long video to learn something cool about Excel. Introducing the Excel Quick Tips at 40+ Amazing Excel Tricks ideas | excel, microsoft excel, microsoft

Phsa asks how to plot every 100th row in Excel. Episode 1919 uses a quick Formula-Based Criteria and an Advanced Filter to solve the problem.

My best wishes to Ian at the Footscray Community Arts Centre. After five years of bringing great Excel tips to his co-workers, he is moving on to pursue a Master's Degree. His co-workers sent in their favorite Ian tips.

Ahmed is looking for a formula that will return certain text if another cell has been crossed out. This is not possible with the Excel built-in functions. But it is possible using a User Defined Function in VBA. Today's episode shows you how.

In Excel, Page Down goes down one screen. Ctrl+Page Down goes to the next worksheet. How do you do Page Down to go right one screen full of columns? In today's episode, we look at Alt+Page Down, plus how to go right one screen in a macro. This is the first mention of the upcoming book, Excel Macro Recorder Success.

I was doing a webinar and it sounded like a simple question; how do you delete a slicer in Excel? But, when you delete a slicer, why does Excel seem to remember the slicer settings?