Here is all of June's new Excel content. Excel Community and Tech Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".
Excel Tip of the Week
292 - Wildcards (public)
Special characters like ? and # can be used to super-charge your Excel text formulas and find-replace operations.
293 - Revisiting layering conditional formats
Conditional formatting is already useful, but getting an understanding of how multiple formats overlap and interact can make it even more so.
294 - Converting data stored as text
Any number of things can leave your Excel thinking that numbers are actually text - but luckily, there're a range of options for converting them.
295 - Binomial distribution functions
The Tip of the Week dives a bit deeper into the world of statistics to examine how to work with the binomial distribution.
Part 49 - Pivotal PivotTables
Liam Bastick explores the basics of the PivotTables feature for modelling users.
Part 50 - Slicer of Good Fortune
Liam explores how to use Slicers to easily filter data - as well as creating a custom sort order for your PivotTables.
Poll - Accountants can't do their jobs properly without an understanding of Power Query (public)
The title says it all - come and weigh in on the discussion!
Accountants' guide to Excel - Excel Tables: Tables and Excel automation, part 3
Simon Hurst lays out some useful features of Excel Tables, as well as workarounds for some of their limitations.