We may earn an affiliate commission when you visit our partners.
Course image
Jaime Busquets and Víctor Braquehais Acero

This is an introductory course in which we will learn to work with Excel, the spreadsheet component of Microsoft's office suite, MS-Office.

This program allows us to perform all kinds of operations with data, being able to classify and handle large amounts of them; it incorporates a large number of functions and has great qualities to represent the results graphically.

We will start from 0 and explore the most used functionalities, such as formats, presentation of results, graphics, functions and data tables.

What's inside

Learning objectives

  • How to start working with excel and perform basic operations.
  • How to handle excel formats and how to present results
  • How to use excel charts
  • What families of functions are available in excel
  • How to handle data tables

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Builds a strong foundation for beginners
Develops professional skills
Strengthens an existing foundation for intermediate learners
Covers core skills for data science
Teaches skills, knowledge, and/or tools that are highly relevant in an academic setting
Provides hands-on labs and interactive materials

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Clear introduction to excel fundamentals

According to learners, this course is an excellent for true beginners, providing a solid foundation in essential Excel functionalities. Students consistently praise the instructor's ability to explain concepts clearly and at an easy-to-follow pace, making complex ideas digestible. The step-by-step demonstrations and practical exercises are highlighted as particularly effective, leading to an immediate and confident application of skills. While many find it a lifesaver for novices, a few experienced users note it might be a bit too basic or too slow and repetitive if you already have some Excel familiarity. Overall, it's highly recommended for those starting from scratch to master formats, functions, charts, and data tables.
Hands-on activities and examples reinforce learning.
"I particularly appreciated the step-by-step demonstrations and the practice exercises."
"The practical examples made learning enjoyable and immediately applicable."
"The hands-on practice really reinforced the concepts. No complaints whatsoever."
The instructor presents material with exceptional clarity.
"The instructor explains concepts clearly and at a pace that is easy to follow."
"The instructor's clear voice and detailed explanations made all the difference."
"The instructor breaks down complex ideas into simple, digestible pieces."
This course is highly effective for absolute beginners.
"This course is excellent for true beginners! I had zero Excel experience before and now feel confident..."
"Absolutely fantastic! The course took me from being completely lost in Excel to understanding core functionalities."
"As a complete novice, this course was a lifesaver. I can now confidently manage spreadsheets for budgeting."
May be too slow or basic for those with prior experience.
"For anyone with even a little prior knowledge, it might feel too slow and repetitive."
"Found this course quite basic. I already knew most of what was taught here from self-learning."
"While it does cover fundamentals, it's really for someone who has never opened Excel."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Excel: Fundamentals and tools with these activities:
Review Spreadsheet Basics
Brush up on the basics of spreadsheets to ensure a solid foundation for this course.
Browse courses on Spreadsheets
Show steps
  • Revisit basic spreadsheet terminology and concepts.
  • Experiment with different spreadsheet functions.
Excel Basic Operations Practice
Practice basic Excel operations to solidify foundational understanding.
Browse courses on Excel Basics
Show steps
  • Open Excel and create a new workbook.
  • Enter data into cells and perform basic calculations.
Excel Formatting Tutorial
Learn how to format Excel spreadsheets to improve readability and presentation.
Show steps
  • Watch a tutorial on Excel formatting.
  • Apply formatting options to a sample spreadsheet.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Excel Functions Practice
Enhance problem-solving skills by practicing the use of Excel functions.
Browse courses on Excel Functions
Show steps
  • Identify the appropriate function for a given task.
  • Construct formulas using the selected functions.
Excel Charting Tutorial
Gain a deeper understanding of Excel charting capabilities through guided instructions.
Browse courses on Excel Charts
Show steps
  • Follow an online or in-person tutorial on creating and customizing charts in Excel.
  • Apply the techniques learned to create charts for a mock data set.
