Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Funciones de Cubo de Excel, descripción y traducción al inglés y otros idiomas

(adsbygoogle = window.adsbygoogle || []).push({});

Cuando se trabaja  con Excel, ya sea que se trabajé con fórmulas o se programe macros para excel, es imprescindible saber que es lo que específicamente realiza cada una de las fórmula que trae Excel su arsenal de herramientas para trabajar con datos  numéricos y de texto, Excel clasifica las fórmulas en:
1 Funciones de Excel Financieras
Funciones de Excel de Fecha y Hora
Funciones de Excel Matemáticas y Trigonométricas
Funciones de Excel Estadísticas
Funciones de Excel de  Búsqueda y Referencia
Funciones de Excel de Base de Datos
Funciones de Excel de Texto
Funciones de Excel Lógicas
Funciones de Excel de Información
10 Funciones de Excel Definidas por  el Usuario
11 Funciones de Excel de Ingeniería
12 Funciones de Excel de Cubo

Función Descripción
MIEMBROKPICUBO Devuelve
un nombre, propiedad y medida de indicador de rendimiento clave (KPI) y
muestra el nombre y la propiedad en la celda. Un KPI es una medida
cuantificable, como los beneficios brutos mensuales o la facturación
trimestral por empleado, que se usa para supervisar el rendimiento de una
organización.
MIEMBROCUBO Devuelve
un miembro o tupla en una jerarquía de cubo. Se usa para validar la
existencia del miembro o la tupla en el cubo.
PROPIEDADMIEMBROCUBO Devuelve
el valor de una propiedad de miembro del cubo Se usa para validar la
existencia de un nombre de miembro en el cubo y para devolver la propiedad
especificada para este miembro.
MIEMBRORANGOCUBO Devuelve
el miembro n, o clasificado, de un conjunto. Se usa para devolver uno o más
elementos de un conjunto, por ejemplo, el representante con mejores ventas o
los diez mejores alumnos.
CONJUNTOCUBO Define
un conjunto calculado de miembros o tuplas mediante el envío de una expresión
de conjunto al cubo en el servidor, lo que crea el conjunto y, después,
devuelve dicho conjunto a Microsoft Office Excel.
RECUENTOCONJUNTOCUBO Devuelve
el número de elementos de un conjunto.
VALORCUBO Devuelve
un valor agregado de un cubo.

 

Te recomiendo que leas un excelente libro sobre Excel el que te ayudará manejar las planillas de cálculo, debes hacer click acá.
  
En post anteriores se presentaron otro tipos de funciones que trae incorporado Excel, ahora voy a mostrarte cuales son  las funciones de Cubo; una pequeña descripción de lo que realiza y la traducción de las formulas de Excel al inglés y otros  idiomas; en los siguientes post, se van a especificar  cada una del resto de funciones que trae Excel incorporadas según la clasificación precedente.


Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (61)

I’m the co-founder of JustCBD company (justcbdstore.com) and I’m presently looking to broaden my wholesale side of company. I really hope that someone at targetdomain share some guidance 🙂 I thought that the best way to do this would be to reach out to vape shops and cbd retailers. I was hoping if someone could suggest a trustworthy web-site where I can buy CBD Shops Business Marketing Data I am currently checking out creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. On the fence which one would be the very best choice and would appreciate any support on this. Or would it be easier for me to scrape my own leads? Ideas?

Responder

There’s definately a lot to know about this subject. I really like all of the points you’ve made.

Responder

I like it when people get together and share thoughts. Great site, stick with it!

Responder

Pretty! This was a really wonderful article. Thank you for providing this information.

Responder

I wanted to thank you for this great read!! I certainly loved every little bit of it. I have got you book-marked to look at new stuff you post…

Responder

May I simply say what a relief to uncover a person that truly understands what they are discussing on the net. You actually realize how to bring an issue to light and make it important. A lot more people ought to check this out and understand this side of your story. I was surprised that you aren’t more popular given that you most certainly possess the gift.

Responder

I truly love your blog.. Pleasant colors & theme. Did you create this web site yourself? Please reply back as I’m wanting to create my own site and would love to know where you got this from or exactly what the theme is called. Many thanks!

