Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Funciones de Base de Datos 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

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 Base de Datos que incorpora Excel, 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.
 

BDPROMEDIO Devuelve el
promedio de las entradas seleccionadas en la base de datos.
DAVERAGE DBMITTELWERT BDMOYENNE DB.MEDIA BDMÉDIA
BDCONTAR Cuenta
el número de celdas que contienen números en una base de datos.
DCOUNT DBANZAHL BDNB DB.CONTA.NUMERI BDCONTAR
BDCONTARA Cuenta
el número de celdas no vacías en una base de datos.
DCOUNTA DBANZAHL2 BDNBVAL DB.CONTA.VALORI BDCONTAR.VAL
BDEXTRAER Extrae
de una base de datos un único registro que cumple los criterios
especificados.
DGET DBAUSZUG BDLIRE DB.VALORI BDOBTER
BDMAX Devuelve
el valor máximo de las entradas seleccionadas de la base de datos.
DMAX DBMAX BDMAX DB.MAX BDMÁX
BDMIN Devuelve
el valor mínimo de las entradas seleccionadas de la base de datos.
DMIN DBMIN BDMIN DB.MIN BDMÍN
BDPRODUCTO Multiplica
los valores de un campo concreto de registros de una base de datos que
cumplen los criterios especificados.
DPRODUCT DBPRODUKT BDPRODUIT DB.PRODOTTO BDMULTIPL
BDDESVEST Calcula
la desviación estándar a partir de una muestra de entradas seleccionadas en
la base de datos.
DSTDEV DBSTDABW BDECARTYPE DB.DEV.ST BDDESVPAD
BDDESVESTP Calcula
la desviación estándar en función de la población total de las entradas
seleccionadas de la base de datos.
DSTDEVP DBSTDABWN BDECARTYPEP DB.DEV.ST.POP BDDESVPADP
BDSUMA Suma
los números de la columna de campo de los registros de la base de datos que
cumplen los criterios.
DSUM DBSUMME BDSOMME DB.SOMMA BDSOMA
BDVAR Calcula
la varianza a partir de una muestra de entradas seleccionadas de la base de
datos.
DVAR DBVARIANZ BDVAR DB.VAR BDVAR
BDVARP Calcula
la varianza a partir de la población total de entradas seleccionadas de la
base de datos.
DVARP DBVARIANZEN BDVARP DB.VAR.POP BDVARP

 

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 (130)

I’m the co-founder of JustCBD company (justcbdstore.com) and am trying to expand my wholesale side of business. I am hoping anybody at targetdomain can help me 🙂 I thought that the most suitable way to do this would be to connect to vape shops and cbd retail stores. I was really hoping if someone could recommend a reliable web site where I can buy Vape Shop B2B Companies I am already checking out creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. Not sure which one would be the most suitable selection and would appreciate any guidance on this. Or would it be simpler for me to scrape my own leads? Suggestions?

Responder

единственный законный способ ликвидации компании с долгами субсидиарная ответственность тема знакома каждому бенефициару

Responder

Hi there! This blog post couldn’t be written any better! Reading through this post reminds me of my previous roommate! He always kept preaching about this. I’ll forward this information to him. Fairly certain he will have a good read. Many thanks for sharing!

Responder

Spot on with this write-up, I absolutely believe this website needs a great deal more attention. I’ll probably be back again to read through more, thanks for the information!

Responder

I was very happy to discover this page. I want to to thank you for your time due to this fantastic read!! I definitely loved every part of it and I have you book marked to look at new stuff in your web site.

Responder

An outstanding share! I have just forwarded this onto a co-worker who was doing a little homework on this. And he actually ordered me dinner because I found it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanx for spending time to talk about this subject here on your internet site.

Responder

There’s certainly a great deal to learn about this topic. I love all of the points you’ve made.

Responder

Greetings, There’s no doubt that your web site may be having internet browser compatibility problems. When I look at your website in Safari, it looks fine however when opening in IE, it has some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, excellent site!

Responder

When I originally left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and now whenever a comment is added I receive four emails with the same comment. Is there a means you are able to remove me from that service? Appreciate it!

Responder

I’m very happy to discover this page. I need to to thank you for your time due to this fantastic read!! I definitely enjoyed every little bit of it and I have you book-marked to look at new things on your website.

Responder

