Data analysis in simple words means examining raw data to find patterns, trends, and answers that help you make better decisions. For example, analysing monthly sales in Excel to find out which product sells the most is data analysis. It involves collecting, cleaning, organising, and interpreting data using tools like Excel, Google Sheets, SQL, or Power BI.

Start by cleaning your data — removing duplicates, fixing blank cells, and correcting formats. Then use Excel formulas like SUMIF, COUNTIF, VLOOKUP, and IF for calculations, summarise large datasets with Pivot Tables, and present findings using charts and conditional formatting. Practising on a real dataset, such as sales or attendance data, is the fastest way to learn data analysis in Excel.

The process is similar to Excel: import your data, clean it, and use functions like SUMIF, COUNTIF, VLOOKUP, and QUERY to analyse it. Google Sheets also offers Pivot Tables, charts, and add-ons for deeper analysis. Its biggest advantages are free access and real-time collaboration, which make it a good starting point for students and freshers.

In research, data analysis begins after data collection — you first clean and code the data, then apply descriptive statistics like mean, percentage, and frequency to summarise it, followed by inferential methods such as correlation, t-tests, chi-square, or regression depending on your research question. Tools like Excel, SPSS, R, and Python are commonly used for research data analysis.

An Excel formula is any calculation you write manually starting with an equals sign, such as =A1+B1, while a function is a ready-made formula built into Excel, such as SUM, AVERAGE, VLOOKUP, or IF, that performs a specific task. In short, functions are used inside formulas. Learning commonly used Excel formulas and functions is the first step towards data analysis and MIS or reporting roles.

To subtract in Excel, use the minus sign: =A2-B2 gives the difference between two cells. You can also subtract multiple values in one formula, like =A2-B2-C2, or subtract a range using =A2-SUM(B2:B10). There is no dedicated SUBTRACT function in Excel — the minus operator is the standard method.

Use the asterisk sign for multiplication in Excel: =A2*B2 multiplies two cells. For multiplying several numbers, use the PRODUCT function, like =PRODUCT(A2:A5). To calculate things like GST quickly, you can multiply a value by a percentage, for example =A2*18%.

Learning websites, YouTube channels, and Microsoft's own support page offer an Excel formulas list with examples covering SUM, IF, VLOOKUP, XLOOKUP, INDEX-MATCH, and text functions. Downloading an Excel formulas PDF as a quick-reference sheet and practising each formula on a sample dataset is the most effective way to remember them.

Beginners should start with Excel or Google Sheets, since most entry-level data analysis work happens there, then move to SQL for handling databases, and Power BI or Tableau for building dashboards. Python or R can be learnt later for advanced analytics. This order — spreadsheets, SQL, then a visualisation tool — is the most common learning path for data analysis tools in India.

A data analysis course is a structured program that teaches you how to collect, clean, analyse, and present data. Most courses cover Excel, SQL, statistics, and a visualisation tool like Power BI or Tableau, along with hands-on projects. They are offered as self-paced online programs, live instructor-led batches, and offline classroom courses.

Data analysis course fees in India vary widely — free content is available on YouTube, self-paced recorded courses usually cost less than live batches, and instructor-led programs or bootcamps with mentorship, projects, and placement support cost more. Instead of the fee alone, check whether a course includes practical projects, doubt-solving, and career support before enrolling.

Start by mastering Excel, then learn SQL, basic statistics, and one visualisation tool like Power BI or Tableau. Build two or three portfolio projects on real datasets, highlight them in your resume and LinkedIn profile, and apply for entry-level roles such as data analyst intern, MIS executive, or reporting analyst. Following a structured, day-wise roadmap instead of random tutorials helps beginners become job-ready much faster.

The typical data analyst career path and salary in India work like this: you start as a data analyst or business analyst, progress to senior data analyst, then analytics manager, and can eventually move into head of analytics or data science roles. Entry-level packages are modest, but pay grows sharply with skills and experience, so it is best to check current job portals for updated salary figures.

Yes — a data analyst career in India has strong demand across IT, banking, e-commerce, healthcare, and consulting, as companies increasingly hire for data-driven decision-making roles. Since every business now generates data, skilled analysts stay relevant, and the role also opens doors to data science, analytics management, and product analytics in the long run.

Freshers can get data analyst jobs in India by building skills in Excel, SQL, and Power BI, completing two or three practical projects, and showcasing them on their resume and LinkedIn. Applying for internships, MIS executive, and reporting analyst roles is a common entry route. Most data analyst careers for freshers take off once candidates can demonstrate hands-on project work in interviews rather than just certificates.