- Data Validation
- Microsoft Excel
- Microsoft Excel Macro
- Pivot Table
- Graphs
- Spreadsheet
- Chart
- Concatenation
- Consolization
- Pivot Chart
- Lookup Table
- Microsoft Excel Vba
Excel 办公技能 專項課程
Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
提供方
您將學到的內容有
Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.
Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.
您將獲得的技能
關於此 專項課程
應用的學習項目
The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This specialization uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts.
This Specialization is appropriate for anyone who is interested in learning about Microsoft Excel.
This Specialization is appropriate for anyone who is interested in learning about Microsoft Excel.
專項課程的運作方式
加入課程
Coursera 專項課程是幫助您掌握一門技能的一系列課程。若要開始學習,請直接註冊專項課程,或預覽專項課程並選擇您要首先開始學習的課程。當您訂閱專項課程的部分課程時,您將自動訂閱整個專項課程。您可以只完成一門課程,您可以隨時暫停學習或結束訂閱。訪問您的學生面板,跟踪您的課程註冊情況和進度。
實踐項目
每個專項課程都包括實踐項目。您需要成功完成這個(些)項目才能完成專項課程並獲得證書。如果專項課程中包括單獨的實踐項目課程,則需要在開始之前完成其他所有課程。
獲得證書
在結束每門課程並完成實踐項目之後,您會獲得一個證書,您可以向您的潛在雇主展示該證書並在您的職業社交網絡中分享。

此專項課程包含 4 門課程
Excel Skills for Business: Essentials
In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Excel Skills for Business: Intermediate I
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.
Excel Skills for Business: Intermediate II
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 this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to
Excel Skills for Business: Advanced
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.
提供方

麦考瑞大学
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.
常見問題
退款政策是如何规定的?
我可以只注册一门课程吗?
有助学金吗?
我可以免费学习课程吗?
此课程是 100% 在线学习吗?是否需要现场参加课程?
完成专项课程需要多长时间?
What background knowledge is necessary?
Do I need to take the courses in a specific order?
完成专项课程后我会获得大学学分吗?
What will I be able to do upon completing the Specialization?
還有其他問題嗎?請訪問 學生幫助中心。