Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’...
by gthtjtkt on Friday October 05, 2018 @08:56PM
(#18152865)
> 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.
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.