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  

3 Answers

Learn Microsoft Excel Training +2 Basic Excel Advanced Excel

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
Dislike Bookmark

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
Dislike Bookmark

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
Dislike Bookmark

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
Should beginners learn excel VBA training online?
Hi Jayant, learning online should always be your second option. I am sure, the place where you live, there might be some coaching classes, tutors available who can teach you personally. This way, you...
Jayant

Dear sir,how to convert number to text in excel by formula?
To get a range of time, you first need to convert the time in Text format and then merge them. You can use the following TEXT Formula: = TEXT( B4, “hh:mm” ) & ( ” – ”...
BINAYAK
0 0
8

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System.

 

Suppose our Customer requires following:

An Excel Software for POS, with following functionalities:

  1. It should have an "Open List" for capturing product related information.
  2. It should have automatic bill numbering
  3. It should have Printable bill
  4. It should have a customer database form and recording
  5. It should take not more than 30 minutes of training to learn and operate

Can you make that?

How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
9
How do I delete a worksheet in MS Excel?
By default, Microsoft Office Excel provides three worksheets in a workbook, but you can insert additional worksheets (and other types of sheets, such as a chart sheet, macro sheet, or dialog sheet) or...
Khushbu

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

Ask a Question

Related Lessons

MS Excel Tips
If you want to do a save as on MS Excel Workbook, use the shortcut key F12 and then select the location and click save
R

Rashmi Raj

0 0
0
Benefits Of E-Learning
From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...
E

Edusmart Skills

0 0
0
Pivot Tables
Pivot table and a very powerrfull feature in Ms-Excel . it is used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information...

Kavita V.

0 0
0
Introduction to VBA editor
G

Gagan G.

0 0
0
Excel Tip: Calculation of Overall Rating in Excel
Nowadays rating got high importance everywhere. Whether you want to purchase an AC or a toy first we will check for rating of that product. Even before joining any institute we will review the rating then...

Naga Satyanarayana Anantapalli

1 0
0

Recommended Articles

Why Should you Learn Microsoft Office

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 >

Learn Microsoft Excel

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 >

Make a Career in Mobile Application Programming

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 >

Why Should you Become an IT Consultant

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 >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Ghaziabad

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