<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-4153286749544178329</id><updated>2024-11-01T08:15:46.528+00:00</updated><title type='text'>VG-EXCEL-GEST</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>49</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-7374313828425371917</id><published>2013-05-25T22:09:00.002+01:00</published><updated>2013-05-25T22:09:18.439+01:00</updated><title type='text'></title><content type='html'>&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
Gravei este vídeo hoje sobre uma ferramenta muito simples e útil que construí no intuito de ofuscar dados reais para serem apresentados publicamente num vídeo demo, permite disfarçar texto por forma a ficar imperceptível e assim garantir-mos a privacidade e confidencialidade dos dados:&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;a href=&quot;http://gexcel.pt/index.php/pt/noticias-gexcel/item/23-ofuscador-de-texto-em-excel&quot;&gt;Ver video aqui&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;span data-mce-style=&quot;line-height: 1.3em;&quot; style=&quot;line-height: 1.3em;&quot;&gt;Deixo aqui um link para se inscreverem se quiser receber uma cópia grátis:&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;a data-mce-href=&quot;https://docs.google.com/forms/d/1Mj9cEHko8dpPGpGVf3-Xt-WfzmpMkcUVd6KjS95jZ00/viewform&quot; href=&quot;https://docs.google.com/forms/d/1Mj9cEHko8dpPGpGVf3-Xt-WfzmpMkcUVd6KjS95jZ00/viewform&quot; style=&quot;color: #1b57b1; text-decoration: none;&quot;&gt;Link para inscrição&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/7374313828425371917/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/05/blog-post.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7374313828425371917'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7374313828425371917'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/05/blog-post.html' title=''/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-8472913245236810319</id><published>2013-04-28T11:22:00.000+01:00</published><updated>2013-04-28T11:22:38.701+01:00</updated><title type='text'></title><content type='html'>&lt;br /&gt;
O Victor Gamboa da Gexcel desta vez gravou um vídeo muito completo com um super procedimento em Excel com o objectivo de calcular as taxas de iva segundo a tabela de históricos de vigências das taxas e escalões.&lt;br /&gt;
&lt;br /&gt;
Com este procedimento, utilizando as funções Procv + Índice + Corresp, temos a garantia de calcular e recalcular as taxas de iva segundo a data de venda correctamente, para ajudar à festa, o Victor utilizou tabelas do Excel, onde usufruiu da facilidade de usar a nomenclatura de tabelas na construção e chamada de intervalos, sendo esses intervalos 100% dinâmicos. As tabelas do Excel são por si só um super procedimento em Excel. &lt;a href=&quot;http://gexcel.pt/index.php/pt/noticias-gexcel/item/21-calcular-taxas-de-iva-em-excel-super-procedimento-100-recomendado?goback=%2Egde_2856919_member_236224628&quot;&gt;Ora vejam aqui&lt;/a&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/8472913245236810319/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/04/o-victor-gamboa-da-gexcel-desta-vez.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/8472913245236810319'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/8472913245236810319'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/04/o-victor-gamboa-da-gexcel-desta-vez.html' title=''/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-385694509454489644</id><published>2013-04-09T08:40:00.004+01:00</published><updated>2013-04-09T08:40:41.548+01:00</updated><title type='text'>Tratar texto no Excel</title><content type='html'>&lt;br /&gt;
A Gexcel gravou mais uma série de 3 vídeos sobre como tratar texto no Excel.&lt;br /&gt;
&lt;br /&gt;
Baseado numa situação que aconteceu há uns dias, em que foi necessário ver a correspondência das funções do Excel de Português para Inglês, fomos à procura de uma lista na internet e encontramos uma em que a correspondência estava em apenas uma coluna e a funç. em pt estava concatenada com a funç em ing. separadas por um hífen (-), não procuramos mais e colocamos mãos à obra para separar em duas colunas a listagem encontrada, resultaram 3 vídeos que explicam o processo.&lt;br /&gt;
&lt;br /&gt;
Importar, separar ou tratar texto em Excel é uma tarefa que pode ser um quebra-cabeças terrível quando não conhecemos os super procedimentos disponíveis no Excel para tornar esta tarefa simples, prática e eficiente.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.gexcel.pt/index.php/pt/noticias-gexcel/item/19-tratar-texto-no-excel&quot;&gt;Link para post com videos&lt;/a&gt;&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/385694509454489644/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/04/tratar-texto-no-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/385694509454489644'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/385694509454489644'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/04/tratar-texto-no-excel.html' title='Tratar texto no Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-6616380749867559504</id><published>2013-03-29T21:24:00.001+00:00</published><updated>2013-03-29T21:24:34.658+00:00</updated><title type='text'>Resumir dados por mês e ano muito rapidamente em Excel.</title><content type='html'>&lt;span style=&quot;background-color: #eeeeee; color: #525253; font-family: &#39;Droid Sans&#39;, Helvetica, arial, serif; font-size: 13px; line-height: 20px;&quot;&gt;O Victor Gamboa demonstra em menos de 120 segundos como podemos resumir dados de uma tabela em Excel por mês e ano, para isso iremos usar uma tabela dinâmica &amp;nbsp;e agrupar os dados, é muito fácil e rápido.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #eeeeee; color: #525253; font-family: &#39;Droid Sans&#39;, Helvetica, arial, serif; font-size: 13px; line-height: 20px;&quot;&gt;&lt;br /&gt;
&lt;/span&gt; &lt;span style=&quot;background-color: #eeeeee; color: #525253; font-family: &#39;Droid Sans&#39;, Helvetica, arial, serif; font-size: 13px; line-height: 20px;&quot;&gt;&lt;a href=&quot;http://www.gexcel.pt/index.php/pt/noticias-gexcel/item/18-resumir-dados-por-m%C3%AAs-e-ano-muito-rapidamente&quot;&gt;Ver aqui&lt;/a&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/6616380749867559504/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/03/resumir-dados-por-mes-e-ano-muito.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6616380749867559504'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6616380749867559504'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/03/resumir-dados-por-mes-e-ano-muito.html' title='Resumir dados por mês e ano muito rapidamente em Excel.'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-7573181907597897481</id><published>2013-03-12T21:56:00.005+00:00</published><updated>2013-03-12T21:56:52.036+00:00</updated><title type='text'>Validação com referência dinâmica de campo de tabela do Excel</title><content type='html'>O Victor Gamboa da Gexcel gravou 2 videos com um procedimento espectacular para validar campos com lista, estes videos serviram como resposta à discussão num video do Bill Jelen.&lt;br /&gt;
&lt;br /&gt;
O Bill Jelen que é um guru e um dos melhores professores de Excel do mundo, nesse video ele dá uma solução interessante e eficaz para criar uma lista de validação sobre uma referencia dinâmica, ele cria uma área nomeada sobre a tabela.&amp;nbsp;
&lt;br /&gt;
&lt;br /&gt;
A  Gexcel utiliza outro processo para fazer a mesma coisa e deu essa resposta na discussão no video e gravou um video em Inglês como resposta, este foi o primeiro video em Inglês, por isso desculpem o meu mau Inglês, também tentei dar mais ênfase à narração tal como fazem o Bill Jelen e o Mike Girvin mas aí eles são exímios e eu nem consegui chegar aos seus calcanhares.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Também gravei em espanhol, pois eles também merecem, apreciaram muito o video que fiz sobre tabelas relacionadas em Excel.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;a href=&quot;http://www.gexcel.pt/index.php/pt/noticias-gexcel/item/16-valida%C3%A7%C3%A3o-com-refer%C3%AAncia-din%C3%A2mica-de-campo-de-tabela-do-excel&quot;&gt;Ver aqui&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/7573181907597897481/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/03/validacao-com-referencia-dinamica-de.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7573181907597897481'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7573181907597897481'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/03/validacao-com-referencia-dinamica-de.html' title='Validação com referência dinâmica de campo de tabela do Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-5889133281625478800</id><published>2013-02-13T09:11:00.000+00:00</published><updated>2013-02-13T09:14:14.353+00:00</updated><title type='text'>Tabelas ralacionadas em Excel</title><content type='html'>Seguem 2 videos da Gexcel (o mesmo proprietário deste blog) sobre tabelas relacionadas em Excel, primeiro no PowerPivot no Excel 2012, depois no PowerPivot do Excel 2013.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.gexcel.pt/index.php/pt/noticias-gexcel/item/13-procedimento-verdadeiramente-awesome-em-excel&quot;&gt;Link para o primeiro video&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.gexcel.pt/index.php/pt/noticias-gexcel/item/14-excel-2013-e-powerpivot-tambien-en-espa%C3%B1ol&quot;&gt;Link para o segundo video&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/5889133281625478800/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/tabelas-ralacionadas-em-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5889133281625478800'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5889133281625478800'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/tabelas-ralacionadas-em-excel.html' title='Tabelas ralacionadas em Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-533739943666912095</id><published>2013-02-05T11:34:00.001+00:00</published><updated>2013-02-05T11:34:04.560+00:00</updated><title type='text'>Empreender por Trás-os-Montes e esse Douro acima: GEXCEL - start-up inova em ferramentas comuns</title><content type='html'>&lt;a href=&quot;http://empreendertmad.blogspot.com/2013/02/gexcel-start-up-inova-em-ferramentas.html?spref=bl&quot;&gt;Empreender por Trás-os-Montes e esse Douro acima: GEXCEL - start-up inova em ferramentas comuns&lt;/a&gt;: A Gexcel - Consultoria em Excel de Excelência para empresas é especializada em soluções personalizadas em excel. Transforma assim esta f...</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/533739943666912095/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/empreender-por-tras-os-montes-e-esse.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/533739943666912095'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/533739943666912095'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/empreender-por-tras-os-montes-e-esse.html' title='Empreender por Trás-os-Montes e esse Douro acima: GEXCEL - start-up inova em ferramentas comuns'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-1448433049457390361</id><published>2013-02-02T17:37:00.001+00:00</published><updated>2013-02-02T17:37:58.998+00:00</updated><title type='text'>Formula 100% dinâmica</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
Na sua actividade de consultoria o Victor Gamboa da Gexcel vai gravando videos sobre as técnicas avançadas utilizadas no desenvolvimento de ferramentas profissionais em Excel para os seus clientes.&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
Nestes dois videos vemos como criar uma formula&amp;nbsp;100% dinâmica de procura de dados numa tabela do Excel, muito pouca gente utiliza este tipo de procedimento, nós consideramos um super-procedimento em Excel.&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/IJLTH4JFg6s&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;