Excel Formula Practice
Develop proficiency in using Excel formulas through repetitive exercises.
Show steps
  • Complete a series of exercises on common Excel formulas.
  • Create a spreadsheet that utilizes a variety of formulas.
Create Excel Chart Visualization
Demonstrate understanding of Excel charts by creating a visualization from a given dataset.
Browse courses on Excel Charts
Show steps
  • Gather data and import it into Excel.
  • Select the appropriate chart type.
  • Customize the chart to enhance readability.
Excel Q&A Discussion Group
Engage with peers to resolve questions, share knowledge, and enhance understanding.
Show steps
  • Join or create a discussion group focused on Excel.
  • Participate in discussions, ask questions, and provide answers.
Excel Data Table Analysis Report
Develop analytical skills by creating a report based on data manipulation using Excel data tables.
Show steps
  • Create a data table with relevant data.
  • Analyze the data using data table tools.
  • Summarize the findings in a written report.
Excel Data Analysis Project
Apply the skills learned to a practical project, reinforcing understanding and solidifying knowledge.
Show steps
  • Identify an appropriate data set for analysis.
  • Use Excel to clean, organize, and analyze the data.
  • Create visualizations and present findings based on the analysis.

Career center

Learners who complete Excel: Fundamentals and tools will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected 50 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel: Fundamentals and tools.
Seminal work on the grammar of graphics, a formal language for describing data visualizations. It covers a wide range of topics, from the basics of the grammar of graphics to the use of the grammar of graphics to create a variety of charts and graphs.
This classic book by Edward Tufte must-read for anyone interested in data visualization. It covers a wide range of topics, from the principles of visual perception to the design of effective charts and graphs.
Created by the original architect of pandas, this masterwork teaches the canonical data structures and vectorized operations essential for slicing, cleaning, merging, and reshaping complex tabular datasets in Python.
Presents the modern tidyverse grammar for transforming messy data into structured insights. Covers tibbles, dplyr pipelines, tidyr pivoting, and purrr iterations for rapid exploratory data manipulation.
More than just a basic Excel guide, this book focuses on applying Excel to real-world data analysis and business problems. It's ideal for those looking to deepen their understanding of using Excel for practical applications, including newer features like dynamic arrays and Power Query. is commonly used as a textbook and strong reference for business professionals.
Demystifies relational data transformation through practical PostgreSQL projects. Teaches window functions, subqueries, regular expressions, and cross-tabulations required to manipulate data directly inside the database.
Delivers a comprehensive, project-driven guide to wrangling messy timeseries, handling missing values, and restructuring dataframes with pandas. Emphasizes defensive coding and performance profiling for large analytical workloads.
Explores the mathematical and algorithmic techniques for transforming raw tabular data into predictive signals. Details numeric scaling, log transforms, categorical encoding, text vectorization, and automated feature extraction.
This practical guide is specifically tailored for those interested in financial modeling using Excel. It provides step-by-step instructions and focuses on applying Excel features to solve common business and financial problems. It's a valuable resource for students and professionals in finance and business roles looking to solidify their modeling skills.
Guides engineers through extracting, cleaning, and transforming irregular data from diverse formats including JSON, XML, PDF, and messy CSVs. Focuses on automation, error detection, and parsing web feeds reliably.
Focuses specifically on Power Query, a powerful tool within Excel and Power BI for connecting, transforming, and combining data from various sources. It's highly relevant for contemporary data analysis workflows and is essential for users who need to clean and prepare data efficiently before analysis. This book adds significant depth to data manipulation skills within Excel.
Combines financial analysis and modeling concepts with the application of Excel and VBA. It's a valuable resource for those in finance who want to leverage Excel's power for complex analysis and automation. It deepens understanding by integrating financial theory with practical Excel implementation.
Provides a deep, foundational look into R core data objects, subscripting mechanics, factor conversions, string manipulation, and reshaping vectors. Offers timeless clarity on base R data processing paradigms.
Offers a detailed look at Power Query, focusing on practical techniques for data collection, combination, and transformation. It's an essential resource for anyone dealing with messy data and provides valuable skills for efficient data preparation in Excel and Power BI. This book significantly deepens understanding of data wrangling.
Is highly recommended for those who want to master financial modeling in Excel. It simplifies complex financial concepts and provides in-depth techniques for building, developing, and deploying financial models. It's a valuable resource for finance professionals and students seeking to deepen their financial modeling expertise.
Provides a comprehensive overview of data visualization, covering the basics of visual perception, data types, and chart types. It great resource for beginners who want to learn the fundamentals of data visualization.
Comprehensive guide covering a vast range of Excel topics from beginner to advanced levels. It's an excellent resource for gaining a broad understanding of Excel's capabilities and serves as a valuable reference tool for various functions, formulas, and features. While published in 2018, its foundational content remains highly relevant for solidifying core Excel skills.
Provides a comprehensive overview of data tables in R, including data manipulation, visualization, and analysis techniques. It is particularly relevant for learners and students who are interested in using R for data analysis.
Considered a classic in financial modeling, this book focuses entirely on using Excel to implement financial models. It's a thorough resource for those seeking a deep understanding of financial modeling principles and their practical application in Excel, drawing on real-world company data.
Lays out a systematic workflow for profiling, assessing, and structuring untidy business data. Connects data preparation directly to downstream analytics, preventing upstream bias and data transformation bottlenecks.
Focuses on modern data analysis techniques within Excel, including Power Query and Power Pivot. It's a contemporary resource for users looking to update their data cleaning and reporting processes and perform more rigorous data analysis directly within Excel. It's highly relevant for professionals working with data regularly.
Delivers fast, battle-tested techniques for cleaning and pivoting irregular spreadsheet exports. Shows how to master Power Query, dynamic arrays, and nested lookups to clean corporate datasets with surgical speed.
A comprehensive guide specifically for Excel 365, covering its features and capabilities. Similar to the Excel 2019 Bible, this book offers broad coverage and serves as a valuable reference for users of the subscription-based version of Excel, ensuring relevance to the latest updates.
Presents a proactive architectural framework for monitoring data pipelines and catching silent transformation bugs. Teaches automated anomaly detection, schema drift prevention, and lineage tracking for robust data operations.
Exposes the most widespread and damaging traps in relational data manipulation and query construction. Illustrates how to avoid Cartesian explosion, improper NULL comparisons, and flawed table structures with cleaner SQL alternatives.
This handbook provides a solid foundation in financial modeling concepts and their implementation, often using Excel as a tool. It's a good resource for those who want to understand the theory behind financial models while also learning how to build them practically. It's suitable for both students and professionals.
Collects cautionary case studies from seasoned data practitioners detailing how hidden encoding bugs, missing fields, schema mismatches, and parsing failures occur, with concrete recipes for defensive data hygiene.
Introduces high-performance dataframe processing using Polars and Apache Arrow memory layout. Demonstrates lazy evaluation, query optimization, and multicore parallel execution for multiterabyte data manipulation in Python.
Explores advanced in-process analytical querying and columnar data manipulation using DuckDB. Teaches students how to construct complex analytical pipelines, process multiterabyte Parquet tables locally, and embed SQL transformations into Python.
An updated guide to VBA and macros in the latest Excel versions, this book strong resource for automating tasks and extending Excel's functionality. It's suitable for users who want to move beyond basic formula and function usage and into more powerful automation.
Covers distributed data transformation patterns across large compute clusters using Apache Spark. Explains DataFrame and Dataset operations, resilient distributed transformations, and partitioning optimization.
Explores modern columnar in-process analytical SQL transformations using DuckDB. Teaches students how to manipulate large Parquet and CSV files with lightning-fast vectorized execution directly from Python and R environments.
Provides a comprehensive introduction to deep learning, covering topics such as neural networks, convolutional neural networks, and recurrent neural networks. It is suitable for students with a strong background in mathematics and computer science.
Covers advanced data analysis techniques in R, including data tables, machine learning, and text mining. It is appropriate for experienced data analysts who wish to enhance their skills and knowledge.
Provides a comprehensive introduction to artificial intelligence, covering topics such as machine learning, natural language processing, and computer vision. It is suitable for students with a strong background in mathematics and computer science.
Provides a comprehensive introduction to partial differential equations, covering topics such as the heat equation, the wave equation, and the Laplace equation. It is suitable for students with a strong background in calculus and linear algebra.
Provides a comprehensive introduction to machine learning, covering topics such as supervised learning, unsupervised learning, and reinforcement learning. It is suitable for students with a strong background in mathematics and computer science.
While not solely an Excel book, 'Data Smart' must-read for anyone in data analysis. It provides a comprehensive guide to using data analysis techniques and tools, including how Excel can be used in real-world scenarios. It helps contextualize Excel within the broader field of data science and is valuable for both beginners and experienced professionals.
Systematizes data preparation for statistical analysis in R, emphasizing string manipulations with stringr, date transformations with lubridate, and automated web scraping for data ingestion.
A concise and practical guide for absolute beginners, this book introduces the basic interface, creating worksheets, using simple formulas, and basic data manipulation. It's an excellent starting point for those with no prior Excel experience and helps build foundational knowledge.
Supplies rapid, practical recipes for migrating pandas workflows to blazing-fast Polars pipelines. Walks through streaming chunk processing, complex string parsing, and timeseries window calculations with minimal RAM overhead.
Provides a concise, pragmatic reference for modern ELT data ingestion and transformation patterns. Covers incremental loading, surrogate key generation, data staging hygiene, and orchestrating batch transformations reliably.
Introduces interactive visual data manipulation, table restructuring, recoding variables, and outlier detection within statistical workflows. Bridges raw data entry with exploratory data mining.
Provides a rigorous mathematical treatment of rule-based data validation, deductive imputation, and error localization. Outlines systematic methodologies for certifying data quality before modeling.
A guide aimed at quickly improving Excel skills from beginner to advanced, covering recent features and practical data analysis techniques. is useful for those seeking an up-to-date resource with a focus on practical application and a faster learning curve.
Serves as the foundational architectural reference for large-scale data storage and batch processing. Explains the mechanics of HDFS, MapReduce record transformations, serialization formats, and distributed file handling.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Excel: Fundamentals and tools.
Principal Component Analysis with NumPy
Most relevant
Google Sheets - The Comprehensive Masterclass
Most relevant
Excel Basics for Data Analysis
Most relevant
Tableau Fundamentals
Most relevant
Excel Data Analysis and DAX Essentials Course
Most relevant
Preparing for the SAS Programming Certification Exam
Most relevant
Get, Shape, Combine and Merge the datasets using Power BI
Most relevant
Pivot Tables in Google Sheets
Most relevant
Python for Excel: Use xlwings for Data Science and Finance
Most relevant

edX Buyer Protection & Guarantee

Verified partner policies & purchase protections

World-Class University Partner
Free Trial & Audit

Free Audit Track Available

Free audit track available for most courses, giving open access to video lectures, course readings, and assignments at no charge.

Return & Refund Policy

14-Day Full Refund Window

14-day full refund available up to 14 days after course start or 14 days after payment (whichever comes second, up to 6 months max), provided verified certificate has not yet been earned.

Buyer Protections

Verified Academic & Industry Partner

University-backed credentials authored by elite institutions like Harvard, MIT, and Oxford, with tamper-proof certificate verification.

Key Purchase Protections
Free audit track for open learning access
14-day money-back guarantee on verified certificates
Prestigious university credentials (Harvard, MIT)
Automatic unenrollment refund process via dashboard
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser