How do i take large amounts of data (in excel) and turn into useable reports or analysis?

Monica Rigaud 1 Reputation point
2021-04-20T14:42:40.877+00:00

I manage large amounts of data (in excel) that I have to turn into useable reports or analysis. I am currently using pivots tables and then hard entering the data into a analysis or summary view. What is the best MS Excel course that I can take to teach me how to do this smarter?

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erin Ding-MSFT 4,476 Reputation points
    2021-04-21T05:51:51.4+00:00

    Hi @Monica Rigaud

    Based on your description, I suggest you to use Power BI.
    More information about using Power BI service, you may refer to this article "Tutorial: Get started creating in the Power BI service".

    Hope the information is helpful.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.