&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/7xaQzeXBtmE&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/1448433049457390361/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/na-sua-actividade-de-consultoria-o.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1448433049457390361'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1448433049457390361'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/02/na-sua-actividade-de-consultoria-o.html' title='Formula 100% dinâmica'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/IJLTH4JFg6s/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-6307893753070720628</id><published>2013-01-18T22:41:00.001+00:00</published><updated>2013-01-18T22:46:31.216+00:00</updated><title type='text'>Índice automático de Id de tabela</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
Mais dois videos didácticos Gexcel foram publicados no site www.120segundos.net,&amp;nbsp;&lt;span style=&quot;line-height: 1.3em;&quot;&gt;nestes dois videos mostramos um processo muito simples para criar um índice automático numa tabela, que servirá de identificação de registo (Id).&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;
No segundo video mostramos como esta formula se comporta numa tabela do Excel.&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.796875px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;iframe allowfullscreen=&quot;allowfullscreen&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/99R_t825WLE&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;

&lt;iframe allowfullscreen=&quot;allowfullscreen&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/wqrOu-p8b1s&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/6307893753070720628/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/01/mais-dois-videos-didacticos-gexcel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6307893753070720628'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6307893753070720628'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2013/01/mais-dois-videos-didacticos-gexcel.html' title='Índice automático de Id de tabela'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/99R_t825WLE/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-7745783186388345548</id><published>2012-11-18T18:26:00.001+00:00</published><updated>2012-11-18T18:28:30.682+00:00</updated><title type='text'>Aprenda a tirar partido da função Hiperligação no Excel -  Excel 2010 - Série Função Hiperligação 2 videos</title><content type='html'>&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/29W28oRYrsc?fs=1&quot; width=&quot;459&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;allowfullscreen&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/h7E6EkUF_VA&quot; width=&quot;420&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/7745783186388345548/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/11/aprenda-tirar-partido-da-funcao.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7745783186388345548'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/7745783186388345548'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/11/aprenda-tirar-partido-da-funcao.html' title='Aprenda a tirar partido da função Hiperligação no Excel -  Excel 2010 - Série Função Hiperligação 2 videos'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/29W28oRYrsc/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-6422911585481627138</id><published>2012-10-04T23:24:00.001+01:00</published><updated>2012-10-04T23:24:06.262+01:00</updated><title type='text'>Excel para crianças - Brincar com a formatação condicional</title><content type='html'>Há muito que pretendia encontrar uma forma eficiente de ensinar Excel para crianças, encontrei uma que me parece a mais adequada, é brincando que melhor as crianças aprendem, vejam:&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;270&quot; src=&quot;http://www.youtube.com/embed/JKmZfjmmkuk?fs=1&quot; width=&quot;480&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/6422911585481627138/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/10/excel-para-criancas-brincar-com.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6422911585481627138'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6422911585481627138'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/10/excel-para-criancas-brincar-com.html' title='Excel para crianças - Brincar com a formatação condicional'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/JKmZfjmmkuk/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-5797928451030348687</id><published>2012-08-06T21:14:00.001+01:00</published><updated>2012-08-06T21:14:23.087+01:00</updated><title type='text'>Excel 2010 - Hiperligação para o último registo de uma tabela</title><content type='html'>No ultimo vídeo sobre hiperligações que publiquei no site www.120segundos.net, disse que &quot;ia levar a função Hiperligação até ao limite&quot;, desta vez vamos ultrapassar esse limite e demonstrar como podemos construir um link que nos leve para o último registo de uma tabela.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;270&quot; src=&quot;http://www.youtube.com/embed/8xxSc_9gNSE?fs=1&quot; width=&quot;480&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/5797928451030348687/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/08/excel-2010-hiperligacao-para-o-ultimo.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5797928451030348687'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5797928451030348687'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/08/excel-2010-hiperligacao-para-o-ultimo.html' title='Excel 2010 - Hiperligação para o último registo de uma tabela'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/8xxSc_9gNSE/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-8764168617484458688</id><published>2012-08-06T21:02:00.002+01:00</published><updated>2012-08-06T21:02:57.814+01:00</updated><title type='text'>ExcelGest_PainelNavegação V Preview</title><content type='html'>Coloco á vossa disposição a versão preview do painel de navegação avançado que está a ser desenvolvido por nós o ExcelGest_PainelNavegação V Preview.

