EdX

Excel for Beginners (edX)

Excel for Beginners (edX)

No knowledge of Excel? No problem! Mastering a few basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. If you’re hoping to move from knowing almost nothing about spreadsheets to basic comfort and competence in Excel, then this is a perfect course for you. The goal of this course is to give you a foundation on which you can build more advanced skills in the future.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

In this course you will learn foundational Excel knowledge like spreadsheet and workbook anatomy, data entry, summary, and manipulation, plotting and visualization, and powerful tools such as filters, sorts, and pivot tables. Not only will you gain strong skills in Excel basics, you will also find several pathways to continue learning the skills you need after the course. Basic Excel skills are required for many jobs, but more advanced skills are often learned on the job. This course can help you quickly get to the point of being able to learn more advanced skills on your own or on the job.
The approach of this course will be different from a typical software course. Rather than focusing on moving through as many tools and skills as quickly as possible, this course will emphasize gaining comfort and familiarity with some of the most useful and foundational skills, the skills that will be key to your success in using Excel now and in the future. You will have the opportunity to practice these skills and identify general principles of successfully working with spreadsheets to be more efficient, reliable, and effective in your work.
This course is part of the Data Analysis Basics with Excel and R Professional Certificate.

What you'll learn

  • Confidence with spreadsheet layout, anatomy, and terminology
  • Good practices for data entry, storage, and manipulation in spreadsheets
  • Common methods of data manipulation and summary such as sorting, filtering, writing simple equations, and using pivot tables
  • Common methods of data visualization using charts

Syllabus

Week 1: Getting to Know Excel & Entering Data
Excel Orientation and Spreadsheet Basics
Excel Data Types
Entering Data
Spreadsheet Setup

Week 2: Making Charts
Bar Charts, Simple and Clustered
Scatterplots
Pie and Stacked Column Charts
Combining Plot Types

Week 3: Manipulating & Summarizing Data Using Functions
Formulas and Functions in Excel
Absolute vs. Relative Cell References
Sorting & Filtering Data in Excel
Conditional functions

Week 4: Bringing it All Together
Converting Data Ranges to Tables
Unleashing the Power of Pivot Tables: Simple Tables and Charts
Unleashing the Power of Pivot Tables: Answering Complex Questions
Introducing the Course Project

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Personal Finance, Part 1: Investing in Yourself (edX) EdX
Wellesley College

Personal Finance, Part 1: Investing in Yourself (edX)

Learn how to incorporate financial considerations into your life decisions and become an effective consumer of financial information. Ready to take control of your finances? Whether you are saving for a house or retirement, struggling with your yearly taxes, or wondering if you should invest your stocks and bonds, there are many questions when it comes to personal finances.

No sessions available
5-12 Weeks
Excel avanzado: importación y análisis de datos (edX) EdX
Universitat Politècnica de València,UPValenciaX

Excel avanzado: importación y análisis de datos (edX)

Conoce técnicas y estrategias avanzadas para importar, consolidar y visualizar con Excel datos provenientes de cualquier fuente. En este curso de análisis e interpretación de datos te presentaremos técnicas avanzadas de importación de datos y estrategias diversas para consolidarlos y prepararlos una vez importados de forma que puedas extraer las conclusiones que necesitas (basadas en nuestra experiencia en el uso de Microsoft Excel y demostradas con casos reales).

Self Paced
Self-Paced
Herramientas ofimáticas básicas para el trabajo (Coursera) Coursera
UBITS

Herramientas ofimáticas básicas para el trabajo (Coursera)

En la actualidad, saber manejar herramientas ofimáticas básicas tales como procesadores de texto, procesadores de datos, correo electrónico y aplicaciones de videollamada es un requisito indispensable para tener éxito en el mundo laboral. Este tipo de herramientas permiten simplificar, agilizar y perfeccionar la comunicación y el manejo de la información en cualquier campo.

Dec 7th 2026
13-24 Weeks
Google Sheets - Advanced Topics (Coursera) Coursera
Google Cloud

