<?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-9031597378895731609</id><updated>2024-09-16T03:16:32.865-03:00</updated><category term="Matriz - Matrizes - MS Office Excel - Intervalor - Renomear Intervalo - Gerenciados de Nomes"/><category term="Formulários"/><category term="Gráfico"/><category term="IRRF - Imposto de Renda -  INSS"/><category term="MS Office Excel - Formulários - Planilha Financeira - PV - FV -"/><category term="Microsoft Office Excel - Macro básica"/><category term="Microsoft Office Excel - Macro básica - PGTO - IPGTO - PPGTO - TAXA - JUROS - FINANCIAMENTOS E EMPRESTIMO"/><category term="Não-Assalariados"/><category term="Salário Pessoa Física"/><title type='text'>Blog do Excel</title><subtitle type='html'>Este Blog tem o objetivo de abordar temas sobre os mais diversos assuntos do MS Office Excel.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Unknown</name><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>25</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-2904991704827960607</id><published>2012-09-05T14:06:00.002-03:00</published><updated>2012-09-05T14:07:36.439-03:00</updated><title type='text'>Tabela para Cálculo do INSS e IR pessoa física</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Prezados,&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Após quase um ano sem postar algum material, venho hoje atualizar este Blog.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Bom, estou disponibilizando a planilha atualizada do INSS e IR para trabalhadores assalariados e/ou autônomos.&amp;nbsp;&lt;/div&gt;
&lt;div&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/AVvXsEhu5zza40ckSrSq_J8QqPxON5SGpBZdYHN1ZctpvzMB5fGds8waJ8a04Fxh05YXRr8TM_Pz22mwzmzPjGctJPA7cf6I5r2WZFAysg7F_kEpm85aanBir5zmiTzC4ruYuy8pYga_pK4Jbi6v/s1600/01.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;191&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu5zza40ckSrSq_J8QqPxON5SGpBZdYHN1ZctpvzMB5fGds8waJ8a04Fxh05YXRr8TM_Pz22mwzmzPjGctJPA7cf6I5r2WZFAysg7F_kEpm85aanBir5zmiTzC4ruYuy8pYga_pK4Jbi6v/s320/01.png&quot; width=&quot;320&quot; /&gt;&lt;/a&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;
Para baixar o arquivo, clique &lt;span style=&quot;color: red; font-family: Georgia, Times New Roman, serif; font-size: x-large;&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://www.mediafire.com/?l1h93jbzox3enh3&quot; target=&quot;_blank&quot;&gt;AQUI!&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Ao clicar, irá abrir uma nova janela para o download.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/2904991704827960607/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2012/09/prezados-apos-quase-um-ano-sem-postar.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/2904991704827960607'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/2904991704827960607'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2012/09/prezados-apos-quase-um-ano-sem-postar.html' title='Tabela para Cálculo do INSS e IR pessoa física'/><author><name>Unknown</name><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/AVvXsEhu5zza40ckSrSq_J8QqPxON5SGpBZdYHN1ZctpvzMB5fGds8waJ8a04Fxh05YXRr8TM_Pz22mwzmzPjGctJPA7cf6I5r2WZFAysg7F_kEpm85aanBir5zmiTzC4ruYuy8pYga_pK4Jbi6v/s72-c/01.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-6722411957360697315</id><published>2011-09-18T23:18:00.003-03:00</published><updated>2011-09-18T23:18:53.363-03:00</updated><title type='text'></title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Boa noite a todos.&lt;br /&gt;
&lt;br /&gt;
Hoje vou postar um assunto muito&amp;nbsp;útil, principalmente para que trabalha em planilhas que mais pessoas utilizam. Vamos falar sobre como &lt;b&gt;Proteger / Bloquear&lt;/b&gt; a planilha.&lt;br /&gt;
&lt;br /&gt;
Protegendo/bloqueando a planilha você pode limitar determinadas atividades que os usuários poderão realizar com o material.&lt;br /&gt;
&lt;br /&gt;
Primeiro passo, antes de qualquer outra coisa:&lt;br /&gt;
&lt;br /&gt;
Para Proteger / Bloquear uma ou mais células, a célula deve estar protegida em sua formatação. Para isso, clique com o botão contrário sobre a célula e selecione a opção FORMATAR CÉLULAS.&lt;br /&gt;
&lt;br /&gt;
Em seguida, clique na aba Proteção, e marque a opção &lt;b&gt;Bloquear&lt;/b&gt;. Se, além de proteger a planilha você quiser ocultar as fórmulas, você também pode marcar a opção &lt;b&gt;Ocultas. &lt;/b&gt;Veja imagem abaixo:&lt;br /&gt;
&lt;br /&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/AVvXsEjz36D9Odc6ZaW2MthWTQymlubdixYwIAwFB4JcvBEwh_H-zwWdY183GcR57ENdHjQikCn1agCA5LdZGsq0yP4rNAsucl-X-4tCWxRQB6UMAoXoH50nFFd40amBcSnAXah88lHYbAFaYAFF/s1600/05.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz36D9Odc6ZaW2MthWTQymlubdixYwIAwFB4JcvBEwh_H-zwWdY183GcR57ENdHjQikCn1agCA5LdZGsq0yP4rNAsucl-X-4tCWxRQB6UMAoXoH50nFFd40amBcSnAXah88lHYbAFaYAFF/s400/05.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: Arial, Helvetica, sans-serif;&quot;&gt;&amp;nbsp;Temos três caminhos para Proteger / Bloquear a planilha.&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;&lt;u&gt;&lt;br /&gt;&lt;/u&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;&lt;u&gt;1º Caminho:&lt;/u&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Clique na aba Revisão,&lt;/li&gt;
&lt;li&gt;Depois, clique no ícone Proteção, conforme imagem:&lt;/li&gt;
&lt;/ul&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/AVvXsEicgs1FQa7hCz7VwP6YoPP4c9nhG9xYNCxsu4q3gPAXdm88erc5mflgNydx6NBVSji4LXeySNF0YLEz0rb7xJ3U2GKrzuffKKSbI0cx3Fx2H9jzJagaPE0JZEu-AU0412C66WvZtHBca5ly/s1600/01.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicgs1FQa7hCz7VwP6YoPP4c9nhG9xYNCxsu4q3gPAXdm88erc5mflgNydx6NBVSji4LXeySNF0YLEz0rb7xJ3U2GKrzuffKKSbI0cx3Fx2H9jzJagaPE0JZEu-AU0412C66WvZtHBca5ly/s400/01.png&quot; width=&quot;400&quot; /&gt;&lt;/a&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 class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;u&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;u&gt;&lt;b&gt;2º Caminho:&lt;/b&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Clique na aba Início,&lt;/li&gt;
&lt;li&gt;Depois clique em Formatar e, em seguida,&lt;/li&gt;
&lt;li&gt;Proteger Planilha... Veja a imagem:&lt;/li&gt;
&lt;/ul&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/AVvXsEjXN7j3YGL8mbkfA6nbGMZ3jqEgjP8jsWYl-KVlSAA3miyqo2geDnRAjL2j0AZ7KodePBdwA3s1-eWDu2NpptRrWhyphenhyphenlnnfZx2xCfbmb8VnVFExEuWBePITFsmDggxWlDjU1UvdoN6wAr9Ne/s1600/02.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXN7j3YGL8mbkfA6nbGMZ3jqEgjP8jsWYl-KVlSAA3miyqo2geDnRAjL2j0AZ7KodePBdwA3s1-eWDu2NpptRrWhyphenhyphenlnnfZx2xCfbmb8VnVFExEuWBePITFsmDggxWlDjU1UvdoN6wAr9Ne/s400/02.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&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;b&gt;&lt;u&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;3º Caminho:&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;No título da planilha, clique com o botão contrário,&lt;/li&gt;
&lt;li&gt;Em seguida, clique em Proteger Planilha...&lt;/li&gt;
&lt;/ul&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/AVvXsEiYeOEstvdjKYSe2V0opGrx8yDkj53aRpvRtfN3XZeF3csZ1F6OdjpARnBgWfgq478KkS0QanQeIUA0BCYzlqpe5cVCJBGD9byGujEHrzUKXiJl5Fc7BDsc1UIhzAYX2nXmY-KOFG5S6Pkr/s1600/03.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;223&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYeOEstvdjKYSe2V0opGrx8yDkj53aRpvRtfN3XZeF3csZ1F6OdjpARnBgWfgq478KkS0QanQeIUA0BCYzlqpe5cVCJBGD9byGujEHrzUKXiJl5Fc7BDsc1UIhzAYX2nXmY-KOFG5S6Pkr/s400/03.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Todos os caminhos te levarão ao mesmo local, ou seja, abrirá uma nova janela para você definir o que o usuário poderá fazer na planilha quando estiver protegida.&lt;/div&gt;
&lt;div&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/AVvXsEiR6hnIP8A3uW2pOh66aQ8jyaD3j9q7MNY8LbUfhjHcDh0R9FeOZCmsBXSzKUzn7UYrJGfQrnKauWEbcePMHkHzS2zOTveGrVqJwZi69S16A_tGCcqD3yJ9imBLfhyDlUTzrJD1LN6xHyPK/s1600/04.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR6hnIP8A3uW2pOh66aQ8jyaD3j9q7MNY8LbUfhjHcDh0R9FeOZCmsBXSzKUzn7UYrJGfQrnKauWEbcePMHkHzS2zOTveGrVqJwZi69S16A_tGCcqD3yJ9imBLfhyDlUTzrJD1LN6xHyPK/s400/04.png&quot; width=&quot;400&quot; /&gt;&lt;/a&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;
Nesta janela também tem a opção de inserir uma senha, o que aumentará a segurança da planilha.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Espero ter colaborado com mais essa dica.&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;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6722411957360697315/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/09/boa-noite-todos_18.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6722411957360697315'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6722411957360697315'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/09/boa-noite-todos_18.html' title=''/><author><name>Unknown</name><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/AVvXsEjz36D9Odc6ZaW2MthWTQymlubdixYwIAwFB4JcvBEwh_H-zwWdY183GcR57ENdHjQikCn1agCA5LdZGsq0yP4rNAsucl-X-4tCWxRQB6UMAoXoH50nFFd40amBcSnAXah88lHYbAFaYAFF/s72-c/05.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-6839937156476596164</id><published>2011-09-16T00:46:00.000-03:00</published><updated>2011-09-16T00:48:10.235-03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Formulários"/><category scheme="http://www.blogger.com/atom/ns#" term="Gráfico"/><category scheme="http://www.blogger.com/atom/ns#" term="Matriz - Matrizes - MS Office Excel - Intervalor - Renomear Intervalo - Gerenciados de Nomes"/><title type='text'>Gráfico com Formulário</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Boa noite a todos.&amp;nbsp;Início de sexta-feira (00:07).&lt;br /&gt;
&lt;br /&gt;
Estou publicando um arquivo que acho muito&amp;nbsp;útil&amp;nbsp;no dia-a-dia, sobre gráficos e formulários.&lt;br /&gt;
Clique &lt;b&gt;&lt;u&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace; font-size: large;&quot;&gt;&lt;a href=&quot;http://www.mediafire.com/?r5cs1tnbfsiqa3f&quot;&gt;AQUI&lt;/a&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt; para baixar o arquivo.&lt;br /&gt;
Primeiramente, nesta planilha, tem duas tabelas de empresas distintas (Empresa ALFA e Empresa BETHA).&lt;br /&gt;
&lt;br /&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/AVvXsEj-dbqyLOJNjYwJY37bCTvcAeFhBa-zkXhpqyxP1ZLxL4I3nKq8hom3Zy_xIhFIB8APBCrCigOU8SDa6icoTlcTPjVKqe2cFzqGXpg1nj7vwY6wPpDBCnpSeQsD9bS1GQjholERnNOwE4gv/s1600/02.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;220&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-dbqyLOJNjYwJY37bCTvcAeFhBa-zkXhpqyxP1ZLxL4I3nKq8hom3Zy_xIhFIB8APBCrCigOU8SDa6icoTlcTPjVKqe2cFzqGXpg1nj7vwY6wPpDBCnpSeQsD9bS1GQjholERnNOwE4gv/s400/02.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
O gráfico gera três tipos de informações (01 -&amp;nbsp;Empresa ALFA, 02 - Empresa BETHA, 03&amp;nbsp;ALFA + BETHA). As informações são alternadas de acordo com a seleção das opções do formulário.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&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/AVvXsEgZPTiIJSVgYMsRA6txjDSqRDpw96cVT2nr5fBNjCTpNWKSEgBIaMCfde-By5pSUeSFnSChyphenhyphenTLLwL99jh7B2dHjbHZb8nINxe685YcJaHqc429K1NAv91ED9YesB-KFJtFsrCJGAFhXHLY-/s1600/01.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;176&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZPTiIJSVgYMsRA6txjDSqRDpw96cVT2nr5fBNjCTpNWKSEgBIaMCfde-By5pSUeSFnSChyphenhyphenTLLwL99jh7B2dHjbHZb8nINxe685YcJaHqc429K1NAv91ED9YesB-KFJtFsrCJGAFhXHLY-/s400/01.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large;&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large;&quot;&gt;&lt;b&gt;Primeiro passo&lt;/b&gt;&lt;/span&gt; é criar o formulário com as três opções.&lt;br /&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large;&quot;&gt;Segundo passo&lt;/span&gt;&lt;/b&gt; criar a terceira tabela e inserir a função se.&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large; font-weight: bold;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large; font-weight: bold;&quot;&gt;Terceiro passo&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: inherit;&quot;&gt; aplicar a função SE, da seguinte maneira:&amp;nbsp;&lt;/span&gt;&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;b style=&quot;background-color: #ffe599;&quot;&gt;=SE($R$8=1;C4;SE($R$8=2;C9;SE($R$8=3;SOMA(C4;C9);0)))&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, &#39;Times New Roman&#39;, serif; font-size: large;&quot;&gt;Quarto e último passo&lt;/span&gt;&lt;/b&gt;&amp;nbsp;é&amp;nbsp;criar o gráfico.&lt;br /&gt;
&lt;br /&gt;
Clique&amp;nbsp;&lt;b&gt;&lt;u&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace; font-size: large;&quot;&gt;&lt;a href=&quot;http://www.mediafire.com/?r5cs1tnbfsiqa3f&quot;&gt;AQUI&lt;/a&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&amp;nbsp;para baixar o arquivo.&lt;br /&gt;
&lt;br /&gt;
Saudações a todos.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6839937156476596164/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/09/boa-noite-todos.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6839937156476596164'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6839937156476596164'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/09/boa-noite-todos.html' title='Gráfico com Formulário'/><author><name>Unknown</name><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/AVvXsEj-dbqyLOJNjYwJY37bCTvcAeFhBa-zkXhpqyxP1ZLxL4I3nKq8hom3Zy_xIhFIB8APBCrCigOU8SDa6icoTlcTPjVKqe2cFzqGXpg1nj7vwY6wPpDBCnpSeQsD9bS1GQjholERnNOwE4gv/s72-c/02.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-6395748616651017922</id><published>2011-08-25T00:11:00.000-03:00</published><updated>2011-08-25T00:11:52.814-03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Matriz - Matrizes - MS Office Excel - Intervalor - Renomear Intervalo - Gerenciados de Nomes"/><title type='text'>Matriz - Matrizes - Gerenciador de Nomes</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #cc0000; font-size: large;&quot;&gt;Saudações Pessoas!!!&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Estou publicando um material que aborda o assunto de Matriz (Matrizes).&lt;br /&gt;
&lt;br /&gt;
Como assim Matrizes? Ok, convenhamos, para entender as Matrizes, se faz necessário ter um conhecimento um pouco mais apurado no MS Office Excel.&lt;br /&gt;
&lt;br /&gt;
As Matrizes permitem digitar uma fórmula para um conjunto de células, ao contrário de digitar uma fórmula para cada célula (uso comum das fórmulas).&lt;br /&gt;
&lt;br /&gt;
Geralmente, aplicamos em matrizes as fórmulas comumente utilizadas no dia-a-dia, porém, para concluir a função, precisa pressionar a sequencia CSE (Ctrl + Shift + Enter). O MS Office Excel automaticamente irá inserir as ({}) no início e final da função.&lt;br /&gt;
&lt;br /&gt;
Modelo: &lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;{=SOMA(Qtia*Val_Unit)}&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Nesta fórmula, o MS Office Excel realiza a multiplicação entre cada célula de quantidade e preço unitário e depois faz a soma dos valores.&lt;br /&gt;
&lt;br /&gt;
Para obter o arquivo de exemplo, você pode clicar &lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #073763; font-size: large;&quot;&gt;&lt;a href=&quot;http://www.mediafire.com/?mzcb22kexnd537f&quot;&gt;AQUI!&lt;/a&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Também no exemplo, apliquei a renomeação de intervalos. &lt;br /&gt;
&lt;br /&gt;
Renomeação de intervalos? O que é isso?&lt;br /&gt;
&lt;br /&gt;
Bom, para renomear um intervalo, como no exemplo, o caminho é aba FÓRMULAS // GERENCIADOR DE NOMES.&lt;br /&gt;
&lt;br /&gt;
Em seguida, clicar em novo, digitar o nome desejado do intervalo, há também um espaço para colocar alguma observação e, o próximo passo é selecionar o intervalo que deseja renomear.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6395748616651017922/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/matriz-matrizes-gerenciador-de-nomes.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6395748616651017922'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6395748616651017922'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/matriz-matrizes-gerenciador-de-nomes.html' title='Matriz - Matrizes - Gerenciador de Nomes'/><author><name>Unknown</name><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-9031597378895731609.post-6506720996782733826</id><published>2011-08-16T23:54:00.003-03:00</published><updated>2011-08-17T00:26:55.827-03:00</updated><title type='text'>Contar com dia útil o sábado</title><content type='html'>Muito boa noite.&lt;br /&gt;&lt;br /&gt;Estou publicando este material para atender a solicitação de um amigo e ex-colega de faculdade.&lt;br /&gt;&lt;br /&gt;A solicitação é a seguinte: uma fórmula para contar os dias úteis entre duas datas, considerando os sábados como dia útil. Bom, o Office 2007 (pelo que sei), não possui nenhuma função desse tipo, portanto, precisei incluir algumas funções, sendo elas:&lt;br /&gt;&lt;br /&gt;1) =DIA.DA.SEMANA(G13) &lt;br /&gt;&lt;br /&gt;---&gt; FÓRMULA DIA.DA.SEMANA PARA SABER QUAL DIA DA SEMANA OCORREU A DATA. SÁBADO É IGUAL A 7.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;2) =SOMA((DIATRABALHOTOTAL(H3;I3;J3:J6));CONT.SE(E3:E22;7)) &lt;br /&gt;&lt;br /&gt;---&gt; FÓRMULA DIATRABALHOTOTAL PARA CONTAR QUANTOS DIAS ÚTEIS TEM ENTRE DUAS DATAS (DATA 01 E DATA 02), SE TIVER FERIADOS A SEREM DESCONTADOS, INFORMAR AS DATAS NO CAMPO FERIADOS.				&lt;br /&gt;				&lt;br /&gt;---&gt; CONT.SE CONTARÁ QUANTOS SÁBADOS TEM EM TODAS AS DATAS E SOMARÁ AO DIATRABALHOTOTAL.&lt;br /&gt;				&lt;br /&gt;Para baixar a planilha clique &lt;a href=&quot;http://www.mediafire.com/?s55vv8hkfvpx579&quot;&gt;AQUI!&lt;/a&gt;				&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;No Office 2010 é possível utilizar a fórmula DIATRABALHOTOTAL.INTL que possibilita informar se o sábado é dia útil ou não.				&lt;br /&gt;		&lt;br /&gt;1) =DIATRABALHOTOTAL.INTL(G2;H2;11;I2:I5)		&lt;br /&gt;---&gt; CONTA QUANTOS DIAS ÚTEIS TEM ENTRE DUAS DATAS, PODENDO ESPECIFICAR QUAIS SÃO OS DIAS ÚTEIS.&lt;br /&gt;&lt;br /&gt;Para baixar o arquivo do Office 2010, clique &lt;a href=&quot;http://www.mediafire.com/?ugf9490kh2ftuxd&quot;&gt;AQUI!&lt;/a&gt;		&lt;br /&gt;		&lt;br /&gt;		&lt;br /&gt;Abraço a todos. Dúvida fico a disposição.&lt;br /&gt;		&lt;br /&gt;		&lt;br /&gt;		&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6506720996782733826/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/contar-com-dia-util-o-sabado.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6506720996782733826'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6506720996782733826'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/contar-com-dia-util-o-sabado.html' title='Contar com dia útil o sábado'/><author><name>Unknown</name><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-9031597378895731609.post-8390742826115355273</id><published>2011-08-09T00:22:00.000-03:00</published><updated>2011-09-18T22:08:52.241-03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="IRRF - Imposto de Renda -  INSS"/><category scheme="http://www.blogger.com/atom/ns#" term="Não-Assalariados"/><category scheme="http://www.blogger.com/atom/ns#" term="Salário Pessoa Física"/><title type='text'>Planilha cálculo IR e INSS (atualizada) para PF</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Boa noite!&lt;br /&gt;
&lt;br /&gt;
Atendendo a demanda por material sobre retenções de INSS e Imposto de Renda (IR) sobre as remunerações de pessoa física (PF), estou publicando a planilha atualizada para este cálculo.&lt;br /&gt;
&lt;br /&gt;
Segue o link&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?27214fncsij24ra&quot;&gt;http://www.mediafire.com/?27214fncsij24ra&lt;/a&gt;&amp;nbsp;se não der certo, tente clicar &lt;a href=&quot;http://www.mediafire.com/?27214fncsij24ra&quot;&gt;AQUI&lt;/a&gt;.&lt;br /&gt;
&lt;br /&gt;
Em breve estarei postando um novo conteúdo sobre as retenções de pagamentos de PJ para PJ (este um pouco mais complicado), pois envolve tipos de enquadramento fiscal: Lucro Real, Lucro Presumido e Simples Nacional.&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/8390742826115355273/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/planilha-calculo-ir-e-inss-atualizada.html#comment-form' title='2 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/8390742826115355273'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/8390742826115355273'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/08/planilha-calculo-ir-e-inss-atualizada.html' title='Planilha cálculo IR e INSS (atualizada) para PF'/><author><name>Unknown</name><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>2</thr:total><georss:featurename>Brasil</georss:featurename><georss:point>-14.235004 -51.925279999999987</georss:point><georss:box>-33.915355000000005 -71.865888499999983 5.4453470000000017 -31.984671499999987</georss:box></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-249791471270839816</id><published>2011-06-10T01:00:00.000-03:00</published><updated>2011-06-10T01:00:57.917-03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Microsoft Office Excel - Macro básica - PGTO - IPGTO - PPGTO - TAXA - JUROS - FINANCIAMENTOS E EMPRESTIMO"/><category scheme="http://www.blogger.com/atom/ns#" term="MS Office Excel - Formulários - Planilha Financeira - PV - FV -"/><title type='text'></title><content type='html'>Muito boa noite pessoal!!!&lt;br /&gt;
&lt;br /&gt;
Boa noite mesmo, afinal, agora é 1:00h desta sexta-feira.&amp;nbsp;Okay, chega de conversa e vamos ao assunto:&lt;br /&gt;
&lt;br /&gt;
Estou postando uma planilha para realizar cálculos financeiros (PV, VF, PGTO, PPGTO, IPGTO, TAXA, NPER).&lt;br /&gt;
&lt;br /&gt;
Segue o link:&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.mediafire.com/?99c2978sg4y7cw2&quot;&gt;http://www.mediafire.com/?99c2978sg4y7cw2&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Faço apenas a seguinte observação: Os valores serão apurados de acordo com a informação prestada pelo usuário.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/249791471270839816/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/06/muito-boa-noite-pessoal-boa-noite-mesmo.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/249791471270839816'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/249791471270839816'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/06/muito-boa-noite-pessoal-boa-noite-mesmo.html' title=''/><author><name>Unknown</name><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-9031597378895731609.post-5056085166677734317</id><published>2011-06-08T21:53:00.000-03:00</published><updated>2011-06-08T21:53:32.083-03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Microsoft Office Excel - Macro básica"/><title type='text'>Macro</title><content type='html'>Boa noite a todos.&lt;br /&gt;
&lt;br /&gt;
Estou postando um arquivo bem básico com uma macro gravada.&lt;br /&gt;
&lt;br /&gt;
&quot;Bom dia a todos!!!&quot;&lt;br /&gt;
&lt;br /&gt;
Segue o link:&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.mediafire.com/?95bc79yd0xcpruk&quot;&gt;http://www.mediafire.com/?95bc79yd0xcpruk&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Espero que gostem.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/5056085166677734317/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/06/macro.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5056085166677734317'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5056085166677734317'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/06/macro.html' title='Macro'/><author><name>Unknown</name><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>1</thr:total><georss:featurename>Itapema - SC, Brasil</georss:featurename><georss:point>-27.0909603 -48.611994699999968</georss:point><georss:box>-27.1425603 -48.662580699999971 -27.0393603 -48.561408699999966</georss:box></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-7141644829284901379</id><published>2011-04-28T00:04:00.000-03:00</published><updated>2011-04-28T00:04:17.293-03:00</updated><title type='text'>Video</title><content type='html'>Boa noite a todos.&lt;br /&gt;
&lt;br /&gt;
Mudando um pouco do conteúdo do blog, o link a seguir está disponibilizado um vídeo que dispensa comentários.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.ted.com/talks/lang/por_pt/chimamanda_adichie_the_danger_of_a_single_story.html&quot;&gt;http://www.ted.com/talks/lang/por_pt/chimamanda_adichie_the_danger_of_a_single_story.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Até mais.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/7141644829284901379/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/video.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/7141644829284901379'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/7141644829284901379'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/video.html' title='Video'/><author><name>Unknown</name><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-9031597378895731609.post-5165025191581852072</id><published>2011-04-16T01:28:00.000-03:00</published><updated>2011-04-16T01:28:55.742-03:00</updated><title type='text'>FUNÇÕES FINANCEIRAS</title><content type='html'>Boa noite.&lt;br /&gt;
&lt;br /&gt;
Estou publicando o material com funções financeiras.&lt;br /&gt;
&lt;br /&gt;
Taxa - VF - VP - PGTO - PPGTO - IPGTP - NPER&lt;br /&gt;
&lt;br /&gt;
Taxa - Calcula a taxa de determinada operação financeira.&lt;br /&gt;
&lt;br /&gt;
VF - Calcula o valor do final&amp;nbsp;de determinada operação financeira.&lt;br /&gt;
&lt;br /&gt;
VP - Calcula o valor inicial (capital)&amp;nbsp;de determinada operação financeira.&lt;br /&gt;
&lt;br /&gt;
PGTO - Calculo o valor da parcela para pagamento mensal.&lt;br /&gt;
&lt;br /&gt;
PPGTO - Calcula o valor do capital que será amortizado em determinada parcela.&lt;br /&gt;
&lt;br /&gt;
IPGTO - Apura o valor do juro embutido em determinada parcela.&lt;br /&gt;
&lt;br /&gt;
NPER - Informa o número de períodos que a operação financeira tem.&lt;br /&gt;
&lt;br /&gt;
Segue o LINK para download:&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?mnwlwifql0oognw&quot;&gt;http://www.mediafire.com/?mnwlwifql0oognw&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Abraço a todos.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/5165025191581852072/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/funcoes-financeiras.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5165025191581852072'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5165025191581852072'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/funcoes-financeiras.html' title='FUNÇÕES FINANCEIRAS'/><author><name>Unknown</name><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-9031597378895731609.post-1403062614754161062</id><published>2011-04-15T23:51:00.001-03:00</published><updated>2011-04-16T00:11:29.385-03:00</updated><title type='text'>Formulários - MS Office Excel</title><content type='html'>Boa noite a todos!&lt;br /&gt;
&lt;br /&gt;
Estou publicando uma planilha pra quem desejar praticar um pouco mais sobre FORMULÁRIOS do MS Office Excel.&lt;br /&gt;
&lt;br /&gt;
Esse material será abordado na aula deste sábado, além dos formulários, também trabalha com função básica do SE.&amp;nbsp;&lt;b&gt;LINK 1&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Também estou aproveitando para publicar outra planilha com formulários, já publicada anteriormente, mas esta fiz algumas pequenas alterações. Trata-se de formulários abrangendo ÍNDICE, PROCH e SE. É uma planilha para pesquisa de preço de vários produtos que seus preços alteram por país.&amp;nbsp;&lt;b&gt;LINK 2&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
As planilhas estão bloqueadas mas a senha está em cada material.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;LINK 1:&amp;nbsp;&lt;/b&gt;&lt;a href=&quot;http://www.mediafire.com/?jxq3c82q879ry23&quot;&gt;http://www.mediafire.com/?jxq3c82q879ry23&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;LINK 2:&amp;nbsp;&lt;/b&gt;&lt;a href=&quot;http://www.mediafire.com/?07ad1x4o72hu4we&quot;&gt;http://www.mediafire.com/?07ad1x4o72hu4we&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Se alguém desejar receber por email o material cada vez que houver publicação neste blog, ao lado esquerdo tem a opção de cadastrar o email.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/1403062614754161062/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/formularios-ms-office-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1403062614754161062'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1403062614754161062'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/formularios-ms-office-excel.html' title='Formulários - MS Office Excel'/><author><name>Unknown</name><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-9031597378895731609.post-194318195810822611</id><published>2011-04-12T23:32:00.000-03:00</published><updated>2011-04-12T23:32:25.387-03:00</updated><title type='text'>Atalhos do Excel - Doze (12) atalhos para facilitar sua vida no EXCEL</title><content type='html'>Olá...&lt;br /&gt;
&lt;br /&gt;
Estou disponibilizando alguns atalhos (comandos) do MS Office Excel:&lt;br /&gt;
&lt;br /&gt;
1) - Se você estiver inserindo uma fórmula e esta fórmula for muito&amp;nbsp;extensa, é possível &quot;quebrar&quot; linha para melhor entendimento. Basta pressionar Alt + Enter.&lt;br /&gt;
&lt;br /&gt;
2) - Ocultar ou Exibir as fórmulas de uma planilha. Pressione Ctrl + ` (acento grave / crase).&lt;br /&gt;
&lt;br /&gt;
3) - Para mostrar as fórmulas em formato de texto, basta inserir um apóstrofo antes de cada fórmula. Ex. &#39;=SOMA(A1:A5)&lt;br /&gt;
&lt;br /&gt;
4) - Formatando o estilo da célula: GERAL &amp;nbsp;---&amp;gt; Ctrl + ~&lt;br /&gt;
&lt;br /&gt;
5) - Formatando o estilo da célula: NUMÉRICO ---&amp;gt; Ctrl + !&lt;br /&gt;
&lt;br /&gt;
6) - Formatando o estilo da célula: MOEDA ---&amp;gt; Ctrl + $&lt;br /&gt;
&lt;br /&gt;
7) - Formatando o estilo da célula: PORCENTAGEM ---&amp;gt; Ctrl + %&lt;br /&gt;
&lt;br /&gt;
8) - Formatando o estilo da célula: CIENTÍFICO ---&amp;gt; Ctrl + ^&lt;br /&gt;
&lt;br /&gt;
9) - Formatando o estilo da célula: dd/mmm/aa ---&amp;gt; Ctrl + #&lt;br /&gt;
&lt;br /&gt;
10) - Formatando o estilo da célula: hh:mm&amp;nbsp;---&amp;gt; Ctrl + @&lt;br /&gt;
&lt;br /&gt;
11) - Formatando o estilo da célula: Data atual (dd/mm/aaaa) ---&amp;gt; Ctrl + ;&lt;br /&gt;
&lt;br /&gt;
12) - Formatando o estilo da célula: Hora Atual (hh:mm) ---&amp;gt; Ctrl + :&lt;br /&gt;
&lt;br /&gt;
Espero que essas dicas agilizem o trabalho com o Excel.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
JOÃO CARLOS BASSO&lt;br /&gt;
&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: xx-small;&quot;&gt;Material extraído do livro: Fórmulas e Funções com Microsoft Office Excel 2007 - Paul McFedries&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/194318195810822611/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/atalhos-do-excel-doze-12-atalhos-para.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/194318195810822611'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/194318195810822611'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/atalhos-do-excel-doze-12-atalhos-para.html' title='Atalhos do Excel - Doze (12) atalhos para facilitar sua vida no EXCEL'/><author><name>Unknown</name><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-9031597378895731609.post-7326783823921375123</id><published>2011-04-12T21:33:00.000-03:00</published><updated>2011-04-12T21:33:26.529-03:00</updated><title type='text'>Soma(Se</title><content type='html'>&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;Hoje me deparei com o seguinte problema no trabalho:&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;_Precisava inserir uma função de soma&amp;nbsp;que trouxesse o&amp;nbsp;saldo atualizado da posição financeira do cliente, de acordo com uma data especifica. Modelo:&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;O cliente realizou a compra no valor de R$ 10.000 e estava pagando determinado valor por mês.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;01/02/2011 Pagou R$ 1.000&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;05/02/2011 Pagou R$ 1.500&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;03/03/2011 Pagou R$&amp;nbsp;2.000&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;Eu precisava, por exemplo, o saldo que ele já havia pago até 05/02.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;Primeiramente tentei inserir o SOMASE, porém o&amp;nbsp;critério inserido &quot;&amp;gt;=data&quot; não funcionou.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;=SOMASE($E$4:$E$14;&quot;&amp;lt;=E4&quot;;$F$&lt;wbr&gt;&lt;/wbr&gt;4:$F$14) &amp;nbsp; ------ não funcionou, estava dando erro.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;A segunda alternativa foi elaborar a seguinte fórmula:&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;{=SOMA(SE(($E$4:$E$14&amp;lt;=E4);$F$&lt;wbr&gt;&lt;/wbr&gt;4:$F$14;0))}&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br clear=&quot;all&quot; /&gt;&lt;strong&gt;Essa sim deu certo.&lt;/strong&gt;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif;&quot;&gt;Mas tem um detalhe, para ela funcionar, é necessário, ao terminar de digitar a fórmula (depois de fechar os parenteses)&amp;nbsp;pressionar:&amp;nbsp;&lt;strong&gt;CTRL + SHIFT + ENTER&lt;/strong&gt;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;As chaves &quot;{&amp;nbsp; }&quot; o&amp;nbsp;Excel insere automaticamente.&amp;nbsp;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: x-small;&quot;&gt;Segue o&lt;/span&gt;&lt;b&gt; link&lt;/b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: x-small;&quot;&gt; para baixar o arquivo com a fórmula.&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;a href=&quot;http://www.mediafire.com/?1a182aq89wrvvb7&quot;&gt;http://www.mediafire.com/?1a182aq89wrvvb7&lt;/a&gt;&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;Espero que todos façam bom proveito desta fórmula.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;Att.&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;João Carlos BASSO&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/7326783823921375123/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/somase.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/7326783823921375123'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/7326783823921375123'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/somase.html' title='Soma(Se'/><author><name>Unknown</name><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-9031597378895731609.post-446239997922366797</id><published>2011-04-04T21:28:00.001-03:00</published><updated>2011-09-18T22:09:53.981-03:00</updated><title type='text'>Planilha IR e INSS (atualizada)</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Olá!&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Boa noite a todos.&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Estou disponibilizando a planilha atualizada para cálculo do Imposto de Renda (IR) e INSS do ano de 2011.&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;Ressalto que esta planilha substitui a anterior, uma vez que a tabela de IR foi reajustada, conforme&amp;nbsp;a Instrução Normativa RFB nº 1142, de 31 de março de 2011, publicada no DOU de 01.04.2011.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;b&gt;&lt;u&gt;LINK&amp;nbsp;&lt;/u&gt;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;a href=&quot;http://www.mediafire.com/?27214fncsij24ra&quot;&gt;http://www.mediafire.com/?27214fncsij24ra&lt;/a&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;Portanto, ao calcular o valor dos impostos, deve-se informar a competência do serviço, para que seja calculado corretamente, pois de Janeiro até Março é uma tabela, de Abril até Dezembro de 2011 é outra.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;Espero que façam bom uso.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;Att.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;border-collapse: collapse;&quot;&gt;&lt;b&gt;João Carlos BASSO&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/446239997922366797/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/planilha-ir-e-inss-atualizada.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/446239997922366797'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/446239997922366797'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/planilha-ir-e-inss-atualizada.html' title='Planilha IR e INSS (atualizada)'/><author><name>Unknown</name><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-9031597378895731609.post-6746669749004504188</id><published>2011-04-01T00:12:00.000-03:00</published><updated>2011-04-01T00:12:53.152-03:00</updated><title type='text'>Formulários</title><content type='html'>Boa noite,&lt;br /&gt;
&lt;br /&gt;
Estou disponibilizando uma planilha com aplicação de formulários.&lt;br /&gt;
&lt;br /&gt;
Ressalto, é importante observar que algumas colunas estão ocultas.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;LINK:&lt;/u&gt;&amp;nbsp;&lt;/b&gt;&lt;a href=&quot;http://www.mediafire.com/?oyfjyck3rt3qe6l&quot;&gt;http://www.mediafire.com/?oyfjyck3rt3qe6l&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6746669749004504188/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/formularios.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6746669749004504188'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6746669749004504188'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/04/formularios.html' title='Formulários'/><author><name>Unknown</name><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-9031597378895731609.post-9187897745395144910</id><published>2011-03-30T00:08:00.000-03:00</published><updated>2011-03-30T00:08:36.124-03:00</updated><title type='text'>Planilha com funções SOMASES e CONT.SES</title><content type='html'>Olá,&lt;br /&gt;
&lt;br /&gt;
No link a seguir você terá acesso à planilha com funções aplicadas ao SOMASES e CONT.SES.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;Link:&lt;/u&gt;&lt;/b&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?g2pixe4qdd6m82y&quot;&gt;http://www.mediafire.com/?g2pixe4qdd6m82y&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;=SOMASES&lt;/u&gt;&lt;/b&gt;(intervalo de valores para somar; intervalo de critérios 01; critério 01;&amp;nbsp;intervalo de critérios 02; critério 02; ...)&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;=CONT.SES&lt;/u&gt;&lt;/b&gt;(intervalo de critérios 01; critério 01;&amp;nbsp;intervalo de critérios 02; critério 02; ...)&lt;br /&gt;
&lt;br /&gt;
&lt;i&gt;&lt;u&gt;&lt;b&gt;Sucesso!&lt;/b&gt;&lt;/u&gt;&lt;/i&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/9187897745395144910/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-funcoes-somases-e-contses.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/9187897745395144910'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/9187897745395144910'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-funcoes-somases-e-contses.html' title='Planilha com funções SOMASES e CONT.SES'/><author><name>Unknown</name><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-9031597378895731609.post-64954263897565227</id><published>2011-03-30T00:02:00.000-03:00</published><updated>2011-03-30T00:02:20.424-03:00</updated><title type='text'>Planilha com funções do SE e SE(E</title><content type='html'>Boa noite a todos!&lt;br /&gt;
&lt;br /&gt;
Estou disponibilizando uma planilha para calcular o valor de INSS de acordo com a tabela vigente da previdência social.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.mediafire.com/?x999ex5crocmmkn&quot;&gt;http://www.mediafire.com/?x999ex5crocmmkn&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
São duas planilhas, uma com todas as fórmulas (resolvida) e, outra, para resolver.&lt;br /&gt;
&lt;br /&gt;
As fórmulas utilizadas nesta planilha são SE e SE(E (...)</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/64954263897565227/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-funcoes-do-se-e-see.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/64954263897565227'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/64954263897565227'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-funcoes-do-se-e-see.html' title='Planilha com funções do SE e SE(E'/><author><name>Unknown</name><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-9031597378895731609.post-6392102533052417274</id><published>2011-03-27T12:44:00.000-03:00</published><updated>2011-03-27T12:44:20.799-03:00</updated><title type='text'>Estoque</title><content type='html'>Estou disponibilizando o arquivo para &lt;b&gt;&lt;u&gt;controle básico do estoque com cálculo do custo pela média ponderada.&lt;/u&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Algumas células estão bloqueadas para edição.&lt;br /&gt;
&lt;br /&gt;
&lt;b style=&quot;text-decoration: underline;&quot;&gt;Link:&lt;/b&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?8tchz0v4p8c9aft&quot;&gt;http://www.mediafire.com/?8tchz0v4p8c9aft&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos BASSO</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/6392102533052417274/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/estoque.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6392102533052417274'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/6392102533052417274'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/estoque.html' title='Estoque'/><author><name>Unknown</name><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-9031597378895731609.post-1879984676784020642</id><published>2011-03-27T09:59:00.000-03:00</published><updated>2011-03-27T09:59:13.922-03:00</updated><title type='text'>Planilha com PROCV e PROCH</title><content type='html'>Olá!&lt;br /&gt;
&lt;br /&gt;
Continuando os assuntos abordados em sala de aula, estou disponibilizando duas planilhas com &lt;b&gt;PROCV&lt;/b&gt; e &lt;b&gt;PROCH&lt;/b&gt;, juntamente com &lt;b&gt;SE(ÉERROS (...)&lt;/b&gt; uma com o exercício &lt;b&gt;RESOLVIDO&lt;/b&gt; e outra para &lt;b&gt;RESOLVER&lt;/b&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;Link RESOLVIDO:&lt;/u&gt;&lt;/b&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?kcwpu93clcucmi0&quot;&gt;http://www.mediafire.com/?kcwpu93clcucmi0&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;Link RESOLVER:&lt;/u&gt;&lt;/b&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?nnfgnzn3ddyd449&quot;&gt;http://www.mediafire.com/?nnfgnzn3ddyd449&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;EXPLICAÇÃO:&lt;/u&gt;&lt;/b&gt; Tanto o PROCH quanto o PROCV, são fórmulas utilizadas para localização. Enquanto o PROCH realiza a procura horizontal na primeira linha da tabela matriz, o PROCV realiza a procura na vertical na primeira coluna da tabela matriz.&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;&lt;b&gt;=PROCH&lt;/b&gt;&lt;/u&gt;(célula digitavel; tabela matriz/origem; número da linha que deseja a resposta; FALSO)&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;=PROCV&lt;/u&gt;&lt;/b&gt;(célula digitavel; tabela matriz/origem; número coluna que deseja a resposta; FALSO)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Vale ressaltar que, para melhorar a estética de nossa planilha colocamos junto às formulas do PROCH e PROCV as funções SE e ÉERROS, ficando da seguinte maneira:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;=SE(ÉERROS(PROCV(&lt;/b&gt;célula digitavel; tabela matriz/origem; número coluna que deseja a resposta; FALSO));&quot;&quot;;PROCV(célula digitavel; tabela matriz/origem; número coluna que deseja a resposta; FALSO))&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;=SE(ÉERROS(PROCH(&lt;/b&gt;célula digitavel; tabela matriz/origem; número da linha que deseja a resposta; FALSO));&quot;&quot;;PROCH(célula digitavel; tabela matriz/origem; número da linha que deseja a resposta; FALSO))&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Não se esqueçam de congelar determinadas células $.</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/1879984676784020642/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-procv-e-proch.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1879984676784020642'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1879984676784020642'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/planilha-com-procv-e-proch.html' title='Planilha com PROCV e PROCH'/><author><name>Unknown</name><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>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-5432965819226367304</id><published>2011-03-27T09:34:00.000-03:00</published><updated>2011-03-27T09:34:33.861-03:00</updated><title type='text'>Exercício Excel com Função SOMASES</title><content type='html'>Bom dia a todos,&lt;br /&gt;
&lt;br /&gt;
A seguir está disponibilizado o arquivo em Excel com exercício, &lt;b&gt;RESOLVIDO&lt;/b&gt; e outro para &lt;b&gt;RESOLVER&lt;/b&gt; &amp;nbsp;da função &lt;b&gt;SOMASES&lt;/b&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;u style=&quot;font-weight: bold;&quot;&gt;LINK RESOLVIDO:&lt;/u&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?g2pixe4qdd6m82y&quot;&gt;http://www.mediafire.com/?g2pixe4qdd6m82y&lt;/a&gt;&lt;br /&gt;
&lt;b&gt;&lt;u&gt;&lt;br /&gt;
&lt;/u&gt;&lt;/b&gt;&lt;br /&gt;
&lt;u style=&quot;font-weight: bold;&quot;&gt;LINK RESOLVER:&lt;/u&gt;&amp;nbsp;&lt;a href=&quot;http://www.mediafire.com/?k3d1wc8855d0p28&quot;&gt;http://www.mediafire.com/?k3d1wc8855d0p28&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;&lt;b&gt;EXPLICAÇÃO:&lt;/b&gt;&lt;/u&gt;&amp;nbsp;esta função mistura a SOMA com o teste de lógica SE. Através dela podemos realizar somas com vários critérios.&lt;br /&gt;
&lt;br /&gt;
&lt;i&gt;&lt;b&gt;&lt;u&gt;=SOMASES&lt;/u&gt;&lt;/b&gt;(intervalo de soma; intervalo de critérios 01; critério 01; intervalo de critérios 02; critério 02; intervalo de critérios 03; critérios 03)&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;u style=&quot;font-weight: bold;&quot;&gt;EXEMPLO:&lt;/u&gt;&amp;nbsp;Possuo uma planilha de vendas onde diariamente são preenchidos os dados com data, nome do vendedor, nome do cliente e valor. Através do SOMASES, podemos realizar somas filtrando determinadas informações, como pelo nome do vendedor e a data da venda.</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/5432965819226367304/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/exercicio-excel-com-funcao-somases.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5432965819226367304'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5432965819226367304'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/03/exercicio-excel-com-funcao-somases.html' title='Exercício Excel com Função SOMASES'/><author><name>Unknown</name><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-9031597378895731609.post-2474870591857503566</id><published>2011-02-23T00:08:00.002-03:00</published><updated>2011-09-18T22:10:18.231-03:00</updated><title type='text'>Arquivo para Download - Calculo de INSS e IR - PF</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Estou de volta,&lt;br /&gt;
&lt;br /&gt;
Acredito que o link abaixo irá abrir uma nova página para fazer o download...&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.mediafire.com/?27214fncsij24ra&quot;&gt;http://www.mediafire.com/?27214fncsij24ra&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Interessados podem clicar e baixar o arquivo. Ele fará o cálculo simples do IR ou INSS, descontando da base de cálculo a pensão alimentícia e o número de dependentes. Fica limitado a isso.&lt;br /&gt;
&lt;br /&gt;
Se precisarem de um arquivo mais completo, podem entrar em contato.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos Basso&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/2474870591857503566/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/arquivo-para-download-calculo-de-inss-e.html#comment-form' title='3 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/2474870591857503566'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/2474870591857503566'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/arquivo-para-download-calculo-de-inss-e.html' title='Arquivo para Download - Calculo de INSS e IR - PF'/><author><name>Unknown</name><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>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-5687826823596054191</id><published>2011-02-22T23:42:00.001-03:00</published><updated>2011-08-09T00:15:26.288-03:00</updated><title type='text'>Planilha cálculo IR e INSS</title><content type='html'>Boa noite a todos...&lt;br /&gt;
&lt;br /&gt;
Fiquei um certo tempo esta noite preparando uma planilha para cálculo do IR e INSS sobre assalariados e não-assalariados. Devido a isso, pretendia publicar a planilha para os interessados, porém, não sei onde ou como faço para anexo o arquivo neste blog.&lt;br /&gt;
&lt;br /&gt;
Segue o link:&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.mediafire.com/?06d0xrgghd7pix6&quot;&gt;http://www.mediafire.com/?06d0xrgghd7pix6&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos Basso</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/5687826823596054191/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/planilha-calculo-ir-e-inss.html#comment-form' title='7 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5687826823596054191'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/5687826823596054191'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/planilha-calculo-ir-e-inss.html' title='Planilha cálculo IR e INSS'/><author><name>Unknown</name><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>7</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9031597378895731609.post-8286117555978528699</id><published>2011-02-21T21:30:00.000-03:00</published><updated>2011-02-21T21:30:07.739-03:00</updated><title type='text'>Funções Básicas do MS Office Excel</title><content type='html'>Ninguém nasce sabendo, para todas as atividades, sempre tem os primeiros passos a serem seguidos. Pro Excel isso também funciona. Então, pensando nisso, estarei passando algumas das funções básicas e que são extremamente úteis no dia-a-dia.&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;=SOMA( )&lt;/span&gt;&lt;/b&gt;&amp;nbsp;essa função, como o próprio nome diz, serve para realizar a soma das células. Para que sua aplicação seja efetiva, é necessário digitar a fórmula na célula =Soma e, em seguida, faz-se necessário abrir parênteses, selecionar as células que farão parte da soma e, após, fechar os parênteses e pressionar enter.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;=MULT( )&lt;/span&gt;&lt;/b&gt;: essa função tem o objetivo de multiplicar as células.&amp;nbsp;&amp;nbsp;Para que sua aplicação seja efetiva, é necessário digitar a fórmula na célula =MULT e, em seguida, faz-se necessário abrir parênteses, selecionar as células que farão parte da multiplicação e, após, fechar os parênteses e pressionar enter.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;=MÁXIMO( )&lt;/span&gt;&lt;/b&gt;: o objetivo dessa fórmula é, numa série de valores, apontar o valor mais alto.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;=MÍNIMO( )&lt;/b&gt;&lt;/span&gt;: esta fórmula aponta o menor valor em um determinado número de células.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;=MÉDIA( )&lt;/span&gt;&lt;/b&gt;: a média, como podemos supor, calcula a média entre determinado número de células.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;=CONT.VALOR( )&lt;/b&gt;&lt;/span&gt;: conta quantas células não estão vazias, ou seja, quantas células estão preenchidas com algum formato de caractere ou número.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;=CONT.NÚM( )&lt;/b&gt;&lt;/span&gt;: conta quantas células estão preenchidas com números. Desta maneira, essa função não contará as células que contenham &quot;letras&quot; ou estejam vazias.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;Façam bom uso destas informações. No próximo post irei abordar outras.&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;João Carlos Basso&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/8286117555978528699/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/funcoes-basicas-do-ms-office-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/8286117555978528699'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/8286117555978528699'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/funcoes-basicas-do-ms-office-excel.html' title='Funções Básicas do MS Office Excel'/><author><name>Unknown</name><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-9031597378895731609.post-3103002497108401475</id><published>2011-02-20T23:31:00.003-03:00</published><updated>2011-02-21T21:32:22.738-03:00</updated><title type='text'>Atalhos do MS Office Excel</title><content type='html'>O primeiro tema abordado será sobre alguns atalhos que são bastante úteis no dia-a-dia de quem trabalha com o MS Office Excel.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;&lt;li&gt;Para passar de uma planilha a outra no mesmo arquivo, sem utilizar o mouse, somente o teclado:&lt;/li&gt;
&lt;/ul&gt;Pressione: &lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;CTRL + PAGE UP&lt;/span&gt;&lt;/b&gt; ou &lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;CTRL + PAGE DOWN&lt;/b&gt;&lt;/span&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;&lt;li&gt;Se você tem várias células e deseja alterar somente algum caractere, ou seja, por exemplo, se você tem uma planilha onde as células A3 até B9 possuem vários caracteres ou valores, e seu desejo é alterar um dado específico, como a letra &quot;M&quot;.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;Selecione as células que deseja alterar os dados e, em seguida, pressione:&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt; CTRL + L&lt;/b&gt;&lt;/span&gt;, irá abrir uma janela com a opção de localizar. Digite no campo &quot;localizar&quot; a letra &quot;M&quot; e na aba superior, clique em &quot;Substituir&quot;, no campo &quot;substituir&quot; digite a informação que deseja substituir pela letra &quot;M&quot; e em seguida, clique em &quot;substituir tudo&quot;. Pronto, as células que possuíam a letra &quot;M&quot;, serão alteradas pelo valor informado.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;ul&gt;&lt;li&gt;A terceira e última dica de hoje vai para quem precisa passar os valores que estão em colunas para linhas e/ou linhas para colunas.&lt;/li&gt;
&lt;/ul&gt;&lt;div&gt;Selecione os valores que estão nas linhas ou colunas, em seguida pressione CTRL + C (copiar). Feito isso, clique na célula onde deseja que a nova relação de valores seja colada, depois pressione &lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;CTRL + ALT + V&lt;/span&gt;&lt;/b&gt; (colar especial). Vai abrir uma nova janela, nesta janela você seleciona a opção transpor e em seguida clica em ok. Processo feito e problema solucionado.&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;Espero ter contribuido/ajudado com essas três super dicas.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;Att.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;João Carlos Basso&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/3103002497108401475/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/funcoes-de-dias-para-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/3103002497108401475'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/3103002497108401475'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/funcoes-de-dias-para-excel.html' title='Atalhos do MS Office Excel'/><author><name>Unknown</name><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-9031597378895731609.post-1650747606611407407</id><published>2011-02-20T22:47:00.001-03:00</published><updated>2011-02-20T23:04:07.980-03:00</updated><title type='text'>Início</title><content type='html'>Olá!&lt;br /&gt;
&lt;br /&gt;
Primeiramente, desejo me apresentar:&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;Meu nome é João Carlos Basso trabalho com Contabilidade e Finanças, além de dar aulas no curso de Excel e curso de Departamento Financeiro.&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
A partir de hoje, tentarei publicar assuntos sobre os mais diversos temas de Finanças e Contabilidade, e também espero conseguir contribuir com o desenvolvimento do conhecimento dos usuários&amp;nbsp;do MS Office Excel com fórmulas/funções e ferramentas.&lt;br /&gt;
&lt;br /&gt;
Em cada postagem buscarei contribuir com uma informação diferente, para que fique fácil o acesso à cada tema.&lt;br /&gt;
&lt;br /&gt;
No próximo post estarei iniciando o material.&lt;br /&gt;
&lt;br /&gt;
Att.&lt;br /&gt;
&lt;br /&gt;
João Carlos Basso</content><link rel='replies' type='application/atom+xml' href='http://blogdoexcel.blogspot.com/feeds/1650747606611407407/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/inicio.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1650747606611407407'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9031597378895731609/posts/default/1650747606611407407'/><link rel='alternate' type='text/html' href='http://blogdoexcel.blogspot.com/2011/02/inicio.html' title='Início'/><author><name>Unknown</name><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>