Tagged: Excel

Como abrir um arquivo DTC (Ctree) no Excel (importando arquivo texto)

No artigo de hoje, irei mostrar como abrir arquivos DTC (Ctree) no Excel.

24 de junho de 2021

Aplicativos e Serviços / Windows

Como mudar a forma de comentários no Excel

Hoje vou mostrar como mudar o desenho das formas de comentário no Excel.

2 de setembro de 2020

Excel

Função que converte um arquivo do IXBLOG transformando em um Excel para análise dos dados

Sabe aquele arquivo do IXBLOG gerado que é necessário validar? Imagina ter uma função que transforme em Excel, e deixe mais fácil a leitura.

26 de setembro de 2019

Excel

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" />

Aplicativos e Serviços / Windows

Como fixar um cabeçalho para ser impresso no Excel

Você já precisou imprimir uma planilha do Excel e queria que o título das colunas se repetisse em todas as páginas?

7 de agosto de 2019

Excel

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" />

Tabela com Lista de CEPs do Brasil

Precisei fazer uma pesquisa recentemente, e decidi disponibilizar o arquivo do Excel que montei com todos os CEPs.

12 de janeiro de 2019

Excel

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Excel" decoding="async" loading="lazy" data-attachment-id="9063" data-permalink="https://terminaldeinformacao.com/2017/11/08/como-totalizar-horas-excel/excel/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" data-orig-size="640,338" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel" data-image-description="<p>Excel</p> " data-image-caption="<p>Excel</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=300%2C158&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2017/07/excel.png?fit=640%2C338&ssl=1" />

Tutoriais e Dicas

Como totalizar horas no Excel

Olá pessoal… Hoje vou mostrar como somar horas no excel, e deixar o resultado certo para a visualização.

8 de novembro de 2017