Internet Radio Podcast Directory Radio Playlists

By Keyword

By Location

By Genre

By Popularity
Trumix.com : Podcast : Technology : Computers

Learn Excel from MrExcel Video Podcast

Network:
Language: English
Category: Technology / Computers
Visit Website

-


RSS FeedView RSS | RSS FeedView in iTunes

Previous1 2 3 4 5 ...32 NEXT

Count >5 Minutes - 1050 - Learn Excel from MrExcel Podcast
Today's dueling Excel podcast question is how to count all cells with times greater than five minutes. Episode 1050 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 3 Jul 2009 13:00:00 GMT ]


Tracing Error - 1049 - Learn Excel from MrExcel Podcast
You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will show 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 2 Jul 2009 13:00:00 GMT ]


Shift-Tab - 1048 - Learn Excel from MrExcel Podcast
Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler. 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 1 Jul 2009 13:00:00 GMT ]


Rounding Correctly - 1047 - Learn Excel from MrExcel Podcast
After yesterdayâs podcast about ASTM E29 rounding, I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel. Episode 1047 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 30 Jun 2009 13:00:00 GMT ]


ASTM E29 Rounding - 1046 - Learn Excel from MrExcel Podcast
If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However, this will introduce errors. Episode 1046 talks about the errors introduced by this rounding. 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 29 Jun 2009 13:00:00 GMT ]


Dueling: Percentage Scrollbar - 1045 - Learn Excel from MrExcel Podcast
Izhak asks how to add a scrollbar to a worksheet for selecting a percentage. In this dueling Excel podcast Episode 1045, Bill and Mike will show you two ways to solve the problem.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 26 Jun 2009 13:00:00 GMT ]


Multi-Column Find - 1044 - Learn Excel from MrExcel Podcast
Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter....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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 25 Jun 2009 13:00:00 GMT ]


Parsing Variable Length - 1043 - Learn Excel from MrExcel Podcast
Dawn's file has name in A and address in B. Except: the address field in column B contains the name again. Episode 1043 shows how to parse the variable-length name out from column B.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 24 Jun 2009 13:00:00 GMT ]


Indian Pay Rounding - 1042 - Learn Excel from MrExcel
Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round down. Otherwise round up. While Excelâs built-in functions donât handle this, Episode 1042 shows you how to handle this using three functions in Excel. 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 t...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 23 Jun 2009 13:00:00 GMT ]


Future IF - 1041 - Learn Excel from MrExcel Podcast
Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at how to modify the original formula to calculate nothing until a score has been entered.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 22 Jun 2009 13:00:00 GMT ]


Dueling: Frequency Distribution - 1040 - Learn Excel from MrExcel Podcast
In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 19 Jun 2009 13:00:00 GMT ]


Round & Round - 1039 - Learn Excel from MrExcel Podcast
Gopal asks how to round a number up to the next whole number. Episode 1039 takes a look at several different functions available for rounding numbers in Excel.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 18 Jun 2009 13:00:00 GMT ]


Multiple Scatter - 1038 - Learn Excel from MrExcel Podcast
In Episode 1038 - a better way to create the multiple scatter charts from Episode 1031 and 1032. Thanks to everyone who wrote in with this better way to set up the data.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 17 Jun 2009 13:00:00 GMT ]


2nd Smallest - 1037 - Learn Excel from MrExcel Podcast
If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 16 Jun 2009 13:00:00 GMT ]


Better 1016 - #1036 - Learn Excel from MrExcel Podcast
Tom and Thor send in better ways to force the area chart under a portion of a line chart to drop to zero. Episode 1036 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 15 Jun 2009 13:00:00 GMT ]


Dueling: Up/Down Symbols - 1035 - Learn Excel from MrExcel Podcast
Jonathan asks how to insert an Up/Down arrow as the result of an IF statement. In Dueling Excel Episode 1035, Bill and Mike show you a few ways how to do this.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 12 Jun 2009 13:00:00 GMT ]


Count Visible Rows - 1034 - Learn Excel from MrExcel Podcast
Isabel asks how to count only the visible entries in a range. =COUNTA() is returning all of the values. Episode 1034 will show you how to count or sum the visible rows in a range.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 11 Jun 2009 13:00:00 GMT ]


Fiscal Quarter UDF - 1033 - Learn Excel from MrExcel Podcast
If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to add a couple of user-defined functions to your personal macro workbook to simplify the conversion of date to Fiscal Quarter or Fiscal Year.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 10 Jun 2009 13:00:00 GMT ]


