Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Hojas de cálculo 101

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for molpe molpe
January 26, 2019
Business
0
38

Hojas de cálculo 101

Pequeña introducción a las hojas de cálculo para niños. Lo básico, básico, básico.

Avatar for molpe

molpe

January 26, 2019
Tweet

More Decks by molpe

See All by molpe
Business Model Canvas Workshop
Avatar for molpe molpe
0
120
A family business
Avatar for molpe molpe
0
28
El milagro de cobrar online
Avatar for molpe molpe
1
71
La industria de los medios de pago
Avatar for molpe molpe
0
87
110km vayas
Avatar for molpe molpe
1
78
¿Merece la pena crear una empresa?
Avatar for molpe molpe
3
590

Other Decks in Business

See All in Business
【Progmat】Monthly-ST-Market-Report-2026-Jan.
Avatar for progmat progmat
0
320
GMO Flatt Security 会社紹介資料
Avatar for GMO Flatt Security flatt_security
0
26k
アシスト 会社紹介資料
Avatar for ashisuto_career ashisuto_career
3
150k
malna-recruiting-pitch
Avatar for malna malna
0
14k
NewsPicks Expert説明資料 / NewsPicks Expert Introduction
Avatar for NewsPicks Expert mimir
0
22k
Growth Book
Avatar for 株式会社クラダシ kuradashi
0
3.4k
20260114_知的生産と事業創造でAIを使いこなす全技法_スライド
Avatar for Itaru Tomita itarutomy
1
490
【northernforce#54】AIの歴史と仕組みから学ぶAIエージェント入門
Avatar for Yoshi yoshi17
0
260
2026.2_中途採用資料.pdf
Avatar for SUPER STUDIO INC. superstudio
PRO
3
97k
税理士法人チェスター_事務所紹介資料
Avatar for m.chester mabhr
0
870
株式会社ネオキャリア＿採用ピッチ資料＿20260128
Avatar for neo_recruit neo_recruit
0
450
メドピアグループ紹介資料
Avatar for MedPeer Inc. Recruit medpeer_recruit
10
150k

Featured

See All Featured
Between Models and Reality
Avatar for mayunak mayunak
1
190
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
910
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
From Legacy to Launchpad: Building Startup-Ready Communities
Avatar for Dug Song dugsong
0
140
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
12
1k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
527
40k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
348
40k
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.3k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
Avatar for Yuki Nakata chikuwait chikuwait
0
330
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
40
2.3k
Data-driven link building: lessons from a $708K investment (BrightonSEO talk)
Avatar for Szymon szymonslowik
1
910
What's in a price? How to price your products and services
Avatar for Michael Herold michaelherold
247
13k

