2.36 score from hupso.pl for:
excelguru.ca



HTML Content


Titleexcelguru help site - welcome

Length: 29, Words: 5
Description excel knowledgebase, excel help articles

Length: 40, Words: 5
Keywords pusty
Robots
Charset UTF-8
Og Meta - Title pusty
Og Meta - Description pusty
Og Meta - Site name pusty
Tytuł powinien zawierać pomiędzy 10 a 70 znaków (ze spacjami), a mniej niż 12 słów w długości.
Meta opis powinien zawierać pomiędzy 50 a 160 znaków (łącznie ze spacjami), a mniej niż 24 słów w długości.
Kodowanie znaków powinny być określone , UTF-8 jest chyba najlepszy zestaw znaków, aby przejść z powodu UTF-8 jest bardziej międzynarodowy kodowaniem.
Otwarte obiekty wykresu powinny być obecne w stronie internetowej (więcej informacji na temat protokołu OpenGraph: http://ogp.me/)

SEO Content

Words/Characters 1248
Text/HTML 23.63 %
Headings H1 1
H2 1
H3 3
H4 13
H5 0
H6 0
H1
welcome to the excelguru knowledge base
H2
sign up for the monthly(ish) excelguru newsletter
H3
knowledge base articles by category
recent knowledge base articles
recent forum posts
H4 making pivot table hyperlinks clickable
categories:
temperature forecast chart
categories:
vlookup for pictures
categories:
understanding how conditional formatting rules are applied
categories:
how to convert a 25 digit serial no into xxxxx-xxxxx-xxxxx-xxxxx-xxxxx format
convert data from code/amount set to proper record
convert data from code/amount set to proper record
how to find a character of a number within a certain date range
convert data from code/amount set to proper record
H5
H6
strong
ken puls
consent for casl
b
ken puls
consent for casl
i
em
Bolds strong 2
b 2
i 0
em 0
Zawartość strony internetowej powinno zawierać więcej niż 250 słów, z stopa tekst / kod jest wyższy niż 20%.
Pozycji używać znaczników (h1, h2, h3, ...), aby określić temat sekcji lub ustępów na stronie, ale zwykle, użyj mniej niż 6 dla każdego tagu pozycje zachować swoją stronę zwięzły.
Styl używać silnych i kursywy znaczniki podkreślić swoje słowa kluczowe swojej stronie, ale nie nadużywać (mniej niż 16 silnych tagi i 16 znaczników kursywy)

Statystyki strony

twitter:title pusty
twitter:description pusty
google+ itemprop=name pusty
Pliki zewnętrzne 17
Pliki CSS 4
Pliki javascript 13
Plik należy zmniejszyć całkowite odwołanie plików (CSS + JavaScript) do 7-8 maksymalnie.

Linki wewnętrzne i zewnętrzne

Linki 146
Linki wewnętrzne 61
Linki zewnętrzne 85
Linki bez atrybutu Title 141
Linki z atrybutem NOFOLLOW 0
Linki - Użyj atrybutu tytuł dla każdego łącza. Nofollow link jest link, który nie pozwala wyszukiwarkom boty zrealizują są odnośniki no follow. Należy zwracać uwagę na ich użytkowania

Linki wewnętrzne

- forum.php?s=f670d3230d9786283f0c4b1bc730d62c
register register.php?s=f670d3230d9786283f0c4b1bc730d62c
help faq.php?s=f670d3230d9786283f0c4b1bc730d62c
today's posts search.php?s=f670d3230d9786283f0c4b1bc730d62c&do=getdaily&contenttype=vbforum_post
faq faq.php?s=f670d3230d9786283f0c4b1bc730d62c
calendar calendar.php?s=f670d3230d9786283f0c4b1bc730d62c
community javascript://
member list memberlist.php?s=f670d3230d9786283f0c4b1bc730d62c
forum actions javascript://
mark forums read forumdisplay.php?s=f670d3230d9786283f0c4b1bc730d62c&do=markread&markreadhash=guest
quick links javascript://
view site leaders showgroups.php?s=f670d3230d9786283f0c4b1bc730d62c
forum forum.php
forum tools javascript://
what's new? search.php?do=getnew&contenttype=vbforum_post
today's posts search.php?do=getdaily&contenttype=vbforum_post
courses javascript://
resources javascript://
faq javascript://
faq index /forums/faq.php?faq=vb3_board_faq#faq_vb3_board_usage
general forum usage /forums/faq.php?faq=vb3_board_usage
reading and posting messages /forums/faq.php?faq=vb3_reading_posting
supported bb code tags /forums/misc.php?do=bbcode
multi forum posting policy /content.php?184
about javascript://
advanced search search.php?s=f670d3230d9786283f0c4b1bc730d62c
- index.php?s=f670d3230d9786283f0c4b1bc730d62c
home content.php?s=f670d3230d9786283f0c4b1bc730d62c
faq faq.php?s=f670d3230d9786283f0c4b1bc730d62c
register here register.php?s=f670d3230d9786283f0c4b1bc730d62c
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
view profile member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
view forum posts search.php?s=f670d3230d9786283f0c4b1bc730d62c&do=finduser&userid=2&contenttype=vbforum_post&showposts=1
view blog entries blog.php?s=f670d3230d9786283f0c4b1bc730d62c&u=2
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
- member.php?3469-nos&s=f670d3230d9786283f0c4b1bc730d62c
how to convert a 25 digit serial no into xxxxx-xxxxx-xxxxx-xxxxx-xxxxx format showthread.php?7081-how-to-convert-a-25-digit-serial-no-into-xxxxx-xxxxx-xxxxx-xxxxx-xxxxx-format&s=f670d3230d9786283f0c4b1bc730d62c
nos member.php?3469-nos&s=f670d3230d9786283f0c4b1bc730d62c
- showthread.php?7081-how-to-convert-a-25-digit-serial-no-into-xxxxx-xxxxx-xxxxx-xxxxx-xxxxx-format&s=c062b0a2c6fb393b62b24cf08da6a0c9&p=29037#post29037
- member.php?1271-canapone&s=f670d3230d9786283f0c4b1bc730d62c
convert data from code/amount set to proper record showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=f670d3230d9786283f0c4b1bc730d62c
canapone member.php?1271-canapone&s=f670d3230d9786283f0c4b1bc730d62c
- showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=c062b0a2c6fb393b62b24cf08da6a0c9&p=29036#post29036
- member.php?44203-rgottesman&s=f670d3230d9786283f0c4b1bc730d62c
convert data from code/amount set to proper record showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=f670d3230d9786283f0c4b1bc730d62c
rgottesman member.php?44203-rgottesman&s=f670d3230d9786283f0c4b1bc730d62c
- showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=c062b0a2c6fb393b62b24cf08da6a0c9&p=29034#post29034
- member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
how to find a character of a number within a certain date range showthread.php?7083-how-to-find-a-character-of-a-number-within-a-certain-date-range&s=f670d3230d9786283f0c4b1bc730d62c
ken puls member.php?2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
- showthread.php?7083-how-to-find-a-character-of-a-number-within-a-certain-date-range&s=c062b0a2c6fb393b62b24cf08da6a0c9&p=29033#post29033
- member.php?1271-canapone&s=f670d3230d9786283f0c4b1bc730d62c
convert data from code/amount set to proper record showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=f670d3230d9786283f0c4b1bc730d62c
canapone member.php?1271-canapone&s=f670d3230d9786283f0c4b1bc730d62c
- showthread.php?7089-convert-data-from-code-amount-set-to-proper-record&s=c062b0a2c6fb393b62b24cf08da6a0c9&p=29032#post29032
contact us sendmessage.php?s=f670d3230d9786283f0c4b1bc730d62c
archive archive/index.php?s=f670d3230d9786283f0c4b1bc730d62c
top #top

Linki zewnętrzne

knowledge base http://www.excelguru.ca
blog http://www.excelguru.ca/blog
excelguru e-learning catalog http://www.excelguru.ca/content.php?259
online training courses http://www.excelguru.ca/content.php?287-online-excel-training-courses
the magic of pivottables (2003) http://www.excelguru.ca/content.php?261
the magic of pivottables (2007) http://www.excelguru.ca/content.php?260
the magic of pivottables (2010) http://www.excelguru.ca/content.php?255
instructor led training http://www.excelguru.ca/forums/content.php?134
sell excelguru courses on your site http://www.excelguru.ca/content.php?258
excelguru e-learning catalog http://www.excelguru.ca/content.php?259
online training courses http://www.excelguru.ca/content.php?287-online-excel-training-courses
books http://www.excelguru.ca/forums/content.php?213-books
charting & dashboarding resources http://www.excelguru.ca/forums/content.php?220-charting-dashboarding-resources
useful add-ins and tools http://www.excelguru.ca/forums/content.php?215-useful-excel-add-ins
other forums http://www.excelguru.ca/forums/content.php?208
excel blogs http://www.excelguru.ca/forums/content.php?209-excel-blogs
useful links http://www.excelguru.ca/forums/content.php?214-useful-links
excel training calendar http://www.excelguru.ca/forums/calendar.php
consulting http://www.excelguru.ca/forums/content.php?201
sales affiliate program http://www.excelguru.ca/content.php?258
about me http://www.excelguru.ca/forums/content.php?125
awards http://www.excelguru.ca/forums/content.php?206-awards
testimonials http://www.excelguru.ca/forums/content.php?205-testimonials
contact me http://www.excelguru.ca/forums/sendmessage.php
- http://www.excelguru.ca/content.php?259-e-learning-products
access - ado (4) http://www.excelguru.ca/list.php?category/59-access-ado&s=f670d3230d9786283f0c4b1bc730d62c
access - sql (4) http://www.excelguru.ca/list.php?category/60-access-sql&s=f670d3230d9786283f0c4b1bc730d62c
access - vba programming (10) http://www.excelguru.ca/list.php?category/68-access-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
downloads - games (1) http://www.excelguru.ca/list.php?category/62-downloads-games&s=f670d3230d9786283f0c4b1bc730d62c
downloads - learning aids (11) http://www.excelguru.ca/list.php?category/63-downloads-learning-aids&s=f670d3230d9786283f0c4b1bc730d62c
downloads - utilities (6) http://www.excelguru.ca/list.php?category/64-downloads-utilities&s=f670d3230d9786283f0c4b1bc730d62c
excel - ado (4) http://www.excelguru.ca/list.php?category/49-excel-ado&s=f670d3230d9786283f0c4b1bc730d62c
excel - charts and data visualization (1) http://www.excelguru.ca/list.php?category/94-excel-charts-and-data-visualization&s=f670d3230d9786283f0c4b1bc730d62c
excel - formulas (8) http://www.excelguru.ca/list.php?category/51-excel-formulas&s=f670d3230d9786283f0c4b1bc730d62c
excel - general tips (36) http://www.excelguru.ca/list.php?category/52-excel-general-tips&s=f670d3230d9786283f0c4b1bc730d62c
excel - interactive pages (9) http://www.excelguru.ca/list.php?category/57-excel-interactive-pages&s=f670d3230d9786283f0c4b1bc730d62c
excel - pivottables (12) http://www.excelguru.ca/list.php?category/91-excel-pivottables&s=f670d3230d9786283f0c4b1bc730d62c
excel - powerpivot (7) http://www.excelguru.ca/list.php?category/86-excel-powerpivot&s=f670d3230d9786283f0c4b1bc730d62c
excel - sql (4) http://www.excelguru.ca/list.php?category/53-excel-sql&s=f670d3230d9786283f0c4b1bc730d62c
excel - udf (7) http://www.excelguru.ca/list.php?category/54-excel-udf&s=f670d3230d9786283f0c4b1bc730d62c
excel - user interface customization (2) http://www.excelguru.ca/list.php?category/84-excel-user-interface-customization&s=f670d3230d9786283f0c4b1bc730d62c
excel - vba programming (49) http://www.excelguru.ca/list.php?category/82-excel-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
excel - webapp (4) http://www.excelguru.ca/list.php?category/81-excel-webapp&s=f670d3230d9786283f0c4b1bc730d62c
internet explorer - vba programming (1) http://www.excelguru.ca/list.php?category/79-internet-explorer-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
novell groupwise - vba programming (2) http://www.excelguru.ca/list.php?category/76-novell-groupwise-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
other - general (1) http://www.excelguru.ca/list.php?category/93-other-general&s=f670d3230d9786283f0c4b1bc730d62c
outlook - general tips (5) http://www.excelguru.ca/list.php?category/70-outlook-general-tips&s=f670d3230d9786283f0c4b1bc730d62c
outlook - vba programming (7) http://www.excelguru.ca/list.php?category/71-outlook-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
pdf creator - vba programming (11) http://www.excelguru.ca/list.php?category/75-pdf-creator-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
powerpoint - vba programming (7) http://www.excelguru.ca/list.php?category/72-powerpoint-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
publisher - vba programming (7) http://www.excelguru.ca/list.php?category/73-publisher-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
syndicated articles (7) http://www.excelguru.ca/list.php?category/92-syndicated-articles&s=f670d3230d9786283f0c4b1bc730d62c
training products (9) http://www.excelguru.ca/list.php?category/88-training-products&s=f670d3230d9786283f0c4b1bc730d62c
word - vba programming (8) http://www.excelguru.ca/list.php?category/89-word-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
- http://www.exceluser.com/cmd.php?clk=3953440
visit homepage http://www.excelguru.ca
view articles http://www.excelguru.ca/list.php?author/2-ken-puls&s=f670d3230d9786283f0c4b1bc730d62c
free help forums http://www.excelguru.ca/forums/forum.php
making pivot table hyperlinks clickable http://www.excelguru.ca/content.php?285-making-pivot-table-hyperlinks-clickable&s=f670d3230d9786283f0c4b1bc730d62c
read more http://www.excelguru.ca/content.php?285-making-pivot-table-hyperlinks-clickable&s=f670d3230d9786283f0c4b1bc730d62c
2013-10-31, 01:58 am http://www.excelguru.ca/content.php?285-making-pivot-table-hyperlinks-clickable&s=f670d3230d9786283f0c4b1bc730d62c
excel - vba programming http://www.excelguru.ca/list.php?category/82-excel-vba-programming&s=f670d3230d9786283f0c4b1bc730d62c
excel - powerpivot http://www.excelguru.ca/list.php?category/86-excel-powerpivot&s=f670d3230d9786283f0c4b1bc730d62c
excel - pivottables http://www.excelguru.ca/list.php?category/91-excel-pivottables&s=f670d3230d9786283f0c4b1bc730d62c
temperature forecast chart http://www.excelguru.ca/content.php?281-temperature-forecast-chart&s=f670d3230d9786283f0c4b1bc730d62c
read more http://www.excelguru.ca/content.php?281-temperature-forecast-chart&s=f670d3230d9786283f0c4b1bc730d62c
2013-03-21, 05:04 am http://www.excelguru.ca/content.php?281-temperature-forecast-chart&s=f670d3230d9786283f0c4b1bc730d62c
excel - general tips http://www.excelguru.ca/list.php?category/52-excel-general-tips&s=f670d3230d9786283f0c4b1bc730d62c
excel - charts and data visualization http://www.excelguru.ca/list.php?category/94-excel-charts-and-data-visualization&s=f670d3230d9786283f0c4b1bc730d62c
vlookup for pictures http://www.excelguru.ca/content.php?279-vlookup-for-pictures&s=f670d3230d9786283f0c4b1bc730d62c
read more http://www.excelguru.ca/content.php?279-vlookup-for-pictures&s=f670d3230d9786283f0c4b1bc730d62c
2013-03-14, 05:47 am http://www.excelguru.ca/content.php?279-vlookup-for-pictures&s=f670d3230d9786283f0c4b1bc730d62c
excel - formulas http://www.excelguru.ca/list.php?category/51-excel-formulas&s=f670d3230d9786283f0c4b1bc730d62c
excel - general tips http://www.excelguru.ca/list.php?category/52-excel-general-tips&s=f670d3230d9786283f0c4b1bc730d62c
understanding how conditional formatting rules are applied http://www.excelguru.ca/content.php?278-understanding-how-conditional-formatting-rules-are-applied&s=f670d3230d9786283f0c4b1bc730d62c
read more http://www.excelguru.ca/content.php?278-understanding-how-conditional-formatting-rules-are-applied&s=f670d3230d9786283f0c4b1bc730d62c
2013-01-22, 07:30 am http://www.excelguru.ca/content.php?278-understanding-how-conditional-formatting-rules-are-applied&s=f670d3230d9786283f0c4b1bc730d62c
excel - formulas http://www.excelguru.ca/list.php?category/51-excel-formulas&s=f670d3230d9786283f0c4b1bc730d62c
excel - general tips http://www.excelguru.ca/list.php?category/52-excel-general-tips&s=f670d3230d9786283f0c4b1bc730d62c
excelguru forums http://www.excelguru.ca
vbulletin® https://www.vbulletin.com
thread / post bookmarking v1.1.0 http://www.dragonbyte-tech.com/product.php?dbtech_bookmark
vbulletin mods & addons http://www.dragonbyte-tech.com
hivelocity hosting http://www.hivelocity.net/?utm_source=iain%2bkidd&utm_medium=back%2blink&utm_term=dedicated%2bserver%2bsponsor&utm_campaign=back%2blinks%2bfrom%2biain%2bkidd
1e2.it http://www.1e2.it/

Zdjęcia

Zdjęcia 24
Zdjęcia bez atrybutu ALT 6
Zdjęcia bez atrybutu TITLE 22
Korzystanie Obraz ALT i TITLE atrybutu dla każdego obrazu.

Zdjęcia bez atrybutu TITLE

images/misc/xlg_logo.png
images/misc/navbit-home.png
images/cms/categories.png
http://www.exceluser.com/images/info/pub/rotate_pnp01.gif
http://www.exceluser.com/cmd.php?imp=3953440
images/cms/widget-forum.png
images/misc/unknown.gif
images/misc/unknown.gif
images/misc/unknown.gif
images/misc/unknown.gif
http://www.excelguru.ca/images/mvp_horizontal_fullcolor.jpg
images/cms/widget-forum.png
images/misc/unknown.gif
images/buttons/lastpost-right.png
images/misc/unknown.gif
images/buttons/lastpost-right.png
images/misc/unknown.gif
images/buttons/lastpost-right.png
images/misc/unknown.gif
images/buttons/lastpost-right.png
images/misc/unknown.gif
images/buttons/lastpost-right.png

Zdjęcia bez atrybutu ALT

http://www.excelguru.ca/images/catalog.gif
images/cms/categories.png
http://www.exceluser.com/cmd.php?imp=3953440
images/cms/widget-forum.png
images/cms/widget-forum.png
images/smilies/smile.png

Ranking:


Alexa Traffic
Daily Global Rank Trend
Daily Reach (Percent)









Majestic SEO











Text on page:

register help remember me? knowledge base today's posts faq calendar community member list forum actions mark forums read quick links view site leaders blog what's new? articles forum blogs --> forumforum toolswhat's new?today's postscoursesexcelguru e-learning catalogonline training coursesthe magic of pivottables (2003)the magic of pivottables (2007)the magic of pivottables (2010)instructor led trainingsell excelguru courses on your siteresourcesexcelguru e-learning catalogonline training coursesbookscharting & dashboarding resourcesuseful add-ins and toolsother forumsexcel blogsuseful linksexcel training calendarconsultingsales affiliate programfaqfaq indexgeneral forum usagereading and posting messagessupported bb code tagsmulti forum posting policyaboutabout meawardstestimonialscontact me advanced search home welcome to the excelguru knowledge base if this is your first visit, then welcome! be sure to check out the faq by clicking the link above. register here so that you can post in the forums or comment on the articles. knowledge base articles by category access - ado (4) access - sql (4) access - vba programming (10) downloads - games (1) downloads - learning aids (11) downloads - utilities (6) excel - ado (4) excel - charts and data visualization (1) excel - formulas (8) excel - general tips (36) excel - interactive pages (9) excel - pivottables (12) excel - powerpivot (7) excel - sql (4) excel - udf (7) excel - user interface customization (2) excel - vba programming (49) excel - webapp (4) internet explorer - vba programming (1) novell groupwise - vba programming (2) other - general (1) outlook - general tips (5) outlook - vba programming (7) pdf creator - vba programming (11) powerpoint - vba programming (7) publisher - vba programming (7) syndicated articles (7) training products (9) word - vba programming (8) welcome to the excelguru knowledge base by ken puls view profile view forum posts view blog entries visit homepage view articles published on 2011-08-26 07:22 am number of views: 3897760 welcome to the new and improved excelguru knowledgebase! my favourite definition of the word guru is "remover of darkness"; a guide. a teacher. it is in this spirit that the excelguru website was created: to help remove the mysteries of excel, help you find solutions, help you to be more proficient or accomplish certain tasks. i am a firm believers that properly set up, a computer can process numbers and data far more efficiently and accurately than any human, and that human brainpower should be devoted to solving problems, not data input. did you know that the only thing that can't be automated in excel is the input of raw data... and that even that can sometimes be done? if you perform repetitive tasks in your excel spreadsheets, you may be wasting both your time and business resources performing unnecessary work. let us show you how to save both your time and money by helping you automate your tasks today! the excelguru knowledgebase is packed with numerous articles on how to accomplish specific tasks in microsoft excel, microsoft access and other programs included in the microsoft office suite. it also includes examples on a select few non-microsoft office programs, and many general tips as well. if you notice errors in any of the articles, or have suggestions for improvements, please feel free to leave a comment on the article's page. and if you need any help modifying the articles to suit your needs, then please, post in my free help forums! sign up for the monthly(ish) excelguru newsletter * indicates required email address * first name last name how did you hear about excelguru? consent for casl i consent recent knowledge base articles making pivot table hyperlinks clickable if you?ve ever built a pivottable that contains hyperlinks, you?ll notice that clicking the hyperlinks doesn?t do anything. this can be a bit frustrating as the reason you put that field on the pivot in the first place is that it?s valuable information you want to use. when you click the hyperlink,... read more ken puls 2013-10-31, 01:58 am categories: excel - vba programming excel - powerpivot excel - pivottables temperature forecast chart some of the really cool charts that we can build in excel involve the trick of combining multiple chart types together to make them happen. in this article, we?ll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. the beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it. ... read more ken puls 2013-03-21, 05:04 am categories: excel - general tips excel - charts and data visualization vlookup for pictures something that can be very handy when you?re building a dashboard is to return a certain picture depending on a condition. we can use vlookup to look up data in a table and return the corresponding value from a different column, but unfortunately we can?t do that with pictures... or can we? this example shows how to accomplish the equivlanet of a picture vlookup, and is based on looking up a picture to display the appropriate... read more ken puls 2013-03-14, 05:47 am categories: excel - formulas excel - general tips understanding how conditional formatting rules are applied conditional formatting in excel is a powerful tool that allows you to dynamically format cells depending on the values of that or other cells? data. in excel 2007 the conditional formatting engine was re-written, opening things up to allow more than 3 conditional formats on any cell, as well as conditional formats that could overlap ranges. all in all, these were fantastic improvements that can lead to some very versatile and useful worksheets. unfortunately, the user interface to control conditional formatting is not the most intuitive. the purpose of this article is to help you understand the way excel applies rule precedence so that you can build powerful formatting rules of your own, without getting frustrated along the way. ... read more ken puls 2013-01-22, 07:30 am categories: excel - formulas excel - general tips recent forum posts how to convert a 25 digit serial no into xxxxx-xxxxx-xxxxx-xxxxx-xxxxx format don't think you can do that in the same cell without vba. i would use the worksheet_change event of the sheet, something like this: ... nos today, 08:16 pm convert data from code/amount set to proper record hi in the attachment data in a1:i1000 formulas to be copied down in m2 code: =iferror(index($a$2:$a$1000,match(aggregate(15,6,subtotal(2,offset($b$2,,,row($2:$1000)-1,columns($b:$i)))/(subtotal(2,offset($b$2,,,row($2:$1000)-1,columns($b:$i)))>=rows(a$1:a1)),1),index(subtotal(2,offset($b$2,,,row($2:$1000)-1,columns(b:i))),),0)),"") ... canapone today, 06:32 pm convert data from code/amount set to proper record 2010... rgottesman today, 06:23 pm how to find a character of a number within a certain date range hey wilkema, your post got stuck in moderation. i've released it for you here. if that happens again, just pm me and i'll look into it. ... ken puls today, 06:10 pm convert data from code/amount set to proper record hi again, thanks, 50 sets per id means a database with 150 columns. i'd need to know what version are you using, i would like... canapone today, 06:02 pm -- default style -- e-learning products -- default mobile style contact us excelguru forums archive top all times are gmt +1. the time now is 08:35 pm. powered by vbulletin® version 4.2.3 copyright © 2016 vbulletin solutions, inc. all rights reserved. thread / post bookmarking by thread / post bookmarking v1.1.0 - vbulletin mods & addons copyright © 2016 dragonbyte technologies ltd. runs best on hivelocity hosting. copyright ? 2004-current by excelguru consulting inc. gravatar by 1e2.it


Here you find all texts from your page as Google (googlebot) and others search engines seen it.

Words density analysis:

Numbers of all words: 1241

One word

Two words phrases

Three words phrases

the - 4.51% (56)
excel - 3.46% (43)
for - 3.14% (39)
you - 2.66% (33)
that - 1.93% (24)
and - 1.85% (23)
can - 1.21% (15)
per - 1.13% (14)
guru - 1.05% (13)
forum - 1.05% (13)
data - 0.97% (12)
excelguru - 0.97% (12)
article - 0.97% (12)
format - 0.89% (11)
... - 0.89% (11)
post - 0.89% (11)
vba - 0.89% (11)
all - 0.81% (10)
how - 0.81% (10)
pivot - 0.81% (10)
programming - 0.81% (10)
now - 0.81% (10)
read - 0.73% (9)
base - 0.73% (9)
your - 0.73% (9)
articles - 0.73% (9)
know - 0.73% (9)
this - 0.64% (8)
out - 0.64% (8)
general - 0.64% (8)
table - 0.64% (8)
chart - 0.64% (8)
look - 0.64% (8)
set - 0.64% (8)
led - 0.64% (8)
use - 0.64% (8)
help - 0.64% (8)
more - 0.56% (7)
knowledge - 0.56% (7)
link - 0.56% (7)
some - 0.48% (6)
any - 0.48% (6)
conditional - 0.48% (6)
pivottable - 0.48% (6)
tips - 0.48% (6)
view - 0.48% (6)
(7) - 0.48% (6)
puls - 0.48% (6)
with - 0.48% (6)
ken - 0.48% (6)
let - 0.4% (5)
time - 0.4% (5)
today, - 0.4% (5)
formatting - 0.4% (5)
thing - 0.4% (5)
not - 0.4% (5)
pivottables - 0.4% (5)
one - 0.4% (5)
code - 0.4% (5)
(4) - 0.4% (5)
picture - 0.4% (5)
forums - 0.4% (5)
links - 0.4% (5)
training - 0.4% (5)
convert - 0.32% (4)
microsoft - 0.32% (4)
new - 0.32% (4)
learning - 0.32% (4)
build - 0.32% (4)
blog - 0.32% (4)
(1) - 0.32% (4)
tasks - 0.32% (4)
faq - 0.32% (4)
posts - 0.32% (4)
low - 0.32% (4)
courses - 0.32% (4)
cell - 0.32% (4)
down - 0.32% (4)
put - 0.32% (4)
formulas - 0.32% (4)
from - 0.32% (4)
click - 0.32% (4)
categories: - 0.32% (4)
access - 0.32% (4)
need - 0.32% (4)
welcome - 0.32% (4)
proper - 0.32% (4)
other - 0.32% (4)
tool - 0.24% (3)
are - 0.24% (3)
temperature - 0.24% (3)
about - 0.24% (3)
into - 0.24% (3)
hyperlinks - 0.24% (3)
vlookup - 0.24% (3)
resources - 0.24% (3)
show - 0.24% (3)
charts - 0.24% (3)
site - 0.24% (3)
first - 0.24% (3)
record - 0.24% (3)
code/amount - 0.24% (3)
magic - 0.24% (3)
e-learning - 0.24% (3)
copyright - 0.24% (3)
what - 0.24% (3)
was - 0.24% (3)
vbulletin - 0.24% (3)
number - 0.24% (3)
rule - 0.24% (3)
certain - 0.24% (3)
useful - 0.24% (3)
than - 0.24% (3)
downloads - 0.24% (3)
accomplish - 0.24% (3)
mark - 0.24% (3)
2016 - 0.16% (2)
return - 0.16% (2)
thread - 0.16% (2)
times - 0.16% (2)
depending - 0.16% (2)
inc. - 0.16% (2)
bookmarking - 0.16% (2)
contact - 0.16% (2)
style - 0.16% (2)
default - 0.16% (2)
unfortunately - 0.16% (2)
version - 0.16% (2)
value - 0.16% (2)
lead - 0.16% (2)
we? - 0.16% (2)
cells - 0.16% (2)
were - 0.16% (2)
well - 0.16% (2)
formats - 0.16% (2)
understand - 0.16% (2)
way - 0.16% (2)
without - 0.16% (2)
allow - 0.16% (2)
2007 - 0.16% (2)
data. - 0.16% (2)
very - 0.16% (2)
again, - 0.16% (2)
would - 0.16% (2)
like - 0.16% (2)
powerful - 0.16% (2)
rules - 0.16% (2)
canapone - 0.16% (2)
range - 0.16% (2)
improvements - 0.16% (2)
example - 0.16% (2)
got - 0.16% (2)
dashboard - 0.16% (2)
register - 0.16% (2)
something - 0.16% (2)
sql - 0.16% (2)
remove - 0.16% (2)
visit - 0.16% (2)
word - 0.16% (2)
products - 0.16% (2)
outlook - 0.16% (2)
(2) - 0.16% (2)
interface - 0.16% (2)
user - 0.16% (2)
powerpivot - 0.16% (2)
(9) - 0.16% (2)
(8) - 0.16% (2)
visualization - 0.16% (2)
(11) - 0.16% (2)
ado - 0.16% (2)
find - 0.16% (2)
comment - 0.16% (2)
here - 0.16% (2)
clicking - 0.16% (2)
then - 0.16% (2)
home - 0.16% (2)
posting - 0.16% (2)
catalogonline - 0.16% (2)
blogs - 0.16% (2)
new? - 0.16% (2)
what's - 0.16% (2)
member - 0.16% (2)
calendar - 0.16% (2)
today's - 0.16% (2)
excel, - 0.16% (2)
solutions, - 0.16% (2)
pictures - 0.16% (2)
free - 0.16% (2)
it. - 0.16% (2)
but - 0.16% (2)
high - 0.16% (2)
shows - 0.16% (2)
really - 0.16% (2)
forecast - 0.16% (2)
when - 0.16% (2)
information - 0.16% (2)
ever - 0.16% (2)
recent - 0.16% (2)
consent - 0.16% (2)
name - 0.16% (2)
suit - 0.16% (2)
please - 0.16% (2)
up, - 0.16% (2)
notice - 0.16% (2)
also - 0.16% (2)
office - 0.16% (2)
programs - 0.16% (2)
knowledgebase - 0.16% (2)
automate - 0.16% (2)
both - 0.16% (2)
perform - 0.16% (2)
even - 0.16% (2)
input - 0.16% (2)
only - 0.16% (2)
did - 0.16% (2)
human - 0.16% (2)
consulting - 0.16% (2)
excel - - 1.69% (21)
vba programming - 0.81% (10)
ken puls - 0.48% (6)
- general - 0.48% (6)
general tips - 0.48% (6)
in the - 0.4% (5)
how to - 0.4% (5)
knowledge base - 0.4% (5)
more ken - 0.32% (4)
to the - 0.32% (4)
categories: excel - 0.32% (4)
that can - 0.32% (4)
on the - 0.32% (4)
in excel - 0.32% (4)
read more - 0.32% (4)
conditional formatting - 0.32% (4)
am categories: - 0.32% (4)
of the - 0.32% (4)
excelguru knowledge - 0.32% (4)
... read - 0.32% (4)
the excelguru - 0.32% (4)
proper record - 0.24% (3)
you can - 0.24% (3)
data in - 0.24% (3)
convert data - 0.24% (3)
from code/amount - 0.24% (3)
we can - 0.24% (3)
pm convert - 0.24% (3)
to proper - 0.24% (3)
downloads - - 0.24% (3)
and data - 0.24% (3)
magic of - 0.24% (3)
set to - 0.24% (3)
code/amount set - 0.24% (3)
programming (7) - 0.24% (3)
data from - 0.24% (3)
welcome to - 0.24% (3)
copyright © - 0.16% (2)
thread / - 0.16% (2)
a certain - 0.16% (2)
/ post - 0.16% (2)
a picture - 0.16% (2)
formulas excel - 0.16% (2)
-- default - 0.16% (2)
formatting rules - 0.16% (2)
what's new? - 0.16% (2)
canapone today, - 0.16% (2)
... canapone - 0.16% (2)
conditional formats - 0.16% (2)
the way - 0.16% (2)
it. ... - 0.16% (2)
so that - 0.16% (2)
record hi - 0.16% (2)
that you - 0.16% (2)
can be - 0.16% (2)
you to - 0.16% (2)
comment on - 0.16% (2)
(4) access - 0.16% (2)
(4) excel - 0.16% (2)
- charts - 0.16% (2)
catalogonline training - 0.16% (2)
sql (4) - 0.16% (2)
user interface - 0.16% (2)
e-learning catalogonline - 0.16% (2)
outlook - - 0.16% (2)
forum posts - 0.16% (2)
that the - 0.16% (2)
to help - 0.16% (2)
did you - 0.16% (2)
that it - 0.16% (2)
thing that - 0.16% (2)
excel is - 0.16% (2)
both your - 0.16% (2)
time and - 0.16% (2)
to accomplish - 0.16% (2)
up for - 0.16% (2)
clicking the - 0.16% (2)
is that - 0.16% (2)
today's posts - 0.16% (2)
- pivottables - 0.16% (2)
in this - 0.16% (2)
and low - 0.16% (2)
of this - 0.16% (2)
post bookmarking - 0.16% (2)
- vba programming - 0.81% (10)
- general tips - 0.4% (5)
read more ken - 0.32% (4)
excel - general - 0.32% (4)
more ken puls - 0.32% (4)
categories: excel - - 0.32% (4)
am categories: excel - 0.32% (4)
... read more - 0.32% (4)
excel - formulas - 0.24% (3)
data from code/amount - 0.24% (3)
set to proper - 0.24% (3)
pm convert data - 0.24% (3)
from code/amount set - 0.24% (3)
vba programming (7) - 0.24% (3)
to proper record - 0.24% (3)
the excelguru knowledge - 0.24% (3)
magic of pivottables - 0.24% (3)
- formulas excel - 0.16% (2)
data in a - 0.16% (2)
excel - pivottables - 0.16% (2)
both your time - 0.16% (2)
how to accomplish - 0.16% (2)
e-learning catalogonline training - 0.16% (2)
your time and - 0.16% (2)
in excel is - 0.16% (2)
to the excelguru - 0.16% (2)
excel - vba - 0.16% (2)
(7) excel - - 0.16% (2)
excel - powerpivot - 0.16% (2)
- charts and - 0.16% (2)
(4) access - - 0.16% (2)
- ado (4) - 0.16% (2)
knowledge base articles - 0.16% (2)
that you can - 0.16% (2)
/ post bookmarking - 0.16% (2)

Here you can find chart of all your popular one, two and three word phrases. Google and others search engines means your page is about words you use frequently.

Copyright © 2015-2016 hupso.pl. All rights reserved. FB | +G | Twitter

Hupso.pl jest serwisem internetowym, w którym jednym kliknieciem możesz szybko i łatwo sprawdź stronę www pod kątem SEO. Oferujemy darmowe pozycjonowanie stron internetowych oraz wycena domen i stron internetowych. Prowadzimy ranking polskich stron internetowych oraz ranking stron alexa.