Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Hojas de cálculo 101
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
molpe
January 26, 2019
Business
39
0
Share
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
More Decks by molpe
See All by molpe
Business Model Canvas Workshop
molpe
0
120
A family business
molpe
0
29
El milagro de cobrar online
molpe
1
73
La industria de los medios de pago
molpe
0
88
110km vayas
molpe
1
79
¿Merece la pena crear una empresa?
molpe
3
590
Other Decks in Business
See All in Business
イグニション・ポイント株式会社/採用エントランスBook_2026
ignitionpointhr
2
180k
爆速で組織になじみ “Work is Fun” を体現するIVRyのオンボーディング
itochan
1
250
LEVELING UP OR LEVELING DOWN? THE IMPACT OF GENERATIVE AI ON STUDENT PERFORMANCE IN BUSINESS SCHOOLS
icopilots
PRO
0
180
(5枚)法人営業のキーパーソンを特定する方法 予材管理で最も重要なラインコントロール
nyattx
PRO
1
570
DNX Ventures Japan|Introduction Deck
natsumidnx
0
3.8k
SANU Regenerative Action Report 2026
sanu
0
9.9k
アッテル会社紹介資料/culture deck
attelu
11
16k
Crisp Code inc.|わたしたちの事例 / 実績 - Works
so_kotani
0
1.9k
第47期 中間期決算説明会資料
tsuchihashi
0
600
withエンジニア_Real Voices
enito
PRO
0
110
株式会社IDOM_FACT BOOK 2026
idompr
0
4.7k
8 quotes that sum up recent trading in the travel sector
marketingttc
0
180
Featured
See All Featured
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
helenjbeal
1
150
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
soudai
PRO
64
53k
The B2B funnel & how to create a winning content strategy
katarinadahlin
PRO
1
330
jQuery: Nuts, Bolts and Bling
dougneiner
66
8.4k
A better future with KSS
kneath
240
18k
How to Think Like a Performance Engineer
csswizardry
28
2.5k
Jamie Indigo - Trashchat’s Guide to Black Boxes: Technical SEO Tactics for LLMs
techseoconnect
PRO
0
93
Primal Persuasion: How to Engage the Brain for Learning That Lasts
tmiket
0
310
4 Signs Your Business is Dying
shpigford
187
22k
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
aleyda
2
10k
The Spectacular Lies of Maps
axbom
PRO
1
680
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.7k
Transcript
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