#Excel Super Links #91 – shared by David Hager

 

Copy a Data Table from PDF into Excel

https://exceloffthegrid.com/copy-a-data-table-from-pdf-into-excel/

Filtering PivotTables with VBA? Deselect Slicers First!

http://dailydoseofexcel.com/archives/2015/11/17/filtering-pivottables-with-vba-deselect-slicers-first/

Use Multiple Connections Between Power BI Tables

https://powerbi.tips/2017/07/use-multiple-connections-between-tables/

Database Functions in Excel

https://roymacleanvba.wordpress.com/2010/09/21/database-functions-in-excel/

Conditional Formatting Gem in #Excel: Highlight the N Closest Values to the Mean of a Range in a Filtered List by David Hager

https://dhexcel1.wordpress.com/2017/07/05/conditional-formatting-gem-in-excel-highlight-the-n-closest-values-to-the-mean-of-a-range-in-a-filtered-list-by-david-hager/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s