Episode 222 - Sales by Product and Rep

As you learned this week, SUMIF and COUNTIF are the coolest functions, but as you try to use them for something that is just a tiny bit more powerful, they fail. What happens when you have to SUMIF based on two conditions? You will have to turn to a really complicated kind of formula called an array formula. Luckily, Excel offers an add-in that will help you build these formulas. Episode 222 will show 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!

Episode 221 - Total Sales by Rep

Use the SUMIF function to figure out the total sales for each of the sales reps in the database. Episode 221 will show 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!

Episode 220 - Age Discrimination

I can't help but thinking that this request is going to lead to an age discrimination lawsuit in a few months. Today, the managers want an analysis of our employees by certain age bands. The COUNTIF function comes to the rescue, but you have to jump through a few more hoops to make it work. Episode 220 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!

Episode 219 - Headcount by Department

I hate when senior managers ask for headcount by department. It always means that they are looking for a way to trim costs. This podcast won't avert any cost cutting, but it will allow you to produce the report easier. Episode 219 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!

Episode 218 – COUNTIF

If you need to count records, use the COUNTIF function to count employees who meet a specific criteria. Episode 218 will show 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!

Episode 217 - Gotchas when using VLOOKUP

Is VLOOKUP not finding all your entries? Find out why and how to fix it. Episode 217 will show 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!

Episode 216 - Matching Customers Using VLOOKUP

Compare and then add new customers and update revenues from daily lists using VLOOKUP. Episode 216 will show 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!

Episode 215 - Using VLOOKUP instead of MATCH

Use VLOOKUP to find the exact match when comparing two lists. Episode 215 will show 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!

Episode 214 - Lucent or Lucille Ball

Learn how to compare two list to find an exact match. Episode 214 will show 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!

Episode 213 - Set up a Simple Time Sheet

What? I work hard all week and Excel can't add up the hours? Find out how to total those hours in two minutes! Episode 213 will show 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!

Episode 212 – Last day of February?

How can you convert a date to the last day of the month? This is hard! 31 days? 30 days? 28 days? 29 days? What is the leap year rule? Never mind - this St Patrick's day podcast solves the problem without worrying about any of those issues. Episode 212 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!

Episode 211 - Daily Dates to Months for Real

OK....the trick that I used in podcast 210 happened to work for automatic subtotals, but it won't work for a lot of other formulas. Episode 211 will show you the real way to solve this problem, reliably, day after day.

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!

Episode 210 - Daily Dates to Month

Make a series of daily dates appear as a month. Episode 210 will show you how. As a bonus, check out the subtotal feature at the end of the podcast.

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!

Episode 209 - Relay Races

10 runners each ran for about 3 minutes and Excel gets a total of 7 hours! I hate when Excel gives what appears to be the wrong answer. In Episode 209, see why Excel whacked out with this simple time problem and how to fix it.

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!

Episode 208 - Time as Text Part 2

In today's episode, someone keyed in hundreds of cells with time and they keyed them all as text. Luckily, though they keyed it in a format that looks exactly like a time Excel would understand. The formula for today's solution is far easier than podcast 207. Episode 208 will show 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!

Episode 207 - Time Entered as Text

Someone entered a million time values as text. How can you convert them to real times? Episode 207 will show 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!

Episode 206 - Time Formats

Learn the obscure formats to make your time calculations work out. Episode 206 will show 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!

Episode 205 - Slow Motion Instant Replay

Rather than drawing a million blue arrows on your worksheet, use the Evalutate Formula functionality to watch a formula get calculated in slow motion. This great new tool allows you to see all of the precedent cells, and also how the precedent cells are calculated. Episode 205 will show 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!

Episode 204 - More Precedents

Use the Formula Auditing tools to find all of the precedents. Episode 204 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!

Episode 203 – Finding Precedents

When you have a large formula, all of the cells that are used in calculating that formula are called Precedent Cells. Episode 203 shows you how to navigate through the precedents using GoTo Special.

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!

Episode 202 - Claiming Dependents

It is tax time, but THESE dependents are not the kind that you have to feed. Before deleting a row, find all of the cells that utilitze the values in that row using the Formula Auditing Arrows. Episode 202 will show 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!

Episode 201 – Order of Operations

Excel has a certain order that it will perform a calculation. Learn the default order of operations and how to override this behavior in Excel. Episode 201 will show 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!

Episode 200 - When 2 + 2 = 5

Are you updating numbers in your worksheet but the calculations are not updating? Episode 200 gives you some details on manual calculation mode.

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!