Excel Roundup - Contextures

Excel 3-D charts, billing sheets, day 42000, productivity tips 

Contextures Excel Roundup 20150105

Pivot table calculated field, sparklines, Power View, iPad formulas

Contextures Excel Roundup 20150112

VLOOKUP, Pivot table makeover, shortcuts, Power Query

Contextures Excel Roundup 20150119

Pivot Tables, Excel improvements, dynamic charts, highlight numbers 

Contextures Excel Roundup 20150320

Highlight dashboard items, change chart color, project management, counting functions 

Contextures Excel Roundup 20150330

Column chart alternatives, random numbers, goal seek, complex counting 

Contextures Excel Roundup 20150406

Function tips, dashboard webinar, funnel chart, VLOOKUP and data analysis

Contextures Excel Roundup 20150413

Dashboard course, array formulas, faster VBA, rounding, big data

Contextures Excel Roundup 20150420

Check formulas, fix Excel tables, save time with shortcuts, Power BI

Contextures Excel Roundup 20150504

Pivot Table % Running Total, best file format, build Excel add-in

Contextures Excel Roundup 20150511

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 table
and many more Exce tips

Contextures Excel Roundup 20150608

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

Contextures Excel Roundup 20150707

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 20150721

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 20150803

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 20150817

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 20150831

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 20160306

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

Excel Roundup 20170518

Latest Microsoft Excel Tips, Tutorials and Announcements