Take your first steps in Excel! Learn how to open Excel files, copy and paste data, and write your first Excel formula.

Introduction to Excel

Options

Possible using Excel

Not possible using Excel

The possibilities of Excel

Navigating Excel

Loading workbooks

Working with data

Creating your first formula

Getting started with Excel

Excel mainly is a data analysis tool. In this chapter, you'll get to apply basic formulae to summarize data. Additionally, you’ll learn how to create your first bar and line charts. 

Aggregate and arithmetic operations

Averaging stock prizes

Counting the days

Visualizing data in Excel

Visualizing categories

Capturing a trend

Data Analysis in Excel

Exercises and Datasets

Excel Formula Translations

New to Microsoft Excel? In this beginner course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. The course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to use formulas in your data to provide new insights, and you'll create your first charts!


Master Excel basics quickly: navigate spreadsheets, apply formulas, analyze data, and create your first charts!

Excel | Master The Basics

Understanding Excel

Create charts like scatter plots and bar charts

The possibilities of Excel

Understanding Excel

Latihan interaktif praktis