MrExcel Excel Videos

Tom & Vicky ask about using Excel for basic household finance. Excel has a great suite of functions for this. Today, a look at using NPER to pay off your credit cards faster. Episode 998 shows you how. This video is the 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!

George sends in a question how can you convert a number to words? For example, how can you write $1234.56 as One Thousand Two Hundred Thirty Four dollars and Fifty Six cents. Although many utility packs offer this functionality, the VBA code is actually available for free from Microsoft. Episode 499 shows you how to add the code to your workbook. Be sure to stop back tomorrow for episode #500, when we will give away a treasure trove of prizes. 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!

In todays netcast, a question about how to create a running total and a running average. Episode 498 discusses how to solve both of these formulas. 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!

George sends in a question How can COUNTIF be made to look for cells that match a pattern? Episode 497 shows the long workaround to this problem. 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!

Do you hate the Zoom control on the standard toolbar? If you have a wheel mouse, there is a much faster way to zoom in and zoom out. Episode 496 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!

In yesterdays podcast, I proposed a formula to solve Jonathans dilemma of analyzing information by hourly buckets. An easier solution is to use the Group by Hour feature in a pivot table. Episode 495 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!

Jonathan from California has a column with date & time information, but would like to strip out just the times to do an analysis by hour. Episode 494 shows you two formulas that can be used to analyze the data by hour. 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!

In just about every pivot table tutorial, the writer tells you to start with a nice clean transactional data set. No blank rows, no blank columns, and no months going across the columns. David from Pennsylvania writes in to ask what to do if your dataset already is in a table with headings in the rows and columns. In Episode 493 I borrow a trick from Mike Alexander to solve this problem and make your dataset appropriate for use in a pivot table. 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!

Bob from Dallas writes in with a question. Bob has created a chart in Excel and needs to copy the chart to a slide in PowerPoint. For those of you who never leave Excel, PowerPoint is a tiny little Add-In that Microsoft created to help Excellers when they need to make presentations. Although there are 7 ways to accomplish this task, Episode 492 takes a look at the best way to get your Excel charts on to a slide in PowerPoint. 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!