Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Hojas de cálculo 101
Search
molpe
January 26, 2019
Business
54
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
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.
molpe
January 26, 2019
Transcript
19 slides
HOJAS DE CÁLCULO 101 "MCFSUP.PMQFDFSFT
¿HOJA DE CÁLCULO? ↟&TVOUJQPEFEPDVNFOUPEFPSEFOBEPS QFOTBEPQBSBNBOJQVMBSQSJODJQBMNFOUF EBUPTOVNéSJDPTFOVOBUBCMB ↟$PNPEPDVNFOUPRVFFT EFCFTFSBCJFSUP QPSVOQSPHSBNBDBQB[EFMFFSFTFGPSNBUP ↟&MQSPHSBNBNáTGBNPTPQBSBDSFBSIPKBTEF
DáMDVMPFT.JDSPTPGU&YDFM QFSPIBZPUSPT DPNP(PPHMF4IFFUTP/VNCFSTEF"QQMF
None
None
PARTES DE UNA HOJA DE CÁLCULO
/PNCSFEFMB IPKBEFDáMDVMP #BSSBEFIFSSBNJFOUBT 1FTUBñBTVIPKBT $PMVNOBT 'JMBT $FMEBT
j " # $ j " # $ j " # $ j $FMEBBDUVBM % ÁSFBEFFTDSJUVSB DFMEBBDUVBM 4FMFDUPSQBSB DPQJBSFOTFSJF
MANOS A LA OBRA
FORMULAS ↟4JSWFOQBSBIBDFSDáMDVMPTPQFSBDJPOFT ↟&TUPTTPONáUFNáUJDBTOúNFSPT PQFSBEPSFT QSFDFOEFODJB ↟)BZRVFDPNFO[BSDPOFMTíNCPMP QPSRVFTJ OPFMQSPHSBNBOPTBCFRVFUJFOFRVFIBDFSVO DáMDVMP&K=(7+10+15)/3
↟Ñ1BSBFTUPNFWBMFDPOVOBDBMDVMBEPSB
REFERENCIAS A CELDAS ↟&OMVHBSEFFTDSJCJSVOWBMPS JOEJDBNPTMBT DPPSEFOBEBTEFMBDFMEBRVFUJFOFFTFWBMPS ↟$POFTUPDPOTFHVJNPTRVFMBGPSNVMBTF SFDBMDVMFTPMBTJDBNCJPFMWBMPSEFMBDFOB PSJHJOBM ↟1PEFNPTQJODIBSTPCSFMBDFMEBFODVFTUJóO
OP IBDFGBMUBFTDSJCJSMBTDPPSEFOBEBTVOBBVOB ↟-BTSFGFSFODJBTQVFEFOTFSEFPUSBIPKB QFTUBñB&KC2POTRAHOJA!C2 ↟4JRVFSFNPTGJKBSVOBDFMEB VTBNPTFMTíNCPMP $C$2
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
EJEMPLOS DE FUNCIONES
RANGOS DE CELDAS ↟4POVOBGPSNBSáQJEBEFSFGFSJSOPTBVOHSVQP EFDFMEBTDPOTFDVUJWPT ↟4FDSFBQPOJFOEPMBQSJNFSBDFMEB FMDBSáDUFS ZMBDFMEBGJOBM&KD4:D9 ↟/PSNBMNFOUFDVBOEPVTBNPTVOBGVODJóO&K SUM(D4:D9)
ALGUNOS TRUCOS
RVJUBSQPOFSDFSPT GPSNBUPTIBCJUVBMFT UFYUPT GFDIBT OúNFSPT FUD DPMPSJOFT UFYUPZGPOEP CPSEFT KVOUBSDFMEBT
HERRAMIENTAS
RELLENAR AUTOMÁTICAMENTE ÐQJODIBSZBSSBTUSBSEFMTFMFDUPS
RELLENAR AUTOMÁTICAMENTE (2) ÐGVODJPOBDPOSFGFSFODJBTBDFMEBTZGVODJPOFT
EJEMPLO ‘LOCKEY’
¿CÓMO NOS VA? ↟Ñ$VáOUPEJOFSPIFNPTHBTUBEPJOWFSUJEPQBSB QPEFSFNQF[BS ↟Ñ$VáOUPOPTDVFTUBGBCSJDBSDBEBUJQPEF MMBWFSP ↟Ñ$VáOUPHBOBNPTDPODBEBMMBWFSP
↟Ñ$VáOUPTMMBWFSPTUFOFNPTRVFWFOEFSQBSB SFDVQFSBSMPTHBTUBEP ↟(BTUPT ↟(FOFSBMFT ↟1PSMMBWFSP ↟*OHSFTPT ↟#FOFGJDJP ↟(FOFSBMFT ↟1PSMMBWFSP
GRACIAS DE PARTE DE TODOS
More Decks by molpe
See All by molpe
Business Model Canvas Workshop
molpe
0
130
A family business
molpe
0
40
El milagro de cobrar online
molpe
1
84
La industria de los medios de pago
molpe
0
98
110km vayas
molpe
1
89
¿Merece la pena crear una empresa?
molpe
3
600
Other Decks in Business
See All in Business
PLAINER 会社紹介資料
plainer
0
560
enechain company deck_english
enechain
PRO
1
800
ログラス会社紹介資料 新卒採用 ビジネス職[経営幹部候補]/ Loglass Company Deck
loglass2019
2
27k
【UMed】Company Deck_261026
ryushu
0
480
Avoiding the "Bad Training, Faster" Trap in the Age of Al
tmiket
0
810
ファブリカホールディングス_2027年3月期 第2四半期説明資料
fabrica_com
1
6.5k
株式会社アドバンテッジリスクマネジメント会社紹介資料
arm0020
0
72k
株式会社Plott Company Deck
plott
0
380
Wantedly, Inc. 会社説明資料/Wantedly Recruitment Brochure
wantedly
2
58k
会社・採用資料(CompanyDeck)_2026.10
sixtypercent
0
610
akippa株式会社|Company Deck
akippa
1
27k
DiSC®研修|相互理解とチームづくり+ミニチームコーチング
chibanba1982
0
180
Featured
See All Featured
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
37
6.7k
Intergalactic Javascript Robots from Outer Space
tanoku
273
28k
svc-hook: hooking system calls on ARM64 by binary rewriting
retrage
2
690
Fireside Chat
paigeccino
43
4.1k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
chikuwait
0
970
The B2B funnel & how to create a winning content strategy
katarinadahlin
PRO
1
620
Visualization
eitanlees
153
17k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
33
5.9k
Producing Creativity
orderedlist
PRO
348
41k
AI Search: Where Are We & What Can We Do About It?
aleyda
0
8.3k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
11
1.1k
Unlocking the hidden potential of vector embeddings in international SEO
frankvandijk
0
1.1k