What sets this Excel course apart is that we don’t focus on quick fixes or specific tips and tricks. This course is for those who already understand Excel. The aim of the course is to elevate Excel models, to improve clarity, longevity, and transferability of these models, and to reduce mistakes and to encourage consistency in businesses as they work with Excel. Through this Excel course learners will gain the tools to decide whether or not to use Excel to solve their problem. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their Excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models. Finally users will get practical tips and steps for the finalization of a model, the automated checks, the manual run through, and general testing that one should do to ensure that their Excel model is accurate and complete.
GT
Great and valuable insights from MVPs and access to use PerfectXL Explore.
KP
Really a great Excel skill enhancing -learning experience. Thank you
RS
This course is very knowledgeable, informative, well presented and well prepared. It has been presented in an excellent way by all the instructors.
Showing: 13 of 13
This course was very helpful and full information, while keeping it simple. Although I couldn't apply everything I learned in the assignments, I can already think aboout building my spreadsheets in a different way. Consistent formatting and cell styles are some of the best tips I learned
I have been doing accounting and finance work for 8 years. I've worked with small & mid-sized corporations, nonprofits, and freelancers. I used what I learned in this course to build a model to track daily cash where I currently work. What I learned here helped me immensely. For my final assignment, I modified a large model I had built a few years ago as a volunteer project for a political organization. I realize now that the way I had built it made maintaining the model unnecessarily complicated. The raw data was on over 20 different sheets instead of being appended together (I appended it together for this course's assignment). I also had used ranges instead of tables because I wasn't comfortable with tables. I don't like how they show up in formulas, I don't like the way the default formatting looks, etc. However, I realized that adding new data to the main input sheet and having it auto-populate the output sheets & charts made updating the entire model with each new report so much easier.
Great and valuable insights from MVPs and access to use PerfectXL Explore.
This course is very knowledgeable, informative, well presented and well prepared. It has been presented in an excellent way by all the instructors.
An amazing course to learn exel modeling.
I have taken this course but it feels me that the learning outcome for me is average. They are focusing only on better visualization of excel sheet and protection of worksheets but my expectation was on better using of formulas.
Not interactive, hard to navigate, mostly reading. This is an online book, not a 'course"
Es un curso que ayuda a mejorar las habilidades para estructurar de manera profesional un modelo financiero.
Excelent
perfect
This course is really helpful with my excel skills, though it is advisable to contain more videos of how to operate Excel and the functions rather than words to describe only. In all, it is really helpful and comprehensive!
Really a great Excel skill enhancing -learning experience. Thank you
help in learning many things in excel