About this Course

5,145,791 recent views

Learner Career Outcomes

31%

started a new career after completing these courses

31%

got a tangible career benefit from this course

13%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

Approx. 26 hours to complete
English

Skills you will gain

GraphsSpreadsheetMicrosoft ExcelChart

Learner Career Outcomes

31%

started a new career after completing these courses

31%

got a tangible career benefit from this course

13%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

Approx. 26 hours to complete
English

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up98%(136,442 ratings)Info
Week
1

Week 1

6 hours to complete

Critical Core of Excel

6 hours to complete
10 videos (Total 46 min), 8 readings, 8 quizzes
10 videos
Week 1 Discussion3m
Practice Video: Taking Charge of Excel7m
Practice Video: Navigating and Selecting5m
Practice Video: View Options5m
Practice Video: Data Entry, Data Types, Editing and Deleting6m
Practice Video: Fill Handle5m
Week 1 Wrap-up1m
Copy and Paste5m
Templates2m
8 readings
Welcome to Excel Skills for Business: Essentials20m
Course goals and weekly learning objectives10m
Important information about versions and regions10m
Read me before you start: Quizzes and Navigation10m
Download the Week 1 workbooks5m
Week 1: Practice Challenge20m
Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips25m
Week 1: Excellent Tips and Resources25m
8 practice exercises
Are essential skills too basic for me?10m
Taking Charge of Excel10m
Navigating and Selecting10m
View Options10m
Data Entry10m
Fill handle30m
Taking Charge of Excel: Test your skills, Part 130m
Taking Charge of Excel: Test your skills, Part 230m
Week
2

Week 2

4 hours to complete

Performing calculations

4 hours to complete
11 videos (Total 44 min), 5 readings, 7 quizzes
11 videos
Week 2 Discussion4m
Practice Video: Formulas3m
Practice Video: Formulas in Context4m
Practice Video: Functions I: SUM and AUTOSUM4m
Practice Video: Functions II: AVERAGE, MIN and MAX4m
Discussion: Absolute Cell References4m
Practice Video: Absolute Cell References3m
Practice Video: Calculations across sheets4m
Week 2 Wrap-up1m
Excel Options6m
5 readings
Download the Week 2 workbooks5m
Week 2: Practice Challenges1h
Word Search Puzzle: Master ranges15m
Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips25m
Week 2: Excellent Tips and Resources20m
7 practice exercises
Formulas6m
Formulas in Context30m
Functions I6m
Functions II6m
Absolute Cell References6m
Calculations across Sheets6m
Performing Calculations: Test your skills30m
Week
3

Week 3

3 hours to complete

Formatting

3 hours to complete
10 videos (Total 40 min), 4 readings, 7 quizzes
10 videos
Week 3 Discussion3m
Practice Video: Formatting3m
Practice Video: Borders3m
Practice Video: Alignment Tools4m
Practice Video: Format Painter3m
Practice Video: Number Formats5m
Practice Video: Styles and Themes5m
Week 3 Wrap-up1m
Graphics6m
4 readings
Download the Week 3 workbooks5m
Week 3: Practice Challenge30m
Week 3: Keyboard Shortcuts and Ninja Tips10m
Week 3: Excellent Tips and Resources15m
7 practice exercises
Formatting8m
Borders8m
Alignment Tools8m
Format Painter12m
Number Formats8m
Styles and Themes5m
Formatting: Test your skills30m
Week
4

Week 4

3 hours to complete

Working with Data

3 hours to complete
9 videos (Total 35 min), 3 readings, 6 quizzes
9 videos
Week 4 Discussion3m
Practice Video: Managing Rows and Columns4m
Practice Video: Find and Replace3m
Practice Video: Filtering6m
Practice Video: Sorting3m
Practice Video: Conditional Formatting5m
Week 4 Wrap-up1m
Accessibility5m
3 readings
Download the Week 4 workbooks5m
Week 4: Practice Challenge30m
Week 4: Keyboard Shortcuts, Terminology, and Ninja Tips25m
6 practice exercises
Managing Rows and Columns10m
Find and Replace8m
Filtering30m
Sorting10m
Conditional Formatting15m
Working with Data: Test your skills30m

Reviews

TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: ESSENTIALS

View all reviews

About the Excel Skills for Business Specialization

Excel Skills for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.