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.
このコースについて
習得するスキル
- Concatenation
- Microsoft Excel
- Consolization
- Pivot Table
- Pivot Chart
提供:

マッコーリー大学(Macquarie University)
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.
レビュー
- 5 stars90.36%
- 4 stars8.82%
- 3 stars0.56%
- 2 stars0.11%
- 1 star0.13%
EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I からの人気レビュー
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.
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.
Truly enjoyed learning the concepts, especially pivot tables. I have developed a sound proficiency in using Excel by using just the keyboard. I would like to see more rigourous and tougher assignments
I found the following areas to be particularly useful to learn about: Combining and Changing Text\n\nExtracting and Finding Text\n\nNamed Ranges\n\nCOUNTIFS and SUMIFS\n\nTables and Pivot Tables
ビジネス向け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.

よくある質問
いつ講座や課題にアクセスできるようになりますか?
この専門講座をサブスクライブすると何を行うことができるようになりますか?
学資援助はありますか?
What version of Excel do you teach?
さらに質問がある場合は、受講者ヘルプセンターにアクセスしてください。