Esta versão vem limitada nos recursos, é só para testar algumas funcionalidades e poderem dar a vossa opinião sobre o layout e design, detectar possíveis erros e bugs, dar sugestões de melhoria.

Para quem colaborar receberá uma cópia da versão final gratis, poderam enviar o feedback para vg-excel-gest@hotmail.com.&lt;br /&gt;
&lt;br /&gt;
Veja aqui um video demo publicado no site www.120segundos.net sobre esta aplicação:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;allowfullscreen&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/AIRocayiDK0&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;font-size: large;&quot;&gt;&lt;a href=&quot;https://www.box.com/s/d733f3c4df5d547d488e&quot;&gt;Baixe aqui&lt;/a&gt;.&lt;/span&gt;&lt;/b&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/8764168617484458688/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/08/excelgestpainelnavegacao-v-preview.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/8764168617484458688'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/8764168617484458688'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/08/excelgestpainelnavegacao-v-preview.html' title='ExcelGest_PainelNavegação V Preview'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/AIRocayiDK0/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-2635564344439402649</id><published>2012-07-21T12:01:00.000+01:00</published><updated>2012-07-30T13:55:36.405+01:00</updated><title type='text'>Caixas de verificação no Excel</title><content type='html'>&lt;span style=&quot;background-color: white;&quot;&gt;Código&lt;/span&gt;&amp;nbsp;para criar caixas de verificação no Excel:&lt;br /&gt;
&lt;br /&gt;
(Colar o código no modulo privado das folhas onde se pretende que haja caixas de verificação)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; If Selection.Font.Name = &quot;Webdings&quot; Then&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Cancel = True&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; If Target = vbNullString Then&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Target = &quot;a&quot;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Else&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Target = vbNullString&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; End If&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Exit Sub&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp; &amp;nbsp; End If&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;End Sub&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Veja este&amp;nbsp;vídeo&amp;nbsp;para aprender em 120 segundos como podemos ter caixas de verificação numa folha de cálculo sem&amp;nbsp;sobrecarregar a folha de objetos ou controlos de formulário:&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/8B4tTbznxUY&quot; width=&quot;420&quot;&gt;&lt;/iframe&gt;

