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.
提供方
课程信息
学生职业成果
25%
24%
您将获得的技能
学生职业成果
25%
24%
提供方

麦考瑞大学
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
教学大纲 - 您将从这门课程中学到什么
Working with Multiple Worksheets & Workbooks
This module is all about working with multiple worksheets and workbooks. Learn how you can combine data, manage datasets and perform calculations across multiple sources. And don't forget the Toolbox with handy shortcuts and ninja tips.
Text and Date Functions
By the end of this module, you will be an expert in Date and Text functions. This module discusses ways you can extract information and manipulate data to fulfil specific business requirements.
Named Ranges
Learn how you can create, manage and apply Named Ranges to enhance your calculations.
Summarising Data
Graduate to advanced formulas in this module. Learn how you can use functions like COUNTIFS to extract information from data, as well as generate graphical representations of it.
审阅
来自EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I的热门评论
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.
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.
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.
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.
关于 Excel 办公技能 专项课程
This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. 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 digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.

常见问题
我什么时候能够访问课程视频和作业?
我订阅此专项课程后会得到什么?
Is financial aid available?
What version of Excel do you teach?
完成课程后,我会获得大学学分吗?
还有其他问题吗?请访问 学生帮助中心。