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.

Read more

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.

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

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

Good to know

Know what's good
, what to watch for
, 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

Save Excel: Fundamentals and tools to your list so you can find it easily later:
Save

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 haven't picked any books for this reading list yet.

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.
Introduction to Microsoft Excel
Most relevant
How to use Custom and Conditional Formatting in Excel
Most relevant
Excel 2019 Pro
Most relevant
Complete Guide to Programming Automation with R and...
Most relevant
Data Processing and Analysis with Excel
Most relevant
Combining and Filtering Data with PostgreSQL 9
Most relevant
Mastering Data Analysis in Excel
Most relevant
A Comprehensive Excel Masterclass
Most relevant
Create a Mortgage Calculator in Excel
Most relevant
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 - 2024 OpenCourser