domingo, 6 de dezembro de 2015

Excel - Calculos com celulas

https://support.office.com/pt-br/article/Definir-e-usar-nomes-em-f%C3%B3rmulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64

https://support.office.com/pt-br/article/Vis%C3%A3o-geral-de-f%C3%B3rmulas-d258ec72-149a-42ac-8eae-b50a667eb4914

como usar referencias L1C1

https://books.google.com.br/books?id=H_Gcaaos1EsC&pg=PA128&lpg=PA128&dq=excel+referenciar+celulas+l1%27c1&source=bl&ots=dAMqR2RVfn&sig=bNL1qjsC_o3VBXs5avemdoSGKCc&hl=pt-BR&sa=X&ved=0ahUKEwih_sKozsfJAhXJIpAKHcpCBOMQ6AEIRzAH#v=onepage&q=excel%20referenciar%20celulas%20l1%27c1&f=false



https://support.office.com/pt-br/article/ENDERE%C3%87O-Fun%C3%A7%C3%A3o-ENDERE%C3%87O-d0c26c0d-3991-446b-8de4-ab46431d4f89

=ENDEREÇO(2+1;3)


-- object range
http://juliobattisti.com.br/cursos/excelavancado/modulo6/07.asp

0 comentários: