In the 22nd session of Chandoo.org podcast, lets do some macros.
What is in this session?
VBA (or macros, automation) is a mystery for many of us. So in this podcast, lets unravel the mystery behind it and get you started with the awesome world of automation.
In this podcast, you will learn,
- What is a macro?
- What is VBA then?
- Reasons for using VBA Macros
- Automation
- Extending Excel’s capabilities
- Efficiency
- Applications
- How to get started with VBA Macros?
- Using Recorder
- Example Macro
- Going beyond recorder – Learning VBA
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Links & Resources for learning VBA Macros:
Getting started with VBA Macros – FREE 5 part crash course
- What is VBA & Writing your First VBA Macro in Excel
- Understanding Variables, Conditions & Loops in VBA
- Using Cells, Ranges & Other Objects in your Macros
- Putting it all together – Your First VBA Application using Excel
- My Top 10 Tips for Mastering VBA & Excel Macros
More tips, information, tutorials & resources on VBA.
VBA Example Macros
VBA Video tutorials
Books for learning VBA
- Excel 2010 Power Programming by John Walkenbach
- Excel VBA for dummies by John Walkenbach
- More recommended books on VBA
Recommended training program
Learn from basics to advanced VBA in a self-paced, on-demand online training from me. With more than 24 hrs of video training material, 50 lessons, 50 example macro workbooks, home work exercises, 2 class projects and an online community, you can quickly learn ways to automate your work & save time.
Please click here to know more about this program.
Transcript of this session:
Download this podcast transcript [PDF].
Are you new to VBA? What is stopping you from learning it?
When I first heard about VBA, I was not very interested (as explained in the podcast). But later when I got a job, I realized the potential of VBA and quickly embraced it.
What about you? Are you a VBA newbie? What is stopping you from learning it? Please share your fears and difficulties in the comments so that I can help you.
11 Responses to “Who is the most consistent seller? [BYOD]”
The Date column in the sample file is Text not Dates
[…] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]
Great Chandoo. Keep it up, Looking forward more from BYOD..
Thanks
With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.
This will do for invoice count
=COUNTIF(F:F,H12)
Instead of
=COUNTIFS(sales[SELLER],$H12)
Excellent document. How did you make the last graphic? Witch app. Thanks for answer.
Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))
Hi Chris,
=countif(sales [date],sales[date]) function is counting the unique dates in the table.
Vândalo
Excellent document!
Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?
How come the number should be smaller if there is more sellers?
Hi,
Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}
Please explain.
Thanks.