the "built in macros" are internal programs built into the fixture that operate under sound active, master/slave modes
Well, im not sure if i completely understand what you mean by how to make the colors. But im going to take a shot at explaining it, hopefully it is what you are asking for.
OK, so you have RGBW...The red,green,blue are your primary colors. With these three colors you can create any color in the visible light spectrum. If you mix green and red you get yellow, green and blue you get cyan. Red and blue you get magenta. now, with that, you can lower one of those two primary colors from 100%/100% to say 100%/50% this will change the color (ex: green 50%-red 100% you will get more of an orange color) and this goes all the way around the color wheel. This flexability gives you countless number of lighting combinations
The white LED are added because color LED diodes are not color temp matched perfectly (this is with 98% of all LED fixtures out there) So, when you put RGB to 100% you get a white, but it is more of a dull white. Not the white that you would like to use for, say, lighting up a promotional poster. So, to get around this, lighting companies added white diodes (some also added amber diodes) this is so that your white is WHITE not a dull white. The amber diodes in other fixtures was added to give a warmer color for when you are shinging the lights on skin tones. Perfect for interviews, theatre, or other events where cameras are involved. The white LED apears "cool" in color temp on cameras. (side note: great way to make someone look sick on stage "Zombie like" is to use RGB vs warmer colors or white LED)
The color mixing comes down to your own personal preference. My color blue has a small bit of magenta in it....where as your blue may just be blue its all in how you want it to look like i attached a photo of a color spectrum wheel for you to see how the colors mix hope this all helps you out. Enjoy