Responder

This site really has all of the information I needed concerning this subject and didn’t know who to ask.

Responder

Hello would you mind stating which blog platform
you’re working with? I’m going to start
my own blog in the near future but I’m having a tough time
choosing between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your layout seems different then most blogs and I’m looking for something completely unique.

P.S Apologies for getting off-topic but I had to ask!

Responder

Wow, fantastic blog layout! How long have you been blogging for?

you made blogging look easy. The overall look of your site
is great, as well as the content! adreamoftrains best web hosting 2020

Responder

Hello! I’m at work browsing your blog from my new apple iphone!

Just wanted to say I love reading through your
blog and look forward to all your posts! Keep up the excellent work!

Responder

You made some really good points there. I looked on the
web for additional information about the issue and found
most individuals will go along with your views on this site.

Responder

I simply want to say I am very new to weblog and honestly enjoyed your web-site. Most likely I’m likely to bookmark your blog . You really come with excellent article content. Kudos for sharing with us your webpage.

Responder

I simply want to tell you that I’m newbie to blogging and site-building and seriously loved this web blog. Very likely I’m planning to bookmark your website . You definitely come with outstanding well written articles. Thanks a lot for revealing your web-site.

Responder

Youre so trendy! I don’t suppose Ive read anything similar to this before. So good to find somebody with some initial ideas on this subject. realy thank you for beginning this up. this website is something that is required on the internet, someone with a little originality. beneficial task for bringing something brand-new to the web!

Responder

pitkävetovihjeet

Responder

Shop; Unique Functions. Simple Product Layouts. Post with review. Advanced Product Layout. Best conversion pages. Frontend Search · Listing example …

Responder

When I originally commented I clicked the «Notify me when new comments are added» checkbox and now each time a comment is added I get three emails with the
same comment. Is there any way you can remove people from that service?
Thanks!

Responder

It’s awesome to pay a visit this website and reading the views of all mates concerning this piece of
writing, while I am also zealous of getting experience.

Responder

How does Ibogaine cure addiction

Responder

An interesting discussion is worth comment. I do think that you need to publish more about this topic, it may not be a taboo matter but usually people do not discuss these issues. To the next! All the best!!

Responder

Best view i have ever seen !

Responder

Love watching sunset !

Responder

It’s fantastic that you are getting thoughts from this article as well as from our dialogue made at this
time.

Responder

Love watching sunset !

Responder

Love watching sunset !

Responder

Best view i have ever seen !

Responder

Love watching sunset !

Responder

ilmaiset videot, ilmaiset pornovideot, ilmaiset porno videot, porno video, porno videot

Responder

Spot on with this write-up, I truly assume this website needs much more consideration. Ill probably be once more to read much more, thanks for that info.

Responder

This design is wicked! You certainly know how to keep a reader entertained.
Between your wit and your videos, I was almost moved to start my own blog
(well, almost…HaHa!) Wonderful job. I really loved what you
had to say, and more than that, how you presented it.
Too cool!

Responder

We are building consultants. We perform roof assessments, window testing, and wall testing for quality assurance on new and existing buildings.

Responder

netticasinot, netticasino, casino, kasinot, nettkasinot

Responder

You can certainly see your enthusiasm in the work you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe. Always follow your heart.

Responder

It is appropriate time to make some plans for the future and it’s time to be happy. I have read this post and if I could I want to suggest you some interesting things or tips. Maybe you could write next articles referring to this article. I desire to read even more things about it!

Responder

Hi there, I found your website via Google at the same time as looking for a related subject, your website came up, it appears good. I’ve bookmarked it in my google bookmarks.

Responder

There are definitely quite a lot of details like that to take into consideration. That may be a great point to carry up. I offer the thoughts above as normal inspiration but clearly there are questions just like the one you convey up the place an important thing will likely be working in sincere good faith. I don?t know if best practices have emerged around issues like that, but I’m positive that your job is clearly recognized as a fair game. Each boys and girls really feel the affect of just a second’s pleasure, for the rest of their lives.

Responder

