I want to learn how to use Excel for data mining and data analysis because I'm working for an e-commerce company. Where can I find resources to learn?

Asked by Last Modified  

Follow 4
Answer

Please enter your answer

Web Expert

Kartika, I can help you learning it online. As Data Analysis you need to put a details approach for Macros, 3 Data Map forecasting, slicers and pivot table.
Comments

Tutor

Hi Kartika It is always recommended that you take help from a subject matter expert who is good in MS-Excel, you have lot of mentors who can provide you training in Urbanpro. They can teach you either on-line, or by directly reaching you at your conveneant time and place as you wish. Thanks and...
read more
Hi Kartika It is always recommended that you take help from a subject matter expert who is good in MS-Excel, you have lot of mentors who can provide you training in Urbanpro. They can teach you either on-line, or by directly reaching you at your conveneant time and place as you wish. Thanks and Regards Ejaz read less
Comments

Trainer

Dear Kartika ji, I am also from retail sector, hope my answer will help to clear your doubts. you need to use various type of charts available in excel. take your source data in tabular format then create MIS with various charts/trends which will help you to analyse and work on data for effective decision...
read more
Dear Kartika ji, I am also from retail sector, hope my answer will help to clear your doubts. you need to use various type of charts available in excel. take your source data in tabular format then create MIS with various charts/trends which will help you to analyse and work on datafor effectivedecision making. you have to first learn how to create tables, pivot charts, using of advanced excel funtions like VLOOKUP, INDEX, MATCH, DMAX, DMIN, DAVERAGE, SUMIFS, COUNTIFS, SUBTOTAL etc. also try to use conditional formating for effective data management. you may call me on 95039-39606 to clear your doubts, if any. Regards, Sachin Talekar Pune read less
Comments

View 1 more Answers

Related Questions

How to become an expert or tutor in UrbanPro ?
You need to register as tutor, and you can choose which skill you expert I mean which you want to teach and give all the information.
Profile Photo
Jenil
Can you help with this Excel formula?
What exactly you want??? I can help you .
Profile Photo
Sajjan
0 0
View Comments5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons


Use of Indirect Function
I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...
Profile Photo

The Average Function(excel)
The Average Function:Follow-along file: Continue with Excel Objective 2.00. (Use file Excel Objective 2.06 if starting here.)The next function we will add to the Budget Detail worksheet is the Average...
U

Uma Sahu

0 1
View Comments0

Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...
Profile Photo

Learning Pivot Table Part-1
You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...
Profile Photo

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you