dates

Episode 752 – Truncating to Date

               

In today’s podcast, we take a look at breaking Romas’ date/time column into a date column using the INT function. Episode 752 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(…)

Episode 751 – Grouping Dates

               

Romas has data with both date and time in column A…but needs to summarize the data by date. In Episode 751, we take a look at using a pivot table to solve this problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video(…)

Episode 732 – Dates from Text to Columns

               

Jonathan notices a problem when he uses the Text to Columns wizard. Baseball scores such as 4-3 are converted to dates. In Episode 732, we’ll take a look at how to keep those scores from being converted. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 710 – Pivot Filters

               

Learn how to filter a pivot table to only items from this week, last quarter, or next month. Episode 710 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(…)

Episode 709 – Pivot Dates

               

Excel offers amazing tools to group daily dates to months, quarters, years, or weeks. Episode 709 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!

Learn Excel from MrExcel