Transcript

  1. HOJAS DE CÁLCULO 101 "MCFSUP.PMQFDFSFT

  2. ¿HOJA DE CÁLCULO? ↟&TVOUJQPEFEPDVNFOUPEFPSEFOBEPS QFOTBEPQBSBNBOJQVMBSQSJODJQBMNFOUF EBUPTOVNéSJDPTFOVOBUBCMB ↟$PNPEPDVNFOUPRVFFT EFCFTFSBCJFSUP QPSVOQSPHSBNBDBQB[EFMFFSFTFGPSNBUP ↟&MQSPHSBNBNáTGBNPTPQBSBDSFBSIPKBTEF

    DáMDVMPFT.JDSPTPGU&YDFM QFSPIBZPUSPT DPNP(PPHMF4IFFUTP/VNCFSTEF"QQMF
  3. None
  4. None

  5. PARTES DE UNA HOJA DE CÁLCULO

  6. /PNCSFEFMB IPKBEFDáMDVMP #BSSBEFIFSSBNJFOUBT 1FTUBñBTVIPKBT $PMVNOBT 'JMBT $FMEBT   

    j " # $ j " # $ j " # $ j $FMEBBDUVBM % ÁSFBEFFTDSJUVSB DFMEBBDUVBM 4FMFDUPSQBSB DPQJBSFOTFSJF

  7. MANOS A LA OBRA

  8. FORMULAS ↟4JSWFOQBSBIBDFSDáMDVMPTPQFSBDJPOFT ↟&TUPTTPONáUFNáUJDBTOúNFSPT PQFSBEPSFT  QSFDFOEFODJB ↟)BZRVFDPNFO[BSDPOFMTíNCPMP QPSRVFTJ OPFMQSPHSBNBOPTBCFRVFUJFOFRVFIBDFSVO DáMDVMP&K=(7+10+15)/3

    ↟Ñ1BSBFTUPNFWBMFDPOVOBDBMDVMBEPSB

  9. REFERENCIAS A CELDAS ↟&OMVHBSEFFTDSJCJSVOWBMPS JOEJDBNPTMBT DPPSEFOBEBTEFMBDFMEBRVFUJFOFFTFWBMPS ↟$POFTUPDPOTFHVJNPTRVFMBGPSNVMBTF SFDBMDVMFTPMBTJDBNCJPFMWBMPSEFMBDFOB PSJHJOBM ↟1PEFNPTQJODIBSTPCSFMBDFMEBFODVFTUJóO

    OP IBDFGBMUBFTDSJCJSMBTDPPSEFOBEBTVOBBVOB ↟-BTSFGFSFODJBTQVFEFOTFSEFPUSBIPKB QFTUBñB&KC2POTRAHOJA!C2 ↟4JRVFSFNPTGJKBSVOBDFMEB VTBNPTFMTíNCPMP $C$2

  10. FUNCIONES ↟4PODáMDVMPTQSFEFUFSNJOBEPTRVFFTDBQB[EF IBDFSMBBQMJDBDJóOQBSBIBDFSOVFTUSBWJEB NáTTFODJMMB ↟)BZ$*&/504EFFMMBT ↟/PSNBMNFOUF.FOV*OTFSUBS'VODJóO ↟&KFNQMPTTVNBTZPUSBTPQFSBDJPOFT DáMDVMPEF NFEJBZPUSBTFTUBEíTUJDBT WBMPSFTNáYJNPT

    NíOJNPT DPOEJDJPOBMFT FUD ↟&MMJTUBEPEFGVODJPOFTEJTQPOJCMFTOPFTFM NJTNPFOUPEBTMBTBQMJDBDJPOFT

  11. EJEMPLOS DE FUNCIONES

  12. RANGOS DE CELDAS ↟4POVOBGPSNBSáQJEBEFSFGFSJSOPTBVOHSVQP EFDFMEBTDPOTFDVUJWPT ↟4FDSFBQPOJFOEPMBQSJNFSBDFMEB FMDBSáDUFS ZMBDFMEBGJOBM&KD4:D9 ↟/PSNBMNFOUFDVBOEPVTBNPTVOBGVODJóO&K SUM(D4:D9)

  13. ALGUNOS TRUCOS

  14. RVJUBSQPOFSDFSPT GPSNBUPTIBCJUVBMFT UFYUPT GFDIBT OúNFSPT FUD DPMPSJOFT UFYUPZGPOEP CPSEFT KVOUBSDFMEBT

    HERRAMIENTAS

  15. RELLENAR AUTOMÁTICAMENTE ÐQJODIBSZBSSBTUSBSEFMTFMFDUPS

  16. RELLENAR AUTOMÁTICAMENTE (2) ÐGVODJPOBDPOSFGFSFODJBTBDFMEBTZGVODJPOFT

  17. EJEMPLO ‘LOCKEY’

  18. ¿CÓMO NOS VA? ↟Ñ$VáOUPEJOFSPIFNPTHBTUBEPJOWFSUJEPQBSB QPEFSFNQF[BS  ↟Ñ$VáOUPOPTDVFTUBGBCSJDBSDBEBUJQPEF MMBWFSP  ↟Ñ$VáOUPHBOBNPTDPODBEBMMBWFSP

     ↟Ñ$VáOUPTMMBWFSPTUFOFNPTRVFWFOEFSQBSB SFDVQFSBSMPTHBTUBEP  ↟(BTUPT ↟(FOFSBMFT ↟1PSMMBWFSP ↟*OHSFTPT ↟#FOFGJDJP ↟(FOFSBMFT ↟1PSMMBWFSP

  19. GRACIAS DE PARTE DE TODOS