Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel. Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.
MK
I have learned a lot of important and useful excel secrets those will play a vital role in my career. I am very thankful to my instructors. Every lesson is so amazing. I have updated my excel skills.
HJ
I learned a lot from this course. Before starting this course I even can't plot a simple graph for my reports but then this course helped me learning mind blowing skills. Thanks Macquarie University.
MT
Just WoW !!! I really happy that i take these courses . I learn a lot but need to learn more. Thanks to all teachers specially Nicky mam for excellent teaching style. Getting ready for next task.
JW
Excellent course. The content is challenging for someone familiar with Excel looking to refresh and enhance skills. I definitely recommend taking the Essentials course before beginning this course.
RZ
Wow, I have no word to say about this course. Its video content, Structure is awesome. The tutor is good. Week assignments and quizzes are always ready to make our practice and make concept permanent.
MM
First of all I want to expand my gratitude. One of the best courses among all of mine my coursera. Teachers are really very helpful, teaching styles are impressive. Deserves more than five star.
MB
Awesome course, the videos are very easy going and if you practice along, it won,t be hard to pass all the exams with more than 905 marks. Thanks to faculties and the University offering the course.
KH
Great course. I have learned lots of good techniques creating pivot tables, slicer. Now i am very confident to make a dashboard for the management. I am looking forward to learn next courses in Excel.
SB
An EXCEL-lent course indeed! It makes "baffling" functions like pivot, working with criteria and combining/splitting texts very understandable. And I'm very happy to learn about tables and slicers.
JS
I really enjoyed this course! It has taught me a lot about Excel and its more advanced functions. Besides, the way all the topics are approached is very clear and easy to understand. Thank you! :)
TT
Many tips and new knowledge gained from this course: Name range, work with table, slicer, chart. If you want to find more intensive in each function, please check on this course. Thank Coursera team!
MJ
Some lessons felt more advanced than intermediate, but the exercises helped with critical thinking and problem solving. Some of the lessons were incredibly useful and applicable to my day to day work.
Showing: 20 of 3,995
I found the following areas to be particularly useful to learn about:
Combining and Changing Text
Extracting and Finding Text
Named Ranges
COUNTIFS and SUMIFS
Tables and Pivot Tables
It was a good experience. I have learned many new tools and how to work smartly. i recommend every Student and employee to go through this course because excel makes work easier. Thanks Coursera.
I would like to extend my thanks without exception to everyone who has participated in the creation of this amazing course. Seriously WOW!! Now I just feel very proud of being Macquarie University student knowing that my university has one of the best Excel training courses on all online training platforms.
Thank you so much, looking forward to start Excel Intermediate II soon.
Wow, I have no word to say about this course. Its video content, Structure is awesome. The tutor is good. Week assignments and quizzes are always ready to make our practice and make concept permanent.
I learned a lot from this course. Before starting this course I even can't plot a simple graph for my reports but then this course helped me learning mind blowing skills. Thanks Macquarie University.
This was my second course with Macquarie University and I can say that they make courses so interesting that one can complete it without getting bored at all.
I learnt a lot of new things without any stress! Best kind of learning. The bite-sized videos and quizzes are a really quick way of cementing new knowledge, and I have a LOT more appreciation for MS Excel than I did. I guess I would personally have liked to be pushed a bit more technically but this was a good start. If you are tech/data savvy generally then it's very quick - I put in an hour a day and finished in 9 days.
Amazing course. I am amazed by the value provided by the instructors. The Pivot Tables in Week 6 is a must for everyone working with Excel. I am glad I chose this course over the other online courses.
I love this course a lot! Thank you very much for this course. It is easy to understand and follow. The practice challenges are so fun to do. Looking forward to the next course in this specialization.
Really great course with a lot of useful content. I had taken another Excel course on Coursera about a year ago, but it was nowhere close to being this detailed and informative. It is getting tougher and tougher undoubtedly but Prashant and Nicky do a great job at explaining the concepts and not to mention the challenges and the quizzes, they are awesome. The solutions are very helpful to say the least. I would recommend this course highly.
I learned a lot of useful stuff in this course. Even though I kind of knew a little bit of everything it covered, this course made me understand the "how" things work. It has definitely made me more confident in using things like pivot tables, ranges, tables, which I had previously been fumbling through with a trial and error approach. Now I actually know why what I have done before does and doesn't work, and why.
The course was exactly what I wanted. Very well-explained and clear. Also fun, and I learnt a lot of information which will be really useful.
This is a very good course! The best online course I've ever had. The structure, the order in which material is given, the difficulty of the course are very thought over. And the most important, I feel that the course is very effective. I really enjoyed all the quizzes and assignments of the course.
Why aren't all the MOOCs on Coursera as GOOD as this courser?!!
It was a self-motivated, professional and informative course with a lot of exercises and hands-on questions..
And I had such an amazing experience..
Thanks Parshan, Nikki and all the specialization team members.
Greetings to all of you
I am very happy to complete my course "Excel Skills for Business: Intermediate I". Thanks a lot for offering this online course. I have learnt much more from this course.
thanks again
Best Regards
Musharaf Khan from Pakistan KP
The length of the video lectures are just right and the numbers of exercises or quizzes are just right. Learned a lot of new things about Excel's functionality. A huge step from the Essentials course.
I really liked the progression of this course! for an excel newbie at the start of Essentials course I am now; by end of Intermediate I, able to make dashboards and even forecast trends ! WOW!
The pedagogy was amazing and the assessments made were really testing but ta the same time, very learning. Thank you for creating this course and your efforts.
one of the most amazing courses I've ever studied with great explanations and clarification of slightly complex topics
It was great experience
The delivery is highly professional. The course started off well with the first two modules being easy to follow. However, the quality seemed to decline thereafter due to several reasons: Lack of thorough explanations: While it is shown how to use a certain tool, the course often fails to provide the rationale behind that (why it is used). Unnecessary complexity: The assignments and assessments are occasionally overly complex, requiring additional research. Disconnect between lectures and assignments: The assignments and assessments often seemed unrelated (to some extent) to the lectures. Course structure: The course provides a “Toolbox” with terms and tips at the end of each week. However, it would have been more beneficial if this was introduced at the beginning of each week. This way the leaner may understand the new concepts better; that would also help to complete the assignments. The course does not have any prerequisites. However, I believe that someone new to Excel would struggle beyond Module 3. Even with my decent level of Excel skills, I found the course challenging, especially after Intermediate I. On top of that you would need some understanding of financial analysis when in Advanced module. Therefore, I would not recommend this course to those without some Excel skills or accounting background. There are plenty of online resources for understanding Excel, such as exceljet.net, trumpexcel.com, and Microsoft Support. Overall, the course left me feeling unsatisfied. I felt that I should have opted for a different course, but since I was already halfway through, I decided to finish it. If you do not need a certificate, I would suggest looking for alternatives. However, if you are already skilled and just seeking a recognition, this course might be suitable for you.