About this Course

1,326,944 recent views

Learner Career Outcomes

19%

started a new career after completing these courses

23%

got a tangible career benefit from this course

12%

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.
Intermediate Level
Approx. 29 hours to complete
English
Subtitles: English, Vietnamese, Arabic

Skills you will gain

Lookup TableMicrosoft Excel VbaData ValidationMicrosoft Excel Macro

Learner Career Outcomes

19%

started a new career after completing these courses

23%

got a tangible career benefit from this course

12%

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.
Intermediate Level
Approx. 29 hours to complete
English
Subtitles: English, Vietnamese, Arabic

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up96%(17,941 ratings)Info
Week
1

Week 1

5 hours to complete

Data Validation

5 hours to complete
8 videos (Total 42 min), 6 readings, 7 quizzes
8 videos
Week 1 Discussion4m
Practice Video: Data Validation6m
Practice Video: Creating Drop-down Lists6m
Practice Video: Using Formulas in Data Validation7m
Practice Video: Working with Data Validation7m
Practice Video: Advanced Conditional Formatting5m
Week 1 Wrap-Up2m
6 readings
Welcome10m
Course goals and weekly learning objectives10m
Read me before you start: Quizzes and navigation10m
Read me before you start: Versions and regions10m
Download the Week 1 workbooks5m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Data Validation30m
Creating Drop-down Lists30m
Using Formulas in Data Validation30m
Working with Data Validation30m
Advanced Conditional Formatting30m
Week 1 Practice Challenge30m
Week 1 Final Assignment30m
Week
2

Week 2

5 hours to complete

Conditional Logic

5 hours to complete
8 videos (Total 39 min), 2 readings, 7 quizzes
8 videos
Week 2 Discussion4m
Practice Video: Logical Functions I: IF7m
Practice Video: Logical Functions II: AND, OR5m
Practice Video: Combining Logical Functions I: IF, AND, OR5m
Practice Video: Combining Logical Functions II: Nested IFs5m
Practice Video: Handling Errors: IFERROR, IFNA6m
Week 2 Wrap-Up1m
2 readings
Download the Week 2 workbooks5m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Logical Functions I: IF30m
Logical Functions II: AND, OR30m
Combining Logical Functions I: IF, AND, OR30m
Combining Logical Functions II: Nested IFs30m
Handling Errors: IFERROR, IFNA30m
Week 2 Practice Challenge30m
Week 2 Final Assignment30m
Week
3

Week 3

5 hours to complete

Automating Lookups

5 hours to complete
8 videos (Total 39 min), 2 readings, 7 quizzes
8 videos
Week 3 Discussion4m
Practice Video: Introduction to Lookups: CHOOSE3m
Practice Video: Approximate Matches: Range VLOOKUP5m
Practice Video: Exact Matches: Exact Match VLOOKUP6m
Practice Video: Finding a Position: MATCH7m
Practice Video: Dynamic Lookups: INDEX, MATCH7m
Week 3 Wrap-Up1m
2 readings
Download the Week 3 workbooks5m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Introduction to Lookups: CHOOSE30m
Approximate Matches: Range VLOOKUP30m
Exact Matches: Exact Match VLOOKUP30m
Finding a Position: MATCH30m
Dynamic Lookups: INDEX, MATCH30m
Week 3 Practice Challenge30m
Week 3 Final Assignment30m
Week
4

Week 4

5 hours to complete

Formula Auditing and Protection

5 hours to complete
8 videos (Total 48 min), 2 readings, 7 quizzes
8 videos
Week 4 Discussion3m
Practice Video: Error Checking9m
Practice Video: Formula Calculation Options6m
Practice Video: Trace Precedents and Dependents5m
Practice Video: Evaluate Formula, Watch Window8m
Practice Video: Protecting Workbooks and Worksheets9m
Week 4 Wrap-Up1m
2 readings
Download the Week 4 workbooks5m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Error Checking30m
Formula Calculation Options30m
Tracing Precedents and Dependents30m
Evaluate Formula, Watch Window30m
Protecting Workbooks and Worksheets30m
Week 4 Practice Challenge30m
Week 4 Final Assignment30m

Reviews

TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: INTERMEDIATE II

View all reviews

About the Excel Skills for Business Specialization

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. In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data....
Excel Skills for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.