Filtering Tables in Excel 2013 with Slicers

Post author:Neale Blackwood
Post published:28/11/2013
Post category:Data Excel 2013 Excel Blog
Post comments:3 Comments

Sometimes when you apply a filter to a table it isn’t obvious what filter has been applied. This is the case when you are filtering by multiple entries in a field. Slicers were introduced in Excel 2010 to filter Pivot Tables. Filtering a Pivot Table has the same issue when filtering by multiple criteria in a single field. Click here to see a post on these Slicers. Slicers’ abilities were expanded in Excel 2013 to include filtering formatted tables. (A…

Excel – Unbreakable Sheet Hyperlink [VIDEO]

Post author:Neale Blackwood
Post published:21/11/2013
Post category:Excel Blog Functions Tips & Tricks Videos
Post comments:3 Comments

Changing a sheet name and deleting the hyperlink cell are two processes that can break Excel sheet hyperlinks. The video is at the bottom of the page.

(more…)

Excel Hyperlink on a Logo

Post author:Neale Blackwood
Post published:13/11/2013
Post category:Excel Blog Tips & Tricks
Post comments:0 Comments

In some files there is a central sheet that you keep returning to. It might hold the inputs or the controls for the file. You can simplify getting to that sheet by using a logo as a hyperlink. Using a logo means you can place it anywhere on another sheet. It’s also easy to copy and paste the logo on other sheets once created. You can add a hyperlink to any image, so it doesn’t have to be a logo.…