&lt;br /&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;&lt;a href=&quot;https://www.box.com/s/8efed1e096dd787059ed&quot;&gt;Download do ficheiro utilizado no&amp;nbsp;&lt;/a&gt;&lt;/span&gt;&lt;span style=&quot;color: #0000ee;&quot;&gt;&lt;u&gt;vídeo&lt;/u&gt;&lt;/span&gt;&amp;nbsp;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/2635564344439402649/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/07/codigo-criar-caixas-de-verificacao-no.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2635564344439402649'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2635564344439402649'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/07/codigo-criar-caixas-de-verificacao-no.html' title='Caixas de verificação no Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/8B4tTbznxUY/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-3923476965945173990</id><published>2012-07-05T14:01:00.002+01:00</published><updated>2013-06-04T11:31:19.305+01:00</updated><title type='text'>VG-EXCEL-GEST_AssistentePersonalizaçãoProcedimento_ExpandirOcultarAreaNoExcel</title><content type='html'>Alguns seguidores têm questionado como devem proceder para usar áreas retracto
expansíveis no Excel, pois bem disponibilizo aqui um assistente em folha de
cálculo para poderem adaptar o procedimento base a qualquer área a ocultar e as
instruções necessárias para o fazer e usar o assistente.&lt;o:p&gt;&lt;/o:p&gt;&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Podem fazer o download&amp;nbsp;&lt;strong&gt;&lt;span style=&quot;font-size: large;&quot;&gt;&lt;a href=&quot;https://www.box.com/s/5od3nu8qe9p2rni4foq3&quot; target=&quot;_blank&quot;&gt;aqui.&lt;/a&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/strong&gt;&lt;span style=&quot;background-color: white;&quot;&gt;(Versão 1.0.3)&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;
Notas importantes:&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;color: red;&quot;&gt;O assistente vai protegido com o XlsWorkbookSecuring sem licença trial,
devem por isso requisitar uma licença que é grátis para poderem aceder, sigam
as instruções ao abrir a aplicação.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;color: red;&quot;&gt;

&lt;/span&gt;&lt;o:p&gt;&lt;span style=&quot;color: red;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;color: red;&quot;&gt;

