About this Course

2,211,247 recent views

Learner Career Outcomes

36%

started a new career after completing these courses

30%

got a tangible career benefit from this course
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.
Intermediate Level
Approx. 30 hours to complete
English

Skills you will gain

ConcatenationMicrosoft ExcelConsolizationPivot TablePivot Chart

Learner Career Outcomes

36%

started a new career after completing these courses

30%

got a tangible career benefit from this course
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.
Intermediate Level
Approx. 30 hours to complete
English

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up96%(38,979 ratings)Info
Week
1

Week 1

6 hours to complete

Working with Multiple Worksheets & Workbooks

6 hours to complete
8 videos (Total 37 min), 8 readings, 6 quizzes
8 videos
Week 1 Discussion4m
Practice Video: Multiple Worksheets6m
Practice Video: 3D Formulas5m
Practice Video: Linking Workbooks6m
Practice Video: Consolidating by Position5m
Practice Video: Consolidating by Category (Reference)3m
Week 1 Wrap-Up1m
8 readings
Welcome to Excel Skills for Business: Intermediate I10m
Course Goals and Weekly Learning Objectives10m
Read me before you start: Quizzes and Navigation10m
Download the Week 1 workbooks5m
Read me before you start: Versions and regions10m
Week 1: Practice Challenge30m
Week 1: Advanced Practice Challenge30m
Keyboard Shortcuts, Excel Terminology and Ninja Tips30m
6 practice exercises
Multiple Worksheets30m
3D Formulas30m
Linking Workbooks30m
Consolidating by Position30m
Consolidating by Category (Reference)30m
Test your Skills: Working with Multiple Worksheets & Workbooks30m
Week
2

Week 2

5 hours to complete

Text and Date Functions

5 hours to complete
8 videos (Total 31 min), 3 readings, 6 quizzes
8 videos
Week 2 Discussion5m
Practice Video: Combining Text (CONCAT, &)4m
Practice Video: Changing Text Case (UPPER, LOWER, PROPER)4m
Practice Video: Extracting Text (LEFT, MID, RIGHT)3m
Practice Video: Finding Text (FIND)5m
Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)3m
Week 2 Wrap-Up1m
3 readings
Download the Week 2 workbooks5m
Week 2: Practice Challenge30m
Keyboard Shortcuts, Excel Terminology and Ninja Tips30m
6 practice exercises
Combining Text (CONCAT, &)30m
Changing Text Case (UPPER, LOWER, PROPER)30m
Extracting Text (LEFT, MID, RIGHT)30m
Finding Text (FIND)30m
Date Calculations (NOW, TODAY, YEARFRAC)30m
Test your Skills: Text and Date Functions30m
Week
3

Week 3

4 hours to complete

Named Ranges

4 hours to complete
8 videos (Total 31 min), 3 readings, 6 quizzes
8 videos
Week 3 Discussion2m
Practice Video: Introducing Named Ranges5m
Practice Video: Creating Named Ranges5m
Practice Video: Managing Named Ranges4m
Practice Video: Named Ranges in Formulas5m
Practice Video: Apply Names5m
Week 3 Wrap-Up1m
3 readings
Download the Week 3 workbooks5m
Week 3: Practice Challenge20m
Keyboard Shortcuts, Terminology and Ninja Tips10m
6 practice exercises
Introducing Named Ranges30m
Creating Named Ranges30m
Managing Named Ranges30m
Named Ranges in Formulas30m
Apply Names30m
Test your Skills: Named Ranges30m
Week
4

Week 4

5 hours to complete

Summarising Data

5 hours to complete
9 videos (Total 37 min), 3 readings, 7 quizzes
9 videos
Week 4 Discussion3m
Practice Video: COUNT functions4m
Practice Video: Counting with Criteria (COUNTIFS)5m
Practice Video: Adding with Criteria (SUMIFS)6m
Practice Video: Sparklines4m
Practice Video: Advanced Charting5m
Practice Video: Trendlines4m
Week 4 Wrap-Up1m
3 readings
Download the Week 4 workbooks5m
Week 4: Practice Challenge20m
Keyboard Shortcuts, Excel Terminology and Ninja Tips30m
7 practice exercises
COUNT functions30m
Counting with Criteria (COUNTIFS)30m
Adding with Criteria (SUMIFS)30m
Sparklines30m
Advanced Charting30m
Trendlines30m
Test your Skills: Summarising Data30m

Reviews

TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I

View all reviews

About the Excel Skills for Business Specialization

Excel Skills for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.