Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Excel Tutorials and Courses: Tips, Tricks, and Advanced Techniques, Cheat Sheet of MS Microsoft Excel skills

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

2021/2022

Uploaded on 04/13/2022

vicky-katariya
vicky-katariya 🇮🇳

3 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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.
Learn 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)
pf2

Partial preview of the text

Download Excel Tutorials and Courses: Tips, Tricks, and Advanced Techniques and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity!

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.

Learn 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")