

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Discover free excel tutorials and courses offering dashboard tips, chart tricks, advanced formula techniques, and more. Learn from experts and enhance your excel skills. Recommended by felix valecillos and ade vaughan.
Typology: Cheat Sheet
1 / 2
This page cannot be seen from the preview
Don't miss anything!
Free Tutorials Courses to help you succeed Favorite Resources Sharing & Learning Feel free to share this with anyone who can benefit! Browse through my free Excel tutorials to discover dashboard tips, chart tricks and advanced formula techniques. If you'd like to learn Excel in a structured way and in your own time, check out my bestselling courses: 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.
Free Tutorials Start Learning Browse 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) 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)
Name Department Salary Gary Miller Finance 60, James Willard Sales 39, Richard Elliot Finance 29, Robert Spear Sales 93, Romina Mun Finance 134, Paula Garza Sales 34, Robert Marquez Sales 134, Natalie Porter Procurement 45, Sum 571,568 =SUM(C3:C10) Average 71,446 =AVERAGE(C3:C10) Count salary 8 =COUNT(C3:C10) Count names 8 =COUNTA(A3:A10) Min 29,727 =MIN(C3:C10) Max 134,468 =MAX(C3:C10) Average Salary Sales 75,642.75 =AVERAGEIFS(C3:C10,B3:B10,"Sales")