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 10: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 5: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 1: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

Jason White
Jason White
With time, we have evolved from oiled lamps to ever-present electricity, printing every page manually to now producing thousands of copies a day and so on. But what is the one thing these distinct things have in common? Yes, technology.One such branch of technology that has crossed leaps and bounds and turned into a  working technology fr...
1 Responses
Digital Business Analysis
Digital Business Analysis
Nowadays, companies like Audi and HSBC, use IT systems in everything they do. Does that make them to be IT companies rather than banks? Most would probably agree that HSBC is a bank, just as Audi is a car manufacturer. But what about digital banks such as Chime or companies offering digital products? In digital companies, most of the employees work...
1 Responses
Digvijaybook
Digvijaybook
IT companies are rapidly looking or adapting modern methodologies, so the business analyst role is increasing day by day. Offline is shifting to online, and this is why today, companies can easily garner important data in any aspect. But, data itself has no meaning hence, organizations look for a business analyst who can analyze the data and draw a...
3 Responses






Latest Articles

An Introduction on Artificial Intelligence and Machine Learning
Feb 23, 2020
0 Comments
After some research, I was taken back with so many machine learning applications already in use: weather forecasting, medical diagnoses, law enforceme...
Copyright 2006-2020 by Modern Analyst Media LLC