Thank you for sharing all these wonderful articles. In addition, the optimal travel along with medical insurance system can often reduce those problems that come with journeying abroad. A new medical crisis can soon become costly and that’s guaranteed to quickly impose a financial weight on the family finances. Setting up in place the excellent travel insurance offer prior to leaving is definitely worth the time and effort. Thank you

Responder

I’m not sure where you’re getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for fantastic info I was looking for this information for my mission.

Responder

How do i use frame or iframe to put facebook or else to blogspot?

Responder

Hmm it seems like your website ate my first comment (it was extremely long) so I guess I’ll just sum it up what I wrote and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog writer but I’m still new to the whole thing. Do you have any points for beginner blog writers? I’d genuinely appreciate it.

Responder

Hello there, I found your web site via Google while searching for a related topic, your website came up, it looks great. I have bookmarked it in my google bookmarks.

Responder

Hi! Somebody in my Facebook team shared this web site with us, so I pertained to provide it a look. I’m enjoying the info. I’m bookmarking and also will be tweeting this to my followers! Remarkable blog and impressive layout as well as design.

Responder

Do you have a spam problem on this blog; I also am a blogger, and I was wondering your situation; we have developed some nice procedures and we are looking to swap techniques with other folks, please shoot me an email if interested.

Responder

Very efficiently written post. It will be helpful to everyone who utilizes it, including yours truly :). Keep doing what you are doing – for sure i will check out more posts.

Responder

Hey there! Someone in my Myspace group shared this site with us so I came to give it a look. I’m definitely loving the information. I’m book-marking and will be tweeting this to my followers! Terrific blog and outstanding design and style.

Responder

I have been exploring for a bit for any high quality articles or weblog posts on this kind of house . Exploring in Yahoo I eventually stumbled upon this website. Studying this information So i am glad to convey that I’ve a very excellent uncanny feeling I found out exactly what I needed. I most without a doubt will make certain to do not overlook this web site and provides it a look on a relentless basis.

Responder

Good site! I really love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified whenever a new post has been made. I’ve subscribed to your RSS feed which must do the trick! Have a nice day!

Responder

certainly like your website but you have to check the spelling on quite a few of your posts. Many of them are rife with spelling issues and I find it very bothersome to tell the truth nevertheless I will definitely come back again.

Responder

Keep working ,great job!

Responder

I would like to get across my appreciation for your kind-heartedness in support of individuals who really need help with that matter. Your very own commitment to passing the message throughout appeared to be rather important and have encouraged women just like me to attain their endeavors. Your personal important instruction implies a whole lot a person like me and substantially more to my mates. Thanks a ton; from all of us.

Responder

I was very pleased to uncover this great site. I want to to thank you for your time for this fantastic read!! I definitely savored every little bit of it and I have you bookmarked to look at new stuff in your web site.

Responder

Howdy would you mind stating which blog platform you’re working with? I’m going to start my own blog soon but I’m having a difficult time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something completely unique. P.S My apologies for being off-topic but I had to ask!

Responder

Nice blog here! Additionally your web site lots up very fast! What host are you using? Can I am getting your associate link for your host? I desire my web site loaded up as fast as yours lol

Responder

Have you ever considered creating an ebook or guest authoring on other websites? I have a blog based on the same subjects you discuss and would really like to have you share some stories/information. I know my readers would value your work. If you’re even remotely interested, feel free to shoot me an e-mail.

Responder

Your home is valueble for me. Thanks!…

Responder

Get to learn a lot from the article and seriously appreciate the work you are doing.

Responder

What’s Happening i am new to this, I stumbled upon this I have found It absolutely useful and it has aided me out loads. I am hoping to give a contribution & assist different customers like its helped me. Good job.

Responder

Wow! This can be one particular of the most beneficial blogs We have ever arrive across on this subject. Actually Fantastic. I’m also an expert in this topic therefore I can understand your effort.

Responder

Hello there, You have performed a great job. I’ll certainly digg it and individually recommend to my friends. I’m confident they will be benefited from this web site.

Responder

May I just say what a comfort to find a person that genuinely knows what they are talking about on the net. You certainly know how to bring an issue to light and make it important. More people must read this and understand this side of the story. I was surprised that you’re not more popular given that you surely possess the gift.

Responder