> but where is the visual data entry? That's where the "Power" suite enters the picture (Power Query, Power Pivot, etc.). Great way for non-technical people to

> but where is the visual data entry? That's where the "Power" suite enters the picture (Power Query, Power Pivot, etc.). Great way for non-technical people to get database data into Excel for reporting/analysis. I've trained plenty of people with only basic Excel skills to use it. The best part (for them) is that it's like a macro, so you can rerun it with new data any time. You can even use those to pull an existing SSRS report directly into Excel.