Microsoft Excel – Online Tutorial for Beginners

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

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

20 Responses

  1. Dear chandoo I have very Interesting question that you will take time to find the solution below is question
    I am Ajay and working in some travel agency and suddenly my boss gave me a job in excel question. Is below

    Suppose we give car for rent and slab is below
    4 hour 40 Km
    8 hour 80 Km
    Extra hour 15 rs
    And extra Km is 200

    Suppose a person go 4 hour and Km 70 in this scenario how we can calculate this do you have any answer of this I.eagrly waiting for this

    Thanks
    Ajay

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.