Blogs
The Excel Club
The website by Paula Guilfoyle has a very active blog that is updated on a weekly basis and YouTube channel with tips. It is dedicated not only to Excel but to PowerBi, Power Pivot and Power Pivot and moving to more advanced topics. The weekly tips are definitely very good as a update or for learning news things in Excel and if you want they have a more formal training via online courses and also Corporate Training. I recommend you to sign for her weekly newsletter.Chris Dutton from Maven Analytics.
He is great for beginners to more advanced topics and terrific explaining things step by step. I became familiar with him through his Udemy courses and if you are looking for reasonably priced Excel Training I highly recommend you to check his courses. He covers topics such Excel, Pivot tables, data visualization with Charts, Power Pivot and Power Query and Power Bi.He has a weekly newsletter with weekly tips. When you go to the website you will be offered a free ebook with more than 75 Excel tips from beginner to advance and this will also sign you to their weekly newsletter. Every week they will send you an email with Excel tips from covering all levels. The tips are hosted in their YouTube channel.
Leila Gharani from Xelplus
Again you can her free ebook with the Top Excel Formulas in her website and be subscribed to her newsletter. Her tips are almost weekly and she has as well a YouTube channel. She offers her online couses in her website as well as in Udemy She covers more beginner issues in some of her courses and moves to more advanced topics such as advanced formulas, dashboards and data visualization with charts and excel VBA and macros.Chandoo
It is another website dedicated to Excel, Power Power Pivot and Query and Power BI as well as dashboards and charts. You have a significant amount of resources to learn about formulas and other topics and you will also find free templates to download. Like in the previous cases you can sign for the weekly newsletter at the bottom of the page and they have a YouTube channel that is updated quite regularly with tips and tutorials. They also have a section dedicated to more formal training in their website.MyOnlineTrainingHub with Mynda and Phil
This a great site dedicated to Excel, and everything related to it (PowerQuery, PowerBI, dashboards, advanced Excel, etc). Mynda has great courses available in the website and shares resources and free tutorials both in her blog and her YouTube channel. She also has a newsletter I would recommend you to sign up for.
If you already have a good idea of Excel and want to move to more advanced topics these are my favourite courses.These are courses that I have personally done myself and fully completed. As I go through other courses I will continue updating the list of courses.
Microsoft Excel - Advanced Excel Formulas & Functions by Chris Dutton.
This course does cover some basics but if you have no idea of Excel it might be a good idea to start with something else as it jumps fast into formulas and advanced ones. You will definitely revisit the course to refresh your knowledge or get ideas for any excel worksheet you are working on.
Microsoft Excel - Data Analysis with Excel Pivot Tables by Chris Dutton.
Pivot tables have become ubiquitous for analysing data and it is very important to know how to work with them. It starts with the basics and moves to more advanced techniques. It covers more advanced technn teh iques such as Pivot charts.
Visually Effective Excel Dashboards by Leila Gharani
Great course by Leila Gharani to learn about dashboards and how to create them, it covers the basics but jumps fast into the most advanced topics. If you are a beginner it might be better to cover some of the basics and learn more advanced formulas before you go for this course. You will revisit this course and you are going to be practising quite a bit in order to learn the techniques.
ExcelGuru
This is a blog and excel community with a very good reputation if you are looking for Excel tips and learning in general. Like the previous blogs they have a newsletter and they offer a training in their website as well as a forum. By subscribing to their newsletter you will get freebies about Excel, Power Bi, etc over a period of 4 weeks.Udemy courses
Microsoft Excel - Advanced Excel Formulas & Functions by Chris Dutton.
This course does cover some basics but if you have no idea of Excel it might be a good idea to start with something else as it jumps fast into formulas and advanced ones. You will definitely revisit the course to refresh your knowledge or get ideas for any excel worksheet you are working on.
Microsoft Excel - Data Analysis with Excel Pivot Tables by Chris Dutton.
Pivot tables have become ubiquitous for analysing data and it is very important to know how to work with them. It starts with the basics and moves to more advanced techniques. It covers more advanced technn teh iques such as Pivot charts.
Microsoft Excel - Data Visualization, Excel Charts & Graphs by Chris Dutton.
This is a course covering visualizations and a course that in my opinion, should be done before you start trying to learn Dashboards. The course below by Leila is terrific and a fantastic course to learn dashboards but if you are new to charts or the material you know is a bit rusty, you are going to find yourself having to repeat again and again the last lessons in the course below. Ideally you would do advance excel formulas in Excel (either the course above or the one by Leila in Udemy) and move on to this course (or the one by Leila in Udemy) before advancing to the materials for dashboards in the course below.
Visually Effective Excel Dashboards by Leila Gharani
Great course by Leila Gharani to learn about dashboards and how to create them, it covers the basics but jumps fast into the most advanced topics. If you are a beginner it might be better to cover some of the basics and learn more advanced formulas before you go for this course. You will revisit this course and you are going to be practising quite a bit in order to learn the techniques.
An alternative that is starting to be more and more used for analysing and presenting data is PowerBi (Tableau in bigger much, much bigger contexts). This is a great video explaining the advantages and disadvantages of using PowerBI vs using Dashboards
Power BI vs Excel Dashboards - And the winner is... by MyOnlineTrainingHub
There are pros and cons, as with everything, and in some situations it might be better to use PowerBI and in others to go for a dashboards. Regardless of which option you choose, the video above provides a good explanation of the best learning routes for both.
If you want to follow or add a new way of presenting reports in the way of a PowerBI report the following are great courses to get you started:
Microsoft Excel: Business Intelligence w/ Power Query & DAX by Chris Dutton
Again a great beginners course to get you started with PowerQuery and Dax and getting you to more advance levels. It starts slow, goes little by little, provides quite a few examples to practice and the explanations are great. I think Chris is really amazing at explaining things to beginners and does get you to a quite advance level.
Other courses in the pipeline that might be interesting to anyone reading this:
All by Leila Gharani, they are great courses and they will get you to a more advance level from a beginners stage. You will have to work through the videos, but Leila is also great at explaining things to beginners, she does get into more advanced material and it becomes noticeable as you go along, so be prepared to work through the tutorials.
No comments:
Post a Comment