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 needed to compose you a tiny word to say thanks a lot again with the gorgeous pointers you’ve provided here. It was seriously generous of you to present freely just what numerous people could possibly have distributed for an ebook to earn some money for themselves, principally given that you could possibly have done it in case you decided. These tricks also worked to be a great way to comprehend some people have the same fervor just like my own to realize more and more when considering this problem. Certainly there are many more pleasant instances up front for folks who read through your blog post.

  2. I have to convey my gratitude for your generosity in support of visitors who have the need for help with this important subject. Your very own dedication to getting the message all-around had been surprisingly important and have frequently empowered girls just like me to achieve their desired goals. This important tips and hints implies a whole lot a person like me and somewhat more to my colleagues. Many thanks; from each one of us.

  3. I must express my respect for your kind-heartedness for folks that must have help on your issue. Your very own dedication to getting the solution throughout turned out to be unbelievably informative and has regularly empowered regular people just like me to attain their targets. Your amazing important suggestions entails so much a person like me and especially to my office workers. Best wishes; from all of us.

  4. Thank you a lot for giving everyone an exceptionally splendid opportunity to read from this website. It is usually very lovely and as well , full of a good time for me and my office mates to visit your website at a minimum 3 times per week to learn the newest guidance you will have. And indeed, I’m also always fulfilled with your striking advice served by you. Selected 3 facts on this page are absolutely the simplest we’ve had.

  5. HelpfulUsefulValuable infoinformation. FortunateLucky me I foundI discovered your siteweb sitewebsite accidentallyby chanceby accidentunintentionally, and I amI’m surprisedstunnedshocked why this twist of fatecoincidenceaccident did notdidn’t came abouthappenedtook place in advanceearlier! I bookmarked it.

  6. I want to express my affection for your kindness for those who absolutely need guidance on this important concern. Your real commitment to passing the message along appeared to be really powerful and has all the time empowered most people much like me to arrive at their goals. The invaluable publication implies much a person like me and additionally to my fellow workers. Regards; from each one of us.

  7. Thanks so much for giving everyone such a spectacular opportunity to discover important secrets from this site. It can be very fantastic and as well , jam-packed with amusement for me and my office mates to visit your web site at the least thrice in a week to read the newest guidance you will have. Not to mention, I’m so certainly satisfied with the eye-popping advice you serve. Some two points in this posting are certainly the most suitable I’ve had.

  8. I and also my pals came analyzing the great suggestions located on your site and so immediately developed a terrible feeling I never thanked the site owner for those tips. All the people appeared to be as a result excited to read them and have now truly been tapping into these things. Appreciate your actually being simply kind and for getting this kind of helpful topics most people are really eager to learn about. My honest apologies for not saying thanks to you earlier.

  9. I wanted to write you the little bit of note to be able to say thank you yet again on your pleasing information you’ve shown on this site. This is simply particularly open-handed of you to deliver easily what many of us might have made available as an e book in order to make some profit for their own end, mostly given that you could have done it in the event you considered necessary. These suggestions likewise worked as the easy way to comprehend other people online have similar interest really like my own to know the truth a great deal more in respect of this condition. I am sure there are lots of more pleasurable opportunities ahead for those who read carefully your blog post.

  10. Thanks a lot for providing individuals with an extremely remarkable opportunity to read critical reviews from this blog. It’s always so pleasurable and also stuffed with fun for me and my office colleagues to search your site really three times weekly to find out the fresh guides you will have. And definitely, I am also actually fascinated for the special hints you give. Some two tips in this posting are rather the very best I’ve ever had.

  11. I simply wanted to write a word so as to thank you for all the nice points you are sharing at this site. My particularly long internet research has at the end of the day been compensated with brilliant details to go over with my good friends. I ‘d declare that many of us readers are really fortunate to be in a magnificent site with very many lovely individuals with very helpful plans. I feel very much happy to have discovered your weblog and look forward to so many more amazing times reading here. Thanks once again for all the details.

  12. I have to express some thanks to this writer for rescuing me from this particular matter. Because of looking out throughout the search engines and coming across views which are not powerful, I thought my life was well over. Living devoid of the approaches to the problems you have resolved through the post is a critical case, as well as the ones that might have badly damaged my entire career if I hadn’t come across your web page. Your primary know-how and kindness in touching every aspect was important. I don’t know what I would have done if I hadn’t come across such a subject like this. I can also at this point relish my future. Thanks for your time very much for the skilled and result oriented guide. I will not be reluctant to propose your web site to anyone who needs to have guidance on this matter.

Deixe uma resposta

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