#Excel Super Links #34 – shared by David Hager

SUMIFS Formula With Empty Criteria Cells

http://blog.contextures.com/archives/2017/04/13/sumifs-formula-with-empty-criteria-cells/

Tip – Create several AutoSum Measures in with one click #Excel Power Pivot – #powerbi

https://eriksvensen.wordpress.com/2017/04/14/tip-create-several-autosum-measures-in-with-one-click-excel-power-pivot-powerbi/

Interpolate values using the FORECAST function

https://exceloffthegrid.com/interpolate-values-using-the-forecast-function/

Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell

https://www.youtube.com/watch?v=KRqIEfwWLQs

Excel 2013: Power Query OmniQueries. Dynamic And Refreshable Connections To The Data Model

https://dhexcel1.wordpress.com/2014/02/05/excel-2013-power-query-omniqueries-dynamic-and-refreshable-connections-to-the-data-model/

 

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