Excel Skills for Business: Essentials

Current Status
Not Enrolled
Price
Closed
Get Started
This course is currently closed

About this Course

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.

Week 1

Critical Core of Excel

In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.

10 videos, 8 readings, 6 practice quizzes

  1. Reading: Welcome to Excel Skills for Business: Essentials
  2. Reading: Course goals and weekly learning objectives
  3. Reading: Important information about versions and regions
  4. Practice Quiz: Are essential skills too basic for me?
  5. Discussion Prompt: Set your goals and be successful
  6. Video: Week 1 Introduction 
  7. Video: Week 1 Discussion
  8. Reading: Read me before you start: Quizzes and Navigation
  9. Reading: Download the Week 1 workbooks
  10. Video: Practice Video: Taking Charge of Excel
  11. Practice Quiz: Taking Charge of Excel
  12. Video: Practice Video: Navigating and Selecting
  13. Practice Quiz: Navigating and Selecting
  14. Video: Practice Video: View Options
  15. Practice Quiz: View Options
  16. Video: Practice Video: Data Entry, Data Types, Editing and Deleting
  17. Practice Quiz: Data Entry
  18. Video: Practice Video: Fill Handle
  19. Practice Quiz: Fill handle
  20. Video: Week 1 Wrap-up
  21. Reading: Week 1: Practice Challenge
  22. Reading: Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips
  23. Video: Copy and Paste
  24. Video: Templates
  25. Reading: Week 1: Excellent Tips and Resources

Graded: Taking Charge of Excel: Test your skills, Part 1

Graded: Taking Charge of Excel: Test your skills, Part 2

Week 2

Performing calculations

The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions – learn how to write them, use them to perform calculations and understand the different cell references.

11 videos, 5 readings, 6 practice quizzes

  1. Video: Week 2 Introduction
  2. Video: Week 2 Discussion
  3. Reading: Download the Week 2 workbooks
  4. Video: Practice Video: Formulas
  5. Practice Quiz: Formulas
  6. Video: Practice Video: Formulas in Context
  7. Practice Quiz: Formulas in Context
  8. Video: Practice Video: Functions I: SUM and AUTOSUM
  9. Practice Quiz: Functions I
  10. Video: Practice Video: Functions II: AVERAGE, MIN and MAX
  11. Practice Quiz: Functions II
  12. Video: Discussion: Absolute Cell References
  13. Video: Practice Video: Absolute Cell References
  14. Practice Quiz: Absolute Cell References
  15. Video: Practice Video: Calculations across sheets
  16. Practice Quiz: Calculations across Sheets
  17. Video: Week 2 Wrap-up
  18. Reading: Week 2: Practice Challenges
  19. Reading: Word Search Puzzle: Master ranges
  20. Reading: Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips
  21. Video: Excel Options
  22. Reading: Week 2: Excellent Tips and Resources

Graded: Performing Calculations: Test your skills

Week 3

Formatting

Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.

10 videos, 4 readings, 6 practice quizzes

  1. Video: Week 3 Introduction
  2. Video: Week 3 Discussion
  3. Reading: Download the Week 3 workbooks
  4. Video: Practice Video: Formatting
  5. Practice Quiz: Formatting
  6. Video: Practice Video: Borders
  7. Practice Quiz: Borders
  8. Video: Practice Video: Alignment Tools
  9. Practice Quiz: Alignment Tools
  10. Video: Practice Video: Format Painter
  11. Practice Quiz: Format Painter
  12. Video: Practice Video: Number Formats
  13. Practice Quiz: Number Formats
  14. Video: Practice Video: Styles and Themes
  15. Practice Quiz: Styles and Themes
  16. Video: Week 3 Wrap-up
  17. Reading: Week 3: Practice Challenge
  18. Reading: Week 3: Keyboard Shortcuts and Ninja Tips
  19. Video: Graphics
  20. Reading: Week 3: Excellent Tips and Resources

Graded: Formatting: Test your skills

Week 4

Working with Data

This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.

9 videos, 3 readings, 5 practice quizzes

  1. Video: Week 4 Introduction
  2. Video: Week 4 Discussion
  3. Reading: Download the Week 4 workbooks
  4. Video: Practice Video: Managing Rows and Columns
  5. Practice Quiz: Managing Rows and Columns
  6. Video: Practice Video: Find and Replace
  7. Practice Quiz: Find and Replace
  8. Video: Practice Video: Filtering
  9. Practice Quiz: Filtering
  10. Video: Practice Video: Sorting
  11. Practice Quiz: Sorting
  12. Video: Practice Video: Conditional Formatting
  13. Practice Quiz: Conditional Formatting
  14. Video: Week 4 Wrap-up
  15. Reading: Week 4: Practice Challenge
  16. Reading: Week 4: Keyboard Shortcuts, Terminology, and Ninja Tips
  17. Video: Accessibility

Graded: Working with Data: Test your skills

Week 5

Printing

Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.

9 videos, 5 readings, 5 practice quizzes

  1. Video: Week 5 Introduction
  2. Video: Week 5 Discussion
  3. Reading: Print to PDF – Setup Tips
  4. Reading: Download the Week 5 workbooks
  5. Video: Practice Video: Print Preview
  6. Practice Quiz: Print Preview
  7. Video: Practice Video: Orientation, Margins and Scale
  8. Practice Quiz: Orientation, Margins and Scale
  9. Video: Practice Video: Page Breaks
  10. Practice Quiz: Page Breaks
  11. Video: Practice Video: Print Titles
  12. Practice Quiz: Print Titles
  13. Video: Practice Video: Headers and Footers
  14. Practice Quiz: Headers and Footers
  15. Video: Week 5 Wrap-up
  16. Reading: Week 5: Practice Challenge
  17. Reading: Week 5: Keyboard Shortcuts, Terminology, and Ninja Tips
  18. Video: Save Options
  19. Reading: Week 5: Excellent Tips and Resources

Graded: Printing: Test your skills

Week 6

Charts

Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.

8 videos, 4 readings, 4 practice quizzes

  1. Video: Week 6 Introduction
  2. Video: Week 6 Discussion
  3. Reading: Download the Week 6 workbooks
  4. Video: Practice Video: Basic Chart Types: Pie, Column and Line Charts
  5. Practice Quiz: Basic Chart Types
  6. Video: Practice Video: Move and Resize Charts
  7. Practice Quiz: Move and Resize Charts
  8. Video: Practice Video: Change Chart Style & Type
  9. Practice Quiz: Change Chart Style & Type
  10. Video: Practice Video: Modify Chart Elements
  11. Practice Quiz: Modify Chart Elements
  12. Video: Week 6 Wrap-up
  13. Reading: Week 6: Practice Challenge
  14. Reading: Week 6: Keyboard Shortcuts, Terminology, and Ninja Tips
  15. Video: Sharing Charts
  16. Reading: Week 6: Excellent Tips and Resources

Graded: Charts: Test your skills

Course Content

Expand All
Week 1
Week 2 - Performance Calculation
Week 3 - Formatting
Week 4 - Working with Data
Week 5 - Printing
Week 6 - Charts
Final Assessment

Leave a Reply

Your email address will not be published. Required fields are marked *