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
- 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
Save this course
Save
Activities
Review Spreadsheet Basics
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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.
Review Spreadsheet Basics
Show steps
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
Show steps
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
Show steps
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.
Excel Functions Practice
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Reading list
Share
Similar courses
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.
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.
