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.htmlKirjoittanut Debra Dalgleish

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.htmlKirjoittanut Debra Dalgleish

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.htmlKirjoittanut Debra Dalgleish

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.htmlKirjoittanut Debra Dalgleish

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.htmlKirjoittanut Debra Dalgleish

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/Kirjoittanut Debra Dalgleish

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

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 tipsKirjoittanut Debra Dalgleish

Pivot Table % Running Total, best file format, build Excel add-inKirjoittanut Debra Dalgleish

Check formulas, fix Excel tables, save time with shortcuts, Power BIKirjoittanut Debra Dalgleish

Dashboard course, array formulas, faster VBA, rounding, big dataKirjoittanut Debra Dalgleish

Function tips, dashboard webinar, funnel chart, VLOOKUP and data analysisKirjoittanut Debra Dalgleish

Column chart alternatives, random numbers, goal seek, complex countingKirjoittanut Debra Dalgleish

Highlight dashboard items, change chart color, project management, counting functionsKirjoittanut Debra Dalgleish

Pivot Tables, Excel improvements, dynamic charts, highlight numbersKirjoittanut Debra Dalgleish

VLOOKUP, Pivot table makeover, shortcuts, Power QueryKirjoittanut Debra Dalgleish

Pivot table calculated field, sparklines, Power View, iPad formulasKirjoittanut Debra Dalgleish

Excel 3-D charts, billing sheets, day 42000, productivity tipsKirjoittanut Debra Dalgleish