Multiple XY II - 1032 - Learn Excel from MrExcel Podcast
Yesterday's podcast showed a tedious method for creating a chart with 5 XY series. Today, Episode 1032 shows a method for streamlining the creation of this chart.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 9 Jun 2009 13:00:00 GMT ]


Multiple XY Series - 1031 - Learn Excel from MrExcel Podcast
Pierre wants to create a chart with multiple XY series on the same chart. While this is possible, it is not extremely easy. Episode 1031 shows you one method for doing this.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 8 Jun 2009 13:00:00 GMT ]


Dueling: Average Non-Zeroes - 1030 - Learn Excel from MrExcel Podcast
Question from YouTube is how to average all the non-zero values in a range. In Episode 1030, Bill and Mike show several methods for solving the problem.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 5 Jun 2009 13:00:00 GMT ]


British Cattle (Really) - 1029 - Learn Excel from MrExcel Podcast
Yes - a podcast of use to 10,000 British Cattle Farmers but of no use to anyone else. Actually...it is a fun challenge. Play this one to see the problem then see if you can come up with a formula to extend the fine numbering system used for British Cattle! Episode 1029 will show 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 4 Jun 2009 13:00:00 GMT ]


Generalize Recorded Macro - 1028 - Learn Excel from MrExcel Podcast
While yesterday's podcast was created with the macro recorder, you can switch over to the VBA editor to change 4 lines of the macro. This will create a macro that will work without requiring you to rename the pivot table. Episode 1028 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 3 Jun 2009 13:00:00 GMT ]


Format Pivot Macro - 1027 - Learn Excel from MrExcel Podcast
Cheryl asks how to format all new pivot tables that she creates. The macro recorder can handle this, if you change the name of the pivot table before recording the macro. Episode 1027 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 2 Jun 2009 13:00:00 GMT ]


1016 Redux - 1026 - Learn Excel from MrExcel Podcast
Mario sends in an UGLY solution to episode 1016. Episode 1026 will show you how to highlight one segment of a line chart in Excel 2003. This episode wins an award for the ugliest workaround.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 1 Jun 2009 13:00:00 GMT ]


Dueling: Sort with a Formula - 1025 - Learn Excel from MrExcel Podcast
A dueling Excel podcast where Mike and Bill take a look at how to sort using a formula. While most people would use RANK and COUNTIF, Episode 1025 shows you how to use LARGE and ROW or ROWS.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 29 May 2009 13:00:00 GMT ]


Breaking out Columns - 1024 - Learn Excel from MrExcel Video Podcast
Todd has lottery data in a single column and needs to break the data into various columns. Episode 1024 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 28 May 2009 13:00:00 GMT ]


WIIW: Printable Background - 1023 - Learn Excel from MrExcel Podcast
Add a background picture to a worksheet that is printable and semi-transparent. Episode 1023 will show 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 27 May 2009 13:00:00 GMT ]


Fixing Data - 1022 - Learn Excel from MrExcel Podcast
Episode 1021 required that the survey data be set up vertically. Most survey tools like Survey Monkey would provide the data in a table format with questions going across the columns. In Episode 1022, learn how to quickly re-orient survey monkey data in a proper format for pivot tables.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 26 May 2009 13:00:00 GMT ]


Replicate Pivot - 1021 - Learn Excel from MrExcel Podcast
Patricia asks how to replicate a frequency distribution for many questions in a survey. If your data is set up correctly, this is a snap using the Show Report Filter Pages feature in a pivot table. Episode 1021 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 25 May 2009 13:00:00 GMT ]

Previous1 2 3 4 5 ...32 NEXT





O2 Arsenal Podcast
Sports
Listen to all the build-up ahead of Arsenal's next match with the O2 ARSENAL PODCAST!Dan Roebuck will bring you news, interviews and features before every Arsenal fixture - plus the chance to win great prizes in our exclusive competitions.

Happy House of Hentai
Arts
The weekly show for hentai news & reviews!

Ultima Thule Ambient Music Radio
Alternative
A weekly programme of ambient and atmospheric music from across the ages and around the world, broadcast on Australian public radio since 1989. Ultima Thule features a blend of ambient, trance, drone and chillout electronica, spacemusic, ancient, mediaeva

  Powered by PenguinRadio & PodcastDirectory.com  |  About Trumix  |  Terms of use  |  FAQs  |  Contact Us