Microsoft Excel Course
This course will help you master Microsoft Excel, a critical and long-standing application for data processing in business and academia. Learning Excel is a valuable job skill that can give you a significant competitive advantage. The lessons focus on teaching you essential functions and advanced data analysis methods. You'll gain practical skills applicable to junior data officer roles and academic research. This course also provides a strong foundation for learning other in-demand Microsoft applications like Access and Power BI, positioning you as a strong candidate in the data sector.
Table of Contents
- 1
Getting Started
This lesson covers the absolute basics of Excel, from understanding the interface to using fundamental formulas and creating simple tables.
- 2
Using Logic and Manipulating Text
Learn how to make decisions in your spreadsheets with IF, AND, and OR functions. This lesson also covers essential functions for combining, cleaning, and splitting text.
- 3
Analyzing and Looking Up Data
This lesson introduces powerful functions for summarizing data based on conditions and for finding and retrieving data from tables.
- 4
Visualizing and Summarizing Data
Learn how to bring your data to life with charts and Sparklines, and master the basics of PivotTables for powerful, interactive data analysis.
- 5
Advanced Formulas, Automation, and Protection
Go beyond the basics by mastering flexible lookup functions like INDEX & MATCH, automating repetitive tasks with Macros, and learning how to protect your workbooks.
Continue Exploring
Discover more articles and projects
