关于此课程： In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn 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. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come. Spreadsheet software is 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. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
此课程适用人群： Completing the course Excel Skills for Business: Essentials will be a highly valuable asset for anyone wanting to improve their employment portfolio. This course is for newcomers to Excel, for self-taught learners who want to fill gaps in their knowledge and for anyone wanting to consolidate their foundational knowledge of Excel in order to progress to a more advanced level of Excel.
制作方： 麦考瑞大学
教学方： Dr Yvonne Breyer, Director, Learning and Teaching
Faculty of Business and Economics
| 基本信息 | 课程 1（共 4 门，Excel Skills for Business Specialization ） |
| 级别 | Beginner |
| 承诺学习时间 | 6 weeks of study, 2-4 hours per week |
| 语言 | English |
| 如何通过 | 通过所有计分作业以完成课程。 |
| 用户评分 |
授课大纲
第 1 周
Critical Core of Excel
In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
10 视频, 8 阅读材料, 6 练习测试
- Reading: Welcome to Excel Skills for Business: Essentials
- Reading: Course goals and weekly learning objectives
- Reading: Important information about versions and regions
- Practice Quiz: Are essential skills too basic for me?
- Discussion Prompt: Set your goals and be successful
- 视频: Week 1 Introduction
- 视频: Week 1 Discussion
- Reading: Read me before you start: Quizzes and Navigation
- Reading: Download the Week 1 workbooks
- 视频: Practice Video: Taking Charge of Excel
- Practice Quiz: Taking Charge of Excel
- 视频: Practice Video: Navigating and Selecting
- Practice Quiz: Navigating and Selecting
- 视频: Practice Video: View Options
- Practice Quiz: View Options
- 视频: Practice Video: Data Entry, Data Types, Editing and Deleting
- Practice Quiz: Data Entry
- 视频: Practice Video: Fill Handle
- Practice Quiz: Fill handle
- 视频: Week 1 Wrap-up
- Reading: Week 1: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- 视频: Copy and Paste
- 视频: Templates
- Reading: Excellent Tips and Resources
已评分: Taking Charge of Excel: Test your skills, Part 1
已评分: Taking Charge of Excel: Test your skills, Part 2
第 2 周
Performing calculations
The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions - learn how to write them, use them to perform calculations and understand the different cell references.
11 视频, 5 阅读材料, 6 练习测试
- 视频: Week 2 Introduction
- 视频: Week 2 Discussion
- Reading: Download the Week 2 workbooks
- 视频: Practice Video: Formulas
- Practice Quiz: Formulas
- 视频: Practice Video: Formulas in Context
- Practice Quiz: Formulas in Context
- 视频: Practice Video: Functions I: SUM and AUTOSUM
- Practice Quiz: Functions I
- 视频: Practice Video: Functions II: AVERAGE, MIN and MAX
- Practice Quiz: Functions II
- 视频: Discussion: Absolute Cell References
- 视频: Practice Video: Absolute Cell References
- Practice Quiz: Absolute Cell References
- 视频: Practice Video: Calculations across sheets
- Practice Quiz: Calculations across Sheets
- 视频: Week 2 Wrap-up
- Reading: Week 2: Practice Challenges
- Reading: Word Search Puzzle: Master ranges
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- 视频: Excel Options
- Reading: Excellent Tips and Resources
已评分: Performing Calculations: Test your skills
第 3 周
Formatting
Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.
10 视频, 4 阅读材料, 6 练习测试
- 视频: Week 3 Introduction
- 视频: Week 3 Discussion
- Reading: Download the Week 3 workbooks
- 视频: Practice Video: Formatting
- Practice Quiz: Formatting
- 视频: Practice Video: Borders
- Practice Quiz: Borders
- 视频: Practice Video: Alignment Tools
- Practice Quiz: Alignment Tools
- 视频: Practice Video: Format Painter
- Practice Quiz: Format Painter
- 视频: Practice Video: Number Formats
- Practice Quiz: Number Formats
- 视频: Practice Video: Styles and Themes
- Practice Quiz: Styles and Themes
- 视频: Week 3 Wrap-up
- Reading: Week 3: Practice Challenge
- Reading: Keyboard Shortcuts and Ninja Tips
- 视频: Graphics
- Reading: Excellent Tips and Resources
已评分: Formatting: Test your skills
第 4 周
Working with Data
This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
9 视频, 3 阅读材料, 5 练习测试
- 视频: Week 4 Introduction
- 视频: Week 4 Discussion
- Reading: Download the Week 4 workbooks
- 视频: Practice Video: Managing Rows and Columns
- Practice Quiz: Managing Rows and Columns
- 视频: Practice Video: Find and Replace
- Practice Quiz: Find and Replace
- 视频: Practice Video: Filtering
- Practice Quiz: Filtering
- 视频: Practice Video: Sorting
- Practice Quiz: Sorting
- 视频: Practice Video: Conditional Formatting
- Practice Quiz: Conditional Formatting
- 视频: Week 4 Wrap-up
- Reading: Week 4: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- 视频: Accessibility
已评分: Working with Data: Test your skills
第 5 周
Printing
Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.
9 视频, 5 阅读材料, 5 练习测试
- 视频: Week 5 Introduction
- 视频: Week 5 Discussion
- Reading: Print to PDF - Setup Tips
- Reading: Download the Week 5 workbooks
- 视频: Practice Video: Print Preview
- Practice Quiz: Print Preview
- 视频: Practice Video: Orientation, Margins and Scale
- Practice Quiz: Orientation, Margins and Scale
- 视频: Practice Video: Page Breaks
- Practice Quiz: Page Breaks
- 视频: Practice Video: Print Titles
- Practice Quiz: Print Titles
- 视频: Practice Video: Headers and Footers
- Practice Quiz: Headers and Footers
- 视频: Week 5 Wrap-up
- Reading: Week 5: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- 视频: Save Options
- Reading: Excellent Tips and Resources
已评分: Printing: Test your skills
第 6 周
Charts
Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.
8 视频, 4 阅读材料, 4 练习测试
- 视频: Week 6 Introduction
- 视频: Week 6 Discussion
- Reading: Download the Week 6 workbooks
- 视频: Practice Video: Basic Chart Types: Pie, Column and Line Charts
- Practice Quiz: Basic Chart Types
- 视频: Practice Video: Move and Resize Charts
- Practice Quiz: Move and Resize Charts
- 视频: Practice Video: Change Chart Style & Type
- Practice Quiz: Change Chart Style & Type
- 视频: Practice Video: Modify Chart Elements
- Practice Quiz: Modify Chart Elements
- 视频: Week 6 Wrap-up
- Reading: Week 6: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- 视频: Sharing Charts
- Reading: Excellent Tips and Resources
已评分: Charts: Test your skills
Final Assessment
已评分: Course 1 Final Assessment
常见问题解答
运作方式
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
制作方
麦考瑞大学
Macquarie is a hub of inspired and unconstrained thinking. Macquarie was founded with a unique purpose: to bring minds together unhindered by tradition. Created to challenge the education establishment, Macquarie has a rich track record of innovation. Macquarie actively shapes the complex issues that define the future of humanity.
价格
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
评分和审阅
Good
This is perfect course for beginners
Great course and very in-depth!
excellent, easy to follow with achievable exercises, tests and exam. A definite requirement to gain all basics of the tool and make one competent at daily excel tasks.