"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on concepts learned in the first course, you will continue to expand your knowledge of Excel, particularly with respect to the new (as of 2020) dynamic array functions and formulas. Dynamic array formulas create the foundation for "modern" Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)". This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) learn dynamic array functions and how to create dynamic array formulas to accomplish many productive tasks in Excel; 2) become affluent in a variety of lookups (two-way forward lookups, one-way reverse lookups, and two-way reverse lookups) and create Top 5/Bottom 5 lists; 3) learn numerous advanced data management techniques, including filtering for multiple criteria, conditional drop-down lists, reconciliation problems, creating repeating arrays of other arrays and sequences, and randomizing (with and without repetition); and 4) learn how to create professional dashboards using Pivot Tables, Pivot Charts, and Power Query. The course is organized into 5 Weeks (modules). To pass each module, you'll need to complete two programming assignments and a mastery quiz (the final module does not have programming assignments). Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!"
BG
Charlie is an AMAZING instructor - I learned a lot, and I wouldn't have if it weren't for his teaching style!
TK
It's the best course for Excel and for beginners and I really enjoyed learning this whole and it was a great experience.
FV
Good course. A few inaccuracies in terminology for finance, and the use of Imperial units of measurement (old feet, US gallons and others), are the shadows I can see from the bright picture.
RW
Very well designed course. There are some very challenging assignments that really improved my understanding of excel. I'm looking forward to Part 3.
WM
It is Very Clearly explained! very good examples and exercises! Also learn how to solve problems not only how to use the excel as a tool.
YK
I have a great time during this course. I suggest everyone join this course, it helps for your future life. Thanks Charlie.
SM
A nice step up from Part 1. The instructor does a good job of setting up the course. He provides files so you can work along with him.
CF
Great course, with in depth explanation of very topic which can be used in different fields such as engineering, finance, etc.
MR
The course was so interesting. I have learnt a lot of things from this course. I hope it will help other to improve their skill in excel. Thank you.
AV
Very interesting and challenging course. I have learned so much more about Excel that I did not know before. The Assignments were great and a good tool to test what you have learned.
AK
sir charlie explains things very well , the assignments are good . the course was nice , hope to get more examples regarding business scenarios too.Nice course
MA
This part of the training was little dificult as Stats are not used by me regularly. The stat concepts were also learned in this session
显示：20/148
Excellent learning. Learnt lot of things. Thanks to the instructor. Only suggestion is to provide simple tasks at the end of each screen casts.
Some assignments are TOUGH, and they really make you think outside of the box for the solutions. I recommend this if you really want to learn the mindset of how to "code" through Excel!
As an Industrial Engineering student, this course also reinforced some of the concepts I've been learning in my classes (financial applications, optimization, statistics, among others). If you're someone who's taking these classes, this course will SURELY help you, not only in learning the Excel side but also in understanding the concepts.
Thank you Charlie, I have learned so much about not only Excel & its functions, but also thanks to your detailed explanations I have a better understanding of a lot of financial & statistical terminology that I previously had no idea about, for example compound interest. I hope eventually to do Part 3 when it comes out, but in the meantime I am going to attempt the Visual Basic problem solving course
sir charlie explains things very well , the assignments are good . the course was nice , hope to get more examples regarding business scenarios too.
Nice course
Very well designed course. There are some very challenging assignments that really improved my understanding of excel. I'm looking forward to Part 3.
Que alegría aprender de esta manera. El curso agregó mucho valor a mi vida, y lo más importante, en vista a que soy docente, estoy seguro agregará mucho valor a mis estudiantes por cuanto pondré a disposición del proceso enseñanza - aprendizaje todo o gran parte de lo aprendido en este curso. Gracias infinitas a coursera y a mi docente Charlie Nuttelman
A very intricately designed course on the advanced functions of Excel. The expertise of the instructor is visible in his teachings and explanations! Enjoyed the course very much!
Charlie Nuttelman is the Excel guy. His explanations are great and clear. He makes you work to fully understand each function and how to apply it in a few cases. I sincerely hope he goes on developing this kind of courses. Thank you so much for this wonderful learning experience!
This course supplies transparent information that helps to provide financial and data analysises as well as presents new facts about INDEX, OFFSET, MATCH functions and DATA VALIDATION to create vivid automatic tables. Thank Charlie Nuttelman for such a great work!
Very interesting and challenging course. I have learned so much more about Excel that I did not know before. The Assignments were great and a good tool to test what you have learned.
Followed Everyday Excel, Part 1 and 2 and I have to say I went from complete noob to an actual advanced user of Excel. Absolutely worth it!
Great class with very useful information and techniques that are directly applicable to real world use.
The instructor is very professional and one can learn a lot from his lessons.
Very helpful and the Modules are easy to learn.
Very useful.
It was a wonderful journey. Learned so many new functions and techniques that would definitely help me. The best part of the course were the assignments, which are fun to solve. I would highly recommend to take this course.
The learning experience is directly related to the challenge presented on course. Good content and quality assignments for all excel level users.
This part of the training was little dificult as Stats are not used by me regularly. The stat concepts were also learned in this session
It is Very Clearly explained! very good examples and exercises! Also learn how to solve problems not only how to use the excel as a tool.
Fantastic teacher and wonderful exercises that truly make you use everything you have learned in the course. 100% recommended