6 hours 3 minutes
Okay, so you have seen Ah, the amends Off Excel views are interfacing how to enter data in excel.
And in this lesson, we're going to talk about how what is X l used for?
So as a spreadsheet program, Excel is
primarily used for treating sze
financial calculations. And when I say financial calculations, I mean, for example, in accounting and bookkeeping, you you enter some data and then from that data, you calculate something else.
Then in business world, you have both Kunkle calculations and analysis. So first is, for example, you are entering the sales data for a month or a year, whatever, period. And then from that,
the data you want to calculate, for example, your gross margin or your net margin.
But then you also want to analyze the daytime. This is what excel is also very good at, which means it helps you based on that, that, uh, create graphs. Ah, even predict trends.
So the difference between calculation and analysis is that when you do calculations, you're using the
data you have in excel entered from
from any other source or whoever entered it in, they in excel
and then you make some other numbers out of it, or are there text or whatever, But when you're doing the analysis, you're not changing anything. You're just finding different ways to look into data you already have in Excel file.
And this is the 13 what Excel is mostly used for. And this is that you collect large quantities of data and then you do the analysis.
This can be sales data. This could be financial data, but this can also be all sorts of data. For example, in social sciences
you collect data from, uh, surveys. Ah, you has the public opinion. Aah! All these things can be entered in excel
and then a very effectively analyzed with using existing functions and formulas in excel or by creating additional pieces of software,
uh, or the Mac rose to do did an analysis.
In the end. Ah, Excel is extremely powerful. Tow the most powerful tool out of fall on the market, and I strongly recommend that whenever your situation that you have to analyze data, you always use excel