Hey man, great job with the VFX you tried to make, attempting a tornado is always fun and there’s many ways to do that. You have a lot of the elements required like smoke, embers, cones etc but I would attempt this in a totally different way and I’d suggest you to do that too if you want to make your tornado look better.
Firstly, tutorials are not references. Be careful learning from people with a sketchy reputation, specially if they’re for your project & PORTFOLIO class. 
That being said, a big NO NO NO to spawning a tonne of particles and using an orbital module. Instead, try creating a cone shaped mesh and make a shader that pans a texture along them. Here are a few examples of this being done:
Check out some of the entries for 12 - Tornado - Real Time VFX
Now to the fireball, good job learning from the tutorial but now build upon that and push it even more! Currently the projectile just appears and disappears. Add a cast / spawn effect when it creates. Go ahead and make an impact effect when it hits the sphere.
Lastly, try keeping your presentation clean. Don’t show unnecessary effects, fly around a room or numbers on a HUD. Make a clean, neutral room to show your VFX.
For the triggering you’ll have to make a blueprint and create an input mouse click or input K whatever and hook that up to a spawn emitter at location. Next, place an empty actor in your scene where you want the effect to spawn and then select it in blueprint and do a get actor location. Plug that into your spawn emitter inside the location and from the drop down select your particle system.
Hope this helps!