Next time I read a blog, Hopefully it does not disappoint me as much as this particular one. I mean, I know it was my choice to read, nonetheless I actually thought you’d have something interesting to talk about. All I hear is a bunch of moaning about something you could fix if you weren’t too busy searching for attention.

Responder

I must thank you for the efforts you have put in writing this site. I’m hoping to check out the same high-grade content by you later on as well. In fact, your creative writing abilities has motivated me to get my own site now 😉

Responder

This blog was… how do you say it? Relevant!! Finally I’ve found something that helped me. Thanks!

Responder

Good blog post. I absolutely love this site. Thanks!

Responder

Greetings! Very useful advice in this particular article! It is the little changes that will make the most significant changes. Thanks for sharing!

Responder

I seriously love your website.. Great colors & theme. Did you develop this website yourself? Please reply back as I’m wanting to create my very own blog and want to know where you got this from or exactly what the theme is called. Appreciate it!

Responder

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

Responder

Very good article. I certainly appreciate this website. Keep writing!

Responder

Good post. I learn something totally new and challenging on sites I stumbleupon everyday. It’s always interesting to read content from other writers and use a little something from other websites.

Responder

Good article. I am experiencing many of these issues as well..

Responder

Oh my goodness! Incredible article dude! Many thanks, However I am encountering issues with your RSS. I don’t know why I cannot subscribe to it. Is there anyone else getting identical RSS problems? Anyone who knows the answer can you kindly respond? Thanx!!

Responder

An outstanding share! I’ve just forwarded this onto a colleague who was conducting a little homework on this. And he actually bought me lunch because I discovered it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanx for spending time to discuss this issue here on your website.

Responder

Everything is very open with a very clear explanation of the challenges. It was really informative. Your website is very useful. Thank you for sharing!

Responder

An interesting discussion is worth comment. I do think that you should publish more about this subject, it might not be a taboo subject but generally folks don’t discuss such issues. To the next! Best wishes!!

Responder

Howdy! This post could not be written any better! Reading through this post reminds me of my previous roommate! He constantly kept talking about this. I am going to send this article to him. Fairly certain he’s going to have a very good read. I appreciate you for sharing!

Responder

Wonderful article! We are linking to this great content on our website. Keep up the great writing.

Responder

Hi there! I could have sworn I’ve visited this website before but after browsing through a few of the articles I realized it’s new to me. Anyhow, I’m certainly pleased I found it and I’ll be bookmarking it and checking back frequently!

Responder

Way cool! Some extremely valid points! I appreciate you penning this write-up and the rest of the website is really good.

Responder

Howdy! I just want to give you a huge thumbs up for the excellent info you’ve got here on this post. I will be returning to your website for more soon.

Responder

Good post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It will always be useful to read through articles from other writers and practice a little something from their websites.

Responder

naturally such as your internet site however you should take a
look at the spelling on several of your respective posts.
Several of them are rife with spelling issues and i also to locate it very troublesome to tell the simple truth nevertheless I will definitely come back again.

Also visit my page NestorKSapia

Responder

I could not resist commenting. Exceptionally well written!

Responder

bookmarked!!, I love your website!

Responder

An impressive share! I’ve just forwarded this onto a co-worker who has been doing a little homework on this. And he actually bought me dinner due to the fact that I discovered it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanks for spending some time to discuss this matter here on your internet site.

Responder

After looking into a number of the blog posts on your website, I truly appreciate your technique of blogging. I bookmarked it to my bookmark site list and will be checking back soon. Please check out my web site as well and tell me how you feel.

Responder

Way cool! Some very valid points! I appreciate you penning this article and the rest of the site is also really good.

Responder

The next time I read a blog, I hope that it doesn’t fail me just as much as this particular one. After all, Yes, it was my choice to read through, but I truly thought you would have something interesting to talk about. All I hear is a bunch of complaining about something that you could possibly fix if you were not too busy looking for attention.

Responder

I could not refrain from commenting. Perfectly written!

Responder

Can I just say what a relief to uncover someone that genuinely knows what they are discussing on the net. You definitely realize how to bring a problem to light and make it important. A lot more people must look at this and understand this side of your story. It’s surprising you are not more popular because you definitely have the gift.

Responder

I love it whenever people come together and share thoughts. Great site, continue the good work!

Responder

