some of the wonders of excel
DESCRIPTION
Some of the Wonders of ExcelTRANSCRIPT
-
Science Seminar Friday, May 20, 2011
The Wonders of ExcelDownload workbook (scroll WAY down to bottom in Other
Excel Series section):
http://people.highline.edu/mgirvin/ExcelIsFun.htmWatch Video:
http://www.youtube.com/watch?v=YiNHBeu_WJIYouTube Site with Over 1400 Excel How To Videos (700
videos for Highline Classes):
http://www.youtube.com/excelisfunSlaying Excel Dragons Book:
http://www.amazon.com/gp/product/161547000X/ref=s9_simh_gw_p14_d2_i1?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=center-2&pf_rd_r=1ZY7BZVZ8RA3149NGHGS&pf_rd_t=101&pf_rd_p=470938631&pf_rd_i=507846Slaying Excel Dragons DVD:
http://www.mrexcel.com/slayingdragonsdvd2011.html
-
http://www.amazon.com/gp/product/161547000X/ref=s9_simh_gw_p14_d2_i1?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=center-2&pf_rd_r=1ZY7BZVZ8RA3149NGHGS&pf_rd_t=101&pf_rd_p=470938631&pf_rd_i=507846
-
http://www.amazon.com/gp/product/161547000X/ref=s9_simh_gw_p14_d2_i1?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=center-2&pf_rd_r=1ZY7BZVZ8RA3149NGHGS&pf_rd_t=101&pf_rd_p=470938631&pf_rd_i=507846
-
1 Copy & Paste Special (2 Examples)
2 Keyboard Magic (3 Examples)
3 Number Format
4 Decimal
5 Date (5 Examples)
6 Percentage
7 Formulas and Relative Cell References
8 Formulas and Absolute Cell References (2 Examples)
9 Sorting (4 Examples)
10 Filtering
11 PivotTables (2 Examples)
12 Charts/Graphs (6 Examples)
-
1) Copy the table, click in cell I3 and Paste while keeping source column widths.
2) Copy the table, click in cell A9 and Paste while transposing column and row headers.
Note: You can use your Horizontal Scroll Bar to scroll over and see more of the sheet to the right.
Bird 1 Count Bird 2 Count Bird 3 Count Bird 4 Count Bird 5 Count
Monday 149 112 276 115 276
Tuesday 173 228 235 145 252
Wednesday 318 241 122 155 280
-
1) Copy the table, click in cell I3 and Paste while keeping source column widths.
2) Copy the table, click in cell A9 and Paste while transposing column and row headers.
Note: You can use your Horizontal Scroll Bar to scroll over and see more of the sheet to the right.
Bird 6 Count
313
318
256
-
1) Copy the table, click in cell I3 and Paste while keeping source column widths.
2) Copy the table, click in cell A9 and Paste while transposing column and row headers.
Note: You can use your Horizontal Scroll Bar to scroll over and see more of the sheet to the right.
Bird 1 Count Bird 2 Count Bird 3 Count Bird 4 Count Bird 5 Count Bird 6 Count
Monday 149 112 276 115 276 313
Tuesday 173 228 235 145 252 318
Wednesday 318 241 122 155 280 256
Monday Tuesday Wednesday
Bird 1 Count 149 173 318
Bird 2 Count 112 228 241
Bird 3 Count 276 235 122
Bird 4 Count 115 145 155
Bird 5 Count 276 252 280
Bird 6 Count 313 318 256
-
1) Copy the table, click in cell I3 and Paste while keeping source column widths.
2) Copy the table, click in cell A9 and Paste while transposing column and row headers.
Note: You can use your Horizontal Scroll Bar to scroll over and see more of the sheet to the right.
Bird 1 Count Bird 2 Count Bird 3 Count Bird 4 Count Bird 5 Count
Monday 149 112 276 115 276
Tuesday 173 228 235 145 252
Wednesday 318 241 122 155 280
-
Bird 6 Count
313
318
256
-
1) Add Bold to the field name (column header) in cell A3.
2) Highlight the whole column and add the border "All Borders".
3) In cell C4 create a formula that adds Jan Sales.
Jan Sales Total
$25.00
$102.00
$68.00 The A4 and the A502 in A4:A502 are called "Cell References"
$59.00 because the formula refers to the cells for its numbers
$62.00
$104.00 Ctrl + Arrow = Jump
$17.00 Ctrl + Shift + Arrow = Highlight
$73.00 Alt + = puts in SUM function
$88.00
$19.00
$100.00
$17.00
$74.00
$39.00
$119.00
$32.00
$88.00
$60.00
$59.00
$53.00
$62.00
$118.00
$70.00
$33.00
$96.00
$18.00
$54.00
$29.00
$100.00
$54.00
$120.00
$44.00
$34.00
$33.00
$50.00
$97.00
$69.00
$104.00
$62.00
$71.00
$23.00
$47.00
-
$55.00
$49.00
$47.00
$80.00
$49.00
$109.00
$28.00
$35.00
$89.00
$52.00
$31.00
$57.00
$109.00
$85.00
$73.00
$89.00
$30.00
$82.00
$113.00
$16.00
$82.00
$10.00
$46.00
$85.00
$71.00
$13.00
$64.00
$109.00
$97.00
$109.00
$102.00
$29.00
$94.00
$56.00
$85.00
$107.00
$90.00
$63.00
$55.00
$68.00
$96.00
$95.00
$59.00
$25.00
$48.00
$85.00
$77.00
-
$33.00
$58.00
$78.00
$107.00
$63.00
$41.00
$99.00
$34.00
$33.00
$92.00
$63.00
$35.00
$60.00
$43.00
$120.00
$88.00
$64.00
$10.00
$15.00
$11.00
$114.00
$52.00
$53.00
$43.00
$86.00
$39.00
$36.00
$46.00
$81.00
$11.00
$115.00
$53.00
$58.00
$16.00
$46.00
$112.00
$105.00
$78.00
$27.00
$36.00
$93.00
$31.00
$107.00
$40.00
$40.00
$104.00
$84.00
-
$26.00
$19.00
$50.00
$100.00
$18.00
$62.00
$70.00
$46.00
$70.00
$80.00
$100.00
$61.00
$98.00
$66.00
$88.00
$107.00
$17.00
$27.00
$114.00
$41.00
$44.00
$44.00
$103.00
$108.00
$20.00
$119.00
$107.00
$19.00
$54.00
$95.00
$87.00
$23.00
$115.00
$18.00
$23.00
$57.00
$120.00
$15.00
$62.00
$47.00
$62.00
$47.00
$38.00
$37.00
$68.00
$109.00
$60.00
-
$110.00
$80.00
$92.00
$117.00
$120.00
$88.00
$97.00
$119.00
$57.00
$62.00
$29.00
$56.00
$104.00
$50.00
$92.00
$82.00
$52.00
$68.00
$98.00
$73.00
$41.00
$76.00
$74.00
$23.00
$120.00
$45.00
$119.00
$24.00
$56.00
$21.00
$24.00
$37.00
$66.00
$54.00
$102.00
$30.00
$61.00
$72.00
$74.00
$99.00
$112.00
$11.00
$117.00
$76.00
$50.00
$25.00
$68.00
-
$32.00
$37.00
$61.00
$58.00
$117.00
$78.00
$20.00
$24.00
$44.00
$82.00
$58.00
$104.00
$14.00
$33.00
$24.00
$62.00
$119.00
$37.00
$29.00
$42.00
$83.00
$42.00
$78.00
$70.00
$14.00
$69.00
$46.00
$66.00
$75.00
$29.00
$11.00
$114.00
$62.00
$12.00
$44.00
$25.00
$14.00
$26.00
$102.00
$117.00
$108.00
$100.00
$27.00
$113.00
$118.00
$119.00
$15.00
-
$79.00
$84.00
$41.00
$43.00
$33.00
$35.00
$114.00
$38.00
$46.00
$71.00
$52.00
$68.00
$111.00
$85.00
$95.00
$119.00
$76.00
$61.00
$89.00
$31.00
$118.00
$38.00
$60.00
$75.00
$51.00
$76.00
$83.00
$32.00
$89.00
$115.00
$94.00
$75.00
$115.00
$35.00
$89.00
$60.00
$62.00
$57.00
$33.00
$103.00
$34.00
$54.00
$14.00
$26.00
$20.00
$62.00
$118.00
-
$68.00
$111.00
$25.00
$107.00
$42.00
$13.00
$107.00
$31.00
$31.00
$27.00
$36.00
$61.00
$102.00
$79.00
$61.00
$15.00
$108.00
$33.00
$102.00
$27.00
$97.00
$65.00
$120.00
$23.00
$78.00
$16.00
$51.00
$49.00
$28.00
$71.00
$25.00
$21.00
$64.00
$102.00
$67.00
$65.00
$97.00
$70.00
$16.00
$62.00
$19.00
$38.00
$111.00
$41.00
$116.00
$44.00
$102.00
-
$44.00
$50.00
$60.00
$89.00
$16.00
$78.00
$87.00
$46.00
$110.00
$39.00
$40.00
$60.00
$84.00
$85.00
$75.00
$89.00
$90.00
$21.00
$52.00
$91.00
$72.00
$17.00
$56.00
$44.00
$35.00
$16.00
$78.00
$98.00
$18.00
$111.00
$49.00
$104.00
$17.00
$70.00
$54.00
$99.00
$85.00
$23.00
$56.00
$74.00
$120.00
$104.00
$109.00
$50.00
$73.00
$104.00
$22.00
-
$52.00
$88.00
$109.00
$45.00
$56.00
$110.00
$113.00
$74.00
$27.00
$48.00
$44.00
$83.00
$60.00
$40.00
$23.00
$120.00
$58.00
$64.00
$88.00
$110.00
$33.00
$15.00
$48.00
$27.00
$89.00
$81.00
$69.00
$117.00
$29.00
$98.00
$65.00
$76.00
$86.00
$16.00
$38.00
$113.00
$12.00
$105.00
$46.00
$26.00
$18.00
$37.00
$15.00
$49.00
$32.00
$41.00
$33.00
-
$107.00
$49.00
$94.00
$39.00
$50.00
$20.00
$85.00
$26.00
$110.00
$78.00
$33.00
$49.00
$60.00
$41.00
$12.00
$77.00
$37.00
$114.00
$48.00
$17.00
$47.00
$56.00
$45.00
$17.00
$20.00
$95.00
$31.00
$113.00
$118.00
$54.00
$111.00
$74.00
$60.00
$27.00
-
1) Add Bold to the field name (column header) in cell A3.
2) Highlight the whole column and add the border "All Borders".
3) In cell C4 create a formula that adds Jan Sales.
Jan Sales Total
$25.00 $31,662.00
$102.00
$68.00 The A4 and the A502 in A4:A502 are called "Cell References"
$59.00 because the formula refers to the cells for its numbers
$62.00
$104.00 Ctrl + Arrow = Jump
$17.00 Ctrl + Shift + Arrow = Highlight
$73.00 Alt + = puts in SUM function
$88.00
$19.00
$100.00
$17.00
$74.00
$39.00
$119.00
$32.00
$88.00
$60.00
$59.00
$53.00
$62.00
$118.00
$70.00
$33.00
$96.00
$18.00
$54.00
$29.00
$100.00
$54.00
$120.00
$44.00
$34.00
$33.00
$50.00
$97.00
$69.00
$104.00
$62.00
$71.00
$23.00
$47.00
-
$55.00
$49.00
$47.00
$80.00
$49.00
$109.00
$28.00
$35.00
$89.00
$52.00
$31.00
$57.00
$109.00
$85.00
$73.00
$89.00
$30.00
$82.00
$113.00
$16.00
$82.00
$10.00
$46.00
$85.00
$71.00
$13.00
$64.00
$109.00
$97.00
$109.00
$102.00
$29.00
$94.00
$56.00
$85.00
$107.00
$90.00
$63.00
$55.00
$68.00
$96.00
$95.00
$59.00
$25.00
$48.00
$85.00
$77.00
-
$33.00
$58.00
$78.00
$107.00
$63.00
$41.00
$99.00
$34.00
$33.00
$92.00
$63.00
$35.00
$60.00
$43.00
$120.00
$88.00
$64.00
$10.00
$15.00
$11.00
$114.00
$52.00
$53.00
$43.00
$86.00
$39.00
$36.00
$46.00
$81.00
$11.00
$115.00
$53.00
$58.00
$16.00
$46.00
$112.00
$105.00
$78.00
$27.00
$36.00
$93.00
$31.00
$107.00
$40.00
$40.00
$104.00
$84.00
-
$26.00
$19.00
$50.00
$100.00
$18.00
$62.00
$70.00
$46.00
$70.00
$80.00
$100.00
$61.00
$98.00
$66.00
$88.00
$107.00
$17.00
$27.00
$114.00
$41.00
$44.00
$44.00
$103.00
$108.00
$20.00
$119.00
$107.00
$19.00
$54.00
$95.00
$87.00
$23.00
$115.00
$18.00
$23.00
$57.00
$120.00
$15.00
$62.00
$47.00
$62.00
$47.00
$38.00
$37.00
$68.00
$109.00
$60.00
-
$110.00
$80.00
$92.00
$117.00
$120.00
$88.00
$97.00
$119.00
$57.00
$62.00
$29.00
$56.00
$104.00
$50.00
$92.00
$82.00
$52.00
$68.00
$98.00
$73.00
$41.00
$76.00
$74.00
$23.00
$120.00
$45.00
$119.00
$24.00
$56.00
$21.00
$24.00
$37.00
$66.00
$54.00
$102.00
$30.00
$61.00
$72.00
$74.00
$99.00
$112.00
$11.00
$117.00
$76.00
$50.00
$25.00
$68.00
-
$32.00
$37.00
$61.00
$58.00
$117.00
$78.00
$20.00
$24.00
$44.00
$82.00
$58.00
$104.00
$14.00
$33.00
$24.00
$62.00
$119.00
$37.00
$29.00
$42.00
$83.00
$42.00
$78.00
$70.00
$14.00
$69.00
$46.00
$66.00
$75.00
$29.00
$11.00
$114.00
$62.00
$12.00
$44.00
$25.00
$14.00
$26.00
$102.00
$117.00
$108.00
$100.00
$27.00
$113.00
$118.00
$119.00
$15.00
-
$79.00
$84.00
$41.00
$43.00
$33.00
$35.00
$114.00
$38.00
$46.00
$71.00
$52.00
$68.00
$111.00
$85.00
$95.00
$119.00
$76.00
$61.00
$89.00
$31.00
$118.00
$38.00
$60.00
$75.00
$51.00
$76.00
$83.00
$32.00
$89.00
$115.00
$94.00
$75.00
$115.00
$35.00
$89.00
$60.00
$62.00
$57.00
$33.00
$103.00
$34.00
$54.00
$14.00
$26.00
$20.00
$62.00
$118.00
-
$68.00
$111.00
$25.00
$107.00
$42.00
$13.00
$107.00
$31.00
$31.00
$27.00
$36.00
$61.00
$102.00
$79.00
$61.00
$15.00
$108.00
$33.00
$102.00
$27.00
$97.00
$65.00
$120.00
$23.00
$78.00
$16.00
$51.00
$49.00
$28.00
$71.00
$25.00
$21.00
$64.00
$102.00
$67.00
$65.00
$97.00
$70.00
$16.00
$62.00
$19.00
$38.00
$111.00
$41.00
$116.00
$44.00
$102.00
-
$44.00
$50.00
$60.00
$89.00
$16.00
$78.00
$87.00
$46.00
$110.00
$39.00
$40.00
$60.00
$84.00
$85.00
$75.00
$89.00
$90.00
$21.00
$52.00
$91.00
$72.00
$17.00
$56.00
$44.00
$35.00
$16.00
$78.00
$98.00
$18.00
$111.00
$49.00
$104.00
$17.00
$70.00
$54.00
$99.00
$85.00
$23.00
$56.00
$74.00
$120.00
$104.00
$109.00
$50.00
$73.00
$104.00
$22.00
-
$52.00
$88.00
$109.00
$45.00
$56.00
$110.00
$113.00
$74.00
$27.00
$48.00
$44.00
$83.00
$60.00
$40.00
$23.00
$120.00
$58.00
$64.00
$88.00
$110.00
$33.00
$15.00
$48.00
$27.00
$89.00
$81.00
$69.00
$117.00
$29.00
$98.00
$65.00
$76.00
$86.00
$16.00
$38.00
$113.00
$12.00
$105.00
$46.00
$26.00
$18.00
$37.00
$15.00
$49.00
$32.00
$41.00
$33.00
-
$107.00
$49.00
$94.00
$39.00
$50.00
$20.00
$85.00
$26.00
$110.00
$78.00
$33.00
$49.00
$60.00
$41.00
$12.00
$77.00
$37.00
$114.00
$48.00
$17.00
$47.00
$56.00
$45.00
$17.00
$20.00
$95.00
$31.00
$113.00
$118.00
$54.00
$111.00
$74.00
$60.00
$27.00
-
Sales *Number Formatting Can Save Time Typing
**Number Formatting is a faade (or Halloween mask) that sits to top
Project Start Date 3/14/2011 *Under the Date Number Format is # of Days since Dec 31, 1899
Project End Date 3/18/2011 ** Type Dates in, but underneath the faade is a numberProject Length in Days Dates
1
Invoice Due Date 2
Today's Date 40620
Day's Invoice Past Due 40644
Loan Amount $10,500.00 Percentage
Loan Issue Date 3/18/2010 0.02 *Rule to create Percentage Symbolic Representation:
Days until loan due 75 2 1) Multiply by 100 ==> .02*100 = 2
Date Loan is due 2) Add % Symbol ==> 2 and % ==> 2%
Project Start Date 3/14/2011
Length of Project (Days) 15
Project End Date
Project Start Date 3/14/2011
Length of Project (Workdays) 15
Project End Date
Holidays
3/15/2011
4/1/2011
-
*Under the Date Number Format is # of Days since Dec 31, 1899
** Type Dates in, but underneath the faade is a number
*Rule to create Percentage Symbolic Representation:
1) Multiply by 100 ==> .02*100 = 2
2) Add % Symbol ==> 2 and % ==> 2%
-
Sales *Number Formatting Can Save Time Typing
$10.00 **Number Formatting is a faade (or Halloween mask) that sits to top$12.50
$10.00 Project Start Date 3/14/2011 *Under the Date Number Format is # of Days since Dec 31, 1899
$12.50 Project End Date 3/18/2011 ** Type Dates in, but underneath the faade is a numberProject Length in Days 5 Dates
1/1/1900
Invoice Due Date 3/18/2011 1/2/1900
Today's Date 4/18/2011 40620
Day's Invoice Past Due 31 40644
Loan Amount $10,500.00 Percentage
Loan Issue Date 3/18/2010 2.00% *Rule to create Percentage Symbolic Representation:
Days until loan due 75 200.00% 1) Multiply by 100 ==> .02*100 = 2
Date Loan is due 6/1/2010 2.00% 2) Add % Symbol ==> 2 and % ==> 2%
2.50%
Project Start Date 3/14/2011
Length of Project (Days) 15
Project End Date 3/29/2011 2.00% Formatting as you type
.02 is still the numbner in the cell
Project Start Date 3/14/2011
Length of Project (Workdays) 15
Project End Date 4/2/2011
Holidays
3/15/2011
4/1/2011
-
*Under the Date Number Format is # of Days since Dec 31, 1899
** Type Dates in, but underneath the faade is a number
*Rule to create Percentage Symbolic Representation:
1) Multiply by 100 ==> .02*100 = 2
2) Add % Symbol ==> 2 and % ==> 2%
Formatting as you type
.02 is still the numbner in the cell
-
1) In cell B8 create a formula that adds the expenses (do not include the Revenue). Then copy that formula
through the range B8:F8.
2) In cell B9 create a formula that calculates Net Income. Then copy that formula through the range B9:F9.
Monday Tuesday Wednesday Thursday Friday
Revenue 1,000.00 1,100.00 1,210.00 1,331.00 1,464.10
Expense 1 291.00 228.00 140.00 268.00 217.00
Expense 2 200.00 124.00 270.00 140.00 164.00
Expense 3 235.00 225.00 103.00 233.00 257.00
Total Expenses
Net Income
To Copy Formula use "Angry Rabbit" Little Cross when pointing to lower right corner of highlighted cell
When you copy a formula, the "Relative Cell References" move along with the formula.
-
1) In cell B8 create a formula that adds the expenses (do not include the Revenue). Then copy that formula
through the range B8:F8.
2) In cell B9 create a formula that calculates Net Income. Then copy that formula through the range B9:F9.
Monday Tuesday Wednesday Thursday Friday
Revenue 1,000.00 1,100.00 1,210.00 1,331.00 1,464.10
Expense 1 291.00 228.00 140.00 268.00 217.00
Expense 2 200.00 124.00 270.00 140.00 164.00
Expense 3 235.00 225.00 103.00 233.00 257.00
Total Expenses 726.00 577.00 513.00 641.00 638.00
Net Income 274.00 523.00 697.00 690.00 826.10
To Copy Formula use "Angry Rabbit" Little Cross when pointing to lower right corner of highlighted cell
When you copy a formula, the "Relative Cell References" move along with the formula.
-
Metal Volume cm3
Mass g Density g/cm3
Gross Pay Deduction Tax Rate
Aluminum 53.98 2.70 $1,245.07 0.08
Aluminum 58.39 $1,259.24
Aluminum 46.95 $1,584.12 FICA 0.062
Aluminum 29.98 $1,131.61 Medicare 0.0145
Aluminum 51.28 $1,024.51
Aluminum 39.53 $1,081.14
Aluminum 64.81 $1,557.29
Aluminum 47.07 $1,386.97
Aluminum 56 $1,296.85
Aluminum 68.16 $1,431.24
Aluminum 42.89 $1,623.80
Aluminum 51.46 $1,055.25
Aluminum 89.78 $1,576.79
Absolute Cell Reference is "Locked" throughout copy action
When cursor touching Cell Reference, F4 Key locks it by putting $ $ signs in
-
Metal Volume cm3
Mass g Density g/cm3
Gross Pay Deduction
Aluminum 53.98 145.746 2.70 $1,245.07 $95.25
Aluminum 58.39 157.653 $1,259.24 $96.33
Aluminum 46.95 126.765 $1,584.12 $121.19 FICA
Aluminum 29.98 80.946 $1,131.61 $86.57 Medicare
Aluminum 51.28 138.456 $1,024.51 $78.38
Aluminum 39.53 106.731 $1,081.14 $82.71
Aluminum 64.81 174.987 $1,557.29 $119.13
Aluminum 47.07 127.089 $1,386.97 $106.10
Aluminum 56 151.2 $1,296.85 $99.21
Aluminum 68.16 184.032 $1,431.24 $109.49
Aluminum 42.89 115.803 $1,623.80 $124.22
Aluminum 51.46 138.942 $1,055.25 $80.73
Aluminum 89.78 242.406 $1,576.79 $120.62
Absolute Cell Reference is "Locked" throughout copy action
When cursor touching Cell Reference, F4 Key locks it by putting $ $ signs in
-
Tax Rate
0.07650
0.062
0.0145
-
Times *No data in column next to data to be sorted
08:09:36 **Click in one cell in column you want to sort, then sort
05:45:36
05:16:48 City Times
09:07:12 Oakland 08:09:36 *Sorting one column in a data set with many columns, will not wreck the data set (records are kept together)
06:00:00 Oakland 05:45:36
06:00:00 San Francisco 05:16:48
07:26:24 Oakland 09:07:12
Sample Times For
Assembly Process
(minutes)
Quality of
Assembly Rating
06:57:36 San Francisco 06:00:00 6.95 ***
04:33:36 Tacoma 06:00:00 4.86 **
04:48:00 Oakland 07:26:24 5.56 **
06:14:24 San Francisco 06:57:36 8.28 ****
04:19:12 Tacoma 04:33:36 6.44 **
08:52:48 Oakland 04:48:00 4.76 *
06:14:24 San Francisco 06:14:24 8.37 **
09:21:36 San Francisco 04:19:12 4.43 ***
02:24:00 San Francisco 08:52:48 4.18 ****
08:09:36 San Francisco 06:14:24 5.16 *
03:21:36 San Francisco 09:21:36 8.75 ****
06:00:00 Tacoma 02:24:00 5.65 **
-
*Sorting one column in a data set with many columns, will not wreck the data set (records are kept together)
Randomize a list
Student Names =RAND() creates random number between 0 and 1, 15 digits.
Shakia Talahytewa
Katelynn Faretra
Leena General
Francene Bracher
Laveta Patrone
Bulah Berthelsen
Thaddeus Bogenschutz
Fidel Bloodgood
Cliff Haeussler
Virgen Eid
Shakia Brade
-
Times *No data in column next to data to be sorted
02:24:00 **Click in one cell in column you want to sort, then sort
03:21:36
04:19:12 City Times
04:33:36 San Francisco 09:21:36 *Sorting one column in a data set with many columns, will not wreck the data set (records are kept together)
04:48:00 Oakland 09:07:12
05:16:48 San Francisco 08:52:48
05:45:36 Oakland 08:09:36
Sample Times For
Assembly Process
(minutes)
Quality of
Assembly Rating
06:00:00 Oakland 07:26:24 4.76 *
06:00:00 San Francisco 06:57:36 5.16 *
06:00:00 San Francisco 06:14:24 4.86 **
06:14:24 San Francisco 06:14:24 5.56 **
06:14:24 San Francisco 06:00:00 6.44 **
06:57:36 Tacoma 06:00:00 8.37 **
07:26:24 Oakland 05:45:36 5.65 **
08:09:36 San Francisco 05:16:48 6.95 ***
08:09:36 Oakland 04:48:00 4.43 ***
08:52:48 Tacoma 04:33:36 8.28 ****
09:07:12 San Francisco 04:19:12 4.18 ****
09:21:36 Tacoma 02:24:00 8.75 ****
-
*Sorting one column in a data set with many columns, will not wreck the data set (records are kept together)
Randomize a list
Student Names =RAND() creates random number between 0 and 1, 15 digits.
Fidel Bloodgood 0.311617
Cliff Haeussler 0.627317
Virgen Eid 0.371086
Francene Bracher 0.788084
Bulah Berthelsen 0.219909
Shakia Talahytewa 0.428045
Katelynn Faretra 0.791987 *F9 randomizes
Shakia Brade 0.988726
Thaddeus Bogenschutz 0.372413
Leena General 0.544062
Laveta Patrone 0.832366
-
Date Product Region SalesRep Customer Units Sales COGS
1/26/11 Bellen West Pham FRED 61 $5,000.00 $610.00 *Filter with as many criteria as you want, then copy and paste.
1/10/11 Quad West Smith KBTB 65 $1,755.00 $942.50
1/6/11 Quad West Sioux PCC 64 $1,728.00 $928.00
1/24/11 Quad West Gault HII 63 $1,701.00 $913.50
1/17/11 Quad East Franks HII 62 $1,674.00 $899.00
1/17/11 Quad MidWest Chin EPP 61 $1,647.00 $884.50
1/21/11 Quad East Chin FM 58 $1,566.00 $841.00
1/28/11 Quad South Gault KBTB 56 $1,512.00 $812.00
1/21/11 Quad West Gault ITW 56 $1,512.00 $812.00
1/10/11 Carlota East Pham AA 63 $1,449.00 $693.00
1/5/11 Carlota West Franks ITTW 60 $1,380.00 $660.00
1/20/11 Carlota East Chin ET 59 $1,357.00 $649.00
1/15/11 Sunset East Gault AST 63 $1,323.00 $582.75
1/11/11 Quad East Smith BBT 49 $1,323.00 $710.50
1/28/11 Sunset West Chin FM 62 $1,302.00 $573.50
1/18/11 Bellen East Pham DFR 59 $1,298.00 $590.00
1/7/11 Sunset West Pham T 61 $1,281.00 $564.25
1/13/11 Bellen MidWest Pham PLOT 57 $1,254.00 $570.00
1/16/11 Bellen MidWest Sioux YTR 56 $1,232.00 $560.00
1/18/11 Carlota South Smith YTR 53 $1,219.00 $583.00
1/21/11 Sunshine MidWest Smith QT 64 $1,216.00 $512.00
1/5/11 Sunset South Pham TTT 57 $1,197.00 $527.25
1/13/11 Carlota South Smith FM 52 $1,196.00 $572.00
1/23/11 Quad East Franks PCC 44 $1,188.00 $638.00
1/28/11 Quad South Franks YTR 44 $1,188.00 $638.00
1/18/11 Sunshine MidWest Chin PCC 62 $1,178.00 $496.00
1/22/11 Bellen West Pham AST 53 $1,166.00 $530.00
1/17/11 Quad East Gault SFWK 43 $1,161.00 $623.50
1/28/11 Quad MidWest Smith YTR 42 $1,134.00 $609.00
1/17/11 Sunshine MidWest Franks HHH 59 $1,121.00 $472.00
1/7/11 Sunset West Pham WT 53 $1,113.00 $490.25
1/20/11 Sunshine West Sioux YTR 58 $1,102.00 $464.00
1/29/11 Bellen East Chin AST 50 $1,100.00 $500.00
1/28/11 Carlota South Franks MNGD 46 $1,058.00 $506.00
1/6/11 Sunshine East Franks PSA 54 $1,026.00 $432.00
1/10/11 Sunset South Sioux MBG 47 $987.00 $434.75
1/28/11 Sunshine South Smith FRED 51 $969.00 $408.00
1/23/11 Sunshine South Chin T 49 $931.00 $392.00
1/30/11 Sunshine West Gault DFR 49 $931.00 $392.00
1/26/11 Sunset South Sioux DFGH 44 $924.00 $407.00
1/17/11 Carlota East Sioux PCC 39 $897.00 $429.00
1/9/11 Bellen East Pham EPP 40 $880.00 $400.00
1/13/11 Bellen MidWest Pham PSA 40 $880.00 $400.00
1/9/11 Carlota East Franks WSD 38 $874.00 $418.00
1/2/11 Quad West Pham AST 30 $810.00 $435.00
1/9/11 Sunshine East Smith PCC 42 $798.00 $336.00
1/22/11 Quad South Franks FM 29 $783.00 $420.50
-
1/14/11 Carlota East Franks JAQ 34 $782.00 $374.00
1/19/11 Bellen South Sioux T 35 $770.00 $350.00
1/22/11 Bellen West Sioux YTR 35 $770.00 $350.00
1/6/11 Sunshine South Smith QT 40 $760.00 $320.00
1/28/11 Sunset East Smith ZAT 36 $756.00 $333.00
1/3/11 Sunshine East Pham FM 38 $722.00 $304.00
1/16/11 Carlota South Smith QT 31 $713.00 $341.00
1/30/11 Quad South Sioux TTT 25 $675.00 $362.50
1/22/11 Carlota South Smith KBTB 29 $667.00 $319.00
1/13/11 Sunshine MidWest Pham PSA 33 $627.00 $264.00
1/4/11 Sunset MidWest Sioux BBT 29 $609.00 $268.25
1/23/11 Quad East Pham WT 22 $594.00 $319.00
1/7/11 Bellen West Smith T 27 $594.00 $270.00
1/9/11 Bellen South Chin WSD 26 $572.00 $260.00
1/10/11 Sunshine South Chin TRU 30 $570.00 $240.00
1/10/11 Sunset East Gault TRU 27 $567.00 $249.75
1/28/11 Bellen South Sioux QT 25 $550.00 $250.00
1/2/11 Bellen South Gault KBTB 24 $528.00 $240.00
1/3/11 Sunset South Pham WSD 23 $483.00 $212.75
1/26/11 Bellen MidWest Gault PSA 21 $462.00 $210.00
1/7/11 Sunset MidWest Sioux PCC 22 $462.00 $203.50
1/3/11 Carlota MidWest Chin FM 20 $460.00 $220.00
1/10/11 Quad East Smith DFR 17 $459.00 $246.50
1/18/11 Quad MidWest Smith PLOT 17 $459.00 $246.50
1/18/11 Sunshine East Franks AA 24 $456.00 $192.00
1/18/11 Bellen East Franks DFGH 20 $440.00 $200.00
1/21/11 Sunshine MidWest Pham DFR 23 $437.00 $184.00
1/30/11 Sunshine South Sioux TTT 23 $437.00 $184.00
1/1/11 Quad East Sioux AA 16 $432.00 $232.00
1/8/11 Quad West Chin HII 16 $432.00 $232.00
1/2/11 Bellen West Pham SFWK 19 $418.00 $190.00
1/6/11 Carlota West Sioux KPSA 18 $414.00 $198.00
1/25/11 Sunshine MidWest Franks JAQ 21 $399.00 $168.00
1/12/11 Sunset MidWest Gault ITW 19 $399.00 $175.75
1/11/11 Quad East Franks ITW 14 $378.00 $203.00
1/26/11 Bellen East Chin KPSA 17 $374.00 $170.00
1/10/11 Sunset East Smith MBG 17 $357.00 $157.25
1/17/11 Bellen MidWest Smith PCC 16 $352.00 $160.00
1/28/11 Carlota West Smith LOP 15 $345.00 $165.00
1/9/11 Bellen South Sioux QT 15 $330.00 $150.00
1/24/11 Carlota MidWest Franks BBT 13 $299.00 $143.00
1/7/11 Carlota MidWest Franks HHH 12 $276.00 $132.00
1/21/11 Sunset South Pham HHH 13 $273.00 $120.25
1/29/11 Quad MidWest Gault PLOT 10 $270.00 $145.00
1/17/11 Quad West Chin PCC 10 $270.00 $145.00
1/18/11 Sunset East Gault MNGD 12 $252.00 $111.00
1/21/11 Bellen South Smith TRU 11 $242.00 $110.00
-
1/27/11 Carlota West Gault QT 10 $230.00 $110.00
1/5/11 Sunshine West Franks ET 12 $228.00 $96.00
1/20/11 Bellen East Gault PSA 10 $220.00 $100.00
1/15/11 Sunshine MidWest Chin YTR 11 $209.00 $88.00
1/23/11 Bellen East Gault DFGH 9 $198.00 $90.00
1/10/11 Bellen MidWest Gault FM 7 $154.00 $70.00
1/12/11 Bellen South Chin WT 7 $154.00 $70.00
1/10/11 Sunshine MidWest Smith TTT 8 $152.00 $64.00
1/18/11 Sunshine West Sioux AST 8 $152.00 $64.00
1/22/11 Bellen West Smith WT 6 $132.00 $60.00
1/3/11 Sunshine South Sioux PCC 6 $114.00 $48.00
-
*Filter with as many criteria as you want, then copy and paste.
-
Date Product Region SalesRep Customer Units Sales COGS
1/26/11 Bellen West Pham FRED 61 $5,000.00 $610.00 *Filter with as many criteria as you want, then copy and paste.
1/10/11 Quad West Smith KBTB 65 $1,755.00 $942.50
1/6/11 Quad West Sioux PCC 64 $1,728.00 $928.00
1/24/11 Quad West Gault HII 63 $1,701.00 $913.50
1/17/11 Quad East Franks HII 62 $1,674.00 $899.00
1/17/11 Quad MidWest Chin EPP 61 $1,647.00 $884.50
1/21/11 Quad East Chin FM 58 $1,566.00 $841.00
1/28/11 Quad South Gault KBTB 56 $1,512.00 $812.00
1/21/11 Quad West Gault ITW 56 $1,512.00 $812.00
1/10/11 Carlota East Pham AA 63 $1,449.00 $693.00
1/5/11 Carlota West Franks ITTW 60 $1,380.00 $660.00
1/20/11 Carlota East Chin ET 59 $1,357.00 $649.00
1/15/11 Sunset East Gault AST 63 $1,323.00 $582.75
1/11/11 Quad East Smith BBT 49 $1,323.00 $710.50
1/28/11 Sunset West Chin FM 62 $1,302.00 $573.50
1/18/11 Bellen East Pham DFR 59 $1,298.00 $590.00
1/7/11 Sunset West Pham T 61 $1,281.00 $564.25
1/13/11 Bellen MidWest Pham PLOT 57 $1,254.00 $570.00
1/16/11 Bellen MidWest Sioux YTR 56 $1,232.00 $560.00
1/18/11 Carlota South Smith YTR 53 $1,219.00 $583.00
1/21/11 Sunshine MidWest Smith QT 64 $1,216.00 $512.00
1/5/11 Sunset South Pham TTT 57 $1,197.00 $527.25
1/13/11 Carlota South Smith FM 52 $1,196.00 $572.00
1/23/11 Quad East Franks PCC 44 $1,188.00 $638.00
1/28/11 Quad South Franks YTR 44 $1,188.00 $638.00
1/18/11 Sunshine MidWest Chin PCC 62 $1,178.00 $496.00
1/22/11 Bellen West Pham AST 53 $1,166.00 $530.00
1/17/11 Quad East Gault SFWK 43 $1,161.00 $623.50
1/28/11 Quad MidWest Smith YTR 42 $1,134.00 $609.00
1/17/11 Sunshine MidWest Franks HHH 59 $1,121.00 $472.00
1/7/11 Sunset West Pham WT 53 $1,113.00 $490.25
1/20/11 Sunshine West Sioux YTR 58 $1,102.00 $464.00
1/29/11 Bellen East Chin AST 50 $1,100.00 $500.00
1/28/11 Carlota South Franks MNGD 46 $1,058.00 $506.00
1/6/11 Sunshine East Franks PSA 54 $1,026.00 $432.00
1/10/11 Sunset South Sioux MBG 47 $987.00 $434.75
1/28/11 Sunshine South Smith FRED 51 $969.00 $408.00
1/23/11 Sunshine South Chin T 49 $931.00 $392.00
1/30/11 Sunshine West Gault DFR 49 $931.00 $392.00
1/26/11 Sunset South Sioux DFGH 44 $924.00 $407.00
1/17/11 Carlota East Sioux PCC 39 $897.00 $429.00
1/9/11 Bellen East Pham EPP 40 $880.00 $400.00
1/13/11 Bellen MidWest Pham PSA 40 $880.00 $400.00
1/9/11 Carlota East Franks WSD 38 $874.00 $418.00
1/2/11 Quad West Pham AST 30 $810.00 $435.00
1/9/11 Sunshine East Smith PCC 42 $798.00 $336.00
1/22/11 Quad South Franks FM 29 $783.00 $420.50
-
1/14/11 Carlota East Franks JAQ 34 $782.00 $374.00
1/19/11 Bellen South Sioux T 35 $770.00 $350.00
1/22/11 Bellen West Sioux YTR 35 $770.00 $350.00
1/6/11 Sunshine South Smith QT 40 $760.00 $320.00
1/28/11 Sunset East Smith ZAT 36 $756.00 $333.00
1/3/11 Sunshine East Pham FM 38 $722.00 $304.00
1/16/11 Carlota South Smith QT 31 $713.00 $341.00
1/30/11 Quad South Sioux TTT 25 $675.00 $362.50
1/22/11 Carlota South Smith KBTB 29 $667.00 $319.00
1/13/11 Sunshine MidWest Pham PSA 33 $627.00 $264.00
1/4/11 Sunset MidWest Sioux BBT 29 $609.00 $268.25
1/23/11 Quad East Pham WT 22 $594.00 $319.00
1/7/11 Bellen West Smith T 27 $594.00 $270.00
1/9/11 Bellen South Chin WSD 26 $572.00 $260.00
1/10/11 Sunshine South Chin TRU 30 $570.00 $240.00
1/10/11 Sunset East Gault TRU 27 $567.00 $249.75
1/28/11 Bellen South Sioux QT 25 $550.00 $250.00
1/2/11 Bellen South Gault KBTB 24 $528.00 $240.00
1/3/11 Sunset South Pham WSD 23 $483.00 $212.75
1/26/11 Bellen MidWest Gault PSA 21 $462.00 $210.00
1/7/11 Sunset MidWest Sioux PCC 22 $462.00 $203.50
1/3/11 Carlota MidWest Chin FM 20 $460.00 $220.00
1/10/11 Quad East Smith DFR 17 $459.00 $246.50
1/18/11 Quad MidWest Smith PLOT 17 $459.00 $246.50
1/18/11 Sunshine East Franks AA 24 $456.00 $192.00
1/18/11 Bellen East Franks DFGH 20 $440.00 $200.00
1/21/11 Sunshine MidWest Pham DFR 23 $437.00 $184.00
1/30/11 Sunshine South Sioux TTT 23 $437.00 $184.00
1/1/11 Quad East Sioux AA 16 $432.00 $232.00
1/8/11 Quad West Chin HII 16 $432.00 $232.00
1/2/11 Bellen West Pham SFWK 19 $418.00 $190.00
1/6/11 Carlota West Sioux KPSA 18 $414.00 $198.00
1/25/11 Sunshine MidWest Franks JAQ 21 $399.00 $168.00
1/12/11 Sunset MidWest Gault ITW 19 $399.00 $175.75
1/11/11 Quad East Franks ITW 14 $378.00 $203.00
1/26/11 Bellen East Chin KPSA 17 $374.00 $170.00
1/10/11 Sunset East Smith MBG 17 $357.00 $157.25
1/17/11 Bellen MidWest Smith PCC 16 $352.00 $160.00
1/28/11 Carlota West Smith LOP 15 $345.00 $165.00
1/9/11 Bellen South Sioux QT 15 $330.00 $150.00
1/24/11 Carlota MidWest Franks BBT 13 $299.00 $143.00
1/7/11 Carlota MidWest Franks HHH 12 $276.00 $132.00
1/21/11 Sunset South Pham HHH 13 $273.00 $120.25
1/29/11 Quad MidWest Gault PLOT 10 $270.00 $145.00
1/17/11 Quad West Chin PCC 10 $270.00 $145.00
1/18/11 Sunset East Gault MNGD 12 $252.00 $111.00
1/21/11 Bellen South Smith TRU 11 $242.00 $110.00
-
1/27/11 Carlota West Gault QT 10 $230.00 $110.00
1/5/11 Sunshine West Franks ET 12 $228.00 $96.00
1/20/11 Bellen East Gault PSA 10 $220.00 $100.00
1/15/11 Sunshine MidWest Chin YTR 11 $209.00 $88.00
1/23/11 Bellen East Gault DFGH 9 $198.00 $90.00
1/10/11 Bellen MidWest Gault FM 7 $154.00 $70.00
1/12/11 Bellen South Chin WT 7 $154.00 $70.00
1/10/11 Sunshine MidWest Smith TTT 8 $152.00 $64.00
1/18/11 Sunshine West Sioux AST 8 $152.00 $64.00
1/22/11 Bellen West Smith WT 6 $132.00 $60.00
1/3/11 Sunshine South Sioux PCC 6 $114.00 $48.00
-
*Filter with as many criteria as you want, then copy and paste.
-
Date Product Region SalesRep Customer Units Sales COGS
1/10/11 Quad West Smith KBTB 65 $1,755.00 $942.50
1/6/11 Quad West Sioux PCC 64 $1,728.00 $928.00
1/24/11 Quad West Gault HII 63 $1,701.00 $913.50
1/21/11 Quad West Gault ITW 56 $1,512.00 $812.00
1/2/11 Quad West Pham AST 30 $810.00 $435.00
1/8/11 Quad West Chin HII 16 $432.00 $232.00
1/17/11 Quad West Chin PCC 10 $270.00 $145.00
-
Date Product Region SalesRep Customer Units Sales COGS
1/26/11 Bellen West Pham FRED 61 $5,000.00 $610.00
1/10/11 Quad West Smith KBTB 65 $1,755.00 $942.50
1/6/11 Quad MidWest Pham PSA 40 $880.00 $400.00
1/24/11 Quad West Sioux PCC 64 $1,728.00 $928.00
1/17/11 Quad West Gault HII 63 $1,701.00 $913.50
1/17/11 Quad MidWest Pham PLOT 57 $1,254.00 $570.00
1/21/11 Quad East Franks HII 62 $1,674.00 $899.00
1/28/11 Quad MidWest Chin EPP 61 $1,647.00 $884.50
1/21/11 Quad East Chin FM 58 $1,566.00 $841.00
1/10/11 Carlota South Gault KBTB 56 $1,512.00 $812.00
1/5/11 Carlota West Gault ITW 56 $1,512.00 $812.00
1/20/11 Carlota East Pham AA 63 $1,449.00 $693.00
1/15/11 Sunset West Franks ITTW 60 $1,380.00 $660.00
1/11/11 Quad East Chin ET 59 $1,357.00 $649.00
1/28/11 Sunset East Gault AST 63 $1,323.00 $582.75
1/18/11 Bellen East Smith BBT 49 $1,323.00 $710.50
1/7/11 Sunset West Chin FM 62 $1,302.00 $573.50
1/13/11 Bellen East Pham DFR 59 $1,298.00 $590.00
1/16/11 Bellen West Pham T 61 $1,281.00 $564.25
1/18/11 Carlota MidWest Sioux YTR 56 $1,232.00 $560.00
1/21/11 Sunshine South Smith YTR 53 $1,219.00 $583.00
1/5/11 Sunset MidWest Smith QT 64 $1,216.00 $512.00
1/13/11 Carlota South Pham TTT 57 $1,197.00 $527.25
1/23/11 Quad South Smith FM 52 $1,196.00 $572.00
1/28/11 Quad East Franks PCC 44 $1,188.00 $638.00
1/18/11 Sunshine South Franks YTR 44 $1,188.00 $638.00
1/22/11 Bellen MidWest Chin PCC 62 $1,178.00 $496.00
1/17/11 Quad West Pham AST 53 $1,166.00 $530.00
1/28/11 Quad East Gault SFWK 43 $1,161.00 $623.50
1/17/11 Sunshine MidWest Smith YTR 42 $1,134.00 $609.00
1/7/11 Sunset MidWest Franks HHH 59 $1,121.00 $472.00
1/20/11 Sunshine West Pham WT 53 $1,113.00 $490.25
1/29/11 Bellen West Sioux YTR 58 $1,102.00 $464.00
1/28/11 Carlota East Chin AST 50 $1,100.00 $500.00
1/6/11 Sunshine South Franks MNGD 46 $1,058.00 $506.00
1/10/11 Sunset East Franks PSA 54 $1,026.00 $432.00
1/28/11 Sunshine South Sioux MBG 47 $987.00 $434.75
1/23/11 Sunshine South Smith FRED 51 $969.00 $408.00
1/30/11 Sunshine South Chin T 49 $931.00 $392.00
1/26/11 Sunset West Gault DFR 49 $931.00 $392.00
1/17/11 Carlota South Sioux DFGH 44 $924.00 $407.00
1/9/11 Bellen East Sioux PCC 39 $897.00 $429.00
1/13/11 Bellen East Pham EPP 40 $880.00 $400.00
1/9/11 Carlota East Franks WSD 38 $874.00 $418.00
1/2/11 Quad West Pham AST 30 $810.00 $435.00
1/9/11 Sunshine East Smith PCC 42 $798.00 $336.00
1/22/11 Quad South Franks FM 29 $783.00 $420.50
-
1/14/11 Carlota East Franks JAQ 34 $782.00 $374.00
1/19/11 Bellen South Sioux T 35 $770.00 $350.00
1/22/11 Bellen West Sioux YTR 35 $770.00 $350.00
1/6/11 Sunshine South Smith QT 40 $760.00 $320.00
1/28/11 Sunset East Smith ZAT 36 $756.00 $333.00
1/3/11 Sunshine East Pham FM 38 $722.00 $304.00
1/16/11 Carlota South Smith QT 31 $713.00 $341.00
1/30/11 Quad South Sioux TTT 25 $675.00 $362.50
1/22/11 Carlota South Smith KBTB 29 $667.00 $319.00
1/13/11 Sunshine MidWest Pham PSA 33 $627.00 $264.00
1/4/11 Sunset MidWest Sioux BBT 29 $609.00 $268.25
1/23/11 Quad East Pham WT 22 $594.00 $319.00
1/7/11 Bellen West Smith T 27 $594.00 $270.00
1/9/11 Bellen South Chin WSD 26 $572.00 $260.00
1/10/11 Sunshine South Chin TRU 30 $570.00 $240.00
1/10/11 Sunset East Gault TRU 27 $567.00 $249.75
1/28/11 Bellen South Sioux QT 25 $550.00 $250.00
1/2/11 Bellen South Gault KBTB 24 $528.00 $240.00
1/3/11 Sunset South Pham WSD 23 $483.00 $212.75
1/26/11 Bellen MidWest Gault PSA 21 $462.00 $210.00
1/7/11 Sunset MidWest Sioux PCC 22 $462.00 $203.50
1/3/11 Carlota MidWest Chin FM 20 $460.00 $220.00
1/10/11 Quad East Smith DFR 17 $459.00 $246.50
1/18/11 Quad MidWest Smith PLOT 17 $459.00 $246.50
1/18/11 Sunshine East Franks AA 24 $456.00 $192.00
1/18/11 Bellen East Franks DFGH 20 $440.00 $200.00
1/21/11 Sunshine MidWest Pham DFR 23 $437.00 $184.00
1/30/11 Sunshine South Sioux TTT 23 $437.00 $184.00
1/1/11 Quad East Sioux AA 16 $432.00 $232.00
1/8/11 Quad West Chin HII 16 $432.00 $232.00
1/2/11 Bellen West Pham SFWK 19 $418.00 $190.00
1/6/11 Carlota West Sioux KPSA 18 $414.00 $198.00
1/25/11 Sunshine MidWest Franks JAQ 21 $399.00 $168.00
1/12/11 Sunset MidWest Gault ITW 19 $399.00 $175.75
1/11/11 Quad East Franks ITW 14 $378.00 $203.00
1/26/11 Bellen East Chin KPSA 17 $374.00 $170.00
1/10/11 Sunset East Smith MBG 17 $357.00 $157.25
1/17/11 Bellen MidWest Smith PCC 16 $352.00 $160.00
1/28/11 Carlota West Smith LOP 15 $345.00 $165.00
1/9/11 Bellen South Sioux QT 15 $330.00 $150.00
1/24/11 Carlota MidWest Franks BBT 13 $299.00 $143.00
1/7/11 Carlota MidWest Franks HHH 12 $276.00 $132.00
1/21/11 Sunset South Pham HHH 13 $273.00 $120.25
1/29/11 Quad MidWest Gault PLOT 10 $270.00 $145.00
1/17/11 Quad West Chin PCC 10 $270.00 $145.00
1/18/11 Sunset East Gault MNGD 12 $252.00 $111.00
1/21/11 Bellen South Smith TRU 11 $242.00 $110.00
-
1/27/11 Carlota West Gault QT 10 $230.00 $110.00
1/5/11 Sunshine West Franks ET 12 $228.00 $96.00
1/20/11 Bellen East Gault PSA 10 $220.00 $100.00
1/15/11 Sunshine MidWest Chin YTR 11 $209.00 $88.00
1/23/11 Bellen East Gault DFGH 9 $198.00 $90.00
1/10/11 Bellen MidWest Gault FM 7 $154.00 $70.00
1/12/11 Bellen South Chin WT 7 $154.00 $70.00
1/10/11 Sunshine MidWest Smith TTT 8 $152.00 $64.00
1/18/11 Sunshine West Sioux AST 8 $152.00 $64.00
1/22/11 Bellen West Smith WT 6 $132.00 $60.00
1/3/11 Sunshine South Sioux PCC 6 $114.00 $48.00
-
SalesRep/Region East MidWest South West
Chin $4,397 $3,494 $2,227 $2,004
Franks $6,818 $2,095 $3,029 $1,608
Gault $3,721 $1,285 $2,040 $4,374
Pham $4,943 $3,198 $1,953 $9,788
Sioux $1,329 $2,303 $4,787 $4,166
Smith $3,693 $3,313 $5,766 $2,826
-
The question is: How do you rate your instructor?
Then, let's find out how ratings change depending on
how long they have been tenured!
Class Rating Tenured
OK 10 > 20 Years
Excellent 5 > 10 Years Tenured/Class Rating Excellent Good OK
Excellent 5 > 10 Years 1 > 5 Years 7 5 7
OK 1 > 5 Years 5 > 10 Years 7 8 1
Good 5 > 10 Years 10 > 20 Years 5 2 3
Good 5 > 10 Years
Good 5 > 10 Years
Excellent 5 > 10 Years
Excellent 10 > 20 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
Good 1 > 5 Years
OK 1 > 5 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
Good 1 > 5 Years
Good 5 > 10 Years
Good 5 > 10 Years
Good 5 > 10 Years
Excellent 10 > 20 Years
Good 10 > 20 Years
OK 5 > 10 Years
Good 5 > 10 Years
OK 1 > 5 Years
Excellent 1 > 5 Years
OK 1 > 5 Years
OK 1 > 5 Years
Excellent 5 > 10 Years
OK 1 > 5 Years
Excellent 10 > 20 Years
Good 10 > 20 Years
Excellent 1 > 5 Years
OK 10 > 20 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
OK 1 > 5 Years
Good 5 > 10 Years
OK 10 > 20 Years
Excellent 5 > 10 Years
Excellent 10 > 20 Years
Excellent 1 > 5 Years
Excellent 5 > 10 Years
-
Excellent 1 > 5 Years
Excellent 10 > 20 Years
Excellent 5 > 10 Years
-
Column Charts (Compare items across categories)
PivotTableSum of Sales Region
SalesRep East MidWest South West Grand Total
Chin $4,397.00 $3,494.00 $2,227.00 $2,004.00 $12,122.00
Franks $6,818.00 $2,095.00 $3,029.00 $1,608.00 $13,550.00
Gault $3,721.00 $1,285.00 $2,040.00 $4,374.00 $11,420.00
Pham $4,943.00 $3,198.00 $1,953.00 $9,788.00 $19,882.00
Sioux $1,329.00 $2,303.00 $4,787.00 $4,166.00 $12,585.00
Smith $3,693.00 $3,313.00 $5,766.00 $2,826.00 $15,598.00
Grand Total $24,901.00 $15,688.00 $19,802.00 $24,766.00 $85,157.00
Not A PivotTable:East MidWest South West
Chin $4,397 $3,494 $2,227 $2,004
Franks $6,818 $2,095 $3,029 $1,608
Gault $3,721 $1,285 $2,040 $4,374
Pham $4,943 $3,198 $1,953 $9,788
Sioux $1,329 $2,303 $4,787 $4,166
Smith $3,693 $3,313 $5,766 $2,826
Line Charts: (1 Number and a label/category)Bird Sightings City Bird Sightings Year Bird Sightings
250 Seattle 250 2008 250
652 Tacoma 652 2009 652
352 Burien 352 2010 352
401 Olympia 401 2011 401
385 San Jose 385 2012 385
239 Portland 239 2013 239
X-Y Scatter (2 Numbers)Angle Range
0.0 0.050
2.5 0.087
5.0 0.224
7.5 0.309
10.0 0.342
12.5 0.423
15.0 0.450
17.5 0.524
20.0 0.593
22.5 0.707
25.0 0.816
-
27.5 0.869
30.0 0.866
32.5 0.906
35.0 0.890
37.5 0.966
40.0 0.985
42.5 0.996
45.0 1.000
47.5 1.046
50.0 1.035
52.5 0.966
55.0 0.940
57.5 0.956
60.0 0.816
62.5 0.819
65.0 0.766
67.5 0.707
70.0 0.693
72.5 0.624
75.0 0.500
77.5 0.373
80.0 0.392
82.5 0.309
85.0 0.124
87.5 0.137
90.0 -0.050
-
Column Charts (Compare items across categories)
PivotTableSum of Sales Region
SalesRep East MidWest South West Grand Total
Chin $4,397.00 $3,494.00 $2,227.00 $2,004.00 $12,122.00
Franks $6,818.00 $2,095.00 $3,029.00 $1,608.00 $13,550.00
Gault $3,721.00 $1,285.00 $2,040.00 $4,374.00 $11,420.00
Pham $4,943.00 $3,198.00 $1,953.00 $9,788.00 $19,882.00
Sioux $1,329.00 $2,303.00 $4,787.00 $4,166.00 $12,585.00
Smith $3,693.00 $3,313.00 $5,766.00 $2,826.00 $15,598.00
Grand Total $24,901.00 $15,688.00 $19,802.00 $24,766.00 $85,157.00
Not A PivotTable:East MidWest South West
Chin $4,397 $3,494 $2,227 $2,004
Franks $6,818 $2,095 $3,029 $1,608
Gault $3,721 $1,285 $2,040 $4,374
Pham $4,943 $3,198 $1,953 $9,788
Sioux $1,329 $2,303 $4,787 $4,166
Smith $3,693 $3,313 $5,766 $2,826
Line Charts: (1 Number and a label/category)Bird Sightings City Bird Sightings Year Bird Sightings
250 Seattle 250 2008 250
652 Tacoma 652 2009 652
352 Burien 352 2010 352
401 Olympia 401 2011 401
385 San Jose 385 2012 385
239 Portland 239 2013 239
X-Y Scatter (2 Numbers)Angle Range
0.0 0.050
2.5 0.087
5.0 0.224
7.5 0.309
10.0 0.342
12.5 0.423
15.0 0.450
17.5 0.524
20.0 0.593
22.5 0.707
25.0 0.816
$0.00
$2,000.00
$4,000.00
$6,000.00
$8,000.00
$10,000.00
$12,000.00
Chin Franks
SalesRep
Sum of Sales
$0
$2,000
$4,000
$6,000
$8,000
$10,000
$12,000
East MidWest
0
100
200
300
400
500
600
700
0
100
200
300
400
500
600
700
2008 2009 2010 2011 2012
Bird Sightings
y = -0.0005x2 + 0.0451x
-0.200
0.000
0.200
0.400
0.600
0.800
1.000
1.200
0.0 20.0 40.0 60.0 80.0
Ran
ge
Angel
Angle & Range
-
27.5 0.869
30.0 0.866
32.5 0.906
35.0 0.890
37.5 0.966
40.0 0.985
42.5 0.996
45.0 1.000
47.5 1.046
50.0 1.035
52.5 0.966
55.0 0.940
57.5 0.956
60.0 0.816
62.5 0.819
65.0 0.766
67.5 0.707
70.0 0.693
72.5 0.624
75.0 0.500
77.5 0.373
80.0 0.392
82.5 0.309
85.0 0.124
87.5 0.137
90.0 -0.050
-
Gault Pham Sioux Smith
East
MidWest
South
West
Region
MidWest South West
Chin
Franks
Gault
Pham
Sioux
Smith
0
100
200
300
400
500
600
700
1 2 3 4 5 6
Bird Sightings
0
100
200
300
400
500
600
700
Seattle Tacoma Burien Olympia San Jose Portland
Bird Sightings
2013
+ 0.0451x - 0.0308
80.0 100.0
-
Date Product Region SalesRep Customer Units Sales COGS
1/26/11 Bellen West Pham FRED 61 $5,000.00 $610.00
1/10/11 Quad West Smith KBTB 65 $1,755.00 $942.50
1/6/11 Quad MidWest Pham PSA 40 $880.00 $400.00
1/24/11 Quad West Sioux PCC 64 $1,728.00 $928.00
1/17/11 Quad West Gault HII 63 $1,701.00 $913.50
1/17/11 Quad MidWest Pham PLOT 57 $1,254.00 $570.00
1/21/11 Quad East Franks HII 62 $1,674.00 $899.00
1/28/11 Quad MidWest Chin EPP 61 $1,647.00 $884.50
1/21/11 Quad East Chin FM 58 $1,566.00 $841.00
1/10/11 Carlota South Gault KBTB 56 $1,512.00 $812.00
1/5/11 Carlota West Gault ITW 56 $1,512.00 $812.00
1/20/11 Carlota East Pham AA 63 $1,449.00 $693.00
1/15/11 Sunset West Franks ITTW 60 $1,380.00 $660.00
1/11/11 Quad East Chin ET 59 $1,357.00 $649.00
1/28/11 Sunset East Gault AST 63 $1,323.00 $582.75
1/18/11 Bellen East Smith BBT 49 $1,323.00 $710.50
1/7/11 Sunset West Chin FM 62 $1,302.00 $573.50
1/13/11 Bellen East Pham DFR 59 $1,298.00 $590.00
1/16/11 Bellen West Pham T 61 $1,281.00 $564.25
1/18/11 Carlota MidWest Sioux YTR 56 $1,232.00 $560.00
1/21/11 Sunshine South Smith YTR 53 $1,219.00 $583.00
1/5/11 Sunset MidWest Smith QT 64 $1,216.00 $512.00
1/13/11 Carlota South Pham TTT 57 $1,197.00 $527.25
1/23/11 Quad South Smith FM 52 $1,196.00 $572.00
1/28/11 Quad East Franks PCC 44 $1,188.00 $638.00
1/18/11 Sunshine South Franks YTR 44 $1,188.00 $638.00
1/22/11 Bellen MidWest Chin PCC 62 $1,178.00 $496.00
1/17/11 Quad West Pham AST 53 $1,166.00 $530.00
1/28/11 Quad East Gault SFWK 43 $1,161.00 $623.50
1/17/11 Sunshine MidWest Smith YTR 42 $1,134.00 $609.00
1/7/11 Sunset MidWest Franks HHH 59 $1,121.00 $472.00
1/20/11 Sunshine West Pham WT 53 $1,113.00 $490.25
1/29/11 Bellen West Sioux YTR 58 $1,102.00 $464.00
1/28/11 Carlota East Chin AST 50 $1,100.00 $500.00
1/6/11 Sunshine South Franks MNGD 46 $1,058.00 $506.00
1/10/11 Sunset East Franks PSA 54 $1,026.00 $432.00
1/28/11 Sunshine South Sioux MBG 47 $987.00 $434.75
1/23/11 Sunshine South Smith FRED 51 $969.00 $408.00
1/30/11 Sunshine South Chin T 49 $931.00 $392.00
1/26/11 Sunset West Gault DFR 49 $931.00 $392.00
1/17/11 Carlota South Sioux DFGH 44 $924.00 $407.00
1/9/11 Bellen East Sioux PCC 39 $897.00 $429.00
1/13/11 Bellen East Pham EPP 40 $880.00 $400.00
1/9/11 Carlota East Franks WSD 38 $874.00 $418.00
1/2/11 Quad West Pham AST 30 $810.00 $435.00
1/9/11 Sunshine East Smith PCC 42 $798.00 $336.00
1/22/11 Quad South Franks FM 29 $783.00 $420.50
-
1/14/11 Carlota East Franks JAQ 34 $782.00 $374.00
1/19/11 Bellen South Sioux T 35 $770.00 $350.00
1/22/11 Bellen West Sioux YTR 35 $770.00 $350.00
1/6/11 Sunshine South Smith QT 40 $760.00 $320.00
1/28/11 Sunset East Smith ZAT 36 $756.00 $333.00
1/3/11 Sunshine East Pham FM 38 $722.00 $304.00
1/16/11 Carlota South Smith QT 31 $713.00 $341.00
1/30/11 Quad South Sioux TTT 25 $675.00 $362.50
1/22/11 Carlota South Smith KBTB 29 $667.00 $319.00
1/13/11 Sunshine MidWest Pham PSA 33 $627.00 $264.00
1/4/11 Sunset MidWest Sioux BBT 29 $609.00 $268.25
1/23/11 Quad East Pham WT 22 $594.00 $319.00
1/7/11 Bellen West Smith T 27 $594.00 $270.00
1/9/11 Bellen South Chin WSD 26 $572.00 $260.00
1/10/11 Sunshine South Chin TRU 30 $570.00 $240.00
1/10/11 Sunset East Gault TRU 27 $567.00 $249.75
1/28/11 Bellen South Sioux QT 25 $550.00 $250.00
1/2/11 Bellen South Gault KBTB 24 $528.00 $240.00
1/3/11 Sunset South Pham WSD 23 $483.00 $212.75
1/26/11 Bellen MidWest Gault PSA 21 $462.00 $210.00
1/7/11 Sunset MidWest Sioux PCC 22 $462.00 $203.50
1/3/11 Carlota MidWest Chin FM 20 $460.00 $220.00
1/10/11 Quad East Smith DFR 17 $459.00 $246.50
1/18/11 Quad MidWest Smith PLOT 17 $459.00 $246.50
1/18/11 Sunshine East Franks AA 24 $456.00 $192.00
1/18/11 Bellen East Franks DFGH 20 $440.00 $200.00
1/21/11 Sunshine MidWest Pham DFR 23 $437.00 $184.00
1/30/11 Sunshine South Sioux TTT 23 $437.00 $184.00
1/1/11 Quad East Sioux AA 16 $432.00 $232.00
1/8/11 Quad West Chin HII 16 $432.00 $232.00
1/2/11 Bellen West Pham SFWK 19 $418.00 $190.00
1/6/11 Carlota West Sioux KPSA 18 $414.00 $198.00
1/25/11 Sunshine MidWest Franks JAQ 21 $399.00 $168.00
1/12/11 Sunset MidWest Gault ITW 19 $399.00 $175.75
1/11/11 Quad East Franks ITW 14 $378.00 $203.00
1/26/11 Bellen East Chin KPSA 17 $374.00 $170.00
1/10/11 Sunset East Smith MBG 17 $357.00 $157.25
1/17/11 Bellen MidWest Smith PCC 16 $352.00 $160.00
1/28/11 Carlota West Smith LOP 15 $345.00 $165.00
1/9/11 Bellen South Sioux QT 15 $330.00 $150.00
1/24/11 Carlota MidWest Franks BBT 13 $299.00 $143.00
1/7/11 Carlota MidWest Franks HHH 12 $276.00 $132.00
1/21/11 Sunset South Pham HHH 13 $273.00 $120.25
1/29/11 Quad MidWest Gault PLOT 10 $270.00 $145.00
1/17/11 Quad West Chin PCC 10 $270.00 $145.00
1/18/11 Sunset East Gault MNGD 12 $252.00 $111.00
1/21/11 Bellen South Smith TRU 11 $242.00 $110.00
-
1/27/11 Carlota West Gault QT 10 $230.00 $110.00
1/5/11 Sunshine West Franks ET 12 $228.00 $96.00
1/20/11 Bellen East Gault PSA 10 $220.00 $100.00
1/15/11 Sunshine MidWest Chin YTR 11 $209.00 $88.00
1/23/11 Bellen East Gault DFGH 9 $198.00 $90.00
1/10/11 Bellen MidWest Gault FM 7 $154.00 $70.00
1/12/11 Bellen South Chin WT 7 $154.00 $70.00
1/10/11 Sunshine MidWest Smith TTT 8 $152.00 $64.00
1/18/11 Sunshine West Sioux AST 8 $152.00 $64.00
1/22/11 Bellen West Smith WT 6 $132.00 $60.00
1/3/11 Sunshine South Sioux PCC 6 $114.00 $48.00
-
SalesRep/Region East MidWest South West
Chin $4,397 $3,494 $2,227 $2,004
Franks $6,818 $2,095 $3,029 $1,608
Gault $3,721 $1,285 $2,040 $4,374
Pham $4,943 $3,198 $1,953 $9,788
Sioux $1,329 $2,303 $4,787 $4,166
Smith $3,693 $3,313 $5,766 $2,826
-
Sum of Sales Region
SalesRep East MidWest South West Grand Total
Chin $4,397.00 $3,494.00 $2,227.00 $2,004.00 $12,122.00
Franks $6,818.00 $2,095.00 $3,029.00 $1,608.00 $13,550.00
Gault $3,721.00 $1,285.00 $2,040.00 $4,374.00 $11,420.00
Pham $4,943.00 $3,198.00 $1,953.00 $9,788.00 $19,882.00
Sioux $1,329.00 $2,303.00 $4,787.00 $4,166.00 $12,585.00
Smith $3,693.00 $3,313.00 $5,766.00 $2,826.00 $15,598.00
Grand Total $24,901.00 $15,688.00 $19,802.00 $24,766.00 $85,157.00
-
The question is: How do you rate your instructor?
Then, let's find out how ratings change depending on
how long they have been tenured!
Class Rating Tenured
OK 10 > 20 Years
Excellent 5 > 10 Years Tenured/Class Rating Excellent Good OK
Excellent 5 > 10 Years 1 > 5 Years 7 5 7
OK 1 > 5 Years 5 > 10 Years 7 8 1
Good 5 > 10 Years 10 > 20 Years 5 2 3
Good 5 > 10 Years
Good 5 > 10 Years
Excellent 5 > 10 Years
Excellent 10 > 20 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
Good 1 > 5 Years
OK 1 > 5 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
Good 1 > 5 Years
Good 5 > 10 Years
Good 5 > 10 Years
Good 5 > 10 Years
Excellent 10 > 20 Years
Good 10 > 20 Years
OK 5 > 10 Years
Good 5 > 10 Years
OK 1 > 5 Years
Excellent 1 > 5 Years
OK 1 > 5 Years
OK 1 > 5 Years
Excellent 5 > 10 Years
OK 1 > 5 Years
Excellent 10 > 20 Years
Good 10 > 20 Years
Excellent 1 > 5 Years
OK 10 > 20 Years
Good 1 > 5 Years
Excellent 1 > 5 Years
OK 1 > 5 Years
Good 5 > 10 Years
OK 10 > 20 Years
Excellent 5 > 10 Years
Excellent 10 > 20 Years
Excellent 1 > 5 Years
Excellent 5 > 10 Years
Excellent 1 > 5 Years
-
Excellent 10 > 20 Years
Excellent 5 > 10 Years
-
Count of Tenured Class Rating
Tenured Excellent Good OK Grand Total
1 > 5 Years 7 5 7 19
10 > 20 Years 5 2 3 10
5 > 10 Years 7 8 1 16
Grand Total 19 15 11 45