Learn More: Free Tutorials

Learn More Free Tutorials Browse through my free Excel tutorials to discover dashboard tips, chart tricks and advanced formula techniques.

Free Tutorials

After having taken other VBA courses, I can say with certainty that this is the best by far, it is amazing the amount of tips, tricks and shortcuts that Leila teaches us and others do not. It shows the effort and love that Leila delivers in each course she does. Felix Valecillos (Excel VBA course)

Courses to help you succeed If you'd like to learn Excel in a structured way and in your own time, check out my bestselling courses:

Start Learning

Favorite Resources Check out my list of favorite resources. It includes links to Excel books I've found helpful, courses on topics I'm interested in such as Power Query, data science and more.

Browse

Sharing & Learning Feel free to share this with anyone who can benefit!

This is a great course that taught me new things and also demonstrated new ways to apply existing techniques in ways I had not previously considered or knew where possible. I really enjoyed and benefited from the teaching style. Leila chunks the more complicated subject matter to make it easier to grasp. As a result my Excel capability just increased significantly and I have no hesitation recommending this course. Ade Vaughan (Excel Dashboard course)

IF Formula Basics 15000 Good Revenue > 15000 then "Good" Apps Fightrr Kryptis Perino Hackrr WenCaL Blend Sleops Accord Misty Wash Twenty20

Apps Fightrr Kryptis Perino Hackrr WenCaL Blend Sleops Accord Misty Wash Twenty20

15000 20000 Revenue > 15000 and <20000 then "Good"

15000 20000 Revenue > 15000 and <20000 then "Good", Revenue >=20000 is "Exceptional", rest is value

Revenue 11,649 7,718 15,033 18,701 14,432 17,990 11,022 17,760 30,400 20,400

Actual Revenue Budget Revenue 11,649 7,718 15,033 18,701 14,432 17,990 11,022 17,760 30,400 20,400

+-10 % Threshold value +-10 % Threshold symbol 10,593 6,409 12,724 19,102 15,113 18,181 13,112 16,854 30,237 18,477

20000 15000 Revenue >= 20000 or <=15000 then "Flag"

IF Formula Basics 15000 Good Revenue > 15000 then "Good" Apps Fightrr Kryptis Perino Hackrr WenCaL Blend Sleops Accord Misty Wash Twenty20

15000 20000 Revenue > 15000 and <20000 then "Good"

15000 20000 Revenue > 15000 and <20000 then "Good", Revenue >=20000 is "Exceptional", rest is value

Revenue 11,649 7,718 15,033 Good 18,701 Good 14,432 17,990 Good 11,022 17,760 Good 30,400 Good 20,400 Good

11649 7718 Good Good

Good Good 14432

Good

Good 11022

Good

Good Exceptional Exceptional

▲ ▼

Apps Fightrr Kryptis Perino Hackrr WenCaL Blend Sleops Accord Misty Wash Twenty20

Actual Revenue Budget Revenue 11,649 7,718 15,033 18,701 14,432 17,990 11,022 17,760 30,400 20,400

+-10 % Threshold value +-10 % Threshold symbol 10,593 6,409 12,724 19,102 15,113 18,181 13,112 16,854 30,237 18,477

20.42% ▲ 18.15% ▲

-15.94% ▼

10.41% ▲

20000 15000 Revenue >= 20000 or <=15000 then "Flag" Flag Flag

Flag Flag Flag Flag