MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
MrExcel's Learn Excel #375 - Ad-hoc Reporting
Today's netcast talks about an easy-to-create reporting tool - one that allows you to show the totals for any subset of a dataset. Watch Episode 375 for the complete details. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #374 - Logarithmic Scale
If you need to create a chart where each series contains both small and large numbers, it will be difficult to see the detail for the smaller numbers. Allow the chart to show detail of both the small and large numbers by using a logarithmic scale. Episode 374 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #373 - Charting Magnitude
Sometimes you want a chart to show two different kinds of data - for example, revenue, and gross profit percentage. If you create such a chart, the size of the revenue bars makes it impossible to see the detail in the profit percentage bars. The trick is to plot one of the series along a secondary axis. Episode 373 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #372 - Custom Charts
Once you have customized a chart, add the chart to your library of user defined charts. You can then apply all of that chart formatting to a new chart with a single keystroke! Episode 372 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #370 - AutoShape Formulas
Rather than static text in the AutoShape, use a formula to add dynamic text to an AutoShape. Episode 370 shows you how to create a shape that shows off the total of all sales made today. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
ADM Calculation - 1133 - Learn Excel from MrExcel Podcast
Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date of October 1. Given a start date and end date, how can you tell if the date is in that range? Episode 1133 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

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