Category Archives: VBA

#Excel Super Links #108 – shared by David Hager

 

Calculating Travel Distance/Time in Power BI using Bing Map API

http://snip.ly/ir4lk?utm_content=buffer784c2&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer#http://datanrg.blogspot.com/2017/07/calculting-travel-distancetime-in-power.html

Creating custom Map Charts using shapes and VBA

https://exceloffthegrid.com/creating-custom-map-charts-in-excel/

WEBSERVICE and FILTERXML functions explained

http://analystcave.com/excel-webservice-filterxml-functions/

Storing and Running M Code from #Excel Worksheet Cells by David Hager

https://dhexcel1.wordpress.com/2017/07/20/storing-and-running-m-code-from-excel-worksheet-cells-by-david-hager/

Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel by David Hager

https://dhexcel1.wordpress.com/2017/07/10/getting-the-latest-earthquake-alert-using-the-webservice-and-filterxml-functions-in-excel-by-david-hager/

 

#Excel Super Links #107 – shared by David Hager

 

IP Address Mapping in Power BI

https://blogs.msdn.microsoft.com/samlester/2017/07/23/ipaddressmappinginpowerbi/

Table.TransformColumns – alternative in PowerBI and PowerQuery in Excel

http://www.thebiccountant.com/2017/07/23/transforming-a-column-with-values-from-another-column-in-powerbi-and-powerquery-in-excel/

Painting with Excel

https://www.sumproduct.com/blog/article/painting-with-excel

Storing and Running M Code from #Excel Worksheet Cells by David Hager

https://dhexcel1.wordpress.com/2017/07/20/storing-and-running-m-code-from-excel-worksheet-cells-by-david-hager/

#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager (Try it, you’ll like it!)

https://dhexcel1.wordpress.com/2017/07/17/excel-short-and-sweet-tip-27-use-worksheet-udf-to-add-background-to-excel-worksheet-by-david-hager/

 

#Excel Super Links #106 – shared by David Hager

 

Excel SUM Function in Detail

https://www.get-digital-help.com/2017/07/22/excel-sum-function/

Analyze Public Facebook Groups in #PowerBI

https://datachant.com/2017/07/22/analyze-public-facebook-groups-powerbi/

Translate RGB codes to HEX #rrggbb

http://www.vbaexpress.com/kb/getarticle.php?kb_id=840

Excel Custom Number Format Guide

http://www.myonlinetraininghub.com/excel-custom-number-format-guide

Storing and Running M Code from #Excel Worksheet Cells by David Hager

https://dhexcel1.wordpress.com/2017/07/20/storing-and-running-m-code-from-excel-worksheet-cells-by-david-hager/

 

#Excel Super Links #105 – shared by David Hager

 

Drop Buttons on VBA UserForm Controls

https://peltiertech.com/drop-buttons-vba-userform-controls/

Power Query Unpivot Scenarios

http://www.myonlinetraininghub.com/power-query-unpivot-scenarios

Reduce Development Lag in Power Query

https://www.excelguru.ca/blog/2017/07/20/reduce-development-lag/

Automatic Default Number Formatting in Excel Pivot Tables

https://www.excelcampus.com/pivot-tables/automatic-default-number-formatting/

#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

https://dhexcel1.wordpress.com/2017/07/17/excel-short-and-sweet-tip-27-use-worksheet-udf-to-add-background-to-excel-worksheet-by-david-hager/

#Excel Super Links #104 – shared by David Hager

 

Get the File Name of the Current Excel Workbook

https://exceloffthegrid.com/get-the-file-name-of-the-current-workbook/

Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards

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

Excel Pop Up Selector Tool With Slicer

http://blog.contextures.com/archives/2017/07/20/excel-pop-up-selector-tool/

Use Webservice functions to Automatically Update Excel 2013 Spreadsheets with Online Data

https://blogs.office.com/en-us/2013/03/21/use-webservice-functions-to-automatically-update-excel-2013-spreadsheets-with-online-data/

#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

https://dhexcel1.wordpress.com/2017/07/17/excel-short-and-sweet-tip-27-use-worksheet-udf-to-add-background-to-excel-worksheet-by-david-hager/

#Excel Super Links #102 – shared by David Hager

 

Using Power BI to Extract Data from Office 365 Reporting Web Services

https://eriksvensen.wordpress.com/2014/11/10/using-power-bi-to-extract-data-from-office-365-reporting-web-services-powerbi-office365/

Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)

https://powerpivotpro.com/2017/07/visualize-data-with-maps-dax-reanimator-series-part-2/

Built In and Custom Lists in Excel

https://peltiertech.com/built-in-custom-lists-excel/

How To Customize The Order Of Your Excel Slicer Buttons

https://www.thespreadsheetguru.com/blog/how-to-customize-order-of-excel-slicer-buttons

Bible Verse In Any Language Using #Excel by David Hager

https://dhexcel1.wordpress.com/2017/07/13/lookup-a-bible-verse-in-any-language-using-excel-by-david-hager/

 

 

#Excel Super Links #101 – shared by David Hager

 

Why does the calculation mode keep changing?

https://exceloffthegrid.com/why-does-the-calculation-mode-keep-changing/

Variations of Alternative Bullet Graphs in Excel

http://www.clearlyandsimply.com/clearly_and_simply/2017/07/variations-of-alternative-bullet-graphs-in-excel.html

Row Context and Filter Context in DAX

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

Browser automation in Excel VBA using Selenium

https://codingislove.com/browser-automation-in-excel-selenium/

#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

https://dhexcel1.wordpress.com/2017/07/17/excel-short-and-sweet-tip-27-use-worksheet-udf-to-add-background-to-excel-worksheet-by-david-hager/