Online Course – Certified Professional Internship in Google Excel Tools, University of Colorado Boulder

Learn Excel from the basics to full mastery. From basic knowledge to exciting projects in the “Projects” course, you will acquire useful skills in Excel tools.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת בכלי Excel של Google

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Knowledge of using Microsoft Excel from beginner to expert level
  • Understanding the basics of Excel through video tutorials
  • Ability to complete quizzes and tasks related to Excel
  • Experience in “real-world” projects
  • Deep understanding of dynamic array functions in Office 365
  • Ability to choose and complete different projects of varying difficulty levels
  • Skills in working with medium and major projects
  • Access to video tutorials with hints and previews for each project

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Project Manager
  • Accountant
  • Finance Manager
  • Business planner
  • Software developer
  • Marketing Manager
  • Sales Manager
  • Operations Manager
  • Business consultant
  • Human Resources Manager
  • Information Systems Manager
  • Technology Project Manager
  • Systems Analyst
  • Data Manager

Internship – 3-part course series

This specialization is intended for learners who are interested in learning Microsoft Excel from beginner to expert level.

Course content

  • The first two courses will teach the basics of Excel through the use of dozens of instructional videos and a series of quizzes and tasks.
  • In Part 3 (Projects), learners will complete a number of “real-world” projects.

Emphasis on dynamic array functions

In Part 3, special emphasis is given to dynamic array functions, which are new in Office 365.

Hands-on Learning Project

In Part 3, learners choose:

  • Three projects for “refreshment” (selected from five potential projects).
  • Three medium-sized projects (selected from six potential projects).
  • Three main projects (selected from five potential projects).

Tutorial videos are provided that show hints and previews for each project.

Details of the courses that make up the specialization

Daily Excel

Part 1

Course 1
23 hours
4.7 (3,402 ratings)

Course Details

  • What you will learn:
    • Navigating Excel, editing sheets (adding/deleting cells, columns, and rows), and formatting cells.
    • Entering formulas and common formulas (logical, text, and financial functions).
    • Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way searches).
    • Data visualization (scatter charts, column charts, pie charts, filters, sparklines, and pivot tables).
  • Skills you will develop:
    • Spreadsheet
    • Microsoft Excel
    • Troubleshooting
    • Data Management

Part 2

Course 2
22 hours
4.8 (542 ratings)

Course Details

  • What you will learn:
    • Advanced data management techniques.
    • Financial calculations in Excel.
    • Using advanced tools (data tables, goal search, and optimization) for “what if” analyses.
    • Creating mathematical prediction models using regression tools.
  • Skills you will develop:
    • Spreadsheet
    • Microsoft Excel
    • Troubleshooting
    • Data Management

Part 3 (Projects)

Course 3
14 hours
4.8 (266 ratings)

Course Details

  • What you will learn:
    • Applying Excel functions and tools to solve broad problems through a variety of “guided” projects.
  • Skills you will develop:
    • Spreadsheet
    • Microsoft Excel
    • Real-world projects
    • Calculation
    • Data Management

Related products