Microsoft Excel – Online Tutorial for Beginners

Welcome to Chandoo.org. This is a basic tutorial on Excel for beginners. Start with the first video and practice as you go along. Follow the links for more information and help.

Introduction to Microsoft Excel

Formatting Data in Excel – Basics

In this tutorial,

  • What is Excel ?
  • Why is it used ?
  • Creating your first excel file
  • Using Ribbon, Understanding what each tab does

Watch now

In this tutorial,

  • Using fonts
  • Using colors
  • Applying Cell Borders
  • Aligning Text, wrapping text
  • more…

Watch now

How to Make a Chart in Excel?

Writing Simple Formulas in Excel

In this tutorial,

  • What is a Chart?
  • Creating a simple chart
  • Formatting a chart
  • Changing chart types

Watch now

In this tutorial,

  • What is a formula
  • Writing simple SUM formulas
  • IF and Else formula
  • Count of values
  • Sum of values meeting a criteria

Watch now

Introduction Conditional Formatting in Excel

Introduction to Excel Tables

In this tutorial,

  • What is Conditional Formatting?
  • Applying simple conditional formatting rules
  • Using predefined CF rules
  • Using Formulas in CF

Watch now

In this tutorial,

  • What is a table
  • Why use tables
  • Applying table styles
  • Sorting, filtering data in tables
  • Charts and tables
  • Formulas and tables

Watch now

Introduction to Excel Pivot Tables

Using Excel Productively – Keyboard Shortcuts

In this tutorial,

  • What is a pivot table?
  • How to create a pivot table?
  • Working with pivots – changing orientation, adding filters
  • Formatting pivots

Watch now

In this tutorial,

  • Navigation Shortcuts
  • Selection Shortcuts
  • Using Function keys
  • Using ALT keys for menus
  • Using CTRL keys

Watch now

Printing Your Workbooks

10 Things you can do in Excel under 10 Minutes

In this tutorial,

  • Using Page Setup
  • Setting Margins
  • Print on one sheet
  • Repeating Rows on Top
  • Adding Headers / Footers

Watch now

In this tutorial,

  • Auto sum a bunch of values
  • Save excel file as PDF
  • Insert an organization chart
  • Insert Euro Symbol or other symbols
  • moreā€¦

Watch now