# Excel
CONTENT
Paper checks? Who uses those anymore? In this post from Steve Murphy from the Payments Journal, it's clear that digital payment systems (and digital wallets) are what's need to adapt to consumer purchasing habits.
There's an intriguing debate in the data analyst community on whether Excel or Power BI is the best tool for data analysis. Hear Pablo Moreno's perspective: he believes it's not about the tool, but rather, your data needs - data ingestion, data size, data aggregation, distribution of the information.
This is one of the most popular tips I have shared at past Summit events! Let me know what you think! You can use #MSDynGP + #Excel + #Macros to create awesome formatted reports!!
Who knew? Read on to find out, as i did that "... a good understanding of data science and machine learning requires some hands-on experience with algorithms. In this regard, a very valuable and often-overlooked tool is Microsoft Excel."
In this session, we will design 4 reports using different methods to retrieve and display data in Excel Refreshable reports. We will cover setting up the data sources and why to utilize the reports. Tools included in this presentation are SQL Views, custom Excel Data Connections, VBA code and Excel Query functionality. This session will be an intermediate to advanced session where knowledge of using SQL Server Management Studio, TSQL, VBA and Excel Data Connections is recommended. This session is geared for an audience with an intermediate skill set. This session will be available for CPE credits pending completion of session survey post event.