Aprendendo Excel

O Microsoft Excel inclui quatro tipos diferentes de operadores de cálculo: aritméticos, de comparação, de texto e de referência.

Operadores aritméticos 

Para efetuar operações matemáticas básicas, como adição, subtração ou multiplicação.

Operador
Significado e (exemplo.)
+ (sinal de mais) Adição (1+1)
(sinal de menos) Subtração (2–1)
Negação (–1)
* (asterisco) Multiplicação (1*1)
/ (sinal de divisão) Divisão (1/1)
% (sinal de porcentagem) Porcentagem (10%)
^ (acento circunflexo) Exponenciação (10^2)

Operadores de comparação     

Ao comparar dois valores usando esses operadores, o resultado é um valor lógico, VERDADEIRO ou FALSO.

Operador de comparação Significado (exemplo)
= (sinal de igual) Igual a (A1=B1)
> (sinal de maior que) Maior que (A1>B1)
< (sinal de menor que) Menor que (A1<B1)
>= (sinal de maior ou igual a) Maior ou igual a (A1>=B1)
<= (sinal de menor ou igual a) Menor ou igual a (A1<=B1)
<> (sinal de diferente de) Diferente de (A1<>B1)

Operador de concatenação de texto

Use o ‘E’ comercial (&) para associar, ou concatenar, uma ou mais sequências de caracteres de texto.

Operador de texto Significado (exemplo)
& (E comercial) Conecta, ou concatena, dois valores para produzir um valor de texto contínuo (“mal”&”sucedido”)

Operadores de referência     

Combine intervalos de células para cálculos com estes operadores.

Operador de referência Significado (exemplo)
: (dois-pontos) Operador de intervalo, que produz uma referência para todas as células entre duas referências, incluindo as duas referências (B5:B15)
, (vírgula) Operador de união, que combina diversas referências em uma referência (SOMA(B5:B15,D5:D15))
 (espaço) Operador de interseção, que produz sobre referência a células comuns a duas referências (B7:D7 C6:C8)

As fórmulas calculam valores segundo uma ordem específica. Uma fórmula no Excel sempre começa com um sinal de igual (=). O sinal de igual informa ao Excel que os caracteres a seguir constituem uma fórmula.
O Excel calcula a fórmula da esquerda para a direita, de acordo com uma ordem específica para cada operador da fórmula.

Ao utilizar vários operadores o Excel vai seguir a ordem especifica mostrada abaixo.
OBS: lembrando que é possível alterar esta ordem veja mais abaixo como fazer.

Operador Descrição
: (dois-pontos)(espaço simples), (vírgula) Operadores de referência
Negação (como em –1)
% Porcentagem
^ Exponenciação
* e / Multiplicação e divisão
+ e – Adição e subtração
& Conecta duas sequências de texto (concatenação)
=
< >
<=
>=
<>
Comparação

Alterando a ordem de operação do Excel

Para alterar a ordem da avaliação, use parênteses na parte da fórmula a ser calculada primeiro.  a fórmula a seguir retornará 20 porque o Excel calcula a multiplicação antes da adição. A fórmula multiplica 2 por 5 e, em seguida, soma 10 ao resultado.

=10+2*5

Por outro lado, se você usar parênteses irá alterar a ordem, o Excel irá somar 10 e 2 e, em seguida, multiplicará o resultado por 5 e o total será 60.

=(10+2)*5

note que no primeiro exemplo o resultado é 20 e no segundo é 60 o que alteraria qualquer trabalho que esteja sendo executado no Excel com uma diferença de valores muito grande.

abaixo, os parênteses no inicio da fórmula forçam o Excel a calcular B1+100 primeiro e, em seguida, dividir o resultado pela soma dos valores nas células D1, E1 e F1.

=(B1+100)/SOMA(D1:F1)

espero ter ajudado e em breve novas atualizações aqui.

grt
DavidGois

 lista e matérias e exemplos publicados aqui no blog:

 

