Save for later

Excel Skills for Business

Excel Skills for Business,

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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.8 based on 617 ratings
Length 7 weeks
Effort 6 weeks of study, 2-4 hours per week
Starts Jul 3 (46 weeks ago)
Cost $69
From Macquarie University via Coursera
Instructors Dr Yvonne Breyer, A/Professor Yvonne Breyer, Nicky Bull, Dr Prashan S. M. Karunaratne, Professor Yvonne Breyer
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Get a Reminder

Send to:

Similar Courses

What people are saying

pivot tables

Prior to finishing this course I had no knowledge about creating and using pivot tables, 3D formulas, pivot charts, a lot many things.

I didn't realize how useful Pivot Tables were until this course.

I have learned lots of good techniques creating pivot tables, slicer.

Very insightful, professionally presented, overall an enjoyable experi Extremely useful course that helps getting an understanding of Pivot Tables, advanced charting and so on.

I learned a lot about using slicing tools such as (LEFT, MID, CONCAT) and enjoyed diving into Pivot tables to solve various questions.

It has been challenging but in the wnd i learned skills i'm sure i will need in a working environment thanks this course I love pivot tables and charts!

I knew about pivot tables, but this helped to understand how easy and useful.

Especially the last week on Pivot Tables.

This course adds a lot to my ability to get the best of using Excel, especially in tables and pivot tables.It is a remarkable experience.

T Good Very wonderful and enriching course it is amazing and very useful thank you so much for your efforts It helps you to construct really powerful datasets with more advanced charts and pivot tables.

Please add more practice content around data consolidation and pivot tables.

This cleared up a lot about pivot tables for me, and although I have more questions, I will be able to work with pivot charts (new to me) and pivot tables with FAR more confidence.

Really great new tools...Charts indised Pivot Tables, 3d Formulas... Really Managing Tables...

Excellent course I have struggled for years to understand Pivot Tables and now I do Great work thanks guys This course worked like a knowledge pool for me.

Read more

easy to follow

Easy to follow step by step.

Easy to follow.

Thorough and easy to follow.

Easy to follow course with plenty of practical examples to put learnings into practice In depth coverage of topics with wonderful practice assignments.

Fantastic examples that are easy to follow along.

If you are looking forward to learn basics Great course , practice challenges are crafted very well to learn maximum This course is made easy to follow.

Good Absolutely great & easy to follow lessons!

quite useful and easy to follow!

Very very useful for intermediate student and for new learner Great course and very easy to follow.

The course was easy to follow.

I love how instructions are clear and easy to follow, each video helps develop knowledge and skills.

Very good and easy to follow It was learning experience and has enhanced my skills to new le Wow.

Very easy to follow, and challenging enough to spur growth.

Very easy to follow quizzes and very helpful and full of learning experience The course is of real help.

Read more

highly recommend

Highly recommended.

highly recommended course for excel Useful!

I highly recommend for everyone!

Really amazing course , helped me alot in learning basics and would highly recommend to anyone out there who is searching for a good course for excel.

nice Highly recommended!

Highly recommend it!

Easy to understand and it is a very powerful skill to learn, highly recommend.

Highly recommend it.

Very useful Very easy to understand and useful to apply in daily work, highly recommend it to everyone from different levels.

I highly recommend.

The instructors are awesome, the material is easy to understand, and the exercises help to learn all those wonderful Excel features.Highly recommend this course for everyone who is familiar with Excel basics.

Great Cours très bien mené du point de vue pédagogique Highly recommended to any one who is wishing to improve productivity in office Very well taught and explained.

I highly recommend this course.

Would highly recommend.

Read more

learnt a lot

Also, the course provides lots of exercises for you to practice the skills learned from the videos and readings awesome new capabilities from excel were acquired I really learnt a lot of useful techniques from this job and actually created a beautiful Pivot Report for my job interview.

But I learnt a lot and loved the course Really good course, learn a lot.

I've learnt a lot of new information Amei, super bom, excelente didática.

Also fun, and I learnt a lot of information which will be really useful.

I learnt a lot of things.. .

Learnt a lot of new excel features and applying them in my day to day work.

I learnt a lot I can use for analysis and forecasting.

I learnt a lot knowledge from this course about Excel Excelente manera de plantear casos, fácil de seguir I've taken all of their Excel Courses and I must say they have done an excellent job.

I have learnt a lot of new things here.

Read more

looking forward

I am already looking forward to completing more courses!

!, no problem to understand the content and logic.Regards, Neeraj Jain Simply awesome and looking forward to learn and dig further Great Course starting to feel a lot more confident and amazed with the capabilities of excel.

I am looking forward to the other classes :) Excellent course, I recommend it 100%.

Looking forward to the next course!

I am looking forward to learn next courses in Excel.

Looking forward to continuing with Excel for Business: Intermediate 2 Great course for review and to learn new skills!

Very satisfied and looking forward to learning more skills in the future with the remaining two courses.

Looking forward to more such courses.

Read more

macquarie university

Thank you Coursera and Macquarie University for allowing me to learn!

Learned New Things, Thanks Macquarie University, Thanks Coursera.

Thanks Macquarie University.

Thanks the great teachers from by Macquarie University.

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.

Thank you Coursera and Macquarie University.

Thanks to Macquarie University, Loved the course!

I think that I've met professional teachers at Macquarie University.

I am really happy that Macquarie University through this course shows us several different ways to achieve a given results.

Read more

intermediate ii

Looking forward to Intermediate II soon!

I will do the Intermediate II next and seeing the topics, most of them will be new for me.

I plan to take Intermediate II course as well!

Awesome and informative course that had me excited for each new week.Definitely recommended!Moving on to Intermediate II now and I just can't wait!

Honestly, cannot wait to see what the instructors have prepared for the Intermediate II.

Read more

named ranges

While I use Excel for quite some time I learned new material in this course (especially the consolidating function and named ranges).

Really liked the sections on named ranges and Pivot Tables.

I had never used Tables or even named ranges before and wasted untold hours selecting ranges and using slow sort/filter processes.

super ,very well presented and exp Thanks As part of the Specialization, this course builds upon the foundations of the previous course to introduce some of the most useful and indispensable concepts to gain advanced Excel skills: named ranges, tables and pivot tables and charts.

In my opinion this is the best course; named ranges, tables and pivot tables are my favorites, and their use and flexibility is wide.

Highly Recommended I found the following areas to be particularly useful to learn about:Combining and Changing TextExtracting and Finding Text Named RangesCOUNTIFS and SUMIFSTables and Pivot Tables Great Learning Experience from wonderful teachers !

Read more

look forward

Thank you for offering it, I look forward to course 3 great course!

The Course material and the presentation has been so very good that I am absolutely enjoying going through the Intermediate 1 and look forward for completion of the Specialization.Well done Prashan and team!

You have opened me up to an entirely new world in Excel and I eagerly look forward to the remaining courses in this specialization.

I look forward to the Intermediate-2 course.

Read more

feel confident

Very good course!the practical tests after every video class, helps you to fixed what you have watched.Also, the exercises and quizzes are well oriented, step by step,and makes you feel comfortable to do, even if you don't feel confident to solve it!I recommend it to every one that do not know excel and also to those that pretend to follow the specialization, because there are features presented in excel basics course that can be helpful in the intermediate l course...

Excellent course, I have learned lots of things and now I feel confident to face professional challenges concerning Excel.

Thanks to the course, I can broaden my Excel skills and feel confident to apply it efficiently at work.

I feel confident to utilise my new found updated Excel skills in my job.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Software / DICOM Connectivity Engineer Contractor $89k

Senior Software Engineer for CCStpa $97k

Sn. Software Engineer Consultant $111k

Senior Control Software Engineer $112k

Embedded Software Engineering $116k

Software Analyst Expert $118k

Senior Software Developer/Engineer $129k

Senior SYS/Software Engineer Analyst $130k

Software Engineer Search $137k

Senior Staff Software Development Supervisor $152k

Principal Software Development Architect $199k

Software Design Engineer in Test Contractor 2 $203k

Write a review

Your opinion matters. Tell us what you think.

Rating 4.8 based on 617 ratings
Length 7 weeks
Effort 6 weeks of study, 2-4 hours per week
Starts Jul 3 (46 weeks ago)
Cost $69
From Macquarie University via Coursera
Instructors Dr Yvonne Breyer, A/Professor Yvonne Breyer, Nicky Bull, Dr Prashan S. M. Karunaratne, Professor Yvonne Breyer
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now