#Excel Super Links #5 – shared by David Hager

I hope that you are enjoying these issues of ESL. Tell your Excel-savvy colleagues to check these out as well. Enjoy ESL #5!

Use Power Query to Get a List of Hidden and System Directories

http://datapigtechnologies.com/blog/index.php/use-power-query-to-get-a-list-of-hidden-and-system-directories/#more-6278

INDEX: Returning an array of values

https://excelxor.com/2014/09/05/index-returning-an-array-of-values/#more-98

Disproportionately Popular & Unpopular Outliers by Region, Demographic, etc (DAX)

https://powerpivotpro.com/2017/02/disproportionately-popular-unpopular-outliers-by-region-demographic-etc/

Excel Formula Names Translated into Other Languages

https://en.excel-translator.de/functions/

Excel Charts: Connect Two XY Series with Arrows

http://peltiertech.com/connect-two-xy-series-with-arrows/

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