Learn Excel from Bill Jelen with this daily 2 minute video podcast.
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.
posted by Bill at 9:00 AM
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.
Labels: dates, Pivot Table
posted by Bill at 9:00 AM
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.
Labels: dates, text to columns
posted by Bill at 9:00 AM
Learn how to filter a pivot table to only items from this week, last quarter, or next month. Episode 710 shows you how.
Labels: dates, Excel 2007, Filters, Pivot Table
posted by Bill at 9:00 AM
Excel offers amazing tools to group daily dates to months, quarters, years, or weeks. Episode 709 will show you how.
Labels: dates, Excel 2007, Grouping, Pivot Table
posted by Bill at 9:00 AM
Calculate the last day of this month, using a new trick sent in by Bob. Episode 688 shows you how.
Labels: dates, end of month
posted by Bill at 9:00 AM
