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
39
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
ARI_BXデザイン第2事業ドメイン_事業紹介資料
arid2
0
1k
株式会社マクロセンド-採用ピッチ資料 / macrosend-guide
macrosend
1
11k
決めたことより、「なぜ決めたか」を残す
doiko123
0
470
Nstock 採用資料 / We are hiring
nstock
30
410k
3ヶ月で月額300万円削減 ── AWSコスト削減プロジェクトのリアル
o2mami
0
770
人は呼び方で行動が変わる / The Stance That Comes Before Scrum
aokiplayer
0
490
会社説明資料 | 株式会社Swish
takumi4327
0
180
THE Impact Report 2026 /THE株式会社 2026年10月公開(訂正版)
yusukiwashita
0
250
DiSC®研修|相互理解とチームづくり+ミニチームコーチング
chibanba1982
0
140
Your AI doesn’t have a point of view.
macgupta
0
170
『仲良しで何が悪い』へのアンチテーゼ - 馴れ合いからプロとして背中を預け合えるチームを作る
rechiba3
0
1.2k
エムスリーキャリア エンジニア採用資料 / M3C Engineer Guide
m3c
2
120k
Featured
See All Featured
Pawsitive SEO: Lessons from My Dog (and Many Mistakes) on Thriving as a Consultant in the Age of AI
davidcarrasco
1
300
Prompt Engineering for Job Search
mfonobong
0
590
Visual Storytelling: How to be a Superhuman Communicator
reverentgeek
2
750
Art, The Web, and Tiny UX
lynnandtonic
304
22k
Utilizing Notion as your number one productivity tool
mfonobong
4
640
Why Our Code Smells
bkeepers
PRO
340
58k
Paper Plane
katiecoart
PRO
6
55k
Leo the Paperboy
mayatellez
11
2.5k
[Rails World 2026] Durable orchestration on Rails: from continuation to workflow
palkan
4
1.3k
Navigating the Design Leadership Dip - Product Design Week Design Leaders+ Conference 2024
apolaine
2
520
Technical Leadership for Architectural Decision Making
baasie
4
650
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
659
62k