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
株式会社EventHub 会社紹介資料
Avatar for EventHub eventhub
1
43k
キャンバスエッジ株式会社　会社説明資料
Avatar for キャンバスエッジ株式会社 canvasedge
0
9.4k
（15枚）NotebookLMのスライド生成機能で「絶対達成」「予材管理」「大量行動」の重要性を解説してもらう
Avatar for 横山信弘／絶対達成スライド館 nyattx
PRO
0
180
RDRAモデルからFP・工数・金額につなぐ定量見積り
Avatar for BPStudy bpstudy
1
210
Le bon Mindset – Gymnastique Québec
Avatar for Jean-Marc De Jonghe jdejongh
PRO
0
120
「回復の場」としてのコミュニティ
Avatar for Emi emi0726
0
820
LW_brochure_engineer
Avatar for linc-well lincwellhr
0
40k
DeNA社のAI活用スキル評価
Avatar for 小平株式会社 kobira_official
PRO
0
150
VISASQ: ABOUT DEV TEAM
Avatar for VISASQ eikohashiba
6
41k
会社説明資料
Avatar for xingHR xinghr
0
190
RSGT2026 Dave Snowden Keynote
Avatar for Jules Yim julesyim
0
980
40代データ人材のキャリア戦略
Avatar for Jun Ernesto Okumura pacocat
4
3.9k

Featured

See All Featured
Public Speaking Without Barfing On Your Shoes - THAT 2023
Avatar for David Neal reverentgeek
1
310
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
500
Tips & Tricks on How to Get Your First Job In Tech
Avatar for Honza Javorek honzajavorek
0
440
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
Avatar for Sara Fernández Carmona sarafernandez
1
1.3k
Done Done
Avatar for chrislema chrislema
186
16k
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.8k
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
110
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
57
14k
Primal Persuasion: How to Engage the Brain for Learning That Lasts
Avatar for Mike Taylor tmiket
0
250
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
320
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
250
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
48

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