&lt;/span&gt;&lt;span style=&quot;color: red;&quot;&gt;Se não conseguirem fazer download porque o vosso antivírus não permite, é
porque o ficheiro está compilado em exe, declaro que a aplicação não contem código&amp;nbsp;malicioso,&amp;nbsp;retornem para dar outra alternativa de download.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;
&lt;br /&gt;
Ver aqui&amp;nbsp;vídeo&amp;nbsp;demonstração&amp;nbsp;de com o proceder para licenciar a aplicação:&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;http://www.youtube.com/embed/HPG856rMt6M&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/3923476965945173990/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/07/vg-excel-gestassistentepersonalizacaopr.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3923476965945173990'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3923476965945173990'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/07/vg-excel-gestassistentepersonalizacaopr.html' title='VG-EXCEL-GEST_AssistentePersonalizaçãoProcedimento_ExpandirOcultarAreaNoExcel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/HPG856rMt6M/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-6614618463186849307</id><published>2012-05-21T17:53:00.000+01:00</published><updated>2012-05-21T17:57:05.339+01:00</updated><title type='text'></title><content type='html'>&lt;span style=&quot;background-color: white; color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif; line-height: 14px; text-align: left;&quot;&gt;Ontem VG-EXCEL-GEST esteve no So Pitch Startupping em Braga, foi demais, ainda estou a processar, a nossa equipa foi uma das vencedoras, ganhamos um bilhete para o Rock In Rio mas não vou!!!!&lt;/span&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white; color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif; line-height: 14px; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;span style=&quot;color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif;&quot;&gt;&lt;span style=&quot;line-height: 14px;&quot;&gt;Apresentou as duas marcas que irão representar comercialmente a consultoria e o XlsWorkbookSecuring, que por agora não as apresento aqui, ainda não está na hora!&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: white; color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif; line-height: 14px; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif; line-height: 14px; text-align: left;&quot;&gt;É pena não haver mais tempo, é para o dia 25, se não tinha feito uma pequena brincadeira com o bilhete! e acabei de oferecê-lo agora mesmo!!!&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; color: grey; font-family: &#39;lucida grande&#39;, tahoma, verdana, arial, sans-serif; font-size: 11px; line-height: 14px; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.facebook.com/SoPitch&quot;&gt;&lt;img src=&quot;http://profile.ak.fbcdn.net/hprofile-ak-ash2/373331_190095531016886_26661677_n.jpg&quot; /&gt;&lt;/a&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Clique na imagem&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/6614618463186849307/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/ontem-vg-excel-gest-esteve-no-so-pitch.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6614618463186849307'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/6614618463186849307'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/ontem-vg-excel-gest-esteve-no-so-pitch.html' title=''/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-2612094353325217340</id><published>2012-05-18T11:28:00.001+01:00</published><updated>2012-05-18T11:29:01.590+01:00</updated><title type='text'>Fábrica de Velocímetros 2 (ordenar cores).</title><content type='html'>Demonstração de como podemos ordenar as cores das bandas do&amp;nbsp;velocímetro.&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/5akrrOnRpr8?fs=1&quot; width=&quot;459&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/2612094353325217340/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/fabrica-de-velocimetros-ordenar-cores.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2612094353325217340'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2612094353325217340'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/fabrica-de-velocimetros-ordenar-cores.html' title='Fábrica de Velocímetros 2 (ordenar cores).'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/5akrrOnRpr8/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-3193972267032556834</id><published>2012-05-18T11:23:00.001+01:00</published><updated>2012-05-18T11:23:58.733+01:00</updated><title type='text'>Fábrica de Velocímetros</title><content type='html'>&lt;span style=&quot;background-color: #ebebeb; color: #333333; font-family: arial, sans-serif; font-size: 13px; line-height: 18px; text-align: left;&quot;&gt;A fábrica de Velocímetros permite personalizar rapidamente um modelo de gráfico velocímetro e replica-lo numa folha quantas vezes quisermos incluindo acumular vários grupos formatados de forma diferente, no final podemos exportar essa folha para um novo livro onde podemos construir um dashboard.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #ebebeb; color: #333333; font-family: arial, sans-serif; font-size: 13px; line-height: 18px; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #ebebeb; color: #333333; font-family: arial, sans-serif; font-size: 13px; line-height: 18px; text-align: left;&quot;&gt;Ainda está em construção, iremos em breve disponibilizar uma versão BETA para puderem testar.&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/lXS1p5szF-Y?fs=1&quot; width=&quot;459&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/3193972267032556834/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/fabrica-de-velocimetros.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3193972267032556834'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3193972267032556834'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/fabrica-de-velocimetros.html' title='Fábrica de Velocímetros'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/lXS1p5szF-Y/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-1928499882418769035</id><published>2012-05-10T14:15:00.001+01:00</published><updated>2012-05-10T14:15:29.965+01:00</updated><title type='text'>XlsWorkbookSecuring3D Multi-Língua</title><content type='html'>Pequena demonstração da versão multi-língua do XlsWorkbookSecuring3D, auto traduz a interface em 3 línguas diferentes, Português, Inglês e Espanhol.&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/fiB-Y6C36yI?fs=1&quot; width=&quot;459&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/1928499882418769035/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/xlsworkbooksecuring3d-multi-lingua.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1928499882418769035'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1928499882418769035'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/xlsworkbooksecuring3d-multi-lingua.html' title='XlsWorkbookSecuring3D Multi-Língua'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/fiB-Y6C36yI/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-5803310806542110636</id><published>2012-05-10T13:43:00.001+01:00</published><updated>2012-05-10T13:43:24.054+01:00</updated><title type='text'>Formulário Com Separadores Em Excel</title><content type='html'>Este formulário está em construção, será para aplicar na BERD(Base Excel Para Registo De Dados), fica aqui um pequeno video para ver como funciona com muito eficiência um sistema de separadores. &lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/7b4v1I_jUi0?fs=1&quot; width=&quot;459&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/5803310806542110636/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/formulario-com-separadores-em-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5803310806542110636'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5803310806542110636'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/05/formulario-com-separadores-em-excel.html' title='Formulário Com Separadores Em Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/7b4v1I_jUi0/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-3768135661192848456</id><published>2012-02-02T22:16:00.000+00:00</published><updated>2012-02-02T22:16:18.630+00:00</updated><title type='text'>Excel Magic Trick 865: Recorded Macro &amp; Paste All Clipboard: Data From M...</title><content type='html'>Excelente truque de ExcelIsFun.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;iframe width=&quot;459&quot; height=&quot;344&quot; src=&quot;http://www.youtube.com/embed/rty_XhIYzuo?fs=1&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/3768135661192848456/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/02/excel-magic-trick-865-recorded-macro.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3768135661192848456'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/3768135661192848456'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/02/excel-magic-trick-865-recorded-macro.html' title='Excel Magic Trick 865: Recorded Macro &amp; Paste All Clipboard: Data From M...'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/rty_XhIYzuo/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-2103189465244530943</id><published>2012-01-28T22:32:00.000+00:00</published><updated>2012-01-28T22:32:42.083+00:00</updated><title type='text'>Tabela códigos vba de cores Excel</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
Publico aqui a tabela de códigos da&amp;nbsp;propriedade&amp;nbsp;colorindex, estes códigos vão fazer falta aos utilizadores do XlsWorkbookSecuring V1.2.8, esta versão para alem de concertar alguns bugs menores compatibiliza-se com a versão 64bits do Excel.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Nesta versão&amp;nbsp;também&amp;nbsp;foram acrescentadas mais 3 elementos de visualização na matriz de&amp;nbsp;protecção&amp;nbsp;e visualização:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;b&gt;GridlineColor&lt;/b&gt; &lt;i&gt;(cor das linhas de grelha)&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;b&gt;MoveAfterReturnDirection Down&lt;/b&gt; &amp;nbsp;&lt;i&gt;(por defeito sem a marcação na matriz assume para a&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; direita,&lt;/i&gt;&lt;i&gt;&amp;nbsp;se o&amp;nbsp;&lt;/i&gt;&lt;i&gt;utilizador quiser que o cursor se desloque para baixo terá de marcar a opção)&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/i&gt;&amp;nbsp;&amp;nbsp;&lt;b&gt;Worksheet to select after login/protect&lt;/b&gt; &lt;i&gt;(o(s) administrador(es) poderão marcar a folha que&amp;nbsp;&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; querem que fique&amp;nbsp;seleccionada&amp;nbsp;&lt;/i&gt;&lt;i&gt;depois de login ou depois de proteger o livro)&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Para utilizar o elemento&amp;nbsp;&lt;b&gt;GridlineColor&lt;/b&gt;, o(s) administrador(es) deverão não utilizar um&amp;nbsp;carácter&amp;nbsp;para marcar mas sim o&amp;nbsp;código&amp;nbsp;de cor que querem para as linhas de grelha, códigos apresentados na tabela em baixo:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiajS_kNFhjqCVCiBnJ7SzM7RAfGVZfNSuyIq4JPza9mWcUZscqbCmEBwhNgZAQrpQvx0-h19BBmrqQCNnm4hiF24jAL5yNM6H9iBKFuZ0kePJgpHkQ91kjux2RlGm64ksWy7GpZt-qFGQo/s1600/TabelaCoresExcel.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;360&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiajS_kNFhjqCVCiBnJ7SzM7RAfGVZfNSuyIq4JPza9mWcUZscqbCmEBwhNgZAQrpQvx0-h19BBmrqQCNnm4hiF24jAL5yNM6H9iBKFuZ0kePJgpHkQ91kjux2RlGm64ksWy7GpZt-qFGQo/s640/TabelaCoresExcel.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/2103189465244530943/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/01/tabela-codigos-vba-de-cores-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2103189465244530943'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/2103189465244530943'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2012/01/tabela-codigos-vba-de-cores-excel.html' title='Tabela códigos vba de cores Excel'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiajS_kNFhjqCVCiBnJ7SzM7RAfGVZfNSuyIq4JPza9mWcUZscqbCmEBwhNgZAQrpQvx0-h19BBmrqQCNnm4hiF24jAL5yNM6H9iBKFuZ0kePJgpHkQ91kjux2RlGm64ksWy7GpZt-qFGQo/s72-c/TabelaCoresExcel.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-1289341056867013981</id><published>2011-12-29T00:05:00.000+00:00</published><updated>2012-01-01T20:30:36.219+00:00</updated><title type='text'>.xlsnol Excel for Business... Visualization and data analysis.</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
xlsnol é um blog sobre Excel de um blogger Português, neste blog pode encontrar diversos artigos sobre business intelligence e&amp;nbsp;visualização&amp;nbsp;de dados e como o&amp;nbsp;Excel&amp;nbsp;pode ajudar, o autor publica alguns truques interessantes sobre o tema.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://xlsnol.blogspot.com/&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;186&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhQcfgqTpo0eSy_CjeLEqcCXhAyH4aFul5kwZO0g74-sO2CG7QGXzs1Uebn5Yu5itl5G4ONl-BMxYwZCV90_sjzI_YV80DjC2OwKL3nH60yCLc1jngomIEsqh5e_ScEgxxt58qUCFICzyn/s320/Screenshot+-+29-12-2011+%252C+0_00_26.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/1289341056867013981/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/xlsnol-excel-for-business-visualization.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1289341056867013981'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/1289341056867013981'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/xlsnol-excel-for-business-visualization.html' title='.xlsnol Excel for Business... Visualization and data analysis.'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhQcfgqTpo0eSy_CjeLEqcCXhAyH4aFul5kwZO0g74-sO2CG7QGXzs1Uebn5Yu5itl5G4ONl-BMxYwZCV90_sjzI_YV80DjC2OwKL3nH60yCLc1jngomIEsqh5e_ScEgxxt58qUCFICzyn/s72-c/Screenshot+-+29-12-2011+%252C+0_00_26.jpg" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-5446905295782982646</id><published>2011-12-06T18:48:00.001+00:00</published><updated>2011-12-07T12:15:06.318+00:00</updated><title type='text'>UNIQUEDASHBOARD</title><content type='html'>&lt;a href=&quot;http://www.rcrempresas.com/rcr-software&quot;&gt;&lt;img alt=&quot;RCR Software&quot; src=&quot;http://www.rcrempresas.com/interface/imgs/uniquedashboard2.png&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;color: #2f2f2f; font-family: arial, serif; font-size: 22px; font-weight: bold; line-height: 17px; margin-bottom: 8px; text-align: left; text-transform: uppercase;&quot;&gt;
&lt;strong style=&quot;background-color: white;&quot;&gt;SOFTWARES DE GESTÃO EMPRESARIAL&lt;/strong&gt;&lt;/div&gt;
&lt;div style=&quot;color: #2f2f2f; font-family: arial, serif; font-size: 22px; font-weight: bold; line-height: 17px; margin-bottom: 8px; text-align: left; text-transform: uppercase;&quot;&gt;
&lt;strong style=&quot;background-color: white;&quot;&gt;PARA O DESENVOLVIMENTO DE NEGÓCIOS&lt;/strong&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #2f2f2f; font-family: arial, sans-serif; font-size: 16px; line-height: 20px;&quot;&gt;A&amp;nbsp;&lt;/span&gt;&lt;strong style=&quot;color: #2f2f2f; font-family: arial, sans-serif; font-size: 16px; line-height: 20px;&quot;&gt;UNIQUEDASHBORD&lt;/strong&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #2f2f2f; font-family: arial, sans-serif; font-size: 16px; line-height: 20px;&quot;&gt;&amp;nbsp;é uma marca especiliazada no desenvolvimento de ferramentas de gestão que permitem alavancar todo o potencial do Gestor actual.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #2f2f2f; font-family: arial, sans-serif; font-size: 16px; line-height: 20px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white;&quot;&gt;&lt;a href=&quot;http://www.uniquedashboard.com/&quot; style=&quot;color: #0068cf; cursor: pointer; font-family: &#39;Times New Roman&#39;, serif; font-size: 16px; line-height: 20px; text-align: left;&quot; target=&quot;_blank&quot;&gt;&lt;span style=&quot;color: purple; line-height: normal;&quot;&gt;www.uniquedashboard.com&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
A UNIQUEDASHBOARD é a primeira empresa em portugal a fornecer software especializado na área da monitorização de negócios, tenho o prazer de conhecer um dos promotores deste projecto e posso afirmar que é dos maiores especialistas da&amp;nbsp;área&amp;nbsp;em Portugal, não só como consultor mas também como formador e professor universitário.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white; color: #2a2a2a; line-height: 20px;&quot;&gt;Aqui há sensivelmente pouco mais de um ano, pouco antes de iniciar este blog, estava eu numa livraria algures em Portugal quando de repente deparo-me com um livro sobre Dashboards em Português&amp;nbsp;escrito por um&amp;nbsp;Português, não acredito!?!? disse para mim mesmo, na altura já andava com &amp;nbsp;intenções de orientar uma parte &amp;nbsp;do meu foco para os Dashboards como forma aplicada de Excel. Estou a falar do Dr. Jorge Caldeira com quem já tive o prazer de fazer formação em E-Learning e de o conhecer pessoalmente, promotor do blog&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #666666; font-family: Georgia, serif; font: normal normal normal 200%/normal Georgia, serif; letter-spacing: 0.2em; margin-bottom: 0px; margin-left: 5px; margin-right: 5px; margin-top: 5px; padding-bottom: 0.25em; padding-left: 20px; padding-right: 20px; padding-top: 15px; text-align: center; text-transform: uppercase;&quot;&gt;

