Create a Table

1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€95.55
List Price:  €133.77
You save:  €38.22
£79.30
List Price:  £111.02
You save:  £31.72
CA$141.90
List Price:  CA$198.66
You save:  CA$56.76
A$157.20
List Price:  A$220.09
You save:  A$62.88
S$134.19
List Price:  S$187.87
You save:  S$53.68
HK$777.47
List Price:  HK$1,088.50
You save:  HK$311.02
CHF 90.03
List Price:  CHF 126.04
You save:  CHF 36.01
NOK kr1,113.09
List Price:  NOK kr1,558.38
You save:  NOK kr445.28
DKK kr712.70
List Price:  DKK kr997.81
You save:  DKK kr285.11
NZ$175.11
List Price:  NZ$245.17
You save:  NZ$70.05
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,166.46
List Price:  ৳17,033.53
You save:  ৳4,867.07
₹8,691.60
List Price:  ₹12,168.59
You save:  ₹3,476.99
RM444.50
List Price:  RM622.32
You save:  RM177.82
₦150,999.89
List Price:  ₦211,405.89
You save:  ₦60,406
₨27,959.15
List Price:  ₨39,143.93
You save:  ₨11,184.78
฿3,368.76
List Price:  ฿4,716.40
You save:  ฿1,347.64
₺3,627.05
List Price:  ₺5,078.02
You save:  ₺1,450.96
B$572.50
List Price:  B$801.52
You save:  B$229.02
R1,838.04
List Price:  R2,573.33
You save:  R735.29
Лв186.91
List Price:  Лв261.69
You save:  Лв74.77
₩144,050.71
List Price:  ₩201,676.76
You save:  ₩57,626.04
₪356.60
List Price:  ₪499.25
You save:  ₪142.65
₱5,816.56
List Price:  ₱8,143.42
You save:  ₱2,326.86
¥15,183.26
List Price:  ¥21,257.18
You save:  ¥6,073.91
MX$2,025.94
List Price:  MX$2,836.40
You save:  MX$810.45
QR365
List Price:  QR511.01
You save:  QR146.01
P1,382.22
List Price:  P1,935.16
You save:  P552.94
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£5,060.50
List Price:  E£7,084.90
You save:  E£2,024.40
ብር12,853.61
List Price:  ብር17,995.56
You save:  ብር5,141.95
Kz91,190.88
List Price:  Kz127,670.88
You save:  Kz36,480
CLP$94,785.52
List Price:  CLP$132,703.52
You save:  CLP$37,918
CN¥727.91
List Price:  CN¥1,019.11
You save:  CN¥291.19
RD$6,215.25
List Price:  RD$8,701.60
You save:  RD$2,486.34
DA13,481.55
List Price:  DA18,874.71
You save:  DA5,393.16
FJ$229.81
List Price:  FJ$321.75
You save:  FJ$91.93
Q772.59
List Price:  Q1,081.66
You save:  Q309.06
GY$20,950.95
List Price:  GY$29,332.18
You save:  GY$8,381.22
ISK kr14,017.59
List Price:  ISK kr19,625.19
You save:  ISK kr5,607.60
DH997.60
List Price:  DH1,396.68
You save:  DH399.08
L1,864.97
List Price:  L2,611.03
You save:  L746.06
ден5,879.23
List Price:  ден8,231.16
You save:  ден2,351.92
MOP$802.38
List Price:  MOP$1,123.37
You save:  MOP$320.98
N$1,845.90
List Price:  N$2,584.33
You save:  N$738.43
C$3,684.65
List Price:  C$5,158.65
You save:  C$1,474
रु13,912.57
List Price:  रु19,478.15
You save:  रु5,565.58
S/370.44
List Price:  S/518.64
You save:  S/148.19
K402.76
List Price:  K563.88
You save:  K161.12
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,816.41
List Price:  ZK3,943.09
You save:  ZK1,126.67
L475.58
List Price:  L665.83
You save:  L190.25
Kč2,396.16
List Price:  Kč3,354.72
You save:  Kč958.56
Ft38,385.49
List Price:  Ft53,741.23
You save:  Ft15,355.73
SEK kr1,071.44
List Price:  SEK kr1,500.06
You save:  SEK kr428.62
ARS$105,926.90
List Price:  ARS$148,301.90
You save:  ARS$42,375
Bs694.44
List Price:  Bs972.25
You save:  Bs277.80
COP$413,151.75
List Price:  COP$578,428.98
You save:  COP$165,277.22
₡50,717.92
List Price:  ₡71,007.11
You save:  ₡20,289.19
L2,552.87
List Price:  L3,574.13
You save:  L1,021.25
₲791,418.37
List Price:  ₲1,108,017.38
You save:  ₲316,599.01
$U4,324.45
List Price:  $U6,054.41
You save:  $U1,729.95
zł397.30
List Price:  zł556.24
You save:  zł158.93
Already have an account? Log In

Transcript

So we're going to create a table to make this data easier to look at, sort and filter. To begin, you want to verify that your data has headers, and there are no blank rows amongst the data. Then, you can select one cell within the data set that's going to eventually become a table, go to the Insert tab and click table. Verify that the pop up that you get here, create table is correct. headers, click OK. And in that one motion there you have a table. Tables are great.

Because they come with these little filters and select sort commands you can sort alphabetically, you can sort numerically and you can sort chronologically by dates, assuming that your dates are in the right format to be recognized as a date. Not only that, can you also change the color of the table. You can filter the table. So imagine I want to see the United States, I can come over here and start to type the United States. Add that to the filter that set their tables can be named. Table one is the default first name when you name it.

Those spaces so I couldn't call it baseball roster with the space because there is a space there. So these are the requirements for a table name. So I would just come up here but a underscore between if I like to or just straight up. Okay, so that's the basic introduction of creating a table.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.