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  Resources http://chandoo.org