last data update: 2011/10/18, 07:24
Website loading time
during the test: 1.52 s
cable connection (average): 1.74 s
DSL connection (average): 1.95 s
modem (average): 13.37 s
HTTP headers
HTTP/1.1 301 Moved Permanently
Date: Tue, 18 Oct 2011 14:24:41 GMT
Server: Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
X-Pingback: http://www.pivot-table.com/xmlrpc.php
Location: http://www.pivot-table.com/
Content-Length: 0
Connection: close
Content-Type: text/html; charset=UTF-8
HTTP/1.1 200 OK
Date: Tue, 18 Oct 2011 14:24:42 GMT
Server: Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
X-Pingback: http://www.pivot-table.com/xmlrpc.php
Set-Cookie: PHPSESSID=cf25156baa2d090b583dc33e4fd56c3d; path=/
Connection: close
Content-Type: text/html; charset=UTF-8
Information about DNS servers
ebw-muenchen.de | TXT | kasserver.com | Array | IN | 7200 |
ebw-muenchen.de | TXT | v=spf1 ip4:85.13.0.1/16 -all | Array | IN | 7200 |
ebw-muenchen.de | MX | 10 | mail.ebw-muenchen.de | IN | 7200 |
ebw-muenchen.de | A | 85.13.157.108 | IN | 7200 | |
ebw-muenchen.de | SOA | ns5.kasserver.com | root.kasserver.com | 2011013189 | 28800 7200 1209600 7200 IN 7200 |
ebw-muenchen.de | NS | ns5.kasserver.com | IN | 7200 | |
ebw-muenchen.de | NS | ns6.kasserver.com | IN | 7200 | |
ifs.hsr.ch | MX | 10 | hsrmx2.hsr.ch | IN | 3600 |
ifs.hsr.ch | MX | 10 | hsrmx1.hsr.ch | IN | 3600 |
ifs.hsr.ch | NS | scsnms.switch.ch | IN | 3600 | |
ifs.hsr.ch | NS | ns1.hsr.ch | IN | 3600 | |
ifs.hsr.ch | NS | ns2.hsr.ch | IN | 3600 | |
ifs.hsr.ch | SOA | ns1.hsr.ch | netzwerk.hsr.ch | 2011081720 | 3600 1800 3600000 10800 IN 3600 |
ifs.hsr.ch | A | 152.96.37.60 | IN | 3600 | |
lrs.se | A | 79.138.93.22 | IN | 3600 | |
lrs.se | MX | 10 | spamfighter.infra.se | IN | 3600 |
lrs.se | SOA | ns1.infra.se | hostmaster.infra.se | 2010061201 | 14400 3600 604800 3600 IN 3600 |
lrs.se | IN | 7200 | |||
lrs.se | IN | 7200 | |||
lrs.se | NS | ns3.infra.se | IN | 3600 | |
lrs.se | NS | ns1.infra.se | IN | 3600 | |
lrs.se | NS | ns2.infra.se | IN | 3600 | |
nationalcircusschool.ca | A | 67.205.111.206 | IN | 900 | |
nationalcircusschool.ca | SOA | ns2.cidc.net | mcossette.enc.qc.ca | 1242745616 | 10800 3600 604800 900 IN 900 |
nationalcircusschool.ca | NS | ns2.cidc.net | IN | 900 | |
nationalcircusschool.ca | NS | ns.cidc.net | IN | 900 | |
tianqi321.com | SOA | ns1.dnsv2.com | level3dnsadmin.dnspod.com | 1318931414 | 3600 180 1209600 180 IN 600 |
tianqi321.com | NS | ns2.dnsv2.com | IN | 43200 | |
tianqi321.com | NS | ns1.dnsv2.com | IN | 43200 | |
pivot-table.com | A | 74.53.86.162 | IN | 14400 | |
pivot-table.com | SOA | ns1039.hostgator.com | root.gator520.hostgator.com | 2008082201 | 86400 7200 3600000 86400 IN 43200 |
pivot-table.com | MX | 0 | pivot-table.com | IN | 14400 |
pivot-table.com | TXT | v=spf1 a mx include:websitewelcome.com ~all | Array | IN | 14400 |
pivot-table.com | NS | ns1039.hostgator.com | IN | 43200 | |
pivot-table.com | NS | ns1040.hostgator.com | IN | 43200 |
Received from the first DNS server
Request to the server "pivot-table.com"
Received 33 bytes from address 85.13.128.3#53 in 126 ms
Request to the server "pivot-table.com"
You used the following DNS server:
DNS Name: ns5.kasserver.com
DNS Server Address: 85.13.128.3#53
DNS server aliases:
Host pivot-table.com not found: 5(REFUSED)
Received 33 bytes from address 85.13.128.3#53 in 440 ms
Received from the second DNS server
Request to the server "pivot-table.com"
Received 33 bytes from address 85.13.159.101#53 in 523 ms
Request to the server "pivot-table.com"
You used the following DNS server:
DNS Name: ns6.kasserver.com
DNS Server Address: 85.13.159.101#53
DNS server aliases:
Host pivot-table.com not found: 5(REFUSED)
Received 33 bytes from address 85.13.159.101#53 in 97 ms
Subdomains (the first 50)
Typos (misspells)
oivot-table.com livot-table.com -ivot-table.com 0ivot-table.com puvot-table.com pjvot-table.com pkvot-table.com povot-table.com p9vot-table.com p8vot-table.com picot-table.com pibot-table.com pigot-table.com pifot-table.com pivit-table.com pivkt-table.com pivlt-table.com pivpt-table.com piv0t-table.com piv9t-table.com pivor-table.com pivof-table.com pivog-table.com pivoy-table.com pivo6-table.com pivo5-table.com pivot0table.com pivotptable.com | pivot-rable.com pivot-fable.com pivot-gable.com pivot-yable.com pivot-6able.com pivot-5able.com pivot-tzble.com pivot-tsble.com pivot-twble.com pivot-tqble.com pivot-tavle.com pivot-tanle.com pivot-tahle.com pivot-tagle.com pivot-tabke.com pivot-tabpe.com pivot-taboe.com pivot-tablw.com pivot-tabls.com pivot-tabld.com pivot-tablr.com pivot-tabl4.com pivot-tabl3.com ivot-table.com pvot-table.com piot-table.com pivt-table.com pivo-table.com | pivottable.com pivot-able.com pivot-tble.com pivot-tale.com pivot-tabe.com pivot-tabl.com ipvot-table.com pviot-table.com piovt-table.com pivto-table.com pivo-ttable.com pivott-able.com pivot-atble.com pivot-tbale.com pivot-talbe.com pivot-tabel.com ppivot-table.com piivot-table.com pivvot-table.com pivoot-table.com pivott-table.com pivot--table.com pivot-ttable.com pivot-taable.com pivot-tabble.com pivot-tablle.com pivot-tablee.com |
Location
IP: 74.53.86.162
continent: NA, country: United States (USA), city: Houston
Website value
rank in the traffic statistics:
There is not enough data to estimate website value.
Basic information
website build using CSS
code weight: 82.98 KB
text per all code ratio: 29 %
title: Excel Pivot Tables
description: Tips and tutorials for Excel pivot tables
keywords: Excel Pivot Tables, Pivot Table, PivotTable, PivotTables, Pivot Chart
encoding: UTF-8
language: en-US
Website code analysis
one word phrases repeated minimum three times
two word phrases repeated minimum three times
three word phrases repeated minimum three times
B tags
U tags
I tags
images
file name | alternative text |
---|---|
f2bdc06bda96968.jpg | Beginning Pivot Tables in Excel 2007 |
ani_140x200_traf01.gif | Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more. |
cmd.php?Imp=4244691 | |
info_dash_d04.gif | Learn how to create Excel dashboards. |
cmd.asp?Imp=1197042 | SpreadsheetDay82 |
SpreadsheetDay82.png | studentbudget01 |
studentbudget01.png | studentbudget02 |
studentbudget02.png | studentbudget03 |
studentbudget03.png | eventcoderefresh |
eventcoderefresh.png | eventcoderefresh02 |
eventcoderefresh02.png | pivotcancelmessage |
pivotcancelmessage.png | GrandTotalRemove01 |
GrandTotalRemove01.png | GrandTotalRemove02 |
GrandTotalRemove02.png | pivot source data monthly |
normalizedata011.jpg | pivot source data bi-weekly |
PivotMonthly01.png | multiple consolidation ranges |
PivotMonthly02.png | pivot table grand totals |
PivotMonthly03.png | pivot table filtered |
PivotMonthly04.png | pivot table % of column |
PivotMonthly05.png | pivot table grouped dates |
PivotMonthly07.png | pivot table vertical |
PivotMonthly08.png | pivot table custom calculations |
PivotMonthly10.png | pivot table difference from |
PivotMonthly09.png | pivot chart finance data |
PivotMonthly11.png | ExcelPivotTable_RageComic |
ExcelPivotTable_RageComic.png | normalizedata01 |
normalizedata01.jpg | normalizedata02a |
normalizedata02a.png | normalizedata02 |
normalizedata02.png | normalizedata03 |
normalizedata03.png | normalizedata04 |
normalizedata04.png | normalizedata05 |
normalizedata05.png | twitter_newbird_boxed_blueonwhite |
twitter_newbird_boxed_blueonwhite.png | :-) |
icon_smile.gif | pivottablesummaryfunctions02 |
pivottablesummaryfunctions02.png | PivotFunctionChange02 |
PivotFunctionChange02.png | showdetails12 |
showdetails12.png | showdetails13 |
showdetails13.png | showdetails07 |
showdetails07.png | showdetails08 |
showdetails08.png | showdetails10 |
showdetails10.png | showdetails09 |
showdetails09.png | showdetails11 |
showdetails11.png | Related Posts Plugin for WordPress, Blogger... |
pixel.png | |
feed-icon16x16.png | |
twitter.png | |
info_dash_a06.jpg | |
cmd.php?Imp=2511399 | |
PivotVideoAd.png | |
info_dash_a07.gif | |
cmd.asp?Imp=2511398 |
headers
H1
H2
Student Budget With Pivot Tables: Spreadsheet Day 2011
Refresh Excel Pivot Table Automatically
Check for Shared Pivot Cache
Quickly Remove Pivot Table Grand Totals
Excel Pivot Table for Financial Data
Friday Fun: Pivot Table Comic
Fix Pivot Table Source Data For Better Results
Excel Pivot Table Tweets
Quickly Change Pivot Table Data Functions
Pivot Table Drilldown Formatting
H3
Student Budget With Pivot Tables: Spreadsheet Day 2011
Refresh Excel Pivot Table Automatically
Check for Shared Pivot Cache
Quickly Remove Pivot Table Grand Totals
Excel Pivot Table for Financial Data
Friday Fun: Pivot Table Comic
Fix Pivot Table Source Data For Better Results
Excel Pivot Table Tweets
Quickly Change Pivot Table Data Functions
Pivot Table Drilldown Formatting
H4
H5
To change the default Table Style:
To change the Normal style:
H6
internal links
address | anchor text |
---|---|
http://www.pivot-table.com/ | Home |
http://www.pivot-table.com/contact-us | Contact us |
http://www.pivot-table.com/about | About |
http://www.pivot-table.com/policies | Policies |
http://www.pivot-table.com/resources | Resources |
http://www.pivot-table.com/videos | Videos |
http://www.pivot-table.com/beginning-pivot-tables-in-excel-2007 | My Books |
http://www.pivot-table.com/ | |
http://www.pivot-table.com/comments/feed | Comments |
http://www.pivot-table.com/feed | Posts |
http://www.pivot-table.com/excel-pivot-tables/student-budget-with-pivot-tables-spreadsheet-day-2011 | Student Budget With Pivot Tables: Spreadsheet Day 2011 |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/excel-pivot-tables/student-budget-with-pivot-tables-spreadsheet-day-2011#comments | One comment |
http://www.pivot-table.com/excel-pivot-tables/refresh-excel-pivot-table-automatically | Refresh Excel Pivot Table Automatically |
http://www.pivot-table.com/pivot-table/refreshing-when-a-file-opens | update when the Excel file opens |
http://www.pivot-table.com/excel-pivot-tables/automatically-include-new-data-in-a-pivot-table | Automatically Include New Data in a Pivot Table |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/category/pivot-table-programming | pivot table programming |
http://www.pivot-table.com/excel-pivot-tables/refresh-excel-pivot-table-automatically#comments | One comment |
http://www.pivot-table.com/excel-pivot-tables/check-for-shared-pivot-cache | Check for Shared Pivot Cache |
http://www.pivot-table.com/excel-pivot-tables/pivot-table-calculated-field-removed-with-excel-vba | removing a calculated field from a pivot table |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/category/excel-vba | Excel VBA |
http://www.pivot-table.com/excel-pivot-tables/check-for-shared-pivot-cache#comments | One comment |
http://www.pivot-table.com/pivot-table-totals/quickly-remove-pivot-table-grand-totals | Quickly Remove Pivot Table Grand Totals |
http://www.pivot-table.com/category/pivot-table-totals | Pivot Table Totals |
http://www.pivot-table.com/pivot-table-totals/quickly-remove-pivot-table-grand-totals#comments | Leave a comment |
http://www.pivot-table.com/excel-pivot-tables/excel-pivot-table-for-financial-data | Excel Pivot Table for Financial Data |
http://www.pivot-table.com/excel-pivot-tables/fix-pivot-table-source-data-for-better-results | changing monthly data into a better layout |
http://www.pivot-table.com/excel-pivot-tables/fix-pivot-table-source-data-for-better-results | normalization workaround |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/excel-pivot-tables/excel-pivot-table-for-financial-data#comments | Leave a comment |
http://www.pivot-table.com/excel-pivot-tables/friday-fun-pivot-table-comic | Friday Fun: Pivot Table Comic |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/excel-pivot-tables/friday-fun-pivot-table-comic#comments | Leave a comment |
http://www.pivot-table.com/excel-pivot-tables/fix-pivot-table-source-data-for-better-results | Fix Pivot Table Source Data For Better Results |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/category/source-data | Source Data |
http://www.pivot-table.com/excel-pivot-tables/fix-pivot-table-source-data-for-better-results#comments | 2 comments |
http://www.pivot-table.com/pivot-table/excel-pivot-table-tweets | Excel Pivot Table Tweets |
http://www.pivot-table.com/category/pivot-table | Pivot Table |
http://www.pivot-table.com/pivot-table/excel-pivot-table-tweets#comments | One comment |
http://www.pivot-table.com/excel-pivot-tables/quickly-change-pivot-table-data-functions | Quickly Change Pivot Table Data Functions |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/category/excel-vba | Excel VBA |
http://www.pivot-table.com/excel-pivot-tables/quickly-change-pivot-table-data-functions#comments | 2 comments |
http://www.pivot-table.com/excel-pivot-tables/pivot-table-drilldown-formatting | Pivot Table Drilldown Formatting |
http://www.pivot-table.com/category/excel-pivot-tables | Excel Pivot Tables |
http://www.pivot-table.com/category/excel-table | Excel Table |
http://www.pivot-table.com/excel-pivot-tables/pivot-table-drilldown-formatting#comments | 3 comments |
http://www.pivot-table.com/page/2 | Older Entries |
http://www.pivot-table.com/ | Excel Pivot Tables |
external links
address | anchor text |
---|---|
http://feedburner.google.com/fb/a/mailverify?uri=ExcelPivotTables&loc=en_US | By Email |
http://www.amazon.com/gp/product/1590598903?ie=UTF8&tag=contextures-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=1590598903 | Beginning Pivot Tables in Excel 2007 |
http://www.exceluser.com/cmd.php?Clk=4244691 | Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more. |
http://www.exceluser.com/cmd.asp?Clk=1197042 | Learn how to create Excel dashboards. |
http://spreadsheet-day.com/blog/ | Spreadsheet Day |
http://simplylearningexcel.com/blog/2011/10/16/free-workbook-to-record-actuals-and-budget-and-compare-actuals-vs-budget/ | Simply Learning Excel website |
http://www.contextures.com/ExcelTemplates/Actual_Budget_Workbook_Basic.zip | download the Student Budget Spreadsheet |
http://simplylearningexcel.com/blog/2011/10/16/free-workbook-to-record-actuals-and-budget-and-compare-actuals-vs-budget/ | Simply Learning Excel blog |
http://www.contextures.com/CreatePivotTable.html | Create a Pivot Table in Excel 2007 |
http://www.contextures.com/xlPivot01.html | Excel Pivot Table -- Dynamic Data Source |
http://www.contextures.com/xlPivot08.html | multiple consolidation ranges |
http://www.contextures.com/xlPivot10.html | % of Column |
http://www.contextures.com/xlPivot07.html | group those dates |
http://www.contextures.com/ExcelTemplates/PivotTableFinanceData.zip | Financial Data Pivot Table sample file |
http://ragecomics.memebase.com/ | Rage Builder |
http://www.contextures.com/CreatePivotTable.html | pivot table |
http://www.contextures.com/xlExcelTable01.html#Prep | data layout guidelines |
http://www.contextures.com/ExcelTemplates/pivotdatanormalize.zip | Normalize Data for Excel Pivot Table sample workbook |
http://youtu.be/xmqTN0X-AgY | Normalize Data for Excel Pivot Table |
http://twitter.com/#!/ddalgleish | twitter_newbird_boxed_blueonwhite |
http://exceltheatre.com/blog/ | Excel tweets |
http://www.contextures.com/excel-pivot-table-summary-functions.html | pivot table summary function |
http://blog.contextures.com/archives/2011/06/22/select-pivot-table-function-from-worksheet-drop-down/ | Select Pivot Table Function From Worksheet Drop Down |
http://www.contextures.com/ExcelTemplates/PivotFunctionSelect.zip | Pivot Table Summary Function Change workbook |
http://www.linkwithin.com/ | Related Posts Plugin for WordPress, Blogger... |
http://feeds.feedburner.com/ExcelPivotTables | |
http://feeds.feedburner.com/ExcelPivotTables | Subscribe in a reader |
http://twitter.com/ddalgleish | |
http://twitter.com/ddalgleish | I'm on Twitter |
http://www.exceluser.com/cmd.php?Clk=2511399 | Learn how to create Excel dashboards. |
http://www.contextures.com/ExcelVideoTutorials.html | |
http://www.exceluser.com/cmd.asp?Clk=2511398 | Learn how to create Excel dashboards. |
http://blog.contextures.com | Contextures Blog |
http://www.contextures.com | Contextures Website |
http://www.debradalgleish.com/blog/ | Debra’s Blog |
http://exceltheatre.com/blog/ | Excel Theatre Blog |
http://www.wordpress.org/ | WordPress |
http://wordpress.bytesforall.com/ | Atahualpa Theme |
http://www.bytesforall.com/ | BytesForAll |