I’m impressed, I must say. Rarely do I come across a blog that’s both educative and interesting, and without a doubt, you’ve hit the nail on the head. The problem is something which not enough people are speaking intelligently about. I’m very happy that I came across this in my search for something regarding this.

Responder

You’re so cool! I don’t suppose I’ve truly read something like that before. So nice to discover another person with some genuine thoughts on this issue. Really.. many thanks for starting this up. This site is something that is needed on the internet, someone with a bit of originality!

Responder

You have made some really good points there. I looked on the web to find out more about the issue and found most individuals will go along with your views on this web site.

Responder

I was extremely pleased to discover this website. I need to to thank you for your time just for this wonderful read!! I definitely liked every bit of it and i also have you bookmarked to check out new stuff in your web site.

Responder

First of all I want to say wonderful blog! I needed a fast question that I’d
like to ask should you not mind. I had been interested to learn how you
will center yourself and clear your ideas just before writing.

I’ve had difficulty clearing my thoughts in getting
my thoughts on the market. I truly do enjoy writing nonetheless
it just may seem like the 1st ten or fifteen minutes are often lost just trying to figure out where to start.

Any suggestions or hints? Thanks!

Take a look at my website; MaileAKirson

Responder

Pretty! This was a really wonderful post. Many thanks for supplying this info.

Responder

Having read this I believed it was really enlightening. I appreciate you finding the time and energy to put this informative article together. I once again find myself personally spending a significant amount of time both reading and commenting. But so what, it was still worth it!

Responder

Good post. I learn something totally new and challenging on websites I stumbleupon everyday. It will always be helpful to read articles from other authors and practice a little something from other websites.

Responder

Does your blog have a contact page? I’m having a tough time locating it but, I’d like to send you an e-mail. I’ve got some ideas for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it grow over time.|

Responder

Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how can we communicate?|

Responder

I used to be able to find good information from your articles.

Responder

Everything is very open with a clear clarification of the issues. It was really informative. Your website is very helpful. Many thanks for sharing!

Responder

This is a topic that’s near to my heart… Take care! Exactly where are your contact details though?

Responder

This is the right blog for everyone who wishes to understand this topic. You understand a whole lot its almost tough to argue with you (not that I personally would want to…HaHa). You certainly put a new spin on a subject which has been written about for ages. Wonderful stuff, just excellent!

Responder

Hi, I do think this is an excellent website. I stumbledupon it 😉 I will come back once again since I book-marked it. Money and freedom is the best way to change, may you be rich and continue to help other people.

Responder

Excellent blog you have got here.. It’s difficult to find high-quality writing like yours these days. I truly appreciate people like you! Take care!!

Responder

Next time I read a blog, I hope that it does not fail me just as much as this particular one. After all, I know it was my choice to read through, but I truly believed you would have something helpful to say. All I hear is a bunch of complaining about something that you can fix if you were not too busy seeking attention.

Responder

Heya i am for the first time here. I found this board and I in finding It really helpful & it helped me out much. I hope to present something back and help others like you helped me.|

Responder

The next time I read a blog, Hopefully it does not disappoint me just as much as this particular one. I mean, I know it was my choice to read through, however I truly thought you would have something helpful to talk about. All I hear is a bunch of crying about something you could fix if you weren’t too busy searching for attention.

Responder

This page really has all of the info I needed about this subject and didn’t know who to ask.

Responder

Achieving your fitness goal doesn’t need a certified personal trainer or an expensive gym membership, it is not hard to exercise at home. It is easy to go down a training and fitness rabbit hole, however, when you’re looking for the best home exercise equipment to outfit your personal home gym.

Responder

Howdy! I could have sworn I’ve visited this website before but after going through some of the articles I realized it’s new to me. Nonetheless, I’m certainly pleased I stumbled upon it and I’ll be bookmarking it and checking back often!

Responder

Hmm it appears much like your blog ate my first comment (it was actually super long) and so i
guess I’ll just sum it a few things i submitted and say, I’m thoroughly enjoying your site.
I as well am an aspiring blog blogger but I’m still unfamiliar with everything.
Are you experiencing any recommendations for inexperienced blog writers?
I’d genuinely appreciate it.

My web site – RemonaRNgoun

Responder

Oh my goodness! Incredible article dude! Thank you so much, However I am experiencing issues with your RSS. I don’t understand why I am unable to subscribe to it. Is there anybody getting identical RSS problems? Anybody who knows the solution will you kindly respond? Thanx!!

Responder

You made some good points there. I checked on the internet to find out more about the issue and found most individuals will go along with your views on this web site.

Responder

I was more than happy to find this web site. I want to to thank you for ones time for this particularly wonderful read!! I definitely enjoyed every little bit of it and I have you bookmarked to see new stuff in your website.

Responder

Hey there! I simply wish to give you a huge thumbs up for your great information you have right here on this post. I will be returning to your site for more soon.

Responder

Great info. Lucky me I came across your site by accident (stumbleupon). I have book marked it for later!

Responder

Good post. I am dealing with some of these issues as well..

Responder

Saved as a favorite, I love your website!

Responder

I blog frequently and I truly thank you for your content. This great article has really peaked my interest. I am going to bookmark your website and keep checking for new information about once per week. I subscribed to your RSS feed as well.

Responder

Good post. I learn something totally new and challenging on blogs I stumbleupon on a daily basis. It will always be helpful to read through articles from other writers and practice something from their web sites.

Responder

Next time I read a blog, I hope that it doesn’t disappoint me as much as this particular one. I mean, Yes, it was my choice to read, but I really believed you would have something helpful to say. All I hear is a bunch of moaning about something that you could fix if you were not too busy searching for attention.

Responder

After I initially left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now whenever a comment is added I recieve four emails with the same comment. Perhaps there is a means you can remove me from that service? Cheers!

Responder

Hi, I do think this is an excellent site. I stumbledupon it 😉 I’m going to return once again since i have book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide other people.

Responder

Thank you for sharing superb informations. Your website is so cool. I am impressed by the details that you have on this site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the info I already searched everywhere and simply couldn’t come across. What an ideal website.

Responder

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

Responder

I was able to find good advice from your blog articles.

Responder

I love reading an article that will make people think. Also, thank you for allowing me to comment!

Responder

Good day! I could have sworn I’ve been to this site before but after going through some of the articles I realized it’s new to me. Regardless, I’m definitely delighted I came across it and I’ll be bookmarking it and checking back regularly!

Responder

I used to be able to find good info from your content.

Responder

I absolutely love your site.. Great colors & theme. Did you create this website yourself? Please reply back as I’m wanting to create my own site and would like to find out where you got this from or what the theme is named. Kudos!

Responder

I was able to find good information from your blog posts.

Responder

An outstanding share! I’ve just forwarded this onto a coworker who had been conducting a little homework on this. And he actually bought me breakfast because I discovered it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanks for spending time to discuss this issue here on your blog.

Responder

I have read several just right stuff here. Certainly worth bookmarking for revisiting. I wonder how so much effort you place to create one of these great informative website.|

Responder

Greetings! Very helpful advice in this particular article! It is the little changes that make the most important changes. Thanks for sharing!

Responder

Wow! Thank you! I constantly wanted to write on my website something like that. Can I take a fragment of your post to my site?

Responder

I’m amazed, I have to admit. Rarely do I encounter a blog that’s both educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something which not enough people are speaking intelligently about. I am very happy that I found this in my hunt for something relating to this.

Responder

You are so interesting! I don’t believe I have read through a single thing like that before. So nice to find someone with some original thoughts on this subject. Seriously.. thank you for starting this up. This website is one thing that is required on the web, someone with a little originality!

Responder

May I just say what a comfort to discover somebody who truly understands what they’re talking about on the web. You actually know how to bring a problem to light and make it important. A lot more people ought to look at this and understand this side of your story. I can’t believe you are not more popular given that you most certainly possess the gift.

Responder

Nice post. I learn something new and challenging on websites I stumbleupon everyday. It’s always helpful to read through articles from other writers and practice something from other websites.

Responder

Your style is unique in comparison to other folks I’ve read stuff from. Many thanks for posting when you have the opportunity, Guess I’ll just book mark this site.

Responder

I could not resist commenting. Exceptionally well written!

Responder

It’s an remarkable paragraph in favor of all the internet users; they will take benefit from it I am sure.|

Responder

Your style is very unique compared to other folks I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this site.

Responder

This is the right blog for anyone who wishes to understand this topic. You know so much its almost hard to argue with you (not that I personally will need to…HaHa). You certainly put a new spin on a topic that’s been written about for ages. Great stuff, just excellent!

Responder

After going over a few of the blog posts on your site, I honestly appreciate your technique of blogging. I book-marked it to my bookmark webpage list and will be checking back soon. Please visit my website as well and let me know how you feel.

Responder

Great blog you have here.. It’s hard to find high quality writing like yours nowadays. I seriously appreciate people like you! Take care!!

Responder

An interesting discussion is definitely worth comment. I think that you should publish more about this issue, it may not be a taboo subject but typically people don’t discuss such topics. To the next! Kind regards!!

Responder

Hi, I do believe this is a great site. I stumbledupon it 😉 I will revisit yet again since i have book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

Responder

Its such as you read my mind! You seem to grasp a lot about this, such as you wrote the e book in it or something. I think that you simply could do with a few to pressure the message house a little bit, but other than that, this is great blog. A fantastic read. I’ll certainly be back.|

Responder

I blog frequently and I seriously appreciate your information. The article has really peaked my interest. I’m going to take a note of your website and keep checking for new information about once per week. I subscribed to your RSS feed as well.

Responder

Pretty! This has been an incredibly wonderful post. Many thanks for supplying this information.

Responder

I really like it whenever people come together and share thoughts. Great site, stick with it!

Responder

I’m impressed, I have to admit. Rarely do I come across a blog that’s both equally educative and engaging, and without a doubt, you’ve hit the nail on the head. The issue is something that too few people are speaking intelligently about. Now i’m very happy that I stumbled across this during my hunt for something concerning this.

Responder

Nice content on this page admin!!

Responder

This site was… how do you say it? Relevant!! Finally I’ve found something that helped me. Thanks a lot!

Responder

You have made some really good points there. I checked on the net for more info about the issue and found most people will go along with your views on this web site.

Responder

There is certainly a lot to learn about this topic. I love all the points you made.

Responder

bookmarked!!, I like your blog!

Responder

After I originally left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now whenever a comment is added I get 4 emails with the exact same comment. Perhaps there is an easy method you can remove me from that service? Many thanks!

Responder

It’s hard to come by educated people on this subject, but you seem like you know what you’re talking about! Thanks

Responder

I blog frequently and I genuinely appreciate your content. The article has really peaked my interest. I am going to take a note of your blog and keep checking for new information about once a week. I subscribed to your Feed too.

Responder

Very good article! We will be linking to this great post on our website. Keep up the good writing.

Responder

Your style is so unique compared to other folks I’ve read stuff from. Thank you for posting when you have the opportunity, Guess I’ll just book mark this site.

Responder

I like it whenever people get together and share ideas. Great site, keep it up!

Responder

Hi! I just would like to offer you a huge thumbs up for your great info you’ve got here on this post. I will be coming back to your web site for more soon.

Responder

This page truly has all the information and facts I needed about this subject and didn’t know who to ask.

Responder

Good info. Lucky me I found your site by accident (stumbleupon). I have book marked it for later!

Responder

This is a topic that’s near to my heart… Take care! Exactly where are your contact details though?

Responder

Thank you a lot for sharing this with all of us you actually know what you’re talking approximately! Bookmarked. Please additionally consult with my web site =). We can have a link exchange agreement among us|

Responder

Nice post. I learn something new and challenging on blogs I stumbleupon every day. It’s always interesting to read through content from other writers and practice a little something from their sites.

Responder

What’s up i am kavin, its my first occasion to commenting anyplace, when i read this paragraph i thought i could also make comment due to this good article.|

Responder

Good blog you have here.. It’s difficult to find high-quality writing like yours nowadays. I truly appreciate individuals like you! Take care!!

Responder

This blog was… how do I say it? Relevant!! Finally I have found something that helped me. Thanks!

Responder

There is definately a lot to learn about this issue. I love all the points you made.

Responder

It’s hard to find educated people on this topic, however, you sound like you know what you’re talking about! Thanks

Responder

After going over a number of the blog posts on your blog, I really like your technique of writing a blog. I book marked it to my bookmark webpage list and will be checking back soon. Please check out my web site as well and let me know your opinion.

Responder

An outstanding share! I’ve just forwarded this onto a colleague who was conducting a little homework on this. And he actually ordered me lunch because I discovered it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending some time to talk about this topic here on your web page.

Responder

I used to be able to find good info from your blog articles.

Responder