All language subtitles for 1Week 3 Introduction Week 3 Manipulating & Summarizing Data U

so here we are in week three of Excel for the 99%

and as you know

you've already mastered a number of

very valuable tools in Excel

you understand spreadsheets and data in spreadsheets

and now you know how to convert those data

into visualizations to help communicate information

either answering a question for yourself

showing something to someone else

some kind of visual summary

that's fantastic

you're gonna be able to do a lot just with these skills

but there are times when we need

additional things from our data

sometimes a picture won't do

sometimes we need actual numbers

we need to know what the average value of something is

we need to know how many people match certain criteria

we need to know the minimum or maximum value

for this really long range of data

and we don't just wanna go scrolling through that

of course there are ways to do this

really quickly and effectively in Excel

and that's what we're working on this week

a lot of this

I consider manipulating data

manipulating data

meaning that we need to change it

or reshape it in some way to meet our needs sometimes

it might just be changing the order of our data

sorting it sometimes it may be filtering out data

looking for data

that match particular things we're looking for

and then doing calculations

using equations as we know

and using functions built in

functions in Excel

which is something we're going to be doing

for the first time this week

these tools I think

are some of the most valuable tools that Excel offers

UPS and that's what we're going to be focusing on

in this week

it's going to be a really nice compliment to

your plotting and charting skills

you're soon going to have skills for summarizing

and manipulating large amounts of data

very quickly

very effectively

and almost guaranteeing that you're not going to make

simple little errors

that's what spreadsheet programs are for

and that's what we're going to be doing this week