Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Excel Skills for Business: Essentials
  • Level Foundation
  • المدة 26 ساعات hours
  • الطبع بواسطة Macquarie University
  • Offered by

عن

In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. Within six weeks, you will be able 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. The best way to learn Excel is to use Excel. In this course, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This course uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts. 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.

الوحدات

Welcome and Critical Information

    • 3 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Are essential skills too basic for me?

1 Discussions

  • Set your goals and be successful

3 Readings

  • Welcome to Excel Skills for Business: Essentials
  • Course goals and weekly learning objectives
  • Important information about versions and regions

Scenario: Taking Charge of Excel

    • 2 Videos
Show info about module content

2 Videos

  • Week 1 Introduction
  • Week 1 Discussion

Practice Videos and Challenges

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

5 Assignment

  • Taking Charge of Excel
  • Navigating and Selecting
  • View Options
  • Data Entry
  • Fill handle

6 Videos

  • Practice Video: Taking Charge of Excel
  • Practice Video: Navigating and Selecting
  • Practice Video: View Options
  • Practice Video: Data Entry, Data Types, Editing and Deleting
  • Practice Video: Fill Handle
  • Week 1 Wrap-up

3 Readings

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

Toolbox

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Copy and Paste
  • Templates

1 Readings

  • Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 2 Assignment
Show info about module content

2 Assignment

  • Taking Charge of Excel: Test your skills, Part 1
  • Taking Charge of Excel: Test your skills, Part 2

Optional Materials

    • 1 Readings
Show info about module content

1 Readings

  • Week 1: Excellent Tips and Resources

Scenario: Performing Calculations

    • 2 Videos
Show info about module content

2 Videos

  • Week 2 Introduction
  • Week 2 Discussion

Practice Videos and Challenges

    • 8 Videos
    • 3 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • Formulas
  • Formulas in Context
  • Functions I
  • Functions II
  • Absolute Cell References
  • Calculations across Sheets

8 Videos

  • Practice Video: Formulas
  • Practice Video: Formulas in Context
  • Practice Video: Functions I: SUM and AUTOSUM
  • Practice Video: Functions II: AVERAGE, MIN and MAX
  • Discussion: Absolute Cell References
  • Practice Video: Absolute Cell References
  • Practice Video: Calculations across sheets
  • Week 2 Wrap-up

3 Readings

  • Download the Week 2 workbooks
  • Week 2: Practice Challenges
  • Word Search Puzzle: Master ranges

Toolbox

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Excel Options

1 Readings

  • Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Performing Calculations: Test your skills

Optional Materials

    • 1 Readings
Show info about module content

1 Readings

  • Week 2: Excellent Tips and Resources

Scenario: Formatting Spreadsheets

    • 2 Videos
Show info about module content

2 Videos

  • Week 3 Introduction
  • Week 3 Discussion

Practice Videos and Challenges

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

6 Assignment

  • Formatting
  • Borders
  • Alignment Tools
  • Format Painter
  • Number Formats
  • Styles and Themes

7 Videos

  • Practice Video: Formatting
  • Practice Video: Borders
  • Practice Video: Alignment Tools
  • Practice Video: Format Painter
  • Practice Video: Number Formats
  • Practice Video: Styles and Themes
  • Week 3 Wrap-up

2 Readings

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

Toolbox

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Graphics

1 Readings

  • Week 3: Keyboard Shortcuts and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Formatting: Test your skills

Optional Materials

    • 1 Readings
Show info about module content

1 Readings

  • Week 3: Excellent Tips and Resources

Scenario: Working with Data

    • 2 Videos
Show info about module content

2 Videos

  • Week 4 Introduction
  • Week 4 Discussion

Practice Videos and Challenges

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

5 Assignment

  • Managing Rows and Columns
  • Find and Replace
  • Filtering
  • Sorting
  • Conditional Formatting

6 Videos

  • Practice Video: Managing Rows and Columns
  • Practice Video: Find and Replace
  • Practice Video: Filtering
  • Practice Video: Sorting
  • Practice Video: Conditional Formatting
  • Week 4 Wrap-up

2 Readings

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

Toolbox

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Accessibility

1 Readings

  • Week 4: Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Working with Data: Test your skills

Scenario: Printing Spreadsheets

    • 2 Videos
Show info about module content

2 Videos

  • Week 5 Introduction
  • Week 5 Discussion

Practice Videos and Challenges

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

5 Assignment

  • Print Preview
  • Orientation, Margins and Scale
  • Page Breaks
  • Print Titles
  • Headers and Footers

6 Videos

  • Practice Video: Print Preview
  • Practice Video: Orientation, Margins and Scale
  • Practice Video: Page Breaks
  • Practice Video: Print Titles
  • Practice Video: Headers and Footers
  • Week 5 Wrap-up

3 Readings

  • Print to PDF - Setup Tips
  • Download the Week 5 workbooks
  • Week 5: Practice Challenge

Toolbox

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Save Options

1 Readings

  • Week 5: Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Printing: Test your skills

Optional Materials

    • 1 Readings
Show info about module content

1 Readings

  • Week 5: Excellent Tips and Resources

Scenario: Creating Charts and Graphs

    • 2 Videos
Show info about module content

2 Videos

  • Week 6 Introduction
  • Week 6 Discussion

Practice Videos and Challenges

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

4 Assignment

  • Basic Chart Types
  • Move and Resize Charts
  • Change Chart Style & Type
  • Modify Chart Elements

5 Videos

  • Practice Video: Basic Chart Types: Pie, Column and Line Charts
  • Practice Video: Move and Resize Charts
  • Practice Video: Change Chart Style & Type
  • Practice Video: Modify Chart Elements
  • Week 6 Wrap-up

2 Readings

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

Toolbox

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Sharing Charts

1 Readings

  • Week 6: Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Charts: Test your skills

Optional Materials

    • 1 Readings
Show info about module content

1 Readings

  • Week 6: Excellent Tips and Resources

Course 1: Final Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Course 1 Final Assessment

Auto Summary

Excel Skills for Business: Essentials, offered by Coursera, is a foundational course in the Data Science & AI domain. Over six weeks, you'll master navigating Excel, performing basic calculations, formatting spreadsheets, and creating data visualizations. Ideal for beginners or those looking to enhance efficiency, this course offers hands-on practice with downloadable workbooks and real-world business problems. Enhance your employability in the growing digital job market by adding valuable Excel skills to your portfolio. Subscription options include Starter, Professional, and Paid.

Nicky Bull
Instructors

Nicky Bull

Dr Prashan S. M. Karunaratne
Instructors

Dr Prashan S. M. Karunaratne

Professor Yvonne Breyer
Instructors

Professor Yvonne Breyer