Google Sheets - Advanced Topics (Coursera)

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet.

Dec 14th 2026
1 Week
Machine learning with Python for finance professionals (edX) EdX
ACCA

Machine learning with Python for finance professionals (edX)

A machine learning course focused on delivering practical Python skills for finance professionals looking to maximise their use of these time-saving tools within their organisation. Welcome to Machine learning with Python for finance professionals, provided by ACCA (Association of Chartered Certified Accountants), the global body for professional accountants. This course is part of the FinTech for finance and business leaders professional certificate program.

Self Paced
Self-Paced
Data Processing and Analysis with Excel (edX) EdX
Rochester Institute of Technology,RITx

Data Processing and Analysis with Excel (edX)

Learn to use Excel to organize and clean data so it can be manipulated and analyzed. In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and anomalies in the data, and how to identify and change data-types. Together we will develop a data analysis plan, after which we will apply analysis methods and tools, including exploratory analysis, evaluation of results, and comparison with other findings.

Self Paced
Self-Paced
Excel: fundamentos y herramientas (edX) EdX
Universitat Politècnica de València,UPValenciaX

Excel: fundamentos y herramientas (edX)

En este curso de Excel aprenderás las herramientas más habituales, desde lo más básico a los gráficos, formulas, funciones y tablas de datos. Conoceras cómo beneficiarte de las capacidades de este programa de Microsoft. Este es un curso de Excel basico en el que aprenderas a trabajar con este programa informatico de Microsoft, el componente para hojas de cálculo de la suite ofimática de Microsoft, MS-Office.

Self Paced
Self-Paced
Análisis de datos: Llévalo al MAX() (edX) EdX
Delft University of Technology,DelftX

Análisis de datos: Llévalo al MAX() (edX)

Incrementa tus habilidades de análisis de datos utilizando hojas de cálculo y visualización de datos en Excel. Aumenta tu productividad y produce mejores decisiones de negocio. Este curso de análisis de datos (business intelligence: BI) y estadísticas es para todos aquellos que quieren mejorar sus habilidades en el análisis de datos. ¿Buscas una forma inteligente de visualizar los datos para que tengan sentido? ¿Quieres entender esa colección de datos loca que te dio tu jefe? ¿Tienes Megabytes de sensores de datos para analizar? ¡No te preocupes, lo tenemos cubierto!

Self Paced
Self-Paced
Excel: Gestión de datos (edX) EdX
Universitat Politècnica de València,UPValenciaX

Excel: Gestión de datos (edX)

En este curso profundizarás en las herramientas para el tratamiento y manejo de datos que ofrece Excel. Este es un curso de nivel intermedio que te permitirá trabajar con datos para su tratamiento y extraer conclusiones mediante el agrupamiento de datos, el uso de tablas y gráficos dinámicos, la realización de análisis de hipótesis y la vinculación de datos de otras hojas de cálculo.

Self Paced
Self-Paced
Statistics and Data Analysis with Excel, Part 2 (Coursera) Coursera
University of Colorado Boulder

Statistics and Data Analysis with Excel, Part 2 (Coursera)

This course is meant to be a direct continuation of "Statistics and Data Analysis with Excel, Part 1." Therefore, it is not recommended to take Part 2 unless you've also taken Part 1. Building on the topics learned in Part 1 of the course (probability, probability mass and density functions, the normal and standard normal distributions), this course dives into a more applied side of statistics.

Dec 14th 2026
5-12 Weeks
A Comprehensive Excel Masterclass (Coursera) Coursera
Illinois Tech

A Comprehensive Excel Masterclass (Coursera)

The Comprehensive Excel Masterclass is an advanced course designed to empower students with the skills and knowledge needed to maximize the potential of Microsoft Excel in a business environment. This course goes beyond the basics and explores advanced functions, and features that will enable students to perform complex calculations, retrieve and manipulate data from multiple sources, and gain valuable insights from data. The course combines theoretical concepts with practical exercises and examples to reinforce learning.

Dec 7th 2026
4 Weeks
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data. This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Self Paced
Self-Paced