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

Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul
Is Excel online coaching much costlier than excel coaching classes?
You'll find numerous sites offering free training/material online. You may also learn directly from Microsoft excel product help. Join classes only if you need step by step guidance and monitoring
Radha
Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting a job? What would be the general cost of learning Tally, Advanced Excel and Python? Which are the best tutors or institutes near to Kudlu Gate and Electronic City?
As a beginner, you should go with Advance Excel and MIS reporting. After that, you can go for VBA, SQL, and Python in the end. Follow this career path. You will end up being a data analyst and package raging from 8-12lakh pa.
Prabhu

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

Ask a Question

Related Lessons

EXCEL - Not just for the professionals but to make your daily life easy
Microsoft Excel This course will focus on real-life applications of MS Excel and help you start from scratch to help build your macros to make your life easier. Apart from technical bits, we will...

Microsoft Word
Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft Word is a component of the Microsoft Office suite of productivity software, but can also be purchased as a stand-alone...

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...

Basic excel required for MIS position
Dear Students, Today we will know about the mis and its importance in business world. In Business world, organisation's have many business problem related to process are exists. For taking any decision,...

Hidden Gems of MS Excel - Compare Year-on-Year Performance Using Pivot Table
Did You know You can Compare Year-on-Year& Performance Using Pivot Table?Yes. Just drag-&-drop and Compare Year-on-Year& Performance Quickly.& Year-on-Year simply means Periodic. As per...

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