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
メドピアグループ紹介資料
Avatar for MedPeer Inc. Recruit medpeer_recruit
10
150k
ARI会社説明
Avatar for ARI arisaiyou
1
22k
【SRE Kaigi 2026】認知負荷を最小化するオブザーバビリティとSLOの導入 ―4名SREが200名のコードエンジニアを支援
Avatar for HIGUCHI.Takashi higuchi_takashi
2
1.1k
【新卒採用資料】Natee Company Deck _202601
Avatar for Natee nateehr
0
2.8k
[1] Power BI Deep Dive [2026-02]
Avatar for Ohata Masatoshi ohata_bi
2
150
会社説明資料
Avatar for xingHR xinghr
0
190
【新卒向け】株式会社リブに興味のある方へ
Avatar for 株式会社リブ/LiB,Inc. libinc
0
11k
イグニション・ポイント株式会社／採用エントランスBook_2026
Avatar for Ignition Point-HR ignitionpointhr
2
170k
会社説明資料｜幸信電気株式会社
Avatar for 幸信電気株式会社 260122
0
120
エピックベース株式会社_会社概要資料_202601
Avatar for Takayoshi Matsuda takayoshimatsuda
PRO
1
570
AI浅慮の時代における「考える」と「視点」、そして「創造性」
Avatar for Masaya Mori (森正弥) / CAIO (Chief AI Officer) masayamoriofficial
1
2k
キャンバスエッジ株式会社　会社説明資料
Avatar for キャンバスエッジ株式会社 canvasedge
0
9.4k

Featured

See All Featured
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
3.9k
Designing Powerful Visuals for Engaging Learning
Avatar for Mike Taylor tmiket
0
230
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.5k
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
Avatar for Aleyda Solis aleyda
1
1.9k
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
13k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
122
21k
The Curious Case for Waylosing
Avatar for Cassini Nazir cassininazir
0
240
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
1
100
The Spectacular Lies of Maps
Avatar for Per Axbom axbom
PRO
1
520
Sharpening the Axe: The Primacy of Toolmaking
Avatar for Bryan Cantrill bcantrill
46
2.7k
Ruling the World: When Life Gets Gamed
Avatar for Sebastian Deterding codingconduct
0
140
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
96

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