63.778 thoughts to “Aprendendo Excel”

  1. I wish to express my appreciation to this writer just for rescuing me from this setting. As a result of checking throughout the online world and obtaining solutions which are not pleasant, I assumed my entire life was over. Existing without the strategies to the issues you’ve fixed through your guide is a serious case, and the kind that would have in a wrong way damaged my entire career if I hadn’t discovered your web blog. Your personal talents and kindness in dealing with every part was useful. I’m not sure what I would have done if I had not come across such a step like this. I can at this time look ahead to my future. Thanks a lot very much for your skilled and results-oriented help. I won’t be reluctant to suggest the blog to any individual who ought to have counselling on this subject.

  2. I am commenting to let you be aware of of the magnificent discovery our child had studying the blog. She discovered such a lot of things, with the inclusion of what it’s like to have a great teaching heart to have other individuals without problems know just exactly chosen advanced matters. You actually exceeded our own expectations. Thank you for rendering such productive, healthy, educational and also cool tips on the topic to Emily.

  3. Hey would you mind letting me know which webhost you’re working with?
    I’ve loaded your blog in 3 completely different internet browsers and I
    must say this blog loads a lot faster then most.
    Can you suggest a good web hosting provider at a fair price?
    Thanks a lot, I appreciate it!

  4. It’s very easysimpletrouble-freestraightforwardeffortless to find out any topicmatter on netweb as compared to bookstextbooks, as I found this articlepostpiece of writingparagraph at this websiteweb sitesiteweb page.

  5. The Red Flag Law provides all necessary procedural safeguards to ensure that no firearm is removed without due process while ensuring that tragedies, like the school shooting in Parkland, Florida, are not repeated.

  6. With havin so much content do you ever run into any
    issues of plagorism or copyright infringement? My blog has a lot of unique
    content I’ve either authored myself or outsourced but it looks
    like a lot of it is popping it up all over the web without my authorization. Do you know any ways to help reduce content from being ripped off?
    I’d definitely appreciate it.

  7. Thanks so much for giving everyone remarkably splendid chance to read critical reviews from this site. It’s always so excellent plus jam-packed with amusement for me personally and my office fellow workers to search your blog at minimum three times in a week to read the new issues you have. And lastly, I’m just actually fulfilled with all the great hints you give. Some 3 areas in this post are definitely the most effective we have all ever had.

  8. I would like to express my thanks to the writer for bailing me out of this type of predicament. Because of browsing throughout the search engines and finding opinions which were not productive, I assumed my life was gone. Existing minus the approaches to the issues you have fixed through your article is a crucial case, and the ones that might have adversely affected my entire career if I had not discovered your web page. The mastery and kindness in maneuvering all areas was crucial. I’m not sure what I would’ve done if I had not come upon such a point like this. I can also now look forward to my future. Thanks a lot very much for the skilled and result oriented guide. I will not hesitate to propose your web site to anyone who would like guidelines on this issue.

  9. I want to voice my love for your generosity for women who require help on this concept. Your special dedication to passing the solution all around has been especially insightful and has consistently made workers like me to realize their targets. Your amazing invaluable report entails a lot to me and substantially more to my peers. Thank you; from everyone of us.

  10. I am only commenting to make you understand what a amazing discovery my friend’s child enjoyed studying yuor web blog. She picked up a wide variety of things, which include how it is like to have an amazing teaching heart to make certain people quite simply understand a variety of grueling subject areas. You undoubtedly surpassed people’s expected results. Many thanks for producing these invaluable, dependable, edifying and easy tips about that topic to Lizeth.

  11. I intended to post you the little word in order to say thanks over again relating to the precious techniques you’ve shared in this article. This has been certainly tremendously generous with you to deliver unreservedly what exactly a lot of people could have supplied as an electronic book to help with making some profit for themselves, and in particular considering the fact that you might have tried it if you desired. These points in addition acted like a fantastic way to be certain that other people have a similar interest like mine to figure out much more pertaining to this matter. I am certain there are several more pleasant opportunities in the future for folks who see your blog post.

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *