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.
提供方
課程信息
學生職業成果
20%
21%
您將獲得的技能
學生職業成果
20%
21%
提供方

麦考瑞大学
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.
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.
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.
關於 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?
完成课程后,我会获得大学学分吗?
還有其他問題嗎?請訪問 學生幫助中心。