Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
Okay, so you have seen Ah, the amends Off Excel views are interfacing how to enter data in excel.
00:08
And in this lesson, we're going to talk about how what is X l used for?
00:14
So as a spreadsheet program, Excel is
00:17
primarily used for treating sze
00:20
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.
00:34
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,
00:50
the data you want to calculate, for example, your gross margin or your net margin.
00:56
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.
01:10
So the difference between calculation and analysis is that when you do calculations, you're using the
01:18
data you have in excel entered from
01:21
forward for
01:23
from any other source or whoever entered it in, they in excel
01:27
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.
01:46
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.
01:57
This can be sales data. This could be financial data, but this can also be all sorts of data. For example, in social sciences
02:06
you collect data from, uh, surveys. Ah, you has the public opinion. Aah! All these things can be entered in excel
02:19
and then a very effectively analyzed with using existing functions and formulas in excel or by creating additional pieces of software,
02:30
uh, or the Mac rose to do did an analysis.
02:36
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

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor