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

Hojas de cálculo 101

Avatar for molpe molpe
January 26, 2019
Business
0
35

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
110
A family business
Avatar for molpe molpe
0
24
El milagro de cobrar online
Avatar for molpe molpe
1
68
La industria de los medios de pago
Avatar for molpe molpe
0
84
110km vayas
Avatar for molpe molpe
1
75
¿Merece la pena crear una empresa?
Avatar for molpe molpe
3
590

Other Decks in Business

See All in Business
2025.08_中途採用資料.pdf
Avatar for SUPER STUDIO INC. superstudio
PRO
1
79k
20250816 「アジャイル」って？～"Do Agile"から"Be Agile"へ～
Avatar for Takumi Abe east_takumi
0
3k
Company Profile
Avatar for Katsuhiko Eguchi katsuegu23
2
10k
Tools & Treasures: Find Auction Items That WOW
Avatar for Auctria auctria
PRO
0
110
AIで変わるPdMの役割──思考する力が武器になる
Avatar for Itsuki Kakitani itsukikacky
18
13k
ナウビレッジ株式会社_会社紹介資料_20250821
Avatar for NOWVILLAGE nowvill
0
11k
【エンジニア職】中途採用向け会社説明資料（テックファーム株式会社）
Avatar for Techfirm techfirm
0
5.4k
merpay-Overview
Avatar for Mercari, Inc. mercari_inc
8
180k
クリアル株式会社_会社概要
Avatar for CREAL creal
PRO
0
860
タケウチグループRecruit
Avatar for タケウチグループ takeuchigroup
0
7.5k
株式会社Domuz会社紹介資料（採用）
Avatar for Kimpachi Kadoike kimpachi_d
0
39k
sample
Avatar for MQ design mamiko
0
130

Featured

See All Featured
A better future with KSS
Avatar for Kyle Neath kneath
239
17k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
87
4.8k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3k
Designing Experiences People Love
Avatar for Jonathan Moore moore
142
24k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.4k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
462
33k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
179
9.9k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
4k
Building Applications with DynamoDB
Avatar for Matt Wood mza
96
6.6k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
26k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
46
7.6k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
36
2.5k

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