Use the EXACT function to compare cell values, including upper and lower case. Get the links on my Contextures website:http://www.contextures.com/podcasts/pc20170518.html

Contextures Excel Roundup 20160306

Mar 6th, 2016 14m 27s

Pivot table sorting, how to split date and time, symbols in drop down lists, and many more tips. Get the links on my Contextures website:http://www.contextures.com/podcasts/pc20160306.html

Contextures Excel Roundup 20150831

Sep 1st, 2015 6m 23s

See the pivot table survey results, navigation tricks, dashboard design ideas, and many more tips. Get the links on my Contextures website:http://www.contextures.com/podcasts/pc20150831.html

Contextures Excel Roundup 20150817

Aug 18th, 2015 4m 33s

Pivot table survey, chart tricks, Power BI update information, and many more tips. Get the links on my Contextures website:http://www.contextures.com/podcasts/pc20150817.html

Contextures Excel Roundup 20150803

Aug 5th, 2015 3m 44s

See the Excel Survey results, create a seating chart for an event, compare Excel and Power BI, and more tips Get the links on my Contextures website:http://www.contextures.com/podcasts/pc20150803.html

Contextures Excel Roundup 20150721

Jul 22nd, 2015 4m 52s

Copy just the numbers in a column, show the month or day name for a date, let me know if you love or hate Excel Get the links on my Contextures website:http://www.contextures.com/podcasts/

Contextures Excel Roundup 20150707

Jul 7th, 2015 4m 39s

Use Rank in Excel pivot table, find free Excel add-ins, and more tipsGet links on my Contextures website:http://www.contextures.com/podcasts/

Contextures Excel Roundup 20150608

Jun 6th, 2015 4m 27s

In this week's Excel Roundup, --Watch a video on Taking Dashboards to the Next Level--See how Excel handles the display and entry of dates--Learn how to build a nested IF formula--Move fields in a pivot tableand many more Exce tips