Forums for the Business Analyst

  Modern Analyst Forums  Business and Sy...  Requirements  Use Excel to Simplify Analysis
Previous Previous
Next Next
New Post 4/18/2015 9:05 AM
User is offline smart_analyst
2 posts
No Ranking

Use Excel to Simplify Analysis 

Over past few years in my role I've realized that a lot of work we do can be done in a simpler manner by using Excel as a tool. For example analyzing a set of fields for different countries may require preparation of similar charts over and over again. But if we make use of Excel macros and other powerful features in Excel this can be simplified and a lot of time can be saved for other useful purposes. Please post the challenges that you face in reproducing same stuff multiple times or doing analysis that you think can be simplified using Excel. I've designed multiple such tools for myself and I'd hope it helps this community.

New Post 4/30/2015 4:17 AM
User is offline Matthew Banks
1 posts
No Ranking

Re: Use Excel to Simplify Analysis 
Yes Excel macros feature is very helpful and saves lot of time.
New Post 5/9/2015 12:46 AM
User is offline Matt Adams (Business Analyst)
6 posts
10th Level Poster

Re: Use Excel to Simplify Analysis 

We used Macro's to create emails from an excel spreadsheet, this wasn't built by me but a colleague. It simplified the process of creating and sending multiple emails to suppliers.

The challenge I face with macro's is that there only ever seems to be one person who knows how the specific task works.

The person who developed the macro functionality.

And the IT team (where i worked) don't support macro's because they are so open to change by anyone.

Therefore there seems to be a lot of key man dependency when macro's are used. Which can be bad for both smaller and larger companies a like.

However, there are many things that macros are good for and it seems to be the tasks which need to be completed every week in the same manner using different data.

Previous Previous
Next Next
  Modern Analyst Forums  Business and Sy...  Requirements  Use Excel to Simplify Analysis

Community Blog - Latest Posts

If you're looking to visualize, analyze, and share data insights with ease, Power BI might be the solution you need. In this article, we'll cover what Power BI is, why it's important, and how to get started with it. What is Power BI? Power BI is a business analytics service provided by Microsoft that helps users visualize and anal...
How to Write Business Analyst Resume
Business analysts must have an up-to-date, visually appealing resume to be able to stand out from the competition. A strong business analyst resume should accurately reflect your skills, experience and qualifications while also highlighting your accomplishments and successes. We will provide invaluable advice on how to build a strong, effective bus...
Are you testing your product in the most effective way?
Today covid-19 pandemic has completely flipped the business model. Various conventional Business models like banking and health had to adopt the digital era. Even the school and colleges have to create various applications so that they can provide online learning for their students. All these statements justify the modern business model as complete...



Copyright 2006-2023 by Modern Analyst Media LLC