fbpx

67 Formulas de Excel muy bien explicadas – Domina Excel

67 Formulas de Excel muy bien explicadas – Domina Excel: Si necesitas dominar Excel o aprender algo más que lo básico, te recomiendo que veas esta excelente guía que contiene 67 funciones (fórmulas) muy bien explicadas con ejercicios prácticos. Si eres de aquellos que pasa mucho tiempo frente a una hoja de cálculo quizás estés perdiendo tiempo por no saber el correcto uso de alguna función, personalmente acabo de revisar cada una de las fórmulas expuestas y encontré 5 que poco conocía pero que a partir de hoy las voy analizar.

Hay formulas Excel claves que debes de saber como por ejemplo: =Suma( ) | =Buscarv( )| =Sumar.si( ) | =Contar.Si( ) y funciones aritmeticas + – / *; creo que con saber esto basta para «sobrevivir» en Excel, pero a nadie le gusta estar al limite por tanto debes centrarte en estas fórmulas: =Sumaproducto( ) | =y( ) | =o( ) | =Indice( ) | =Coincidir( ) | =Desref( ) | =Buscarh( ) | =Elegir( ); conociendo estas puedes pasearte en excel pero no ser aún  experto, obviamente todo debe ir acompañado de un buen uso de tablas dinámicas, formularios, filtros avanzados etc.

Espero en algún momento tocar el tema de Formulas matriciales para que conoscan el verdadero poder de Excel.

Nunca terminaremos de conocer a Excel.

DESCARGA

Descargar 67 Funciones para dominar Excel – Formulas básicas – avanzadas Excel.xls

SUSCRÍBETE GRATIS

Te convertiré en un experto en Excel, tengo la experiencia y todo el material que necesitas, mi ayuda es totalmente gratuita.

Suscríbete

Agrega tu comentario

Comentarios
  1. Posted by saul
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Mariaaaa
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Lenin
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by patricia
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Jose Maria Eworo Ndong
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Efraín Esteban Ruiz
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Cecilia
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by JORGE ÁLVAREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Marco Antonio Martinez
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Azucena Ocampo Barrera
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Juan Esteban zamarra moreno
  12. Posted by Itza
  13. Posted by juAN
  14. Posted by jairo camacho
  15. Posted by guadalupe
  16. Posted by Pedro Benitez
  17. Posted by victor
  18. Posted by FREDY CRUZ ROMERO
  19. Posted by Elias Velasquez
  20. Posted by jose
  21. Posted by INGENIERIA ELECTRICA
  22. Posted by Yorkevin Alayon
  23. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by alexander
  25. Posted by Pedro Benitez
  26. Posted by Germán Manga Chavez
  27. Posted by Juan ramon
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by SANDRA
  29. Posted by geiner paisig
  30. Posted by ynocencio valdez
  31. Posted by Louis
  32. Posted by ynocencio Valdez
  33. Posted by maribel
  34. Posted by Emilio
  35. Posted by Placido Parada Cubides
    • Posted by Robin Solano
  36. Posted by Rolando
  37. Posted by Rolando
  38. Posted by manuel quezafa araluce
  39. Posted by Jhonny
  40. Posted by JUAN CARLOS GONZALEZ ARMENDARIZ
  41. Posted by Nelson
    • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by Edgar
  43. Posted by Edwin Zhunio
  44. Posted by Humberto Gutierrez
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by oscar
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by lalo
  46. Posted by Alma
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by mili
    • Posted by Gustavo A. Sebastiani Cépeda
  48. Posted by Uras
    • Posted by Gustavo A. Sebastiani Cépeda
  49. Posted by carol
    • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by Telma Atagon
  51. Posted by Miguel Sanchez
    • Posted by Gustavo A. Sebastiani Cépeda
  52. Posted by efrain chujai
  53. Posted by Eduardo
  54. Posted by Ricardo Humes
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by ALESS PEDRAZA
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ARANCHA
        • Posted by Gustavo A. Sebastiani Cépeda
  56. Posted by fabian
  57. Posted by Norberto Guillén
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by dary zuly bedoya
  59. Posted by CARMELA
  60. Posted by Silvia Monterrosa
  61. Posted by Rodolfo Enrique Acosta Castro
  62. Posted by saturinino
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by mentefria2016
  63. Posted by royer
  64. Posted by Karen
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by BenjaminS
      • Posted by Gustavo A. Sebastiani Cépeda
  65. Posted by MONDRAGON
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by VIOLETA
  67. Posted by Salvador
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by JOSE LUIS FLORES
  69. Posted by Jeronimo Quintero
    • Posted by Gustavo A. Sebastiani Cépeda
  70. Posted by Sergio José
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by guilmar
  72. Posted by martin roa
  73. Posted by Henry
  74. Posted by AMRAM G.
    • Posted by wili
  75. Posted by grimaldo juep sanchez
  76. Posted by MARIA
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by RDP
  77. Posted by Christián Cárdenas
  78. Posted by Christian
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by mauricio bejarano
  80. Posted by Hector
    • Posted by vesna
  81. Posted by Manolo
  82. Posted by Anton
  83. Posted by gabriel
  84. Posted by Jesus flores
  85. Posted by Gonzalo Fernández
    • Posted by waldo
  86. Posted by sergio
  87. Posted by Alan Garcia
  88. Posted by Freddy
  89. Posted by melvin
    • Posted by ricardopalmeros
  90. Posted by YUDIMIRFOX
  91. Posted by Ludwing
  92. Posted by VIVIANA SANTOS
    • Posted by LUIS G. CASTAÑEDA P