Excel Essentials: The Complete Excel Series - Level 1, 2 & 3 (Udemy.com)

I was taking this course in my spare time, which I didn't have much of due to the nature of my work. However, Alan explained everything clearly. He answered all my questions. He fielded questions from other students and turned them into valuable lectures that were also helpful. I highly recommend this course to anyone who wants to take his or her Excel skills to the next level. I know that Microsoft has recently made some major updates to Excel 365, and I don't know if Alan will create a new course for 365 or incorporate the updates into this existing course. Either way, I'm a fan of this course, and I highly recommend it. I'm also planning to take more courses from Alan Jarvis because he is such a darn good teacher.

Quite good but not that great, because it could be more useful and fruitful if you make project to do, so at the end we could have nice and beautiful product being made by Microsoft Excel.

the course is complete BUT .... First of all, I mention the flaws. This course has serious defects and errors for understanding, especially if you are a novice. First of all some lessons are explained in a hurry, and for this reason you have to review them several times to understand them. Number 2, the English subtitles have errors, making it difficult to understand somewhere if you are not a native English speaker. Number 3, a few lessons are not superfluous if you use excel 2019, as the instructor in the course uses an older version. Number 4, some downloadable files of the various sessions are different from those seen in the video course, making it an obstacle to follow the lesson step by step, especially if you are a novice. The positive aspects of this course are VBA, really complete and well done except for a few lessons, the assistance, the instructor almost always tries to answer every question, and the fact that it is a complete video course.

OK guys, I just completed the entire course. I was super impressed. In fact, I was about halfway through when I started thinking, "I wish Udemy had a way to tip instructors." I got the course on sale and it was more than worth what I paid for it. If you're only interested in a particular section, I put the SECTION in all caps so it's easy to find the section of interest. The course is very well laid out. The progression through the lessons is very logical and he frequently recalls things you learned in previous lessons as they apply to the current lesson in case you forgot without slowing down the lesson. Additionally, every section ends with student questions answered lessons where he takes the time to work through practical solutions for questions that have been sent to him. If you have a question, he is very responsive. He usually answers your questions in two or three days. SECTION 1 starts super, super basic. As in, if you just landed on the planet and this is the first time you have ever heard of Excel, you will still be able to follow the lessons in section one. If you have been using Excel for years, you're probably only going to pick up a few tricks in the entire section. I watched almost all of section 1 at 2X speed. Most of it was stuff I already knew, but I picked up a handful of tips so I would still recommend checking out section one. SECTION 2 was very informative for me. I knew a minimal amount about functions and have used them in the past, but this section taught me sooo much more. As a tip, when you are working through the lessons, make super detailed notes on the sheet your working on of exactly how the function is working. I didn't do this when I started and, when I went back to those formulas, I couldn't remember what exactly they were doing. Also, breaking down every element of the formula makes it really obvious if you don't understand something. This is particularly useful when you get to some of the really complex compound formulas. I love all of the practical exercises in section 2. I definitely learn best by doing and he had great practical exercises with hints to get you started. They were just hard enough to make you think, but not so hard you were ever tempted to give up. Later exercises incorporate older lessons and build on them so you don't lose what you learned. SECTION 3 I had virtually no experience with VBA prior to this course other than someone telling me very specifically to go in and make a very specific change to existing code to make it do what I needed. I learned a lot from this course and look forward to applying it to workbooks I build in the future. It doesn't cover everything there is to know about VBA, but it's a really solid start and covers everything the average user is going to need. WHY NOT A PERFECT 5? I can only think of two negative things to say. 1. I'm using Excel 2019 and he is using an older version in the lesson. So, very occasionally, I would run across a lesson that didn't work as demonstrated. I would have to scour the internet for a solution or ask him for help with the lesson and wait for an answer. This happened with a dozen lessons at the most so it's not that big of a deal. I tried to post the solutions in the questions section so, if you run into the problem, search "Excel 2019" in the questions section and you might find a solution without having to scour the internet. 2. I really wish there were practical exercises in Section 3. I realize that's probably more difficult to accomplish than for sections 1 and 2 because some of the problems would have easily a half dozen different solutions and probably more once you start working in VBA, but I still would have found it really helpful because I am so much a hands on learner. Section 3 has over 3 hours of student questions answered lectures though so there are a lot of great solutions in those lessons. Overall, I highly recommend this course and I have already used a bunch of what I learned. It has made some of the tasks at work MUCH more efficient and far less prone to errors. Thanks Alan! You put together a great course.

Fantastic course with detailed explanation and examples

I found this course extremely comprehensive, the time that Alan takes to explain everything is second to none, easily the most comprehensive course i have ever done. I definitely feel i have learned so much from this course, and that is down to the way it is taught. If you are looking for a comprehensive course on Excel, then this should be your first port of call. Thank you Alan, for instilling all the new knowledge i now have.

Comprehensive and very useful, thanks a lot Alan Jarvis!!!

A very simplistic and straightforward explanation of all the basics. A lot of tricks and shortcuts that I had learnt as a kid being covered in just the basics. Looking forward to seeing how the intermediate goes.

This was my first encounter with VBA, and it just let me go past the initial fear of starting something new.
I learnt a lot and am determined to carry on learning VBA and using it in my daily work routines.
Thanks a lot.

The course has been amazing and Mr. Alan was also really good. Alan responds to doubts mostly within 24hrs which is really good. The course is really good if you're working with excel. Only just one suggestion, even though Mr. Alan covered most of the topics, I feel there are a few which he left. It would be great if he covers that also even though they might not be that important.

Clear concise lectures

The simplest and most effective explanation of VBA programming I have ever seen. Thanks, Alan!