Practica 24 Consolidar.xls
5
PRACTICA 24: CONSOLIDAR Consolida las tablas de enero, febrero y marzo, en la hoja 1er Trim. Utiliz Consolidación de Datos Vendedor Facturación Uds. Comisión Remuneración Enero Isabel 7,472 97 5% 373.6 Alejandro 8,451 16 9% 760.59 Victor 3,643 17 3% 109.29 David 2,186 74 10% 218.6 Paula 4,862 68 2% 97.24
-
Upload
maximo-romero-aguilar -
Category
Documents
-
view
7 -
download
1
Transcript of Practica 24 Consolidar.xls
EneroPRACTICA 24: CONSOLIDARConsolida las tablas de enero, febrero y marzo, en la hoja 1er Trim. Utiliza la funcin suma.Consolidacin de DatosVendedorFacturacinUds.ComisinRemuneracinEneroIsabel7,472975%373.6Alejandro8,451169%760.59Victor3,643173%109.29David2,1867410%218.6Paula4,862682%97.24
FebreroConsolidacin de DatosVendedorFacturacinUds.ComisinRemuneracinFebreroIsabel8,682632%173.64Alejandro3,783644%151.32Victor3,888545%194.4David5,664593%169.92Paula3,674519%330.66
MarzoConsolidacin de DatosVendedorFacturacinUds.ComisinRemuneracinMarzoIsabel5,342772%106.84Alejandro1,681831%16.81Victor5,935879%534.15David6,89825%344.9Paula7,4521001%74.52
1er Trim
SolucinFacturacinUds.ComisinRemuneracinPractica 24 Consolidar7,472975%373.6Practica 24 Consolidar8,682632%173.64Practica 24 Consolidar5,342772%106.84Isabel21,4962379%654.08Practica 24 Consolidar8,451169%760.59Practica 24 Consolidar3,783644%151.32Practica 24 Consolidar1,681831%16.81Alejandro13,91516314%928.72Practica 24 Consolidar3,643173%109.29Practica 24 Consolidar3,888545%194.4Practica 24 Consolidar5,935879%534.15Victor13,46615817%837.84Practica 24 Consolidar2,1867410%218.6Practica 24 Consolidar5,664593%169.92Practica 24 Consolidar6,89825%344.9David14,74813518%733.42Practica 24 Consolidar4,862682%97.24Practica 24 Consolidar3,674519%330.66Practica 24 Consolidar7,4521001%74.52Paula15,98821912%502.42
