MS Excel: Beginner's Guide

Here I have discussed about for what purpose MS Excel can be used and how it can be used for simple usage. I have made 5 videos to explain basic features of MS Excel for beginners.

First video talks about representation of data in a table format and how it is useful. Don’t worry about thinking what is a Table, watch this video, hopefully it will answer some of your questions like,

1. What is a table
2. How to put data in a table format using MS Excel
3. Why we have to use table format to represent data
4. How to manage MS Excel file like open, close, Save
5. What is a worksheet in MS Excel

Second video discuss about how data entered in a table format can be formatted to make it look more pleasing and convey more information

Following data formatting is explained in this video

1. Changing font style, size
2. How to give background color

Third video discuss about how to do sorting in MS excel with one example

Forth video discuss about how arithmetic operations like SUM, COUNT, Percentage can be performed in MS excel with one example

Fifth video talks about basic types of Graphs and charts and how it can be used in MS Excel to display data in a visual format

1. Pie chart
2. Bar graph
3. Line Chart