Make Your Excel Reports 10X FASTER With This Pivot Table Method!
6K views
Jan 7, 2025
Learn how to create multiple file reports quickly and efficiently using Pivot Tables in Excel! This tutorial covers step-by-step instructions to help you organize, analyze, and export data into separate reports. Perfect for beginners and advanced users looking to streamline reporting tasks. Watch now and take your Excel skills to the next level! #ExcelTips #PivotTable
View Video Transcript
0:01
hi lovely people and welcome back to our
0:03
YouTube channel on this channel on
0:05
today's Channel we're going to show you
0:08
how to generate multiple reports using
0:10
pivot tables and if you don't know how
0:13
to create a pivot table we've created a
0:16
separate video in a go back and watch it
0:20
and you'll know how to create pivot
0:22
tables once you're done you can come and
0:24
continue with this if you know already
0:27
how to create pivot tables this is how
0:31
you this is how you can generate
0:33
multiple
0:34
results on this uh particular video we
0:38
have column A with our countries column
0:41
B product column C with the sales that
0:44
were made from this particular countries
0:47
so the very first step you need to do of
0:49
course you need to create a pivot
0:52
table
0:54
select select your
0:57
data uh go on insert pivot
1:01
table uh click on from table range
1:05
always choose a new worksheet click on
1:08
okay uh you will see that you have this
1:12
country product sales made uh particular
1:17
at this time you'll just uh click on
1:20
product click on sales this is what we
1:24
have but since we are going to have we
1:27
want to make our data in in different we
1:31
want to have different sales for
1:33
different countries so we have to put
1:36
our country as a filter and it will
1:40
create a filter uh a filter that has all
1:45
the different count so if you need let's
1:47
say for example you need the sales for
1:50
Kuwait click on Kuwait and click on okay
1:53
so you will have the data for only quit
1:57
let's rename this to to pivot
2:02
table pivot
2:06
table in using the long uh way we could
2:10
have just uh copied
2:12
this copy create a new sheet rename it
2:18
to
2:20
Kuwait and then paste this data we'll do
2:25
this for every for every country that we
2:30
have on our sheet and this is very time
2:32
consuming so rather than doing this the
2:35
easiest way you can generate multiple
2:37
results it's even less than 3 minutes
2:40
let's undo
2:42
this uh let's undo
2:46
Kuwait so the first thing is you create
2:50
your pivot
2:51
table let's we need to have all our
2:56
all so this is our pivot table what you
2:59
need to do is select on the cell that
3:03
has all once you've selected this you'll
3:06
have you go here on top select on pivot
3:09
table analyze once you've clicked on
3:12
that on your left move to pivot table
3:16
under pivot table click on options you
3:19
have three options but we need only show
3:22
report filter Pages click on it ensure
3:26
that your country has been uh clicked on
3:29
already and then click on okay and here
3:33
goes
3:34
your here goes your data it's as easy as
3:39
this so you don't have to manually uh
3:43
create each sheet and put the data there
3:45
manually you just use this and you're
3:49
good to go so if you have any questions
3:52
pleas feel free to put them in the
3:54
comment section and if you need
3:56
something else in Excel that you need us
3:59
to create a video on please do that
4:02
otherwise thank you very much for always
4:04
liking our content and subscribe if you
4:08
really love this content thank you very
4:10
much see you in the next video