in the advanced course, we will prepare you to become a power user of excel – this is your last step before specializing at a professional level. this module covers the use of array formulas, how to build them and use them effectively. financial functions are often used in businesses and excel has a variety of tools to help you with that. this module will help you set up a dashboard – learn how to visualise data through graphs and charts, create data models, and add interactivity.

this course is overall easier to understand only thing i felt was under explained in term of an individual concept was indirect function,\n\nrest everything is top notch\n\n#everyone_say_wow this specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. if you don’t see the audit option: when you enroll in the course, you get access to all of the courses in the specialization, and you earn a certificate when you complete the work. if you cannot use excel 2016 on a pc, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require excel. online degrees and mastertrack™ certificates on coursera provide the opportunity to earn university credit.

for example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it. even if you’re using excel for the first time, you can quickly get a hang of it.in this video, i try to cover a lot about the pivot table. this training is completely free and covers most of the excel topics you need to get started and become a pro. i just purchased microsoft home@student and one of the things i wanted to do was learn excel. you are a wonderful teacher and have made it so easy for me to grow my knowledge of excel — thank you for these wonderful videos and instruction! i hope to learn the program soon though it is a bit too fast for me but you are very clear. i used this function often in my work but now have a better understanding of how to use the different formats of number, dates and times. you entire module is a collection of all the lessons and i do not have to go anywhere else to find video. i was a teacher and hope to be a student of you very soon. i bow to you for your kind heart. can you provide me with a hard copy of the lecture which you are speaking so that it may be easy to understand for a person who is not that proficient in english. thanks you so much to all those who had given great platform to learn the excel and various things….. thank you sir, it is very useful for me to know about excel as i am working on excel in my office and it will be very useful for me. this training has helped me a lot and i am so grateful.