Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Excel Skills for Business: Intermediate I
  • Level Professional
  • Duration 28 hours
  • Course by Macquarie University
  • Offered by

About

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. In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel. Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.

Modules

Welcome and Critical Information

    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Excel: Who, Why, How

2 Readings

  • Welcome to Excel Skills for Business: Intermediate I
  • Course Goals and Weekly Learning Objectives

Scenario: Multiple Worksheets and Workbooks

    • 2 Videos
Show info about module content

2 Videos

  • Week 1 Introduction
  • Week 1 Discussion

Practice Videos and Challenges

    • 6 Videos
    • 5 Readings
    • 5 Assignment
Show info about module content

5 Assignment

  • Multiple Worksheets
  • 3D Formulas
  • Linking Workbooks
  • Consolidating by Position
  • Consolidating by Category (Reference)

6 Videos

  • Practice Video: Multiple Worksheets
  • Practice Video: 3D Formulas
  • Practice Video: Linking Workbooks
  • Practice Video: Consolidating by Position
  • Practice Video: Consolidating by Category (Reference)
  • Week 1 Wrap-Up

5 Readings

  • Read me before you start: Quizzes and Navigation
  • Download the Week 1 workbooks
  • Read me before you start: Versions and regions
  • Week 1: Practice Challenge
  • Week 1: Advanced Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Working with Multiple Worksheets & Workbooks

Scenario

    • 2 Videos
    • 1 Discussion
Show info about module content

1 Discussions

  • Excel - how, when, where, why

2 Videos

  • Week 2 Introduction
  • Week 2 Discussion

Practice Videos and Challenges

    • 6 Videos
    • 2 Readings
    • 5 Assignment
Show info about module content

5 Assignment

  • Combining Text (CONCAT, &)
  • Changing Text Case (UPPER, LOWER, PROPER)
  • Extracting Text (LEFT, MID, RIGHT)
  • Finding Text (FIND)
  • Date Calculations (NOW, TODAY, YEARFRAC)

6 Videos

  • Practice Video: Combining Text (CONCAT, &)
  • Practice Video: Changing Text Case (UPPER, LOWER, PROPER)
  • Practice Video: Extracting Text (LEFT, MID, RIGHT)
  • Practice Video: Finding Text (FIND)
  • Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)
  • Week 2 Wrap-Up

2 Readings

  • Download the Week 2 workbooks
  • Week 2: Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Text and Date Functions

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 3 Introduction
  • Week 3 Discussion

Practice Videos and Challenges

    • 6 Videos
    • 2 Readings
    • 5 Assignment
Show info about module content

5 Assignment

  • Introducing Named Ranges
  • Creating Named Ranges
  • Managing Named Ranges
  • Named Ranges in Formulas
  • Apply Names

6 Videos

  • Practice Video: Introducing Named Ranges
  • Practice Video: Creating Named Ranges
  • Practice Video: Managing Named Ranges
  • Practice Video: Named Ranges in Formulas
  • Practice Video: Apply Names
  • Week 3 Wrap-Up

2 Readings

  • Download the Week 3 workbooks
  • Week 3: Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Named Ranges

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 4 Introduction
  • Week 4 Discussion

Practice Videos and Challenges

    • 7 Videos
    • 2 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • COUNT functions
  • Counting with Criteria (COUNTIFS)
  • Adding with Criteria (SUMIFS)
  • Sparklines
  • Advanced Charting
  • Trendlines

7 Videos

  • Practice Video: COUNT functions
  • Practice Video: Counting with Criteria (COUNTIFS)
  • Practice Video: Adding with Criteria (SUMIFS)
  • Practice Video: Sparklines
  • Practice Video: Advanced Charting
  • Practice Video: Trendlines
  • Week 4 Wrap-Up

2 Readings

  • Download the Week 4 workbooks
  • Week 4: Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Summarising Data

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 5 Introduction
  • Week 5 Discussion

Practice Videos and Challenges

    • 6 Videos
    • 2 Readings
    • 5 Assignment
Show info about module content

5 Assignment

  • Creating and Formatting Tables
  • Working with Tables
  • Sorting and Filtering in Tables
  • Automation with Tables
  • Converting to Range and Subtotaling

6 Videos

  • Practice Video: Creating and Formatting Tables
  • Practice Video: Working with Tables
  • Practice Video: Sorting and Filtering in Tables
  • Practice Video: Automation with Tables
  • Practice Video: Converting to Range and Subtotaling
  • Week 5 Wrap-Up

2 Readings

  • Download the Week 5 workbooks
  • Week 5: Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Tables

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 6 Introduction
  • Week 6 Discussion

Practice Videos and Challenges

    • 7 Videos
    • 2 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • Creating and Modifying a Pivot Table
  • Value Field Settings
  • Sorting and Filtering a Pivot Table
  • Report Filter Pages
  • Pivoting Charts
  • Pivoting Slicers

7 Videos

  • Practice Video: Creating and Modifying a Pivot Table
  • Practice Video: Value Field Settings
  • Practice Video: Sorting and Filtering a Pivot Table
  • Practice Video: Reporting Filter Pages
  • Practice Video: Pivoting Charts
  • Practice Video: Pivoting Slicers
  • Week 6 Wrap-Up

2 Readings

  • Download the Week 6 workbooks
  • Week 6: Practice Challenge

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Skills: Pivot Tables, Charts and Slicers

Final Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Assessment

Auto Summary

Embark on an advanced journey with "Excel Skills for Business: Intermediate I," a specialized course in the Data Science & AI domain, designed to elevate your Excel expertise. This course builds upon foundational knowledge, focusing on advanced techniques and skills that will enhance your ability to manage large datasets and create sophisticated reports. Guided by expert instructors Prashan and Nicky, and featuring special guest insights, this course spans across five engaging weeks. You will explore a variety of tools and techniques to add automation and efficiency to your everyday Excel tasks, making you more proficient and employable in today’s job market where digital skills are in high demand. Throughout the course, you will follow the practical scenarios of Uma at the fictitious company PushPin, making the learning experience relatable and applicable to real-world situations. This hands-on approach ensures that you can seamlessly integrate new skills into your professional toolkit. Ideal for professionals looking to advance their Excel capabilities, this course offers a comprehensive learning experience over 1680 minutes, available through Coursera’s Starter subscription. Join now to transform your Excel proficiency and open doors to better employment opportunities and higher income potential.

Nicky Bull
Instructors

Nicky Bull

Dr Prashan S. M. Karunaratne
Instructors

Dr Prashan S. M. Karunaratne

Professor Yvonne Breyer
Instructors

Professor Yvonne Breyer