Software Development Exam > Software Development Videos > Microsoft Excel 2013: Be the Excel Master > Microsoft Excel 2013 Tutorial - 9 - Working with Tables
Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development
FAQs on Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture - Microsoft Excel 2013: Be the Excel Master - Software Development
| 1. What is a table in Microsoft Excel 2013? |  |
Ans. In Microsoft Excel 2013, a table is a range of cells that are formatted to enable easy sorting, filtering, and analysis of data. It allows users to organize and manage their data effectively by providing multiple features such as auto-filtering, total rows, and structured references.
| 2. How do I create a table in Excel 2013? | |
Ans. To create a table in Excel 2013, follow these steps:
1. Select the range of cells that you want to convert into a table.
2. In the "Insert" tab, click on the "Table" button.
3. Verify that the correct range is selected in the "Create Table" dialog box.
4. Check the box for "My table has headers" if your data has headers.
5. Click on the "OK" button to create the table.
| 3. How can I sort data in a table in Excel 2013? | |
Ans. To sort data in a table in Excel 2013, follow these steps:
1. Click on any cell within the table.
2. In the "Data" tab, click on the "Sort" button.
3. Choose the column you want to sort by from the "Sort by" drop-down list.
4. Select the sort order (ascending or descending) from the "Order" drop-down list.
5. Click on the "OK" button to apply the sorting.
| 4. Can I filter data in a table in Excel 2013? | |
Ans. Yes, you can filter data in a table in Excel 2013. To filter data, follow these steps:
1. Click on any cell within the table.
2. In the "Data" tab, click on the "Filter" button.
3. Click on the filter arrow in the column header you want to filter.
4. Choose the desired filter criteria from the drop-down list.
5. Repeat the process for other columns if needed.
6. Click on the "OK" button to apply the filters.
| 5. How can I use structured references in Excel 2013 tables? | |
Ans. Structured references in Excel 2013 tables allow users to refer to table elements using descriptive names instead of cell references. To use structured references, follow these steps:
1. Type a formula or function in a cell outside the table.
2. Instead of manually selecting the range, start typing the table name followed by the desired column name, using the syntax "[Table Name][Column Name]".
3. Excel will provide suggestions as you type, making it easier to select the desired column.
4. Press Enter to complete the formula or function with the structured reference.
Text Transcript from Video
alright guys welcome back and in this
video what I want to do is I want to
cover the rest of the basics about
tables so in the very first tutorial
maybe it was a second one I keep
forgetting but I showed you guys how you
can change the table style in other
words the basic coloring for the table
and that is if you go up here you can
hover over each one that you like and
you can also drop down if you want some
more options but basically whenever you
click one let me find a good one mmm
this is harder than I thought okay this
one right here so whenever you click one
it actually sets your table to that
style now you also have another option
and that is a theme and a theme is kind
of different than a style because a
style is pretty much just the color of
it a theme is other things like font
size and stuff like that so if you go to
the page Layout tab you're going to see
this drop-down right here that says
themes now keep an eye on the table in
the background whenever I hover over
these you can see that the actual font
is changing the font size so that's the
difference between the two I actually
kind of like this one Aion all right
kind of a nice classy look in my help I
want to have to remember that one so
that is how you can change the overall
look and feel of your table now if you
hop back over to the table tools and
designs I'll show you guys some other
really nifty options and the first one
is this header row checkbox so I'm going
to be showing you guys a couple things
in here the header row of course is the
very first row some people like it some
people don't something that is pretty
much appears on your table by default
that I really don't like is this banded
rows so by default it is checked and
again that just means color every other
row to look like bands and I think
unchecking it gives it a little more
professional and cleaner look so I
typically I'm going to have mine
unchecked maybe I have a checked if
they're easier
see how the Toros know I like it this
way
actually you know what for you guys
easier to see whatever and this last one
this filter button of course is the
button that appears on the header now it
not only is just a filter button that's
just what they call it but of course as
we already saw it's the button that
allows you to sort your data as well so
that was incredibly handy so I'm going
to go ahead and leave that one on and of
course you have another slew of options
right here but you guys can figure out
what they are those are the most common
ones and well if you guys ever want to
change it that's where they are now
another thing that I probably should
have point out it point out it pointed
out that's what I meant to say all right
is this so these are your default table
styles but what if you're looking
through these and you're like okay I
want to have a table style that matches
the exact color of my website and I'm
not really finding it right here well
what you could do is you can hover down
to this option new table style and this
allows you to pretty much format a table
style exactly how you want it so you can
say okay so the first column stripe I'm
going to format this to whatever font
border fill just like any other you know
editor that you use before and what you
also want to do is you want to make sure
to give it a descriptive name kind of
like um
Bucky's room website theme or um black
and gold or something like that because
I don't know it's just easier to see
whenever you're looking at all your
styles so if we ever want to create a
custom one there you go so now that we
have time to kind of move on to actually
working with the table well this is kind
of how I wanted to break up the story I
wanted to show you guys how to style the
table make everything look pretty and
then um kind of show you guys the
options of everything so now I want to
show you guys had actually move it
around within your spreadsheet so the
first thing that a lot of people have
problems with is how to select your
entire table now of course you can do
this let's scroll down
on the phone you know what as a pain in
the butt already because if it's huge of
course I already already I'm having
problem finding the end of that so then
they go up here now this button right
here this little arrow it selects your
entire spreadsheet not very handy if you
want to just move this table around your
spreadsheet so if you ever want to
select just the table this is what you
can do you can go up and look at my
mouse cursor right here you see how it's
the fat plus sign if you move in the top
left corner you're going to see that it
moves to a right down arrow in other
words in east south or south south east
arrow so click that and what this is
going to do is it's going to select your
table right like that now whenever you
have it selected you can do a couple
things with it you can either just cut
it and move it to anywhere else that you
want or what you can do is you can move
it to a new spreadsheet and I'll show
you guys a really cool way that you can
do that so this little arrow button
whenever you click that it's really only
good if you want to format the data in
your table but as you guys can see we
have a little problem whenever we try to
paste it
um we're leaving all of this stuff
behind which what you know that's kind
of important too so how do we select
that well I'll show you guys a real cool
way click any cell within your table and
hit ctrl a and that's going to select
exactly what was selected before and now
hit ctrl a again now as you can see not
only did it select the data within the
table but also the headers itself so
again that was ctrl a select it twice or
excuse me
hit ctrl a twice and it's going to
select your entire table so now you can
do something like I don't know just cut
it and let's say you want to do
something like move it to a new
spreadsheet boom look at that
now the one other thing that I want to
point out is this
let me just undo that and deselect it
what if actually let me scroll out it
will probably be a little bit easier all
right too much all right there you go so
I want to show you guys a real quick way
to move around your table or not move
around your table just move your table
without having to copy it or cut it what
you can do is you can actually take your
mouse and you can move it until it gets
to the border any border actually it
doesn't matter if it's the left one or
the top one and look what happens
I go from the fat plus sign I almost
want to call it the Red Cross it's like
it kind of looks like the Red Cross logo
but it's all white so I'll call this the
white cross from now on that's my that's
my own version of the symbol they're
actually probably is a name for if
anyone knows leave a comment below but
check this out it goes from the white
cross to the four directional arrows now
what this means is move around so
whenever I get those four directional
arrows I can just go ahead click and
drag and check it out so again white
cross move it to a border to get those
four directional arrows and move it
around pretty stinkin sweet so those are
a bunch of different ways that you can
select the data within your table select
the entire table or move the table by
dragging and dropping really easily so
thank you guys for watching arm well
I'll see you guys next time
video what I want to do is I want to
cover the rest of the basics about
tables so in the very first tutorial
maybe it was a second one I keep
forgetting but I showed you guys how you
can change the table style in other
words the basic coloring for the table
and that is if you go up here you can
hover over each one that you like and
you can also drop down if you want some
more options but basically whenever you
click one let me find a good one mmm
this is harder than I thought okay this
one right here so whenever you click one
it actually sets your table to that
style now you also have another option
and that is a theme and a theme is kind
of different than a style because a
style is pretty much just the color of
it a theme is other things like font
size and stuff like that so if you go to
the page Layout tab you're going to see
this drop-down right here that says
themes now keep an eye on the table in
the background whenever I hover over
these you can see that the actual font
is changing the font size so that's the
difference between the two I actually
kind of like this one Aion all right
kind of a nice classy look in my help I
want to have to remember that one so
that is how you can change the overall
look and feel of your table now if you
hop back over to the table tools and
designs I'll show you guys some other
really nifty options and the first one
is this header row checkbox so I'm going
to be showing you guys a couple things
in here the header row of course is the
very first row some people like it some
people don't something that is pretty
much appears on your table by default
that I really don't like is this banded
rows so by default it is checked and
again that just means color every other
row to look like bands and I think
unchecking it gives it a little more
professional and cleaner look so I
typically I'm going to have mine
unchecked maybe I have a checked if
they're easier
see how the Toros know I like it this
way
actually you know what for you guys
easier to see whatever and this last one
this filter button of course is the
button that appears on the header now it
not only is just a filter button that's
just what they call it but of course as
we already saw it's the button that
allows you to sort your data as well so
that was incredibly handy so I'm going
to go ahead and leave that one on and of
course you have another slew of options
right here but you guys can figure out
what they are those are the most common
ones and well if you guys ever want to
change it that's where they are now
another thing that I probably should
have point out it point out it pointed
out that's what I meant to say all right
is this so these are your default table
styles but what if you're looking
through these and you're like okay I
want to have a table style that matches
the exact color of my website and I'm
not really finding it right here well
what you could do is you can hover down
to this option new table style and this
allows you to pretty much format a table
style exactly how you want it so you can
say okay so the first column stripe I'm
going to format this to whatever font
border fill just like any other you know
editor that you use before and what you
also want to do is you want to make sure
to give it a descriptive name kind of
like um
Bucky's room website theme or um black
and gold or something like that because
I don't know it's just easier to see
whenever you're looking at all your
styles so if we ever want to create a
custom one there you go so now that we
have time to kind of move on to actually
working with the table well this is kind
of how I wanted to break up the story I
wanted to show you guys how to style the
table make everything look pretty and
then um kind of show you guys the
options of everything so now I want to
show you guys had actually move it
around within your spreadsheet so the
first thing that a lot of people have
problems with is how to select your
entire table now of course you can do
this let's scroll down
on the phone you know what as a pain in
the butt already because if it's huge of
course I already already I'm having
problem finding the end of that so then
they go up here now this button right
here this little arrow it selects your
entire spreadsheet not very handy if you
want to just move this table around your
spreadsheet so if you ever want to
select just the table this is what you
can do you can go up and look at my
mouse cursor right here you see how it's
the fat plus sign if you move in the top
left corner you're going to see that it
moves to a right down arrow in other
words in east south or south south east
arrow so click that and what this is
going to do is it's going to select your
table right like that now whenever you
have it selected you can do a couple
things with it you can either just cut
it and move it to anywhere else that you
want or what you can do is you can move
it to a new spreadsheet and I'll show
you guys a really cool way that you can
do that so this little arrow button
whenever you click that it's really only
good if you want to format the data in
your table but as you guys can see we
have a little problem whenever we try to
paste it
um we're leaving all of this stuff
behind which what you know that's kind
of important too so how do we select
that well I'll show you guys a real cool
way click any cell within your table and
hit ctrl a and that's going to select
exactly what was selected before and now
hit ctrl a again now as you can see not
only did it select the data within the
table but also the headers itself so
again that was ctrl a select it twice or
excuse me
hit ctrl a twice and it's going to
select your entire table so now you can
do something like I don't know just cut
it and let's say you want to do
something like move it to a new
spreadsheet boom look at that
now the one other thing that I want to
point out is this
let me just undo that and deselect it
what if actually let me scroll out it
will probably be a little bit easier all
right too much all right there you go so
I want to show you guys a real quick way
to move around your table or not move
around your table just move your table
without having to copy it or cut it what
you can do is you can actually take your
mouse and you can move it until it gets
to the border any border actually it
doesn't matter if it's the left one or
the top one and look what happens
I go from the fat plus sign I almost
want to call it the Red Cross it's like
it kind of looks like the Red Cross logo
but it's all white so I'll call this the
white cross from now on that's my that's
my own version of the symbol they're
actually probably is a name for if
anyone knows leave a comment below but
check this out it goes from the white
cross to the four directional arrows now
what this means is move around so
whenever I get those four directional
arrows I can just go ahead click and
drag and check it out so again white
cross move it to a border to get those
four directional arrows and move it
around pretty stinkin sweet so those are
a bunch of different ways that you can
select the data within your table select
the entire table or move the table by
dragging and dropping really easily so
thank you guys for watching arm well
I'll see you guys next time
Related Exams
About this Video
|
4.93/5 Rating |
|
Dec 23, 2024 Last updated |
Video Description: Microsoft Excel 2013 Tutorial - 9 - Working with Tables for Software Development 2024 is part of Microsoft Excel 2013: Be the Excel Master preparation.
The notes and questions for Microsoft Excel 2013 Tutorial - 9 - Working with Tables have been prepared according to the Software Development exam syllabus.
Information about Microsoft Excel 2013 Tutorial - 9 - Working with Tables covers all important topics for Software Development 2024 Exam.
Find important definitions, questions, notes, meanings, examples, exercises and tests below for Microsoft Excel 2013 Tutorial - 9 - Working with Tables.
Introduction of Microsoft Excel 2013 Tutorial - 9 - Working with Tables in English is available as part of our Microsoft Excel 2013: Be the Excel Master for Software Development & Microsoft Excel 2013 Tutorial - 9 - Working with Tables in
Hindi for Microsoft Excel 2013: Be the Excel Master course. Download more important topics related with notes, lectures and mock test series for
Software Development Exam by signing up for free.
Description
Video Lecture & Questions for Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development - Software Development full syllabus preparation | Free video for Software Development exam to prepare for Microsoft Excel 2013: Be the Excel Master.
Information about Microsoft Excel 2013 Tutorial - 9 - Working with Tables
Here you can find the meaning of Microsoft Excel 2013 Tutorial - 9 - Working with Tables defined & explained in the simplest way possible.
Besides explaining types of Microsoft Excel 2013 Tutorial - 9 - Working with Tables theory, EduRev gives you an ample number of questions to practice Microsoft Excel 2013 Tutorial - 9 - Working with Tables tests,
examples and also practice Software Development tests.
|
Explore Courses for Software Development exam
|
|
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
Related Searches
video lectures
,shortcuts and tricks
,Previous Year Questions with Solutions
,MCQs
,Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development
,Important questions
,Free
,Viva Questions
,Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development
,Summary
,mock tests for examination
,Extra Questions
,past year papers
,Exam
,study material
,Semester Notes
,Objective type Questions
,Microsoft Excel 2013 Tutorial - 9 - Working with Tables Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development
,practice quizzes
,ppt
,Sample Paper
,
Study Microsoft Excel 2013 Tutorial - 9 - Working with Tables on the App
Students of Software Development can study Microsoft Excel 2013 Tutorial - 9 - Working with Tables alongwith tests & analysis from the EduRev app,
which will help them while preparing for their exam. Apart from the Microsoft Excel 2013 Tutorial - 9 - Working with Tables,
students can also utilize the EduRev App for other study materials such as previous year question papers, syllabus, important questions, etc.
The EduRev App will make your learning easier as you can access it from anywhere you want.
The content of Microsoft Excel 2013 Tutorial - 9 - Working with Tables is prepared as per the latest Software Development syllabus.
|
© EduRev
|
Education Revolution
|
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup