Tips & tricks for getting the most out of MS Excel
See all
Members (56,306)
Excel Training's profile photo
Silicon Beach Training's profile photo
Graeme McRae's profile photo
Joaquim Reis's profile photo
Shengyue He's profile photo
Ashish Sharad's profile photo
praveen kumar's profile photo
Kehhua Chen's profile photo
Hassan Aaya's profile photo
muhand sabri's profile photo
Janusz Dzięcioł's profile photo
Hesly Cedeño P.'s profile photo
Fábio Ribeiro Ferraz's profile photo
Raymundo Pérez's profile photo
pawan singh's profile photo
Abhijeet Bhandari's profile photo
Ruben De Jesus's profile photo
Ramiro Barra's profile photo
Ravi Kumar's profile photo
sheetal agrawal's profile photo
JC FA's profile photo
Aik Koon Wee's profile photo
Ali Sohrabi's profile photo
Sylvie Gemme's profile photo

Stream

Join this community to post or comment

Ryan Wells

Discussion  - 
 
I've been doing VBA consulting for years, but I never had an official landing page on my website until yesterday. I'd appreciate your honest feedback!

http://wellsr.com/vba/consulting/
Let me complete your VBA projects so you can spend your time on the more enjoyable parts of life. Request my exceptional VBA consulting services today.
2
Jerry Nord's profile photo
 
I like that your pricing is up-front and I don't have to wade thru screen after screen of sales pitches to get to that. I was a little surprised that clicking on the Request for Service just opened up an email type window. Not sure what exactly I was expecting, maybe more detail on billing and service, but not just an email request. Have you looked into how the Power Tools integration into Excel 2016 is going to impact VBA? Waiting for someone to address that, your thoughts?
Add a comment...

David Garcia

Discussion  - 
 
Tips VBA en Excel Propiedad MultiSelect ListBox

 ·  Translate
1
Add a comment...

Mr DBA

Discussion  - 
 
Fill blank cells with value above in Excel
 ·  Translate
1
Add a comment...

Ryan Wells

Discussion  - 
 
Restrict your Excel UserForm TextBoxes to numbers only by using the VBA KeyPress event and KeyAscii argument.

http://wellsr.com/vba/2017/excel/vba-textbox-numbers-only-using-keypress-keyascii/
Learn how to restrict a VBA UserForm TextBox to numbers only using the VBA KeyPress event and KeyAscii argument. Negative numbers and decimals are also allowed.
1
Add a comment...

Adriano Pataro

Discussion  - 
 
 
Tem dúvida sobre qual gráfico usar para apresentar seus dados? Veja este infográfico que mostra os tipos de gráficos do Excel e em qual situação usá-los.
http://adrianopataro.com.br/tipos-de-graficos-do-excel/
 ·  Translate
1
Add a comment...
 
New #Excel Contest!
Submit a video of you building an Excel report or dashboard in 5 minutes or less. You could win an Xbox One! Check out Details: http://datapigtechnologies.com/blog/index.php/new-contest-for-2017-the-excel-5-minute-challenge/
2
Add a comment...

Clarence O'Neil

Discussion  - 
 
 
Powerful Tips for Excel Productivity - FREE COURSE ➡ http://bit.ly/2j0z5T6 #Excel #MsExcel #Microsoft
1
1
Add a comment...

Mr DBA

Discussion  - 
 
2 simple ways to get email address from text string
 ·  Translate
1
Add a comment...
 
Hello friends, how to copy ballots, with the same space, without having to do manually, ex L10, L20, L30, what function or formula to use to do this?
1
Add a comment...

QuickStart

Discussion  - 
 
 
Powerful Tips for Excel Productivity - FREE COURSE ➡ http://bit.ly/2j0z5T6 #Excel #MsExcel #Microsoft
2
1
Add a comment...

About this community

This community is for anyone interested in becoming better at Excel. Share your news, tips and tutorials. Community Rules: 1/ No spam 2/ English language links and comments only 3/ Links must have comments 4/ Discuss, don't sell 5/ Repeat offenders will be banned This community is moderated by Silicon Beach Training. If you would like to be a moderator, let us know!

Felipe Leal A.

Discussion  - 
 
Hi mates! In another group I asked the same thing already, but I wanna try to get some solution asap because this trouble makes me cry like a little baby xD. Does somebody know how I can process the answers from Multiple Options questions (or Multiple Selection, Multiselect)? Example:
- "X" said A, B y C
- "Y" said B, D y E
- "Z" said A, B y E
Excel Pivot/Dynamic Table just takes the first column. Can I make that one with Excel, or I have to jump to SPSS?
Some advice?
Regards!
--
Amigos/as, ¿alguno sabe cómo procesar datos de una pregunta de selección múltiple? Un ejemplo:
- "X" dice A, B y C
- "Y" dice B, D y E
- "Z" dice A, B y E
Tabla dinámica de Excel solo me recoge los de la primera columna.
Alguna ayuda por ahí? Saludos y gracias!

 ·  Translate
1
P. Korevaar's profile photo
 
I assume every answer option has its own column and that you want a pivot table. Make sure you can see the Field List (Under Pivottable tools > Analyze). Add every one of those columns to the Values Area. Row totals will be added automatically. 
Add a comment...
 
#MVPBuzz | Curso de Excel desde cero | #METN
Si eres un usuario con conocimientos mínimos de Excel, esta oportunidad excelente para ti, en el siguiente curso podras aprender todos los conceptos básicos para introducirte en el uso de la Hoja de cálculo
1a Temporada | https://goo.gl/GTmCzL 2a Temporada | https://goo.gl/lL5XLK
 ·  Translate
1
Add a comment...

Marco Tatta

Discussion  - 
 
Cari, non sono uno molto prepareato. Ho celle in excel e i in questo file vorrei importare un modulo in word o pdf e mettere questo modulo in secondo piaco stampabile, e negli spazi appositi far emergere quanto messo nelle celle dato che uqeste sono poi variabili. Come posso fare? Grazie di cuore
 ·  Translate
1
Add a comment...

David Garcia

Discussion  - 
 
Tutorial SQL en Excel Capitulo Nº 7

 ·  Translate
1
Add a comment...

Arun Banik

Discussion  - 
 
Count Total Number of Words in a Cell or Range in #Excel using #VBA ~ http://bit.ly/2jTeKjo

#microsoft #developers
Here in this article, I am going to share a simple method or code in Excel VBA on how to count total number of words in a cell or range in Excel.
1
吳百正's profile photoArun Banik's profile photo
2 comments
 
+吳百正 Brilliant. Thanks for sharing.
 ·  Translate
Add a comment...

Adriano Pataro

Discussion  - 
 
Tem dúvida sobre qual gráfico usar para apresentar seus dados? Veja este infográfico que mostra os tipos de gráficos do Excel e em qual situação usá-los.
http://adrianopataro.com.br/tipos-de-graficos-do-excel/
 ·  Translate
2
1
Add a comment...
 
Hoy por METN | #MVPBuzz | Como insertar un reloj en Excel
Ver video | https://goo.gl/au7iEr
En este video te mostraré como insertar un reloj que se actualice segundo a segundo dentro de MIcrosoft Excel, este tipo de herramientas te permitirá automatizar tareas en las que sea necesario crear registros de determinadas con base en tiempos.

 ·  Translate
1
1
Roiner Torres's profile photo

Kadr Leyn

Discussion  - 
 
Parsing Data Into Multiple Worksheets With Drop-Down Lists

In this study, the row is copied to the sheet according to the value selected from the drop-down list in column H, and the row is deleted.

https://youtu.be/S-KUHWysAqk

Details and example file here : https://merkez-ihayat.blogspot.com/2017/01/parsing-data-into-multiple-worksheets.html

3
Add a comment...
 
Buen dia

como puedo por media de una macro identificar las celdas vacías dentro de un rango y me indique en otra hoja cuales son.

Gracias
 ·  Translate
1
Mr DBA's profile photoFabian Valencia Diaz's profile photo
4 comments
 
No sale ni linea amarilla.
 ·  Translate
Add a comment...
 
Find the Second Largest Value when Duplicate numbers exist in range
=LARGE(IF(FREQUENCY($A$2:$A$7,$A$2:$A$7)<>0,$A$2:$A$7),2)
A2:A7 is the range consists of numbers
3
Gaurav Sangwan's profile photo
 
Did you get the result? Tried with random numbers but duplicate and couldn't get the desired result
Add a comment...