&lt;a href=&quot;http://monitorizaraperformance.blogspot.com/&quot;&gt;MONITORIZAÇÃO DA PERFORMANCE&lt;/a&gt;&lt;/h1&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Bem haja Dr. Jorge Caldeira, bem como a todos os que nos&amp;nbsp;dedicamos&amp;nbsp;a divulgar esta&amp;nbsp;área, uns mais directamente outros menos directamente ligados ao Excel.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Victor Gamboa&lt;br /&gt;
VG-EXCEL-GEST&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;font-family: Tahoma; font-size: 13px;&quot;&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;span class=&quot;ecxApple-style-span&quot; style=&quot;color: #17365d; font-family: arial, sans-serif; font-size: 10pt;&quot;&gt;&lt;a href=&quot;http://www.youtube.com/user/VGEXCELGEST2?feature=mhum&quot; target=&quot;_blank&quot;&gt;http://www.youtube.com/user/VGEXCELGEST2?feature=mhum&lt;/a&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div style=&quot;font-family: Tahoma; font-size: 13px;&quot;&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;a href=&quot;http://www.facebook.com/vgexcelgest&quot; style=&quot;font-size: 10pt;&quot; target=&quot;_blank&quot;&gt;http://www.facebook.com/vgexcelgest&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div style=&quot;font-family: Tahoma; font-size: 13px;&quot;&gt;
&lt;br /&gt;&lt;div&gt;
&lt;div&gt;
Proteja a sua informação ou da sua empresa com o XlsWorkbookSecuring - Template segura para Excel :&lt;br /&gt;&lt;div&gt;
&lt;a href=&quot;http://vg-excel-gest.blogspot.com/p/xlsworkbooksecuring3d.html&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;&lt;span class=&quot;ecxApple-style-span&quot; style=&quot;color: #953734;&quot;&gt;http://vg-excel-gest.blogspot.com/p/xlsworkbooksecuring3d.html&lt;/span&gt;&lt;/b&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href=&quot;http://vg-excel-gest-products.weebly.com/&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;&lt;span class=&quot;ecxApple-style-span&quot; style=&quot;color: #953734;&quot;&gt;http://vg-excel-gest-products.weebly.com/&lt;/span&gt;&lt;/b&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/5446905295782982646/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/uniquedashboard.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5446905295782982646'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/5446905295782982646'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/uniquedashboard.html' title='UNIQUEDASHBOARD'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4153286749544178329.post-4487378803847836853</id><published>2011-12-05T00:28:00.001+00:00</published><updated>2011-12-05T00:30:10.163+00:00</updated><title type='text'>8 Aspectos rápidos a ter em conta na utilização do XlsWorkbookSecuring</title><content type='html'>&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
1 – A sua utilização é
extremamente fácil, trata-se de um template em branco com funcionalidades de
protecção anti-cópia avançada, controlo de utilizadores e matriz de
automatização da protecção e visualização das folhas do livro Excel.&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
2 – O template também é
fornecido apenas com o módulo de licenciamento (1D).&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
3 – A sua compilação em
exe permite adicionar várias funcionalidades de protecção, tais como:&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - Manipular a instância e versão de Excel que irá
abrir com o template&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - Reforçar a segurança do projecto vba e do ficheiro&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - Abrir numa instância própria sem suplementos&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-indent: 35.4pt;&quot;&gt;
&amp;nbsp; &amp;nbsp; Todas estas funcionalidades são personalizáveis.&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
4 – O template funciona
com uma licença trial dividida em dois períodos, um dos quais personalizável para
redistribuição por parte dos nossos clientes, só disponível na versão 3D.&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
5 – Expiradas as licenças
triais o template só funcionará mediante o registo de um NSL (Nº de série de
licença) que deverá ser requisitado a nós pelo email &lt;span lang=&quot;ES-TRAD&quot;&gt;&lt;a href=&quot;mailto:vg-excel-gest@hotmail.com&quot;&gt;&lt;span lang=&quot;PT&quot;&gt;vg-excel-gest@hotmail.com&lt;/span&gt;&lt;/a&gt;&lt;/span&gt; , ver vídeo no youtube &lt;span lang=&quot;ES-TRAD&quot;&gt;&lt;a href=&quot;http://www.youtube.com/watch?v=_FlnI7bp8eU&quot;&gt;&lt;span lang=&quot;PT&quot;&gt;http://www.youtube.com/watch?v=_FlnI7bp8eU&lt;/span&gt;&lt;/a&gt;&lt;/span&gt; .&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
6 – Para licenciar o
template você não adquire licenças mas sim créditos de licenças que irá
consumir a cada NSL que requisitar, as licenças serão vendidas em pacotes que
farão cada NSL ficar a um preço muito baixo.&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
7 – No registo para
download do template oferecemos automaticamente 2 créditos de licença para
poderem licenciar o template e continuar a experiência, se necessitarem mais
créditos de licença basta escrever-nos para &lt;span lang=&quot;ES-TRAD&quot;&gt;&lt;a href=&quot;mailto:vg-excel-gest@hotmail.com&quot;&gt;&lt;span lang=&quot;PT&quot;&gt;vg-excel-gest@hotmail.com&lt;/span&gt;&lt;/a&gt;&lt;/span&gt; que nós lhe ofereceremos mais créditos.&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
8 – Esta ainda é uma fase
beta do projecto, apenas estão a ser libertadas duas versões do template a 3D s
n4 exe (versão exe sem edição de macros, nível 4 de licenciamento) e 1D s exe
n4 ver em &lt;span lang=&quot;ES-TRAD&quot;&gt;&lt;a href=&quot;http://vg-excel-gest.blogspot.com/2011/09/tabela-de-versoes-disponiveis-vs.html&quot;&gt;http://vg-excel-gest.blogspot.com/2011/09/tabela-de-versoes-disponiveis-vs.html&lt;/a&gt;
&lt;/span&gt;ou em &lt;span lang=&quot;ES-TRAD&quot;&gt;&lt;a href=&quot;http://vg-excel-gest-products.weebly.com/3/post/2011/09/-primeira-publicao.html&quot;&gt;http://vg-excel-gest-products.weebly.com/3/post/2011/09/-primeira-publicao.html&lt;/a&gt;&lt;span class=&quot;MsoHyperlink&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vg-excel-gest.blogspot.com/feeds/4487378803847836853/comments/default' title='Enviar feedback'/><link rel='replies' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/8-aspectos-rapidos-ter-em-conta-na.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/4487378803847836853'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4153286749544178329/posts/default/4487378803847836853'/><link rel='alternate' type='text/html' href='http://vg-excel-gest.blogspot.com/2011/12/8-aspectos-rapidos-ter-em-conta-na.html' title='8 Aspectos rápidos a ter em conta na utilização do XlsWorkbookSecuring'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/07914229763308054653</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>